Error occured while processing ROCK Building Society QIF

Options
Amanda_8338221
Amanda_8338221 Member Posts: 4 ✭
edited February 2020 in Reckon Accounts (Desktop)
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.

Comments

  • Shane_6461899
    Shane_6461899 Reckon Staff Posts: 339 Reckon Staff
    edited February 2020
    Options
    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.
  • Amanda_8338221
    Amanda_8338221 Member Posts: 4 ✭
    edited December 2017
    Options

    D24/11/2017
    T$545.60

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


  • Shane_6461899
    Shane_6461899 Reckon Staff Posts: 339 Reckon Staff
    edited February 2020
    Options
    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
  • Shane_6461899
    Shane_6461899 Reckon Staff Posts: 339 Reckon Staff
    edited February 2020
    Options
    image

Categories