Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Importing qif file, is this something I am going to have to live with

0 views
Skip to first unread message

bdeditch

unread,
Jan 15, 2007, 10:02:52 PM1/15/07
to
Is there any way of not having to accept every transaction, when I
download the qif file from Bank of the West. Why can't it just show the
new ones?? Running Money 2007

Cal Learner-- MVP

unread,
Jan 15, 2007, 10:50:48 PM1/15/07
to
In microsoft.public.money, bdeditch wrote:

>Is there any way of not having to accept every transaction, when I
>download the qif file from Bank of the West.

ReconcileTransactions->AcceptAllTransactions.

> Why can't it just show the
>new ones?? Running Money 2007


Do you mean that there are identical transactions that are not being
properly matched to existing transactions? There is not a choice to
automatically accept only the matched transactions, tho there is the
opposite choice available.

bdeditch

unread,
Jan 16, 2007, 8:18:11 AM1/16/07
to

Cal Learner-- MVP wrote:
> Do you mean that there are identical transactions that are not being
> properly matched to existing transactions?

I had this problem as well for a while, it just stopped, don't know
what I did to get that problem solved

Mark Horn

unread,
Jan 17, 2007, 8:12:58 AM1/17/07
to

What I hear you saying is that when you download transactions A,B&C
today, you have to accept them. Then tomorrow, when you download
A,B,C,D&E, you have accept A through E. Which means you had to
accept A,B&C twice.

If that's the case, then the reason is that you're using QIF.
If you have the option try downloading OFX instead of QIF.

QIF is a pretty old mechanism for downloading transactions.
It does not have any facility for uniquely identifying transactions.
However, OFX has a facility which allows the bank to assign unique
transaction IDs to every single transaction. Money recognizes
these IDs, so that when it see's transaction A,B&C again, it knows
that they're not new transactions but already accepted transactions,
and it doesn't prompt you to accept transactions that you've already
accepted. Unfortuately, because QIF doesn't uniquely identify all
transactions, Money doesn't know if A,B&C are the transactions from
yesterday or entirely brand new transactions that just happen to
have the same payee, date, and amount as the ones from yesterday.
It thinks that it probably is the same transaction so it attempts
to match them, but it can't be certain so it has to ask.
When Money uses OFX, this ambiguity disappears.

Bottom line: if you can use OFX instead of QIF, you'll avoid this
problem.

0 new messages