Depreciation Forecast report—Fixed Assets Management

The Depreciation Forecast report displays the remaining depreciation schedule entries and their future posting dates for all assets. Assets in the report are grouped by classification. This report is available in the Fixed Assets Management reports package and is generated using custom reports.

Typically, this report assists controllers in understanding the remaining depreciation amounts for accurate financial planning. By identifying the expected depreciation, controllers can allocate budgets for future asset purchases and plan expenses for tax deductions effectively.

For example, it reveals 10 assets under the Computer Equipment classification totaling $10,000 in remaining depreciation for the upcoming year.

Who typically needs this report?

  • Controllers

  • FA accountants

  • FA managers

Before you begin

Run a custom report

You can run the report from the application menu or the Reports center.

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 Forecast", or next to your customized version.

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

  3. Optionally, customize the filters.

    1. Select the range of posting dates to include in the report.

    2. Enter the name of the classification that you want to include in the report.

    3. Select one or more books that you want to include in the report.

    4. Enter the name of a journal that you want to include in the report.

  4. 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.

  5. 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.

  6. 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.

Buttons field descriptions
Column Description
Subtotal name Displays subtotal lines for scheduled posting dates and asset classifications.
Asset ID

The unique identifier of the asset.
Asset name The name of the asset.
Posting date The date when the depreciation schedule entry is expected to post to the General Ledger.
Remaining depreciation The depreciation expense amount yet to be recognized in the accounting records for an asset from the current period until the end of its useful life. It is the sum of the depreciation schedule entries that have not been posted yet. This concept is also known as the net book value.
Location ID The ID of the location dimension that the asset is assigned to.
Classification ID The ID of the asset classification that the asset belongs to.
Classification name The name of the asset classification that the asset belongs to.