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 Importer

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

    • 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 ...

    • Foreign property Income

      Foreign property Income What is this? Foreign property income refers to rental earnings generated from property located outside your country of residence. For UK tax residents, this encompasses rental receipts from residential homes, holiday lets, or ...

    • 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 ...

    • Data connections - Bank

      Data connections - Bank What is this? Data connections help you and your client import data into ApariPro, including data from bank feeds. The Open Banking system, regulated by the Financial Conduct Authority, provides a secure method for connecting ...