Importing Assets from Excel

Active Ledger 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.


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.


 

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:

  1. 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).
  2. 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. 



Next article: Assets - Reports


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.