Bank transactions can be manually imported using a 'csv' file format.
⚠️ Warning: Do not add manual transactions directly into a bank account with live transactions in TaxTank. Doing so will throw out your TaxTank Balance. Instead, create a manual account for these transactions.
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.
FAQs
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.
Q: Why won’t my CSV file import?
A: The most common reason a CSV file won’t import is that the file is not in a clean format. Before uploading, please open the CSV file and check the following:
CSV import checklist
The first row must only contain the column headers
Use one of these formats only:
date, amount, descriptionor
date, debit, credit, descriptionDo not include any extra columns such as:
balance
transaction type
account number
BSB
category
notes
running balance
reference number
Extra columns can prevent the file from importing correctly.
Remove blank rows
Delete any blank rows above the headers, between transactions, or at the bottom of the file.
Remove totals or summary rows
Some banks export rows such as:
opening balance
closing balance
total credits
total debits
These should be removed before upload.
Make sure the file is saved as a CSV
The file must end in
.csv.Excel files such as
.xlsxor.xlswill not import through the manual CSV upload.Check the date format
Dates should be consistent throughout the file.
For example:
01/04/2026Avoid mixed date formats in the same file.
Q: My bank export has extra columns. What should I do?
A: That’s completely fine, but you’ll need to clean the file first.
Keep only the required columns:
date
amount or debit and credit
description
Delete everything else before uploading.
Using our downloadable CSV template is usually the easiest way to fix this.
Simply copy and paste only the required columns into the template, save it as CSV, then upload.