Reconcile beginning balance does not match the previous ending balance

When you open the Begin Reconciliation window and select an account to reconcile, the opening balance displayed does not match the ending balance from your previous reconciliation.

This issue can occur for several reasons:

• If this is the first time you are reconciling this account, either no balance was entered or an incorrect balance was entered. You need to correct the opening balance for the account.
   
• You may have voided, deleted, or changed the amount of a previously cleared transaction since your last reconciliation. You need to correct the edited transactions and reconcile them.
   
• Occasionally, the company data file may be damaged (this is not common). Run the Rebuild Data utility to correct the damage to data. You may need to troubleshoot for damaged transactions.
   

Solution 1: Correct the opening balance.

If this is the first time you are reconciling this account, refer to these resources:

• Enter the opening balance for the account
• Change the opening balance for an account in use
   

Solution 2: Correct an edited, voided,  or deleted previously cleared transaction

Run a Reconcile Discrepancy report:

1. From the Reports menu choose Banking.
2. Select Reconciliation Discrepancy.
3. Select the appropriate account and click OK.
    
4. Use this list of transactions to identify the transaction(s) causing the problem.
   Note: This report provides a list of transactions that were changed since the last reconciliation.
5. If you find a discrepancy, note both dates:
   • The transaction date tells QuickBooks when the transaction occurred.
   • The Entered/Last Modified date tells you when the change occurred.

Run a Previous Reconciliation report:

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

To correct the discrepancy, you may need to:

• Enter missing transactions.
• Edit existing transactions.
• Undo a previous reconciliation and redo it.
• Ignore the discrepancy and let QuickBooks enter an offsetting adjustment.
• Contact your financial institution about a banking error.
   

Solution 3: If you have previously reconciled without problems and have not made change previously cleared transactions, troubleshoot for damage with the Verify and Rebuild utilities.

1. Run the Rebuild Data Utility.
2. Run the Verify Data Utility.
3. If the issue persists, troubleshoot and fix any damaged transactions

If these solutions do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free, or you can contact a technical support agent for additional guidance. Fees may apply.