Updated
15 min read

QuickBooks Desktop reconciliation issues occur when account balances or transactions don’t match with your bank or credit card statements. Usually, an incorrect opening balance, modified transaction, or a missing entry leads a user to face beginning and ending balance issues in QuickBooks Desktop. The sooner you identify the discrepancy, the easier it is to correct it without creating further problems in your books.
Before changing any account records, identify what is causing the discrepancy. This guide covers the common causes of reconciliation errors and walks you through the steps to correct beginning and ending balance issues in QuickBooks Desktop.
Before troubleshooting these errors, it is important to understand what opening, beginning, and ending balances mean in QuickBooks Desktop. Although these terms are closely related, each serves a different purpose when tracking your account activity and reconciling transactions against a bank statement.
Note: If a previously reconciled transaction is modified, deleted, or unreconciled, the balance may no longer match the expected amount.
Once you understand which balance is causing the discrepancy, you can focus on the right transactions or account details instead of making unnecessary changes to your books.
Beginning and ending balance discrepancies in QuickBooks Desktop can occur for several reasons. Take a quick look and get this fixed:
| Common Causes | What Happens |
| Incorrect Opening Balance | An incorrect opening balance can cause the beginning balance to differ from the expected amount. |
| Modified Transactions | Editing the amount, date, or account of a previously reconciled transaction can affect the balance. |
| Deleted Transactions | Removing a previously cleared transaction can create discrepancies in subsequent reconciliations. |
| Unreconciled Transactions | Transactions marked as reconciled may become unreconciled, changing the beginning balance. |
| Duplicate Transactions | Recording the same transaction more than once can result in an incorrect account balance. |
Identifying what causes these issues is the first step toward keeping your records accurate. Now, let’s walk through the steps to fix beginning and ending balance issues in QuickBooks Desktop and get your reconciliation back on track.
Beginning balance errors in QuickBooks Desktop can disrupt reconciliation, even when your current transactions appear correct. These discrepancies often occur when a previously reconciled transaction is modified, deleted, or marked as unreconciled.
When you select an account and click Begin Reconciliation in QuickBooks Desktop, you may notice that the beginning balance is incorrect or shows $0.00. This usually indicates an issue with the account’s opening balance, changes to previously reconciled transactions, or inconsistencies in your company file.
To resolve beginning balance issues in QuickBooks Desktop, you first need to correct a zero balance and fix an incorrect amount. Follow the steps carefully:
A zero-beginning balance during the first reconciliation may indicate that the opening balance was not entered during account setup. Here’s how to recreate the opening balance by entering a new journal entry:
Follow these steps to record the opening balance using a journal entry:
Note: Use this method only when an opening balance entry is genuinely missing or incorrect.
After recording the journal entry, reconcile the account to verify that the beginning balance is correct. Follow these steps:
Note: Before completing the reconciliation, verify that the journal entry reflects the correct opening balance and that the selected transactions match your records.
If the beginning balance in QuickBooks Desktop is incorrect, review your account records to identify transactions that may have been changed, deleted, or incorrectly recorded. You can run the following reports to track down discrepancies and determine what caused the balance to change:
Reviewing these reports can help you pinpoint the source of the discrepancy before making any corrections to your account.
Note: the transaction date and the Entered/Last Modified details for each discrepancy. This information will help you determine when the changes occur and track the cause of the balance issue.
Note: Don’t forget to compare these entries with the reconciliation discrepancy and previous reports to identify changes that could explain the incorrect beginning balance.
QuickBooks Pro may only provide access to the most recent reconciliation report, so save older reports as PDFs for future reference.
Note: Compare the report with your previous bank statements to identify any discrepancies.
Now that you know how to troubleshoot zero and incorrect beginning balances in QuickBooks Desktop, let’s look at how to undo a previous reconciliation when necessary.
Let's Fix QuickBooks Desktop Balance Issues Together!
Don’t let balance discrepancies disrupt your accounting! Get expert assistance to identify and resolve beginning and ending balance issues in QuickBooks Desktop. Call us today!
Follow these steps to undo the most recent reconciliation in QuickBooks Desktop and redo it:
Note: Undoing a reconciliation can affect your previously reconciled transactions. Review your records carefully and ensure you have a backup before proceeding.
In some cases, you may choose to proceed with the discrepancy and let QuickBooks Desktop create an adjusting entry to balance the difference. However, this should be your last resort, as the adjustment may hide the underlying issue rather than fix it.
Despite trying the troubleshooting steps above, the beginning balance issue may persist. In that case, you can record an offsetting adjustment to finish the reconciliation.
To proceed, select Enter Adjustment when prompted. QuickBooks Desktop will create a journal entry to account for the difference and post it to the Reconciliation Discrepancies expense account. You can review the entry and make corrections through your Chart of Accounts if necessary.
If you need to locate the adjustment later, use either of the following methods.
Use this option only when you understand the reason for the difference and have determined that an adjustment is appropriate.
Note: Differences in reconciliation between QuickBooks Desktop for Mac and QuickBooks Online may cause transactions to become unreconciled, affecting your opening balance.
Correcting the beginning balance is an important part of resolving reconciliation issues, but it doesn’t guarantee that your account will match the bank statement. Even with an accurate beginning balance, missing transactions, or duplicate entries can cause the ending balance to remain incorrect. The next step is to review your account activity and identify what is preventing the ending balance from matching your bank statement.
An incorrect ending balance can prevent you from completing reconciliation, even when your beginning balance is accurate. The following steps will help you review your account activity, identify discrepancies, and correct the entries affecting your ending balance.
Before checking the ending balance, make sure your opening and beginning balances are correct. If you’ve already followed the steps mentioned above to correct your beginning balance, you can move ahead and review the transactions recorded in your QuickBooks company file.
Once you’ve verified the opening and beginning balances, review your transaction history for changes or missing entries. The following QuickBooks Desktop reports can help you identify discrepancies affecting the ending balance.
Note: A check listed in the report isn’t necessarily an error. Verify whether it cleared your bank before changing or removing the transaction.
Sometimes, users enter reconciliation adjustments to force the QuickBooks balance to match the bank statement. To check whether an adjustment is affecting your account balance, follow these steps:
Note: Avoid deleting or modifying reconciliation adjustments without understanding their impact on previously reconciled periods.
Once you’ve identified and corrected the discrepancies, return to the Reconcile window and try reconciling the account again. Make sure the statement ending date and ending balance match your bank statement and review the transactions you’ve marked as cleared. The Difference field should show $0.00 when all relevant transactions have been recorded and matched correctly.
If you still can’t identify the cause of the discrepancy, you may need to undo previous reconciliations until you reach the period where the beginning balance was accurate.
Correcting beginning and ending balance discrepancies can take some time, especially when the issue involves previously reconciled transactions or older account entries. To avoid running into similar problems in the future, let’s look at some practical tips to keep your records accurate and up to date.
Preventing reconciliation discrepancies starts with maintaining accurate account records and reviewing transactions regularly. Here are the tips:
Beginning and ending balance discrepancies in QuickBooks Desktop can disrupt your reconciliation and make it difficult to keep your financial records accurate. By identifying the cause, reviewing reconciliation reports, and correcting transactions carefully, you can resolve these issues without creating further inconsistencies.
If you need help troubleshooting persistent QuickBooks issues, contact our Certified QuickBooks ProAdvisors for expert assistance.
To fix the beginning balance discrepancy in QuickBooks Desktop, you can try running the Reconciliation Discrepancy, Audit Trail, and Previous Reconciliation reports to identify and correct changes to previously reconciled transactions. For a detailed, step-by-step resolution, refer to the sections covered in this blog.
To review transactions from an earlier reconciliation and identify possible discrepancies, follow these steps:
1. Open QuickBooks Desktop, go to Reports, and select Banking.
2. Choose Previous Reconciliation from the available report options.
3. Select the account you last reconciled.
4. Choose the most recent statement date you want to review.
5. Click Display to generate the report.
Compare the transactions in the report with your previous bank or credit card statements to identify any missing, modified, or incorrect entries.
Verify that the statement ending date and balance are entered correctly in QuickBooks Desktop. Then review your account records for missing, duplicate, or incorrectly entered transactions that may affect the total. You can also run the Missing Checks and Reconciliation Discrepancy reports to identify potential issues and investigate the differences.
The beginning balance in QuickBooks Desktop may not match your bank statement due to errors or changes in your account records. Several factors can cause this discrepancy, including:
1. Incorrect opening balance
2. Modified or deleted reconciled transactions
3. Previously reconciled transactions marked as unreconciled
4. Duplicate transactions
5. Incorrect journal entry adjustments
If you’re unable to identify the cause or correct the discrepancy, give a call directly at 1-888-245-6075.
There could be multiple reasons why the beginning balance appears as zero or incorrect in the Begin Reconciliation window. Some of the common causes include:
1. No opening balance or an incorrect balance entered during account setup.
2. Previously reconciled transactions being voided, deleted, or modified.
3. Company file conversion from another QuickBooks version.
4. Data damage in the company file.
On this page
Have a QuickBooks® question? Our ProAdvisors can help. QAsolved is not affiliated with Intuit.