What are Rollforward Schedules?
Definition
Rollforward Schedules are finance schedules that explain how an account balance moves from opening balance to closing balance during a reporting period. They show additions, reductions, transfers, adjustments, and ending balances so finance teams can support reconciliations, financial reporting, cash flow analysis, and audit review.
How Rollforward Schedules Work
A rollforward starts with the opening balance from the prior period, adds current-period activity, subtracts reductions, includes reclasses or adjustments, and arrives at the closing balance. The core structure is: opening balance + additions - reductions +/- adjustments = closing balance.
For example, if an asset account opens at $500,000, has additions of $80,000, disposals of $30,000, and adjustments of $5,000, the closing balance is $555,000. This makes the movement visible and easier to validate.
Core Components
Most rollforward schedules include the same basic elements, but the details vary by account type. The schedule should tie to the general ledger, supporting documents, and financial statement line items.
Opening balance: the prior-period closing balance.
Additions: purchases, new contracts, new assets, or new obligations.
Reductions: payments, disposals, usage, releases, or settlements.
Adjustments: reclasses, corrections, impairments, foreign exchange, or close entries.
Closing balance: the final amount reported for the period.
Common Types
An Asset Rollforward tracks asset additions, disposals, depreciation, impairment, and ending net book value. A WIP Rollforward shows how work-in-progress moves through additions, transfers, completions, and write-offs. An Inventory Rollforward explains purchases, production, transfers, cost of goods sold, write-downs, and ending inventory.
For revenue-related balances, a Deferred Revenue Rollforward shows billings, revenue recognized, adjustments, and ending deferred revenue. A Contract Asset Rollforward or Contract Asset Rollforward Model helps explain contract performance, revenue recognition, billing timing, and remaining asset balances.
Lease and Liability Use Cases
Lease accounting often depends on rollforwards because right-of-use assets and lease liabilities change each period. A Lease Asset Rollforward shows opening asset balance, additions, amortization, modifications, impairments, and closing asset value. A Lease Liability Rollforward shows opening liability, interest expense, lease payments, modifications, and ending liability.
These schedules help reviewers confirm that expense recognition, liability balances, and cash payments are consistent across the ledger, financial statements, and supporting lease records.
Business Use Cases
Rollforward schedules support month-end close, account reconciliation, audit preparation, lender reporting, board reporting, and management analysis. They help finance teams explain not only what the closing balance is, but how the company got there.
They are especially useful for accounts with frequent movement, such as fixed assets, inventory, contract assets, deferred revenue, leases, debt, provisions, and reserves. They also help management understand cash flow timing, profitability drivers, asset utilization, and balance sheet quality.
Best Practices
Effective rollforward schedules should have clear ownership, source references, calculation logic, tie-out checks, and reviewer sign-off. Each movement should be supported by transaction details, journal entries, contracts, invoices, system reports, or approval evidence.
The strongest rollforwards reconcile to the general ledger, explain unusual movements, separate recurring activity from one-time adjustments, and provide enough detail for financial reporting and audit readiness.
Summary
Rollforward Schedules explain the movement from opening balance to closing balance for key financial accounts. They strengthen financial reporting, cash flow visibility, audit readiness, and business decisions by making account changes traceable, explainable, and supported.
