Importing Assets

Importing Assets is a quick way to add Assets into Arbor Finance using a CSV file. 

The sample file shows the fields needed and some examples of a tangible and non-tangible asset.

When using the CSV keep the first line and remove the explanations and the sample data.

Fields to import

1. Name* - Asset name (Max 50 characters)
2. Description* - Description of Asset
3. Type* - Tangible or Intangible
4. Subclass* - Subclass of asset from your list or if you add a new one it will be created on import (Max 3 Characters)
5. Location - Location of asset from your list or if you add a new one it will be created on import (Max 8 characters)
6. Serial Number* - Asset or contract serial number (Max 40 characters)
7. Depreciation start - start date you wish to depreciate the asset from
8. Number of years - number of years to depreciate the asset, must be a whole number
9. Initial value - initial value of the asset (numbers only)
10. Bought - Y or N
11. Staff first name - first name of staff member to whom the asset is assigned or if you add a new staff member it will be created on import
12. Staff last name - last name of staff member to whom the asset is assigned or if you add a new staff member it will be created on import
13. Department - Department of asset from your list or if you add a new one it will be created on import (Max 8 characters)
14. Supplier - short code of supplier - if this is not already created the import will fail (Max 8 characters)
15. Goods received date - date good were received, which is different to depreciation start date
16. Notice period - notice period in days for a contract (Max 180)
17. Contract End Date* - The date for the end of a contract, mandatory for contract lines

* These fields are Mandatory

Importing Assets

1. From the Records > Assets menu click the import button on the right hand side

 

2. On the next page you will see the following screen

3. To see a sample file click the download an example file link in the top right hand corner. The help page can be accesses via the Help Guide link at the bottom of the screen.
4. Once you have prepared the file (see above for the required fields) click Choose file to select your CSV file to be uploaded.
5. Click on Open to load your file
6. If the Header Row for your file is not the first line then enter the Header Row line number in the Header line no.
7. If you have already saved a mapping for your file choose the mapping from the list.
8. Click Start Import to load the file
9. Now choose the column that contains your Transaction Types and click Next (if you have chosen a mapping then you can skip this step)

10. If you have not already chosen a saved mapping, you can now map your file headings to the ones required by Arbor Finance. Note that only the ones with a * are mandatory.
11. When you have finished enter a name for your mapping and click Save. This will remember your mappings for the next time.
12. You will now be presented with a Validation summary report showing you which lines have passed validation, which have failed and any warnings.

13. If there are any errors then you can either click the "See the summary report for full details including errors" to see the error details or Complete Import, and any lines with errors will be ignored.
14. The report will give you full details of all errors in the file which need correcting before the line will be transacted. Once you have corrected your file go back to step 1. to reload it.
15. Once you are satisfied with the file click Complete Import to upload your transactions.
16. You will see a confirmation message that your file has been successfully uploaded.