Inventory Reconciliation in Dynamics 365 Business Central

Month-end close is going fine until someone pulls up the inventory account. The general ledger says one number; the inventory subledger says another. They are supposed to be identical, but they are not. And now someone must figure out why before the books can close. 

This is one of the most common reconciliation headaches in Business Central, not because the system is unreliable, but because inventory accounting involves more moving parts than almost any other area of the ledger. Purchases, sales, production output, cost adjustments, revaluations — each one touches the inventory value differently, and each one is a place where something can go quietly out of sync. 

This blog walks through what inventory reconciliation in Business Central tests, why the G/L and the inventory subledger drift apart in the first place, how to run the reconciliation correctly, and what an auditor expects to find when they review your process. 

What is Inventory Reconciliation in Business Central?

Every inventory transaction in Business Central creates two records simultaneously. One is a quantity of movement means a receipt, a shipment, an adjustment, a transfer. The other is a value of movement; the monetary cost is tied to that quantity of change. 

The quantity side lives in Item Ledger Entries. The value side lives in Value Entries, which are linked to those item ledger entries and together form what's commonly called the inventory subledger. The general ledger gets updated from the value of entries, not directly from the item ledger entries themselves. 

In theory, the total of those value entries should always equal the balance sitting in your inventory G/L account. In practice, it frequently does not, and inventory reconciliation Business Central is the process of figuring out why and fixing it before the difference shows up in a financial statement that's supposed to be accurate. 

Nevertheless, it is accounting control. Finance teams are expected to perform this reconciliation at every period close, document what they found, and resolve any difference before the books are considered closed, not leave it as an open question for next month to inherit. 

Why the G/L and Inventory Subledger Go Out of Sync 

Before running the reconciliation, it helps to understand what typically causes the gap. A handful of root causes account for almost every discrepancy finance team encounter. 

Unposted transactions: A purchase invoice sitting unposted, a sales shipment that has not been invoiced yet, an inventory adjustment that was created but never finalized, any of these leave the subledger and the G/L temporarily out of step until the transaction completes. 

Costs not yet adjusted: Business Central calculates item cost using whichever method is set on the item card like FIFO, LIFO, Average, Standard, or Specific. When a cost change happens (for example, a vendor invoice arrives at a different price than the original receipt), that adjustment needs to run through the Adjust Cost – Item Entries batch job before it reflects correctly. If that job has not run, the subledger value and the G/L can show different numbers for the exact same items. 

Direct postings to the G/L inventory account: This is one of the more disruptive causes. If someone manually posts a journal entry directly to the inventory G/L account means bypassing the inventory subledger entirely, the two will no longer agree, and nothing in the inventory module will explain why, because the discrepancy did not originate there. 

Misconfigured posting groups: Every item is linked to posting groups that tell Business Central which G/L accounts to use for receipts, shipments, and adjustments. If an item or transaction posts to the wrong account because a posting group is set up incorrectly, the inventory total and the G/L total stop matching, and the cause can be difficult to spot without checking the setup directly. 

Open prior periods: If a transaction posts into a period that should have been closed, it can shift balances retroactively in ways that look like an unexplained variance when you are only looking at the current period.

Also Read: Financial Operations

How to Reconcile Inventory to the G/L in Business Central: Step by Step 

Step 1: Open the Inventory - G/L Reconciliation Report

Search for Inventory - G/L Reconciliation in Business Central. This report compares what's recorded in the inventory ledger (value entries) against what's recorded in the relevant G/L accounts, and it does this across three categories: Inventory (invoiced), Inventory Interim (received or shipped but not yet invoiced), and WIP Inventory.

Step 2: Set the Filters

Enter the date range for the period you are closing, along with any item or location filters relevant to your review. Check Show Warning, these surfaces explanatory messages whenever the report finds a discrepancy, which saves significant time versus investigating blind. 

Step 3: Run Show Matrix 

This generates the comparison grid. The left column lists the G/L account types tied to inventory. Each row shows the inventory ledger total next to the G/L total for that account type, with the difference calculated automatically. The target is zero across every row. If there's a difference anywhere, the reconciliation is not complete, regardless of how the individual numbers look on their own.

Step 4: Drill Into Any Difference

Where the report shows a non-zero difference, drill directly from the matrix into the underlying value entries and item ledger entries that make up that number. This is where you find the actual transaction, an unposted document, a manually posted journal entry, or a cost that has not been adjusted yet.

Step 5: Check for Unposted Transactions

Review Item Ledger Entries and Value Entries for anything still open. Unposted purchase invoices, sales shipments awaiting invoicing, or adjustments that were started but not completed are the most common sources of a difference, and they are usually the fastest to resolve. 

Step 6: Run Adjust Cost – Item Entries

If costs have not fully flowed through to the G/L, run this batch job. It recalculates and posts the cost adjustments needed to bring the subledger and G/L back in line. For businesses running average or standard costing, this step often resolves a difference that looked far more complicated than it was.

Step 7: Investigate and Correct Direct Postings

If a manual journal entry was posted directly to the inventory account, identify it and correct it properly, typically by reversing the entry and re-posting the transaction the right way through the inventory module so it flows through the subledger correctly. Document the correction clearly. A future reconciliation will flag this entry as unusual, and a clear description prevents someone from accidentally reversing a correction that was already valid.

Step 8: Close Prior Periods

