Exclusive Offer: Sign up today and unlock 7 days of full feature access— 100% free!
Exclusive Offer: Sign up today and unlock 7 days of full feature access— 100% free!

Inventory Audit: How to Do It, How Often to Audit & How Software Helps

| By Stockount

infographic showing stock audit software steps and frequency options in a warehouse setting, with hourglass and clock icons.

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.

What Is an Inventory Audit?

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:

  • Condition — damaged, expired or unsellable goods
  • Location — items stored in the wrong bin, aisle or branch
  • Identity — the right SKU, batch or serial number
  • Value — whether the stock value in your books reflects reality

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.

Why Are Inventory Audits Important?

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:

  • Inventory accuracy — Purchasing, sales and planning all rely on stock numbers. Audits keep those numbers honest.
  • Catching stock discrepancies early — A 5-unit variance found this month is easy to trace. The same variance found after a year is almost impossible to explain.
  • Reducing shrinkage — Theft, damage, expiry and admin errors all show up as shrinkage. Audits reveal where it's happening, not just that it's happening.
  • Avoiding overstock — If the system under-reports stock, you reorder what you already have and tie up cash and space.
  • Preventing stockouts — If the system over-reports stock, you promise customers items you can't ship. That costs sales and trust.
  • Financial reliability — Inventory is often one of the largest items on the balance sheet. Statutory auditors, lenders and investors expect it to be verified.

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.

How to Conduct an Inventory Audit Step by Step

The process below works whether you're auditing one stockroom or twenty branches. The tools change; the logic doesn't.

1. Prepare Inventory Records

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:

  • Export current stock from your ERP or accounting system (Tally, Zoho, Odoo or similar)
  • Post all pending receipts, sales and transfers so the book stock is up to date
  • Fix the cut-off time: transactions after this point are excluded from the audit
  • Share count sheets or load the item list into your counting app

2. Organize Stock and Locations

A messy store produces a messy count. Before counting:

  • Group items by location, zone, aisle or bin
  • Label shelves and bins clearly
  • Separate damaged, returned and quarantined stock
  • Assign each counter a defined zone so no area is counted twice or missed

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.

3. Perform the Physical Count

Count everything in scope, using barcode scanners, mobile devices or manual tally sheets depending on your setup.

A few practices make counts more reliable:

  • Freeze movement in the zone being counted, or count during low-activity hours
  • Use blind counts where counters don't see the expected quantity, so they record what's actually there
  • Count by unit of measure and note when cartons, packs and loose units are mixed
  • Record condition — damaged, expired or near-expiry items should be flagged, not just counted
  • Recount high-value items with a second person

4. Compare Physical Stock With Recorded Stock

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.

5. Identify Inventory Discrepancies

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:

  • By value — largest rupee or dollar impact first
  • By percentage — items where the variance is large relative to stock held
  • By pattern — the same SKU or location showing variances audit after audit

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.

6. Investigate the Root Cause

This is where an audit becomes useful instead of just a count. For each significant variance, ask what actually happened.

Common causes include:

  • Goods received but not entered, or entered twice
  • Sales billed to the wrong SKU or variant
  • Transfers between branches not recorded at one end
  • Damage, expiry or write-offs not posted
  • Unit-of-measure errors (a carton of 12 entered as 1)
  • Theft or pilferage

Recount before investigating further. Many "discrepancies" turn out to be counting errors.

7. Correct and Verify Inventory Records

Once causes are confirmed:

  • Post approved stock adjustments in your ERP, with reasons
  • Fix the process gap that caused the variance (receiving, billing, transfers)
  • Document the audit: what was counted, by whom, variances found, how they were resolved
  • Get sign-off from the store, warehouse or finance owner

That audit trail matters. It shows statutory auditors what was checked, and it gives you a baseline to compare against next time.

How Often Should You Conduct an Inventory Audit?

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 Inventory Checks

Daily checks are short spot counts, not full audits. They suit:

  • Cash-like or high-theft items (mobile phones, liquor, cosmetics, branded apparel)
  • Fast-moving SKUs in retail and quick commerce
  • Items with frequent stock complaints from customers or sales teams

A counter can check 10–20 critical SKUs at opening or closing in a few minutes.

Weekly Audits

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

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

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.

Annual Physical Inventory Audits

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.

How to Choose the Right Audit Frequency

Audit frequency depends on six factors:

  • Inventory value — higher-value stock deserves more frequent checks
  • SKU volume — thousands of SKUs usually call for cycle counting instead of frequent full counts
  • Business type — retail and pharma move faster than manufacturing spares
  • Stock movement — fast-moving items drift from records sooner
  • Risk level — theft-prone, expiry-sensitive or regulated items need tighter control
  • Number of locations — more branches mean more transfers and more places for errors to hide
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.

