Skip to main content
Remote Financial Services
HomeAboutPricingToolsContact
+1 (818) 321-4972 Book a free consultation
Article

Inventory Reconciliation: Steps, Variances, and Journal Entries

Inventory reconciliation steps for US small businesses: count-to-subledger-to-GL tie-out, cutoff checks, variance classification, and journal entries.

Remote Financial Services
Inventory Reconciliation: Steps, Variances, and Journal Entries

Inventory reconciliation is the process of proving that three numbers agree — the physical count of goods on hand, the item-level inventory subledger, and the inventory control account in the general ledger (GL) — then investigating every difference and posting adjusting journal entries until they match. It applies to any US business that buys, makes, or resells merchandise. Two boundaries matter up front: a reconciliation fixes the books but not a process that keeps bypassing the system, and reconciling your books is a separate question from whether federal tax rules require you to keep a formal inventory at all.

Quick answer

To reconcile inventory: freeze stock movement at a cutoff time, check receipts and shipments around the cutoff, count the goods, extend quantities at cost, compare the count to the inventory subledger (the book-to-stock variance), classify and investigate each difference, post adjusting journal entries through the inventory system, then tie the subledger to the GL and get a reviewer’s sign-off. For wider context, see our industry finance guides for small businesses; for the software that feeds this process, see our guide to inventory management systems for small businesses.

What is inventory reconciliation?

Inventory reconciliation is a three-way tie-out between the physical count extended at cost, the inventory subledger (the item-by-item quantity and value detail your system maintains), and the GL control account (the single inventory asset balance on the balance sheet). In a clean system the subledger and GL move together on every transaction, so a gap between them points to a manual journal entry or broken integration; a gap between the count and the subledger points to counting, cutoff, transaction, or loss problems.

The stakes are concrete because inventory drives cost of goods sold (COGS), the direct cost of the merchandise you sold. Schedule C (Form 1040) Part III computes COGS as beginning-of-year inventory plus purchases, labor, materials, and other costs, minus end-of-year inventory (lines 35 through 42), and asks which method you used to value closing inventory — cost, lower of cost or market, or other (line 33), per the 2024 Schedule C (Form 1040) (accessed July 28, 2026); IRS Publication 334 walks through the same lines. If ending inventory is wrong, COGS, gross profit, and taxable income are all wrong by the same amount.

Keep three lenses on that number separate. For book accounting under US Generally Accepted Accounting Principles (GAAP), inventory is an asset until sold, and under the Financial Accounting Standards Board (FASB) Accounting Standards Update (ASU) 2015-11, FIFO or weighted-average-cost inventory is carried at the lower of cost and net realizable value, so damaged or obsolete stock is written down, per Xero’s US inventory accounting guide (accessed July 28, 2026), a secondary explanation of the FASB standard. For tax, federal rules decide whether you must keep a formal inventory at all (next section). For management reporting, owners need reliable margins even when tax law would let them expense inventory sooner.

Does the IRS require you to count and reconcile inventory?

Often, yes. Section 471(a) of the Internal Revenue Code requires inventories whenever holding one is necessary to determine income, and Treasury Regulation section 1.471-1 requires taking an inventory at the beginning and end of each taxable year in which the production, purchase, or sale of merchandise is an income-producing factor, per Treasury Decision (T.D.) 9942 (accessed July 28, 2026).

The same decision notes that when an inventory is required, the accrual method must be used for purchases and sales — the rule IRS Publication 538 states directly.

On counting frequency, Publication 538 adds (accessed July 28, 2026):

“You must take a physical inventory at reasonable intervals and the book amount for inventory must be adjusted to agree with the actual inventory.” — Internal Revenue Service, Publication 538

That second sentence is this article’s whole point in tax form: the books must be adjusted to match the count. There is an important exception. A “small business taxpayer” — one that meets the gross receipts test of section 448(c) and is not a tax shelter — may instead treat inventory as non-incidental materials and supplies or follow the inventory treatment in its financial statements or books and records, under section 471(c) as implemented by T.D. 9942. The gross receipts test is average annual gross receipts of $31 million or less for tax years beginning in 2025 (Rev. Proc. 2024-40, section 2.31) and $32 million or less for 2026 (Rev. Proc. 2025-32, section 4.30; both accessed July 28, 2026), indexed annually. Qualifying businesses are also exempt from the uniform capitalization (UNICAP) rules of section 263A.

Two cautions before skipping formal inventory. T.D. 9942 counts physical counts you actually take as part of your books and records: if your normal accounting uses an end-of-year count to allocate costs, the IRS expects that count for tax — the exception changes the method, not the honesty of the numbers. And the exception is federal; state conformity varies, so confirm the rule where you file.

How often should you reconcile?

