Roll Forward Report

What is a Roll Forward Report in Accounting?

A roll forward report shows how one balance or account changes from the start of a period to the end of it. It begins with the opening balance, adds all increases, subtracts all decreases, and arrives at the closing balance.

The report highlights the movement of each line item over time, giving you a clear, step-by-step view of what caused the change. It’s called “roll forward” because you take the balance from a previous period and roll it forward into the next one.

Think of it as carrying over last period’s ending balance, then updating it with the new activity to arrive at the current balance. Each period builds on the one before it, so you’re essentially rolling the numbers forward through time instead of starting from scratch.

Synonyms

• Continuity schedule
• Movement schedule

How Roll Forward Accounting Works

Roll forward accounting is a simple but structured workflow. You always move step by step from the prior period to the current one.

Here’s how it works:

• Start with the opening balance. Take the ending balance from the previous reporting period. This becomes your starting point.
• Add all increases. Record transactions or events that raised the balance. For example, new purchases for inventory or new subscriptions billed for deferred revenue.
• Subtract all decreases. Deduct transactions that lowered the balance, such as depreciation, amortization, or customer revenue you’ve recognized.
• Arrive at the closing balance. After adding and subtracting the activity, you have the new ending balance for the period.
• Reconcile and review. Compare the closing balance in your roll forward schedule against the general ledger or subledger. If they don’t match, identify and fix the differences.
• Carry it into the next period. The closing balance becomes the opening balance for the next roll forward, and the cycle repeats.

You build separate roll forward schedules for accounts that need detailed tracking or reconciliations. Common accounts on roll forward schedules include inventory, fixed assets, equity balances, deferred revenue, accounts payable, and accounts receivable. That way, every account that needs explanation or audit support gets it.

The roll forward accounting process

Starting balance

Closing balance

Start with the opening balance from the previous period.

Add all increases that raised the balance.

Subtract all decreases that lowered the balance.

Arrive at the closing balance for the period.

Reconcile and review against the general ledger.

Carry the closing balance into the next period.

Repeat the cycle for each reporting period.

Roll forward report vs. standard trial balance or general ledger

The general ledger is your central record of every transaction posted to every account. It shows the full history of activity across all accounts in chronological order, not just the ending balances.

A trial balance is a snapshot of all your general ledger accounts and their debit or credit balances at a specific point in time. Its main purpose is to check that total debits equal total credits so you can catch arithmetic or posting errors before preparing financial statements.

A roll forward report is different. It focuses on one account and explains how that single balance changed from the prior to the current period. For example, inventory sits on a roll forward schedule because you need to show how purchases increased the balance and sales or write-offs reduced it.

TL;DR:

• The general ledger shows all activity.
• The trial balance verifies the math.
• The roll forward report explains movement in a specific account over time.

Which accounts need roll forward reports?

Cash

Tracks cash inflows and outflows to explain liquidity changes.

Accounts receivable

Shows billed customer balances collected or written off.

Accounts payable

Tracks unpaid vendor bills and payments reducing liabilities over time.

Inventory

Explains purchases, production costs, and goods sold each period.

Fixed assets (PP&E)

Records acquisitions, disposals, and depreciation on physical assets.

Equity accounts

Captures owner investments, distributions, and retained earnings adjustments.

Deferred revenue

Shows billings received in advance and revenue recognized later.

Long-term debt

Details new borrowings, repayments, and interest applied each period.

Intangible assets

Tracks patents, trademarks, and other non-tangible holdings.

Why Roll Forward Reports are Important

Roll forward reports connect the dots between where you started and where you ended, making financial activity easier to understand. Since they zero in on each individual account, they reveal exactly how each variable affects your overall financial performance.

This offers several critical benefits for both your accounting department and your business as a whole:

• Improves transparency for internal reviews and external audits
• Builds confidence in reported balances and financial statements
• Simplifies reconciliations between subledgers and the general ledger
• Strengthens controls by documenting every movement in critical accounts
• Speeds up month-end and year-end close processes
• Reduces errors by exposing discrepancies early
• Enhances communication between finance teams and stakeholders
• Helps high-level decision-makers understand trends and anomalies

Imagine trying to explain a sudden $50,000 drop in cash without showing the steps that caused it. A roll forward report makes that explanation straightforward and credible.

Roll forward reporting is also critical for GAAP and IFRS compliance because it documents every change in your key accounts. Auditors rely on these reports to verify the accuracy of your reported numbers and make sure a clear trail of activity supports your financial statements.

Common Use Cases for Roll Forward Reports

Roll forward reports are valuable whenever you need to explain changes in balances and verify the numbers tie back to real activity. The most common uses are in financial auditing, financial close processes, fixed asset management, inventory control, receivables, and payables.

Auditing

Auditors use roll forward reports as a way of confirming your balances tie directly to source documents and underlying transactions. This clear trail of changes makes testing and verification faster and more reliable.

Monthly, quarterly, and annual close

Finance teams use roll forward schedules when they reconcile accounts at the end of each reporting period. With the detailed breakdown, it’s easier to pinpoint discrepancies and finalize reports on time.

Fixed asset management

Roll forward reports help you track asset acquisitions, disposals, and depreciation of assets like buildings, machinery, and equipment. They keep your fixed asset balances accurate and up to date.

Inventory control

Inventory roll forwards show how beginning stock, purchases, and usage lead to the ending balance. They help your team spot shrinkage, miscounts, and valuation issues before they affect your balance sheet and income statement.

Accounts receivable and payable

Roll forward reports give your billing and accounting teams a running picture of outstanding receivables and payables. They show how much was billed or owed, how much was collected or paid, and the remaining balance over time.

Components of a Roll Forward Report

Every roll forward report has nine core elements that keep the report clear, consistent, and useful:

• Account name
• Account description
• Reporting period
• Opening balance
• Additions or increases
• Reductions or decreases
• Adjustments
• Closing balance
• Supporting details or notes

Key components of a roll forward report

Account name

Clearly identify the account being tracked (e.g., inventory, deferred revenue) so there’s no confusion about what the numbers represent.

Account description

Briefly describe the account for further clarity and differentiation from other roll forward accounts.

Reporting period

Specify the time frame you’re covering—monthly, quarterly, or annually—to define the scope of activity.

Opening balance

Start with the ending balance from the previous period as your baseline.

Additions or increases

List all transactions or activities that raised the balance during the period.

Reductions or decreases

Show all deductions, such as expenses, disposals, or revenue recognition, that lowered the balance.

Adjustments

Include corrections, write-offs, or reclassifications to keep the account accurate and aligned with accounting standards.

Closing balance

Display the final calculated balance after all additions, reductions, and adjustments.

Supporting details or notes

Include references to source documents, invoices, journal entries, and/or explanations for unusual fluctuations.

How to Create a Roll Forward Report

There’s a ten-step process we follow here at DealHub whenever we create a roll forward report:

• Pick the account and period. Any account that shows movement over time and needs reconciliation deserves its own roll forward report.
• Pull the opening balance. Use last period’s ending balance, whether your focus is on the month, quarter, or year.
• Gather the period’s source data. Export from the general ledger and subledgers.
• Classify activity. Separate increases and decreases by clear categories.
• Record adjustments. Include corrections, write-offs, and reclasses with explanations for each.
• Calculate the closing balance. Opening + Increases – Decreases + Adjustments = Closing.
• Reconcile to the general ledger. Resolve the differences line by line.
• Add references and notes. Link to invoices, journals, and support for unusual movements (and audit readiness).
• Review and approve. Get sign-off from the owner and the financial controller.
• Lock the schedule. Carry the closing balance into the next period.

Tip: Use accounting software to automate data pulls, apply formulas, attach source documents, and roll balances forward with an audit-ready trail.

Roll Forward Report Example

To help you grasp the concept, here’s a quick example of how you’d prepare a roll forward report for an equipment account:

• Account: Equipment – January 2025
• Beginning balance – $50,000
• Additions – $10,000
• Deductions – ($2,000)
• Adjustments – $500
• Ending balance – $58,500

What this means is:

• You started January with $50,000 worth of inventory on hand.
• During the month, you purchased an additional $10,000 of goods, increasing your total stock.
• You then sold or used $2,000 worth of inventory, which reduced the balance.
• An adjustment of $500 (maybe from a valuation update or correcting a counting error) brought the total to an ending balance of $55,500.

So, you purchased more than you sold or used. While that might indicate healthy stock levels for future sales, it also means more cash is tied up in inventory. If the balance keeps rising without a matching sales increase, it may signal overstocking, slower turnover, or obsolescence.

Best Practices for Managing Roll Forward Reports

If you want your roll forward reports to be airtight and audit-ready, you need more than just clean tables. Here’s how our team would approach it as people who have managed these schedules for a multimillion-dollar SaaS company for years:

Tie every number back to source data.

Never rely on estimates or unverified balances. Every addition, deduction, or adjustment should link to an invoice, journal entry, or subledger. When an auditor asks “Where did this come from?” you’ll have the backup in seconds.

Keep a clear audit trail.

Document every change you make to a schedule with the date, reason, and supporting evidence. You’ll save yourself hours of digging when reconciling or answering questions at month-end. This is something enterprise accounting systems will handle automatically. 

Align your schedules with the general ledger daily.

Don’t wait until the close to reconcile. The sooner you catch discrepancies between your roll forward and the ledger, the easier they are to fix because every following number will be incorrect. 

Use consistent formats and naming conventions.

Confusion often comes from inconsistent layouts. Use the same columns, date ranges, and terminology for all schedules. Anyone on your team should be able to pick one up and know exactly what they’re looking at.

Flag unusual fluctuations immediately.

Big swings in account balances deserve an explanation sooner rather than later. Taking a proactive approach helps you avoid surprises when it comes time to present the report to leadership or auditors.

Automate whenever possible.

Manual spreadsheets are prone to errors. If you’re pulling data and updating balances by hand, you’re wasting time and increasing risk. Invest in accounting software that integrates with your ledger and keeps a live connection to your roll forward schedules.

Review regularly, not just at close.

Roll forwards shouldn’t be something you only look at during month-end or year-end. Treat them as living documents that give you insight into daily operations, particularly for cash, inventory, and receivables.

Roll Forward Reports and Accounting Technology

Roll forward reporting relies on the same tools you use for financial reporting: your accounting software, ERP system, or spreadsheet platform you use to build and maintain each schedule.

That said, we don’t recommend using spreadsheets for anything beyond the simplest accounts in a small business. Spreadsheets don’t scale, are prone to human error, and lack proper version control.

Accounting and ERP software automate the roll forward process itself. Rather than manually pulling data from subledgers, they update your schedules in real time as transactions post. That means fewer errors, cleaner audit trails, better finance team collaboration, and faster closes.

Automation is a game-changer because it links your roll forward schedules directly to source transactions. You can drill down from a balance to the invoice or journal entry behind it in seconds, which is invaluable during reconciliations and audits.If your organization is growing or if you’re dealing with complicated revenue recognition (like SaaS billing or milestone-based pricing), that’s what you need.

People Also Ask