Which version are you in? Look at the menu on the left. If you see Loans with a New label, follow the first set of steps. If your leases sit inside your assets, follow the second set.

In Loans (new)

In Loans, assets and loans are imported separately. Import your assets as usual from Add Assets > File Import. Then import your loans from Loans > Add Loans > File Import > Import Loans.

At the Import Options step, choose Separate worksheet. This is for loans with irregular payments, where each loan's payment schedule is set out on its own worksheet.

To set up your file:

  • On your loans sheet, add a column with the name of the worksheet that holds each loan's payment schedule.
  • On that worksheet, list the payment dates and amounts. You can enter each payment as one amount, or as principal and interest separately.

For the full steps, including how to link your loans to the assets they financed, see Add your assets, then import your loans.

Loans is new and we are still adding to it. Bulk actions for loans are not available yet. See What is coming next in Loans.

In the current version

AssetAccountant allows you to upload information in bulk for assets and leases that are entered into to finance an asset such as hire purchase or chattel mortgage arrangements.


This article covers the case where the profile of the lease is:


  • A one-off up front payment such as a deposit (Optional)
  • A series of regular payments
  • A final (balloon) payment (Optional)


In order to do this, you will need to prepare a data upload file based on the upload templates provided in the interface.


When you ready to upload the data, navigate to the Add Assets > File Import area and choose "New Lease Import" > "New Custom Lease Import (custom payments)":




and then upload your file:





Upload your file and AssetAccountant will walk you through a wizard to make sure the data is mapped correctly.


Firstly, if there are multiple tabs in the uploaded file, you will be asked to nominate the relevant worksheet to import:





Then AssetAccountant will ask for the header row for the data:





Confirm the header and press Next. Then you will be asked to confirm some points about the upload:





Opening Balances and Lease Opening Balances should be used for assets and leases that you are bringing in part way through their lives and want AssetAccountant to start with the closing balance from your prior system.


Lease interest paid is to specify if the interest is accounted for at the start or end of the lease payment period and "Pools" is if you are bringing in any assets that are in a pool for tax purposes.


From here, you will be asked to confirm the columns are mapped to the correct fields for upload.