Error Importing QIF Bank Data

  • 2
  • Problem
  • Updated 5 years ago
  • In Progress

When processing the bank data - the final step after uploading and selecting the correct account - I receive a warning box "An error occurred while processing your online banking data. Your data was not imported in to Reckon Accounts. Please try importing your data again. If this error persists, contact Reckon Accounts technical support".

I have tried a couple of times now, using two different PC's and two different browsers, but it has not worked. I bank with CBA.

Any thoughts?

Photo of Duncan Harvey

Duncan Harvey

  • 144 Points 100 badge 2x thumb

Posted 5 years ago

  • 2
Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Thanks for the additional information Duncan and starting a new thread.

This error in the past has been associated with QIFs created from Westpac accounts only, where the date format was not in the Accounts required format of dd/mm/yyyy.   I am not aware of the CBA having this problem - you did download it from NetBank? Or was it from CommBiz or CommSec?

Also, did you view the QIF file in a spreadsheet programme where the date format may have been changed?

As a first step go back to your CBA account and download a fresh file.  

Please let me know how it goes or of any other information you come by.

regards,
John
Photo of Duncan Harvey

Duncan Harvey

  • 144 Points 100 badge 2x thumb

Hi John,

Thanks for your reply.

I have tried a fresh file, and still receive the same error. The file is downloaded from Netbank. It has not been opened with any other programs. (about to try) 

I have now just opened the file using Excel to see what format the date is. It is in the format dd/mm/yy, I am not sure if excel changes it when opening or that is how it comes out from Netbank.

Should I ask the question to CBA? They did have an upgrade of Netbank the other week, and I have not downloaded any files for about 6 weeks. So can't tell you if this is an error with the new hosted version or a problem created by Netbank.


Photo of Emma

Emma

  • 110 Points 100 badge 2x thumb

Hi Duncan & John

I have also experienced this last night when trying to import my CBA QIF which I downloaded from netbank. Still receiving this error this morning when I tried a different date range and still receive the error.

Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Hi Emma,

Did you save the export file as a Quicken AUS format rather than one of the other QIF formats?

regards,
John
Photo of Emma

Emma

  • 110 Points 100 badge 2x thumb

Hi John


Yes, used the AUS format. I have been using QB and downloading files from CBA netbank for the past 8 years and I have not ever encountered this issue before.

Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Hi Emma,

Thanks,

Have replicated the issue - all 3 QIF formats failing with the same error.  

Need some time to do some testing to isolate this issue.

BTW, what computer and browser are you using?

regards,
John
Photo of Duncan Harvey

Duncan Harvey

  • 144 Points 100 badge 2x thumb
I am using both windows 7 and 8 using IE11 and also tried Firefox.  As a side note, I don't get the upload/download buttons (just a blue keyboard) when using the windows 8 PC with IE11, but do when using firefox. Windows 7 with IE works fine.
Photo of Drew

Drew

  • 130 Points 100 badge 2x thumb
Hi

We are having the exact same issue.  We are also with CBA, downloading through Netbank, same file type.

We are using windows 8 (big mistake) and had the error appear on both explorer and firefox.  I have just tried on our windows 7 machine and the same error appears.

Cheers

Fiona
Photo of John G

John G, Information Support Analyst

  • 27,510 Points 20k badge 2x thumb
Hello Emma, Duncan and Drew,

Just compared the CBA QIF to the SGB QIF and to the CBA QIF from a month ago, and yes there is a difference - the CBA has inserted a space where once there was none.

Compare these two.
Now:


A month ago:


You can see the space between T/T- and the number (underlined in red).  This is enough to make the import fail.

The workaround is to open this QIF file in Notepad and delete the space.
Your file will then import.  

Will report this to the Developers on Monday who will need to follow up with the Bank.


regards, 
John
Photo of Andrew Wernbacher

Andrew Wernbacher

  • 180 Points 100 badge 2x thumb

Same issue here...have we a rosolution as yet?

Photo of Emma

Emma

  • 110 Points 100 badge 2x thumb

Hi John

Thanks for your prompt replies. Using Windows 7 and IE. I have this morning removed the spaces as advised in the work around instructions and success. Look forward to hearing when CBA rectifies this issue. Thanks again.

Photo of Duncan Harvey

Duncan Harvey

  • 144 Points 100 badge 2x thumb

Hi John,

Thanks for the update.  It has worked for me too.

Duncan.

Photo of Andrew Wernbacher

Andrew Wernbacher

  • 180 Points 100 badge 2x thumb

John

Ive completed the suggested deletion and I seem to get the file to only open in Notepad now. Can you advise what I should be selecting to stop the file from being opened in notebook file even within Reckon?

Thanks

Andrew

 

Photo of Emma

Emma

  • 110 Points 100 badge 2x thumb
Hi Andrew

I had the same issue and found that I needed to set the default program to open the QIF file back to Reckon. Right click the QIF file and click on Reckon to set it as the default. You should then be able to use the file in Reckon again.
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Update: CBA have advised they are looking into the export file and hope to have an answer 'in coming days' via: https://community.commbank.com.au/t5/NetBank/QIF-Export-format-broken/m-p/38889