Asset List By Acquisition Date

Report Module Guide: Asset List by Acquisition Date

Module Location

Fixed Asset > Reports > Asset List by Acquisition Date

Module Objective

The Asset List by Acquisition Date module is used to generate a complete list of all company fixed assets, sorted chronologically and grouped by their acquisition year. This report format is ideal for analyzing the age profile of assets and for preparing fixed asset schedules in formal financial reporting.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Location Filter:

  • Select All Locations to display all assets, or Selected Asset Location to choose one or more specific departments/locations.

• As of:

  • This is the primary filter to define the report's reference date ("as of" date). The report will display all assets acquired up to this date.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the As of date.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a complete asset list grouped by its acquisition year (e.g., 2017, 2018, 2021, etc.).

This report displays all important financial details for each asset, including:

• Acquisition Cost

• Accumulated Depreciation

• Book Value

• Remaining Useful Life.

Tips & Important Notes

• Use this report to prepare the fixed asset schedule that is attached to the Financial Statements. The grouping by year is very helpful in creating an asset mutation report (roll-forward schedule).

• This report provides insight into the age profile of the company's assets and can help in planning for future investment or asset replacement.

• This is a very important audit report for the Fixed Asset Accountant and Controller.