Streamline your year-end fixed asset reporting

Year-end fixed asset reporting often requires detailed information about your assets, their transactions, depreciation, book values, and acquisition dates. Dynamics 365 Business Central provides several reporting options that can help you gather this information for your auditors. One useful option is Analyze Fixed Assets, which brings detailed fixed asset information together on a list page and allows you to organize the data using Analysis View. You can also export the results to Excel for additional reporting. We’ll also look at the Fixed Asset Book Value 01 and Fixed Asset Acquisition List reports, which remain useful options for year-end reporting.

Navigate to Analyze Fixed Assets

To access Analyze Fixed Assets:

• Go to All Reports.
• Under Finance, open Fixed Assets.
• Select Analyze Fixed Assets.

Analyze Fixed Assets opens a list page containing information posted to your fixed assets, including acquisition and depreciation transactions, document information, depreciation dates, asset types, and fixed asset descriptions. Bringing this information together makes Analyze Fixed Assets especially useful when preparing year-end reporting.

Create an Analysis View

From Analyze Fixed Assets, you can create an Analysis View to organize and summarize your fixed asset information. For example, you can use the Fixed Asset number as your first Row Group:

• Open the Analysis View.
• Locate FA No.
• Drag FA No. into the Row Groups area.

This organizes the data by individual fixed asset. Expanding an asset allows you to review the transactions associated with it. You can add another layer of detail by adding Posting Type to your Row Groups. This lets you expand each fixed asset and separate transactions such as acquisition and depreciation. You can also add other fields and columns depending on the information you need for your year-end reporting.

Export your fixed asset analysis to Excel

Once you have configured the Analysis View, you can open the information in Excel. From the Analysis View, use the available sharing options and select Open in Excel. The analysis will open in an Excel spreadsheet, where you can use Excel functions to further organize and format the information for your auditors or other year-end reporting needs. One advantage of Analyze Fixed Assets is the amount of information available in one place. For example, it can provide acquisition and depreciation information along with dates and transaction details that you might otherwise need to collect from multiple fixed asset reports.

Run the Fixed Asset Book Value 01 report

The Fixed Asset Book Value 01 report provides another useful view of your fixed asset information. Search for Fixed Asset Book Value 01 in Business Central and populate the report options for your reporting period. For year-end reporting:

• Select the appropriate Depreciation Book.
• Enter the beginning of your fiscal year as the Start Date.
• Enter the end of your fiscal year as the Ending Date.
• Set Group Totals to FA Subclass.
• Turn on Print per Fixed Asset.

Grouping by FA Subclass helps keep assets in their appropriate groups. The subclass code can also align with the related accounts in your general ledger. Print per Fixed Asset is particularly useful for year-end reporting because it provides individual asset detail. You can then Send to, Print, or Preview the report.

Understand what the Book Value 01 report provides

The Fixed Asset Book Value 01 report provides information such as:

• Acquisition cost
• Depreciation
• Book value
• Individual fixed asset details when Print per Fixed Asset is enabled

This information can provide auditors with valuable details about the value and depreciation of your assets for the reporting period. However, the report does not provide all the acquisition-date information available through Analyze Fixed Assets. For an asset purchased during the year, for example, Book Value 01 can show its acquisition cost without showing the acquisition date. If your auditors need acquisition dates, you can supplement this report with the Fixed Asset Acquisition List.

Run the Fixed Asset Acquisition List

Search for Fixed Asset Acquisition List in Business Central. Populate the report with:

• The appropriate Depreciation Book
• An Acquisition Period beginning on the first day of your fiscal year
• An Acquisition Period ending on the last day of your fiscal year

Previewing the report provides a list of assets acquired during that period along with their acquisition dates. This makes the Fixed Asset Acquisition List a useful companion to the Book Value 01 report when auditors need to know which assets were acquired during the year and when they were acquired.

Choose the reporting approach that works for you

Analyze Fixed Assets can simplify year-end reporting by bringing a large amount of fixed asset information into one place. Analysis View lets you organize the information by fixed asset and posting type, while the Excel export gives you additional flexibility to prepare an auditor-friendly report. The traditional reports are still useful as well:

• Use Analyze Fixed Assets for a detailed view of fixed asset transactions and dates that can be customized and exported to Excel.
• Use Fixed Asset Book Value 01 for asset costs, depreciation, and book values.
• Use the Fixed Asset Acquisition List when you need a list of assets acquired during the fiscal year and their acquisition dates.

Together, these tools can provide the fixed asset information you need to prepare for year-end reporting and support your auditors.