Kellett Accounting Solutions Limited

Tax specialists for network marketing and home based business professionals
Exporting your bank statements
  • Rather than making notes on all your bank statements and then sending them to me by mail or courier, you may like to export them from online banking, make any notes on them for items that need explaining, and then attach them to an email.

  • If you do this, I can manipulate the file you send, and may be able to save myself time in processing the information, which is likely to decrease your accounting fees. Win-win!

  • All my banking is done through ASB, so I've based these instructions on their systems. If the steps below don't match the options in your bank's systems, please call me and I'll both talk you through the process, and adjust these instructions accordingly.

  • Log into online banking, then follow the instructions for each business bank account and each account that has business transactions (including ones with just interest and/or fees).
  • Select "statements" under the "accounts" menu.
  • Choose the account.
  • Date range (while you can't make transactions on weekends or public holidays, you can usually select these as part of the reporting range... since Easter often falls around year end, please make sure you've requested the full date range in question (e.g. for the 2013 tax year it will be 1 April 2012 - 31 March 2013).
  • Choose the maximum number of transactions per page
  • Export format is CSV generic.
  • Click "export" NOT "view"
  • Depending on where your computer puts downloads (mine has a button to click on at the bottom left of the screen), you'll need to find the file and double click on it.
  • It will open in MS excel.
  • Select "save as" in the file menu, and give it a name that indicates the account name and date range, e.g. asb omni 1 apr 2012 to 31 mar 2013.
  • For any items that aren't immediately obvious from the bank account description, please note down the nature of the item in a blank column (especially split out personal items). Or if there's a mix of personal and business items, you may just like to write the expense type beside the business items and leave personal ones blank.
  • Save.
  • Email it to me by creating an email and either clicking on the paperclip icon or selecting "file" in the "insert" menu. (You can attach as many files as you want to one email).
  • If the downloaded statement doesn't show the opening and closing bank account balances, please click on "view" for the same date range and give me those figures too (just in the body of the email is fine).
Contact Us