From: Harley on
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?


From: wbertram on
On 5/23/2010 9:26 AM, Harley wrote:
> 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?
>
>

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.
From: John Pollard on
Harley wrote:
> 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?

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"

--

John Pollard
news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
Your source of user-to-user Quicken help


From: Tim Conway on

"John Pollard" <8plus7isf(a)gmail.com> wrote in message
news:htchvo$63u$1(a)news.eternal-september.org...
> Harley wrote:
>> 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?
>
> 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"
>
I like the paper statement idea. Even if the statement is "paperless" on
the fi's website, it is still a lot less problematic.

From: Harley on
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.


"John Pollard" <8plus7isf(a)gmail.com> wrote in message
news:htchvo$63u$1(a)news.eternal-september.org...
> Harley wrote:
>> 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?
>
> 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"
>
> --
>
> John Pollard
> news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
> Your source of user-to-user Quicken help
>
>