How to do a stock count and adjust your books

Your records say you have 120 units, the shelf says 112. Here is how to count stock and fix the books.

By the AvrioBooks team · · 6 min read

How to do a stock count and adjust your books

If you hold stock, the number in your books and the number on your shelves will drift apart over time, through theft, damage, mistakes and miscounts. A regular stock count (stock-take) finds the difference and lets you correct it. It also matters for your profit, because the value of closing stock affects your accounts. This guide is general information.

Why count stock

  • You find missing, damaged or out-of-date stock.
  • Your profit is more accurate.
  • You avoid running out of fast sellers, or over-ordering slow ones.
  • Your year-end accounts and tax figures are right.

Plan the count

  1. Choose a quiet time, such as the end of the month or the year.
  2. Print or export your current stock list.
  3. Stop receiving and shipping during the count, or record what moves.
  4. Divide the space into areas so nothing is counted twice or missed.

Counting methods

  • Full count: count everything at once. Simple but disruptive. Best once a year.
  • Cycle counting: count a small section every week, so everything is counted over a few months.
  • Spot checks: count the highest-value or fastest-moving lines more often.

Count carefully

  • Count in pairs, one counting and one recording.
  • Record what you count, not what the list says.
  • Mark counted items so they are not counted twice.
  • Note damaged or expired items separately.

Investigate the differences

Compare counted quantities with your records. For each difference, ask whether it is a miscount, a late entry (a sale or delivery not yet recorded), damage, theft or a data error. Recount anything large before you adjust.

Record the adjustments

Once you are confident in the count, enter stock adjustments to bring your records into line, with a reason for each. Write-offs reduce the value of your stock and show up as a cost.

Value your stock

Your stock is normally valued at cost, or net realisable value if that is lower. AvrioBooks uses weighted-average costing, so the value of what is left updates with every purchase and sale.

After the count

  1. Review the biggest variances and fix the cause.
  2. Update reorder levels.
  3. Lock the period so the adjusted figures do not change.

Read our guide to stock and cash around Christmas.

How AvrioBooks helps

Inventory on the Premium plan tracks quantities, weighted-average costs, stock valuation and movements, and lets you record adjustments after a count. See inventory management software and products, services and inventory.

Frequently asked questions

How often should I count stock?

At least once a year for your accounts. Many businesses also do cycle counts of a section each week, or spot checks on high-value lines.

What should I do if the count differs from my records?

Recount large differences, check for late entries, then record stock adjustments with a reason for each.

How is stock valued?

Normally at cost, or net realisable value if lower. AvrioBooks uses weighted-average costing.

Does AvrioBooks track stock?

Yes. Inventory is on the Premium plan, with stock valuation, movements and adjustments.

Written by the AvrioBooks team. We build cloud accounting software for small businesses, freelancers and their accountants, from Qodexify. This article is general information, not tax, legal or financial advice. Check GOV.UK or ask an accountant about your own situation.
Try AvrioBooks free Start a 30-day free trial with everything in Premium, no card needed. Start free trial
Newsletter

Accounting tips, tax dates and product news

Practical bookkeeping, VAT and Making Tax Digital guidance for freelancers and small businesses, plus AvrioBooks updates.

By subscribing you agree to receive emails from AvrioBooks. Unsubscribe at any time. See our privacy policy.

Sign up freeContact us