QuickBooks Desktop Reconciliation: Fix Beginning & Ending Balance Issues

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.

Understanding Opening, Beginning, and Ending Balance 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.

• Opening Balance: This is the starting amount entered when you set up a bank, credit card, or other balance sheet account in QuickBooks Desktop.

• Beginning Balance: This is the amount carried forward from the previous reconciliation period.

Note: If a previously reconciled transaction is modified, deleted, or unreconciled, the balance may no longer match the expected amount.

• Ending Balance: This is the balance shown on your bank or credit card statement at the end of the reconciliation period. You enter this amount in the Reconcile window in QuickBooks Desktop and compare it with the transactions recorded in your company file.

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.

What Causes Beginning and Ending Balance Issues in QuickBooks Desktop

Beginning and ending balance discrepancies in QuickBooks Desktop can occur for several reasons. Take a quick look and get this fixed:

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.

How to Fix the Beginning Balance Issues in QuickBooks Desktop

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. Correct a Zero Balance in QuickBooks

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:

Step 1: Create a Journal Entry

Follow these steps to record the opening balance using a journal entry:

1. Open QuickBooks Desktop and Go to Company and then click Make General Journal Entries.
2. Set the date to match the date associated with your opening balance.
3. From the Account dropdown, select the account you want to reconcile.
4. Enter the correct opening balance in the Debit column.
5. In the next line, select Opening Balance Equity from the Account dropdown and enter the corresponding amount in the Credit column.
6. Click Save & Close to record the journal entry.

Note: Use this method only when an opening balance entry is genuinely missing or incorrect.

Step 2: Reconcile the Account to Correct the Beginning Balance

After recording the journal entry, reconcile the account to verify that the beginning balance is correct. Follow these steps:

1. Navigate to the Banking section and click Reconcile.
2. Choose the account you want to reconcile from the Account dropdown.
3. Enter the statement date and ending balance that correspond to the journal entry and the relevant bank statement.
4. Click Continue to open the reconciliation window.
5. Under Deposits and Other Credits, locate and select the journal entry you created.
6. Verify that the Difference field shows $0.00, then click Reconcile Now to complete the process.

Note: Before completing the reconciliation, verify that the journal entry reflects the correct opening balance and that the selected transactions match your records.

B. Fix an Incorrect Balance in QuickBooks Desktop

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:

• Reconcile Discrepancy Report: Identifies changes to transactions that were previously reconciled.
• Audit Trail Report: Helps you review changes made to transactions and identify when they occurred.
• Previous Reconciliation Report: Lets you review transactions included in an earlier reconciliation and compare them with your current records.

Reviewing these reports can help you pinpoint the source of the discrepancy before making any corrections to your account.

a. Reconcile Discrepancy Report

1. Open QuickBooks Desktop and navigate to the Reports menu to get started.
2. Navigate to Banking and select Reconciliation Discrepancy.
3. Choose the account you’re having trouble reconciling from the Account dropdown, then click OK.
4. Check the report for transactions that have been changed since your last reconciliation. Look for any modifications that could explain why the beginning balance is incorrect.

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.

b. Audit Trail Report

1. Go to Reports, select Banking, and then choose Previous Reconciliation.
2. Select the account you want to investigate from the account list.
3. Choose the most recent statement date. Select Transactions cleared at the time of reconciliation to generate the report as a PDF, then click Display.
   • Note: Write down or save the statement date and the reconciliation creation date shown in the report.
4. Go to Reports, select Accountant & Taxes, and then choose Audit Trail.
5. Choose the account you want to reconcile from the Account filter.
   • Click Customize Report.
   • Open the Filters tab and select Account.
   • Choose the relevant account from the Account dropdown.
6. Click Display to apply the account filter. Next, set the date range for the transactions:
   • Leave the From field blank.
   • Enter the statement date in the To field.
   • Click OK to apply the date filter.
7. Set the Entered/Modified filter to narrow down changes made after the previous reconciliation:
   • Set the From date to the reconciliation creation date noted in the PDF report.
   • Set the To date to today’s date.
8. Review the filtered Audit Trail report and look for transactions that were modified, deleted, or otherwise changed after the previous reconciliation.

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.

c. Previous Reconciliation Report

QuickBooks Pro may only provide access to the most recent reconciliation report, so save older reports as PDFs for future reference.

