Solved

Why does QuickBooks Online show the wrong last reconciliation date when my history shows completed reconciliations?

Forum|Forum|4 years ago
February 15, 2022
5 replies
35 views

My bank account is reconciled through August 2021. I was out sick and couldn't reconcile the last 4 months of the year until this month. However, when I click register, it says the last date reconciled is "date ending 12/31/2020". BUT the history shows the reconciliations complete through August 2021. Any ideas how to fix this? I'm not planning to re-reconcile everything because the history shows the account is mostly reconciled - so somewhere the system knows it was completed (plus the 'un-reconciliaiton nightmare' we all know about).

To recap: account reconciled through August 2021. History confirms reconciliations complete. When attempting to reconcile the rest of the year, the system says last reconciliation was 12/31/2020.

Thanks in advance.

QuickBooks Online

Best answer by sofiamdc-2341

When QuickBooks Online shows a beginning date that's earlier than what your history records, it usually means something changed in one of those completed reconciliation periods (such as a transaction being edited, deleted, or unreconciled) that caused the system to revert to the last clean balance. The fix is to find the change using the Reconcile Discrepancy Report, correct it, and then continue reconciling from where you left off.

Step 1: Check the Reconcile Discrepancy Report

This report is the fastest way to find out exactly what changed and when.

Go to All apps, then Accounting, then Reconcile.
Select your bank account from the dropdown.
If your beginning balance is showing an earlier date than expected, you'll see an alert: "Your account isn't ready to reconcile yet. Your beginning balance is off by..."
Select We can help you fix it to open the Reconcile Discrepancy Report.
Check the What happened column for each flagged transaction; it will show whether a transaction was deleted, edited, or voided, and who made the change.
Select Review in tray to see the full details, or select View History for a complete audit trail.
Follow the suggested correction for each item, or make your own based on your records.

Make a note of the exact dollar amount your balance is off by before you start, as the changes you find should add up to that amount.

Step 2: Check for deleted or voided transactions in the audit log

Some changes, specifically deleted or voided transactions, won't appear in the Reconcile Discrepancy Report. To catch those:

Go to Settings, then Audit log.
Filter by the bank account and the time period since your last completed reconciliation.
Look for any transactions that were deleted or voided during that window.
If you find one, re-enter it with the correct details and mark it as reconciled in the account register by clicking the checkmark column until it shows an R.

Step 3: Check for manually reconciled transactions

A transaction reconciled directly in the register, outside of a normal reconciliation workflow, can also shift your beginning balance without appearing in the discrepancy report. To check:

Go to All apps, then Accounting, then Chart of accounts.
Find your bank account and select View register.
Filter by Reconcile status and look for any transaction marked R that falls after the date of your last completed reconciliation.
If you find one that shouldn't be there, change its status back to uncleared and reconcile it through the normal reconciliation process instead.

If the discrepancy report shows nothing, try clearing your browser cache

If the report is clean and your beginning balance still looks right in history but QuickBooks is displaying the wrong starting date, this can sometimes be a browser display issue. Try opening QuickBooks Online in an incognito or private browser window. If the correct date appears there, the problem is with your browser's cached data.

To fix it in your regular browser, clear your cache and Intuit-specific cookies. QuickBooks Online provides step-by-step instructions for each supported browser in their help article: Clear cache and cookies to fix issues when using QuickBooks Online.

For a full walkthrough of fixing beginning balance issues in QuickBooks Online, see: Fix beginning balance issues when reconciling in QuickBooks Online.

If you're still seeing the wrong date after working through these steps, share more details about what the discrepancy report shows and we'll help you dig into it further.

K

Kurt_M

QuickBooks Team

I appreciate you for reaching out here in the Community, @Megaec12. I'll share some insights about your concern along with the steps on how to fix it.

There are possible reasons why this occurs, it could be because of the amount of a transaction changed, or Someone unreconciled a transaction in the register, it could also be that someone added a transaction to a past reconciliation, usually this is by accident, and then lastly is that someone deletes a transaction, and that can really affect your reconciliation.

To fix this, we'll have to do these:

Review the original opening balance.
Check your bank statement.
Match and categorize downloaded transactions.
Review any discrepancy reports.

In reviewing the original opening balance, always know that the opening balance is the starting point for accounts in QuickBooks. If this is incorrect, this will affect all the following reconciliations.

You'll want to make sure your opening balance is correct before you go to check your beginning balance.

To check your bank statement, here's how:

In QuickBooks online, go to the Accounting menu and then select Reconcile.
Review the account you selected in the Account dropdown menu.

Make sure you're reconciling the correct account if you have multiple accounts at the same bank or many accounts of the same type. Once done, we can now proceed to categorizing and matching downloaded transactions.

Before you begin reconciling, match and categorize all of your downloaded transactions if your account is connected to online banking. To get your final correct beginning balance, you need categorize everything.

You'll then want to review any discrepancy reports. To begin, these are the steps:

Click the Gear icon and then under the Tools column, select Reconcile.
You'll then see an alert if you have a problem with your opening balance.
Select the hyper link We can help you fix it. to look at your discrepancy report.
Under the column CHANGE TYPE, you'll find some information that will let you know how to solve your problem.

