An inventory roll forward moves a verified inventory balance from the date you counted the stock to the date you actually need it valued, using transaction records to bridge the gap. The formula is one line: beginning inventory plus purchases minus cost of goods sold equals ending inventory. Everything else is making sure each of those inputs is complete, correctly dated, and adjusted for the things a physical count alone won’t catch.
You use the procedure when a full count on the exact balance sheet date isn’t practical. A retailer might finish counting on December 15 for a December 31 year-end. A manufacturer might prefer counting during a January shutdown and work backward to the prior December 31. PCAOB Auditing Standard 2510 requires auditors to apply “appropriate tests of intervening transactions” when the count date and the balance sheet date differ, and those tests are the roll forward. Well-maintained perpetual records are what make it workable; without reliable transaction-level data, the count date can’t be moved.1Public Company Accounting Oversight Board. AS 2510 – Auditing Inventories
The Formula and Where the Numbers Come From
Beginning Inventory + Purchases − Cost of Goods Sold = Ending Inventory
Beginning inventory is the counted balance. Purchases means every addition during the window: goods received, finished production transferred in, customer returns added back. Cost of goods sold captures every removal: items sold, scrapped, written off, or transferred out.
Pull these from the perpetual system or general ledger at the transaction level, not as summary totals. Auditors will sample individual purchase orders and sales invoices against the figures you use, so the underlying detail has to be there.
Forward vs. Backward
Direction depends on whether the count happened before or after your target date, and getting the direction wrong on any single line is one of the most common errors.
A forward roll starts from a count before the target date. Add the purchases received between the two dates, subtract the cost of goods sold during that window.
A backward roll starts from a count after the target date, and the adjustments invert. Purchases received between the target date and the count date get subtracted, because those goods weren’t yet on hand at the target date. Cost of goods sold during that window gets added back, because those items were still on hand at the target date. Test every line against the target date: if the transaction happened on the far side of it, the sign flips.
How Your Cost Method Feeds the COGS Number
Two companies with identical physical stock can produce different ending balances depending on how they assign costs to outgoing units.
- FIFO assigns the oldest costs to goods sold first. In a rising-price period, that produces lower COGS and higher ending inventory.
- LIFO assigns the newest costs first. Rising prices mean higher COGS and lower ending inventory. Companies on LIFO track a LIFO reserve — the cumulative difference between LIFO-valued inventory and what it would be under FIFO — and any change in that reserve during the roll-forward window has to be accounted for.
- Weighted average cost divides total cost of goods available for sale by total units available, producing one blended unit cost applied to both COGS and remaining inventory. In a perpetual system, the average recalculates after every purchase.
Whichever method you use, hold it constant across the roll-forward window. Switching methods isn’t just an internal decision; it requires IRS approval on Form 3115 and triggers a Section 481(a) adjustment.2Internal Revenue Service. Instructions for Form 3115 – Application for Change in Accounting Method
Adjustments That Decide Whether the Balance Is Right
The formula gets you a preliminary figure. The adjustments below are where a roll forward either ties out to the ledger or quietly diverges from it.
Shrinkage
Shrinkage covers theft, damage, spoilage, and administrative errors like miscounts and mislabels. Federal tax law permits estimated shrinkage in inventory valuation as long as you perform regular physical counts to validate the estimates and adjust the method when the estimates prove off.3GovInfo. 26 USC 471 – General Rule for Inventories Most companies apply a historical shrink percentage to sales in the roll-forward window, record the estimate as a reduction to the calculated balance, and investigate any large deviation from the historical rate.
Write-Downs for Obsolescence or Damage
Inventory doesn’t always hold its cost. The GAAP rule depends on your method. Companies on FIFO or weighted average measure at lower of cost or net realizable value: if you can’t recover what you paid, write down to what you’ll actually get from selling it, net of costs to complete and sell. Companies on LIFO or the retail inventory method still use lower of cost or market, where “market” is replacement cost bounded by a ceiling and floor.4Financial Accounting Standards Board. ASU 2015-11 – Inventory (Topic 330) For tax, the IRS accepts lower-of-cost-or-market as one of two permissible methods under Section 471.5Internal Revenue Service. Lower of Cost or Market
During a roll forward, ask whether anything changed between the count date and the target date that would justify a write-down that didn’t exist at the count. A recall announced after the count is a classic example. The write-down is recorded as an inventory reserve, a contra-asset reducing carrying value.
Goods in Transit
Stock on a truck between the count date and the target date is easy to miss, and the shipping terms decide who owns it.
- FOB shipping point: ownership transfers when goods leave the seller’s dock. A shipment that left the supplier on December 29 and arrives January 3 belongs on your December 31 balance sheet even though no one counted it.
- FOB destination: ownership transfers on arrival. The same shipment stays with the seller until it reaches you.
Review open purchase orders and shipping documents for the window around the target date. Any FOB-shipping-point purchase that left the dock before the target date belongs in ending inventory. Miss it and you understate inventory while overstating COGS.
Consigned Goods
Consignment inventory sits in someone else’s warehouse but stays on the consignor’s books until it sells. If you’re the consignor, don’t drop those goods from your balance just because they weren’t physically present at your count. If you’re the consignee, don’t accidentally include goods on your shelves that belong to someone else — you record only the commission when the goods sell, not the goods themselves.
Cutoff Testing
Cutoff is where most roll forwards break. The term refers to the days immediately before and after the target date, when a transaction can slip into the wrong period. A sale shipped December 31 but invoiced January 2, or a purchase received January 1 but backdated to December 30, will throw the ending balance off.
Test cutoff by pulling shipping logs, receiving reports, and sales invoices from the last days of the period and the first days of the next, then matching each transaction to the date it was actually posted. Confirm the posting date matches the date ownership actually transferred. If your system auto-posts based on invoice date rather than shipment or receipt date, expect errors, and expect the roll forward to hide them unless someone looks.
Reconciling to the Ledger
Once the adjustments are in, compare the calculated ending balance against the general ledger and against the most recent physical count result. Any material gap gets investigated: start with cutoff, then look at unrecorded shrinkage, posting errors, and classification mistakes. A clean roll forward ties out within your materiality threshold with no unexplained differences.
How the Ending Balance Lands on the Tax Return
The number you produce doesn’t stop at the balance sheet. It flows onto the tax return, and the IRS has specific rules for what must be included and how changes get reported.
Form 1125-A
Any business that tracks inventory and deducts cost of goods sold attaches Form 1125-A to its corporate or partnership return. The form is an inventory reconciliation: Line 1 reports beginning-of-year inventory, Line 7 reports end-of-year inventory, and Line 8 calculates COGS by subtracting ending inventory from total goods available for sale. If you changed methods during the year, Line 1 has to be refigured under the new method, and the difference goes into a Section 481(a) adjustment. Line 9f asks directly whether quantities, costs, or valuations were determined differently between opening and closing inventory, and requires an attached explanation if so.6Internal Revenue Service. Form 1125-A (Rev. November 2024) That line exists to surface exactly the kind of inconsistency a sloppy roll forward can introduce.
Section 263A Costs
If you produce goods or acquire them for resale, the uniform capitalization rules under Section 263A require certain indirect costs — warehouse overhead, purchasing, handling — to be capitalized into inventory rather than expensed.7Office of the Law Revision Counsel. 26 USC 263A – Capitalization and Inclusion in Inventory Costs of Certain Expenses Ending inventory on Form 1125-A must include those capitalized amounts. A roll forward that only tracks direct purchase cost will understate ending inventory and overstate the COGS deduction.
Changing Methods
A switch between FIFO and LIFO, a change in valuation approach, or any other shift in inventory accounting requires Form 3115. The resulting Section 481(a) adjustment captures the cumulative income difference from using the old method. A positive adjustment (more income) spreads over four tax years; a negative adjustment (less income) takes the full deduction in the year of change.2Internal Revenue Service. Instructions for Form 3115 – Application for Change in Accounting Method
Small businesses meeting the gross receipts test under Section 448(c) get more flexibility. They can skip formal inventory accounting and treat inventory as non-incidental materials and supplies, or conform to the method used in their financial statements.3GovInfo. 26 USC 471 – General Rule for Inventories The roll forward gets simpler, but records still have to match what appears on Form 1125-A.
What Happens When the Number Is Wrong
For public companies, inaccurate inventory carries securities-law exposure. The Securities Exchange Act requires issuers to keep books and records that “accurately and fairly reflect the transactions and dispositions of the assets” and to maintain internal controls sufficient to ensure recording consistent with GAAP.8Office of the Law Revision Counsel. 15 USC 78m – Periodical and Other Reports The SEC has brought enforcement actions where inventory systems couldn’t support the company’s disclosed methodology, resulting in multi-year restatements, civil penalties, and cease-and-desist orders against both the company and its former CEO.9Securities and Exchange Commission. SEC Charges Retailer and Former CEO for Accounting, Reporting, and Control Failures
For private companies, the exposure runs through the tax return. A misstated ending inventory flows straight into cost of goods sold and distorts taxable income. And because this year’s ending inventory becomes next year’s beginning inventory, one roll-forward error can distort two consecutive tax years before anyone notices.