Accounting

ERP

Inventory Management

Inventory Reconciliation: How to Match Physical Stock to Your Books

Sherman Hsieh

Share This Post!

Last updated: October 9, 2026 · Independent guide · We do not sell rankings or coverage.

Inventory reconciliation is the process of matching what is physically in your warehouse to your perpetual inventory record, and then matching the value of that perpetual record to the inventory balance in your general ledger. Most guides stop at the first match, but a correct count can still sit next to a wrong general ledger balance. This guide walks through each stage, who owns it, the controls and journal entries involved, and how ERP systems support the work.

The inventory reconciliation process in seven steps

1. Plan the count and set cutoff. Decide what to count, freeze or document movements, and record the last receiving and shipping documents.
2. Count and record. Count by location, ideally blind, and enter quantities against a snapshot of the system.
3. Compare counts to the perpetual record. Produce a variance report by item, location, quantity and value.
4. Investigate and recount. Rule out timing, unit-of-measure, location and ownership errors before you accept a variance.
5. Approve and post adjustments. Route variances to the right approver by value and post them with reason codes.
6. Reconcile the perpetual record to the general ledger. Tie the inventory valuation report to the inventory account balance and explain every difference.
7. Analyze and fix root causes. Trend adjustments by reason code and change the process that produced them.

Titles vary, but keep counting, approving and posting with different people.

Stage 1: Plan the count and set cutoff

Owner and inputs. The inventory controller plans the count from the item list, location map and open documents. You decide between a full physical count and a rolling program; our guide to cycle counting software covers ABC frequencies and count methods in detail.

Controls. Record the last receipt, shipment, transfer and production document posted before the count. If you count on a date other than period end, your auditor will need to test the transactions in between. PCAOB AS 2510 says counts should be “as of a single date within a reasonable time before or after the balance-sheet” date and that auditors apply “appropriate tests of intervening transactions” where needed (PCAOB AS 2510, no date shown).

What goes wrong. Cutoff errors are a frequent cause of false variances. A truck unloaded but not received makes the shelf look long, and an order picked and staged but not shipped makes it look short.

Stage 2: Count and record

Owner and outputs. Count teams record quantities by item and location. The output is a set of count sheets or scanner records tied to a system snapshot of expected quantity.

Controls. Use blind counts, where counters do not see the expected quantity. Keep the snapshot fixed once taken. Microsoft’s Business Central documentation warns that you should keep the originally calculated journal lines and not recalculate expected inventory, “because the expected inventory might change and lead to incorrect inventory levels” (Microsoft Learn, June 17, 2026).

What goes wrong. Counters count in cases when the system holds eaches, miss a second storage location, or count customer-owned or consigned stock as your own.

Stage 3: Compare counts to the perpetual record

Owner and outputs. The inventory controller runs a variance report showing book quantity, counted quantity, difference and extended value for each item and location. Sort it by absolute value.

Controls. Set a recount tolerance before the count starts, for example by value or percentage per line.

What goes wrong. Teams look only at the net total. A net difference near zero can hide offsetting errors, such as a mis-pick between two similar SKUs.

Stage 4: Investigate and recount

Owner. The inventory controller investigates, and a different person recounts. Work through causes in this order, because the early ones are common and cheap to check:

• Timing. Unposted receipts, shipments, transfers or production issues around cutoff.
• Unit of measure. A variance that equals a pack size or a multiple of it.
• Wrong item or location. A matching overage on a neighboring SKU or another bin. Business Central’s documentation says that if a difference comes from items posted to the wrong location, you should use a reclassification journal or transfer order instead of entering it as a count difference (Microsoft Learn, June 17, 2026).
• Kits and backflushing. A bill of materials that does not match actual usage.
• Unrecorded scrap, damage and returns. AccountingTools notes that a consistent small excess of book over physical quantity suggests unrecorded scrap (AccountingTools, March 20, 2026).
• Theft and true shrink. What remains after the rest.

If items show below zero in the system, solve that first. Our guide to negative inventory explains how shipping before receiving and unit-of-measure errors create negative balances and distort cost of goods sold.

What goes wrong. Adjusting a timing difference adds stock that the late receipt then adds again.

Stage 5: Approve and post adjustments

Owner. The inventory accountant prepares the adjustment, and an approver who did not count signs it off. Set approval limits by value. The limits below are an illustration only.

The journal entries. In a perpetual system the adjustment transaction usually creates the entry for you. A shortage reduces inventory, and an overage increases it.

