Exporting data from Reckon Personal Plus in QIF format

agchristie's Avatar

agchristie

09 Mar, 2020 11:03 AM

Dear All,
There was an article by Michael Young in 2017 on this subject and I wish to add some more info on the ability to export data from Reckon PP in QIF format. I am a long term Quicken/Reckon user who is moving over to Moneydance

Reckon has hidden the ability to export account data from us lowly users. However it can be revealed.

1. Open Reckon Personal plus
2. Run your cursor over 'File' in the menu ribbon. Do not left mouse click to expand the 'file' menu
3. Hit the Keys CTRL-SHIFT-Z
4. Open the "file' menu path > Export and the option to export in QIF format will become available

Note: If you have any 'hidden' accounts you will have to 'unhide' them to export their data.

regards

Andrew

  1. 1 Posted by dwg on 09 Mar, 2020 11:27 AM

    dwg's Avatar

    I'm a fellow user.

    Another user found this little trick out a few years ago, thank you for confirming it still exists.

    http://help.infinitekind.com/discussions/suggestions-for-our-knowledge-base/45-reckon-personal-accounts-2016-australian-version-you-can-export-to-qif

    However as I recall this only allowed for exporting one account at a time and this is a real nuisance, it certainly does not help with the problem of creating duplicates. I'm wondering if the QIFs produced have enough header information that would enable the combining of all the individual QIF files into one larger QIF and perhaps avoid some problems in this regards.

  2. 2 Posted by agchristie on 12 Mar, 2020 11:06 PM

    agchristie's Avatar

    Hi dwg,
    Thanks for your answer, yes only one account at a time. It's a pain but I will perservere. I am using Reckon PP 2020

    On my import testing of the so created QIF files I found that if I had posted back into an account the import created a duplicate account to cover the posting e.g. 'SavingsX ' account was created as well as the original 'Savings' account. :-(.

    I have been testing Michael Young's solution and have found that a couple of tweaks were needed because of the time lag. I note that you have created an addendum. Any chance of seeing your spreadsheet? I can only access your document.

    I have found that some accounts/categories can be duplicated in the export process so I have created an empty account in Reckon and exported that to a QIF file along with all other accounts and categories fields ticked. Subsequent exports for other files are done without these items ticked. Seems to work OK.

    The QIF files created from Reckon seem to have the necessary header info, as far as combining the QIF files this is out of my technical prowess. Would be nice though.

    regards

  3. 3 Posted by dwg on 13 Mar, 2020 12:16 AM

    dwg's Avatar

    Reckon does not follow account rules, hence its ability to draw on the account itself and thus create or dispose of money in thin air. Nice party trick but not going to win any friends in accounting circles or the ATO. The latest preview versions of Moneydance can handle this Reckon quirk if it is used for the initial balance. Otherwise you get the accountX creation to make the transaction meet the rules.

    I'm assuming you mean the extensions I made to Michael's spreadsheet. I added to the formulas to deal with some common situations. A copy is attached in a zip file.

    There is another spreadsheet to deal with Investment accounts, it looks very similar but uses a lot of VBA code to parse the data rather than the formula based sheet that handles bank type accounts. i built it in the days of Moneydance 2012 and dealt with some specifics around that version, the QIF importer is quite different now, I'm not sure how useful it would be now and I suspect the QIF files that Reckon can produce may be a better starting point in any case.

    In some recent testing I found the latest version of Moneydance handles duplicates much better than it used to, but not something that I think could be completely solved.

    Combining QIFs could be interesting but it would most likely need some additional QIF entries manually added to give the importer what is needed, I suspect the QIFs produced just have the minimum required for a single account.

  4. 4 Posted by agchristie on 13 Mar, 2020 07:07 AM

    agchristie's Avatar

    Hi again dwg

    I think I will (for the while) persevere with the QIF export from Reckon. So far so good.

    I'll let you know how I go

    cheers

    Andrew

  5. System closed this discussion on 12 Jun, 2020 07:10 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac