+1 480 485 7373
Microsoft Teams
Where the days of a Business Central month-end close go
Ask a controller why the close takes as long as it does, and the answers repeat. Staff wait on purchase invoices, re-key accruals from last month's workbook and chase a bank difference. Then, on the final day, they find that inventory in the general ledger does not match the inventory valuation report. Each of these has a Business Central answer, but only if someone designed the setup with the close in mind.
The biggest shift is moving work out of the close window. Bank reconciliations can run weekly. Cost adjustment can run every night through the job queue. Recurring accruals can post from a journal that already holds last month's lines. When those pieces run during the month, you get a faster month-end close in Business Central. The close itself becomes review and judgment rather than data entry.
Who owns each step of the Business Central month-end close
The second cause is unclear ownership. Sometimes nobody knows who closes fixed assets or who signs off the payables aging. Then tasks wait on each other and the calendar stretches. A written close checklist removes most of that waiting without any change to the system. Give each line one owner, and keep it in the same place every month.
A Business Central month-end close sequence that holds up
- 1
Narrow the posting window
Once you agree sales and purchasing cut-off, set Allow Posting From and Allow Posting To in General Ledger Setup. Then use User Setup to give operational staff the new month only. Orders keep flowing in the new period while the old month stays under finance control.
- 2
Finish receiving and invoicing cut-off
Post outstanding receipts, shipments and invoices dated in the period. Use purchase receipts not yet invoiced to see what needs an accrual. Also agree a rule that the warehouse posts goods received on the last day that same day.
- 3
Adjust cost, then post inventory cost
Run Adjust Cost - Item Entries, then Post Inventory Cost to G/L if automatic cost posting is off. Only after both should you compare the inventory valuation report with the inventory accounts. Running them in the wrong order is the most common reason inventory does not tie.
- 4
Post recurring and period-end journals
Recurring general journals carry accruals, prepayments and allocations. The reversing recurring methods post the entry at period end and reverse it the following day. Run Calculate Depreciation for fixed assets and post the journal it produces.
- 5
Reconcile bank, receivables and payables
Complete the bank account reconciliation for each account, then check that customer and vendor aging totals agree with their control accounts. Differences usually point to entries posted straight to a control account, which switching off Direct Posting on those accounts prevents.
- 6
Report, sign off and lock
Run the trial balance and your financial reports, investigate movements that look wrong, and record sign-off against each checklist line. Then close the posting window for everyone except the person authorized to make post-close adjustments.
Settings that speed up the Business Central month-end close
Posting date controls
Allow Posting From and To work company-wide and per user. They keep closed months closed without anyone needing to remember a rule.
Automatic cost posting
Once you switch it on in Inventory Setup, it sends inventory value entries to the general ledger as transactions happen. That leaves less to post at month end.
Deferral templates
Prepaid expenses and deferred revenue spread across periods from the document line itself, instead of from a separate schedule kept in a spreadsheet.
Job queue entries
Cost adjustment and other batch jobs run overnight on a schedule, so results are waiting when the finance team arrives in the morning.
Example: Business Central month-end close ownership at a distributor
Example: what changes when the close is redesigned
Example: a wholesale distributor on Business Central kept its accruals in a workbook. It ran cost adjustment only at month end and reconciled three bank accounts after the period had closed. Each step waited on the one before it. Meanwhile, the controller spent the start of every month rebuilding entries that matched the previous month almost line for line.
The redesign added no software. Accruals moved into a recurring general journal with reversing lines, and cost adjustment ran nightly. Bank reconciliations became a weekly routine. Finance also narrowed the posting window per user, so operations could keep invoicing in the new month. The checklist shrank to a short list of reviews, each with a named owner.
The lesson carries over to most companies. A faster month-end close in Business Central mostly comes from moving repetitive work earlier and letting the system post what it already knows. Where the close still drags, the cause is usually a data problem. Examples are items carrying the wrong posting group, or entries posted directly to control accounts. Those are worth fixing at the source rather than correcting every month.
Business Central month-end close questions
Where should our close checklist live?
Keep it in a shared list your team already uses, with each line pointing to the Business Central page or report it involves. Business Central supplies the controls: posting date windows, recurring journals, cost adjustment, bank reconciliation, depreciation and financial reports. The checklist adds the order and the owner for each. Some teams track it in Microsoft 365 lists or with a simple Power Automate reminder flow.
How do we stop people posting into a closed month?
Use the Allow Posting From and Allow Posting To fields. Set them in General Ledger Setup for the whole company. Then override them per person in User Setup when someone needs a different window. Anyone outside their window gets an error when they try to post. Check the per-user overrides regularly, because a forgotten wide window is how back-dated entries slip through.
Why does inventory in the general ledger not match the valuation report?
Usually because cost adjustment or cost posting has not run for every entry. Run Adjust Cost - Item Entries, then Post Inventory Cost to G/L if automatic cost posting is off, and compare again. If a difference remains, look for general journal lines posted directly to inventory accounts and for items whose posting groups point at the wrong account. The inventory to G/L reconciliation view helps locate the account and item that are out.
More questions on a faster month-end close in Business Central
Can accruals reverse automatically at the start of the next month?
Yes, through recurring general journals. The reversing recurring methods post the entry on the date you choose and create the reversal the following day. So a month-end entry reverses on the first of the next month. The lines stay in the journal afterwards. Next month you adjust the amounts and post again instead of starting from a blank journal.
Is a faster close worth bringing in outside help?
Often it is a small, focused piece of work rather than a large project. The usual changes behind a faster month-end close in Business Central are settings and routines: posting windows, recurring journals, scheduled cost adjustment and a clean checklist. Where bad master data or a poor chart of accounts slows the close, fixing that takes more effort, and a short assessment shows which situation you are in. We put any scope in writing before work starts.
Talk to us about your project.
Tell us what you run today and what has to change. A senior consultant replies with a written next step.