Importing a QIF file into a liability account only accepts positive transaction values. This worked OK in Q2006. In my case the QIF file is from my credit union VISA account. So the result of one month's import is to pick up only credits and not charges.
"Dennis and Lilia" wrote
Strange.
Is there some reason your credit card account is setup as a liability account? Was that a workaround for post-Q2004 qif file import restrictions?
Have you checked the qif file to be certain it contains all the transactions? If all transactions are in the qif file; are all transactions that are accepted at the beginning of the qif file, followed by all those that are not accepted?
What happens if you import to a (dummy) cash account, then cut/paste into the liability account? (If your Quicken account were a credit card account, you should be able to do the same thing).
Yes.
All of the transactions are there.
I'll try your suggestion; thanks.
Same problem using a cash account. Editing the QIF file to make one of the charges a positive value results in that transaction also being imported into the account. So looks like Quicken is explicitly skipping QIF entries with a negative value.
"Dennis and Lilia"
Not sure I would use the term "explicitly" (maybe unintentionally ... because if Intuit wanted to screw up qif imports, they could do it more "explicitly" than that), still it definitely seems like a Q2007 problem to me ... but I can't test it because I don't have Q2007.
Intuit's "helpful" reply.
Dennis, I apologize for the inconvenience caused to you. It may or may not work as QIF is not supported in Quicken 2007.
Quicken Interchange Format (QIF) is a non-proprietary data format. Although QIF was originally developed by Intuit, and certain Intuit products (including this product) still contain the ability to import and/or export files in QIF format, Intuit does not endorse or provide support for this format. For this reason, Intuit does not know the identities of all institutions and processors that support QIF.
"Dennis and Lilia" wrote
Thanks for the info, but the scheme doesn't work in Q2007. Only the transactions with a positive cash value get imported; negative cash value transactions do not. The additional four lines described in your link seem to make no difference.
Also tried exporting an existing account to a QIF file and then importing that into a new account and the same thing happened. Only positive values get imported.
"Dennis and Lilia" wrote
You tried this with a Quicken credit-card account?
(And I've forgotten; have you tried validating your file? Reinstalling Quicken?)
If nothing works, I would post your experience in the Quicken Forums. No version of Quicken through Q2006 (and I suspect the same is true for Q2007) intended to prevent importing to liability accounts. I would like to hear Intuit's response ... assuming that the problem is reproducible.
Our Bank of America VISA account updates correctly but this doesn't involve QIF files.
Validate does not indicate any problems. Haven't re-installed.
430 No such article 222 11794 body > "Dennis and Lilia" wroteOur Bank of America VISA account updates correctly but this doesn't involve QIF files.
Validate does not indicate any problems. Haven't re-installed.
430 No such article 430 No such article 222 11794 body > "Dennis and Lilia" wroteOur Bank of America VISA account updates correctly but this doesn't involve QIF files.
Validate does not indicate any problems. Haven't re-installed.
I already posted it on the Quicken forum.
Turns out in the QIF Import popup box, "Special handling for transfers" was checked by default. Clearing that checkbox allowed the import to work correctly.
Dennis: After working on this similar problem (Q2007) for two days and 1 reinstall, your recommendation to clear the checkbox solved my problem. Thank you.
David
Dennis and Lilia wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.