Rollforward accounting: reconcile opening to closing balances

Rollforward accounting reconciles an opening balance to a closing balance by adding the period's signed movements. The schedule should explain both the amount that changed and the transactions behind that change. Compare the calculated close with the current trial balance before calling the account reconciled.

Define the account and the period

Calculated closing balance = Opening balance + Additions − Reductions + Signed other movements

Reconciliation difference = Calculated closing balance − Recorded closing balance

Take the opening balance from the previous approved close. Export posted activity for the period, and obtain the current closing trial balance independently. Define the entity, account, currency and posting cutoff before joining them.

Keep journal IDs and document references in the movement export. The IRS's recordkeeping guidance explains that business transactions generate supporting documents containing the information recorded in the books. Those references make a rollforward reviewable when a total needs explanation.

For an asset account, the example below treats increases as positive and decreases as negative. A liability schedule needs its own consistent convention. A credit-positive balance export cannot be combined blindly with debit-positive activity. The distinction between accrual and cash accounting also matters: noncash postings remain part of an accrual-account rollforward.

Start with a ledger export

A US company is reconciling prepaid insurance for October 2026. Its opening balance is $120,000. The movement worksheet contains only the posted entries below, with actual spreadsheet dates in column A.

These are account-side ledger amounts, rather than both sides of every journal. The reclassification transfers a balance out of this account; its offset belongs to another account's reconciliation. Retain the journal reference so the reviewer can inspect both sides without double counting them here.

Remove duplicate export rows only after checking their journal-line identifiers. Repeated journal IDs alone do not establish duplication because a journal can legitimately contain several lines.

Calculate the close in a spreadsheet

Name the source worksheet Movements; its entries occupy rows 2:7. On a Summary worksheet, put Prepaid insurance in A2 and the opening balance in B2. In J1 and J2, set the period boundaries:

=DATE(2026,10,1)
=DATE(2026,11,1)

Calculate net movement in C2:

=SUMIFS(Movements!$E$2:$E$7,Movements!$C$2:$C$7,$A2,Movements!$A$2:$A$7,">="&$J$1,Movements!$A$2:$A$7,"<"&$J$2)

The date conditions include the start of October and exclude the start of November. The account condition stops another account's rows from entering the total. Microsoft documents SUMIFS as adding amounts that satisfy multiple criteria; all criteria ranges must match the sum range's dimensions.

Calculate the closing balance in D2:

=B2+C2

Enter the independently exported closing balance in E2, then calculate the difference in F2:

=D2-E2

The net movement is $48,000 + $12,000 − $18,000 − $16,000 − $14,000 − $5,000 = $7,000. Adding that to $120,000 gives $127,000. The example uses whole dollars without rounding. Covirage is not affiliated with Microsoft.

Explain the movement as well as the balance

Group the same six source rows by category. Additions total $60,000, expense releases total $48,000 and the transfer out is $5,000. Show reductions as positive values in the presentation below, even though the source entries are negative.

This categorized bridge must give the same closing balance as the signed transaction sum. If it does not, a movement category is missing, duplicated or assigned the wrong sign.

The controller owns the reconciliation and sign-off. The account preparer supplies the movement explanations and supporting records. An FP&A reviewer can then use flux analysis to explain why the balance changed, with the rollforward supplying the underlying evidence.

Where it goes wrong

• Opening from an outdated close. A late approved adjustment changes the starting point. Confirm the prior closing version before calculating the movement.
• Changing the sign convention halfway through. Subtracting an already negative expense doubles its effect. Separate source signs from presentation labels.
• Dropping reclassifications. A transfer may have no company-wide earnings effect but still changes this account. Keep it in the schedule.
• Summing displayed rows only in your head. Spreadsheet totals can include rows hidden by a filter. Use account and date criteria rather than relying on what is visible.
• Accepting a zero total without reviewing scope. Offsetting errors can cancel. Check document coverage and compare relevant subledger detail with the control account.

For specialist applications, the ending accounts payable formula uses supplier invoices and settlements as movement categories. Analytics for tax and accounting describes the broader use of uploaded accounting schedules.

Reconcile your own workbook in Covirage

Upload a file or Google Sheet with opening balances, posted movements and the closing ledger. Covirage maps the columns; its tools compute and check the balance bridge, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own workbook.

See Covirage for finance teams for the supporting reporting workflow.