# Fixed Asset Analysis Excel (report)
The Fixed Asset Analysis Excel report shows fixed asset details in given time periods, such as:
 Book value
 Depreciation
 Acquisitions
Specify a depreciation book and valid starting and ending dates. You can include inactive fixed assets or select Only Sold Assets to include assets disposed of within the selected period. Select Budget Report to include calculated future depreciation and book value.
The report Excel workbook includes the following report and data worksheets:
 Fixed Asset Analysis (Print)
 Fixed Asset Analysis
 Book Value
 FixedAssetData
Use the worksheets to analyze data in different ways.
> TIP
> If you configure OneDrive for system features, the Excel workbook opens in your browser in Excel for the web. Otherwise, the workbook is downloaded to your device.
> NOTE
> This report does the calculations when you view it in Excel for the web, or when you download and open it. If a banner displays text about external data connections, you might need to select the Enable content button to load data. Enable content only if you trust the file. The report doesn't connect to any external data sources. Some layouts use Power Query to prepare the analysis worksheets. Depending on your organization's security settings, you might also need to right-click a PivotTable cell in Excel for Windows and select Refresh to update data in the report.
## Fixed asset analysis worksheet
This worksheet shows details about your fixed assets, such as fixed assets class, sub class, description, acquisition date, and disposal date. It also shows their value at the starting date and ending date of the specified period.
The filters and slicers on the worksheet let you zoom in on a fixed asset's class, subclass, or location. You can also filter by the two global dimensions. The dimension names depend on your company's setup.
![Screenshot of the Fixed Asset Analysis worksheet]
> TIP
> The data is shown in an Excel PivotTable. Select any cell in the PivotTable to show the Field List, where you can arrange fields. You can also group or ungroup values and filter data in the PivotTable. Learn more in the following articles:
 > Use the field list to arrange fields in a pivot table<https://support.microsoft.com/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-80160adfebec>
 > Group or ungroup data in a pivot table<https://support.microsoft.com/office/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725>
 > Filter data in a pivot table<https://support.microsoft.com/office/filter-data-in-a-pivottable-cc1ed287-3a97-4e95-b377-ddfafe79fa8f>.
## Book value worksheet
This worksheet shows fixed asset details in the given time periods, such as:
 Book value
 Depreciations
 Acquisitions
The filters and slicers on the worksheet let you zoom in on a fixed asset's class, subclass, or location. You can also filter by the two global dimensions. The dimension names depend on your company's setup.
![Screenshot of the fixed asset Book Value worksheet.]
> TIP
> The data is shown in an Excel PivotTable. Select any cell in the PivotTable to show the Field List, where you can arrange fields. You can also group or ungroup values and filter data in the PivotTable. Learn more in the following articles:
 > Use the field list to arrange fields in a pivot table<https://support.microsoft.com/office/use-the-field-list-to-arrange-fields-in-a-pivottable-43980e05-a585-4fcd-bd91-80160adfebec>
 > Group or ungroup data in a pivot table<https://support.microsoft.com/office/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725>
 > Filter data in a pivot table<https://support.microsoft.com/office/filter-data-in-a-pivottable-cc1ed287-3a97-4e95-b377-ddfafe79fa8f>.
## Fixed asset data worksheet
This worksheet shows the raw data used in the report. Depending on the report, the worksheet shows individual entries or aggregated amounts.
Use this worksheet for data analysis assisted by built-in tools in Excel, such as Excel Copilot when it's available to you, or the what-if analysis tools. You can use Forecast Sheet in Excel for Windows if the data includes a date or time series with consistent intervals and corresponding numeric values.
![Screenshot of the FixedAssetData worksheet]
Copilot availability depends on your license and your organization's settings. See https://support.microsoft.com/en-us/office/get-started-with-copilot-in-excel-d7110502-0334-4b4f-a175-a73abdfc118a.
## Supporting workbook worksheets
The Business Central platform always adds three system worksheets to Excel reports:
 TranslationData, with text needed for multilingual reports.
 CaptionData, with text from Business Central fields needed for multilingual reports.
 Aggregated Metadata, with data about the report, and when and how it was run.
All three worksheets are hidden by default. See /dev-itpro/developer/devenv-howto-excel-report-layout#system-excel-sheets.
## Use cases
Get an overview of your fixed assets for a given period of time, including:
 Book values
 Depreciation
 Acquisitions
## Try the report
Try the report here: Fixed Asset Analysis Excel<https://businesscentral.dynamics.com?report=4412>
> TIP
> If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.
## Make the report your own
You can create your own report layouts with Excel, either from scratch or based on an existing layout. To modify the layout for the report, export the layout (not the workbook that resulted from running the report) from Business Central, make your changes, and then import the layout into Business Central.
See /ui-excel-report-layouts#task-1-create-the-excel-layout-file.
## Alternative reports
There are several other ways to analyze your fixed assets. Learn more in the following articles:
 Fixed Asset Analysis (legacy report)<report-5600>
 Using data analysis to analyze fixed assets data</ad-hoc-analysis-fa>
## Contributors
Microsoft maintains this article. The following contributors provided some or all of its contents.
 Kim Dallefeld<https://www.linkedin.com/in/kim-dallefeld/> | Microsoft MVP
## Related information
Ad-hoc analysis of fixed assets data</ad-hoc-analysis-fa>
Fixed assets analytics overview</fa-analytics-overview>
Financial analytics overview</bi>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-4412, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/reports/report-4412/
