Stock that isn't where the records say it is, or isn't worth what the ledger says, goes straight to the bottom line.
Inventory reconciliation has two parts. First, agree the physical count to the stock system by item and investigate variances above a threshold. Second, agree the valued stock report to the inventory balance in the general ledger. Check cut-off on goods received and dispatched around the count date, and review slow-moving or damaged items for write-down.
Both are needed. A perfect count is no use if the ledger has been adjusted by journals that never reached the stock system, and a ledger that agrees to the stock report is no use if the report itself is wrong.
Count by location, using count sheets or scanners that don't show the expected quantity so counters aren't influenced. Freeze movements during the count, or record every movement that happens during it. Then compare:
With item code in A, counted quantity in B, and the system quantity looked up from a second sheet:
C2: =XLOOKUP(A2,System!A:A,System!B:B,0)
D2: =B2-C2
E2: =D2*XLOOKUP(A2,System!A:A,System!C:C,0)
D is the quantity variance and E the value variance, using unit cost from column C of the system sheet. Sort by the absolute value of E and recount the largest variances before posting any adjustment. Also check the other direction: items in the system that weren't found in the count.
Common causes, roughly in order of how often they turn up:
Paired variances (a shortage on one item and a matching surplus on a similar one) usually point to a coding error rather than a real loss.
Run the valued stock report at the period end and compare its total to the inventory account balance. Differences usually come from:
Hold provisions for slow-moving or obsolete stock in a separate account, so the gross balance can still be agreed to the stock report and the provision supported on its own.
Around the count date and the period end, take the last few goods received notes and dispatch notes before the cut-off and the first few after it. Check each was recorded in the correct period, both in stock and in the ledger. See month-end cut-off procedures.
Inventory is normally held at the lower of cost and net realisable value (or a similar test under your accounting framework). Each period, list items with no sales or usage in a set period. With the last movement date in column F and the report date in a named cell ReportDate:
=ReportDate-F2
gives days since last movement. Review the longest-standing items with the operations team and agree a provision or write-off based on evidence, such as recent selling prices or disposal quotes.
UK teams often say "stock" and "stocktake"; US teams say "inventory" and "physical inventory count". Valuation follows your accounting framework, such as IAS 2 under IFRS, FRS 102 in the UK or ASC 330 under US GAAP. Check the current standard for the measurement rules that apply to you.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
At least once a year in full for most businesses, with cycle counts of high-value or high-risk items during the year. Some businesses replace the annual count with a robust cycle-counting programme.
Only after recounting the largest variances and checking cut-off. Adjusting first can hide a coding error that will reappear as a variance on another item.
Usually because of manual journals to the inventory account, cost changes not posted, or a timing difference between when the report was run and the period end.
Last updated 04 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.