Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
October 13, 2021
Question

How do I clear out an incorrect balance?

  • October 13, 2021
  • 2 replies
  • 49 views

I inherited an incorrect account balance and I don't know how to fix it. There are incorrect entries going back to last year. I want to clean out the account and make it the correct balance. 

 

Thanks!

2 replies

QuickBooks Team
October 13, 2021

Hello there, @Tayssoun

 

Welcome and thank you for posting here in the Community. I can help you fix this beginning balance. 

 

You can correct this bank balance by recreating the deleted, voided, or changed the amount of a previously cleared transaction that caused the discrepancy. 

 

To help you find these transactions, run the Reconcile Discrepancy report and Previous Reconciliation report

 

Run the Reconcile Discrepancy report:

  1. Go to the Reports menu and the Banking and select Reconciliation Discrepancy.
  2. Choose the account and click OK.
  3. Use this list of transactions to identify the transaction(s) causing the problem.
  4. If you find a discrepancy, take note of the date when the transaction occurred and the entered/last modified date when the change occurred.

This report provides a list of transaction changes since the last reconciliation.

 

Run a Previous Reconciliation report:

  1. Go to the Reports menu and the Banking and select Previous Reconciliation.
  2. Select the account, set the statement ending date, and click Display.
  3. Compare this report to past bank statements from your financial institution and look for differences.

Additionally, I recommend the following resource contains information to help a user fix the ending balance, as well as resolving data damage:

Let us know if there's anything that you need. We're always here to help you in reconciling your account. 

TayssounAuthor
October 18, 2021

HI,

Thank you but this doesn't help in this situation. These are accounts that haven't been reconcilled and it would take I don't know how long to go through all those. Someone posted one time about changing the date on a posted item thats wrong and then changing the date back. Im looking for something like that.

August 8, 2025

Thank you for joining the conversation and sharing your information, Virgie1.
 

Changing the last balance to reconcile your account is not advisable, as it could lead to inaccuracies in your financial records. Instead, it's better to review the transactions in the account to find any entries that might have been recorded incorrectly, duplicated, or missed. These discrepancies are typically the root cause of an incorrect balance.


I suggest reviewing your transactions in QuickBooks with your bank statement. It will help you identify errors and figure out what adjustments may be necessary. Once these discrepancies are resolved, your records will align with the bank's actual balance, which makes reconciliation much easier going forward.


Please note that altering the beginning balance or creating a manual adjustment will impact unreconciled transactions. It's essential to carefully review past transactions to ensure you don't accidentally duplicate or omit records. If this feels overwhelming, I recommend consulting an accountant to ensure all financial records remain accurate.


If you require further assistance, please feel free to reply here.