When should a small business do a physical stock count?

At minimum on 31 March, because closing stock decides your taxable profit and your CA or auditor needs a verified figure. Businesses with a cash credit or overdraft limit should count monthly to support the bank's stock statement, and shops with fast-moving or high-value goods often count weekly for a handful of key lines.

How is stock variance calculated and what is an acceptable variance?

Variance is the counted quantity minus the system quantity, shown per item in units and, if you like, in value. There is no legal threshold. Many small businesses treat anything within one or two percent of the item's value as normal shrinkage and investigate larger gaps: unrecorded purchases, sales billed without reducing stock, damage, or theft.

Does closing stock have to be physically verified for income tax?

The Income Tax Act does not spell out a counting procedure, but ICDS II and AS 2 require inventory to be valued at cost or net realisable value, whichever is lower, and a tax auditor under Section 44AB reports on how stock was verified. A signed, dated count sheet is the simplest evidence. If unsure, check with your CA.

How do I count stock without closing the shop?

Use cycle counting: count a section or category each day or week instead of everything at once, and record which invoices and purchase bills were made during the count so they can be adjusted. High-value and fast-moving lines get counted more often, slow lines quarterly. Full counts are then needed only at year end.

Should the sheet show the system quantity or be a blind count?

A blind count hides the system quantity so the counter cannot simply copy it, which auditors prefer for high-value stock. For routine monthly counts, showing the system quantity is faster because staff can see and recheck an obvious mismatch on the spot. If you want a blind count, cover or cut off the System Qty column before handing out the sheet.

Why does my system quantity not match the physical stock?

The usual causes are a purchase bill or goods receipt that was never recorded, a sale made on a kacha bill or delivery challan without an invoice, free samples and replacements given out informally, breakage, expiry, and unit confusion (a box recorded as one unit but sold as twelve pieces). Fix the root cause, not just the number.

Stock Count Sheet

Print a stock count sheet from your saved items with SKU, unit, system quantity and blank counted and variance columns for physical audits. Free.

Free account · 3 sheets a month freeMade for India · ₹, GST, UPI, WhatsApp

In short

A stock count sheet is a printed list of every item you hold, with its SKU, unit and system quantity, a blank column for the physically counted quantity and a variance column. VyaparKit's Stock Count Sheet builds it from your saved items in one click, so year-end and monthly counts start from live numbers instead of a retyped Excel list.

Free account required

Create a Stock Count Sheet in under a minute

Sign in once with Google or email. Your business name, GSTIN, logo, bank details and saved customers fill in automatically. Download a PDF or share a link on WhatsApp. 3 sheets a month are free, forever.

Start free See what's free

✓Beautiful PDF with your logo and details
✓GST calculated automatically where applicable
✓Saved customers, vendors and items, so no retyping
✓Share link with WhatsApp button and UPI QR
✓Converts to related documents in one click

About the stock count sheet tool

A stock count sheet (also called a physical verification sheet or stock take sheet) is the working paper you carry through the shop or godown while counting what is actually on the shelf. Indian businesses need one at least once a year, on 31 March, because closing stock decides the profit shown in the books and the income tax return, and auditors under Section 44AB ask how it was verified. Kirana stores, pharmacies and garment shops often count monthly, and any business with a cash credit limit needs a reliable stock figure for the bank's monthly stock statement.

Counting from a hand-made Excel sheet goes wrong in predictable ways. The list is copied from an old file, so new items are missing and discontinued ones are still there. Units are inconsistent (one row in boxes, the next in pieces), the system quantity was typed in last week and is already stale, and the variance is worked out later on a calculator with fresh mistakes. VyaparKit prints the sheet from your saved items: SKU, unit and the current system quantity are filled in, the counted quantity and variance columns are blank, and the sheet is dated.

The system quantity on the sheet is the one VyaparKit maintains for you. Every invoice and delivery challan you create reduces stock, every purchase bill and goods receipt adds to it, so the sheet reflects what the records say as of the moment you print it. After the count, the same items feed the Stock Valuation tool for your balance sheet and bank statement, and the Low-stock Calculator for what to reorder.

How to prepare a stock count sheet in VyaparKit

