Import Assets

Asset import allows multiple assets to be created at once using an Excel file. Axanta ERP provides a standard Asset Import Template that can be downloaded, completed and uploaded into the system.

Important: Always download and use the latest Asset Import Template from Axanta ERP. Do not change the headings already included in the template.

1. Download the Template

Step 1: Open Accounting > Assets > Assets.

Step 2: Open Favorites and select Import records.

[Insert image: Assets list showing Favorites > Import records]

Step 3: On the Import a File page, click Import Template for Assets.

[Insert image: Import a File page showing Import Template for Assets]

The template will be downloaded as an Excel file. Open it and enter one asset per row.

2. Prepare the Import File

Complete the columns included in the downloaded template. The selected Asset Profile provides the standard depreciation method, useful life, period length and accounting configuration.

Template Column	What to Enter	Example
Asset Name	A clear description that identifies the asset.	Office Laptop - Finance
Reference	The company’s unique asset number or reference.	FA-2026-001
Asset Profile	The profile containing the depreciation and accounting settings. The name must match an existing Asset Profile.	Computer Equipment - 5 Years
Purchase Value	The original purchase or capitalized cost.	$6,000
Salvage Value	The estimated value remaining after depreciation is completed. Enter zero when no salvage value is expected.	$600
Asset Start Date	The date from which the depreciation schedule begins.	01/01/2025
Depreciation Closing Date	For an existing asset, enter the date up to which depreciation has already been recognized.	31/12/2025
Closing Accumulated Depreciation	The total depreciation already recognized up to the Depreciation Closing Date.	$1,080

Existing assets: The Depreciation Closing Date and Closing Accumulated Depreciation allow an existing asset to continue from its current position. The depreciation board creates future periods after the closing date without recreating earlier periods.

No accounting entry is created for Closing Accumulated Depreciation during import. It is used only to prepare the remaining depreciation schedule. Enter the required opening accounting balances separately through the appropriate opening journal entry.

3. Optional Columns

The following columns are not included in the standard template. Add them only when an asset requires additional information or settings different from the selected Asset Profile.

Optional Column	When to Use It	Example
Depreciation Method	Use when the asset requires a depreciation method different from the Asset Profile.	Linear
Useful Life	Use when the asset’s useful life differs from the Asset Profile.	5 years
Period Length	Use when the depreciation frequency differs from the Asset Profile.	Month
Ending Date	Use when depreciation must finish on a specific date.	31/12/2030
Analytic Names	Enter analytic account names separated by commas. Use only one account from each analytic plan. The names must match existing analytic accounts in Axanta ERP.	Finance Department, Kuwait Branch

Recommendation: Use the Asset Profile settings where possible to maintain consistent depreciation rules across similar assets.

4. Upload the File

Step 1: Save the completed template in Excel format.

Step 2: Return to Accounting > Assets > Assets.

Step 3: Select Favorites > Import records, then click Upload File.

Step 4: Select the completed Excel file and review the field mapping displayed by the system.

Step 5: Test the import and correct any reported errors.

Step 6: When the test is successful, click Import.

[Insert image: Uploaded Asset Import Template with mapped columns]

5. Review Imported Assets

Imported assets are created in Draft status. Review the imported information before confirming them.

Check	Expected Result
Asset Profile	The correct depreciation and accounting profile is selected.
Purchase and Salvage Values	The amounts agree with the source asset register.
Depreciation Dates	The start, closing and ending dates are correct.
Closing Accumulated Depreciation	The amount agrees with the closing asset register.
Depreciation Board	Previous periods are not recreated, and future depreciation continues up to the original ending date.
Analytic Distribution	When Analytic Names were imported, the correct analytic accounts are assigned to the asset.

6. Confirm Multiple Assets

After reviewing the imported information, multiple draft assets can be confirmed together from the Assets list.

Step 1: Open Accounting > Assets > Assets.

Step 2: Select the reviewed assets using the checkboxes in the asset list.

Step 3: Open the Action menu and select Confirm Assets.

[Insert image: Selected assets with Action > Confirm Assets]

Only selected assets in Draft status are confirmed. Selected assets that are already Running, Closed or Removed are ignored.

Important: Confirm assets only after completing the review. Confirmation activates the depreciation schedule and allows depreciation entries to be created.

7. Final Checklist

Check	Completed
The latest Asset Import Template was used.	Yes / No
Asset Profile names match existing profiles.	Yes / No
Purchase and salvage values were reviewed.	Yes / No
Opening depreciation values agree with the asset register.	Yes / No
The depreciation board was reviewed.	Yes / No
Draft assets were confirmed after review.	Yes / No