Tie the subledger to the GL every month, even with no count — that is a report-to-report comparison. Run cycle counts through the year so every stock keeping unit (SKU) is counted at least once or twice, and take a full physical count at least annually where inventory is material, satisfying the “reasonable intervals” expectation and producing the year-end number Schedule C Part III requires. Periodic systems depend entirely on the count; perpetual systems still need counts because the subledger only knows what was posted to it.

What are the inventory reconciliation steps?

  1. Freeze movement and set the cutoff — pause receiving and shipping; record the last receipt and shipment numbers.
  2. Run cutoff checks (next section) so the count and the records cover the same goods.
  3. Count physically — use sheets or scanners that show locations but not system quantities (a “blind” count).
  4. Extend the count at cost — multiply quantities by unit cost under your valuation method (FIFO layers, weighted average, or specific identification).
  5. Compare count to subledger — the item-level difference is the book-to-stock variance.
  6. Classify and investigate each variance — recount first, then trace transactions, receipts, and returns (see Table 1).
  7. Post adjusting journal entries through the inventory system, not straight to the GL, so both move together.
  8. Tie the subledger to the GL control account — after adjustments they should match exactly.
  9. Get reviewer sign-off and retain the file — count sheets, variance analysis, entries, and approvals.

Which cutoff checks prevent the biggest errors?

Cutoff means the count and the books describe the same moment. Most “mystery” variances are cutoff problems:

  • Receipts not yet entered: goods received before the cutoff are counted but missing from the subledger — post the receipt (debit inventory, credit accounts payable).
  • Vendor invoices not yet received: if the goods are in and counted, include them in inventory and accrue the liability anyway.
  • Shipments not yet relieved: goods shipped before the cutoff must be out of both the count and the subledger; check the shipment log against what the system depleted.
  • Goods in transit: ownership follows the shipping terms in the contract, so decide whose stock it is before the count.
  • Customer returns received but not processed: returned units in receiving are counted but not yet in the subledger — process the return or record the adjustment.

Worked example: count to subledger to general ledger

The following is a hypothetical illustration with made-up inputs for a fictional US ecommerce reseller, “Cascade Home Goods,” reconciling inventory at its June 30, 2026 month-end close on a perpetual FIFO system. Every figure is invented to show the method.

Starting positions: the GL inventory control account shows $84,600.00, the inventory subledger totals $83,940.00, and the first-pass physical count extended at FIFO cost comes to $82,760.00. A recount of one aisle finds $340.00 of units the first count missed, moving the adjusted count to $82,760.00 + $340.00 = $83,100.00.

Table 1: Variance classification for the June 30, 2026 reconciliation (hypothetical, USD).

Variance foundAmountClassificationRoot causeDisposition
First-pass count missed units in Aisle C+$340.00Counting errorMis-keyed case countRecount; correct count sheet
Vendor return shipped but never entered−$500.00Transaction error40 units × $12.50 left with no return recordedPost vendor return (JE1)
Water-damaged units found during count−$360.00Condition/valuation24 units × $15.00 unsellableWrite off to COGS (JE2)
Unexplained shortage, SKU HG-114−$480.00Shrinkage32 units × $15.00 missing; no transaction trailExpense as shrinkage (JE3)
June 29 receipt entered July 1+$500.00Cutoff/timing50 units × $10.00 counted but not in subledgerPost June receipt (JE4)
May manual journal entry bypassed items−$660.00Posting/control errorEntry posted straight to GLReverse via item adjustment (JE5)

Interpretation: the net count-to-subledger variance is $500.00 + $360.00 + $480.00 − $500.00 = $840.00 ($83,940.00 subledger minus $83,100.00 adjusted count), and every dollar is explained before any entry posts. The company’s policy — recount any line over $250, document a root cause over $500, escalate unexplained losses over $1,000 — is a management choice, not a rule.

Table 2: Adjusting journal entries from the variance analysis (hypothetical, USD).

EntryDebitCreditAmountWhy
JE1Accounts payable (vendor return due)Inventory$500.00Record the return shipped to the vendor
JE2COGS — damaged inventoryInventory$360.00Write off unsellable units
JE3Inventory shrinkage expense (COGS)Inventory$480.00Recognize the unexplained shortage
JE4InventoryAccounts payable$500.00Record the June 29 receipt in June
JE5COGSInventory$660.00Reverse the May manual GL-only entry

Interpretation: JE1 and JE4 are balance-sheet-only; the expense effect lands in COGS through JE2, JE3, and JE5, totaling $360.00 + $480.00 + $660.00 = $1,500.00. Posted through the inventory system, JE1–JE4 move the subledger and GL together; JE5 then removes the GL-only residue.

Table 3: Three-way tie-out as the reconciliation progresses (hypothetical, USD).

