QuickBooks Desktop helps businesses maintain accurate financial records by matching transactions in the company file with bank statement activity. However, you may sometimes notice a reconciliation discrepancy when the difference between the cleared transactions and the bank statement does not reach zero.
This issue can occur because of missing deposits, duplicate payments, incorrect transaction amounts, bank fees, or changes to previously reconciled entries. An incorrect beginning balance can also cause problems during reconciliation.
In this article, you will learn how to correct a bank reconciliation discrepancy in QuickBooks Desktop, identify common causes, and prevent the same problem from happening again.
A bank reconciliation discrepancy occurs when the transactions recorded in QuickBooks Desktop do not match the transactions and ending balance shown on your bank statement.
During reconciliation, QuickBooks compares your recorded deposits, withdrawals, checks, and other transactions with the bank statement. When the amounts do not match, the reconciliation window displays a remaining difference.
A discrepancy does not always mean that your accounting records are incorrect. Outstanding checks and deposits in transit, for example, can be legitimate timing differences. The important step is to identify the reason for the discrepancy before changing any transactions.
Understanding the possible causes can help you choose the right correction.
Incorrect beginning balance: A previously reconciled transaction may have been edited, deleted, or marked as unreconciled.
Missing transactions: Deposits, checks, or electronic payments may not have been recorded in QuickBooks.
Duplicate entries: A payment or deposit may have been entered more than once.
Incorrect transaction amounts: An amount in QuickBooks may differ from the amount on the bank statement.
Unrecorded bank charges: Service fees or interest may appear on the statement but not in the company file.
Wrong statement details: The ending balance or statement date may have been entered incorrectly.
Outstanding transactions: Checks or deposits may not have cleared the bank by the statement's ending date.
Wrong account selection: You may be reconciling an account that does not correspond to the bank statement.
Follow these steps to locate and correct the underlying problem.
First, confirm that the reconciliation details match your bank statement.
Open QuickBooks Desktop.
Select Banking > Reconcile.
Choose the correct bank account.
Compare the statement ending date with the date on your bank statement.
Verify that the ending balance is entered correctly.
Review the displayed beginning balance.
If you discover an incorrect date or ending balance, correct the information before reviewing individual transactions.
An incorrect beginning balance is a common reason for a reconciliation discrepancy.
To investigate the issue:
Open the reconciliation window and note the beginning balance.
Compare it with the previous bank statement's ending balance.
Open the account register and review previously reconciled transactions.
Look for transactions that have been edited, deleted, or changed from reconciled to unreconciled.
Compare the affected transactions with the previous reconciliation report.
If a previously reconciled transaction was changed, determine what was altered and restore the correct information when appropriate.
Do not create an adjustment simply to force the beginning balance to match. Identify the original cause first, particularly if the transaction belongs to a closed accounting period.
A missing transaction can cause QuickBooks Desktop to show a difference even when the rest of the reconciliation is correct.
Open your bank statement.
Review each deposit, check, withdrawal, and electronic payment.
Compare these transactions with the QuickBooks account register.
Identify legitimate transactions that appear on the bank statement but are missing from QuickBooks.
Enter the missing transactions using the correct date, amount, payee, and account.
Before creating a new entry, search the register carefully. A transaction may already exist under a different description or date.
Duplicate payments and deposits can distort your account balance.
To find duplicates:
Open the bank account register.
Look for repeated transactions with similar dates, amounts, and payees.
Compare each entry with the bank statement and any downloaded bank transactions.
Determine which transaction is valid.
Correct or remove a confirmed duplicate after reviewing its accounting impact.
Be cautious when changing reconciled entries. Editing or deleting a transaction from a completed reconciliation can affect later reconciliation balances and financial reports.
Not every transaction recorded in QuickBooks will appear on the current bank statement. Some transactions may not have cleared by the statement's ending date.
Examples include:
Checks issued shortly before the statement period ended.
Deposits recorded in QuickBooks that the bank processed later.
Electronic payments that have not cleared.
Transfers that appear on different dates in QuickBooks and the bank account.
Verify that these transactions are valid and recorded correctly. Do not delete legitimate outstanding transactions simply because they are absent from the current bank statement.
Bank fees and interest can also create reconciliation discrepancies.
Review the bank statement for service charges, account fees, and interest.
Check whether those items already exist in QuickBooks Desktop.
Enter any legitimate missing transactions.
Assign each transaction to the appropriate account.
Return to the reconciliation window and review the difference.
If you download bank transactions, confirm that the charge or interest entry has not already been imported to avoid duplication.
If the discrepancy remains, examine the previous reconciliation report.
Open the Reports menu.
Look for the reconciliation report or locate the relevant report through the banking or reconciliation options available in your QuickBooks version.
Select the account and reconciliation period.
Compare the report with the current account register.
Investigate transactions that have changed since the previous reconciliation.
The report can help identify unexpected changes to previously reconciled transactions. If you cannot determine why a transaction changed, avoid making further edits until you understand the accounting impact.
After correcting verified errors, repeat the reconciliation process.
Select Banking > Reconcile.
Choose the correct bank account.
Confirm the statement ending date and ending balance.
Compare the transactions listed in QuickBooks with the bank statement.
Mark the transactions that have cleared the bank.
Review the difference displayed in the reconciliation window.
Complete the reconciliation when the transactions match and the difference is zero.
Only mark transactions as cleared when they correspond to the bank statement. If the difference remains, investigate it rather than forcing the reconciliation to finish.
If you have reviewed the transactions and the discrepancy remains, check the following:
Confirm that you selected the correct bank account.
Verify the statement date and ending balance.
Review the previous reconciliation report.
Check for deleted, edited, or unreconciled transactions.
Confirm that bank fees and interest are recorded correctly.
Review imported transactions for duplicates.
Check whether outstanding checks or deposits explain a timing difference.
If the discrepancy involves prior-period financial statements or a substantial adjustment, consider consulting a qualified accounting professional before changing the records.
Follow these practices to keep your QuickBooks Desktop records accurate:
Reconcile bank accounts regularly.
Enter statement dates and ending balances carefully.
Record bank fees and interest promptly.
Review imported bank transactions before adding them.
Keep copies of bank statements and reconciliation reports.
Avoid editing or deleting previously reconciled transactions without checking the impact.
Maintain regular backups of your company file.
Investigate discrepancies before entering adjustments.
The difference may result from missing transactions, duplicate entries, incorrect amounts, an inaccurate beginning balance, or incorrect statement details. Outstanding checks and deposits can also explain timing differences.
Compare the beginning balance with the previous statement's ending balance and review the previous reconciliation report. Check for transactions that were edited, deleted, or changed to unreconciled. Correct the underlying issue instead of creating an unexplained adjustment.
Do not delete it automatically. First determine whether the transaction is incorrect and review its impact on previous reconciliations and financial reports. Correct the record only after verifying the appropriate accounting treatment.
An adjustment should not be used simply to force the difference to zero. Identify the reason for the discrepancy first. If an adjustment is genuinely required, make sure it is properly documented and assigned to the correct account.
Review transaction amounts, rounding, bank charges, and data-entry mistakes. Even a small difference should be investigated before you complete the reconciliation.
To correct a bank reconciliation discrepancy in QuickBooks Desktop, begin by verifying the statement ending date, ending balance, and beginning balance. Then review missing transactions, duplicates, bank fees, outstanding checks, and changes to previously reconciled entries.
Once you identify and correct the underlying issue, reconcile the account again and confirm that the difference is zero. Avoid unexplained adjustments and unnecessary changes to completed reconciliations. Regular reconciliation and careful transaction management help maintain reliable financial records.