Common Challenges With Manual Inventory Audits

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:

  • Spreadsheet version chaos — Multiple counters, multiple files, and nobody is sure which sheet is final.
  • Manual data entry — Every number gets written on paper, then typed into Excel, then compared with the ERP. Each step is a chance for a typo.
  • Counting errors — Similar-looking SKUs, mixed units of measure and tired counters lead to wrong counts.
  • Duplicate counting — Without zone control, the same shelf gets counted twice, or a corner gets missed entirely.
  • Delayed reconciliation — Comparing counts with book stock can take days after counting ends. By then, stock has moved and the comparison is less reliable.
  • No real-time visibility — Managers don't know how far the count has progressed or which areas show big variances until it's over.
  • Multi-location complexity — Each branch audits differently, files come back in different formats, and head office has to stitch them together.
  • Weak discrepancy tracking — Variances get adjusted, but the reason, the approver and the history are rarely recorded. The same problem shows up again next audit.

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.

Manual Inventory Audit vs Inventory 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.

What Is Inventory Audit Software?

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:

  • Load your item master and book stock from your ERP or a file
  • Assign audits to people, locations or zones
  • Count by scanning barcodes on a phone, tablet or handheld
  • See variances as counts come in
  • Record reasons and resolutions for each discrepancy
  • Produce audit reports and keep a history of every audit

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.

Key Features to Look for in Inventory Audit Software

Not every tool fits every business. These are the features that make the biggest practical difference:

  • Mobile barcode scanning — Counting with a phone camera or an external Bluetooth/USB scanner. A good inventory audit app also parses different barcode formats.
  • Offline mode — Warehouses, basements and cold rooms often have poor connectivity. Counting should continue offline and sync later.
  • Multi-user counting — Several counters working on the same audit at once without overwriting each other.
  • Serial, batch and unit-level counting — Essential for pharma, electronics, automotive parts and any stock tracked by batch or serial number.
  • Cycle counts and periodic audits — Support for both rolling cycle counts and full physical audits, not just one.
  • Multi-location management — Run and compare audits across branches, warehouses and dealer sites from one place.
  • Variance resolution — A clear workflow to record why a variance happened and how it was resolved.
  • Photo validation — Attaching photos to counts or discrepancies as evidence for review.
  • Real-time dashboard — Progress and variances visible to managers while the count is running.
  • Audit reports and history — Summary, variance and cycle reports, plus a record of past audits for comparison.
  • ERP integration — Pulling book stock from, and sending results back to, the system you already use.

How Stockount Helps Simplify Inventory Audits

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:

  • Faster physical counts — Teams count using the Stockount mobile audit app, web or tablet, scanning with the device camera or an external scanner. Continuous count mode suits high-volume shelves.
  • Verification at item level — Count by unit, batch or serial number, so regulated or high-value stock is verified precisely.
  • Discrepancies identified as you go — Physical counts are compared with book stock, variances are surfaced, and audit resolutions record what was found and why. Photo cross-checking supports review.
  • Multiple locations, one view — Run audits across branches and warehouses, with a real-time dashboard and multi-branch reporting.
  • Different audit types — Periodic and cycle audits, ad-hoc and investigation audits, and cross audits where a second team re-verifies counts.
  • Less manual work — Offline support keeps counting going in low-signal areas, and multi-user counting lets several people work on one audit.
  • Audit results and reports — Audit summary reports, cycle and complete reports, and variance trend analysis help you see recurring problem areas.
  • ERP connection — Integrations with ERPs such as Odoo and Zoho, plus a custom ERP API.

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.

Inventory Audit Checklist

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

  • Define the purpose and scope (full count, cycle count, investigation)
  • Fix the cut-off date and time
  • Post all pending receipts, sales, returns and transfers
  • Export book stock and load it into count sheets or the audit app
  • Organize and label shelves, bins and zones
  • Separate damaged, returned and quarantined stock
  • Assign counters and zones; brief the team

During the audit

  • Freeze or restrict stock movement in counting zones
  • Count by zone, using blind counts where possible
  • Record condition, batch and expiry where relevant
  • Recount high-value items and large variances
  • Track progress so no zone is skipped or counted twice

After the audit

  • Compare physical counts with book stock
  • Prioritize variances by value and pattern
  • Investigate and document root causes
  • Post approved adjustments with reasons
  • Fix the process gaps behind repeat variances
  • Get sign-off and archive the audit report
  • Schedule the next audit or cycle count

Frequently Asked Questions

1. What is an inventory 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.

2. How often should inventory be audited?

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.

3. What is the difference between a stock audit and an inventory audit?

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.

4. What is inventory audit software?

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.

5. Can inventory audits be done using barcode scanning?

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.

6. How can software reduce inventory audit errors?

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.

7. What is the best inventory audit software?

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.

Book a Demo · Start Your Free Trial

Tags
Search For Articles
Latest Articles

Follow Us
Tags
Book 20-Min Demo