Document Explorer: Importing a CSV-file

Document Explorer: Importing a CSV-file

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.


NOTE: from the Document Explorer page/dashboard, you can also preview, download and delete documents.

Need help?

If you have any further questions or need technical support please contact ApariPro Support here.

    • Related Articles

    • AI document extractor

      AI document extractor What is this? Our brand new AI DocExtractor uses cutting-edge technology to help you save time on your time heavy tasks processing clients documents. Easily upload documents and see the extractor create and categorise ...

    • Record Keeping Overview

      Record Keeping Overview What is this? The Record Keeping Section helps you keep track of your clients transactions in a digital format. Transactions can be automatically uploaded directly from your clients bank feed, imported by CSV-file or manually ...

    • Adding a new client

      Adding a new client What is this? You can add new clients in two ways, individually or in bulk. Adding clients individually is ideal for adding a small number of clients and for larger numbers you should add multiple clients using our CSV-file client ...

    • Tax return download & SA302

      Tax return download & SA302 What is this? You can download a complete PDF of your client's tax return at any point in the workflow. The PDF contains both the SA100 form and the SA302 tax calculation document. How to Download Go to Tax Submission ...

    • Creating Transaction Rules

      Creating Transaction Rules What is this? Transactions can be imported directly from bank feeds, importing bank statement CSV's, from uploaded documents and/or adding transactions manually. Once transactions are in ApariPro you can categorise them in ...