Depreciation Roll Forward report—Fixed Assets Management

The Depreciation Roll Forward report provides a detailed view of changes in accumulated depreciation for your fixed assets over a specified period. It shows the beginning accumulated depreciation balance, depreciation expenses recorded during the period, and the ending accumulated depreciation balance. The report is available in the Fixed Assets Management reports package and is generated using custom reports.

This report is a valuable tool for verifying that depreciation transactions are properly recorded. It supports audits and helps ensure the accuracy of your balance sheet. It can also provide insight into depreciation trends and how your asset base is evolving over time.

For example, for a specific asset classification over the past quarter, the report shows a beginning accumulated depreciation balance of £50,000, with £5,000 of depreciation recorded during the period, and an ending accumulated depreciation balance of £55,000.

Who typically needs this report?

  • AP Clerk

  • Fixed assets accountant

  • Fixed assets manager

  • Controller

Before you begin

Run the report

Subscription

General Ledger

Fixed Assets Management

Regional availability

All regions

User type Business
Permissions Custom reports: List, View

  1. Do one of the following:

    • Go to Fixed Assets Management > All > Reports > Custom reports and select your customized report.

    • Go to Reports > All > Advanced > Custom reports and select Run next to "FAM_Depreciation Roll Forward", or next to your customized version.

  2. Select a reporting period relative to the As of date, or enter Start and End dates.

    If you enter values in all of the time period fields, Sage Intacct uses the start and end dates.

  3. Optionally, customize the format of the report.

    1. For Page orientation, choose whether print versions of this report use a Portrait or Landscape page layout.

    2. For Show details, select Yes to display the detail lines that make up the report. Select No to display only subtotal and total calculation lines.

    3. The remaining format options are for viewing the report as a graph.

      Learn more about graphs.

  4. Optionally, customize the report titles, which apply only to print versions of this report.

    1. Enter the title in the Report Title 1 box.

      2. This title appears in large type at the top of the page, directly under your company name,

    2. Enter the subtitle in the Report Title 2 box.

      This subtitle appears in smaller type, directly beneath the main title.

    3. Enter the footer text in the Footer Text box.

      Footer text appears at the bottom center of the report.

    You can use up to 80 characters, including spaces, in each title, subtitle, and footer.

  5. Choose an option to view the report:

    • Select View to view the report in your browser as an HTML page.
    • Select Print to view the report as a printable PDF file.
    • Select Export to download the report in a different format.

What's in this report?

The default report consists of the following columns.

Report field descriptions
Column Description
Subtotal name Displays asset classifications and subtotal lines for those classifications.
Asset ID

The unique identifier of the asset.
Asset name The name of the asset.
Asset cost The Asset cost is the amount that the asset was purchased for.
Salvage value The Salvage value is the estimated value of the asset at the end of its useful life. It must be less than the Asset cost.
Depreciation schedule ID The unique identifier of the schedule. Sage Intacct generates the ID automatically.
Location ID The ID of the location dimension that the asset is assigned to.
Department ID The ID of the department dimension that the asset is assigned to.
Acquisition date The Acquisition date is the date that your organization purchased or obtained the asset.
In-service date The in-service date is the date when the asset is available for use by your business. This date, along with the Convention, determines when the asset starts to depreciate. The In-service date must be on or after the acquisition date and the most recent transfer date, if any.
Beginning depreciation balance

The sum of the following entries:

  • Posted depreciation entries with an actual posting date before the report's start date

  • Historically posted depreciation entries with a scheduled posting date before the report's start date
Period depreciation balance

The sum of the following entries:

  • Posted depreciation entries with an actual posting date on or between the report's start and end dates

  • Historically posted depreciation entries with a scheduled posting date on or between the report's start and end dates
Ending depreciation balance

The sum of the following entries:

  • Posted depreciation entries with an actual posting date on or before the report's end date

  • Historically posted depreciation entries with a scheduled posting date on or before the report's end date

The Ending depreciation balance should equal the sum of the Beginning and Period depreciation balances.
Total remaining depreciation

The sum of the following entries:

  • Posted depreciation entries with an actual posting date after the report's end date

  • Historically posted, not posted, and canceled depreciation entries with a scheduled posting date after the report's end date
Journal The journal where fixed asset transactions are recorded.
Book The book associated with the journal.