Article Objective: To assist users in navigating Active Ledger & Reporting to import a previous asset register via Excel. Context: Active Ledger & Reporting allows you to bulk import assets from another system via Excel. You can also use this tool as a means of quickly creating multiple new assets from a client ledger export. Please refer to the Glossary for definitions of key terms used in this article. |
Importing assets from Excel
To access the Excel template for importing, go to the Assets screen, and click on Import from Excel.
Note: If you have already created an asset group, the 'Import from Excel' function can be found in the Bulk Actions drop-down menu.
This will open a dialogue where you can access and download the import template.
Once downloaded, follow the instructions in the Excel worksheet that corresponds to your client's accounting system to copy the data into the worksheet. If your client's accounting file is not listed, complete Sheet 1.
Once you have clicked the Convert button, the data will be displayed in Sheet 1 in the appropriate format for importing into Active Ledger. You are also able use this sheet as a means of quickly creating multiple new assets. Save your file.
There are two things to note with the import template:
- Asset group - if an asset group does not exist within Active Ledger by the provided name, a new one will be created automatically during the import process (noting that this is case sensitive)
- Accounting - the accounting fields are optional, as the import process allows you to copy all taxation values into the corresponding accounting values.
Running the import
To run the import, return to the dialogue screen and upload the Excel file by clicking on the Choose File button. You then need to choose the relevant depreciation year. Check the 'Copy taxation values to accounting values' if your import only contains taxation data.
Finally, click on the Prepare Import button.
A message will appear to show how many assets will be imported. Click the Import Assets button to finalise the import.
All asset groups, with their corresponding assets, will now appear on the left menu of the main Assets screen.
Note: For all motor vehicles, ensure you manually adjust the Asset Type to 'Motor Vehicles'. This will ensure the cost limit is applied to the asset.