Importing transactions from a spreadsheet

Importing transactions from a spreadsheet

Importing transactions from a spreadsheet


If you already record information for your tax return in a spreadsheet, you can import the individual items into ApariPro’s Record Keeping area. 

You can also import bank statements if you don’t use our bank feed feature. 

TO MAKE SURE THE DATA IS IMPORTED CORRECTLY, PLEASE MAKE SURE OF THE FOLLOWING:

  • Save the spreadsheet as a CSV file. This is possible on 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’. 

ONCE YOU HAVE YOUR CSV FILE, YOU CAN UPLOAD THIS TO ApariPro. THIS VIDEO EXPLAINS THE STEPS:


Video attached: Upload transactions



TO DOWNLOAD BANK STATEMENTS: 

  • Log into your online banking and select the relevant account

  • Find a “view statements” or “view transaction history” or similar tab

  • Select the date range for transactions

  • Select the CSV file type option and Export / Save / Download. 

Tip: All banks offer a ‘midata’ export as a CSV file, which contains transactions for the last 12 months.

TO USE THE ApariPro SPREADSHEET TEMPLATE:

  • Download the APARI CSV template.

  • Copy and paste your transactions into the structure.

  • Remember to save the file as a CSV.

    • Related Articles

    • Reviewing your transactions

      Reviewing your transactions If your Record Keeping area is growing and growing, well done! It means you’re staying on top of your finances. By default, we show all transactions and sort them by date, with the most recent transactions at the top. To ...

    • Assigning Transactions to Categories

      Assigning Transactions to Categories Once your transactions are in ApariPro, you can allocate them so that they end up in the correct box of the tax return. This helps you stay on top of your income and tax-deductible payments, such as business ...

    • Accountant or Bookkeeper Access

      Bookkeeper Many people start using ApariPro to make it easier to work with their accountant. IF YOUR ACCOUNTANT OR BOOKKEEPER CREATED YOUR ApariPro LOG-IN FOR YOU: They will already have access to ApariPro and can act on your behalf. IF YOUR ...

    • Tax Terminology (Jargon Buster)

      Tax Terminology (Jargon Buster) We know tax can seem complicated, so we try our best to use everyday language in our ApariPro products. Here are some explainers for tax-related jargon: ACCOUNTING METHOD: CASH VS ACCRUALS Most self-employed people and ...

    • What's included with an ApariPro account?

      What's included with an ApariPro account? People say that tax is complicated. At ApariPro, we make sure that our pricing isn’t! ONE ApariPro ACCOUNT COVERS ONE TAXPAYER FOR ONE TAX YEAR (6TH APRIL TO 5TH APRIL THE FOLLOWING YEAR). A single account ...