NetAsset - Asset Register Roll Forward Report
Overview
The Asset Register Roll Forward report is a query based NetAsset report that contains a full listing of all assets with start-of-period and end-of-period balances, as well as reporting period activity. By default, results are grouped by asset type.
Step-by-Step Process
Navigation
Navigate to NetAsset > Reports (All or Subledger Reports). Locate Asset Register Roll Forward in the report list and click Run.
Filtering
The report can be narrowed by adjusting available filters, including subsidiary, department, location, accounting period, class, date range, and others. Once filters are set as desired, click the refresh arrow to apply the filters and view the report.
Results
Upon running the report, a summarized view of the asset register for the selected period is displayed.
Column Definitions
The table below defines each default column, its data source, and the formula used to calculate it.
| Column | Represents | Formula / Source |
|---|---|---|
| Beginning Gross Balance | Gross cost at the start of the period | Sum of all gross asset activity prior to the report's start date. |
| Beginning Accumulated Balance | Accumulated depreciation at the start of the period | Sum of all accumulated depreciation activity prior to the report's start date. Displayed as a positive number (although technically a credit balance) |
| Additions | Gross cost added during the period | Sums all asset cost increases during the period including: capitalizations for new assets, go-lives, splits, and build up revaluations. |
| Depreciation | Accumulated depreciation activity during the period | Sums all accumulated depreciation activity during the period including: standard period depreciation, depreciation on split and transferred assets, and true up revaluation depreciation. |
| Disposals | Net Book Value (NBV) of disposed assets | Gross Asset Disposal Amount − Accumulated Depreciation − Accumulated Impairment See note above |
| Revaluations | Net revaluation adjustments during the period | Gross asset transactions including Write Ups, Write Downs, and True Ups (gross component only). |
| Ending Gross Balance | Gross cost at the end of the period | Pulled directly from the depreciation schedules. Adjusted for the FX rate in multi-currency environments. |
| Ending Accumulated Balance | Accumulated depreciation at the end of the period | Beginning Accumulated Balance + Depreciation |
Important — Disposals Column: The Disposals column reflects the Net Book Value (NBV) of disposed assets, not the gross disposal amount. This is the most common source of reconciliation confusion.
This means using the disposal amount from the column will not tie out the Ending Gross Balance or Accumulated Depreciation calculations above, since those both require the gross amounts, and the amount shown out of the box is the NBV or combined amount.
To tie out the Gross Ending Balance, you will need to add two additional columns: NetAsset Disposals: Gross Disposal Amount & NetAsset Disposals: Accumulated Depreciation. See Editing Reports in NetAsset for a guide on adding additional fields. Or scroll to the bottom of this article.
Reconciliation
NBV Roll Forward
The default columns support an NBV-level reconciliation using the following formula:
Beg NBV + Additions + Depreciation + Disposals + Revaluations = End NBV
Where Beg NBV = Beginning Gross Balance − Beginning Accumulated Balance, and End NBV = Ending Gross Balance − Ending Accumulated Balance.
Gross Asset Roll Forward
Because the Disposals column represents NBV rather than gross cost, the formula Beg Gross + Additions − Disposals = End Gross will not reconcile using the default columns. To reconcile at the gross asset level, two additional columns must be added to the report:
- Disposal Gross Amount — the gross cost basis removed at disposal
- Disposal Accumulated Depreciation — the accumulated depreciation removed at disposal
With these columns present, the gross reconciliation is:
Beg Gross + Additions − Disposal Gross Amount = End Gross
And the accumulated depreciation reconciliation is:
Beg Accumulated Balance + Depreciation − Disposal Accumulated Depreciation = End Accumulated Balance
For instructions on adding these columns, see the Customization section below.
Customization
The Asset Register Roll Forward report can be customized to reorder existing columns or add fields not included by default.
- Navigate to NetAsset > Reports (All or Subledger Reports) > Asset Register Roll Forward
- Click Edit
- Open the Advanced Configuration subtab
Adding Custom Columns
Click New NetAsset Report Column to add a field. Use the Move Up / Move Down buttons to position the column as needed, then click OK and Save.
The dropdown contains every field available in the report query. The table below identifies the most commonly needed fields by category.
| Field Name | Category | Description |
|---|---|---|
| Disposal Gross Amount | Disposal Detail | Gross cost basis removed at disposal |
| Disposal Accumulated Depreciation | Disposal Detail | Accumulated depreciation removed at disposal |
| Total Additions | Gross Movements | Sum of all gross additions activity |
| Capitalizations from CIP | Gross Movements | Gross cost additions from CIP capitalization |
| Build Ups | Gross Movements | Gross cost increases from build-up entries |
| Write Downs | Gross Movements | Gross cost reductions from write-down entries |
| Write Ups | Gross Movements | Gross cost increases from write-up entries |
| True Ups (Gross) | Gross Movements | True-up adjustments to gross asset value |
| True Ups (Depr) | Depreciation Movements | True-up adjustments to accumulated depreciation |
| Total Revaluations | Gross Movements | Net total of all revaluation activity |
| FX Balance Sheet | Multi-Currency | Exchange rate impact on cost/NBV-side transactions |
| FX Income Statement | Multi-Currency | Exchange rate impact on depreciation-side transactions |
| CTA | Multi-Currency | Cumulative Translation Adjustment |
| Row Number | Audit | Sequential row number for export verification |
Adding Row Number
Row Number provides a sequential count that confirms an export included all results. Auditors may require this column to verify that data was not altered after export.
- Open the Advanced Configuration subtab
- Click New NetAsset Report Column
- Select Row Number
- Use Move Up / Move Down to position the column as needed
- Click OK, then Save
Upon running the report, the row number is visible by selecting the dropdown arrow on each asset row.
Multi-Currency Fields (CTA, FX Balance Sheet, FX Income Statement)
The CTA, FX Balance Sheet, and FX Income Statement fields are available as optional columns under the Advanced Configuration tab. These fields are relevant only for assets with a currency that differs from the reporting currency. For assets where the asset currency matches the reporting currency, these values will be zero.
FX Income Statement (IS FX)
Reflects the exchange rate impact on depreciation-side transactions for the period. Calculated as:
IS FX = End Period FX Rate × (Depreciation + True Up Depr + Write Down + Write Up) − Beg Period FX Rate × (Depreciation + True Up Depr + Write Down + Write Up)
FX Balance Sheet (BS FX)
Reflects the exchange rate impact on cost and NBV-side transactions for the period. Calculated as:
BS FX = End Period FX Rate × (Beg NBV + Build Ups + True Ups + Disposals + Caps + Transfers) − Beg Period FX Rate × (Beg NBV + Build Ups + True Ups + Disposals + Caps + Transfers)
Note: The Disposals value used in the BS FX formula follows the same NBV treatment as the main Disposals column.
CTA (Cumulative Translation Adjustment)
Represents the value difference between the historical and current exchange rate for the period. Calculated as:
CTA = IS FX + BS FX
Troubleshooting
Expected assets are not visible in the report:
- Assets with a Pending or Split status do not appear in these reports by default. Verify the asset status directly on the asset record.
- Filters such as subsidiary, currency, department, class, location, or accounting period may exclude assets or transactions. It is recommended to start with broader filter settings to ensure all assets are included, then narrow the filters as needed.
The report is showing schedule line dates instead of actual transaction posting dates:
If asset activity was backdated—by placing an asset in service in the past or running catch-up depreciation—the report can be configured to reflect actual transaction posting dates rather than scheduled line dates.
- Navigate to NetAsset > Reports > Subledger Reports > Asset Register Roll Forward Report
- Click Edit
- Open the Advanced Configuration subtab
- Check the box labeled Use Posting Dates When Available
- Click Save