CSV to QIF
I am just one of many Canadians who use MD as we all know most Canadian Banks will not support Direct Connect. Some Banks and other financial institutions allow a download of Quicken files and some Give don't have quicken files. Some institutions have Comma Delaminated files or CSV files. Big Red Consulting has a QIF to CSV converter that is an add on to excel. I know they allow a download that allows 100 transactions so you can test it. You can also test to see how many files will be downloaded and it may give you a popup telling you what your errors are that prevent you from creating a QIF file. Their is also a manual that you can assess for help. I have used excel add on and the manual and it works. If your interested download it and test it out before deciding to buy. This Excel add on is available for windows and MAC. Current cost of this product is $59 USD. I have no conflict of Interest, as I have no financial or other interest in this company. This posting is for information only and is not a sales pitch. I asked permission to post this and Ben Spencer gave me permission to post this.
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
1 Posted by Ben Spencer on 13 Apr, 2015 09:35 PM
I would like to add to this post, in the spirit of educating new users, that there is also a free extension for Moneydance called "Text Import" which can import some, but not all, CSV files directly. You can install it by going to the menu bar and selecting Extensions->Manage Extensions.
Ben Spencer
Infinite Kind Support
2 Posted by -Kevin N. on 13 Apr, 2015 10:57 PM
To add to Ben's post, there is also a third party CSV importer that is a little more robust than the 'Text Import' extension.
You can d/l the version for MD 2015 here:
https://github.com/stant/mdcsvimporter2015/releases
-Kevin N.
3 Posted by dwg on 13 Apr, 2015 11:25 PM
There is also a free Excel to QIF converter available:
http://xl2qif.chez-alice.fr/xl2qif_en.php
A version is also available for OpenOffice/LibreOffice
http://xl2qif.chez-alice.fr/calc2qif_en.php
I used the Excel version successfully when I migrated to MoneyDance importing 70+ accounts.
Des
System closed this discussion on 19 Mar, 2016 04:55 AM.