How to Fix Beginning Balance Issues While Reconciling in QuickBooks Desktop and Online?

When the QuickBooks beginning balance does not match the ending balance from your previous reconciliation, you can see a discrepancy that prevents you from reconciling the account correctly. This issue can occur in both QuickBooks Desktop and QuickBooks Online when a previously reconciled transaction is edited, deleted, voided, unreconciled, or affected by an incorrect adjustment.

If you do not correct the underlying issue, the beginning balance can remain out of balance and your QuickBooks records may not match your bank statement. The steps for investigating the discrepancy vary between QuickBooks Desktop and QuickBooks Online, so you should follow the workflow for your version.

In this guide, we’ll discuss why a QuickBooks reconciliation discrepancy occurs, how to check the previous reconciliation, find changed transactions, fix reconciliation discrepancies, and prevent future problems.

What Is the Beginning Balance in QuickBooks Reconciliation?

The beginning balance in QuickBooks reconciliation is the balance carried forward from the end of the previous reconciliation period. QuickBooks uses this amount as the starting point when you reconcile the account against a new bank statement. It is the balance after the last reconciliation, and it allows QuickBooks to know the difference in the current period.

The beginning balance should normally match the ending balance from the previous reconciliation. When it does not, QuickBooks can indicate a reconciliation discrepancy and will not allow the account to balance. Editing or deleting a reconciled transaction, changing its reconciliation status, or entering an incorrect adjustment can change the account history and cause the beginning balance to become incorrect.

Why Is My Beginning Balance Incorrect in QuickBooks?

A beginning balance discrepancy usually means something changed in the account after a previous reconciliation. The specific cause can vary depending on whether you use QuickBooks Desktop or QuickBooks Online. Here are the common causes of the beginning balance discrepancy in QuickBooks.

• Previously Reconciled Transactions Were Changed or Removed
• The Account Started With an Incorrect Opening Balance
• Transactions Were Manually Marked as Reconciled
• An Improper Reconciliation Adjustment Was Added
• Company File Conversion Affected Historical Data
• Duplicate or Incorrect Transactions Changed the Account Balance

How to Check the Previous Reconciliation in QuickBooks Desktop & Online?

Before changing any transaction, review the previous reconciliation and compare its ending balance with the current beginning balance. The process differs between QuickBooks Desktop and QuickBooks Online.

QuickBooks Desktop

You can check a previous reconciliation in QuickBooks Desktop by opening Reports > Banking > Previous Reconciliation and selecting the account and statement ending date. Here are the steps to check the previous reconciliation in QuickBooks Desktop:

• Go to Reports from the top menu.
• Select Banking, then click Previous Reconciliation.
• Choose the required bank account from the Account drop-down menu.
• Select the reconciliation period under Statement Ending Date.
• Choose Detailed, Summary, or Both, depending on the information you need.
• Select whether you want to view transactions cleared at the time of reconciliation or transactions cleared at that time plus changes made later.
• Click Display to view the report.
• Use the Print option if you need a physical or PDF copy through your system’s print options.

QuickBooks Online

QuickBooks Online provides reconciliation history and a Reconciliation Discrepancy Report to help identify changes affecting the beginning balance.

1. Go to All apps.
2. Select Accounting.
3. Select Reconcile.
4. Select the account you are trying to reconcile.
5. Review the beginning balance and any discrepancy alert.
6. Select We can help you fix it when QuickBooks displays a beginning balance warning.

How to Find Transactions That Changed After Reconciliation in QuickBooks Desktop & Online?

Before changing any transaction, review the previous reconciliation and compare its ending balance with the current beginning balance. The process differs between QuickBooks Desktop and QuickBooks Online.

QuickBooks Desktop 

Here are the methods to find transactions that changed after reconciliation in QuickBooks Desktop.

Method 1. Using the Reconciliation Discrepancy Report

