How to Import your data

Modified on Wed, 20 Mar at 9:02 AM

Arthur provides a Paid import service for clients   

If you decide to do this yourselves and encounter problems it's impossible for us to identify the problem due to the complexity of an import.  Each spreadsheet is linked and must be done in the correct order listed below. Because of the linked sheets, a single cell could create a problem.  

The order of imports are:

  1. Area  - Optional
  2. Unit type  - Optional
  3. Entity  - Required for owners- Import 1
  4. Property  - Required - Import 2
  5. Unit  - Required- Import 3
  6. Tenancy  - Required- Import 4
  7. Tenant  includes tenancy recurring charges - Required - Import 5
  8. Financials- Optional
    • Recurring charges - e.g management fees - Import 6
    • Transaction template - opening balances and registered deposits - Import 7
  9. Certificates - Optional



Go to settings>import data

  1. Download the templates in the order above
  2. View the import guide links to view formatting
  3. Upload in the order above



Rolling back data

To roll back an import that needs redoing go to import file>roll back


In order to import tenants and recurring charges, you'll need to add in tenancy reference. You can export a file via custom reports. Group tenancy> add tenancy reference and tenant name as fields> Run report via CSV.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article