Home Page link  

reconcile not showing all transactions

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
reconcile not showing all transactions EdStevens 08-13-2008
Posted by EdStevens on August 13, 2008, 6:57 pm
Please log in for more thread options

Q 2006 Dlx on Vista Premium

Doing a checking account statement reconciliation. I do all of my
reconciliations to 'paper' statement, not online. Usually goes
without a hitch, but this time it was off by the amount of one pay
check. Digging a bit deeper, the deposit is in my Q account register,
it is on the bank statement, but the list brought up for
reconciliation doesn't show it. Double checked dates of statement vs.
reconciliation and they are good. Q. reconciliation is showing
transactions before and after the 'missing' deposit. Ran a file
verification, which reported no problems.

Ideas?

Posted by John Pollard on August 13, 2008, 7:18 pm
Please log in for more thread options

EdStevens wrote:
> Q 2006 Dlx on Vista Premium
>
> Doing a checking account statement reconciliation. I do all
> of my
> reconciliations to 'paper' statement, not online. Usually
> goes
> without a hitch, but this time it was off by the amount of one
> pay
> check. Digging a bit deeper, the deposit is in my Q account
> register,
> it is on the bank statement, but the list brought up for
> reconciliation doesn't show it.

> Double checked dates of statement vs.
> reconciliation and they are good.

This is probably the key ... but it's not clear "exactly" what
dates you compared. If you compared using "transaction" date
(the date you see in your Quicken register), your comparison was
not valid.

You need to make sure the "Posting date" of your register
transaction is not later than the "statement date" of your
reconcile.

> Q. reconciliation is showing
> transactions before and after the 'missing' deposit. Ran a
> file
> verification, which reported no problems.
>
> Ideas?

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by EdStevens on August 13, 2008, 9:42 pm
Please log in for more thread options


> EdStevens wrote:
> > Q 2006 Dlx on Vista Premium
>
> > Doing a checking account statement reconciliation. I do all
> > of my
> > reconciliations to 'paper' statement, not online. Usually
> > goes
> > without a hitch, but this time it was off by the amount of one
> > pay
> > check. Digging a bit deeper, the deposit is in my Q account
> > register,
> > it is on the bank statement, but the list brought up for
> > reconciliation doesn't show it.
> > Double checked dates of statement vs.
> > reconciliation and they are good.
>
> This is probably the key ... but it's not clear "exactly" what
> dates you compared. If you compared using "transaction" date
> (the date you see in your Quicken register), your comparison was
> not valid.
>
> You need to make sure the "Posting date" of your register
> transaction is not later than the "statement date" of your
> reconcile.
>
> > Q. reconciliation is showing
> > transactions before and after the 'missing' deposit. Ran a
> > file
> > verification, which reported no problems.
>
> > Ideas?
>
> --
>
> John Pollard
> First initial underscore Last name at mchsi dot com
> Please reply to newsgrou

The period of the paper statement is 6/12 to 7/14. The date of the
'missing' transaction is 7/3. The "statement summary" window during
reconciliation shows deposits dating from 6/12 to 8/14. All deposits
from 6/12 through 7/9 are checked to be reconciled.

