How to record physical counts and opening balances
Year end is when small errors from the whole year come due: stock on the shelf does not match the books, a few invoices are dated into the wrong year, and the new year starts with numbers nobody trusts. This guide shows how to plan a physical count, record it, close the accounts and open the next year cleanly.
The example is an electrical goods wholesaler in Ludhiana with about 1,800 stock items in one godown and a financial year that ends on 31 March.
Why this matters
Closing stock feeds directly into your profit, so a counting mistake of even a few lakh rupees changes the profit you report and the tax and bank decisions that follow. An opening balance that is carried over wrongly spoils every month of the new year. A tidy, documented year end also saves your accountant days of questions and gives you a base to compare against next year.
Before you start
- The stock list from your books, by item and quantity, printed or exported on the count date.
- Count sheets, numbered and signed out, plus a rule on who counts and who checks.
- A cut-off rule: the last invoice, delivery challan and goods receipt that belong to the old year.
- Last year's closing balances for customers, suppliers, bank, loans and stock.
- Names for the finance lead, stores lead and the owner who approves closing entries.
Step by step
- Plan the count and the cut-off. The finance lead picks the count date, ideally when the godown is quiet, and decides how goods in transit, goods held for customers and goods lying with third parties will be treated. For the wholesaler, nothing moves in or out during the count, and the last challan and goods receipt numbers are written down at the start.
- Count in pairs and record on sheets. The stores lead organises counts in pairs, one person counting and one recording, with a second person re-counting high-value items. Damaged, expired or slow-moving items are listed separately with a short reason, because they may need a different value.
- Compare with the books and resolve differences. The finance lead matches each counted quantity to the book quantity, and every difference above an agreed limit is traced: a missed receipt, an unposted sale, a wrong item code, a theft. Anything that stays unresolved is recorded with an explanation, not rubbed out.
- Value the stock and approve closing entries. The stores lead signs the count and the finance lead prepares the stock valuation using the method you follow every year. The owner reviews the differences, approves adjustments to stock, write-offs and any other year-end entries, and the accountant posts them as dated closing journals.
- Check late invoices and document numbers. Before the books are locked, the finance lead scans for sales and purchase bills dated in the old year but entered late, and confirms that the numbering of invoices and receipts for the new year starts as you have decided. A new series should be set up deliberately, not by accident.
- Carry forward balances and review renewals. The accountant confirms that opening balances in the new year equal the closing balances of the old one. The stores lead and finance lead then list insurance, licences, annual contracts and warranties that fall due in the new year and file the count sheets and approvals for the period you must keep them.
Rules on how invoices are numbered, how long records must be kept and how stock is valued for tax can differ by registration and by business type. Check the current rule on the official portal or with your CA before acting.
Who does what
| Role | What they do | Record they own |
|---|---|---|
| Finance lead | Plans cut-off and count, resolves differences, checks numbering for the new period | Physical count and number series |
| Stores lead | Runs the count, signs the count sheets, prepares the renewal schedule | Stock valuation and renewal schedule |
| Owner | Reviews differences and approves closing entries | Closing journal approval |
Common mistakes
- Counting while goods are still moving, then spending weeks explaining differences that were just timing.
- Letting the person who keeps the stock records also do the only count.
- Posting closing entries without a written reason for each adjustment.
- Recording a March delivery in April's books, or the reverse, because the cut-off was never agreed.
- Starting the new year with the old year's invoice series still running, or with duplicate numbers across branches.
How to tell it is working
- Unresolved count difference. After the count and the investigation, list the items where counted and book quantity still differ, and multiply each by its cost. The total should be small and every line should have a note.
- Late invoice. Count bills dated in the old year that were entered after the books were locked, and compare it with the previous year. The count should fall.
- Wrong number series. Check a sample of new-year invoices and receipts and count how many carry a number from the old series or a number already used. The answer should be zero.
Questions people ask
Who owns year end?
The finance lead owns the plan and the closing checklist, with the owner approving the entries. The stores lead owns the count itself, since the person who looks after the goods must sign for what was found.
What is the minimum record for year end?
Keep the signed count sheets, the comparison with book stock, a note on each difference, the valuation, the approved closing journals and a list of opening balances. With these, your accountant or an auditor can follow what you did without calling you.
When should a case stop?
A count difference stops when it has either been explained and corrected or written off with approval. Anything still open at the date you lock the books should be carried forward as a named item to resolve, never left unexplained.
Can a spreadsheet support this stream?
Yes, a count sheet and a comparison sheet with quantity, book quantity and difference columns is an ordinary way to do it. Keep the original sheets as well as the typed copy, and never overwrite last year's file.
What should the owner review?
Read the list of unresolved differences, the largest adjustments, late invoices and the check on new document numbers. Also confirm that the opening balances match last year's closing ones before the new year's entries begin.