Inventory reconciliation template in Excel
Compare what you counted with what the books say, item by item, explain every variance that matters and get the adjustment approved before it is posted. This inventory reconciliation template is one Excel workbook with variance analysis by quantity and value, a cut-off list and a summary for the approver.
Finance teamsGet this pack and 51 more for $79
Want every pack, for every region? Global library, 110 packs, $99
What the workbook looks like

When you need an inventory reconciliation
An inventory reconciliation compares the physical count with the stock records on the count date and explains the difference before the books are adjusted. A UK company that deals in goods must keep statements of stock held at each year end and the stocktaking records they come from. Use this one when:
- You have just finished a year-end or periodic stock take
- The stock figure in the ledger has drifted from the stock system
- Large write-offs are posted without anyone saying why
- Your auditor wants to see how count differences were explained and approved
How to use the inventory reconciliation template
- Fill in Settings. Company, count date, currency and the value and % limits above which a variance has to be explained.
- Enter each item. Item code, description, unit, unit cost, book quantity and counted quantity. Values and variances work themselves out.
- Explain the large variances. Pick a reason from the list for every row over tolerance and write a short explanation, such as a missing display unit reported to the site manager.
- List the cut-off items. Goods received, issued or dispatched around the count date that were booked in the wrong period, with the document number and value.
- Get it approved. Check the variance by reason agrees to the net variance, then the approver signs and dates it before the journal is posted.
Questions
What is inventory reconciliation?
Matching the stock you physically counted with the quantities and values in your records, then finding out why they differ. It ends with an approved adjustment that brings the books in line with the count.
How do you do an inventory reconciliation?
List each item with its book and counted quantity, value both at unit cost, and work out the variance. Investigate the variances over your tolerance, check cut-off around the count date, give each one a reason and post the approved adjustment.
What causes inventory discrepancies?
Counting errors, goods received or sold but not booked, cut-off errors around the count date, damage, loss or theft, items counted in the wrong unit of measure and wrong unit costs.
What is the difference between net and gross variance?
Net variance adds the gains and losses together, so they can cancel out. Gross variance adds up every difference ignoring the sign, which shows how accurate the records really are.
Do companies have to keep stocktaking records?
Yes, in the UK. A company whose business involves dealing in goods must keep statements of stock held at the end of each financial year and all the stocktaking statements those figures were prepared from.
Also in the stock count pack
Who it's for
Finance teams and practices running year-end or periodic stock takes for businesses that hold stock.
Last checked
Checked against the Companies Act 2006 accounting records rules in November 2026.