ERPs differ in where they send the offset. NetSuite’s Inventory Count feature uses a Default Inventory Count Account, which Oracle describes as “typically an expense account” (Oracle NetSuite Help, no date shown). QuickBooks Online asks you to choose an inventory adjustment account and records adjustments to “Cost of Goods Sold (under Inventory Shrinkage) accounts” (Intuit, updated August 5, 2026). In SAP, offsets normally post to accounts for expenses or revenue from inventory differences (SAP Help, R/3 4.6C documentation, no date shown).

Tax note. If you estimate shrinkage at year end and confirm it with a later count, 26 U.S.C. 471(b) allows that method when the taxpayer “normally does a physical count of inventories at each location on a regular and consistent basis” and adjusts its inventories and estimating methods to actual shrinkage (26 U.S.C. 471, Cornell LII, no date shown; checked October 9, 2026).

What goes wrong. The counter also posts the adjustment, or adjustments post with no reason code.

Stage 6: Reconcile the perpetual record to the general ledger

Owner and inputs. An inventory or GL accountant compares the inventory valuation report (quantity times cost from the subledger) with the inventory account balance on the trial balance at the same date. The controller reviews and signs. Do this monthly, not only after a count.

Common causes of a difference:

• Manual journal entries posted directly to the inventory account. MYOB Acumatica’s documentation lists entries from other modules that are “directly processed to the inventory account without the processing from the inventory subledger” as a cause (MYOB Acumatica help, no date shown).
• Inventory transactions not yet posted to the GL. The same page notes a GL transaction may not be generated if Update GL was cleared when the inventory transaction was released, and points you to unposted batches.
• Cost adjustments not run. In Business Central you run Adjust Cost – Item Entries before Post Inventory Cost to G/L so the costs posted are current, unless Automatic Cost Posting is on (Microsoft Learn, August 29, 2024).
• Entries in a closed period. Business Central skips value entries dated in a closed period (Microsoft Learn, August 13, 2025).
• Received-not-invoiced timing. Expected cost may sit in interim accounts until the vendor bill posts.
• Reserves outside the subledger. Obsolescence reserves booked in the GL are known reconciling items.

Illustrative example. Your trial balance shows inventory of $1,248,300 at September 30. The inventory valuation report shows $1,241,050, a difference of $7,250. Investigation finds a $5,000 freight accrual posted by journal entry directly to inventory instead of through landed cost, and $2,250 of cost adjustments that were calculated but not posted to the GL. You reverse the journal, reprocess the freight through landed cost and post the cost adjustments, leaving no unexplained difference.

Controls. Restrict manual journals to inventory control accounts and explain any reconciling item older than one month. Our guide to standard cost vs actual cost explains the variance accounts that also need to be reviewed if you use standard costing.

Stage 7: Analyze and fix root causes

Group posted adjustments by reason code, item class and location, and review the trend each month. If mis-picks drive most of the value, look at slotting, labels and scan confirmation; our article on the hidden cost of mis-picks covers that wider cost. Record inaccuracy is common: one study of nearly 370,000 inventory records across 37 stores of a single retailer found 65% to be inaccurate (DeHoratius and Raman, Management Science, April 2008).

Metrics to track

• Inventory record accuracy: the share of counted item-locations within tolerance.
• Gross and net adjustment value: gross shows how much was wrong; net shows the profit effect.
• Shrink as a percentage of sales or inventory. For context, the National Retail Federation reported an average retail shrink rate of 1.6% for fiscal 2022 (NRF, September 26, 2023). Compare against your own history.
• Adjustments by reason code: the share of value explained by timing, unit of measure, mis-pick, scrap and unknown.
• Unexplained subledger-to-GL difference and its age: this should be zero or near zero at each close.

How software supports each stage

Count and approval. In NetSuite WMS, Inventory Count records in Complete/Pending Approval status are ones where “a supervisor can approve or reject them”; an approved count record lists any related positive or negative inventory adjustments, and a rejected count returns to Started so the operator counts again (Oracle NetSuite Help, no date shown). SAP lets you define value tolerances for groups of users who post inventory differences, with a limit per document and per item (SAP Help, R/3 4.6C documentation, no date shown). Business Central posts count differences from the Phys. Inventory Journal or from Physical Inventory Orders, which Microsoft says offer more control over distributing the counting work; its documentation does not describe a built-in approval step for the result (Microsoft Learn, June 17, 2026). In Acumatica, you finish on the Physical Inventory Review (IN305000) form, where Complete PI generates the adjusting transactions (MYOB Acumatica help, no date shown).

