Blog · Board and management reporting · Finance and FP&A teams
Under the periodic inventory system, a period-end count establishes the inventory balance rather than each sale updating the inventory ledger. Follow the count, cutoff, valuation, and ledger checks in a worked business reconciliation.
Under the periodic inventory system, the inventory ledger is updated at the close from a valued physical count, while purchases accumulate during the period. Individual sales do not each trigger an inventory cost update in that ledger. The closing workbook must prove which goods belonged to the business, what was on hand at cutoff, and how the final value ties to the accounts.
The operating question is whether the count, purchase records, valuation, and ledger describe the same inventory at the same time. A correct subtraction cannot repair an incomplete count or a receipt recorded in the wrong period.
OpenStax's accounting text distinguishes periodic updates at scheduled reporting dates from perpetual updates as inventory transactions occur. It also describes the conventional Purchases account used during a periodic cycle. A company may still have order, shipping, or warehouse records between closes; those records do not automatically make its accounting ledger perpetual.
Periodic recordkeeping and inventory valuation are separate choices. The former determines when the accounts are updated; the latter determines which costs attach to the goods remaining. Keep the company's approved costing method consistent rather than choosing whichever unit cost makes the reconciliation easiest.
Use the cost of goods sold guide for the full expense formula and cost-method comparison. Here the focus is the evidence supporting the closing inputs.
Keep a separate tab for each source and a reconciliation tab that references them. The inventory accountant should be able to trace every closing amount to either an opening balance, a purchase document, or a count row.
| Source | Fields to retain | What it proves |
|---|---|---|
| Prior approved close | Item, location, quantity, cost, closing value | Opening balances agree with the last close |
| Purchase and receipt records | Item, quantity, receipt date, invoice reference, cost | Receipts belong to the period and population |
| Returns and credits | Item, quantity, credit reference, effective date | Purchase reductions are included once |
| Physical count sheets | Item, location, unit of measure, quantity, count time, counter | Original physical observations |
| Movement bridge | Receipt or shipment reference, time, quantity, ownership evidence | Count quantities become cutoff quantities |
| Valuation schedule | Cutoff quantity, approved cost layers or unit cost, extension | Ending inventory value is reproducible |
| General ledger export | Opening inventory, purchases, adjustments, ending postings | Workbook totals agree with accounts |
Count all locations in scope, including segregated goods and documented off-site stock. Review who owns goods in transit or on consignment under the relevant terms. Physical presence alone does not establish ownership.
An Ohio parts distributor closes September on September 30, 2026. Its count takes place at 1:00 p.m.; reporting cutoff is 5:00 p.m. The following movements are supported by shipping and receiving records, and ownership changes within that interval as shown.
| Item | Count at 1:00 p.m. (units) | Receipts before cutoff | Shipments before cutoff | Cutoff quantity |
|---|---|---|---|---|
| Gasket | 70 | 0 | 0 | 70 |
| Valve | 55 | 0 | 5 | 50 |
| Filter | 130 | 10 | 0 | 140 |
The quantity bridge is count plus receipts minus shipments. If those columns occupy B through D, the cutoff quantity in E2 is:
=B2+C2-D2
Retain the original count rather than replacing it with the cutoff quantity. The valve's 55 minus 5 equals 50; the filter's 130 plus 10 equals 140. The filter receipt is also included in the period's purchase records, so it belongs in both the receipt history and ending stock without becoming a duplicate purchase.
For clarity, each item in this example has a constant approved unit cost throughout the period. There are no supplier returns, discounts, freight additions, reserves, or other adjustments. A real workbook must include such items when applicable and apply the company's costing policy.
| Item | Opening units | Purchased units | Cutoff units | Unit cost (USD) | Opening value (USD) | Purchases (USD) | Ending value (USD) |
|---|---|---|---|---|---|---|---|
| Gasket | 100 | 60 | 70 | 20 | 2,000 | 1,200 | 1,400 |
| Valve | 80 | 40 | 50 | 50 | 4,000 | 2,000 | 2,500 |
| Filter | 200 | 100 | 140 | 10 | 2,000 | 1,000 | 1,400 |
| Total | 8,000 | 4,200 | 5,300 |
Each extension is quantity multiplied by unit cost. Ending values are 70 × 20 = 1,400, 50 × 50 = 2,500, and 140 × 10 = 1,400. No rounding is needed in this example; preserve cost precision before rounding real posting totals.
The IRS's inventory guidance discusses physical counts and adjusting book inventory to actual inventory. Its tax rules are not a replacement for the company's book accounting policy, but the count-to-record distinction is useful: valuing a count and posting it are separate control steps.
The prior approved ending schedule must support the $8,000 opening balance. The purchase records must tie to the $4,200 purchase balance after any cutoff corrections. The valued count supports $5,300 of ending inventory.
| Closing bridge | Amount (USD) | Supporting evidence |
|---|---|---|
| Opening inventory | 8,000 | Prior approved close |
| Plus period purchases | 4,200 | Purchase and receipt reconciliation |
| Equals available cost | 12,200 | 8,000 + 4,200 |
| Less ending inventory | -5,300 | Count valuation schedule |
| Residual inventory expense | 6,900 | 12,200 - 5,300 |
The check reverses the calculation: 5,300 + 6,900 = 12,200. IRS Publication 334's inventory worksheet similarly subtracts closing inventory from goods available to determine cost of goods sold. Here the $6,900 is COGS under the stated assumptions; investigate any separately identified losses or adjustments under the company's policy rather than assuming every uncounted unit was sold.
The inventory accountant prepares the schedule and proposed posting packet. The warehouse lead confirms count coverage and movements. The controller approves adjustments, verifies the ending inventory account becomes $5,300, and checks that the purchase accounts are treated correctly in the close. The resulting asset balance feeds the balance sheet.
The workbook establishes a reliable closing balance and a list of unresolved records. It does not establish current availability between closes. A department deciding what to reorder still needs receipt, shipment, and demand information current enough for that decision.
After reconciliation, finance can use consistent opening and closing values for the inventory turnover ratio. An inventory aging review answers a different question: which goods have remained unsold long enough to require attention. Neither measure substitutes for verifying the count.
Bring your opening inventory, purchase records, count sheets, and movement bridge to Covirage, where columns are mapped and its tools compute and check the supplied reconciliation. The external AI model explains the results with every figure traced to its rows, while your team confirms ownership, physical counts, and approved adjustments. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for finance teams for the broader reporting context.
In a conventional periodic system, merchandise purchases accumulate in a Purchases account during the period. The inventory balance is updated during the close using the valued ending count. The exact closing entries depend on the company's chart of accounts and accounting policies.
No. Periodic describes when the inventory account is updated, rather than requiring an annual schedule. A business can use monthly or quarterly closes and perform additional counts. Choose count timing and coverage that support the company's reporting and operating needs.
A count establishes what remains, but the residual between available goods and ending inventory does not by itself distinguish sales from theft, damage, or recording mistakes. Investigating shrinkage requires supporting shipment, receipt, return, adjustment, or loss records.
Bridge the physical count forward using documented receipts, shipments, and other movements between count time and cutoff. Review ownership as well as location. Preserve the original count and show each timing adjustment separately so a reviewer can reconstruct the ending quantity.