Error importing Westpac bank statements

  • 1
  • Problem
  • Updated 5 months ago
Hi,

I am using Reckon Accounts Plus 2017 and attempting to import Westpac NZ bank and credit card statements.

Whilst using Accounts Plus 2016 I had no problem with this.

I am able to import ASB and ANZ bank statements into 2017 without any trouble.

The error message I am getting is:
Errors were encountered wihile attempting to convert:
file name.qif
Please ensure that this file is a valid qif.


Having read a number of others queries on this topic I can confirm:
- I am downloding the correct Quicken format
- When I open the qif file the date is correctly formateed, eg, D31/12/17
- The qif file starts with !Type:Bank
- I am saving the qif file to my desktop and then uploading
- there are no files already listed in the online banking screen for either of these accounts.


I have compared the qif file with the ones from ASB and ANZ and can see no differences other than the file size.
The ASB and ANZ files are 2KB and the Westpac one 64kb for a similar number of transactions.

Can anyone help please?

Many thnaks.
Photo of Clare Bristow

Clare Bristow

  • 90 Points 75 badge 2x thumb

Posted 5 months ago

  • 1
Photo of Michelle Thomas

Michelle Thomas

  • 70 Points
I have the same problem with reckon hosted 2018 while trying to import a westpac bank statement file. I was advised by Reckon support to check with westpac as they may have changed their QIF file format recently. I haven’t contacted them yet though
Photo of Clare Bristow

Clare Bristow

  • 90 Points 75 badge 2x thumb
Thanks Michelle.  Did Reckon support suggest where to start finding the right person to speak to at Westpac? 
Photo of Michelle Thomas

Michelle Thomas

  • 70 Points
No they didn’t but I have sent westpac a message via online banking so will let you know what they say when they get back to me. I find it hard to believe we are the only westpac Reckon users having this issue, surely if westpac changed something like this Reckon would know about the issue by now?
Photo of brendon

brendon

  • 70 Points
Same issue for me, reckon small business 2015. Everything worked fine last time i imported statements - but now have this issue. Seems most likely westpac are the culprit. 
Photo of brendon

brendon

  • 70 Points
Aha, i've found the issue. It is indeed with westpacs .QIF file export feature. This appends multiple lines of ‘NULNULNUL...’  to the end of the file.

The files are valid if you delete this from the end of the file before importing them.
- In notepad or similiar this will look like whitespace below the last ^
- In a hex editor or similar these are nulls.

I have no idea how to get this to the right people at westpac so emailed my local bank contact, feel free to forward to the correct team if anyone knows.
(Edited)
Photo of Clare Bristow

Clare Bristow

  • 90 Points 75 badge 2x thumb
Thanks Brendon; it sounds like you have the solution.
I haven't had chance to give it a go but will have a look at the weekend.
Many thanks for posting what you've found out, I appreciate it.
Photo of Mike Maltby

Mike Maltby

  • 350 Points 250 badge 2x thumb
Thanks for the solution Brendon. It was starting to get annoying.. For anyone not sure how to get rid of the Null's this is what I did: Edit the QIF file with Notepad. You won't see anything after the last ^ but if you drag your mouse down the page you will see that you are selecting text. When you get to the end release the mouse,  delete then save the file.