SAP Business One Period End Close Checklist for Month End and Year End
A SAP Business One close is mostly a sequence: finish operational documents, post the automatic and manual journals, review, then lock the period. This checklist puts the steps in that order, with the ones that cannot easily be undone marked critical.
0 of 30 items complete
11 critical items still open - these are the highest-risk gaps.
1. Cut-off and open documents
2. Inventory and production
3. Sub-ledgers and bank
4. Journals, FX and tax
5. Review, lock and report
Close in the order shown: cut-off, inventory, sub-ledgers, journals, then lock. Locking before inventory and production variances are posted is the most common reason for reopening a period.
Want a close exceptions report from B1?
We can sketch a read-only report that lists open deliveries, uninvoiced receipts and stale orders before your close.
Optional. The tool and every export work without this. No spam.
How to use this checklist
Run it on the same working day each month, with owners named next to each group. Tick items as you complete them, then export the PDF as the close file. Items marked critical are those where a miss tends to cause a misstatement or force a period to be reopened. Adapt the list for your tax regime and business: a company with no fixed assets can skip depreciation, and a single currency company can skip revaluation. Add your own lines for local statutory filings.
The B1 features it relies on
Posting Periods in Administration, Setup, Financials control which dates accept postings, with statuses such as Unlocked, Locked and Unlocked except sales or purchasing, depending on version. Currency revaluation is available as an exchange rate difference run. Inventory valuation reports can be compared with the control account. Period End Closing is a year-end function that closes income and expense accounts. Each of these is a place where setting is easy and unsetting is slow, so check before clicking.
Reconciling inventory to the ledger
In B1 with perpetual inventory, every stock movement posts to the G/L, so the inventory valuation by item should equal the inventory control account balance. Differences usually come from manual journals to the control account, items with the wrong group, landed cost timing or production variances not yet posted. Run the inventory audit report for the month and the G/L account balance for the same date, then trace the gap by document type. Fix by correcting the source, not by a plug journal.
- Compare totals by item group first
- Exclude manual journals when tracing, then add them back
- Check receipts with no matching invoice
- Check closed production orders with variances
Common mistakes
Teams reopen periods because of a short list of habits, each easy to prevent.
- Locking the period before bank and tax reconciliations
- Running revaluation before entering period end rates
- Leaving drafts open that later post into a locked period
- Doing the year-end closing before audit adjustments
- Having no named backup when the controller is away
Frequently Asked Questions
How do I lock a period in SAP Business One?
Open Administration, Setup, Financials, Posting Periods, select the period and set its status to Locked. Make sure the period you lock is the one you closed, and restrict who can unlock it through authorizations.
What is Period End Closing in B1?
It is the year-end process that transfers profit and loss account balances to retained earnings and closes the fiscal year for those accounts. It is separate from locking a monthly posting period and should follow final audit adjustments.
How do I handle foreign currency revaluation?
Enter the exchange rates for the period end date, then run the exchange rate differences or revaluation function. B1 posts the unrealized gain or loss. Confirm the revaluation accounts are mapped before you run it.
Why does inventory not match the G/L?
Typical causes are manual journals to the control account, wrong item group account mapping, landed cost timing and unposted production variances. Compare by item group first, then by document type, and fix at source.
Many close delays come from chasing the same open items every month. We can build a read-only exceptions report from B1 data that lists them before day one of the close. Ask us about it.
Related Tools
SAP Business One Production Order Checklist
A step-by-step checklist for creating, releasing, issuing to, receiving from and closing a production order in SAP Business One.
SAPSAP B1 User Permission Matrix Worksheet
An editable role-by-module matrix to plan SAP Business One authorizations, with a score for roles that mix duties.
SAPSAP B1 Approval Procedure Template
Fill in thresholds and approvers to generate a written SAP Business One approval procedure you can sign and configure from.
Developer ToolsSAP B1 SQL Query Generator (OITM, ORDR, RDR1)
Fill in a few filters and get a read-only SQL query over OITM, ORDR and RDR1 to paste into the SAP B1 Query Manager.
More SAP tools
See all- SAP B1 Business Partner Master Data Request Form
- SAP Business One User Acceptance Test Script Template
- SAP Business One Data Migration Mapping Worksheet
- SAP Business One User-Defined Fields and Tables Register
- SAP Business One Document Object Type Codes
- SAP Business One User-Defined Field Planning Worksheet
- SAP Business One Private AI Layer Blueprint Generator
- SAP Business One AI Assistant Sizing and Value Calculator
- SAP B1 Item, Warehouse and Batch Columns Reference (OITM, OITW, OITL, OBTN)
New to SAP Business One? Start with the SAP Business One guide and toolkit.
Keep exploring
Free tools
- SAP Period End Closing ChecklistA month-end close checklist in a sensible order, with the SAP transactions to run for each step.
- SAP B1 Production Order Cost Variance CalculatorCompare actual to standard on a closed production order and see how much of the variance is material, labor rate and labor efficiency.
- SAP Business One Production Order ChecklistA step-by-step checklist for creating, releasing, issuing to, receiving from and closing a production order in SAP Business One.
ERP fixes and how-tos
- Production standard cost in SAP Business One: how it works and where it stopsHow standard cost works for production orders in SAP Business One: valuation method, issue and receipt values, variances at close and process limits.
- SAP Business One production planning: MRP, production orders, cost and variancesSAP Business One production planning end to end: MRP, planned to released orders, cost rollup, variance reporting and when you need a manufacturing add-on.
- SAP Business One: Posting Date Blocked by a Locked PeriodPosting blocked in SAP Business One because the period is locked? Check period status, sub-periods, authorization and document dates, then fix it safely.
Runs with your ERP
- ECOSIRE CPQ Configurator with SAP Business One: guided quotingHow the ECOSIRE CPQ configurator uses option models, requires/excludes rules and live cost roll-up to create SAP Business One quotes and orders.
- Ecosire quality control and inspection with SAP Business One: CoA, NCR and CAPAHow Ecosire's quality add-on for SAP Business One handles inspections, certificates of analysis, NCR and CAPA ageing and supplier quality reporting.
- ECOSIRE Time and Attendance and SAP Business One: clock events to job costingHow ECOSIRE's time and attendance integration turns clock terminal events into hours, overtime and absence in SAP Business One, with setup, pitfalls and AI.
AI on your ERP
- AI for SAP Business One, Without Sending Your Books to a Public APIAdd AI to SAP Business One without sending customer data or financials to a public API. Service Layer and DI API integration, sized for an SMB budget.
- AI for SAP Business One Inventory: Stock, Batches, Bins and ValuationPrivate AI over SAP Business One inventory: OITW stock, batches, serials, bins and valuation. Answers grounded in live data via Service Layer or SQL views.
Integrations
- How to add AI agents to SAP Business OneHow to put AI agents on SAP Business One: Service Layer tool design, read-only first, draft documents for human approval, and an on-prem model option.
- How to add WhatsApp to SAP Business OneHow to add WhatsApp to SAP Business One: Service Layer, Cloud API templates, opt-in rules, order status, delivery alerts and two-way replies into documents.