Roll Forward report—Fixed Assets Management

The Roll Forward report provides a clear view of changes in fixed asset balances over a specified time period. It’s included as a standard report in Fixed Assets Management. It shows opening balances, period activity, and closing balances for asset cost and depreciation, along with the resulting opening and closing net book value.

This report is a key reconciliation tool for validating that fixed asset activity is recorded correctly. It supports audits, helps ensure balance sheet accuracy, and makes it easier to explain period‑over‑period changes in fixed asset balances.

For example, for a specific asset classification over a fiscal quarter, the report can show an opening asset cost of $250,000 and accumulated depreciation of $80,000, $40,000 in asset additions, $10,000 in disposals, $7,500 in depreciation, and a resulting closing net book value of $192,500.

Who typically needs this report?

• AP Clerk

• Fixed assets accountant

• Fixed assets manager

• Controller

Run the report

1. Go to Fixed Assets Management > All > Reports > Roll forward report.

2. Set the report's time period by doing one of the following:

   • Select a Reporting period and an As of date.

   • Enter a specific Start date and End date.

     If you enter values for all fields, the report uses the start and end dates.

3. Customize the filters to focus the results of your report.

   • From asset, To asset: Filter by a range of asset IDs. Select the first asset to include in From asset and the last asset to include in To asset.

   • Asset classification

   • Location

   • Journal

   • Include non-depreciable assets

   • Asset state: By default, the report includes In service and Disposed assets.

4. Customize the format of your report.

   1. Dimensions to display: Select standard or user-defined dimensions to include as columns. Drag and drop these fields to change their column order.

   2. Additional fields to display: Select additional asset attribute fields to include as columns. Custom fields are not available.

   3. Report type: Select Summary to show totals by asset classification. Select Detail to show individual assets within each classification, along with more fields. Dimensions and additional fields are available only in the Detail report.

5. Select View.

Learn more about working with reports.

What's in this report?

This report includes the following columns by default. You can also add dimensions and additional fields as columns.

Report field descriptions

Column	Description
Asset classification	The ID of the asset classification. Select the ID to drill into the asset classification.
Asset ID	The unique identifier of the asset. Select the ID to drill into the asset. This field only appears in the Detail view of this report.
Asset name	The name of the asset. This field only appears in the Detail view of this report.
State	The current state of the asset, such as In service. This field only appears in the Detail view of this report.
Asset cost	The original purchase cost of the asset. This field only appears in the Detail view of this report.
Salvage value	The estimated value of the asset at the end of its useful life. This field only appears in the Detail view of this report.
Cost: Opening	Asset cost before the start of the report's time period. This includes the following assets: Assets with an in-service date before the report's start date. Assets that were not fully disposed of before the report’s start date. For partially disposed assets, this shows the remaining asset cost after the disposal.
Cost: Additions	Asset cost added within the report's time period (including start and end dates). This includes assets with an in-service date on or between the report's start and end dates.
Cost: Disposals	Asset cost disposed of within the report’s time period (including start and end dates). This includes full and partial disposals for assets with a disposal date on or between the report's start and end dates.
Cost: Closing	Asset cost as of the end of the report's time period. This value equals opening cost plus additions, minus disposals.
Acquisition date	The date that your organization purchased or obtained the asset. This field only appears in the Detail view of this report.
In-service date	The date when the asset became available for use by your organization. Determines when the asset starts to depreciate. This field only appears in the Detail view of this report.
Depreciation: Opening	Depreciation accumulated before the start of the report's time period. This amount includes the following depreciation entries: Posted entries with an actual posting date before the report's start date. Historically posted entries with a scheduled posting date before the report's start date.
Depreciation: Period	Depreciation accumulated within the report's time period (including start and end dates). This amount includes the following depreciation entries: Posted entries with an actual posting date on or between the report's start and end dates. Historically posted entries with a scheduled posting date on or between the report's start and end dates.
Depreciation: Disposals	Accumulated depreciation for assets that were fully or partially disposed of within the report's time period (including start and end dates). For full disposals, this is the total accumulated depreciation. For partial disposals, this is the partial accumulated depreciation.
Depreciation: Closing	Depreciation accumulated as of the end of the report's time period. This amount includes the following depreciation entries: Posted entries with an actual posting date on or before the report's end date. Historically posted entries with a scheduled posting date on or before the report's end date. This value equals opening depreciation plus period depreciation, minus disposals. In the Detail view of the report, select this value to drill into the depreciation schedule.
Net book value: Opening	The opening cost minus opening depreciation.
Net book value: Closing	The closing cost minus closing depreciation.
Journal	The journal where fixed asset transactions are recorded. This field only appears in the Detail view of this report.
Book	The book associated with the journal. This field only appears in the Detail view of this report.