DOWNLOADING A CSV FILE FROM YOUR BANK (WITH SCREENSHOTS FOR ASB, BNZ, KIWIBANK, WESTPAC)
At Dropbooks.co.nz 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.
HOW TO DO IT
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.
HOW TO GET CSV FILES FROM YOUR BANK:
- Log into your online banking
- Select the account you want to download a CSV for
- Find a “view statements” or “view transaction history” or similar tab and click on it
- Insert the date range we have asked you for
- Make sure you select the CSV option as the “Output” or “Format”
- Click “Export”, “Save” or “Download” and the file will be saved to wherever your computer usually saves files
- Don’t open the file as you can corrupt it
- Now go into your email and set up an email to your client manager here at Dropbooks and attach the file and subject it “CSV files for Dropbooks”
- Send it to us 🙂
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
WESTPAC BUSINESS ONLINE
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