Skip to main content
March 26, 2024
Question

My ending balance reconciliation is different than my starting balance now. I have deleted entries that are changing the balance. How do I fix this?

  • March 26, 2024
  • 1 reply
  • 0 views
My ending balance in December of 2022 was correct and reconciled to my bank statement.  The beginning balance now is out of balance creating a discrepancy.  I deleted transactions that were duplicates, but now I cannot get them corrected.  It's a beginning balance discrepancy.  How do I fix this?

1 reply

March 26, 2024

I've noticed that you're encountering a beginning balance discrepancy, Tom. Let me provide some guidelines on how to fix this issue for the accounts you've reconciled in the past in QuickBooks Online (QBO). 

 

Every time you reconcile your accounts, you'll have to review the beginning balance, which is the amount in the account at the start of the period you're reviewing and should match the bank statement. 

 

Since you're having this discrepancy in the beginning balance, this may be due to various reasons. Here are the common causes of these discrepancies: 

 

  • Incorrect entry of the opening balance during the account setup in QuickBooks.
  • Addition of transactions older than the opening balance without updating the original entry to reflect the changes.
  • Modification, deletion, relocation, or undoing of a previously reconciled transaction alters the ending balance of the last reconciliation and affects the subsequent starting balance.
  • Manual reconciliation of a transaction leads to discrepancies in the following reconciliation process.

 

To fix this, review whether the original opening balance is correct before checking your beginning balance. Then, check your bank statement and ensure you're reconciling the correct account for the exact period. Here's how:

 

  1. Go to Transactions, then select Reconcile.
  2. Select the account that you want to reconcile from the Account ▼ dropdown.
  3. If your account is connected to online banking, match and categorize all downloaded transactions before you start reconciling to get the final correct beginning balance.

 

Afterward, review any discrepancy reports to identify changes affecting the beginning balance. You'll get a message before you start reconciling. 

 

  1. Click the We can help you fix it hyperlink to access the discrepancy report.
  2. Review the discrepancy report to determine necessary corrections.


Once you know you need to make corrections, review each transaction in the report one at a time:

 

  1. Select View to see the history of changes to the transaction.
  2. Review the Change Type column.
  3. Make edits based on the status in the Change Type column.


For more details on how to make edits based on the Changed type, please refer to Step 4 of this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

In addition, I'm adding some articles that can help you in the future with other reconciliation issues and related tasks:

 

 

By following these steps and referring to the articles provided, you should be able to rectify the discrepancies in your reconciliation. 

 

If you have any further queries about reconciling your accounts in QuickBooks, feel free to post or comment here in the forum. I'll be happy to assist you! Have a great day!