Bank transactions can be manually imported using a 'csv' file format.
To obtain bank transactions simply log into your internet banking, select your account and transaction date range, and then select export. When exporting you should be able to choose the file type, in which case you want to choose 'csv'.
Open your CSV file and check the first row. It should be the column headers and look like one of these:
date, amount, description
or
date, debit, credit, description
Different banks export their data differently, so either format is fine.
Download CSV template
If you’re unsure, you can download the CSV template that aligns with your bank export from the bottom of this article or in TaxTank by clicking the Download button in your account under Bank Feeds, then copy and paste your bank transactions into the template.
To import the transactions, select the financial year the transactions apply to, select 'Bank Feeds' from the left side menu, select the bank account you want to import transactions into, and then select the Import button to upload the csv file.
In a few seconds your transactions will be ready to allocate.
One thing to note, if you're importing transactions for multiple years, you will need to import the transactions for each financial year.
Q: My bank only lets me export statements as a PDF or in paper format. How can I import these transactions?
A: You can use an online service to convert your PDF to a CSV, such as Convertio. Once converted, make sure the file matches our required format before uploading, otherwise it won’t import correctly.