Reconciling Year-End Inventory With Your Books

Counting your stock is only half the job. The other half is making the number on the shelves agree with the number in your accounts. Reconciling year-end inventory with your books turns a pile of count sheets into a figure you can trust for your tax return, your margins and your buying plans for the year ahead.

By early February, most businesses with a calendar year end have finished their stock count. Then the bookkeeper asks the question that starts the real work: "Why does the count say one thing and the ledger say another?"

That gap is normal. Almost no business finishes a year with a perfect match between physical stock and the books. What matters is that you understand the gap, correct what needs correcting and leave a trail that explains your decisions. This guide covers the counting itself only in passing and focuses on what happens after: matching, investigating, adjusting and learning from the result.

A quick note: this article is general information about bookkeeping, not accounting or tax advice. Inventory rules differ between the US, the UK and other countries, and between small and larger businesses, so check with your accountant before you finalize your figures.

Why the count and the books rarely match

Your accounting system holds a running idea of what you own. It adds stock when purchases are recorded and removes it when sales are recorded. Your physical count tells you what is really there. The two drift apart for predictable reasons.

• Timing and cutoff: goods arrived before year end but the bill was entered in January, or a sale was shipped in January but recorded in December.
• Goods in transit: stock you own that was on a truck, at a supplier or in a courier depot on count day.
• Returns: customer returns put back on the shelf but never recorded, or supplier returns sent back but still in the books.
• Damage, spoilage and loss: items thrown away, used as samples or lost without a record.
• Unit of measure errors: a case of 12 counted as 1, or 12 cases entered as 12 units.
• Costing errors: the right quantity at the wrong unit cost, which makes the value wrong even when the count is right.
• Count mistakes: skipped shelves, double counts and typos on the sheets.

Gather what you need before you start

Reconciliation is much faster when everything is in one place. Pull these together before you open a single spreadsheet:

• Final count sheets or the export from your count app, with item codes, quantities and locations
• An inventory valuation report from your accounting or inventory system dated on the last day of the year
• The inventory balance from your general ledger or balance sheet on the same date
• Purchase invoices and delivery notes for the last few weeks of the year and the first few weeks of the new one
• Sales invoices and shipping records for the same window
• Records of customer returns, supplier returns, write-offs and samples
• Your costing method, such as FIFO or weighted average, and any standard costs you use

How to reconcile, step by step

Work from big to small. Start with the totals, then narrow down to the items that explain the gap.

1. Check the three totals. Compare the value from your count, the value in your inventory report and the inventory balance in your general ledger. If the inventory report and the ledger do not agree, fix that first, because it points to a posting problem rather than a stock problem.
2. Match quantities by item. Put the counted quantity next to the system quantity for each item code and calculate the difference in units.
3. Value each difference. Multiply each unit difference by the unit cost to see which gaps matter in money terms.
4. Sort by size. Rank the differences from largest to smallest value. A small number of lines usually explains most of the gap.
5. Investigate the big ones. For each large difference, check cutoff, transit, returns, units of measure and count sheets, in that order.
6. Recount where needed. If a difference still makes no sense and the stock is still there, recount it and adjust for movements since count day.
7. Decide and document. For each line, record whether the count or the books were wrong, and why.
8. Post the adjustment. Make one adjusting entry for the remaining difference, with notes, and get it reviewed.

Set a materiality threshold

You do not need to chase every single unit. Before you start, agree a threshold with your accountant, for example "investigate any line over a set value or a set percentage of the item's total." Lines under the threshold can be adjusted in bulk with a note. This keeps the work proportionate for a small team.

Inventory reconciliation template

Copy this layout into a spreadsheet. The figures are made up for illustration.

Notice that the third line was not a real loss at all. Unit of measure slips often create the biggest, scariest differences, and they are the easiest to fix.

Getting cutoff right

Cutoff is the single biggest source of reconciliation headaches. The goal is simple: stock and the matching purchase or sale should land in the same year.

Purchases

If goods arrived and were counted before year end, the purchase should be recorded in the old year too, even if the supplier's bill came later. If the bill was entered in December but the goods arrived in January, they should not be in your closing stock, and the purchase may need moving or accruing. Check your shipping terms as well, because ownership can pass when goods leave the supplier rather than when they reach you.

Sales

If you shipped an order on 31 December and recorded the sale, the goods should not be in your count. If you recorded the sale but the goods were still on your shelf, you either count them and reverse the timing, or exclude them and keep the sale, depending on when ownership passed to the customer. Your accountant can help you apply this consistently.

Valuing what you counted

The quantity is only half of the inventory figure. The other half is the cost you assign to each unit.

• Use your normal costing method consistently. FIFO and weighted average are common for small businesses. Some methods are only allowed in certain countries, so check what applies to you.
• Check unit costs for outliers. A unit cost that is ten times higher or lower than usual often points to a typing error on a purchase bill.
• Include the right costs. Depending on your accounting rules, inventory cost can include freight in and some other costs of getting goods ready to sell. Ask your accountant what you should include.
• Review slow and damaged stock. Items that cannot be sold at a price above their cost may need writing down. Accounting rules generally require inventory to be shown at no more than what you can realistically recover, so flag these items and discuss them with your accountant.

Posting adjustments and closing the loop

Once you know the true difference, record it cleanly. Your accountant may prefer a particular approach, but the usual pattern is an adjustment between inventory on the balance sheet and cost of goods sold, or a separate inventory adjustment or write-off account, so the effect on profit is visible.

• Post one dated entry, or a small number of grouped entries, rather than dozens of tiny ones.
• Attach or link the reconciliation spreadsheet to the entry.
• Write a short memo: what the difference was, what caused it and who approved the adjustment.
• Check that your inventory report, ledger and balance sheet now agree.
• Lock the period in your accounting software once your accountant is happy, so no one changes it by accident.

Because closing inventory feeds directly into cost of goods sold, every adjustment changes your gross profit. That is why accountants care so much about this one number, and why it is worth taking the time to get it right before tax returns are prepared.

Use the result to sharpen your metrics

Once your closing figure is clean, you can calculate useful measures with confidence. Inventory turnover, for example, is cost of goods sold divided by average inventory. A wrong closing balance distorts that ratio and every buying decision you base on it.

Preventing next year's headaches

The best reconciliation is a boring one. A few habits during the year make the next close much easier.

• Record damage, samples and staff use on the day they happen.
• Enter supplier bills promptly, and match them to delivery notes.
• Use consistent units of measure across purchasing, receiving and selling.
• Run small cycle counts of high-value items during the year.
• Freeze stock movements, or carefully track them, on count day.
• Keep your records for as long as your tax authority requires. In the US, the IRS generally expects records to be kept for at least 3 years after filing, and longer in some cases. In the UK, companies keep records for 6 years from the end of the financial year.

Frequently asked questions

The bottom line

Reconciling year-end inventory with your books means matching the count to the ledger, explaining the large differences, fixing cutoff and costing errors and posting one clean, documented adjustment. It protects your profit figure, your tax return and the buying decisions you will make this year.

Set aside a focused afternoon, work from the biggest differences down and leave yourself good notes. Next year's close will be faster, calmer and far less of a mystery.