| By Stockount

It's month-end. Finance needs the closing stock value by Friday to close the books. Operations has already promised a distributor 500 cartons for Monday's dispatch. The inventory manager walks the racks with a printout and finds 430.
Everyone trusted the same number. The system said 500. Now nobody can say whether the missing 70 were sold without being billed, moved to another branch without a transfer entry, damaged and never written off, or never received at all. Finance has a stock figure it can't sign off. Operations has a customer to call. The inventory manager has a weekend of recounting ahead.
This isn't only a small-business problem. In 2025, independent accountants counted a sample of 233 items at the City of San Diego's central store, which runs on SAP. 100 of them did not match the system records (City of San Diego report). A good ERP records transactions; it can't confirm what's actually on the shelf.
A stock audit is how you close that gap: count what's physically there, compare it with the books, explain every difference and fix the records. It gives operations stock they can promise, gives the inventory team numbers they can trust, and gives finance a closing stock value they can defend to auditors. The process is the same whether you run a liquor store, an FMCG distribution warehouse, a pharmacy or ten branches.
This guide walks through how to do a stock audit step by step, how often you should audit based on your business, and where manual methods start to break down. If you're counting across several locations, we'll also cover how inventory audit software can take the spreadsheet work out of the process, and what to look for if you're evaluating one.
An inventory audit (also called a stock audit) is the process of physically checking the stock you have and comparing it with what your records say you should have.
It's more than counting boxes. A proper audit also checks:
In short, an inventory audit answers one question: can we trust our inventory numbers?
Stock audit vs inventory audit: in everyday use the two terms mean the same thing. "Stock audit" is more common in India and the UK; "inventory audit" is more common in the US. Some auditors use "inventory audit" for the broader review that includes valuation and controls, and "stock count" for the physical counting part.
Even good inventory software is only as accurate as the data going into it. Goods get received without being scanned, sales get billed to the wrong SKU, and items get moved without a transfer entry. Over weeks, these small gaps add up.
Regular audits protect you in six practical ways:
Audits also improve day-to-day operations. When teams trust the numbers, they spend less time searching for missing items and less time fixing mistakes after the fact.
The process below works whether you're auditing one stockroom or twenty branches. The tools change; the logic doesn't.
Start by deciding why you're auditing. Is it a year-end physical count, a theft investigation, a reconciliation before an ERP migration, or a routine cycle count? The goal decides the scope.
Then prepare your records:
A messy store produces a messy count. Before counting:
For multi-location businesses, assign audits by branch or warehouse, with one owner per site.
Real example (2025): On 1 June 2025, Maharashtra's Food and Drug Administration suspended the food business licence of a Zepto dark store in Dharavi, Mumbai. Inspectors reported expired products kept alongside fresh stock, along with fungal growth and cold storage units that were not holding the required temperature (Storyboard18). The store resumed operations about two weeks later, after corrective action (Angel One).
The takeaway for any business holding food, medicines or cosmetics: an audit that only checks quantity would have missed this. Separating expired and near-expiry stock, and recording condition during the count, is what catches the problem before an inspector or a customer does.
Count everything in scope, using barcode scanners, mobile devices or manual tally sheets depending on your setup.
A few practices make counts more reliable:
Once counting is complete, compare the physical count with the book stock for every item.
For example, a mobile accessories retailer finds:
| SKU | Book stock | Physical count | Variance |
|---|---|---|---|
| USB-C cable 1m | 120 | 112 | –8 |
| 20W charger | 45 | 45 | 0 |
| Tempered glass (Model X) | 60 | 74 | +14 |
Not every variance is a loss. A positive variance usually means a receipt wasn't recorded or stock was billed under the wrong SKU.
Sort variances by impact rather than by count. A shortage of 3 laptops matters more than a shortage of 30 pens.
Useful ways to prioritize:
Set a tolerance level (for example, accept small variances on low-value consumables) so the team spends time on what matters.
Real example (2025): In the City of San Diego's fiscal-year-2025 central stores review, published in October 2025, independent accountants from Crowe LLP physically counted 233 sampled stock items at the Chollas store, which tracks inventory in SAP (City of San Diego report).
| Result | Items | Units | Value |
|---|---|---|---|
| In the system but not on the shelf (overstated) | 56 | 363 | $14,705 |
| On the shelf but not in the system (understated) | 44 | 624 | $12,812 |
| Net difference | 100 of 233 items | — | $1,893 overstated |
On paper, the net gap was under $1,900. In reality, the mismatch ran in both directions and added up to more than $27,500. Overages and shortages cancel each other out in a net figure, hiding two separate problems: stock that went missing, and stock that was received or moved without being recorded.
The lesson: always review gross variances, not just the net. And notice that the store already used an ERP; system records still drifted from the shelf, which is exactly why physical audits remain necessary.
This is where an audit becomes useful instead of just a count. For each significant variance, ask what actually happened.
Common causes include:
Recount before investigating further. Many "discrepancies" turn out to be counting errors.
Once causes are confirmed:
That audit trail matters. It shows statutory auditors what was checked, and it gives you a baseline to compare against next time.
There's no single right answer. Most businesses use a mix: frequent small checks on high-risk items, and one full physical count each year. Here's how each frequency is typically used.
Daily checks are short spot counts, not full audits. They suit:
A counter can check 10–20 critical SKUs at opening or closing in a few minutes.
Weekly audits work well for fast-moving retail, FMCG distribution and pharmacies. Many teams run them as cycle counts: a different group of SKUs or bins is counted each week, so the whole store is covered over a month or quarter without shutting down operations. Read more about cycle counting.
Monthly audits suit most growing SMEs and distributors. They're frequent enough to catch problems before month-end closing, and they line up with financial reporting. A common approach is to audit all A-class items (high value) monthly and B/C items less often.
Quarterly audits suit businesses with slower stock movement, such as industrial spares, furniture or capital goods, or as a check on branches and franchise outlets. They're also useful before quarterly board or lender reviews.
An annual full physical count is the baseline for almost every business. In many cases it's expected by statutory auditors at financial year-end. It covers every SKU in every location, usually with operations paused or restricted while counting happens.
If you run regular cycle counts throughout the year, the annual audit becomes a verification exercise rather than a scramble.
Audit frequency depends on six factors:
| Business type | Suggested approach |
|---|---|
| Fast-moving retail / FMCG outlet | Daily spot checks on high-risk SKUs, weekly or monthly cycle counts, annual full count |
| Liquor store | Daily checks on premium brands, weekly cycle counts, monthly reconciliation |
| Pharmacy / pharma distributor | Weekly or monthly counts with batch and expiry checks, annual full count |
| Warehouse / 3PL | Ongoing cycle counts by zone, client-level audits as contracts require |
| Manufacturing (raw material, WIP, finished goods) | Monthly for critical raw materials, quarterly for spares, annual full count |
| Multi-location retail or dealer network | Branch audits monthly or quarterly on a rotating schedule, plus surprise audits |
Treat this as a starting point. If a location keeps showing large variances, audit it more often until the cause is fixed.
Many businesses still audit with printed count sheets and Excel. It works for a small stockroom. As SKUs, people and locations grow, the same problems tend to appear:
None of this means manual audits are wrong. It means they become slow and fragile at scale. This is the point where many teams start looking at stock audit software.
Here's how a paper-and-Excel audit compares with dedicated inventory counting software across the parts of the process that matter most.
| Area | Manual audit (paper + Excel) | Inventory audit software |
|---|---|---|
| Counting | Tally sheets, handwritten counts | Mobile app or handheld scanner, counts saved per item |
| Data capture | Written, then re-typed into Excel | Captured once, directly into the system |
| Barcode scanning | Not possible, or a separate tool | Built in through phone camera or external scanner |
| Offline capability | Paper works offline, but data entry happens later | Counting continues offline and syncs when connected |
| Multi-location auditing | Separate files per branch, merged manually | Locations managed centrally with consistent audit rules |
| Discrepancy tracking | Highlighted cells, comments if any | Variances calculated automatically, with resolution notes |
| Audit history | Scattered across files and email | Stored per audit, location and item |
| Reporting | Built manually after the count | Summary and variance reports generated from count data |
| Speed | Counting plus days of compilation | Counting and reconciliation run closer together |
| Human error | High risk at every handover | Reduced, since data entry and comparison are automated |
Software doesn't remove the need for careful counting. It removes the copying, merging and manual comparing that cause most audit delays.
Inventory audit software is a tool built specifically for counting and verifying physical stock, then comparing it with your system records. It's different from general inventory management software, which tracks purchases, sales and stock movement day to day. An audit tool focuses on one job: proving whether those numbers are right.
A typical inventory audit system lets you:
Who needs a stock audit system? Typically, businesses with hundreds or thousands of SKUs, more than one location, regulated stock (batch, expiry or serial numbers), or a finance team that has to sign off on inventory. Retailers, distributors, warehouses, 3PLs, manufacturers and pharma companies are the most common users.
If you count one small stockroom twice a year, a well-organized spreadsheet may be enough. If audits take days and still leave unexplained variances, it's worth looking at an automated inventory audit tool.
Not every tool fits every business. These are the features that make the biggest practical difference:
Stockount is inventory audit software built for stock counting and verification. It sits alongside your existing ERP rather than replacing it, so teams keep their current billing and accounting workflows.
Here's how it fits into the audit process described above:
For example, Velavan Motorcycles, a Royal Enfield dealer, reduced a manual stock audit that used to take 7 days to 2 days after moving to Stockount.
You can see the full list on the inventory audit system features page.
Use this checklist for your next audit, whether you're on paper or software. For a printable version, see the inventory audit checklist.
Before the audit
During the audit
After the audit
An inventory audit is the process of physically counting and checking stock, then comparing it with recorded stock to find and fix discrepancies. It also checks condition, location and, where relevant, batch or serial details.
Most businesses do a full physical audit at least once a year, plus cycle counts in between. Fast-moving retail and high-risk items often need weekly or monthly counts; slow-moving stock can be checked quarterly.
In practice, they mean the same thing: verifying physical stock against records. "Stock audit" is more common in India and the UK, "inventory audit" in the US. Some use "inventory audit" for a broader review that includes valuation and controls.
Inventory audit software (or stock audit software) is a tool for counting physical stock, comparing it with book stock, tracking variances and producing audit reports. It usually includes mobile scanning, multi-location support and ERP integration.
Yes. Barcode scanning is one of the most effective ways to speed up counts and reduce errors. Many teams now use an inventory audit app on a smartphone camera instead of dedicated handheld scanners, or alongside them.
Software removes the most error-prone steps: re-typing paper counts, merging spreadsheets and manually comparing with book stock. Scanning reduces SKU mix-ups, zone assignment reduces double counting, and variances are calculated automatically.
The best option depends on your SKU count, number of locations, ERP and whether you track batches or serial numbers. Look for mobile scanning, offline mode, variance resolution, multi-location reporting and integration with your ERP. Stockount is one option built for these needs; try it against your own audit workflow before deciding.
Make Inventory Audits Faster and More Accurate
A good audit process starts with clear steps and the right schedule. If spreadsheets are slowing you down, inventory audit software like Stockount helps your team run mobile inventory audits, verify stock at item, batch or serial level, identify discrepancies, and manage audits across every location from one place.
See how it works with your own stock and ERP.