Sage 300 Period End Checklist
A repeatable close is mostly sequence: post subledgers, run day end, reconcile to the ledger, then lock. This checklist follows the Sage 300 module order so accounting teams stop forgetting the same two steps every month.
0 of 36 items complete
16 critical items still open - these are the highest-risk gaps.
Before you start
Accounts Payable
Accounts Receivable
Inventory, order entry and purchasing
Bank and general ledger
Close and report
Do not lock the period until every critical item is done. Keep the signed list with the month end file.
Automate my month end checks
Optional: we can discuss turning your reconciliation steps into scheduled, read-only reports.
Optional. The tool and every export work without this. No spam.
How to use the checklist
Print or export a fresh copy each period and work top to bottom. Assign each group to an owner, tick items as they are completed and note the date. The critical items are the ones that most often cause an out-of-balance condition or force a reopening of the period. If your company uses only some modules, strike out the groups you do not use and keep the remainder as your own standard.
Why the order matters
Subledgers feed the general ledger, and day end processing in the operational modules creates the GL transactions that you then reconcile. Inventory depends on receipts and shipments being invoiced or accrued, which depend on purchasing and order entry. Reconcile each subledger to its control account before touching the ledger close, because differences found late are much harder to trace. Lock the period only after the trial balance review.
- Post and run day end in the subledgers first
- Reconcile each subledger to its control account
- Accrue received-not-invoiced and shipped-not-invoiced
- Lock periods last
Common mistakes
Frequent issues are leaving batches unposted, forgetting day end processing in one module, entering back-dated transactions after the period is locked, and letting inventory and GL drift because adjustments were posted in the wrong period. Another is skipping bank reconciliation until the following month. Confirm exact screen names and options in your version of Sage 300, since menus differ between releases.
Frequently Asked Questions
What is day end processing in Sage 300?
It is the process in several modules, such as accounts receivable, accounts payable and inventory control, that creates the general ledger transactions from posted subledger activity. If it is skipped, the subledger and the GL will not agree.
Can I post to a closed period?
Sage 300 lets you control which fiscal periods accept posting by module. Posting to a locked period is blocked, and reopening a period should be a controlled decision with approval, since it changes reported results.
How often should I back up before close?
Take a verified backup before you start the close and another before any step that changes many records, such as a year-end process. A backup you have never restored is not proof that you can recover.
Is the year end checklist different?
Year end adds steps such as closing the fiscal year, opening the new year, archiving or clearing history according to your policy, and confirming retained earnings. Use this list for the final period, then add your year-end procedures from the Sage documentation.
If your close still depends on spreadsheets pulled from Sage 300, we can help automate the reconciliation reports and variance checks.
Related Tools
Sage Intacct Dimension Design Worksheet
An editable worksheet for designing Intacct dimensions: which standard and custom dimensions to use, value counts, requirements and examples.
ERP Migration & SelectionSage 100 to Cloud Migration Assessment
A 10-question readiness score for companies on Sage 100 deciding when and how to move to a cloud ERP, with recommendations by result band.
Other ERPsSage X3 Import Template Worksheet
An editable import tracker for Sage X3: which object, which import template, source file, records loaded, errors and owner, with error rates calculated.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator
New to Sage X3 and Sage 100? Start with the Sage X3 and Sage 100 guide and toolkit.
Keep exploring
Free tools
- Sage 300 Database Table ReferenceA quick lookup of well-known Sage 300 SQL table names, the module they belong to and what each stores, for reports and integrations.
- Sage 100 and Sage 300 Private AI Layer Blueprint GeneratorGenerate an architecture plan for a private AI assistant on on-prem Sage 100 or Sage 300: reporting copy or ODBC extract, Web API or BOI, retrieval, local GPU model and audit.
- Sage 300 Foreign Currency Revaluation CalculatorComputes unrealized gain or loss at period end and realized gain or loss at settlement for an open foreign-currency AR or AP balance.
ERP fixes and how-tos
- How to Add AI to Sage 100 and Sage 300 On-PremPrivate AI architecture for on-prem Sage 100 and Sage 300: ODBC or SQL extracts, Sage 300 Web API, Sage 100 BOI, local GPU model, permissions and audit log.
- How to Run a Physical Inventory Count in Sage X3Run a Sage X3 physical inventory count end to end: generate count sheets, freeze theoretical quantities, enter counts, and post variances correctly.
- Sage X3 latest version and release historySage X3 version lineage from V5 to V12 and later, the Sage Enterprise Management name, and how to check your own version and plan an upgrade.
AI on your ERP
- AI for Sage 300, Built for Multi-Entity ManufacturersGround a private LLM on Sage 300 (Accpac) financial and operations data. On-prem AI for multi-currency, multi-entity manufacturers without a public API.
- AI for Sage X3, Grounded in Your Own Ledgers and Stock DataAdd AI to Sage X3 finance and stock data without exporting it to a public model. On-prem and private-cloud LLMs for Sage X3 in the UK and France.
Integrations
- How to add AI agents to Sage X3How to add AI agents to Sage X3: a tool layer over SData and web services, read-first design, human approval on writes, and on-prem models for MRP and POs.
- How to connect Power BI to Sage X3Connect Power BI to Sage X3 through a warehouse, replica or API, use the on-prem gateway, build manufacturing dashboards and add natural-language questions.