Importing QIF Bank Statement Fails

  • 1
  • Problem
  • Updated 4 years ago
  • Solved

I am now unable to import QIF bank statements into Reckon Accounts 2013 despite having done this many times in the past.

I have tried importing directly from the bank using 'Online Banking Centre' and by first downloading the file & importing using 'Import Bank Statement'.

I figured the problem might be with the file itself, so I tried importing an old QIF file which I have already imported previously. That failed leading me to believe there was some sort of corruption in my Reckon Accounts installation.

I have tried repairing via Windows Control Panel without any joy.

Can anyone suggest what I should be doing next please?...

Photo of Craig

Craig

  • 112 Points 100 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hey Craig, can you confirm the which bank these files are coming from?
Photo of Craig

Craig

  • 112 Points 100 badge 2x thumb

Hey Mirko, they're coming from Westpac (www.westpac.com.au)

I have used their files before and as I mentioned I tried reloading an old file (which previously did work), however it did not work this time.


Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hey Craig, shoot me a copy of the QIF to community@reckon.com so I can test it from our end - so see how it goes on my Reckon Accounts install (I'll test on 2013, 2014 and 2015). Cheers, Mirko.
Photo of Craig

Craig

  • 112 Points 100 badge 2x thumb
Thanks, I sent that today Mirko, sorry it took me a while. Craig
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Cheers Craig - no need to apologise. I've had a quick squiz at it myself and all imported fine in 2014. I've escalated the issue to our tech support and they revived an error (see below) when importing to 2015.

When I tried in 2014, I went to import Bank Statement files with no error.





If that doesn't work try to select Web Connect Files as that got our Tech Support team member to successfully import after an error.

Keen to hear how you go Craig!
Photo of Craig

Craig

  • 112 Points 100 badge 2x thumb

Thank you Mirko but neither of these have worked for me.

I have an option to 'Import Bank Statement...', which offers to convert a QIF file to QBO & import it. This option gives me the error I reported above during the import stage.

I looked up 'Web Connect Files' in the program's help. It refers to importing QBO files & says I should right click & choose open. When I do that it asks me if I want to import now (which I do), then in the next stage I get the same error as I reported above.

I tried also importing an OFX file which would not work because Reckon Accounts wanted to open it as a new company.

I'm not really sure what to try next...

Photo of Tony Wilson

Tony Wilson

  • 70 Points
I am getting exactly the same issue with NAB statements for my credit card.
Photo of Craig

Craig

  • 112 Points 100 badge 2x thumb
Here's what I do now. Download QIF to your hard drive. Then import via Banking / Import Bank Statement. It works for me.
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Hi Tony,

Welcome to the Reckon Community.

I believe NAB offers a couple of QIF formats - a Quicken 6 and earlier, and a Quicken 7 and later.  Make sure your export file is in the Quicken 7 option option.

This error usually relates to an incorrect date format - mm/dd/yy rather than the dd/mm/yyyy format required by Reckon Accounts.  


Hope this helps.


regards,
John.
Photo of Tony Wilson

Tony Wilson

  • 70 Points
Wow that's fixed it completely. Thank you very much.
Photo of John G

John G, Information Support Analyst

  • 27,530 Points 20k badge 2x thumb
Great to hear Tony.


regards,
John