1. Go to Reports. 
2. Hover over Banking and select Reconciliation Discrepancy. 
3. Select the bank account you are reconciling and click OK. 
4. Review the report for transactions changed since the previous reconciliation. 
5. Compare the listed transactions with your previous reconciliation report and bank statement. 
6. Investigate each discrepancy and correct the transaction when necessary.

Method 2. Using a Transaction Detail Report

1. Go to Reports > Custom Reports > Transaction Detail. 
2. Open the Display tab. 
3. Set the Date From to the earliest date for the account, or leave it blank. 
4. Set Date To to the date of your last reconciliation. 
5. Open the Filters tab. 
6. In Account, select the account you are reconciling. 
7. Under Entered/Last Modified, set Date From to the date of your last reconciliation and Date To to today’s date. 
8. Click OK to run the report. 
9. Review the results for transactions that changed and compare them with your bank statement and previous reconciliation records

QuickBooks Online

QuickBooks Online provides a Reconciliation Discrepancy Report to help you identify changes that caused your beginning balance to differ from the ending balance of your previous reconciliation.

1. Go to All apps > Accounting > Reconcile.
2. Select the account you want to reconcile from the account drop-down.
3. Check the beginning balance. If it does not match the ending balance of the previous reconciliation, QuickBooks displays an alert stating that your account is not ready to reconcile and that the beginning balance is off.
4. Select We can help you fix it in the alert.
5. Review the Reconciliation Discrepancy Report to see what changed, when the change occurred, and how it affected your balance.
6. Select Review in tray to examine the details of a listed transaction. You can also select View History to review its complete transaction history.

How to Fix Beginning Balance Issues in QuickBooks Desktop?

To resolve a beginning balance problem in QuickBooks Desktop, you must determine what was changed in your account history and then fix the original transaction, opening balance, or reconciliation. Here are the proven methods to fix beginning balance issues in QuickBooks Desktop.

Method 1: Correct a Zero Opening Balance

If this is the first time you are reconciling the account and QuickBooks shows a zero beginning balance, you can recreate the opening balance with a journal entry. Intuit recommends using the correct date and amount that should appear in the Begin Reconciliation window.

QuickBooks Online

1. Go to All apps > Accounting > Chart of accounts.
2. Find the affected bank or credit card account.
3. Select View Register.
4. Find the Opening Balance entry. It should show Opening Balance Equity in the Account column.
5. Note the opening balance date and amount.
6. Compare the amount with the balance on your bank or credit card statement for the same date.
7. If the amounts do not match, select the opening balance entry to expand it.
8. In the Deposit column, edit the amount so it matches your bank records.
9. Select Save.
10. Return to All apps > Accounting > Reconcile and verify that the beginning balance is now correct.

Note: If you forgot to enter an opening balance when you created the account, QuickBooks Online allows you to add one later through a journal entry.

QuickBooks Desktop

1. Go to Company > Make General Journal Entries. 
2. Set the date to the correct statement date for the opening balance. 
3. Select the appropriate account from the Account drop-down. 
4. Enter the correct opening balance in the Debit column. 
5. On the next line, select Opening Balance Equity. 
6. Select Save. 
7. Go to Banking > Reconcile. 
8. Select the same account. 
9. Enter the statement date and ending balance that correspond to the journal entry. 
10. Select Continue. 
11. Under Deposits and Other Credits, select the journal entry. 
12. Confirm that the Difference is zero, then select Reconcile Now.

Method 2: Find and Correct Transactions Changed After Reconciliation

A previously reconciled transaction can cause a beginning balance discrepancy if it was edited, deleted, voided, or changed from reconciled to uncleared after the previous reconciliation.

QuickBooks Online

Use the Reconciliation Discrepancy Report to identify changes that affected the beginning balance.

1. Go to All apps > Accounting > Reconcile.
2. Select the affected account.
3. Review the beginning balance discrepancy.
4. Select We can help you fix it when the beginning balance warning appears.
5. Review the transactions listed in the Reconciliation Discrepancy Report.
6. Select Review in tray to examine a listed transaction.
7. Select View History when you need to review the transaction’s history.
8. Compare the current transaction details with the previous reconciliation and bank statement.
9. Correct the transaction only if you confirm that the current information is incorrect.

