The SAP Business One Month-End Closing Checklist (Posting Periods, FX Revaluation & Locks)
A repeatable 10-step close used by mid-market finance teams: from posting period statuses to exchange rate differences and the final period lock.
SAP B1 Academy Editorial
Published • 3 min read
A disciplined month-end close is what separates an ERP that produces reliable numbers from one that produces surprises. SAP Business One gives you every tool you need. The trick is running them in the right order, every month.
Understand Posting Period Statuses First
Under Administration → System Initialization → General Settings → Posting Periods, each period can be set to one of four statuses:
- Unlocked: all users can post.
- Unlocked Except Sales: purchasing and finance can post, but sales documents are blocked. This is ideal for the first days of the close.
- Closing Period: only users with the Closing Period authorization can post adjustments.
- Locked: no postings at all. Use this once the management accounts are signed off.
The 10-Step Close
- Set the period to "Unlocked Except Sales" on the first working day after month-end.
- Post all goods receipts and A/P invoices dated in the closing month. Chase missing vendor invoices with the Open Items List.
- Close or reconcile Goods Receipt PO accruals. Review the Open Items List → Goods Receipt POs for old receipts that will never be invoiced.
- Run recurring postings via Financials → Recurring Postings for rent, depreciation, and prepaid amortization.
- Run the depreciation run in the Fixed Assets module, if used.
- Reconcile every bank account using Banking → Bank Statements and Reconciliations.
- Run Exchange Rate Differences (Financials → Exchange Rate Differences) to revalue open foreign-currency invoices and payments at the month-end rate. Use Conversion Differences if you maintain a system currency different from your local currency.
- Review the Inventory Audit Report against the Trial Balance for each stock account.
- Print the Trial Balance, Balance Sheet, and P&L and compare them with budget and the prior month for unusual swings.
- Set the period to "Closing Period" for final adjustments, then to "Locked" once results are approved.
Common Mistakes to Avoid
- Running exchange rate differences before all payments are posted forces you to run it again.
- Leaving prior periods unlocked "just in case" invites backdated postings that change reported results.
- Skipping the inventory-to-G/L comparison hides valuation problems until year-end, when they are much harder to unwind.
Year-End Note
At fiscal year-end, run Financials → Period-End Closing to transfer the P&L balances into retained earnings after the final month is locked and audited. Create the next fiscal year's posting periods well in advance so January transactions are never blocked.
The Ultimate SAP B1 SQL & HANA Query Cookbook
Instant-download PDF playbook plus ready-to-import .sql files for Financials, Inventory Audit, Sales Margin, and Approval Alerts.