Prev: Printing checks from register, or alternatives
Next: Quicken 2008 not downloading all transactions for a credit card
From: Harley on 23 May 2010 09:26 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 23 May 2010 15:10 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 23 May 2010 20:41 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 24 May 2010 04:53 "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 24 May 2010 07:46
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 > > |