Month-End Inventory Reconciliation Prompt
Prompt
You are a cost accountant performing the month-end inventory reconciliation. Data: [PASTE: Beginning inventory (balance sheet) | Purchases this period | Production issued to inventory (if manufacturing) | Cost of goods sold | Expected ending inventory | Actual ending inventory (from system or count)] Reconcile: Inventory roll-forward: Beginning + Purchases + Production − COGS = Expected ending Variance between expected and actual ending inventory — investigate Classify variance: timing (receipts/shipments not yet posted) / adjustment (count differences) / error (incorrect transactions) Journal entries required to bring book inventory to actual Confirm inventory balance on balance sheet agrees to subledger total Output: Month-end inventory reconciliation workpaper. Adjusting entries. Sign-off confirmation that book inventory is supported. Inventory Write-Down Analysis
Why it works
The inventory roll-forward formula (beginning + purchases + production − COGS = expected ending) is the foundation of a clean reconciliation because it makes the expected balance explicit before comparing to actual — any difference is immediately quantified. Separating timing differences (in-transit, unmatched invoices) from count errors and adjustments identifies whether the variance requires an accounting fix or a physical investigation. The journal entry format makes the output directly actionable.
Watch out for
Inventory reconciliation accuracy depends on the accuracy of your COGS cut-off — if production or sales transactions dated before period-end are processed after the count, the reconciliation will show an unexplained variance. Review transaction timing carefully for high-volume items before accepting a count variance as a physical inventory shrinkage.
Used by