# Sage 100 Year-End Close Checklist > Source: https://netray.co/tools/sage-100-year-end-close-checklist > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Step-by-step year-end list for Sage 100 2022 to 2025: what to back up, which reports to keep, how to handle 1099s and the order to close each module. ## Category other-erp ## Erp Sage 100 ## Audience - Controller - Sage 100 administrator - Accounting manager ## Tool **Kind:** checklist **Groups:** #### 1. Before you start **Items:** **Text:** Install the latest product update for your Sage 100 version and the year-end tax updates for Payroll and 1099 forms if you use them **Critical:** true **Text:** Take a full backup of the MAS90 folder including every MAS_XXX company folder (Premium: also back up the SQL Server company databases) and test that it opens **Critical:** true Get all users out of the company; check Master Console for remaining sessions and stop scheduled VI jobs Print or save to PDF the year-end reports you must keep: aged reports, inventory valuation, trial balance, registers Confirm the current fiscal and calendar year settings in Company Maintenance and each module's setup options **Text:** Agree the module closing order with the team before anyone runs Period End Processing **Critical:** true #### 2. Sales Order, Purchase Order, Inventory and BOM **Items:** Complete the physical count and post the Physical Count Variance register Print the Inventory Valuation and Trial Balance reports and reconcile inventory to the GL Post all Sales Order and Purchase Order registers (receipts, returns, invoices) Run Sales Order and Purchase Order Period End Processing before Inventory Management Purge completed orders only as set in module options; keep history you need for audit Run Inventory Management Period End Processing for year end #### 3. Accounts Receivable **Items:** Post all invoice, cash receipts and finance charge registers; nothing left unposted Run the Aged Invoice Report and Trial Balance and reconcile AR control to the GL account Review Customer Sales History and purge options in Accounts Receivable Options before closing **Text:** Run Accounts Receivable > Period End > Period End Processing and choose End of Year for the fiscal year end **Critical:** true Keep the period end reports printed during processing with the year-end file #### 4. Accounts Payable and 1099s **Items:** Post all invoice, manual check and check registers Run the Aged Invoice Report and reconcile AP control to the GL Review 1099 data for every 1099 vendor (TIN, form type, box amounts) and correct it before printing **Text:** Print 1099 forms or file electronically through Aatrix from the 1099 tasks in Accounts Payable **Critical:** true **Text:** Confirm in your version's help whether AP year end affects 1099 data before closing; do not close AP until 1099s are final unless you have confirmed it is safe **Critical:** true Run Accounts Payable > Period End > Period End Processing for the year end #### 5. Bank Reconciliation **Items:** Enter and post all deposits, checks and adjustments for the year Reconcile each bank account to the last statement of the year **Text:** Compare the calculated book balance with the GL cash account balance and resolve differences **Critical:** true Print or save the reconciliation reports for each bank account and keep them with the year-end file #### 6. General Ledger (last) **Items:** **Text:** Confirm every subsidiary module has posted to GL for the year; post any open journals **Critical:** true Run the Trial Balance and financial reports and save them to PDF Post adjusting and auditor entries in the final period **Text:** Back up again before GL year end **Critical:** true Run General Ledger > Period End > Period End Processing for year end; retained earnings is closed to the retained earnings account Check the opening balances of the new year and the closing to retained earnings Enter or copy budgets for the new fiscal year **Scoring Note:** Critical items are the ones that cannot be undone without restoring a backup: backups, closing order, 1099 finalisation and cash reconciliation. ## Content **Intro:** This checklist walks through a Sage 100 fiscal and calendar year end for versions 2022 to 2025, from backups and updates through each module's Period End Processing. The rule that drives the order is simple: close subsidiary modules before General Ledger. **Sections:** #### How to use it **Body:** Work top to bottom and tick items as you go; export the ticked list to PDF and keep it with the year-end file. Run it in the company's real calendar: the fiscal year end and the calendar year end are separate events if your fiscal year does not end in December, and 1099s always follow the calendar year. Items marked critical are the ones you cannot reverse without restoring a backup. If several people close modules, give each module an owner and a time slot so nobody runs Period End Processing out of order. #### Module order **Body:** Sage 100 posts from subsidiary modules into General Ledger, so the subledgers must be finished first. A common order is Sales Order and Purchase Order, then Inventory Management, then Accounts Receivable and Accounts Payable, then Bank Reconciliation checks, and General Ledger last. Your exact list depends on installed modules (Bill of Materials, Work Order, Payroll); check the Period End Processing help for each one. Closing GL early forces later postings into the new year or into a closed period, which is the most common year-end mistake. **Bullets:** - Distribution modules before Inventory Management. - AR and AP before GL. - General Ledger always last. #### Worked example: December calendar, June fiscal year **Body:** A company with a June fiscal year runs the full checklist in July. In January it runs only the calendar items: install the year-end updates, review 1099 data, print and e-file 1099s, and process payroll year-end forms if Sage 100 Payroll is used. It does not run AP or GL year end in January. Keeping the two events separate avoids clearing data that one of them still needs. #### Gotchas **Body:** Back up before each irreversible step, not only once at the start. Purge options set years ago can delete history auditors ask for, so read module options before processing. On Premium, back up the SQL databases, not only the MAS90 folder. Running Period End while a user is still in the module can fail or leave locks; use Master Console first. After year end, check that the current fiscal year in GL moved forward before staff start posting. **Cta:** If you want controllers to ask Sage 100 for year-end balances and reconciling items in plain English on your own servers, we can set that up. **Faq:** #### In what order should I close modules in Sage 100? **Answer:** Close subsidiary modules before General Ledger. A common order is Sales Order and Purchase Order, then Inventory Management, then Accounts Receivable and Accounts Payable, with Bank Reconciliation reconciled before General Ledger, which always closes last. Check the help for each installed module, such as Bill of Materials, Work Order or Payroll, for its position. #### Should I print 1099s before AP year end in Sage 100? **Answer:** Yes, that is the safe rule: review 1099 data, print or e-file the forms, then run AP year end. Some versions keep 1099 history by calendar year, but confirm it in your version's help before relying on it. 1099s follow the calendar year even if your fiscal year ends in another month. #### How do I back up Sage 100 before year end? **Answer:** With all users out, copy the whole MAS90 folder, including every MAS_XXX company folder, to separate storage, or use your server backup if it captures the folder consistently. For Sage 100 Premium, also take SQL Server backups of the company databases. Then restore the backup somewhere else and open it to prove it works. #### What is the calculated book balance in Bank Reconciliation? **Answer:** It is the balance Bank Reconciliation derives for the bank account from the statement balance and the outstanding checks, deposits and adjustments. At year end it should match the GL cash account. A difference means something was posted to cash in GL without a matching bank entry, or the reverse, and it should be resolved before GL year end. ## Search terms sage 100 year end checklist, sage 100 how to close the year, sage 100 year end closing procedures, sage 100 period end processing, sage 100 form 1099 filing and reporting, sage 100 how to backup, sage 100 calculated book balance --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json