At IOCA we use Xero. Xero gets electronic copies of your bank statement data directly from the bank in the form of “Bank Feeds”.
Getting this data digitally creates one of the big time savings in Xero - neither of us has to enter this information into Xero by hand.
One of the tricks with Bank Feeds though is that we can only access data through them going forwards in time. We can’t access any bank transaction information before your Bank Feed was activated. This means past data either has to be entered by hand or the data is sourced from internet banking.
This is is why we may ask for your help - because only you have access to your online banking history.
Unfortunately, all the different banks have different methods for getting your transaction data out of internet banking. The guide below should help you do this if you belong to the major NZ banks.
Each bank differs slightly so after the more generic instructions (which should help with most banks, not just these four) there are screenshots for each of the major banks that will show you exactly what you are looking for.
If you still have problems give us a ring to arrange some more hands on help - you can come to us or we can come to you.
Click on the account you want want to generate a CSV for.
Click “Export Transactions”
Select the date range required and ‘CSV dd/mm/yyyy’ format
Under ‘Balances and Reporting’ select “Export”
Create a “New Export Profile”
Name the profile, the file to be generated (unimportant really), and select the format ‘CSV dd/mm/yyyy’.
Then select the relevant account and date range.
Click “Continue” and “Confirm” on the next page.
Under ‘Accounts’ look for the “Search/export options” button. Click this to dropdown the export options. Export a “Full CSV”
Select Account that requires Exporting
Select Export, Top Right of page
Select CSV format for export
Select the date range for the transactions required
Review selected options and if this is correct then press “Export”
Under accounts select “Search and Export”
Select the desired account, the date range for required transactions and ‘CSV - Generic’ format for export