Go to Inventory > Setup > Inventory Periods and close any period that's been fully reconciled. This prevents new transactions from posting retroactively into a period you have already confirmed is correct.

Step 9: Re-Run the Reconciliation

Run the Inventory - G/L Reconciliation report again to confirm the difference is fully resolved. If it is not, repeat the drill-down process. There may be more than one cause contributing to the same overall variance.

Also Read: Dynamics GP Bank Reconciliation

What This Looks Like as an Accounting Control

Running the reconciliation report once a month is not the same as having a documented control around it. Auditors reviewing inventory reconciliation in Business Central are typically looking for three specific things: evidence the reconciliation was performed, evidence that any differences found were investigated, and evidence that adjusting entries, if any were needed — were reviewed and approved before posting.

A few setup decisions make this easier to demonstrate consistently:

• Automatic Cost Posting, enabled on the Inventory Setup page, posts G/L entries in real time as inventory transactions happen, rather than waiting for a manual batch job. This keeps the G/L closer to current throughout the month, not just at period end.
• Restricting Direct Posting on the inventory G/L account prevents casual manual entries that bypass the subledger. This single setting eliminates one of the most common, and hardest to trace that causes reconciliation differences.
• Standardizing the correction process so that every adjustment to the inventory account includes a clear, specific description explaining why it was posted. Future reconciliations need to immediately recognize a documented correction versus something that needs investigating again.

Reports That Support the Reconciliation Process

Beyond the core Inventory - G/L Reconciliation report, a few other Business Central inventory reports are worth building into a consistent month-end routine:

• Inventory Valuation report: Shows the value of inventory on hand based on value entries. Worth noting: the standard version does not include goods received or shipped but not yet invoiced, so comparing it directly to the G/L balance will often show an expected difference, not an actual error. 
• Item Ledger Entries and Value Entries: The most granular drill-down tools available, used to trace any individual transaction back to its source.
• Power BI Inventory app: For businesses tracking inventory KPIs across multiple locations, connecting Business Central inventory data to Power BI gives finance and operations a shared, real-time view of stock value, turnover, and aging without manual report-building. 

Why This Matters Beyond the Month-End Close

Inventory is frequently one of the largest assets on a mid-sized business balance sheet. An unreconciled difference does not just look untidy in a report, it can understate or overstate the company's actual financial position, trigger questions during an audit, or mask an underlying operational issue like a data entry error or, in less common cases, inventory shrinkage that has not been investigated.

For Canadian businesses in Ontario and Toronto running multi-location inventory, the stakes get higher with scale. More locations mean more posting groups, more transaction volume, and more opportunities for a misconfigured setup to quietly create discrepancies that compound over several periods before anyone notices.

How Dynamics Square Helps Canadian Businesses Get Inventory Reconciliation Right 

Most inventory reconciliation problems in Business Central trace back to setup means posting groups configured inconsistently, Automatic Cost Posting left off, or a costing method that does not match how the business operates.

Dynamics Square Canada is leading Microsoft Dynamics 365 Business Central partner with 150+ certified professionals, 350+ businesses served across Ontario and Canada. Our Business Central implementation process includes inventory posting setup designed to minimize reconciliation differences from the start including correct posting groups, the right costing method for the business, and Automatic Cost Posting configured before going-live rather than discovered as a problem afterward.

For businesses already running Business Central with inventory accounts that won't reconcile cleanly, Dynamics Square's support services include a full review of inventory setup, posting history, and the specific transactions causing the variance, fixed without disrupting live financial operations.

Conclusion

Inventory reconciliation in Business Central is a discipline that protects the accuracy of one of the largest numbers on your balance sheet. Done consistently; it catches small discrepancies before they compound. Skipped or rushed, it turns into the kind of month-end surprise that delays a close and raises questions an auditor should not have to ask.

For Canadian businesses running Business Central across Ontario and beyond, the businesses that close cleanly every month are the ones treating this as a standing control, not a once-a-year scramble. 

Connect with Dynamics Square via call at +1 778 381 5388 or drop an email at info@dynamicssquare.ca to get your Business Central inventory setup configured so reconciliation stops being a guessing game.  

People Also Ask:

What is inventory reconciliation in Business Central?

Inventory reconciliation in Business Central is the process of confirming that the value recorded in the inventory subledger, built from item ledger entries and value entries that matches the balance in the general ledger inventory account. Business Central provides the Inventory - G/L Reconciliation report specifically to compare these two and identify any difference.

Why don't the G/L and inventory subledger always match?

The most common causes are unposted transactions, costs that have not been run through the Adjust Cost – Item Entries job, manual journal entries posted directly to the inventory account, misconfigured posting groups, and transactions posted into a period that should have been closed.

How often should inventory reconciliation be performed in Business Central?

At every period close, as standard accounting control; not as an occasional check or only at year-end. Auditors expect evidence that the reconciliation happens consistently; that differences are investigated when found, and that any adjusting entries are documented and approved. 

What's the difference between the Inventory Valuation report and the Inventory - G/L Reconciliation report?  

The Inventory Valuation report shows the value of inventory on hand based on value entries, but the standard version excludes goods received or shipped but not yet invoiced. The Inventory - G/L Reconciliation report is built specifically to compare the inventory subledger against the G/L and will show whether they are in balance, which the valuation report alone won't confirm.