StagePhysical countInventory subledgerGL control account
Before reconciliation$83,940.00$84,600.00
First-pass count$82,760.00$83,940.00$84,600.00
Recount correction (+$340.00)$83,100.00$83,940.00$84,600.00
After JE1–JE4 (−$840.00 net)$83,100.00$83,100.00$83,760.00
After JE5 (−$660.00)$83,100.00$83,100.00$83,100.00

Interpretation: the output is one defensible number — count, subledger, and GL all at $83,100.00 — with a documented root cause for every difference. Net inventory fell $1,500.00, about 1.8% of the pre-adjustment GL balance ($1,500.00 ÷ $84,600.00), and COGS rose by the same amount, flowing into June gross margin and, at year-end, into Schedule C Part III. Why units go missing — theft, damage, obsolescence — is a separate topic this article deliberately leaves aside; the reconciliation only detects, classifies, and records it.

How do QuickBooks Online and Xero handle the adjustments?

QuickBooks Online Plus and Advanced track inventory perpetually using FIFO: “QuickBooks always considers the first items you purchase as the first items you sell,” per Intuit’s inventory setup guide (accessed July 28, 2026). To true up quantities after a count, you enter an inventory quantity adjustment, and per Intuit’s adjustment help article (accessed July 28, 2026):

“When you save the inventory adjustment, QuickBooks Online automatically records appropriate adjustments to your Inventory Asset and Cost of Goods Sold (under Inventory Shrinkage) accounts.” — Intuit QuickBooks help

Xero’s tracked items use a different cost flow: Xero shows COGS at the average cost of the item when sold and total value as current quantity times average cost, per Xero’s US stock and inventory page (accessed July 28, 2026). Because both platforms post adjustments to the subledger and GL automatically, most subledger-to-GL gaps come from manual journal entries or failing integrations — which is why step 7 routes every fix through items. This is routine engagement work: RFS implemented FIFO inventory in QuickBooks Online and consolidated Shopify, Amazon, and eBay channel data for a Texas-based ecommerce company, as described in our ecommerce financial optimization case study.

What should the reviewer sign-off cover?

Someone other than the counter should own the final review:

  • Count sheets or scanner files are complete and signed, with recounts documented.
  • The variance schedule classifies every difference and states a root cause — no unexplained “plug” entries.
  • Journal entries match the variance schedule and were posted through the inventory system with support attached.
  • The final subledger-to-GL comparison shows zero difference, or the residual is itemized.
  • The reviewer signs and dates the reconciliation, and the file is retained.

Retention is a tax matter: the IRS says to keep records supporting an item of income or deduction until the period of limitations for that return runs out — generally three years, and six years if more than 25% of gross income was omitted, per its recordkeeping guidance (accessed July 28, 2026).

FAQs

Is inventory reconciliation the same as a physical count?

No. The count is one input; reconciliation is the full loop of counting, comparing to the subledger, investigating variances, posting entries, tying the subledger to the GL, and documenting sign-off.

Does the IRS require a physical inventory count?

Generally yes when producing, buying, or selling merchandise is an income-producing factor (section 471(a); Regulation 1.471-1). A small business taxpayer meeting the section 448(c) gross receipts test ($32 million for tax years beginning in 2026) may use the simplified section 471(c) methods instead — but counts used in its own books still count for tax under T.D. 9942.

What account should inventory adjustments post to?

Normally COGS or a dedicated COGS sub-account such as inventory shrinkage or damaged inventory — QuickBooks Online defaults quantity adjustments to Inventory Shrinkage under COGS. Genuine purchase and return transactions belong against accounts payable, as JE1 and JE4 show.

What is the difference between inventory reconciliation and inventory shrinkage?

Reconciliation is the procedure this article describes. Shrinkage is one variance class it detects: stock missing with no recorded sale, return, or damage. The causes and prevention of shrinkage are a separate topic.

The bottom line

Reconcile inventory monthly: freeze and check cutoff, count, classify every variance by cause, post adjustments through the inventory system, tie the subledger to the GL, and get a dated reviewer sign-off. When that loop runs clean, ending inventory is a number you can defend on a tax return and trust for purchasing decisions. If your subledger and GL have not agreed in months, our remote bookkeeping services can reconcile inventory for you and keep the monthly close on schedule. For adjacent topics, see the industry finance guides for small businesses and our inventory management systems guide.

This article provides general educational information, not tax, legal, or accounting advice. Inventory and accounting-method rules depend on your facts, entity type, state, and tax year, and figures cited here were current as of July 2026; consult a qualified tax or accounting professional before changing how you account for inventory.

#inventory reconciliation #physical inventory count #book-to-stock variance #inventory journal entries #month-end close #small business accounting