Monthly Inventory Reconciliation Template
Three documents and four sheets that check the physical count and the standard cost as two separate questions, then tie both to your ledger.
Free download · No account needed
Every inventory reconciliation template does the same one thing: compare book quantity to a physical count, value the gap at whatever cost is already on file, and call the result shrink. That comparison can never catch a stale standard cost, because the same cost values both sides of it and cancels out completely. This pack runs quantity and cost as two separate checks, so a costing error sitting on units that are still sitting on the shelf, uncounted as missing, does not disappear into a clean count.
Corrigan Hardware Supply's July close carries both failures on the same register. HW-205, a sledgehammer, shows a clean cost basis and a 296.00 quantity problem: the count found 108 on the shelf against 124 the books expected, 16 units genuinely missing. HW-100, a cordless drill, shows the opposite: a perfect count, 75 units both ways, sitting on top of a 330.00 costing error. This month's invoice priced the drill at 47.50 a unit while the standard cost on file still reads 42.00. A count-only close reports one of these and misses the other.
COGS Tie-out catches a third failure neither sheet above can see: a dollar amount that enters the ledger's cost of goods sold account without ever touching a SKU. A 775.00 water-damage write-off posted as a lump entry this period, never logged against the item it destroyed, so the SKU-level total reads 5,789.80 against the ledger's 6,564.80. Feed all three checks from the same POS or ERP export alongside the close checklist, and flag the resulting margin swing on the board slide.
What's in the pack
Inventory Rollforward sheet
Every SKU's opening quantity, purchases, and units sold, rolled into an ending quantity and value at standard cost.
Shrink and Adjustment Log sheet
Physical count against book quantity, valued at standard cost, with the 100.00 investigation threshold applied per SKU.
Standard Cost Variance sheet
Standard cost against this period's actual purchase invoices, run independently of whatever the count shows.
COGS Tie-out sheet
SKU-level totals against the general ledger's cost of goods sold and inventory accounts, for catching an entry never attributed to a SKU.
Inventory Policy
The standard costing method, the count cadence, and the dollar threshold that decides when a variance gets investigated.
Why a Count Can't Catch a Costing Error
The mechanism behind the sledgehammer and drill comparison, worked through in full with both sets of numbers.
Shrink Investigation Note
A completed example: what gets checked, standard cost, receiving, sales, before a variance is logged as unexplained.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent read your SKU list, purchases, and sales, or download the blank Word and CSV files instantly with no account.
- 2
Send the count sheet
This period's physical count, plus the purchase invoices with actual cost per unit, in whatever shape they exist today.
- 3
Let both checks run
The count gets compared to book quantity, and the standard cost gets compared to the actual invoice price, as two independent checks.
- 4
Tie it to the ledger every close
Both the cost of goods sold account and the inventory account get checked against the SKU-level totals, so a gap gets traced to a specific entry.
Frequently asked questions
Is this template free?
Yes. Download the whole pack as Word documents and CSV sheets, with no signup and no credit card. Edit with AI is a separate, optional path for anyone who wants the agent to read your purchases, sales, and count sheet and build the register directly. The template library holds the rest of the packs.
Why does a physical count miss a costing error?
Because a count values both book quantity and counted quantity at the same standard cost. If that cost is wrong, it is wrong identically on both sides, so the error cancels out of the comparison entirely. On the drill in the worked example, a perfect count hides a 330.00 cost variance that only a check against the actual invoice price reveals.
What is the investigation threshold, and why 100.00?
Book inventory should be verified by physical counts and adjusted to conform to the result, and this pack applies that at 100.00 of shrink per SKU per period. Below it, log the variance and move on. Above it, open a Shrink Investigation Note before adjusting the books, so the cause gets checked, not assumed.
What happens when I find a gap in COGS Tie-out?
You trace it to a specific entry before writing it down as a variance. Estimates of shrinkage are permitted only when the taxpayer makes proper adjustments as actual counts come in, and the same discipline applies here: a lump write-off gets attributed to the SKU it destroyed, not left as an unexplained ledger difference.
What costing method does this use?
Standard cost: one figure per SKU, set when it is added and revisited on a schedule, not the actual price of whatever was purchased most recently. Cost of goods sold and ending inventory value both run on that standard, which is what makes a direct check against actual purchase cost necessary rather than optional.
What does Edit with AI actually do?
It creates a free River account and installs this exact pack as a private workspace. The agent opens ready to read your SKU list, purchases, sales, and count sheet, and to run the quantity check and the cost check as two separate questions from the start. Nothing is written until you send something.
Who is this template for?
Controllers and bookkeepers at a product business, where a percent or two of margin drift is easy to miss until a quarter has already gone by. Once inventory and COGS are tied to the ledger, the close checklist is where that tie-out runs every month alongside the rest of the close.
Check quantity and cost as two separate questions
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent build the register from your own purchases, sales, and count sheet.
Edit with AI