The Importance of Keeping Stock Control Records (and What Bad Ones Cost You)

The importance of keeping stock control records comes down to proof: they show what you hold, where it came from, where it went and what it is worth, so the accounts, the buyers and anyone handling a recall can act on the same facts. For a UK company that deals in goods, some of those records are also a legal requirement, not just good practice.

The practical problem is that most businesses keep some stock records but not the right ones, or not accurately. A year-end stock figure with no count sheets behind it, a reorder decision made on a balance nobody trusts, or a supplier recall that takes days to trace all come from the same gap: records that were never designed to answer the questions the business would one day be asked.

A stocktake is only as useful as the records it is checked against. Illustrative photograph, not an OpsMavix project.

Image credit: Lagos Food Bank Initiative, Pexels License. No edits.

Key Takeaways

• Stock control records support four jobs: the accounts, purchasing, sales promises and traceability.
• UK companies dealing in goods must keep year-end stock statements and the stocktakings behind them.
• A wrong closing stock figure moves reported profit pound for pound.
• Reorder decisions are only as good as the balance they are triggered from.
• Traceability depends on recording suppliers, batches and customers at the time goods move.
• Keep the source documents as well as the balances, for at least the longest retention period that applies.

In this guide:

• 1. Understand the Four Jobs Stock Records Do
• 2. Know the UK Record-Keeping Rules
• 3. Support Year-End Accounts and the Stocktake
• 4. Buy at the Right Time From Reliable Balances
• 5. Trace Batches Suppliers and Customers
• 6. Decide Which Stock Records to Keep
• 7. Compare Ways of Keeping Stock Records
• 8. Keep the Records Accurate Between Counts
• Frequently Asked Questions
• How OpsMavix Can Help

1. Understand the Four Jobs Stock Records Do

One set of records, several users

A stock record is the running account of an item: its opening balance, every movement in and out, and the quantity and value left. Our guide to what a stock record is covers the fields and types in detail. This guide focuses on why keeping them matters and which records to retain.

Different people rely on the same records for different decisions:

Accuracy is the condition for all four

Every one of those jobs assumes the balance matches the shelf. A record that is quietly wrong is more dangerous than an obviously missing one, because people act on it with confidence. If your figures have already drifted, why the stock never matches the system covers the common causes.

2. Know the UK Record-Keeping Rules

What the Companies Act requires

Section 386 of the Companies Act 2006 requires every company to keep adequate accounting records. Where the business involves dealing in goods, subsection (4) says the records must contain:

1. Statements of stock held at the end of each financial year.
2. All statements of stocktakings from which those year-end statements have been or will be prepared.
3. Except for goods sold by way of ordinary retail trade, statements of all goods sold and purchased, showing the goods and the buyers and sellers in enough detail to identify them.

The gov.uk guidance on company accounting records lists the same items in plain English: stock owned at the end of the financial year, the stocktakings used to work out the stock figure, all goods bought and sold, and who you bought and sold them to and from (unless you run a retail business).

How long to keep them

In practice, the longest period that applies to you sets the policy. A private limited company registered for VAT, for example, would plan around 6 years rather than the 3-year Companies Act minimum. Your accountant should confirm the position for your entity and any sector rules.

How stock is valued for tax

HMRC’s Business Income Manual (BIM33115) recognises two valuation bases for stock: the lower of cost or net realisable value, and mark to market. Either way, the value depends on reliable quantities and costs, which is what the stock records provide.

3. Support Year-End Accounts and the Stocktake

Why closing stock moves profit

Cost of sales is usually calculated as opening stock plus purchases minus closing stock. Every pound of error in closing stock therefore becomes a pound of error in gross profit.

Hypothetical worked example: an overstated closing stock

A hypothetical wholesaler has sales of £400,000, opening stock of £60,000 and purchases of £250,000. Its records show closing stock of £78,000, but a properly reconciled count shows £70,000, because damaged goods and unrecorded issues were never written off.