1. Go to Reports, select Banking, and then choose Previous Reconciliation.
2. Select the account and Statement Ending Date, then click Display.

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.

How to Undo a Previous Reconciliation and Redo It

Follow these steps to undo the most recent reconciliation in QuickBooks Desktop and redo it:

1. Backup your QuickBooks company file before making any changes to your reconciliation records.
2. Go to Banking and select Reconcile.
3. Click Undo Last Reconciliation.
4. When prompted, select Continue and then click OK to confirm.
5. Close the Reconcile window and reopen it to begin the reconciliation process again.

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.

How to Ignore the Discrepancy and Record an Offsetting Adjustment in QuickBooks Desktop

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.

Method 1: Find the Journal Entry

1. Go to Edit and select Find.
2. Open the Advanced tab and select Memo.
3. Enter Balance Adjustment in the search field and click Find.
4. Review the search results to locate the adjustment entry.

Method 2: Check the Previous Reconciliation Report

1. Go to Reports, select Banking, and then choose Previous Reconciliation.
2. Select the relevant account and statement ending date, then click Display.
3. Review the Cleared Transactions section for the General Journal Entry associated with the balance adjustment.

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.

How to Fix Ending Balance Issues in QuickBooks Desktop

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.

Step 1: Verify the Opening and Beginning Balances

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.

Step 2: Look for Changed, Deleted, or Missing Transactions

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.

A. Run the Reconciliation Discrepancy Report

1. Open QuickBooks Desktop and go to Reports.
2. Select Banking and then choose Reconciliation Discrepancy.
3. Select the account you’re trying to reconcile and click OK.
4. Review the report for transactions that have changed since the previous reconciliation.
5. If you find any discrepancies, check the transaction details and discuss the changes with the person who made them. Correct the entries if necessary.

B. Run the Missing Checks Report

1. Go to Reports and select Banking.
2. Choose Missing Checks.
3. Select the account you’re reconciling and click OK.
4. Review the report and compare the listed checks with your bank statement.
5. Identify any missing or duplicate entries and make the necessary corrections after verifying the transactions.

Note: A check listed in the report isn’t necessarily an error. Verify whether it cleared your bank before changing or removing the transaction.

C. Run the Transaction Detail Report

1. Go to Reports, select Custom Reports, and then choose Transaction Detail.
2. Open the Display tab.
3. In the Date From field, enter the earliest date available for the account or leave it blank.
4. Enter the date of your last reconciliation in the Date To field.
5. Open the Filters tab and select Account.
6. Choose the account you’re trying to reconcile.
7. Find the Entered/Last Modified filter and set the Date From field to your previous reconciliation date.
8. Set the Date To field to the current date.
9. Click OK to generate the report.
10. Review the results and compare the transactions with your bank statement. Investigate any changes or entries that could explain the ending balance difference.

Step 3: Check for Incorrect Reconciliation Adjustments

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:

1. Go to Lists and select Chart of Accounts.
2. Locate and open the Reconciliation Discrepancies account.
3. In the Dates field, select a date range covering your most recent reconciliations.
4. Review the transactions and look for any adjustments that may have affected your account balance.
5. If you find an incorrect adjustment, contact the person who recorded it or consult your accountant before making changes.

Note: Avoid deleting or modifying reconciliation adjustments without understanding their impact on previously reconciled periods.

Step 4: Complete the Reconciliation Again

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.

Tips to Prevent Beginning and Ending Balance Issues in QuickBooks Desktop

Preventing reconciliation discrepancies starts with maintaining accurate account records and reviewing transactions regularly. Here are the tips:

• Verify Opening Balances: Check opening balances when setting up accounts to ensure they match your actual bank or credit card records.
• Reconcile Accounts Regularly: Reconcile your accounts every month to identify discrepancies before they affect future periods.
• Avoid Editing Reconciled Transactions: Review previously reconciled transactions carefully before changing their dates, amounts, or account details.
• Review Reconciliation Reports: Save and compare previous reconciliation reports to track changes and identify unusual discrepancies.
• Record Transactions Promptly: Enter deposits, payments, checks, and other transactions regularly to keep your account records up to date.
• Avoid Unnecessary Adjustments: Investigate the cause of a reconciliation difference before creating journal entries or offsetting adjustments.
• Back Up Your Company File: Create regular backups before making significant changes to account records or reconciliation entries.

Conclusion

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.

Frequently Asked Questions