Prepare a Fixed Asset Roll-Forward

The auditors ask for a roll-forward and it takes a week

Every year end the same request arrives: show how the fixed asset balance moved from last year to this year. Cost in, cost out, depreciation charged, depreciation released on disposals, by category.

Building it means pulling the register at two dates, matching additions to purchases, matching disposals to sales and reconciling the depreciation charge to the ledger. If the register is a spreadsheet, each of those is a manual exercise.

The result is often correct only until someone finds a late disposal and the whole schedule has to be redone.

Why this happens

The register does not remember what an asset was worth at a past date.
Depreciation is calculated outside the system that holds the assets.
Disposals are not recorded on the date they happened.
Categories are inconsistent, so movements land in the wrong row.

Biznsbook addresses this through roll-forward report, fixed asset register, asset categories when Accounting and Finance Management are licensed. Each asset carries its own depreciation settings, and the receipt or conversion that brought it in stays linked to the same record.

Books and registers drift when depreciation is worked out in one place and posted in another. Keeping the settings on the asset, reviewing a preview and posting one journal keeps the register, the ledger and the reports telling the same story.

Step-by-step: Prepare a Fixed Asset Roll-Forward

Built for accountants, finance controllers and fixed asset managers who depreciate and report on company equipment in Biznsbook. It needs Accounting and Finance Management as well as Fixed Assets Tracking.

Make sure every asset has a category. The roll-forward is grouped by Finance asset category. Assets received through a goods receipt or converted from stock get the category of their asset type. Anything waiting in the capitalization queue is not yet in the register.
Finish the depreciation runs for the period. Post or reverse any draft runs so the charge for the period is complete. A draft run is not part of the report.
Post any disposals still waiting. Assets that show Disposal to post have been disposed operationally but not in the ledger. Post them so they leave the register in the right period.
Open the roll-forward and choose the period. In Finance, Asset reports, Roll-forward, enter the start and end dates. The default is the start of the year to today.
Read cost first. Opening cost is assets bought before the start. Additions are assets bought in the period. Disposals are the cost of assets disposed in the period. Closing cost is opening plus additions less disposals.
Read accumulated depreciation next. Opening balance, the charge for the period from posted runs and disposal catch-up, depreciation removed on assets disposed, and the closing balance. Depreciation entered as an opening balance on an asset added in the period appears under additions.
Check net book value. Closing cost less closing accumulated depreciation is closing net book value. For a period that ends today it equals the total on the fixed asset register.
Export it. Export the roll-forward to Excel. The register can be exported too, grouped by category, for the supporting detail.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Screen names in this guide match the product: Finance, Depreciation runs, Fixed assets, Asset categories, Capitalization queue and Asset reports. Every screen has a Help button.

Common mistakes to avoid

Mistake 1: The register does not remember what an asset was worth at a past date. Repeating this each month usually shows up first in depreciation that does not match the register, a disposal with the wrong gain or loss, or a roll-forward that has to be rebuilt.
Mistake 2: Depreciation is calculated outside the system that holds the assets. Repeating this each month usually shows up first in depreciation that does not match the register, a disposal with the wrong gain or loss, or a roll-forward that has to be rebuilt.
Mistake 3: Disposals are not recorded on the date they happened. Repeating this each month usually shows up first in depreciation that does not match the register, a disposal with the wrong gain or loss, or a roll-forward that has to be rebuilt.
Mistake 4: Categories are inconsistent, so movements land in the wrong row. Repeating this each month usually shows up first in depreciation that does not match the register, a disposal with the wrong gain or loss, or a roll-forward that has to be rebuilt.

Note each recurring gap in the monthly review; each should map to a step in this guide.

Best practices that hold up as you scale

Make sure every asset has a category — The roll-forward is grouped by Finance asset category.
Finish the depreciation runs for the period — Post or reverse any draft runs so the charge for the period is complete.
Post any disposals still waiting — Assets that show Disposal to post have been disposed operationally but not in the ledger.
Open the roll-forward and choose the period — In Finance, Asset reports, Roll-forward, enter the start and end dates.
Read cost first — Opening cost is assets bought before the start.