The £8,000 overstatement of stock overstates gross profit by exactly £8,000 (168,000 - 160,000). Because this year’s closing stock becomes next year’s opening stock, an error left uncorrected also affects the following year’s profit.

What a supportable stocktake needs

A year-end figure is easier to support when the count and the records meet cleanly:

• Count sheets that are signed, dated and kept, not discarded once totals are typed up.
• A clear cut-off so goods received or dispatched around the count date are recorded in the right period.
• Variances investigated and adjustments approved, with reasons recorded.
• Damaged, obsolete and slow-moving lines identified for valuation review.
• The final valued listing tied back to the count sheets.

Our physical stocktaking procedure walks through preparing, counting and reconciling in detail.

4. Buy at the Right Time From Reliable Balances

Balances drive purchasing decisions

A reorder point tells a buyer when to order, but it is triggered by the recorded balance. If that balance is too high, the trigger fires late; if it is too low, the business buys stock it already has. Purchasing also needs open purchase orders and committed customer orders recorded alongside on-hand stock, otherwise buyers double-order or miss demand.

Hypothetical worked example: a late reorder

A hypothetical item sells 12 units a day. The supplier lead time is 10 days and the business holds 40 units of safety stock, so the reorder point is (12 x 10) + 40 = 160 units.

The record shows 175 units, so no order is raised. The shelf actually holds 100, because 75 units of returns, breakages and mis-picks were never recorded.

• The record falls from 175 to the 160 trigger after 15 more units are sold, which takes 15 / 12 = 1.25 days.
• By then the true stock is 100 - 15 = 85 units.
• The order arrives 10 days later, but 85 units cover only 85 / 12 = about 7.1 days of sales.
• Demand during the lead time is 12 x 10 = 120 units, so the business is short by 120 - 85 = 35 units.

The reorder rule was correct. The record was not, so the safety stock was gone before anyone knew. Accurate balances, plus regular inventory cycle counts on fast movers, are what make reorder points trustworthy.

Purchasing records checklist

• Purchase orders with item, quantity, price and expected date.
• Goods received notes recording what physically arrived (see what a goods received note is).
• Supplier invoices matched to the order and receipt.
• Returns to supplier and credit notes.
• Supplier lead times and minimum order quantities, kept up to date.

Recording movements where the stock is handled keeps balances closer to the shelf. Illustrative photograph, not an OpsMavix project.

Image credit: Tiger Lily, Pexels License. No edits.

5. Trace Batches Suppliers and Customers

When traceability is a legal duty

For food and feed businesses, traceability is not optional. Article 18 of Regulation (EC) No 178/2002, as published on legislation.gov.uk, requires operators to be able to identify any person from whom they have been supplied, and to have systems and procedures to identify the other businesses to which their products have been supplied, with that information available to the competent authorities on demand. Other sectors have their own rules, and many customers impose traceability through contracts even where no law requires it.

Even outside regulated sectors, the s386 requirement to identify buyers and sellers (other than in ordinary retail trade) means non-retail companies already need much of the supplier and customer link.

Hypothetical worked example: tracing one lot

A hypothetical distributor receives 500 units of lot L-0421. A supplier later reports a labelling fault on that lot. Because each dispatch recorded the lot number, the records show:

The arithmetic ties: 120 + 200 + 90 = 410 dispatched, and 500 - 410 = 90 left in stock. The business can quarantine 90 units and contact three customers. Without lot numbers on dispatches, it would have to contact every customer who bought that product in the period and quarantine all of its stock.

What traceability records need

• Batch or lot number captured at goods receipt.
• Expiry or best-before dates where relevant.
• Lot recorded on every issue to production, dispatch and return.
• Links between input lots and finished lots for manufacturers.
• Supplier and customer identities on every movement.

Batch and lot tracking covers the mechanics in more depth.

6. Decide Which Stock Records to Keep

A practical retention list

The balance alone is not enough. The supporting documents explain how the balance was reached, which is what an accountant, auditor or HMRC enquiry will ask.