1
Keep your items list current
Under Items, add every product with its SKU, unit (pcs, kg, box) and opening quantity. Invoices, challans, purchase bills and goods receipts then keep the system quantity moving on their own.
2
Open Stock Count Sheet
Go to Stock, then Stock Count Sheet. Every saved item is listed with SKU, unit and the system quantity as of now. Choose the count date you want printed on the sheet.
3
Download and print
Click Download PDF. The sheet has blank Counted Qty and Variance columns and space for the counter's name and signature. Print one copy per rack or counter if several people are counting.
4
Count on the floor
Write the physical quantity against each row in the unit shown. Count sealed cartons as full and open ones by piece, and note damaged or expired stock separately so it is not treated as saleable.
5
Work out variances and fix the records
Variance is counted minus system. Investigate anything large before adjusting: a missing purchase bill or an invoice made without stock reduction explains most gaps. Correct the item quantities so the next count starts clean.

What a good stock count sheet has

Item name and SKU or item code, so two similar products are never confused.
Unit of measure matching how you count on the floor (pieces, kg, litres, boxes, with pack size if a box holds many pieces).
System quantity as on the count date, taken from records that already reflect the latest invoices and purchase bills.
A blank Counted Qty column, filled in by hand during the count, never pre-filled.
A Variance column (Counted minus System) with room for a short reason: damage, expiry, sample, unbilled sale, unrecorded purchase.
Count date, location or rack, and the name and signature of the person counting; auditors ask for exactly this.
Batch number and expiry for pharma, FMCG and cosmetics, where expired stock must be excluded from closing stock.
A cut-off note: stop billing and receiving during the count, or record which invoices and purchase bills are after the cut-off.

Who uses the stock count sheet

Kirana and general stores

A monthly count of fast-moving lines (oil, atta, sugar, biscuits) catches pilferage and unbilled sales early. The shop prints the sheet on the last Sunday, two staff count, and variances above a few units get a second look.

Medical stores

A pharmacy in Nagpur counts by batch and expiry so near-expiry strips are pulled and returned to the distributor before they become dead stock, and the closing stock given to the CA excludes expired items.

Garment and footwear shops

Size-and-colour SKUs make counting painful. Listing each SKU with the system quantity lets the owner spot where a size has vanished without a sale, which is usually a billing error rather than theft.

Small warehouses and D2C brands

A D2C brand with 150 SKUs in a rented godown prints a sheet per rack, has the packer and the supervisor count independently, and reconciles the variances against Shiprocket dispatches for the month.

Stock Count Sheet: frequently asked questions

When should a small business do a physical stock count?: At minimum on 31 March, because closing stock decides your taxable profit and your CA or auditor needs a verified figure. Businesses with a cash credit or overdraft limit should count monthly to support the bank's stock statement, and shops with fast-moving or high-value goods often count weekly for a handful of key lines.
How is stock variance calculated and what is an acceptable variance?: Variance is the counted quantity minus the system quantity, shown per item in units and, if you like, in value. There is no legal threshold. Many small businesses treat anything within one or two percent of the item's value as normal shrinkage and investigate larger gaps: unrecorded purchases, sales billed without reducing stock, damage, or theft.
Does closing stock have to be physically verified for income tax?: The Income Tax Act does not spell out a counting procedure, but ICDS II and AS 2 require inventory to be valued at cost or net realisable value, whichever is lower, and a tax auditor under Section 44AB reports on how stock was verified. A signed, dated count sheet is the simplest evidence. If unsure, check with your CA.
How do I count stock without closing the shop?: Use cycle counting: count a section or category each day or week instead of everything at once, and record which invoices and purchase bills were made during the count so they can be adjusted. High-value and fast-moving lines get counted more often, slow lines quarterly. Full counts are then needed only at year end.
Should the sheet show the system quantity or be a blind count?: A blind count hides the system quantity so the counter cannot simply copy it, which auditors prefer for high-value stock. For routine monthly counts, showing the system quantity is faster because staff can see and recheck an obvious mismatch on the spot. If you want a blind count, cover or cut off the System Qty column before handing out the sheet.
Why does my system quantity not match the physical stock?: The usual causes are a purchase bill or goods receipt that was never recorded, a sale made on a kacha bill or delivery challan without an invoice, free samples and replacements given out informally, breakage, expiry, and unit confusion (a box recorded as one unit but sold as twelve pieces). Fix the root cause, not just the number.

Guides from the blog

Accounting13 Sept 2026 11 min

Financial year-end closing checklist for small businesses: what to do by 31 March

A March 31 checklist covering stock count, debtor and creditor confirmations, TDS matching with 26AS and AIS, GST reconciliation with GSTR-1, 3B and 2B.

Read the guide →