Subledger-to-GL reconciliation. Business Central’s Inventory – G/L Reconciliation page compares inventory ledger value entries with G/L totals and shows a Difference column (Microsoft Learn, August 29, 2024). Acumatica documents a reconciliation routine using Inventory Valuation (IN615500), Inventory Transactions by Account (IN403000) and the Trial Balance Summary (GL632000) (MYOB Acumatica help, no date shown).

How we researched this

We reviewed the top-ranking pages for “inventory reconciliation” in October 2026, including guides from ShipBob, Linnworks and GEP (each sells software or services) and AccountingTools. Most skip the general ledger tie-out, journal entries and approval limits. We checked each ERP feature against vendor documentation, the audit and tax rules against PCAOB and the U.S. Code, and we flag sources that sell products. Worked examples and approval limits use constructed numbers.

Related guides

• Kitting Inventory: How ERP Handles Kits and Bundles
• VMI Software: How Suppliers and Distributors Run It
• Warehouse Slotting Software: When You Need It (2026)

Frequently asked questions

What is the difference between inventory reconciliation and a physical count?

A physical count tells you what is on the shelf. Reconciliation compares that count with the perpetual record, explains and approves the differences, and then ties the value of the perpetual record to the general ledger.

How often should you reconcile inventory?

Reconcile the perpetual record to the general ledger every month as part of the close. Physical counts can be annual, or replaced by a cycle count program that covers high-value items more often.

Where do inventory adjustments go in the general ledger?

The inventory account is debited or credited, and the offset usually goes to an inventory shrinkage or adjustment expense account, which many companies report within cost of goods sold. Variances caused by a wrong location or item should be corrected with transfers or reclassifications, not posted as shrinkage.

Why does my inventory valuation report not match the balance sheet?

The usual causes are manual journal entries posted directly to the inventory account, inventory transactions not yet posted to the general ledger, cost adjustments that have not run, and reserves that exist only in the general ledger. Your ERP’s reconciliation report will usually point to the cause.

Sources

• PCAOB, AS 2510: Auditing Inventories, no date shown. pcaobus.org
• 26 U.S.C. 471, General rule for inventories, Cornell Legal Information Institute, no date shown (checked October 9, 2026). law.cornell.edu
• Microsoft Learn, Count, adjust, and reclassify inventory (Business Central), June 17, 2026. learn.microsoft.com
• Microsoft Learn, Post inventory costs to the general ledger (Business Central), August 29, 2024. learn.microsoft.com
• Microsoft Learn, Design details: reconciliation with the general ledger (Business Central), August 13, 2025. learn.microsoft.com
• Oracle NetSuite Help, Setting Up Inventory Count, no date shown. docs.oracle.com
• Oracle NetSuite Help, Approving or Rejecting Inventory Counts, no date shown. docs.oracle.com
• MYOB Acumatica help, Reconciliation of the Cost of Inventory with the Account Balance, no date shown. help.myob.com.au
• MYOB Acumatica help, To Complete the Physical Inventory Count, no date shown. help.myob.com.au
• SAP Help, Physical Inventory: Differences (R/3 4.6C), no date shown. help.sap.com
• SAP Help, tolerances for posting inventory differences (R/3 4.6C), no date shown. help.sap.com
• Intuit, Adjust inventory quantity on hand in QuickBooks Online, updated August 5, 2026. quickbooks.intuit.com
• AccountingTools, How to reconcile inventory, March 20, 2026. accountingtools.com
• National Retail Federation, National Retail Security Survey 2023, September 26, 2023. nrf.com
• DeHoratius, N. and Raman, A., Inventory Record Inaccuracy: An Empirical Analysis, Management Science 54(4), April 2008. ideas.repec.org
• ShipBob (sells fulfillment services), Inventory reconciliation, July 28, 2026. shipbob.com
• Linnworks (sells inventory software), Inventory reconciliation, June 20, 2025. linnworks.com

3198 Overall Score

Sherman Hsieh

CEO & Editor-in-Chief, Business-Software.com
Independent analysis of enterprise software — ERP, CRM and more

Sherman Hsieh is the founder, CEO, and editor-in-chief of Business-Software.com. He leads the site's independent, buyer-focused coverage of ERP, CRM, and other business systems, including vendor-neutral comparisons, pricing analysis, and implementation guidance. Before founding Business-Software.com, Sherman was an executive at Siebel ...