Preparing Stock Records for VAT Audits: A Practical Checklist
When a VAT review starts, tax officers rarely ask for a slogan. They ask for evidence: what you bought, what you received, what you sold, what you adjusted, and whether those numbers still add up. For wholesalers, pharmacies, hardware stores, and workshops across Kenya, Nigeria, South Africa and beyond, that evidence lives in stock and purchase documents long before it appears on a VAT return.
This guide is a practical preparation checklist. It is not tax advice, and it does not claim that any software replaces your accountant or your local tax rules. It shows how clean inventory records reduce audit stress — and where StockPRO can help without inventing country-specific tax-authority integrations.
Why this costs real money
Inventory carrying-cost benchmarks commonly sit around 15–25% of inventory value on hand (APICS/ASCM rule-of-thumb ranges). That means unclear stock is not only an audit risk — it is cash tied up in the wrong places.
Separately, IHL Group research has estimated worldwide retail inventory distortion (out-of-stocks + overstocks) at roughly 6.5% of global retail sales. The same distortion pattern shows up in African SMBs as missing GRVs, till totals that do not match stock movement, and adjustments with no owner approval trail.
Audits get expensive when you cannot explain those gaps quickly. Penalties and professional fees aside, the bigger cost is management time spent reconstructing history from WhatsApp photos and spreadsheets.
Step-by-step: what good looks like before an audit
Treat this as industry best practice. Your accountant or tax practitioner should confirm what your local authority expects for each period.
- Lock the period. Decide the start and end dates the reviewer is asking about (month or quarter).
- List opening stock. Quantity and value by product at period start — from a stocktake or system closing of the prior period.
- Collect purchase evidence. Supplier invoices for the period, plus matching goods received records (GRVs/GRNs).
- Collect sales evidence. Invoices and/or POS sales totals for the same period.
- List stock adjustments. Write-offs, damages, corrections — with who approved them and why.
- Reconcile the story. Opening + purchases/receipts − sales issues − adjustments should explain closing stock closely enough that differences are documented.
- Package supporting files. Keep exports, PDFs, and notes in one folder named by country and period (for example
KE_2025Q1_stock_support). - Have a human review before submission. An owner or accountant should check obvious mismatches before anything is sent.
How StockPRO helps (honestly)
StockPRO is a cloud ERP for inventory, multi-warehouse stock, POS, purchasing, GRVs, job cards, sales/invoicing, and accounting in one system. That shared record trail is what makes audit preparation faster — not a pretend “one-click VAT audit pack” or a built-in KRA/FIRS filing integration.
- Missing link between buys and receipts → Purchasing + GRV keeps receiving tied to what you ordered, then updates stock.
- “What did we sell?” arguments → POS and sales/invoicing in the same system reduce re-keying from till notes into a separate book.
- Multi-branch confusion → Multi-warehouse stock helps you see where quantity actually sits before you explain a shortage.
- Finance and floor using different numbers → Accounting workflows in the same product reduce duplicate ledgers.
- Need a history to export for your accountant → Standard stock/purchasing/sales history in one place is easier to extract than scattered notebooks (your accountant still formats what the authority wants).
What this does not claim: StockPRO does not replace eTIMS/iTax/FIRS portals, does not auto-file VAT returns, and does not ship certified country-specific VAT audit templates for Kenya or Nigeria. Use StockPRO for operational truth; use your tax practitioner for statutory filings.
Practical checklist you can use this week
- Pick last month and try to assemble opening stock, purchases, GRVs, sales, and adjustments in one folder
- Count how many supplier deliveries have no GRV
- Compare POS/sales totals to stock issues for one high-volume product
- List unapproved write-offs
- Confirm who can approve stock adjustments
- Ask your accountant what document set they want for the next VAT period — then keep that set recurring
- If you run multiple locations, reconcile one SKU across branches before month-end
If you want purchasing, receiving, stock, sales, and accounting records in one system so audit prep is less of a scavenger hunt, see how StockPRO can tighten stock control across your stores and warehouses.