Bank reconciliation Problem; last month's ending balance doesn't match beginning balance

jmfstone
jmfstone Quicken Windows Subscription Member ✭✭
I reconciled last month's bank balance before Quicken went bonkers. My ending balance was X, but when I tried to reconcile this month the beginning balance was X+ exactly $2000.

Quicken support had me revalidate my database. Something occurred during that process that changed my ending balance from last month and increased it by $2000 to the penny. So when trying to reconcile this month's statement the beginning balance was $2000 higher than last month's reconciled ending balance.

Where do I begin to search and how do I fix?

Best Answer

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓
    If the beginning balance of the reconcile is changing from what they were, it is because the Reconciled transactions have changed.

    The opening balance of the reconcile is the sum total of all of the R transactions in the register and is calculated at the time of reconciliation and not stored for future reference.

    What could change that # is one of the following:
    1. a blank or C was changed to a R
    2. an R was changed to a blank or C
    3. the amount of an R was changed
    4. a new transaction was marked R to begin with
    5. a R transaction was deleted

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

Answers

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓
    If the beginning balance of the reconcile is changing from what they were, it is because the Reconciled transactions have changed.

    The opening balance of the reconcile is the sum total of all of the R transactions in the register and is calculated at the time of reconciliation and not stored for future reference.

    What could change that # is one of the following:
    1. a blank or C was changed to a R
    2. an R was changed to a blank or C
    3. the amount of an R was changed
    4. a new transaction was marked R to begin with
    5. a R transaction was deleted

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Please clarify the problem. 
    Did you contact Quicken Support because there was an account balance issue? 
    Or did the balance issue only occur after contacting Quicken Support and running Validate & Repair?  And if this accurately describes the situation, then why did you feel the need to contact Quicken Support to begin with?  Was there some other issue that you wanted Quicken Support to help resolve and what was that problem?
    One of the first things an exact $2000 balance increase issue would cause me to do is to sort the Deposit column of the account register by clicking on the Deposit column header.  Then scroll through the register looking for a $2000 deposit transaction.  If not found, then I'd look for multiple transactions of even amounts that total up to $2000 (ex, two $1000 transactions, four $500 transactions, eight $250 transactions, etc.)  I have used this process to identify account balance issues in the past.  Maybe it will help you, too.

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11

  • jmfstone
    jmfstone Quicken Windows Subscription Member ✭✭
    Thank you. Yes, I contacted Quicken support due to the Schwab download issues. I have run scans on all $2000 transactions. I will see what happens when my next reconciliation takes place.
This discussion has been closed.