Inventory Reconciliation in Business Central: The Accounting Control Behind the Process

If you are responsible for closing the books in Business Central, inventory reconciliation is one of the tasks most likely to produce a difference you cannot immediately explain. The numbers are in the system. The process to reconcile them is not always clear. This post covers what the reconciliation is actually testing, how to run it correctly, and what your auditor will expect to see.

Inventory G/L reconciliation

Inventory Reconciliation as an Accounting Control: What IFRS and GAAP Require

Every inventory transaction in a business creates two records: a quantity and cost movement in the inventory subledger, and a corresponding entry in the general ledger. In theory, the subledger total and the G/L inventory account balance should always agree. In practice, they frequently do not, and identifying why is the purpose of reconciliation.

Subledger-to-G/L reconciliation is a required internal control, not a year-end exercise. Finance teams are expected to reconcile inventory at every period close, retain documentation of the reconciliation, and investigate and resolve differences before signing off on financial statements.

Auditors look for three things: evidence that the reconciliation was performed, that differences were investigated, and that adjusting entries, if any, were approved and documented.

Business Central Inventory Subledger and G/L: How the Architecture Works

Every inventory transaction in BC writes to two parallel records. Item Ledger Entries capture the quantity record: every receipt, shipment, adjustment, and transfer. Value Entries are linked to item ledger entries and capture the monetary value of each transaction, forming the inventory subledger. The general ledger is updated from value entries, not directly from item ledger entries.

Two settings in Inventory Setup determine whether your G/L reflects current inventory values at any given point. These are worth knowing even if you did not configure them yourself.

Automatic Cost Posting: When enabled, G/L entries are created in real time as inventory transactions are posted. When disabled, the Post Inventory Cost to G/L batch job must be run manually before G/L balances reflect current inventory values. Automatic Cost Adjustment controls when the Adjust Cost - Item Entries process runs. This process recalculates item costs when late purchase invoices or transfers affect cost retrospectively. If this is not set to Always, or scheduled via Job Queue, costs in the value entries may be incomplete at the point of reconciliation.

Inventory Setup

These two settings work together: Automatic Cost Posting running without Automatic Cost Adjustment means real-time G/L posting of costs that have not yet been fully adjusted. The G/L updates, but with costs that may change once adjustment runs.

Running Inventory Reconciliation in Business Central: Month-End Sequence

Run these three steps in order before opening any reconciliation report (If cost posting and cost adjustments are set up to run automatically, you don't need to perform the first two steps.).

First, run Adjust Cost - Item Entries to ensure all value entries reflect current costs. Second, run Post Inventory Cost to G/L if not using Automatic Cost Posting, to ensure value entries are reflected in the G/L. Third, open the Inventory - G/L Reconciliation page, which is the primary reconciliation tool.

Inventory G/L reconciliation

The Inventory - G/L Reconciliation page compares value entries to G/L entries across three columns: Inventory (invoiced), Inventory Interim (received or shipped but not yet invoiced), and WIP Inventory.

The Difference column shows any gap between the subledger and the G/L for each account type. Enable Show Warnings to surface explanatory messages for any discrepancy. A zero difference across all rows is the target. If differences exist, the reconciliation is not complete regardless of what the individual reports show.

Warning on inventory reconciliation

The Inventory Valuation report shows the value of inventory on hand calculated from value entries. It is not the same as the G/L inventory account balance. The standard version does not include items received or shipped but not yet invoiced — comparing it directly to the G/L will almost always show a difference that is expected, not an error.

Inventory Valuation

The Inventory to G/L Reconcile report is the correct report for month-end reconciliation. It includes expected costs and gives a full view of what should be in the G/L versus what is. If your organisation uses manufacturing, run Inventory Valuation - WIP alongside the standard reconciliation. WIP inventory sits in separate G/L accounts and is not captured in the standard reconciliation page.

Inventory G/L Reconciliation Differences: Causes and How to Investigate

When the Inventory - G/L Reconciliation page shows a difference, the investigation follows a clear sequence.

Direct posting to inventory G/L accounts. If someone has posted a manual journal entry directly to an inventory account, it appears in the G/L but not in the value entries, creating a permanent difference. Filter G/L entries for the inventory account by Source Code and exclude INVTPCOST to identify any entries that bypassed the subledger. The Direct Posting flag on the G/L account should be set to No for all inventory accounts to prevent this.

Incorrect posting group setup is a less common but harder-to-detect cause. If an inventory posting group was mapped to an expense account rather than a balance sheet account during the implementation, inventory transactions will have been hitting the income statement rather than the inventory G/L. If your reconciliation consistently shows a difference that does not match any of the other causes above, this is worth raising with whoever manages your system setup.

If Expected Cost Posting to G/L is enabled, receipts and shipments create interim G/L entries before invoicing. If reconciliation is performed without accounting for interim entries, the difference is not a system error. It is a timing item that will clear on invoicing.

Next steps

If you are implementing Business Central or reviewing your month-end close process, check out our adoption training program for Business Central here.