Teams that post depreciation every month, post disposals when they happen and clear the capitalization queue at month end find year end a review rather than a rebuild.

How Biznsbook supports this workflow

roll-forward report is part of Biznsbook fixed asset accounting. Every asset has one record with its cost, depreciation settings, accumulated depreciation and net book value, and it links back to the receipt or conversion that created it.

fixed asset register is part of Biznsbook fixed asset accounting. Every asset has one record with its cost, depreciation settings, accumulated depreciation and net book value, and it links back to the receipt or conversion that created it.

asset categories is part of Biznsbook fixed asset accounting. Every asset has one record with its cost, depreciation settings, accumulated depreciation and net book value, and it links back to the receipt or conversion that created it.

Running depreciation and posting disposals are separate permissions held by finance roles. Viewing finance data, creating journals and managing tracked assets are also separate.

Suggested implementation timeline

Week 1: Agree the depreciation policy with your accountant and set up an asset category for each class of asset.
Week 2: Enter existing assets with their depreciation to date and start using roll-forward report for the first month.
Week 3: Compare the first posted run with your own workings and correct any category defaults.
Week 4: Post disposals, clear the capitalization queue and review the register.
Ongoing: Monthly review using how the report counts an asset and the asset reports.

Also see receive assets from purchase orders and manage fixed asset depreciation schedules. All guides: asset tracking. Product page: Asset Tracking.

What the report does not do

The roll-forward is built from the asset register and the depreciation runs. It does not read the ledger, so agree the closing figures to the balance sheet as part of your normal review.

It does not show revaluations or impairments. Book depreciation is monthly and there are no tax basis columns.

A routine that keeps it easy

Post depreciation each month, post disposals when they happen and clear the capitalization queue at month end. The roll-forward then takes minutes and is the same every time you run it.

Keep a copy of the export with the year end file. If an asset is corrected later, the change is visible by running the report again for the same dates.

Metrics to track monthly

Draft depreciation runs not yet posted
Assets with no depreciation method or useful life
Assets waiting in the capitalization queue
Disposals marked Disposal to post
Difference between register net book value and the ledger

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Manual handling vs Biznsbook fixed asset accounting

Compare doing this by hand with Biznsbook roll-forward report and related capabilities.

Capability	Manual / Spreadsheet	Biznsbook
Building it	❌ Days at year end	✅ One report for any period
Categories	❌ Regrouped by hand	✅ Grouped by the asset category
Depreciation charge	❌ Reconciled from a workbook	✅ From posted runs and disposal catch-up
Disposals	❌ Matched to sales manually	✅ Taken from the disposal date on the asset
Late changes	❌ Rebuild the schedule	✅ Run the report again
Supporting detail	❌ Assembled on request	✅ Register export by category

How the report counts an asset

An asset counts from its purchase date. If it was bought before the start of the period it is in the opening balance, otherwise it is an addition. If it was disposed of during the period it appears under disposals with its cost and the accumulated depreciation removed. An asset disposed before the period does not appear at all.

Write this into your month end checklist and revisit it when you add asset categories or change your policy.

Frequently asked questions

What does the roll-forward include?

Cost: opening, additions, disposals and closing. Accumulated depreciation: opening, on additions, charge for the period, removed on disposals and closing. Net book value opening and closing. All by category, with a total.

Is a draft depreciation run included?

No. Only posted runs and disposal catch-up count. A reversed run is not counted either.

Can I run it for a past period?

Yes. Choose any start and end date. Assets count from their purchase date and leave in the period of their disposal date.

What about the depreciation forecast?

There is a separate report that shows the expected charge for each of the next twelve months by category. The first month includes any months that have not been depreciated yet.

How this differs by industry

Retail

A chain can show additions by category for a store opening year and the depreciation charged against the fit-out, in one export for the auditors.

Wholesale & distribution

A distributor can show fleet additions and disposals for the year, with the depreciation released on the vehicles sold.

Manufacturing

A plant can show machinery additions from a capital project and the charge for the year, category by category.