Use Excel reports for consolidation and fixed assets

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users, automatically Sep 2, 2024 Oct 2, 2024

Business value

Excel reports give you the underlying data that they're based on, so that you can reformat the data to build a custom report—for example, to get a specific insight or for troubleshooting.

Feature details

In this release we have added four Excel report layouts that cover the consolidation and fixed assets areas:

  • Consolidated Trial Balance (Preview)
  • Fixed Asset Details (Preview)
  • Fixed Asset Analysis (Preview)
  • Fixed Asset Projected Value (Preview)

The report layouts are available through search and the Accountant home page.

The content of each report covers the content of one or more existing RDLC reports, and gives you the underlying data so you can create custom reports.

The new Excel FA Analysis report, showing the Book Value report worksheet

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.