QuickBooks Desktop

Use the Reconciliation Discrepancy Report to identify transactions that changed after the previous reconciliation.

1. Go to Reports > Banking > Reconciliation Discrepancy.
2. Select the affected account.
3. Select OK.
4. Review the transactions listed in the report.
5. Compare them with the previous reconciliation report and bank statement.
6. Review the transaction details and modification information.
7. Correct the transaction only after confirming that the change was incorrect.

Do not automatically reverse every transaction identified by these reports. Some changes may have been intentional. Correct only the transaction or adjustment that does not agree with your accounting records.

Method 3: Review Previous Reconciliation Records

Reviewing the previous reconciliation helps you confirm what the beginning balance should be and determine whether the discrepancy developed after the previous reconciliation.

QuickBooks Online

1. Go to All apps > Accounting > Reconcile.
2. Select History by account.
3. Select the affected account.
4. Choose the relevant reconciliation period.
5. Open the available reconciliation report.
6. Compare the previous reconciliation’s ending balance with the current beginning balance.
7. Review the transaction details for items that may have changed after the reconciliation.

Use the reconciliation history as a reference when investigating the discrepancy. If the previous reconciliation was correct but the current beginning balance has changed, investigate transactions modified after that reconciliation.

QuickBooks Desktop

1. Go to Reports > Banking > Previous Reconciliation.
2. Select the affected account.
3. Choose the appropriate Statement Ending Date.
4. Select Detailed or Both.
5. Select the option to include transactions cleared plus changes made after the reconciliation, when available.
6. Select Display.
7. Compare the report with the corresponding bank statement and current reconciliation.

The Previous Reconciliation report helps you compare the account’s historical reconciliation with its current transaction status.

Method 4: Unreconcile an Incorrectly Reconciled Transaction in QuickBooks Online

If you confirm that an individual transaction was reconciled by mistake, you can change its reconciliation status without undoing the entire reconciliation.

1. Go to All apps > Accounting > Chart of accounts.
2. Find the affected account.
3. Select View register.
4. Locate the transaction marked R.
5. Select the transaction to expand its details.
6. Select the R status until it changes to blank.
7. Select Save.
8. Include the transaction in the appropriate reconciliation when you reconcile the account again.

QuickBooks Online uses R to indicate a reconciled transaction, C for a cleared transaction, and a blank status for an uncleared transaction.

Only change the reconciliation status after confirming that the transaction was reconciled incorrectly. Unreconciling a valid transaction can create another discrepancy.

Method 5: Review Audit History for Changed Transactions

If the reconciliation reports do not fully explain the discrepancy, review transaction history to identify changes made after the previous reconciliation.

QuickBooks Online

1. Go to Settings > Audit log.
2. Set the relevant date range.
3. Review changes to transactions associated with the affected account.
4. Look for deleted, voided, or modified transactions.
5. Compare the changes with your previous reconciliation and bank statement.
6. Correct a transaction only when your accounting records show that the change was incorrect.

The Audit Log can be particularly useful when a deleted or voided transaction does not fully explain the discrepancy shown in the Reconciliation Discrepancy Report.

QuickBooks Desktop

1. Go to Reports > Accountant & Taxes > Audit Trail.
2. Customize the report.
3. Apply the Account filter for the affected account.
4. Set the appropriate transaction date range.
5. Review the Entered/Modified information.
6. Identify transactions changed after the previous reconciliation.
7. Compare the changes with your bank statement and reconciliation records.

The Audit Trail can help you identify historical changes when the Reconciliation Discrepancy Report does not fully explain the beginning balance difference.

Method 6: Review Existing Reconciliation Adjustments

A previous reconciliation adjustment can affect your account balance. Before entering another adjustment, review existing adjustments and determine why they were created.

QuickBooks Desktop

QuickBooks Desktop can record reconciliation adjustments in the Reconciliation Discrepancies account.

