Month-end close in Business Central

A clean month-end close in Business Central is mostly process discipline supported by a handful of routines. The system isn't trying to be clever — it gives finance the order to run things in.

Run it from a checklist with names on it

The single biggest close improvement has nothing to do with software: a written close calendar where every task below has an owner, a working-day deadline (D+1, D+2…), and a dependency order. Inventory cost adjustment before inventory reconciliation; FX revaluation before the sub-ledger reconciliations; everything before the period locks. Companies that close in three days and companies that close in twelve run the same BC routines — the difference is whether the sequence lives in a checklist or in one controller's head. Keep the checklist in whatever tool the team already uses; the point is that "the close" is a repeatable production run, not a monthly improvisation.

Cut-off and accruals

Set the Posting Date limits in the General Ledger Setup so that no one back-dates into the closed period. Post recurring accruals (rent, utilities, payroll, deferred revenue) from the Recurring General Journal, which can be templated and reused each period.

AP and AR reconciliation

Reconcile Detailed Vendor Ledger Entries and Detailed Customer Ledger Entries totals to the GL control account balances. Differences usually trace to direct postings to AP/AR control accounts (which the system blocks by default, but can be allowed); investigate and correct via the Reconcile Customer/Vendor Accounts report. Aging reports are the standard tool for spotting which open balances are actually collectible before they distort the close, and unresolved overdue receivables are what reminders and finance charges exist to chase down before they become a habit.

Bank reconciliation

Reconcile every active bank account to its bank statement balance. Post fees, interest, and direct debits from the reconciliation page. Carry forward any in-transit items. The direct debits Business Central collects from customers itself have their own setup and R-transaction handling, covered in direct debits, and the payment side that funds those postings is payment journals, in depth.

FX revaluation

Run Adjust Exchange Rates for foreign currency customer, vendor, and bank balances. This produces unrealized gain/loss entries reflecting period-end rates.

Inventory cost adjustment

Run Adjust Cost — Item Entries for all items. This flushes landed cost from inbound transactions into outbound cost of goods sold, and corrects any mid-period cost reversals. Then run Post Inventory Cost to G/L to propagate the cost into the GL. Inventory in the GL should match the Inventory Valuation report to the penny. The cost adjustment job explains why this step is separated from posting in the first place, and standard-cost shops should also see the standard cost worksheet for the variance side of the same close.

Fixed asset depreciation

Run Calculate Depreciation for the period; review and post the resulting FA journal.

Sub-ledger reconciliations

Inventory, fixed assets, jobs (WIP), VAT — each has a control account in the GL that should match the underlying sub-ledger totals. The relevant reconciliation reports are Inventory G/L Reconciliation, FA G/L Reconciliation, and Job WIP G/L Reconciliation.

VAT settlement

Run Calc. and Post VAT Settlement to close the VAT entries into a payable/receivable balance, then post the payment to the tax authority.

Lock the period

Move the Allow Posting From date forward so the closed period is read-only. Some companies also set per-user posting date ranges.

Reporting the close

Build the month-end reporting pack once as financial reports (account schedules) — P&L versus budget, balance sheet, and the handful of KPIs management actually reads — and the reporting step becomes running saved reports rather than assembling spreadsheets. If the pack is still built by exporting trial balances to Excel every month, that's the next thing to fix after the checklist.

Shortening the close

Most of the calendar time in a slow close is waiting and rework, not processing. The levers that actually move the needle:

• Reconcile continuously, not monthly. With bank feeds importing transactions daily, bank rec at month-end is a five-minute confirmation instead of a half-day archaeology dig. The same applies to posting supplier invoices as they arrive rather than in a month-end batch.
• Template everything recurring. Accruals, allocations, and standard corrections belong in recurring journals with allocation keys set up once — not rebuilt in Excel each period.
• Run cost adjustment on a schedule. Adjust Cost — Item Entries can run as a nightly job queue entry (or automatically, via the inventory setup toggle) so month-end isn't the first time three weeks of cost corrections land in the GL.
• Chase the same differences once. If the AP reconciliation finds the same class of direct posting every month, close the hole — restrict direct posting on the control accounts — rather than re-finding it forever. A recurring reconciliation difference is a setup bug wearing a process costume.

Year-end

At year-end, run Close Income Statement to roll P&L to retained earnings, then process the Closing Date posting and lock the year. The full year-end sequence — including dimension handling on the closing entries and reopening adjustments — is covered in closing the income statement and year-end in BC. For where the close sits in the wider finance setup, see the Business Central finance module.