How to Export Bank Transactions to a CSV or Excel file

Author: Duncan Warnock CPA | August, 2025

 Exporting bank transactions to a CSV or Excel file can be help you meet your record keeping requirments and document income & expenses.  The key data to export into a file are the DATE, AMOUNT and TRANSACTION DESCRIPTION fields. 

Capturing & recording bank account transaction data can be helpful for a variety of reasons:

1. Help fulfil business record keeping requirements
2. Business income & expense recording
3. Rental Property income & expense recording
4. Air BNB income & expense recording
5. Investment income (i.e. share dividends)
6. Employee tax deduction recording
7. Import missing bank transactions into accounting software
8. Sort, filter, highlight, categorise & comment on bank transaction data for any of the above reasons

Best practice approach is to both

1. save the 'official' bank statements in PDF format (this is much better than a simple transaction history' report'  because a bank statement is an official bank document) and
2. also export the bank account transactions into a CSV/Excel file. Exporting the bank data will do the hevay lifting for you as it will document the DATE, AMOUNT and TRANSACTION DESCRIPTION for you. Sometimes the transaction description wont have enough info but you can solve that by adding an extra excel/CSV file column and add the extra info as needed.