Step 1: Setup General Ledger Options in Sage 500
Head over to the Sage 500 ERP General Ledger Maintenance menu and select GL Setup/Set Up Options, and verify the settings on the following tabs:
- Clear the Non-Financial Accounts at Year End – Select this option to clear non-financial account balances for the next fiscal year (only applies to accounts with a Non-Financial account group, this option has no effect on statistical data.) If you do not select this option all non-financial account balances will be carried over to the next fiscal year.
- Default Budget – Select a Default Budget to use for reporting purposes. If you select Copy Budget as the Year-End Copy option your budget will be updated during year end processing.
- Year End Copy – Select to copy budget figures, or the current year’s actual figure, to the budget specified in the Default Budget option. Select None if you do not require a budget copy at year-end. *Note: Depending on the size of the Chart of Accounts, selecting this option may cause the Year End closing process to take a great deal longer than a standard period-end process.
- Copy Budget – Select the budget used to update the figures for the budget specified in the Default Budget option during year-end processing. This field is disabled if None or Copy Actual is specified for the Year End Copy option.
- Retained Earnings Account – Verify that the correct Retained Earnings Account is specified.
- Number of Years to Track Periodic GL History – Select the numbers of years you wish to keep transaction summary and account history in the General Ledger. If the purge option is selected when you close the fiscal year in Process Period End, Sage 500 ERP data older than the specified period will be purged at year-end and summarized by account and date.
- Number of Years to Keep Trans History Detail - Select the number of years you wish to keep transaction detail in the General Ledger. Sage 500 Data older than this is summarized by date at year-end and is unavailable for reports.
WARNING: Periodic GL history enables you to print financial statements and budgets from historical data. Transaction history allows you to print detailed transaction reports from history. Both account history and transaction history may be purged and therefore render the data unavailable based on the setup of these options. See the 'Default Auto Purge' section for additional information on setting purge options.
Financial Terms Tab
- Review the terms used and change as needed for financial reporting purposes.
Step 2: Closing the Year in Sage 500 ERP
- Print Period End Reports
- Purge General Ledger Data
- Close the Fiscal Year
Year End Processing is automatically performed when the Current Period specified in Sage 500 Set Up GL Options is set to the last period of the current fiscal year. Here is a guideline for closing the fiscal year.
1. Complete Posting, Adjusting, and Closing Procedures for all subsidiary modules.
2. Backup the Sage 500 ERP application and system databases.
3. Complete posting of all GL pending batches, recurring transactions, and adjusting entries in Process Journal
Transactions using an appropriate posting date.
4. Print the Year End reports required by your accountant or bookkeeper.
5. Verify that the applicable GL account balances match the month-end report balances in modules such as AP, AP,
6. Make any necessary adjustments to the General Ledger.
7. If needed, re-print any Year End reports.
8. Print the final Financial Statements and verify that they balance.
9. Backup the Sage 500 ERP application and system database.
10. Complete Year End processing by selecting the Process Period End task from the GL Activities menu. The
following options are available:
- Print Period End Reports, optional - To select which reports to print, use the Select Reports option and select your desired reports. To further customize the reports you can select the individual report from the GL Reports menu and create a Saved Setting, follow these steps:
- Make the required changes to the sort and selection criteria, and print options.
- Save the report setting and name it Period End. These report settings are used when printing reports during
Period End or Year End processing.
- Purge GL Data, optional - If the purge data flag is set, the purge occurs before the period is incremented. The purge process uses the parameters configured in the Set Up GL Options task and removes data accordingly. *Sage does not recommend selecting this option during year-end, as it may cause the year end close to take a great deal longer to process.
- Close Period X-YYYY ending on MM/DD/YY – This option if activated only if the period selected in the header is the oldest open period; otherwise, this option is disabled. This option should be selected after all the steps stated above have been completed and account balances are finalized for the year. *Note: A period cannot be closed in the General Ledger if that period is still open in any subsidiary module. A warning will display that the suspense account has a balance or if any unposted GL batches have a posting date prior to the period being closed.
Year and Current Period will be incremented in GL Options. The Status in GL Setup Fiscal Calendar for the period
being closed will be set to "Closed".
12. Backup the Sage 500 ERP application and system database.
13. Adjust budget figures for the New Year as necessary.
14. Print the new period's financial statements and verify
- Balance Sheet accounts have the appropriate beginning balances.
- Retained Earnings is correct.
- Beginning balances for the Income Statement accounts are 0.00.
15. Make a backup of all company data and place it in safe permanent storage. This will serve as the permanent
record of your company's financial position at the end of the year, which can be later restored if necessary.
Step 3: Additional Information in Sage 500
- Depreciation/Amortization expense is calculated and booked.
- Loss Provisions are made to applicable accounts.
- Recurring journal entries are noted.
- Allowance is made for Doubtful Accounts.
- Inventory is adjusted to physical counts and analyzed for obsolescence.
- Income and expenses are accrued, as necessary.
- Deferred Income is recorded.
- Correction of any errors in prior postings.
- See your accountant or bookkeeper for further information regarding adjustments.
- Year End processing and Period End processing are essentially identical. The most significant difference is that Year End processing generates the new Budget for the following year.
- Transactions can be posted only to "open" periods. Any closed periods can be reopened through Set Up Fiscal Calendar. However, after a period is "reopened", that period and all future periods must be reclosed. Any transactions posted to a prior period change the related reports and financial statements, so the ability to "open" a closed period should be subject to management approval.
Step 4: Default Auto Purge in Sage 500
The list below shows the preset or default automatic data purges for individual modules. Sage recommends you change the purge value fields in the Set Up (xx) Options task for each registered module to 999.
*Note: (xx) = module abbreviations.
- Common Information (CI)
- Sales Tax History: 5 Years
- General Ledger (GL)
- Accounts Payable (AP)
- Vendor data: 5 Years
- Accounts Receivable (AR)
- History retained by year: 5 Years
- Multicurrency (MC)
- Cash Management (CM)
- Bank Transactions: 24 Months
- Bank Statements: 24 Months
- Purchase Orders (PO)
- Requisitions: 24 Months
- Receivers: 24 Months
- Inventory Management (IM)
- Purchase Product Line: 5 Years
- Lot/Serial Transactions: 5 Years
- Inventory Transactions: 24 Months
- Outdated Prices: 24 Months
- Inactive Item: 4 Months
- Sales Order (SO)
- Shipments: 24 Months
- Quotes: 6 Months
- Sales Analysis History: 5 Years
Go to Set Up Options in each module and reset the purge fields to 999.
*Note: If the data MUST be purged, contact your SQL data base administrator or your Sage business partner for assistance.
Need Sage 500 Support, Training or Year End Closing Assistance?
Please feel free to share it with your friends and colleagues on Twitter or Facebook!