Year-End Inventory Audit Readiness Checklist
Inventory is usually the largest judgment area in a manufacturer's audit. This checklist covers the count, cutoff, valuation, reserves and documentation steps that auditors ask for, so the work is done before fieldwork starts.
0 of 28 items complete
10 critical items still open - these are the highest-risk gaps.
Physical count and observation
Cutoff
Valuation
Reserves and documentation
Every critical item should be complete before the audit begins. Unfinished critical items are the most likely sources of audit adjustments or delays.
Audit package automation
Optional: talk through how to generate the inventory PBC package from your ERP automatically.
Optional. The tool and every export work without this. No spam.
How to use the checklist
Assign each group to an owner, such as the plant controller for count and cutoff and the cost accountant for valuation. Work through the items several weeks before year end, finish the count items on the count day, and complete valuation and reserves after the close. Export the list to share with the auditor as part of the prepared-by-client package.
What auditors test
Auditors usually observe the count, test cutoff using the last receiving and shipping documents, test valuation by tracing costs to invoices and standards, and challenge the reserve for excess and obsolete stock. They also check that the subledger ties to the GL. Weak spots in any of these areas tend to expand the testing scope.
Valuation and reserve support
Keep the roll-up approval, overhead rate calculation and capacity assumptions in one folder. For reserves, keep aging reports, usage by item over a defined period, and evidence of sales prices after the period end. A reserve that uses a simple documented rule applied consistently is easier to defend than a manual estimate with no support.
Common mistakes
Letting shipments continue during the count without logging document numbers, recounting only the items with large differences, forgetting consigned and customer-owned stock, leaving negative inventory unresolved, and booking a reserve that cannot be traced to data.
Frequently Asked Questions
What does an auditor check in manufacturing inventory?
Existence through count observation, completeness and cutoff through document testing, valuation through cost support and standards, and the adequacy of the excess and obsolete reserve. They also test ties between subledger and GL.
Do we need a full physical count at year end?
Not necessarily. Auditors can accept a well-run cycle count program with accurate records. Otherwise a full count or a count close to year end with roll-forward is expected.
How should unallocated overhead be treated?
Fixed overhead should be allocated based on normal capacity. Costs from abnormally low production or idle capacity are expensed in the period rather than added to inventory value.
What is the lower of cost and net realizable value test?
Inventory must not be carried above the amount expected to be recovered from sale. Compare cost with estimated selling price less costs to complete and sell, and write down the difference.
If your inventory extracts and reconciliations are manual, we can discuss how to automate the PBC package from your ERP data.
Related Tools
Inventory Subledger to GL Reconciliation SQL Generator
Generates a SQL query that compares inventory subledger value with the GL inventory accounts and shows the difference by account and period.
Costing & FinanceStandard Costing Process Maturity Assessment
Ten questions that score how well your standard cost process holds up: update cadence, BOM and routing accuracy, variance follow-up and governance.
Costing & FinanceExcess and Obsolete Inventory Reserve Calculator
Apply reserve percentages to aged inventory buckets and see the total E&O reserve, net inventory and the margin impact of changing the policy.
ERP OperationsERP Month-End Close Checklist
A 32-point close checklist built for manufacturing ERP, covering transaction cutoff, inventory and WIP valuation, subledger reconciliation, and period lock.
Costing & FinanceInventory Valuation Methods Reference (IFRS vs US GAAP)
A lookup table of inventory costing methods and measurement rules under IFRS and US GAAP, with the matching ERP setting where it is well known.
More Costing & Finance tools
See all- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet
- SyteLine Cost Rollup Variance Calculator
Keep exploring
Free tools
- Electronics Traceability Readiness ChecklistA 30-point checklist to audit your lot/serial capture, supplier traceability, test data linkage, and recall readiness before a customer or auditor does.
- Business Central Year-End Close ChecklistWork through preparation, subledger, inventory, closing and post-close steps for a clean Business Central fiscal year end.
- Dynamics GP Year-End Close ChecklistA step-by-step checklist for closing a fiscal year in Dynamics GP, from subledger reconciliation to final backup and sign-off.
ERP fixes and how-tos
- Is Your ERP Data Ready for AI? A Readiness ChecklistMost ERP data is ready enough to pilot AI today. A practical checklist of the master-data and access-control issues that actually break AI answers.
- Costpoint Year-End Close and Indirect Rate True-UpA practical Deltek Costpoint year-end checklist: close periods, compute actual indirect rates, post the true-up against provisional billing rates.
- SyteLine 1099: set up vendors and run year-end reportingHow 1099 reporting works in Infor SyteLine: flag vendors, make sure payments carry the right 1099 category, verify totals, and prepare year-end filing.
Guides
- SyteLine Physical Inventory Procedures and Best PracticesExecute physical inventory in Infor SyteLine with freeze procedures, count sheet generation, variance reconciliation, and posting workflows for year-end audits.
- SyteLine Period Close Checklist and Best Practices GuideExecute month-end and year-end close in Infor SyteLine with a detailed checklist covering subledger reconciliation, accruals, GL close, and reporting.
- How to Run Financial Period Close in SyteLineStep-by-step guide to running financial period close in Infor SyteLine. Learn month-end procedures, GL reconciliation, period locking, and year-end closing processes.
AI on your ERP
- Is Your ERP Ready for AI? A Readiness Assessment ChecklistIs your ERP actually ready for AI? A practical checklist covering master data quality, access and permissions, GPU sizing, and governance before you fund a pilot.
- AI for SAP Business One Inventory: Stock, Batches, Bins and ValuationPrivate AI over SAP Business One inventory: OITW stock, batches, serials, bins and valuation. Answers grounded in live data via Service Layer or SQL views.