Home Page link  

Q2007 QIF import to liability account incomplete

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Q2007 QIF import to liability account incomplete Dennis and Lilia 09-01-2006
Posted by Dennis and Lilia on September 1, 2006, 5:18 pm
Please log in for more thread options
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 T.Cook

Posted by John Pollard on September 1, 2006, 5:30 pm
Please log in for more thread options

> 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.

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).



Posted by Dennis and Lilia on September 1, 2006, 5:34 pm
Please log in for more thread options
says...
>
> > 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.
>
> 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?

Yes.

>
> 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?

All of the transactions are there.

>
> 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).

I'll try your suggestion; thanks.

>
>
>

--
Dennis T.Cook

Posted by Dennis and Lilia on September 1, 2006, 5:46 pm
Please log in for more thread options
DennisCook@comcast.net says...
> says...
> >
> > > 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.
> >
> > 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?
>
> Yes.
>
> >
> > 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?
>
> All of the transactions are there.
>
> >
> > 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).
>
> 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 T.Cook

Posted by John Pollard on September 1, 2006, 9:48 pm
Please log in for more thread options
"Dennis and Lilia"
> 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.

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.



Similar ThreadsPosted
Help! - Q2007 Cap Gains is Incomplete January 6, 2007, 10:23 pm
Q2007 ~ Xfrs fromiInvestment account not showing up in linked account. October 27, 2007, 5:16 pm
Cannot import Vanguard download to correct investment account May 15, 2008, 12:19 pm
Q2007 - Account Bar September 12, 2006, 3:42 pm
Downloading transactions, Q2007 suddenly doesn't seem to find the right account September 25, 2007, 12:22 pm
What Gets Matched on QIF Import? July 19, 2006, 3:35 pm
Q07 TurboTax import August 19, 2006, 2:04 pm
Import my paychecks February 12, 2007, 6:31 pm
QIF--export/import November 11, 2007, 1:06 am
Import-export question August 6, 2006, 12:21 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap