My Bank reconciliation is a mess. Starting balance from last month is off. Items reconciled last mo

sunflowerlise
sunflowerlise Quicken Canada Subscription Member ✭✭

I have the same problem as Pakchap from December 2025 and your replies were not helpful at all and now the discussion is closed???

My Bank reconciliation is a mess. Starting balance from last month is off.

Items reconciled last month are showing as unreconciled.

Transaction for current month are not showing in items to be reconciled.

And it only started in the last month or so. When I tried to reconcile month of Dec 9 to Jan 9th, the account was a mess already. I have verified double transactions and all and my account has never been sync'd to the cloud. I save everything on my desktop.

Is there something going on? I Update often, I am at version R65.20.

I always did reconciliation every month and it did balance and now it's a real mess.

[Removed - Personal Information]

Best Answers

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    Starting Balance in a reconciliation is the sum of ALL (past or future) transactions in the account that are marked with an "R" in the CLR column.

    SO, did you manually change any CLR value in the account for any transaction? OR, if a transaction was a transfer to another account in Q, did you change the CLR value of the other side of the transfer … which inappropriately changes the CLR value in both sides. OR did you delete, or manually add, an "R" transaction?

    OR, did you change the download method into the account? Say, from Direct Connect to Express Web Connect(+)? There's a long-standing bug in Q that can cause such actions to change the Opening Balance in the account … which is why it's suggested to record the correct Opening Balance in the Memo field of the OB transaction so if/when it happens it's easier to spot and to know what the correct amount should be.

    IF an OB amount change is the cause you can look back to prior months and see if the balance on the prior statement date matches between Q and your bank statements. If you go back several time periods (say 3 month jumps at a time) and many of them are off, suspect an OB change.

    What you can do to be certain is to restore from a backup created before the download change and see what the OB was at that time. It's possible that you'll have to open several backups before you find one with the correct amount (assuming, of course, that you don't simply have paper statements that go back far enough).

    IMPORTANT, when you restore such backups, don't "overwrite" your current production file. Use a name for the restored file that's somehow different from production.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • sunflowerlise
    sunflowerlise Quicken Canada Subscription Member ✭✭
    Answer ✓

    I did restore back up and at same date mess started and will now make sure that needs to be entered is entered with the help of my bank statements. It may take some time, but at least I will be able to reconcile my accounts, Yay!!! I do not know what happened that it became all messy, for some reason my account (in Quicken) had an opening balance of a minus amount in June 2018. And from there, it was not good.

    Thank you for your time.

    Lise G

Answers

  • sunflowerlise
    sunflowerlise Quicken Canada Subscription Member ✭✭

    Also my transactions that are to automatically go from one account to another are now being done. It is really frustrating.

  • sunflowerlise
    sunflowerlise Quicken Canada Subscription Member ✭✭

    not being done

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭
    Answer ✓

    Starting Balance in a reconciliation is the sum of ALL (past or future) transactions in the account that are marked with an "R" in the CLR column.

    SO, did you manually change any CLR value in the account for any transaction? OR, if a transaction was a transfer to another account in Q, did you change the CLR value of the other side of the transfer … which inappropriately changes the CLR value in both sides. OR did you delete, or manually add, an "R" transaction?

    OR, did you change the download method into the account? Say, from Direct Connect to Express Web Connect(+)? There's a long-standing bug in Q that can cause such actions to change the Opening Balance in the account … which is why it's suggested to record the correct Opening Balance in the Memo field of the OB transaction so if/when it happens it's easier to spot and to know what the correct amount should be.

    IF an OB amount change is the cause you can look back to prior months and see if the balance on the prior statement date matches between Q and your bank statements. If you go back several time periods (say 3 month jumps at a time) and many of them are off, suspect an OB change.

    What you can do to be certain is to restore from a backup created before the download change and see what the OB was at that time. It's possible that you'll have to open several backups before you find one with the correct amount (assuming, of course, that you don't simply have paper statements that go back far enough).

    IMPORTANT, when you restore such backups, don't "overwrite" your current production file. Use a name for the restored file that's somehow different from production.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • sunflowerlise
    sunflowerlise Quicken Canada Subscription Member ✭✭
    Answer ✓

    I did restore back up and at same date mess started and will now make sure that needs to be entered is entered with the help of my bank statements. It may take some time, but at least I will be able to reconcile my accounts, Yay!!! I do not know what happened that it became all messy, for some reason my account (in Quicken) had an opening balance of a minus amount in June 2018. And from there, it was not good.

    Thank you for your time.

    Lise G