Fixed assets reports in Business Central

When you prepare a balance sheet and income statement, you might have to generate reports to analyze the depreciation, acquisition, disposal, and gain or loss values for an accounting period. You might also need reports that show:

  • Accumulated depreciation and book value at the end of a period.
  • List your fixed assets for inventory, insurance, and other management purposes.

This article describes the built-in reports for fixed assets.

Explore fixed assets reports with Report Explorer

To get an overview of available reports, choose All reports at the top of your Home page. This action opens the Role Explorer page, which is filtered to the features in the Report & Analysis option. To find reports related to fixed assets, in the Find field, enter fixed assets. To learn more, go to Finding Reports with the Role Explorer.

[Example of reports on the finance role center.]

Fixed assets core reports

The following table describes some of the key reports in fixed asset management.

To...Open in Business Central (CTRL+select)Learn moreID
Get an overview of your fixed assets for a given period of time, including: - Book values - Depreciation - AcquisitionsFixed Asset Analysis ExcelAbout Fixed Asset Analysis Excel4412
Get details about fixed assets transactions and reference data that can help you manage your fixed assets.Fixed Asset Details ExcelAbout Fixed Asset Details Excel4411
Explore projected depreciation amounts and book value for a future period for your fixed assets.Fixed Asset Projected Value ExcelAbout Fixed Asset Projected Value Excel4413
Get a comprehensive list of active fixed assets and their current setup.Fixed Asset ListAbout Fixed Asset List5601
View the journal lines in a fixed asset journal. You can use the report to check the lines before you post the journal.Fixed Asset Journal - TestAbout Fixed Asset Journal - Test5602
Get an organized, detailed overview of all transactions for your fixed assets.Fixed Asset RegisterAbout Fixed Asset Register5603
Get detailed or summarized information about acquisition cost, depreciation value, and book value for groups of fixed assets.Fixed Asset Book Value 01About Fixed Asset Book Value 015605
View the movement in valuation of fixed assets over a period of time, with a breakdown of values under additions and disposals during the period. If needed, further group the information under classes and subclasses.Fixed Asset Book Value 02About Fixed Asset Book Value 025606
Get a list of all assets acquired in a given date range. You can also include fixed assets that are created but aren't acquired.Fixed Asset - Acquisition ListAbout Fixed Asset - Acquisition List5608
Get help with reconciling fixed assets transactions to the general ledger. Typically used to validate disposal entries.Fixed Asset G/L AnalysisAbout Fixed Asset G/L Analysis5610
Review the net change posted in the fixed asset ledger entries for a fixed asset (FA) posting group. If general ledger integration is active for a depreciation book, the amounts in the report should be the same as the net change in the general ledger accounts assigned to the fixed asset posting groups. You can use the report when you reconcile the fixed asset ledger and general ledger.FA Posting Group - Net Change ReportAbout FA Posting Group - Net Change Report5611
Get a list of fixed asset ledger entries, sorted by document type and number. Use it when you audit your fixed asset transactions.Fixed Asset Document Nos.About Fixed Asset Document Nos.5636
This is a legacy report for fixed assets. Refer to the report documentation for alternatives.Fixed Asset AnalysisAbout Fixed Asset Analysis (legacy)5600
This is a legacy report for fixed assets. Refer to the report documentation for alternatives.Fixed Asset DetailsAbout Fixed Asset (FA) Details (legacy)5604
This is a legacy report for fixed assets. Refer to the report documentation for alternatives.Fixed Asset Projected ValueAbout Fixed Asset Projected Value (legacy)5607

Fixed assets insurance reports

The following table describes some of the key reports in fixed assets insurance management.

To...Open in Business Central (CTRL+select)Learn moreID
Get an overview of your insurance policies, including annual premiums, policy coverage, and information about over or underinsured assets.Insurance - AnalysisAbout Insurance - Analysis5620
Get an overview of your insurance policies.Insurance - ListAbout Insurance - List5621
Review the journal lines in a fixed assets insurance journal. You can use the report to check the lines before you post the journal.Insurance Journal - TestAbout Insurance Journal - Test5622
View posted fixed assets insurance ledger entries sorted by register number. Use the information to document the posted entries or for auditing.Insurance RegisterAbout Insurance Register5623
Get an overview of how your individual fixed assets link to insurance policies.Insurance - Coverage DetailsAbout Insurance - Coverage Details5624
Review the total insured amount recorded for each asset and policy when checking whether your fixed assets are adequately insured.Insurance - Tot. Value InsuredAbout Insurance - Tot. Value Insured5625
Check whether you forgot to record insurance coverage for a fixed asset.Insurance - Uninsured FAsAbout Insurance - Uninsured FAs5626

Fixed assets maintenance reports

The following table describes some of the key reports in fixed asset management.

To...Open in Business Central (CTRL+select)Learn moreID
Review your maintenance expenses for fixed assets for different time periods. The information is broken down by maintenance types or other categories, such as fixed asset class.Maintenance - AnalysisAbout Maintenance - Analysis5630
View posted fixed assets maintenance entries sorted by register number. You can use the report to document the posted entries or for auditing.Maintenance RegisterAbout Maintenance Register5633
Get detailed information about the maintenance ledger entries for your fixed assets.Maintenance - DetailsAbout Maintenance - Details5634
Get an overview of when service and repairs are planned for your fixed assets.Maintenance - Next ServiceAbout Maintenance - Next Service5635

Ad-hoc analysis of fixed assets data
Fixed assets analytics overview
Financial analytics overview
Managing Fixed Assets

Find free e-learning modules for Business Central here