How to Download a .QIF file so that you can send us your electronic bank statements.
Part of going paperless means that data is now exchanged in different ways and formats. The easiest way for us to receive your bank transaction information is directly into an online accounting system such as MYOB Essentials. When this is set up for the first time, we may also request that you email us a QIF file for a specific date range, this will be a one-off request.
We require the QIF file because most of the banks will only supply the bank transactions from the date that the systems are set up. In order for us to have a complete financial year of data, we need to get an electronic copy of the bank transactions from the start of your financial year (usually 1 April) through to the start date of the banking transactions in your accounting system.
MYOB specifically requires a QIF file. Please be aware that this is not the same as a CSV, it will not be able to be opened. The reason we ask for this type of file is that it contains a lot more data and integrates better with the software.
The process for getting a QIF file is fairly straight forward but is slightly different depending on which bank you are with. We have provided detailed instructions below for each major bank in New Zealand. If you require further assistance to complete this, please don’t hesitate to contact us.
It is also recommended that a PDF of the Bank Statement that clearly shows the balance as at the end date of the QIF Data you are sending is also sent to us. For example, if you are sending a QIF from 01 April 2019 to 27 May 2019, also include the May Statement which shows what the correct balance is as at 27 May 2019. This step acts as a check to ensure that the data has correctly been transferred to the software.
If you have chosen to use XERO, we may request an OFX file, you can follow these same instructions and just choose OFX as the file format instead of QIF.
Once you have downloaded the files please email them back to us so that we can get the accounting software set up correctly with a full year of transaction data. If you have any questions or concerns please get in touch, we are happy to help.
To jump to your particular bank instructions, please click on the appropriate heading below: