Fixed asset rollforward that flags the breaks.

Does it tie out, and if not, where is the difference?

Roll cost and accumulated depreciation by asset class from opening to closing, compare with the general ledger, check transfers net to zero and tie depreciation and disposal gains to the income statement.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Rollforward by asset class

Enter each class from the fixed asset register and the general ledger. Accumulated depreciation is entered as a positive number. Scroll the table sideways on a phone.

Line
Opening cost
Additions
Disposals (cost)
Transfers in / (out)
Closing cost per GL
Opening accumulated depreciation
Depreciation expense
Disposals (accumulated depreciation)
Closing accumulated depreciation per GL
Disposal proceeds
Expected closing cost$4,510,000.00$2,895,000.00$80,000.00
Cost break (GL − expected)$0.00$0.00$0.00
Expected closing accumulated depreciation$1,372,750.00$1,617,000.00$0.00
AD break (GL − expected)$0.00$5,000.00$0.00
Net book value, closing$3,137,250.00$1,273,000.00$80,000.00
Gain / (loss) on disposal$0.00-$2,500.00$0.00
Tie to the income statement
Breaks found
1
Tolerance $1.00
Net book value, closing
$4,490,250
Opening $4,290,000
Depreciation in rollforward
$377,750
Income statement $377,750
Action
1 break to resolve
  • Machinery & equipment: accumulated depreciation does not roll by $5,000.00
How this was worked out
Work shownrecomputed as you type
Expected closing cost = opening cost + additions − disposals + transfers
Expected closing accumulated depreciation = opening + depreciation expense − accumulated depreciation on disposals
Break = closing balance per GL − expected closing (flagged when larger than $1.00)
Gain / (loss) = proceeds − (cost disposed − accumulated depreciation disposed); total -$2,500.00
Transfers across classes net to $0.00 (should be zero); depreciation $377,750.00 vs. income statement $377,750.00

The rollforward supports the property, plant and equipment disclosures: balances of major classes, accumulated depreciation and depreciation expense for the period (ASC 360-10-50-1). Recompute the depreciation expense line with the depreciation calculator. Impairment write-downs (ASC 360-10-35-17) and assets held for sale need their own lines if the client has them.

The rollforward as the backbone of PP&E testing

Most property, plant and equipment procedures hang off the rollforward: vouching additions, testing disposals and the gain or loss, recomputing depreciation, and agreeing the closing balances to the trial balance. It also supports the disclosures ASC 360-10-50-1 requires: balances of major classes, accumulated depreciation and depreciation expense for the period.

A rollforward that does not foot or does not agree to the ledger points to an unrecorded movement. Resolve every break before sampling from it. Recompute the depreciation line with the depreciation calculator.

Common questions

What is a fixed asset rollforward?

A schedule that starts from opening cost and accumulated depreciation for each asset class, adds additions and depreciation, removes disposals, and arrives at the closing balances. The closing figures must agree with the general ledger.

What does a break in the rollforward mean?

The movements do not explain the change in the ledger balance. Common causes are unrecorded disposals, additions posted straight to expense or to the wrong class, depreciation journals that differ from the register, and transfers out of construction in progress recorded on one side only.

How is the gain or loss on disposal calculated?

Gain or loss = proceeds − net book value disposed, where net book value = cost disposed − accumulated depreciation disposed. The total should agree with the income statement.

What disclosures does the rollforward support?

ASC 360-10-50-1 requires depreciation expense for the period, balances of major classes of depreciable assets, accumulated depreciation, and a description of the depreciation methods.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required