Importing transactions from a spreadsheet (CSV)

Importing transactions from a spreadsheet (CSV)

Importing a CSV-file (spreadsheet)


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.

CSV-file checklist

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

  • Ensure all cells are formatted as text

  • Ensure no rows are empty

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

Use the ApariPro spreadsheet template

  • Download the ApariPro CSV template

  • Copy and paste your transactions into the structure

  • Save the file as a CSV

How to import

  • Go to Record Keeping and select Import CSV-file

  • Select the transaction source from the dropdown

  • Select Choose File to upload your CSV, then click Continue

  • Map the fields by matching your file headers to APARI column headers

  • Select Import to finalise the upload

The data will be added to your unassigned transactions.


    • Related Articles

    • Assigning your clients transactions

      Once your client's bank feed is connected and the transactions are fed into ApariPro, you or your client can allocate them to the correct categories which will update the correct boxes on your tax submission form. This will allow you to keep on top ...

    • Record Keeping

      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 added. Adding transactions manually ...

    • Data connections - Bank

      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 a wide range of financial authorities ...

    • Adding a new client

      Bulk Migration Once your account is created, we will invoice you for the agreed number of licences and work with you to export data from your existing systems. We will handle the bulk migration to ApariPro for you, ensuring a smooth transition. ...

    • Using your HMRC credentials

      Your firm’s Government Gateway IDs are used in several ways within the software. Annual tax return submission uses your HMRC Online Services for Agents ID. You can save this in your profile via Profile & Settings > Personal Data. You enter the ...