1. Open the Chart of Accounts.
2. Locate the Reconciliation Discrepancies account.
3. Review entries for the affected reconciliation period.
4. Compare each adjustment with the bank statement and reconciliation report.
5. Determine whether the adjustment represents a valid accounting correction.
6. Correct an inaccurate adjustment only when your accounting records support the change.

You can also use the Find feature to locate balance adjustments by searching for Balance Adjustment in the Memo field.

QuickBooks Online

If the discrepancy involves an existing accounting entry or adjustment, review the affected transaction and its history to determine why it was created and how it affected the account balance.

Do not assume that creating another adjustment is the correct solution. If the adjustment relates to a prior accounting period or financial statement, consult your accountant before making changes.

Important: Do not create a new reconciliation adjustment simply to force the difference to zero. An adjustment can hide the original problem instead of correcting it.

Method 7: Check the Reconciliation Statement Dates

Before changing transactions, verify that the reconciliation periods and statement dates are correct. An incorrect statement ending date can cause transactions to fall into the wrong reconciliation period.

In both QuickBooks Desktop and QuickBooks Online, check that:

• The current statement ending date matches your bank statement.
• The previous reconciliation used the correct statement ending date.
• You are reconciling statements in chronological order.
• You did not reconcile a later statement before an earlier statement.
• The current beginning balance matches the previous reconciliation’s ending balance.

If a previous reconciliation used an incorrect statement date, identify the affected reconciliation and correct it using the appropriate workflow for your QuickBooks version.

Method 8: Undo and Redo the Reconciliation in QuickBooks Desktop

If you cannot identify or safely correct the discrepancy at the transaction level, you may need to undo the previous reconciliation in QuickBooks Desktop.

Before making historical changes, create a backup of your QuickBooks company file.

1. Go to Banking > Reconcile.
2. Select Undo Last Reconciliation.
3. Select Continue, then OK when prompted.
4. Close the reconciliation window.
5. Open the reconciliation window again.
6. Correct the underlying transaction, statement date, or other issue.
7. Reconcile the account again using the correct statement information.

If the discrepancy originated several reconciliations ago, you may need to work backward through previous reconciliations until you reach the period where the beginning balance first became incorrect.

Method 9: Undo a Reconciliation in QuickBooks Online

If correcting an individual transaction does not resolve the problem, you may need to undo the affected reconciliation in QuickBooks Online.

The Primary Admin, in-house accountant, or accountant user with the required access can undo a reconciliation in QuickBooks Online.

Before undoing a reconciliation, save any reconciliation reports and supporting documents you need. QuickBooks Online permanently deletes the reconciliation report and its attachments when you undo that reconciliation.

1. Go to All apps > Accounting > Reconcile.
2. Select History by account.
3. Select the affected account.
4. Choose the appropriate date range.
5. Find the reconciliation you need to undo.
6. In the Action column, select the dropdown.
7. Select Undo.
8. Review the warning.
9. Select Undo reconciliation to confirm.

Undoing a reconciliation also undoes reconciliations completed after the selected reconciliation. Reconciled transactions revert to cleared or uncleared status, and the beginning balance is based on the reconciliation immediately preceding the one you undo.

If the discrepancy involves multiple historical periods or affects financial statements that have already been filed or reported, consult your accountant before undoing the reconciliation.

Method 10: Reconcile the Account Again

After correcting the source of the discrepancy, return to the reconciliation screen and verify the beginning balance before completing the reconciliation.

1. Confirm that the beginning balance matches the previous reconciliation’s ending balance.
2. Enter the correct statement ending date.
3. Enter the ending balance shown on your bank statement.
4. Review the transactions that cleared during the statement period.
5. Confirm that the Difference is $0.00.
6. Complete the reconciliation.

What to Do If the Beginning Balance Is Still Incorrect in QuickBooks?

If the QuickBooks beginning balance is still incorrect after reviewing the reconciliation discrepancy, continue investigating changes made to previously reconciled transactions and compare the current account history with earlier reconciliation records. The troubleshooting steps differ between QuickBooks Online and QuickBooks Desktop.

