An inventory roll forward moves a verified physical count to a different valuation date by adding every stock increase and subtracting every stock decrease that occurred in between. The formula is Beginning Inventory + Purchases − Cost of Goods Sold = Ending Inventory, applied to the window between your count date and your target date, with adjustments for shrinkage, write-downs, goods in transit, consignment, and cutoff timing. Companies use the procedure when counting on the exact balance sheet date isn’t practical, and PCAOB Auditing Standard 2510 explicitly permits observing physical counts at a different date so long as “appropriate tests of intervening transactions” connect the two.1Public Company Accounting Oversight Board. AS 2510 – Auditing Inventories
The Core Formula and Where the Numbers Come From
The arithmetic is one line:
Beginning Inventory + Purchases − Cost of Goods Sold = Ending Inventory
Beginning Inventory is the verified balance from your physical count. Purchases covers every addition during the roll-forward window: new merchandise received, finished goods transferred in from production, customer returns added back to stock. Cost of Goods Sold captures every removal: items sold, scrapped, written off, or transferred out.
Pull these figures from the perpetual inventory system or general ledger at the transaction level, not as summary estimates. Auditors will sample individual purchase orders and sales invoices to confirm the totals. Well-maintained perpetual records that are regularly reconciled against physical counts are what make an off-date count acceptable under AS 2510 in the first place.1Public Company Accounting Oversight Board. AS 2510 – Auditing Inventories
Rolling Forward vs. Rolling Backward
The direction depends on when you counted. A forward roll starts from a count performed before the balance sheet date. A November 30 count rolling to December 31 means you add December purchases and subtract December’s cost of goods sold.
A backward roll starts from a count performed after the balance sheet date. A January 15 count rolling back to December 31 inverts the signs. You subtract purchases received between December 31 and January 15, because those goods weren’t in the warehouse on the target date, and add back cost of goods sold during that window, because those items were still on hand at year-end. Getting the direction wrong on any single line is one of the most common roll-forward errors. If a transaction happened after your target date, it needs to be reversed, not added.
Keeping the Cost Flow Assumption Consistent
The formula is only as reliable as the cost assigned to goods sold. Two companies with identical physical stock can report different ending balances depending on their cost flow method.
- FIFO (first-in, first-out) assigns the oldest costs to goods sold first. In a period of rising prices, this produces a lower COGS and a higher ending inventory balance.
- LIFO (last-in, first-out) assigns the newest costs to goods sold first. Rising prices mean higher COGS and a lower ending inventory. LIFO users 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 must be captured.
- Weighted average cost divides total cost of goods available by total units available, producing a single blended unit cost. It smooths price swings but requires recalculation after every purchase under a perpetual system.
The method has to stay the same across the roll-forward period. Switching mid-stream isn’t a bookkeeping choice; it requires IRS approval through Form 3115 and triggers a cumulative income adjustment under Section 481(a).2Internal Revenue Service. Instructions for Form 3115 – Application for Change in Accounting Method
The Adjustments That Decide Whether the Reconciliation Holds
The basic formula produces a preliminary number. The adjustments produce an accurate one. A roll forward that ignores shrinkage, write-downs, or ownership timing will look reasonable on paper and fall apart against the general ledger or a later physical count.
Shrinkage
Shrinkage is stock lost to theft, damage, spoilage, and administrative errors like miscounts or mislabeling. Federal tax law permits estimated shrinkage figures in inventory valuation, provided you perform physical counts regularly to validate the estimates and adjust your method when they miss.3GovInfo. 26 USC 471 – General Rule for Inventories Most companies estimate shrinkage as a percentage of sales applied to the roll-forward window. Record it as a reduction to the calculated balance and investigate any large swing from the historical rate.
Write-Downs for Obsolescence or Damage
Inventory sitting in the warehouse doesn’t always hold its value. Under current GAAP, the write-down rule depends on your cost method. FIFO and weighted average cost users measure inventory at the lower of cost or net realizable value, meaning if you can’t recover what you paid, you write down to what you’d actually get from selling it, minus completion and selling costs. LIFO and retail inventory method users still follow the older “lower of cost or market” framework, where “market” is replacement cost bounded by a ceiling and floor.4Financial Accounting Standards Board. ASU 2015-11 – Inventory (Topic 330) For tax purposes, the IRS allows a lower-of-cost-or-market valuation as one of two permissible inventory methods under Section 471.5Internal Revenue Service. Lower of Cost or Market
These write-downs post as an inventory reserve, a contra-asset reducing the carrying value. During a roll forward, evaluate whether conditions changed between count date and target date. A product recall announced in late December could require a significant write-down that didn’t exist at a mid-November count.
Goods in Transit
Stock moving between parties around the target date is easy to overlook, and the ownership terms decide whose balance it belongs on:
- FOB shipping point: ownership transfers when the goods leave the seller’s dock. A shipment that left the supplier on December 29 and arrives January 3 is your inventory on the December 31 balance sheet even though nobody could have counted it.
- FOB destination: ownership transfers when the goods arrive at your location. That same December 29 shipment stays on the seller’s books until it reaches you.
Review open purchase orders and shipping documents for the days surrounding the target date. Any FOB-shipping-point purchase that shipped before year-end belongs in ending inventory even if physical receipt happened after the count. Miss this and you’ll understate inventory and overstate COGS.
Consigned Goods
Consignment stock sits in someone else’s warehouse but still belongs to you until it sells. If you’re the consignor, those goods stay on your balance sheet regardless of location. If you’re the consignee holding another party’s goods, you don’t record them as your asset; only the commission you earn on sale. During a roll forward, confirm that consigned-out goods aren’t dropped because they weren’t physically present at the count, and consigned-in goods aren’t included just because they were on your shelf.
Cutoff Testing and Final Reconciliation
Cutoff is where most roll forwards go wrong. It refers to the days immediately before and after the target date, the window where a transaction can land in the wrong period if someone processes it a day early or a day late. A sale shipped December 31 but not invoiced until January 2, or a purchase received January 1 but backdated to December 30, will throw off the ending balance.
Auditors focus heavily on cutoff. They’ll pull shipping logs, receiving reports, and sales invoices from the final days of the period and the first days of the next, matching each transaction to the date it was actually recorded. If your system auto-posts based on invoice date rather than shipment or receipt date, cutoff errors are likely, and the roll forward will absorb them invisibly unless someone checks.
The final step compares your adjusted calculated balance against both the general ledger and the most recent physical count result. A material gap triggers investigation, starting with cutoff and moving to unrecorded shrinkage, posting errors, and classification mistakes. A clean roll forward ties out within your materiality threshold with no unexplained differences.
How the Result Feeds Your Tax Return
The ending balance from the roll forward flows directly onto the tax return, and the IRS has specific requirements for how it gets reported and what costs must be inside the number.
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 itself 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 your inventory method during the year, Line 1 must be refigured using the new method, with any difference between the original and restated amount going into a Section 481(a) adjustment.6Internal Revenue Service. Form 1125-A (Rev. November 2024)
Line 9f asks whether there was any change in how you determined quantities, costs, or valuations between opening and closing inventory. If there was, you attach an explanation. The IRS is flagging exactly the kind of inconsistency a sloppy roll forward produces.
Section 263A Costs
If you produce goods or acquire them for resale, the uniform capitalization rules under Section 263A require certain indirect costs, including warehouse overhead, purchasing costs, and handling, to be capitalized into inventory rather than expensed immediately.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 these capitalized amounts. A roll forward that tracks only direct purchase costs and ignores the 263A allocation will understate ending inventory and overstate the COGS deduction.
Changing Your Inventory Method
Switching from FIFO to LIFO, changing your valuation approach, or shifting any other aspect of how you account for inventory requires filing Form 3115. The change produces a Section 481(a) adjustment capturing the cumulative income difference from the old method. A positive adjustment (one that increases taxable income) spreads over four tax years. A negative adjustment comes through fully in the year of change.2Internal Revenue Service. Instructions for Form 3115 – Application for Change in Accounting Method
What a Bad Number Costs
For public companies, inaccurate inventory reporting carries direct legal exposure. The Securities Exchange Act requires every issuer 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 transactions are recorded consistently with GAAP.8Office of the Law Revision Counsel. 15 USC 78m – Periodical and Other Reports
In one SEC action, a retailer’s inventory tracking system couldn’t support its disclosed accounting methodology because it failed to maintain historical cost data. The result was a multi-year restatement covering fiscal years 2017 through 2019, civil penalties of $200,000 for the company and $25,000 for the former CEO, and cease-and-desist orders against both.9Securities and Exchange Commission. SEC Charges Retailer and Former CEO for Accounting, Reporting, and Control Failures The underlying problem wasn’t fraud. It was a system producing unreliable valuation data, which is the kind of breakdown a well-executed roll forward is designed to catch before it compounds.
For private companies the stakes are different but still real. A misstated ending inventory flows straight into COGS on the tax return, overstating or understating taxable income. The error carries forward too: this year’s ending inventory becomes next year’s beginning inventory, so one bad roll forward can distort two consecutive tax years before anyone notices.