Ethan on 21 Jan, 2019 05:41 PM
I'm not quite sure why they offer so many choices for Quicken, as the file format should be the same for most of those, and then they don't even list versions from the past 15 years. If the Quicken files are the QFX format, they should work just as well as the OFX format the above user suggested. If they are QIF format, those will still work, but are generally not as good as OFX or QFX.
I'm not even sure what a MS Works file would be (maybe a spreadsheet compatible file?), so I'd avoid those.
Ethan on 21 Jan, 2019 08:04 PM
From the options, it sort of sounds like someone set this up in the early 2000s, and no one has updated the options since. MS Works hasn't existed for almost a decade at this point, for example. I'd go with the OFX format out of all your choices.
Ethan on 21 Jan, 2019 08:37 PM
Ah, I misunderstood. I thought the MS Money was an OFX file, but you said it was also QIF. I believe MS Money could read QIF files, but that is technically an incorrect designation, just as wrong as calling a CSV a MS Works file. Strange!
QIF files should import fine. The only significant difference with what you're doing is that they won't have unique transaction IDs for your data. This means that every time you download a file that contains an already existing transaction, Moneydance will not be able to understand it has seen it before, and will reimport it. You will then have to merge those transactions with the existing ones in the confirmation process. This wouldn't have to be done with newer OFX or QFX formats.
As Ethan pointed out. should the QIF file format prove problematic with regards to allowing duplicate transactions, there is a free, third-party CSV Importer designed specifically for Moneydance that does a good job of preventing duplicates.
If you're interested in trying it out, let me know and I'll dig up the link to the developer's website.
I received a reply from my bank overnight concerning download formats. I won't bore you with their long, irrelevant template reply but I will copy my response. It is a UK bank:
Thank you for your reply. MS Money was discontinued in 2009, Quicken stopped producing UK software in 2005, MS Works was discontinued in 2009 as was Lotus 123. The QIF format has been superseded by QFX and OFX which integrate with modern accounting software in a more intuitive way. Please read my original message again. I do not wish to connect my accounting software to the bank. I wish to download my data in a modern format. I would be grateful if you would pass this correspondence up to someone who can answer my question please.
My question was why can't I get a QFX or OFX file download.
Hi Jeff. Oh I won't be changing from Moneydance, The bank in question is First Direct. They are fine for me in all other respects so, like the good Remainer I am, I shan't be leaving but aiming to change from within. ;)
Thank you for the link. That looks very interesting. With Kevin's link and yours I shall have plenty to try out this afternoon.