Year End Checklists for Sage 100
Here are year end closing checklists for General Ledger, Accounts Receivable and Accounts Payable to help ensure that all tasks are processed and in the proper order.
Note: these modules all begin with the following 2 steps:
1. Backup your AR/AP/GL files and label them as “prior” to Year End processing.
2. Make sure the AR/AP/GL system date is set to the last day of your fiscal year.
3. Ensure all invoices and cash receipts have been recorded for the current year.
4. Apply finance charges to past due customers.
5. Note: If you answered “None” for “Finance Charge Computation Method” in A/R Set Up Options, then continue.
6. Print statements for the appropriate customers.
7. Note: If you did not activate the “Customer Statements” option in A/R Set Up Options, continue to the next step.
8. Select “Period End Processing” from the Period End menu, and choose the Full Period & YE Processing option.
9. Select the reports you wish to print for the period. At minimum, we recommend Aged Invoice Report and A/R Trial Balance.
10. Complete year end processing, backup AR files, and label them as “after” YE processing.
3. Ensure all invoices and checks have been entered and updated for the current year.
4. If your fiscal year coincides with the calendar year and your company issues 1099 Forms for vendors, then print, verify, and clear the 1099 Forms.
5. Select “Period End Processing” from the Period End menu, and choose the Full Period & YE Processing option.
6. Select the reports you wish to print for the period. At minimum, we recommend Aged Invoice Report, A/P Trial Balance, and Check History Report.
7. Complete year end processing, backup AR files and label them as “after” YE processing.
3. Make sure all activity and adjustments in modules integrated with General Ledger have been completed in the year to be closed. Note: Check the Module Closing Order article elsewhere on this website.
4. Print and update the Recurring Journals. Refer to the Recurring Journal section on page 99 of the GL Manual.
5. Print the General Ledger Worksheet and log all essential adjustments.
6. Enter adjustments in General Journal Entry. This includes entries logged on the General Ledger Worksheet (above).
7. Print and update the Daily Transaction Register.
8. Note: The system will not allow YE processing to continue until after this step is performed.
9. Enter budget revisions through Budget Revision Entry and update the Budget Revision Register.
10. Go to G/L Options, confirm proper settings for these fields:
11. Auto Budget Option field is set to the option you want to create next years’ budget
12. Number of Years to Retain in Transaction History
13. Number of Years to Retain in Summary History
14. Note: Setting number of years to “1” will not retain history - 1 means current year only.
15. Make sure the Balance Sheet is in balance.
16. Print the General Ledger Analysis (not “required”)
17. Update & print Custom Financial Reports (not “required”)
18. Select, modify, and update the Allocation Journal.
19. Select Period End Processing, and choose the Full Period End Processing option.
20. Select the reports you wish to print for the period. At minimum, we recommend Trial Balance, Standard Financial Statements, and General Ledger Detail Report.
21. Complete period end processing, backup general ledger files, and label them as “after” YE processing.
TIP: Year end checklists for all modules can be viewed onscreen and are accessible from the Sage 100 Help section of the software.
©2015 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.©2015 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.
Note: these modules all begin with the following 2 steps:
1. Backup your AR/AP/GL files and label them as “prior” to Year End processing.
2. Make sure the AR/AP/GL system date is set to the last day of your fiscal year.
Accounts Receivable
3. Ensure all invoices and cash receipts have been recorded for the current year.
4. Apply finance charges to past due customers.
5. Note: If you answered “None” for “Finance Charge Computation Method” in A/R Set Up Options, then continue.
6. Print statements for the appropriate customers.
7. Note: If you did not activate the “Customer Statements” option in A/R Set Up Options, continue to the next step.
8. Select “Period End Processing” from the Period End menu, and choose the Full Period & YE Processing option.
9. Select the reports you wish to print for the period. At minimum, we recommend Aged Invoice Report and A/R Trial Balance.
10. Complete year end processing, backup AR files, and label them as “after” YE processing.
Accounts Payable
3. Ensure all invoices and checks have been entered and updated for the current year.
4. If your fiscal year coincides with the calendar year and your company issues 1099 Forms for vendors, then print, verify, and clear the 1099 Forms.
5. Select “Period End Processing” from the Period End menu, and choose the Full Period & YE Processing option.
6. Select the reports you wish to print for the period. At minimum, we recommend Aged Invoice Report, A/P Trial Balance, and Check History Report.
7. Complete year end processing, backup AR files and label them as “after” YE processing.
General Ledger
3. Make sure all activity and adjustments in modules integrated with General Ledger have been completed in the year to be closed. Note: Check the Module Closing Order article elsewhere on this website.
4. Print and update the Recurring Journals. Refer to the Recurring Journal section on page 99 of the GL Manual.
5. Print the General Ledger Worksheet and log all essential adjustments.
6. Enter adjustments in General Journal Entry. This includes entries logged on the General Ledger Worksheet (above).
7. Print and update the Daily Transaction Register.
8. Note: The system will not allow YE processing to continue until after this step is performed.
9. Enter budget revisions through Budget Revision Entry and update the Budget Revision Register.
10. Go to G/L Options, confirm proper settings for these fields:
11. Auto Budget Option field is set to the option you want to create next years’ budget
12. Number of Years to Retain in Transaction History
13. Number of Years to Retain in Summary History
14. Note: Setting number of years to “1” will not retain history - 1 means current year only.
15. Make sure the Balance Sheet is in balance.
16. Print the General Ledger Analysis (not “required”)
17. Update & print Custom Financial Reports (not “required”)
18. Select, modify, and update the Allocation Journal.
19. Select Period End Processing, and choose the Full Period End Processing option.
20. Select the reports you wish to print for the period. At minimum, we recommend Trial Balance, Standard Financial Statements, and General Ledger Detail Report.
21. Complete period end processing, backup general ledger files, and label them as “after” YE processing.
Get All the Checklists
TIP: Year end checklists for all modules can be viewed onscreen and are accessible from the Sage 100 Help section of the software.
©2015 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.©2015 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.
Tags: Sage 100 ERP Year End
