Home → Problems →

Issues importing QIF and OFC files

• Edit

Mike

16 Jun, 2010 09:06 PM

My bank account gives me the option to export QIF an OFC files. When I export a QIF file and import it to MD, all transactions are posted as deposits. When I export as an OFC file and import to MD, all transactions are posted correctely as deposits or payments but no Memo/ Descriptions are imported.

1) Is there a way something I can do with the QIF import so the transactions properly show up as a deposit or payment or is there a relatively painless why to switch the transactions from deposit to payment or vis versa once imported?

2) Or, is there something I can do with the OFC file to ensure it imports the description/ memo?

Thanks

1. 1 Posted by Ben Spencer on 23 Jun, 2010 05:33 PM

   

   Hi Mike

   To my knowledge we have never come across this problem importing QIF files before. You can easily modify a transaction once it is in the register. Double click on a transaction to put it in edit mode and move the amount from the deposit field to the payment field. I strongly suspect that this is problem caused by the bank incorrectly formatting the QIF file. If you open the QIF file in a text editor you will be able to see the raw data and verify the sign on the amount. For example a $100 deposit with the category "Salary:Bonus" and a description "a bonus" would look like this in a QIF file:

   !Type:Bank D04/10/2010
   T100.00
   C
   N
   Pa bonus
   M
   LSalary:Bonus
   ^

   And a $10 payment to the category "Bills:Gas" and the description "a bill" would look like this. Note the minus sign on the amount signifies this is a payment.

   D04/10/2010
   T-10.00
   C
   N
   Pa bill
   M
   LBills:Gas

   With regard to the OFC file again i would open the file in a text editor and verify it it contains the description and memo field. If it does please attach the file and i will have the developers take a look at it. I have made this discussion private to protect your data. If it doesn't then I recommend contacting your bank and reporting the problem.

   Ben Spencer
   Moneydance Support

   • Edit

2. Angie Rauscher closed this discussion on 24 Jul, 2011 07:55 PM.