(If you're wondering why I'm just now reconciling a statement from
that period .... my bank has had recent problems getting statements
out. We don't get paper statements in the mail .. just an email
notification of availability, then we download a pdf. We now have
other issues with them as well, as seen in my other posting
today ....) :-(

Posted by John Pollard on August 14, 2008, 9:07 am
Please log in for more thread options


EdStevens wrote:
> wrote:
>> EdStevens wrote:
>>> Q 2006 Dlx on Vista Premium
>>
>>> Doing a checking account statement reconciliation. I do all
>>> of my
>>> reconciliations to 'paper' statement, not online. Usually
>>> goes
>>> without a hitch, but this time it was off by the amount of
>>> one
>>> pay
>>> check. Digging a bit deeper, the deposit is in my Q account
>>> register,
>>> it is on the bank statement, but the list brought up for
>>> reconciliation doesn't show it.
>>> Double checked dates of statement vs.
>>> reconciliation and they are good.
>>
>> This is probably the key ... but it's not clear "exactly"
>> what
>> dates you compared. If you compared using "transaction" date
>> (the date you see in your Quicken register), your comparison
>> was
>> not valid.
>>
>> You need to make sure the "Posting date" of your register
>> transaction is not later than the "statement date" of your
>> reconcile.
>>
>>> Q. reconciliation is showing
>>> transactions before and after the 'missing' deposit. Ran a
>>> file
>>> verification, which reported no problems.
>>
>>> Ideas?
>>

> The period of the paper statement is 6/12 to 7/14.

> The date of the 'missing' transaction is 7/3.

Again: is this the "transaction" date? If so, it is not the
date that matters.

Right click the 7/3 transaction (in the register). Then hold
down the CTRL key while left-clicking "Copy transaction". What
is the "Posting date"? If it is later than July 14, that is why
it's not showing up in the reconcile.

> The "statement summary" window during
> reconciliation shows deposits dating from 6/12 to 8/14.

The reconcile window only shows "transaction" dates, not
"posting" dates.

--

John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by EdStevens on August 14, 2008, 10:16 am
Please log in for more thread options


> EdStevens wrote:
> > wrote:
> >> EdStevens wrote:
> >>> Q 2006 Dlx on Vista Premium
>
> >>> Doing a checking account statement reconciliation. I do all
> >>> of my
> >>> reconciliations to 'paper' statement, not online. Usually
> >>> goes
> >>> without a hitch, but this time it was off by the amount of
> >>> one
> >>> pay
> >>> check. Digging a bit deeper, the deposit is in my Q account
> >>> register,
> >>> it is on the bank statement, but the list brought up for
> >>> reconciliation doesn't show it.
> >>> Double checked dates of statement vs.
> >>> reconciliation and they are good.
>
> >> This is probably the key ... but it's not clear "exactly"
> >> what
> >> dates you compared. If you compared using "transaction" date
> >> (the date you see in your Quicken register), your comparison
> >> was
> >> not valid.
>
> >> You need to make sure the "Posting date" of your register
> >> transaction is not later than the "statement date" of your
> >> reconcile.
>
> >>> Q. reconciliation is showing
> >>> transactions before and after the 'missing' deposit. Ran a
> >>> file
> >>> verification, which reported no problems.
>
> >>> Ideas?
>
> > The period of the paper statement is 6/12 to 7/14.
> > The date of the 'missing' transaction is 7/3.
>
> Again: is this the "transaction" date? If so, it is not the
> date that matters.
>
> Right click the 7/3 transaction (in the register). Then hold
> down the CTRL key while left-clicking "Copy transaction". What
> is the "Posting date"? If it is later than July 14, that is why
> it's not showing up in the reconcile.
>
> > The "statement summary" window during
> > reconciliation shows deposits dating from 6/12 to 8/14.
>
> The reconcile window only shows "transaction" dates, not
> "posting" dates.
>
> --
>
> John Pollard
> First initial underscore Last name at mchsi dot com
> Please reply to newsgroup

That was it. That 'posting date' was shown as July 17. Not sure how
that happened as the transaction is an electronic deposite of my
paycheck, but there it was. With that 'secret' key combination I was
able to edit the posting date to match the date as shown on the bank
statement, and everything matched up after that.

Thanks again for you help

Similar ThreadsPosted
Downloaded Transactions not showing September 11, 2007, 7:06 am
Downloaded transactions not showing up in register February 26, 2008, 1:39 am
Transactions not showing up in linked checking account August 2, 2007, 9:59 am
Import transactions without reconcile September 23, 2007, 9:16 pm
Vanguard midcap not showing changes August 25, 2006, 10:35 pm
Purchased security not showing August 6, 2007, 12:20 pm
Report Showing Basis? November 5, 2007, 9:59 am
PAYX showing a yield of 0.00 September 26, 2008, 10:51 pm
Report showing running shares July 8, 2007, 11:11 am
accounts not showing on start page December 6, 2007, 3:03 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap