,

Inventory & Stores Audit Program v1.0

$21.99

A risk-led Excel audit program for any organisation that holds stock. It has 93 procedures, a 54-risk register, a ready-to-send evidence request list, and a Loss Estimator that values count shortfalls, short deliveries, unauthorised issues, excess and obsolete stock, and unapproved write-offs.

Your stock ledger says the shelves are full. When did someone last count them, and who checked the counter?

Stock rarely disappears in one go. A supplier invoices 500 bags and delivers 480. A box of spares leaves the store on a phone call instead of a signed requisition. The storekeeper counts their own shelves, finds a shortage, and posts an adjustment the same afternoon. Three years’ supply of one item sits gathering dust while another runs out and is bought in a hurry at twice the price. Expired items stay on the shelf at full value. Each problem looks small on its own. Together they cost real money and leave the stock figure in the financial statements wrong.

The Inventory & Stores Audit Program follows stock from the reorder trigger to the final issue, count and write-off. It is built for internal auditors, external auditors, finance managers, stores and warehouse managers, and consultants who need to know whether stock is properly controlled, and what it costs when it is not.

This is a risk-led program, not a checklist. Every procedure traces one golden thread: Objective → Risk → Impact → Expected Control → Procedure → Evidence → Finding. You can show management exactly why each test exists and what it protects.

The program contains 93 audit procedures across 9 sections. It is supported by a 54-risk register scored on five impact dimensions, and by a Loss Estimator that puts a money value on control gaps.

Built around recognised practice

  • Structured on COSO internal control principles and the IIA’s risk-based audit approach.
  • Valuation tests (costing method, landed costs, net realisable value, cut-off, provisions, disclosure) are written to work under any applicable financial reporting framework.
  • Jurisdiction-neutral: no country-specific regulators, tax rules or standards, so it works in any country.

What the program covers

Section 1 — Governance, Policy & Inventory Framework (10 procedures) Confirms there is an approved stores policy, that ordering, receiving, custody, recording and counting are separated, and that approval limits cover adjustments and write-offs. Also checks system access, named custodians with handover counts, and stock held at sub-stores, sites and third parties.

Section 2 — Replenishment & Requisitioning (10 procedures) Tests reorder levels and min/max settings, stock-outs of critical items, and stock held far above maximum. Also checks that requisitions are based on real need and approved, and that “emergency” buying is not a way around the rules.

Section 3 — Receiving & Inspection (10 procedures) Confirms only ordered goods are accepted, that goods are counted and inspected on arrival, and that invoices are matched to orders and receipts before payment. Values short deliveries and follows rejected goods through to credit notes.

Section 4 — Storage, Security & Stock Condition (11 procedures) Inspects store security, access logs, key control, gate passes and CCTV, with extra checks on high-value items. Also tests bin locations and bin cards, storage conditions, hazardous materials, and expired or damaged stock still on the shelves.

Section 5 — Issues, Transfers & Returns (11 procedures) Tests that stock is issued only against authorised requisitions and charged to the right job. Compares consumption with standards, follows transfers between stores until they are received, and finds unused materials left at sites.

Section 6 — Stock Counts & Reconciliation (11 procedures) Checks count planning and instructions, independent blind counts and cut-off, with test counts both ways. Values shortfalls, tests whether variances were investigated, and reviews every adjustment for support and approval.

Section 7 — Slow-moving, Obsolete & Expired Stock (10 procedures) Tests the ageing report, values slow-moving and expired stock that is not yet provided for, and recalculates the provision. Also checks that write-offs are approved and inspected, that hazardous stock is destroyed safely, and that scrap sales bring in fair value.

Section 8 — Inventory Valuation & Accounting (10 procedures) Confirms the costing method, recalculates unit costs and landed costs, and reviews net realisable value. Also tests cut-off at period end and reconciles the stock ledger to the general ledger.

Section 9 — Inventory Data, Systems & Reporting (10 procedures) Finds duplicate items, wrong units of measure and unauthorised master data changes. Tests negative stock and interface errors, traces management reports to the system, follows up past findings, and agrees the inventory note to the stock ledger.