Retention checklist

1. Identify every rule that applies to you (company law, HMRC, VAT, sector rules, customer contracts).
2. Set the retention period to the longest of them.
3. Keep source documents, not only summaries.
4. Make records retrievable by item, date, supplier, customer and batch.
5. Protect against loss with backups and access controls.
6. Record who made each adjustment and when.

7. Compare Ways of Keeping Stock Records

Matching the approach to the operation

Packaged inventory software can be a good fit where your processes match its design. A custom application earns its place when the records you need are specific to your operation. Either way, judge options against the records listed in section 6 and against a real month of your movements, not a generic demo.

8. Keep the Records Accurate Between Counts

Make recording part of the work

Records drift when updating them is a separate task done later. They stay closer to the shelf when the movement and the record happen together: receiving against the purchase order, scanning at pick, recording the lot at dispatch, and logging breakages when they are found.

Accuracy routine checklist

• Record receipts, issues, transfers and returns at the time they happen.
• Require a reason code on every adjustment.
• Run cycle counts on high-value and fast-moving lines between full stocktakes.
• Investigate variances by type, using a guide such as types of stock discrepancies.
• Review on-hand against available stock before promising large orders.
• Measure accuracy as the share of counted lines that match the record within tolerance.

Hypothetical worked example: measuring record accuracy

In a hypothetical month, a business cycle counts 250 lines and 230 match the record. Record accuracy is 230 / 250 = 92%. If 15 of the 20 mismatches trace back to returns being shelved without being booked in, fixing that one process would have lifted accuracy to 245 / 250 = 98% for that sample.

Frequently Asked Questions

Why is keeping stock control records important?

They let the business prove what it holds, what it is worth and how it moved. That supports accurate accounts, timely purchasing, reliable sales promises and traceability. For UK companies that deal in goods, certain stock records are also required by the Companies Act 2006.

Are UK companies legally required to keep stock records?

Yes, where the business involves dealing in goods. Section 386(4) of the Companies Act 2006 requires statements of stock held at each financial year end, the statements of stocktakings behind them, and (except for ordinary retail trade) statements of goods bought and sold identifying the buyers and sellers.

How long should stock records be kept?

Private companies must keep accounting records for 3 years under the Companies Act, but HMRC requires company records for 6 years from the end of the financial year they relate to, and VAT records for at least 6 years. Sole traders must keep records for at least 5 years after the 31 January submission deadline. Use the longest period that applies.

What records should a stocktake produce?

Signed and dated count sheets, a cut-off record, a list of variances with approved adjustments and reasons, and a final valued stock listing that ties back to the counts. Keep all of them, not just the final total.

What happens if closing stock is wrong?

Gross profit moves by the same amount. Overstated closing stock overstates profit, and understated closing stock understates it. Because closing stock becomes next year’s opening stock, an uncorrected error also affects the following year.

Is a spreadsheet good enough for stock records?

For a small range, one location and same-day entry, it can be. It becomes risky when several people update stock, when you need batch traceability, or when entries are made long after the movement.

Do I need batch or lot records?

If you handle food or feed, you must be able to identify suppliers and the businesses you supplied. Many other sectors and customers expect batch traceability too. If a recall would force you to contact every customer, lot-level records are worth keeping.

Can OpsMavix build a stock record system?

Yes. OpsMavix can build focused applications or a full custom ERP, and can configure or integrate suitable existing tools where those approaches fit the requirements.

How OpsMavix Can Help

OpsMavix can review how stock moves through receiving, storage, sales and returns, and define which records each step needs to create so year-end figures, reorder decisions and traces rest on the same history.

That may mean configuring tools you already use, connecting them, or building an inventory automation system around your processes. For makers, manufacturing production tracking links material lots to finished output, and wholesalers can tie stock to orders through a wholesale order management system.

Contact OpsMavix with one recent stocktake variance, the records behind it and the handoff that creates the most rework. We can use that evidence to define requirements and a practical pilot.