Once you've determined that your beginning balance is correct, you can proceed to start the reconciliation. In case you see any issues along way of your reconciliation, you can visit this page to know what you should review.

You might also want to give this article a visit, this contains an instructional video of how to fix issues for accounts you've reconciled in the past in QuickBooks Online (QBO).Additionally, I'll be adding these articles to help you in the future:

Don't hesitate to get back to me if you have further clarifications about this. I'll be more than happy to provide additional assistance. Keep safe!

M

Megaec12Author

Thank you for your reply, but it did not answer my question. All of the reconciliations from Jan thru August 2021 are correct, and in the history. There are no discrepancies or issues with the previously completed reconciliations. The dates, beginning and ending balances are all fine, as are the transactions (presumably because there are no reports or errors, corrections, etc...). So, the previous reconciliations seem clean and proper.

However, when I try to reconcile the September 2021 statement, the system is pre-populating the last date of reconciliation as the last statement for December 2020. This is despite the fact that the previous clean reconciliations for 2021 are present in the history.

MarsStephanieL

Level 6

Thank you for giving us an update on your concern, @Megaec12. Allow me to share more details on how to troubleshoot this error.

Since you've confirmed that the possible reasons stated by my colleague are not applicable, we may proceed with troubleshooting the browser. There are times that the program will react abnormally because of outdated data.

You can start with using an incognito browser to check if this is a data-related issue. If it shows the correct date while using an incognito, you can go back to the regular browser and clear the cache to avoid getting the same issue in the future.

Then, try to check if the last reconciliation date pop-up is still on December 2020. If that's so use another browser. To know the supported browser, you can check out this article: Clear cache and cookies to fix issues when using QuickBooks Online.

Then, you can proceed to the reconciliation process if it's all good. If not, I'd recommend contacting our Customer Care Team to have a better look at the issue. They also have the tools to verify your account and further check on the issue with their designated tools.

I've got your back if you have any questions about QuickBooks Online. Just comment back so I can assist you further. Take care.

sofiamdc-2341

Answer

Community Manager

When QuickBooks Online shows a beginning date that's earlier than what your history records, it usually means something changed in one of those completed reconciliation periods (such as a transaction being edited, deleted, or unreconciled) that caused the system to revert to the last clean balance. The fix is to find the change using the Reconcile Discrepancy Report, correct it, and then continue reconciling from where you left off.

Step 1: Check the Reconcile Discrepancy Report

This report is the fastest way to find out exactly what changed and when.

Go to All apps, then Accounting, then Reconcile.
Select your bank account from the dropdown.
If your beginning balance is showing an earlier date than expected, you'll see an alert: "Your account isn't ready to reconcile yet. Your beginning balance is off by..."
Select We can help you fix it to open the Reconcile Discrepancy Report.
Check the What happened column for each flagged transaction; it will show whether a transaction was deleted, edited, or voided, and who made the change.
Select Review in tray to see the full details, or select View History for a complete audit trail.
Follow the suggested correction for each item, or make your own based on your records.

Make a note of the exact dollar amount your balance is off by before you start, as the changes you find should add up to that amount.

Step 2: Check for deleted or voided transactions in the audit log

Some changes, specifically deleted or voided transactions, won't appear in the Reconcile Discrepancy Report. To catch those:

Go to Settings, then Audit log.
Filter by the bank account and the time period since your last completed reconciliation.
Look for any transactions that were deleted or voided during that window.
If you find one, re-enter it with the correct details and mark it as reconciled in the account register by clicking the checkmark column until it shows an R.

Step 3: Check for manually reconciled transactions

A transaction reconciled directly in the register, outside of a normal reconciliation workflow, can also shift your beginning balance without appearing in the discrepancy report. To check:

Go to All apps, then Accounting, then Chart of accounts.
Find your bank account and select View register.
Filter by Reconcile status and look for any transaction marked R that falls after the date of your last completed reconciliation.
If you find one that shouldn't be there, change its status back to uncleared and reconcile it through the normal reconciliation process instead.

If the discrepancy report shows nothing, try clearing your browser cache

If the report is clean and your beginning balance still looks right in history but QuickBooks is displaying the wrong starting date, this can sometimes be a browser display issue. Try opening QuickBooks Online in an incognito or private browser window. If the correct date appears there, the problem is with your browser's cached data.

To fix it in your regular browser, clear your cache and Intuit-specific cookies. QuickBooks Online provides step-by-step instructions for each supported browser in their help article: Clear cache and cookies to fix issues when using QuickBooks Online.

For a full walkthrough of fixing beginning balance issues in QuickBooks Online, see: Fix beginning balance issues when reconciling in QuickBooks Online.

If you're still seeing the wrong date after working through these steps, share more details about what the discrepancy report shows and we'll help you dig into it further.

Step 1: Check the Reconcile Discrepancy Report

Step 2: Check for deleted or voided transactions in the audit log

Step 3: Check for manually reconciled transactions

If the discrepancy report shows nothing, try clearing your browser cache

Step 1: Check the Reconcile Discrepancy Report

Step 2: Check for deleted or voided transactions in the audit log

Step 3: Check for manually reconciled transactions

If the discrepancy report shows nothing, try clearing your browser cache

Sign up

Login with SSO

Let's get you signed in

Login with SSO