Payee Information in the Memo Field
Todd Jonas
When I download & import transactions into MD from my checking account I see all of the payee information gets loaded into memo field. The Description field gets filled with "Withdrawal" or "Withdrawal #45644" or similar. Is there any way I can get MD to load the payee info in to the Description field?
2 Posted by james f on 07 Jul, 2012 04:20 AM
What file format are you downloading your transactions? QIF, OFX, QFX, CSV?
If your Financial Institution (FI) offers it, it is suggested that you download using either OFX (Microsoft Money) or QFX (Quicken) format.
There is no standard format for CSV. Every FI writes CSV files differently. There are programs available to edit the file to conform to Moneydance, but I find it quite a daunting task, so I don't bother with it.
QIF is a flakey format at best. It was never intended to br used by the general public. It was developed primarily to be used internally by FI's.
3 Posted by Todd Jonas on 07 Jul, 2012 07:06 AM
I used QFX and OFX with the same result -- payee information in the memo field.
What's strange is that downloads from my savings account from the same FI work ok. It's just the checking account that go astray.
Support Staff 4 Posted by Jessica Little on 07 Jul, 2012 10:53 AM
Unfortunately, we fill those fields in the way they are sent by your bank. It's likely that they are sending the payee information in the memo field for some reason, which is why you are seeing it there in Moneydance. If you view your OFX file in a text editor, you should be able to confirm this. In order to change this, you would need to manually edit either your OFX file or the transactions in Moneydance after the import.
Jessica Little
Moneydance Support
5 Posted by Ric Werme on 07 Jul, 2012 04:46 PM
I have a similar problem with my Credit Union. I assume you aren't a programmer since you didn't look at the contents of the .ofx files, so I probably can't help much.
When I added a credit card to the services from the credit union, I decided it was time to write a Python program that I run between downloading and importing. Much easier than writing a Jython (or Java) program to fix things later. Also, safer to the .md file.