Error occured while processing ROCK Building Society QIF

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Version 2017 Reckon (Desktop) Premier.  Trying to import QIF from Rock Building Society.  I have downloaded all of the formats (dd/mm/yyy, dd/mm/yy, mm/dd/yyyy, mm/dd/yy) and still receive the error message stating there was a problem.  I have opened the file with notepad and there are no obvious issues such as spaces.  Very frustrated.
Photo of Amanda

Amanda

  • 132 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Shane

Shane, Employee

  • 7,388 Points 5k badge 2x thumb
Hi Amanda,

Can you show us the first transaction as it shows in note pad.

EG: this is one transaction:
D01/01/2017
T-3000.00
PRent
^

PS: That works for me.

Regards,
Shane.
Photo of Amanda

Amanda

  • 132 Points 100 badge 2x thumb

D24/11/2017
T$545.60

MDIRECT CR  FROM:MARGARET BEAK      REF: Su Beak Inv 61
^


Photo of Shane

Shane, Employee

  • 7,388 Points 5k badge 2x thumb
Hi Amanda,

The reason it isn't working is because of the $ symbol in the amount.  Reckon Accounts can't accept amounts with the $.  You could open the QIF in Notepad, click Edit, Replace, in Find What enter $ and leave Replace with: blank.  CLick Replace All.  This will remove all the $ for you.  Then click File, Save.

Try to import it again and it should work, assuming there are no other issues file.

let me know how it goes.

Regards,
Shane
Photo of Shane

Shane, Employee

  • 7,388 Points 5k badge 2x thumb