Skip to main content

Fixed Assets

Business Value

When you need to create a large number of fixed assets you need a fast way to do it. This feature allows you to import new or update existing fixed assets using a single Excel worksheet. The import creates/updates Fixed Assets, FA Depreciation Books, Main Asset/Component and also creates opening transactions.

Possible Scenarios

  • You can use this feature to a Fixed Asset Register into a new Business Central company. Using this feature is much faster than using a configuration package because you don't need to change the format of the file and split it into different tables.
  • If your purchase process does not support you first creating a fixed asset before placing an order, you can use this feature to create the new fixed assets and create the Fixed Asset Journals for the acquisition costs.

Feature Details

The Fixed Asset import can be accessed from the Fixed Asset list. Fixed Asset Import


Update Existing

YesUpdate existing records and add new records.
NoOnly add new records.

Balances Journal Type

FA Journal (Default)Import the opening balances to a Fixed Asset Journal, which is not integrated to the General Ledger. This us usually used when you are importing a Fixed Asset Register into a new company
General JournalImport the opening balances to a Fixed Asset G/L Journal.

Example: Importing a Fixed Asset Register for a new Company

In this example, we use Excel Importer to upload a fixed asset register that contains the the fixed assets together with the the cost and accumulated depreciation.

Excel file

Fixed Asset Excel

Excel Mapping Template

Step-by-Step Guide

This guide presents the steps required to import Fixed asset records into Business Central and their associated acquisition cost and accumulated depreciation amounts using a single import template in Excel Importer.