Quicken quirk in .qif imports?


B

bruce

Using Quicken 2001, Win XP, cable modem, using online banking for personal
finances.

1. Every Monday, my bank does an auto transfer of $100.00 from the primary
account to each of two accounts. These accounts are all at the same bank.
This happens twice each Monday.

2. When I export transaction data from the bank, into a .qif file, and bring
it into Quicken, a problem arises. Each transfer imports with "AUTO DRAFT
SENT TO" , and then ID's the account number the $100. was sent to. For some
reason Q wants to always place each of the weekly $100.00 transfers at THEIR
REPECTIVELY SAME, AND AT SOME PREVIOUSLY OCCURING date. ( A different Monday
date that had already been accepted in an earlier session.) When I go to
accept all, I am $200 out of balance each Monday.

3. The bank tells me it is Q's fault. Q won't hear me unless I shell out $
for support. I believe that the problem lies in the way the data has been
packaged at the bank. I think that some unique marker needs to be added to
the 'auto draft sent' transaction that Q will recognize, as a new event,
upon import. But how to get the correct information in order to get someone
at the bank to listen to me.

Any suggestions???

tyia, bruce
 
Ad

Advertisements

J

John Pollard

bruce said:
Using Quicken 2001, Win XP, cable modem, using online banking for
personal finances.

1. Every Monday, my bank does an auto transfer of $100.00 from the
primary account to each of two accounts. These accounts are all at
the same bank. This happens twice each Monday.

2. When I export transaction data from the bank, into a .qif file,
and bring it into Quicken, a problem arises. Each transfer imports
with "AUTO DRAFT SENT TO" , and then ID's the account number the
$100. was sent to. For some reason Q wants to always place each of
the weekly $100.00 transfers at THEIR REPECTIVELY SAME, AND AT SOME
PREVIOUSLY OCCURING date. ( A different Monday date that had
already been accepted in an earlier session.) When I go to accept
all, I am $200 out of balance each Monday.
Then don't "accept all". When you do, you are implicitly telling
Quicken that you agree with their match/nomatch logic. If you accept
transactions individually, you may elect to ignore/override Quicken's
match criteria. QIF file matching criteria are different than direct
download match criteria (and will usually find more matches than
direct downloads); and while it is possible that the bank is making an
error, I think it is more likely that you need to take more control of
the compare-to-register process.

If you have already entered the transactions in your register before
the download, then you want the downloaded transactions to match. If
you have not already entered them, you want the downloaded
transactions to be new. If you accept transactions individually, you
can guarantee this will happen.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top