Identify What Changed

QuickBooks Online

1. Go to All apps > Accounting > Reconcile.
2. Select the affected account.
3. Review the beginning balance discrepancy.
4. Select We can help you fix it if QuickBooks displays a beginning balance warning.
5. Review the transactions listed in the Reconciliation Discrepancy Report.
6. Select Review in tray to examine a transaction.
7. Select View History to review changes made to the transaction.
8. Compare the current transaction details with the previous reconciliation and bank statement.
9. If the discrepancy is not explained by the report, go to Settings > Audit Log and review relevant transaction changes.

QuickBooks Desktop

1. Go to Reports > Banking > Reconciliation Discrepancy.
2. Select the affected account and click OK.
3. Review the transactions listed in the report.
4. Check the transaction details and modification information.
5. Compare the transactions with the previous reconciliation report and corresponding bank statement.
6. Review the Audit Trail under Reports > Accountant & Taxes > Audit Trail to investigate changes made to affected transactions.

Correct the Source of the Discrepancy

Open the affected transaction and correct it only when your review confirms that its current details do not match your bank statement or accounting records.

Before changing a previously reconciled transaction, confirm that the correction is necessary. Some changes may have been intentional, and changing a reconciled transaction can affect subsequent reconciliation periods.

If you are unsure whether a historical transaction should be changed, consult your accountant before making the correction.

Undo and Redo the Reconciliation When Necessary

If you cannot resolve the discrepancy by correcting the underlying transaction, you may need to undo the affected reconciliation. The process differs between QuickBooks Desktop and QuickBooks Online.

QuickBooks Desktop

Before making historical changes, create a backup of your company file.

1. Go to Banking > Reconcile.
2. Select Undo Last Reconciliation.
3. Select Continue, then OK.
4. Close the reconciliation window.
5. Open the reconciliation window again.
6. Correct the underlying transaction, statement date, or other issue.
7. Reconcile the account again using the correct statement information.

If the discrepancy originated several reconciliations ago, you may need to work backward through previous reconciliations until you reach the period where the beginning balance first became incorrect.

QuickBooks Online

The Primary Admin, in-house accountant, or an accountant user with the required access may need to undo the affected reconciliation if correcting an individual transaction does not resolve the discrepancy.

1. Go to All apps > Accounting > Reconcile.
2. Select History by account.
3. Select the affected account.
4. Choose the appropriate date range.
5. Find the reconciliation you need to undo.
6. In the Action column, select the dropdown.
7. Select Undo.
8. Review the warning.
9. Select Undo reconciliation to confirm.

Undoing a reconciliation in QuickBooks Online also undoes reconciliations completed after the selected reconciliation. Reconciled transactions revert to cleared or uncleared status.

How to Prevent Beginning Balance Issues in QuickBooks

You can reduce future reconciliation discrepancies by protecting completed accounting periods and reviewing changes before they affect historical balances. Here are the best ways to prevent the beginning balance discrepancy in QuickBooks:

• Set a closing date and password to protect completed accounting periods.
• Enter accurate opening balances when creating new accounts.
• Review Previous Reconciliation reports after each reconciliation.
• Avoid changing reconciled transactions without verifying the correction.
• Back up your QuickBooks company file before changing historical data.

Conclusion

You can fix beginning balance issues in QuickBooks Desktop and QuickBooks Online by identifying changes to previously reconciled transactions, correcting inaccurate opening balances, reviewing reconciliation history, checking deleted or voided transactions, and addressing incorrect reconciliation adjustments. If the discrepancy comes from a previous reconciliation, review the affected period before undoing and redoing the reconciliation.

The key is to correct the transaction or reconciliation that caused the discrepancy instead of simply forcing the account to balance with an adjustment. Once the beginning balance matches the previous reconciliation’s ending balance, you can proceed with the current bank reconciliation.

Frequently Asked Questions