Fuel stock, capitalised spares, and supplier selection and tendering are deliberately left out. Pair this program with the Fuel Management Audit Program for fuel, and with the Fixed Assets & Motor Vehicle Audit Program for equipment and vehicles.

What makes it different

  • Suggested evidence on every procedure. Each procedure names the documents to request, the evidence type and the person who holds them, so you know what to ask for and whom to ask.
  • “What to look for” red flags. Practical warning signs are built into every procedure, for example: “Gains on one item offsetting losses on a similar item” or “Boxes received as single units.”
  • Ready-to-send Evidence Request List. 84 documents are grouped by owner, with status tracking and overdue alerts. Filter it, send it to the client, and start fieldwork with the evidence already in hand.
  • Loss Estimator. Six calculators cover Stock Count Shortfall, Receipt Short-Delivery, Unauthorised Issues, Excess Stock Holding Cost, Slow-moving & Obsolete Stock, and Unapproved Adjustments & Write-offs. Two totals keep the story honest: annual leakage for losses that repeat every month, and one-off loss & exposure for count shortfalls, unprovided obsolete stock and unapproved write-offs. A finding like “about $31,000 a year leaking through short deliveries and unauthorised issues” gets attention in a way “controls need improvement” never does.
  • 54-risk Risk Register. Each risk is scored for Financial, Operational, Safety & Environmental, Regulatory and Reputational impact. Inherent and residual ratings calculate automatically as you assess controls.
  • Executive Dashboard. Section scores, inherent and residual heat maps, the top 10 risks, findings by rating, annual leakage, and one-off loss & exposure all update live, ready for your report and exit meeting.

What’s included

  • 1 Excel workbook with 15 tabs, with no macros and no add-ins required.
  • 93 audit procedures across 9 colour-coded sections, organised under 36 audit objectives.
  • A 54-risk Risk Register with impact and likelihood scales defined.
  • Suggested evidence, evidence owner and red flags for every procedure.
  • An Evidence Request List (84 items, 9 owners) with tracking.
  • A Loss Estimator with 6 calculators, adjustable tolerances and separate recurring and one-off totals.
  • A Findings Log (Condition, Criteria, Cause, Impact, Recommendation, management action tracking).
  • An auto-scoring Dashboard with heat maps and a top 10 risk table.
  • An About tab with a section navigator, how-to-use guide and rating definitions.

Who it’s for

  • Internal audit teams in manufacturing, mining, construction, retail, distribution, hospitals and utilities.
  • Councils, parastatals, NGOs, schools and donor-funded projects that hold stores, drugs, spares or relief supplies.
  • External auditors and audit firms attending stock counts and testing inventory valuation.
  • Finance, stores and warehouse managers who want to check their own controls before the auditors arrive.
  • Consultants carrying out stock takes, stores reviews or loss investigations.

# Section Procedures Focus
1 Governance, Policy & Inventory Framework 10 Policy, segregation, limits, custodians, all stock locations
2 Replenishment & Requisitioning 10 Reorder levels, stock-outs, excess stock, emergency buying
3 Receiving & Inspection 10 Short deliveries, inspection, three-way match, returns
4 Storage, Security & Stock Condition 11 Access, keys, bin cards, conditions, expired stock
5 Issues, Transfers & Returns 11 Authorised issues, consumption, transfers, returns
6 Stock Counts & Reconciliation 11 Blind counts, shortfalls, variance follow-up, adjustments
7 Slow-moving, Obsolete & Expired Stock 10 Ageing, provisions, write-offs, scrap sales
8 Inventory Valuation & Accounting 10 Costing, landed cost, NRV, cut-off, ledger reconciliation
9 Inventory Data, Systems & Reporting 10 Item master, units, negative stock, reports, disclosure
Total 93

Reviews

There are no reviews yet.

Be the first to review “Inventory & Stores Audit Program v1.0”

Your email address will not be published. Required fields are marked *

Shopping Cart
Chat With Us
Scroll to Top