QuickBooks Bank Reconciliation Problems: Causes and Practical Fixes
QuickBooks bank reconciliation problems usually become noticeable when the ending balance in QuickBooks does not agree with the bank statement, transactions refuse to match, or the reconciliation difference will not reach zero. Sometimes the problem is caused by one missing transaction. In other cases, an older reconciliation, beginning balance, duplicate entry, or manually changed transaction can affect everything that follows.
Bank reconciliation is more than checking whether two balances look similar. QuickBooks compares the transactions you select against the bank statement information for a specific period. A small mistake early in the process can continue showing up in later reconciliations.
Before changing or deleting transactions, identify where the difference started. If you need assistance troubleshooting the issue, QuickBooks support is available at 866-798-4134.
Why Am I Having Bank Reconciliation Problems in QuickBooks?
There is rarely one single cause behind a reconciliation difference.
Common causes include:
- A transaction is missing from QuickBooks
- A transaction was entered twice
- The transaction amount is incorrect
- The transaction date is wrong
- A previously reconciled transaction was edited
- A transaction was accidentally unreconciled
- The beginning balance does not agree with the previous reconciliation
- Bank-feed transactions were duplicated
- Transactions were entered manually and also downloaded from the bank
- The wrong bank or credit-card account was selected
The most important question is when the difference first appeared. If your reconciliations were correct for months and suddenly stopped balancing, look at the transactions changed since the last successful reconciliation rather than reviewing the entire account randomly.
Start With the Previous Reconciliation
If the current reconciliation does not balance, compare its beginning balance with the ending balance from the previous reconciliation.
A mismatch here is an important warning sign. The current reconciliation may not be the original problem.
For example, suppose last month’s reconciliation finished correctly, but the current month’s beginning balance is different. Something may have changed in the account after the previous reconciliation.
Look for:
- Edited reconciled transactions
- Deleted reconciled transactions
- Previously reconciled transactions marked as unreconciled
- Changes to transaction amounts
- Changes to transaction dates
Do not immediately enter an adjustment simply to force the account to balance. An adjustment can hide the original discrepancy and make future reconciliations harder to understand.
For general information about bank reconciliation statements, you can Read more about bank reconciliation statements.
Compare the Ending Balance and Statement Date
Before selecting transactions, confirm that the reconciliation uses the correct bank statement date and ending balance.
It is surprisingly easy to enter the wrong statement date or accidentally type an incorrect balance.
Check the physical or electronic bank statement and compare:
- Statement ending date
- Statement ending balance
- Bank account
- Beginning balance
- Reconciliation period
If the statement balance itself was entered incorrectly, no amount of transaction matching will make the reconciliation accurate.
Look for Missing Transactions
A missing transaction is one of the most common reasons the reconciliation difference does not disappear.
Compare the bank statement with the transactions recorded in QuickBooks for the same period.
Look for checks, deposits, withdrawals, fees, transfers, electronic payments, and other transactions that appear on the statement but are absent from QuickBooks.
If you use bank feeds, remember that downloading transactions does not automatically mean every transaction has been correctly categorized and added to the register.
Review downloaded transactions carefully before assuming the bank-feed history is complete.
Watch for Duplicate Transactions
Duplicates can create a reconciliation difference just as easily as missing transactions.
This often happens when a transaction was entered manually and later downloaded from the bank.
For example, an employee might enter a $500 payment manually. A few days later, the same $500 payment appears in the bank feed and is added as a new transaction instead of being matched to the existing entry.
The bank statement contains one transaction, while QuickBooks contains two.
Compare transaction dates, amounts, payees, and reference information before deleting anything. If you are not certain which transaction is the duplicate, preserve the original data and investigate further.
Check Transaction Dates and Amounts
A transaction can exist in QuickBooks but still be missing from the reconciliation because its date or amount does not match what you expect.
A payment dated just outside the statement period may not appear in the current reconciliation even though it is related to the same business activity.
Likewise, a $1,250 transaction entered as $1,520 will produce a difference that may be difficult to identify if you are only checking totals.
Review the individual transaction details whenever the difference looks close to a specific amount.
Investigate the Beginning Balance Difference
A beginning balance problem deserves special attention because it can affect more than one reconciliation period.
If QuickBooks shows a beginning balance that does not match the prior statement or reconciliation, check the previous reconciliation before changing the current one.
Do not assume that entering a new opening balance is the correct fix.
The appropriate solution depends on what caused the discrepancy. In some cases, a previously reconciled transaction was modified. In others, the original reconciliation may have been completed incorrectly.
If you need help with another QuickBooks account-access issue while working through your books, you can Read more about whether QuickBooks Online requires a login.
Check for Transactions That Were Edited After Reconciliation
One of the easiest ways to create a reconciliation problem is to change a transaction that had already been reconciled.
For example, a reconciled check for $750 might later be edited to $570. QuickBooks now contains a different amount from the transaction originally reconciled against the bank statement.
Look at the reconciliation history and transaction details if the problem appeared unexpectedly after previous reconciliations were correct.
If several old transactions have been changed, fixing the latest reconciliation alone may not solve the underlying issue.
Be Careful With Reconciliation Adjustments
QuickBooks may provide ways to enter an adjustment when an account will not reconcile.
An adjustment can have a legitimate accounting purpose in certain circumstances, but it should not be used simply because you cannot locate a missing $100 or $1,000 transaction.
A forced adjustment can make the current reconciliation appear correct while leaving the underlying records inaccurate.
Before using an adjustment, determine:
- What created the difference?
- Which period was affected?
- Whether a transaction was deleted or edited?
- Whether the bank statement itself was entered correctly?
- Whether the difference is actually a timing issue?
Only then should you determine whether an adjustment is appropriate.
Understand Outstanding Transactions
Not every difference means there is an error.
Some checks or payments may have been recorded in QuickBooks but have not yet cleared the bank. Likewise, a deposit may have been entered before it appeared on the statement.
These are legitimate timing differences.
If the transaction appears in QuickBooks but not on the current bank statement, compare the transaction date and clearing status rather than deleting it.
The objective of reconciliation is to explain the difference, not necessarily to make every transaction appear on the bank statement immediately.
Check Bank-Feed Matches Carefully
Bank feeds can save time, but incorrect matching can create accounting problems.
When reviewing downloaded transactions, make sure QuickBooks is matching the bank transaction with the correct existing entry.
Pay particular attention to:
- Similar transaction amounts
- Recurring payments
- Transfers between accounts
- Credit-card payments
- Vendor names that appear differently at the bank
- Transactions entered manually
A wrong match can make the register look correct at first while creating problems during reconciliation.
What If QuickBooks Shows a Different Reconciliation Difference?
If the difference changes after you select or deselect transactions, compare the selected transaction totals with the bank statement.
Make changes one at a time.
For example, if the difference is $300 and selecting one transaction changes the difference to zero, investigate that transaction instead of immediately assuming the problem is solved. Verify that it belongs to the correct account and statement period.
This approach helps prevent accidental reconciliation of an unrelated transaction.
When Should You Contact QuickBooks Support?
If the reconciliation difference continues after reviewing missing transactions, duplicates, beginning balances, edited transactions, and timing differences, professional assistance may be useful.
Before contacting QuickBooks support at 866-798-4134, gather:
- Bank statement for the affected period
- Statement ending balance
- Statement date
- Current reconciliation difference
- Previous successful reconciliation date
- Any known edited or deleted transactions
- Details of recent bank-feed activity
If you use QuickBooks Enterprise, additional product information is available through Read more about QuickBooks Enterprise terminology.
For Enterprise support contact information, you can also Read more about QuickBooks Enterprise Support contact options.
If your reconciliation issue is connected to payroll transactions, this resource may also be useful: Read more about QuickBooks Payroll error support.
For payroll callback information, see Read more about requesting a QuickBooks Payroll support callback.
Protect Your Data Before Correcting Reconciliation Problems
Bank reconciliation changes can affect your accounting records, so avoid making multiple changes without recording what you changed.
If possible, maintain a recent backup of your QuickBooks Desktop company file. For QuickBooks Online, preserve relevant reports and transaction information before making significant corrections.
Do not delete transactions simply because they do not match the bank statement. A transaction may represent an outstanding item, timing difference, or legitimate accounting entry.
Likewise, do not create random transactions solely to eliminate a reconciliation difference.
Frequently Asked Questions
Why won’t my QuickBooks bank reconciliation balance?
The difference may be caused by missing or duplicate transactions, incorrect amounts, edited reconciled transactions, beginning-balance problems, or legitimate outstanding transactions.
Why is my beginning balance different in QuickBooks?
A previously reconciled transaction may have been edited, deleted, or changed to an unreconciled status. Review the previous reconciliation before changing the current beginning balance.
Should I enter an adjustment to make the reconciliation zero?
Not automatically. First determine why the difference exists. An adjustment can conceal an underlying transaction or reconciliation problem.
Can duplicate bank-feed transactions cause reconciliation problems?
Yes. If a transaction was manually entered and the downloaded bank transaction was added separately instead of matched, QuickBooks may contain two entries for one bank transaction.
What should I do if I cannot find the reconciliation difference?
Start with the previous successful reconciliation and work forward. Compare the bank statement against QuickBooks, paying particular attention to edited, deleted, missing, duplicate, and incorrectly dated transactions.
What number can I call for QuickBooks reconciliation help?
For troubleshooting assistance, you can contact QuickBooks support at 866-798-4134.
Conclusion
QuickBooks Bank Reconciliation Problems are easier to resolve when you identify where the difference began instead of immediately forcing the account to balance.
Start with the previous reconciliation, confirm the statement date and ending balance, then check for missing transactions, duplicates, edited reconciled entries, incorrect amounts, and outstanding items. Bank-feed matches and beginning-balance changes deserve particular attention because they can affect later reconciliation periods.
Most importantly, avoid using adjustments as a shortcut before understanding the cause. Keeping accurate transaction history is more important than simply making the reconciliation screen show zero.
If you need additional assistance, QuickBooks support can be reached at 866-798-4134.
