Document Explorer: Importing a CSV-file

What is this?

If you or your client records their tax return in a spreadsheet you can import individual items into the Record Keeping section. If your client prefers not to connect a bank feed you can also import bank statements directly.

How do I do this?

CSV-file checklist

1. Save the spreadsheet as CSV-file, this is possible from most devices

2. Ensure all cells are formatted as text

3. Ensure no rows are empty

4. Delete any ‘Total’ rows or rows where the transaction value is ‘0’

How to import

1. Go to Record Keeping and select Import Document

2. Select Upload new document and Import

3. Select the transaction source from the dropdown

4. Select Choose File to upload your CSV, then click Continue

5. Map the fields by matching your file headers to APARI column headers

6. Select Import to finalise the upload

The data will be added to your unassigned transactions.