Quicken not downloading duplicate withdrawals

I just finished going through a whole year's worth of data to bring Quicken

2009 up to date, such that the checking account balance in Quicken should reconcile. Even though both the bank and Quicken have the same totals, the online reconcile will not work - but that's a problem that's been ongoing for the past year (and I'm not happy about it).

After spending a great deal of time completing the above task, yesterday I did two $200 ATM withdrawals (at two different times of the day, but at the same ATM) that show up in the banks online register (web site). This morning I went to download and reconcile the data and Quicken would only download one of the transactions. When I manually entered the second withdrawal in Quicken the manual, i.e., "paper" reconciliation shows I'm off by +$200. This is what caused my original problem with the Quicken check register missing two previous unrelated electronic debit card transactions on two different dates and at two different merchants.

So how do I get the online reconciliation to work, and why won't Quicken see (download) some of the transactions? Suggestions anyone?

Reply to
Harley
Loading thread data ...

If you make a transaction on a Saturday, it most likely will not show up on the bank website as "completed" until Tuesday morning. Saturday and Sunday are not business days. Transactions made on Sat or Sun are entered by the bank as being made on Monday, and are available online on Tues morning.

Bottom line, reconcile your account on Tuesday.

Reply to
wbertram

To add to the other informed reply you got:

There is no way to do what you are asking to do ... and no reason to expect to do so - based on current downloading practices.

No financial institution downloads (or should download) "pended" transactions. "Pended" transactions are transactions that your financial institution will not guarantee will ultimately "posted" to your account. Neither you, nor Quicken, should assume they will.

If you insist on taking the lazy route and using the Quicken option to reconcile to an online balance ... you will have to accept the fact that virtually every Online Balance includes every transaction submitted to your financial institution (which means "pended" transactions) ... and that Quicken can not reconcile to an "online balance" when Quicken does not have the same transactions that your fi used to compute the "online balance" that it downloaded to Quicken.

As far as I can tell, you have only two choices.

1.) Initiate your "reconciliation" (to an Online Balance) only when there are no "pended" transactions with your fi ....

or

2.) Reconcile to a "paper statement"
Reply to
John Pollard

I like the paper statement idea. Even if the statement is "paperless" on the fi's website, it is still a lot less problematic.

Reply to
Tim Conway

Why did Quicken download and reconcile one of the two transactions, when they were done at an ATM only about 2 hours apart? One of them it accepted and the other it pretends isn't even there. I just tried it again this morning and found the same result - it placed an "R" on the one $200 ATM withdrawal, but ignored the second $200 ATM transaction from the same day. And it downloaded a supermarket debit card transaction from later the same day. All three transactions show up on the bank's website. After completing the downloads Quicken complains that my balance is off by $200, and would I like to adjust my balance. I don't believe any of them are "pended," as the amounts have been deducted from the bank's online balance. One registers in Quicken and the other not.

Reply to
Harley

I think it's important to distinguish between what gets downloaded and what gets presented to the user.

Quicken has no control over what gets downloaded; your financial institution controls that.

Quicken does have control over which downloaded transactions the user gets to see, and act on.

If you're trying to detemine why you did not see a particular transaction, you'd first have to determine whether the transaction was downloaded by your financial institution. For Direct Connect downloads; see Quicken Help > Product and Customer Support > OFXLog. [You can "Save" the OFXlog to a .txt file for easier viewing in an editor or word processor.] For Web Connect downloads, save the QFX file to disk; it's format is essentially the same as the OFXlog.

If the transaction in question is not in the OFXlog/QFX file, your financial institution didn't supply it.

If the transaction in question was downloaded, you need to determine whether Quicken has a good reason to believe the transaction was downloaded before. The OFX specs require that every unique transaction be given a unique Financial Institution Transaction ID ("FITID"). If the financial institution accidentally assigns the same FITID to two different transactions, Quicken will not process the second one (you will not see it).

You can see the FITID in the downloaded data. It's important to note that when Quicken sees a downloaded transaction, it "remembers" its FITID, even if you do not Accept the downloaded transaction. Quicken saves that FITID in your Quicken data file(set). Once an FITID has been seen by Quicken, it will not (should not) present to you, any transaction with that same FITID.

So in addition to looking for duplicate FITID's in a specific download, you need to know what FITID's Quicken has stored in your data. To do that see:

formatting link
[If you're a Q2010 user, ignore the text regarding a ".QEL" file. The data that used to be stored in the QEL file, is stored in the QDF file in Q2010. But the rest of the article is still valid.]

Reply to
John Pollard

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.