reconcile not showing all transactions

Discussion in 'Quicken' started by EdStevens, Aug 13, 2008.

  1. EdStevens

    EdStevens Guest

    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?
     
    EdStevens, Aug 13, 2008
    #1
    1. Advertisements

  2. EdStevens

    John Pollard Guest

    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
     
    John Pollard, Aug 14, 2008
    #2
    1. Advertisements

  3. EdStevens

    EdStevens Guest

    On Aug 13, 6:18 pm, "John Pollard" <> 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?

    >
    > --
    >
    > 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 ....) :-(
     
    EdStevens, Aug 14, 2008
    #3
  4. EdStevens

    John Pollard Guest

    EdStevens wrote:
    > On Aug 13, 6:18 pm, "John Pollard" <>
    > 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
     
    John Pollard, Aug 14, 2008
    #4
  5. EdStevens

    EdStevens Guest

    On Aug 14, 8:07 am, "John Pollard" <> wrote:
    > EdStevens wrote:
    > > On Aug 13, 6:18 pm, "John Pollard" <>
    > > 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
     
    EdStevens, Aug 14, 2008
    #5
  6. EdStevens

    Ron Guest

    responding to
    http://www.beansmart.com/quicken/reconcile-not-showing-all-transactions-14961-.htm
    , Ron wrote:
    > invalid wrote:
    >
    >
    >
    > EdStevens wrote:
    > > On Aug 13, 6:18 pm, "John Pollard"

    > <>
    > > 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.
    >


    I know this is an old thread, but John, thank you so much. I was not aware
    that for electronic transactions, the posting date could be so far from the
    transaction date. I spent a lot of time trying to figure out why 2
    transactions were not showing up in the reconcile window. The information you
    gave was exactly what I needed to perfectly balance my account. Thanks again!
     
    Ron, Dec 8, 2012
    #6
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    2
    Views:
    798
  2. kimer in NH

    "Ref" column not showing all of Ref field

    kimer in NH, Sep 27, 2007, in forum: Quickbooks
    Replies:
    2
    Views:
    274
    kimer in NH
    Sep 28, 2007
  3. johndog
    Replies:
    7
    Views:
    355
    Keli''''i Martin
    Feb 3, 2007
  4. Sandac
    Replies:
    0
    Views:
    177
    Sandac
    Feb 19, 2007
  5. Sandac
    Replies:
    9
    Views:
    180
    Sandac
    Feb 21, 2007
Loading...

Share This Page