Home → Problems →

Transaction's date fails to load using "Text file importer"

• Edit

bonnie

25 Jan, 2011 05:58 AM

Evaluating Moneydance as a replacement for Quicken. I'm testing various routines for importing my data to Moneydance using a combination of imports from Quicken QIF files and OFX or CSV files from my credit union.

I would like to import the past two years of checking account transactions. I've been testing various import options, from OFX files from my credit union and QIF files generated by Quicken. As neither OFX or QIF files support the category field in the transaction, I tried using the MD "Text file importer". Here too, "Text file importer" does not identify a category field, but at least I was able to place the category info in the MD "Memo" field.

The problem with "Text file importer" that I can't get working, is the transaction's posting date is not being imported. Whatever I try, MD is setting the date for all the imported transactions to the current date instead of the posting date. All the other fields are importing correctly.

Is this a "Text file importer" issue, or is there something I'm doing wrong?

Moneydance (v. 2010r3(751)), Java 1.6.0_23, Windows XP SP3

Thanks, Bonnie

1. 1 Posted by Ben Spencer on 25 Jan, 2011 04:11 PM

   

   Hi Bonnie

   You should use the QIF file format. The QIF importer in Moneydance will use the category field on each transaction in the QIF file if you set the "From another program" option on the QIF import window.

   You can find instructions for importing your data from Quicken in the article linked below:
   http://help.infinitekind.com/kb/importing-from-quicken-or-ms-money/...

   Sincerely
   Ben Spencer
   Moneydance Support

   • Edit

2. 2 Posted by bonnie on 26 Jan, 2011 01:46 AM

   

   1) I have data that is not in Quicken that I'd like to load. Example: detail credit card transactions from my credit union. Is there a recommended CSV to QIF converter utility?

   Using "Text File Importer"

   2) I found the reason why the current date was being loaded instead of the posting date. Unseen down in "More Fields" was another "Date" selection, which resulted in a null value. I must have accidentally set this? Resetting this field to "Ignore" solved the problem.

   3) With more testing I discovered that the "Account" field designation would load the data in the MD category field. :-)
   

   -Thanks again, Bonnie

   • Edit

3. 3 Posted by Angie Rauscher on 03 Mar, 2011 07:06 PM

   

   Bonnie,

   I don't have a recommended CSV to QIF importer, but I imagine a web search would turn up quite a few. You can use the csv importer to import to credit card files, but to be completely honest if you have any other options (qif, ofx, ofc, qfc) for file types you should take them. That said, the text file importer is a good backup option when the other file types aren't available. Good luck getting your information imported, and please let me know if I can be of further assistance,

   Angie Rauscher
   Moneydance Support

   • Edit

4. System closed this discussion on 31 Mar, 2015 03:40 PM.