Dealing With Uncleared Checks During a QuickBooks Reconciliation

QuickBooks Bank Reconciliation Problems can make it difficult to match transactions, balance accounts, identify discrepancies, and keep financial records accurate. Bank reconciliation is an important accounting task because it compares the transactions recorded in QuickBooks with the activity reported by your bank.

When the beginning balance is incorrect, transactions are missing, duplicate entries appear, or previously reconciled transactions are changed, the reconciliation may no longer balance.

This guide explains common QuickBooks Bank Reconciliation Problems, their causes, troubleshooting steps, and ways to prevent reconciliation discrepancies.

📞 866-798-4134

What Are QuickBooks Bank Reconciliation Problems?

QuickBooks Bank Reconciliation Problems occur when the transactions or balances recorded in QuickBooks do not match the corresponding information on a bank statement.

You may notice:

• Beginning balance doesn’t match.
• Ending balance is incorrect.
• Reconciliation difference doesn’t reach zero.
• Transactions are missing.
• Transactions appear twice.
• Previously reconciled transactions become unreconciled.
• Deposits don’t match the bank statement.
• Checks remain uncleared.
• Bank fees are missing.
• QuickBooks shows an unexpected reconciliation discrepancy.

These problems can occur in both QuickBooks Desktop and QuickBooks Online, although the exact troubleshooting process can differ between the two products.

Common Causes of QuickBooks Bank Reconciliation Problems

Incorrect Beginning Balance

One of the most common reconciliation problems is an incorrect beginning balance.

The beginning balance should generally correspond to the ending balance from the previous completed reconciliation. If a previously reconciled transaction was modified or deleted, the beginning balance may no longer agree with the bank statement.

Missing Transactions

A transaction that appears on your bank statement but isn’t recorded in QuickBooks can cause the reconciliation to remain out of balance.

Common missing transactions include:

• Checks
• Deposits
• Bank fees
• Interest
• ACH payments
• Electronic withdrawals
• Transfers

Duplicate Transactions

Duplicate transactions can make the QuickBooks balance higher or lower than the actual bank balance.

This can happen when transactions are manually entered and then downloaded again through bank feeds.

Incorrect Transaction Amounts

Even a small difference in the amount of a transaction can prevent reconciliation.

For example, if a check was recorded as $850 but the bank statement shows $580, the difference will remain until the transaction is corrected.

Incorrect Transaction Dates

A transaction may be entered using the wrong date, causing it to appear in a different reconciliation period.

Previously Reconciled Transactions Were Changed

Editing or deleting transactions that were already reconciled can affect the reconciliation history.

This is especially important when multiple users have access to the same QuickBooks company file.

Bank Fees Were Not Recorded

Banks may charge:

• Monthly service fees
• Wire fees
• Transaction fees
• Overdraft fees
• Other account charges

If these amounts aren’t entered into QuickBooks, the reconciliation may not balance.

Outstanding Checks

Checks recorded in QuickBooks may not yet have cleared the bank.

Outstanding checks aren’t necessarily errors. They may simply need to remain uncleared until they appear on the bank statement.

Outstanding Deposits

Deposits recorded in QuickBooks may not have appeared on the bank statement by the reconciliation date.

Bank Feed Errors

Downloaded transactions can sometimes create duplicate entries or incorrectly matched transactions.

Review imported transactions carefully before accepting them.

Symptoms of QuickBooks Bank Reconciliation Problems

Common warning signs include:

• Reconciliation difference is not zero.
• Beginning balance is different from the previous reconciliation.
• Bank statement balance doesn’t match QuickBooks.
• Transactions are missing from the reconciliation window.
• Reconciled transactions have changed.
• Bank feed transactions don’t match manually entered transactions.
• Uncleared transactions remain for an unusually long time.
• Account balance appears incorrect after reconciliation.

How To Fix QuickBooks Bank Reconciliation Problems

Solution 1: Compare the Beginning Balance

Start by checking the beginning balance shown in QuickBooks against the previous bank reconciliation.

Review the last completed reconciliation and confirm that the ending balance matches the current beginning balance.

If the amounts don’t agree, look for transactions that were:

• Added
• Deleted
• Modified
• Unreconciled

after the previous reconciliation.

Solution 2: Compare the Bank Statement With QuickBooks

Work through the bank statement line by line.

Compare:

• Transaction date
• Payee
• Description
• Amount
• Deposit
• Withdrawal
• Check number

Mark transactions that appear in both records.

This can help identify missing, duplicated, or incorrectly entered transactions.

Solution 3: Look for Missing Transactions

Search QuickBooks for transactions appearing on your bank statement.

Pay particular attention to:

• Bank charges
• Interest income
• Electronic payments
• Transfers
• ATM transactions
• Checks
• Deposits

Enter legitimate missing transactions before completing reconciliation.

Solution 4: Check for Duplicate Transactions

Review transactions that have similar:

• Dates
• Amounts
• Payees
• Descriptions

A manually entered transaction may have already been downloaded through the bank feed.

Don’t delete a transaction simply because it appears similar. Confirm the transaction is actually duplicated first.

Solution 5: Verify Transaction Amounts

Open transactions that don’t match your bank statement.

Check whether:

• The amount is correct.
• The transaction date is correct.
• The account is correct.
• The payee is correct.
• The transaction wasn’t entered twice.

Correct legitimate errors before continuing reconciliation.

Solution 6: Check Outstanding Checks

Outstanding checks can cause the QuickBooks balance to differ from the bank statement.

Review old uncleared checks and determine whether they are genuinely outstanding.

Don’t simply mark every old check as cleared to force the reconciliation to balance.

Solution 7: Check Outstanding Deposits

Review deposits that were entered into QuickBooks but haven’t appeared on the bank statement.

These may simply have been deposited near the end of the statement period and cleared later.

Solution 8: Record Bank Fees

If your bank statement contains a fee that doesn’t appear in QuickBooks, record the appropriate transaction.

Examples include:

• Monthly account fees
• Wire transfer fees
• Service charges
• Overdraft fees

After entering the legitimate fee, return to reconciliation and verify the difference.

Solution 9: Review Bank Transfers

Transfers between QuickBooks accounts can sometimes be incorrectly recorded.

For example, a transfer from checking to savings should generally have corresponding entries in the appropriate accounts.

Review transfers for:

• Incorrect accounts
• Incorrect amounts
• Duplicate entries
• Missing entries

Solution 10: Review Previously Reconciled Transactions

If the beginning balance suddenly changed, investigate transactions that were previously reconciled.

Look for transactions with changed reconciliation status.

In QuickBooks Desktop, the reconciliation history and reports can help identify changes to reconciled transactions.

QuickBooks Bank Reconciliation Difference Won’t Go Away

If the reconciliation difference remains, don’t immediately force the account to balance.

Instead:

1. Note the exact difference.
2. Compare it with the bank statement.
3. Search for a transaction with the same amount.
4. Check for duplicate entries.
5. Review missing transactions.
6. Check previously reconciled transactions.
7. Review beginning and ending balances.
8. Verify outstanding checks and deposits.

The exact difference can sometimes provide a clue.

For example, a difference matching a bank fee may indicate that the fee was never recorded.

QuickBooks Bank Reconciliation Beginning Balance Is Wrong

An incorrect beginning balance often requires additional investigation.

Check:

• The previous reconciliation.
• Reconciled transactions.
• Deleted transactions.
• Modified transactions.
• Opening balance entries.
• Account transfers.

Avoid simply entering a new adjustment to make the beginning balance match unless the adjustment is properly supported by your accounting records.

QuickBooks Bank Reconciliation Doesn’t Match Bank Statement

If the bank statement and QuickBooks don’t match, compare them systematically.

Create three categories:

Category	Example
Appears on both	Cleared check
Bank only	Bank fee
QuickBooks only	Outstanding check

This makes it easier to determine whether the difference is caused by timing, missing transactions, duplicate entries, or incorrect records.

QuickBooks Bank Reconciliation After Bank Feed Download

Bank feeds can make reconciliation easier, but automatically downloaded transactions still need review.

Before accepting transactions:

• Match them to existing entries.
• Avoid creating duplicates.
• Verify transaction amounts.
• Check transaction dates.
• Review transfers.
• Confirm the correct account.

Bank feeds should not replace the reconciliation process.

QuickBooks Online Bank Reconciliation Problems

For QuickBooks Online, review the banking transactions and reconciliation information carefully.

If transactions were recently downloaded:

1. Open the Banking or Transactions area.
2. Review downloaded transactions.
3. Match transactions with existing records.
4. Add legitimate transactions that aren’t already recorded.
5. Review duplicate entries.
6. Start the reconciliation.
7. Compare the statement ending balance and date.

Make sure you aren’t accidentally adding a bank-feed transaction that already exists in the register.

QuickBooks Desktop Bank Reconciliation Problems

For QuickBooks Desktop, review the account register and reconciliation reports.

Check:

• Beginning balance.
• Ending balance.
• Cleared transactions.
• Reconciled transactions.
• Outstanding transactions.
• Reconciliation discrepancies.

QuickBooks Desktop also provides reports that can help identify changes to previously reconciled transactions.

Should You Undo a Bank Reconciliation?

Sometimes an earlier reconciliation may need to be reviewed or undone, particularly if incorrect transactions were reconciled.

However, undoing a reconciliation can affect subsequent reconciliation periods.

Before making significant changes:

• Create a backup when using QuickBooks Desktop.
• Document the current reconciliation.
• Identify the reason for the discrepancy.
• Review the affected transactions.

Don’t repeatedly undo reconciliations simply to force the account to match.

Common QuickBooks Reconciliation Mistakes

Avoid these common mistakes:

Forcing the Difference to Zero

Creating an unsupported adjustment can hide the actual accounting problem.

Marking Everything as Cleared

A transaction should only be marked cleared when it corresponds to the bank activity or is otherwise properly accounted for.

Deleting Transactions Without Investigation

A transaction that appears incorrect may actually be legitimate.

Ignoring Old Outstanding Transactions

Old checks and deposits should be reviewed rather than automatically cleared.

Accepting Every Bank Feed Transaction

Downloaded transactions should be matched and reviewed before being added.

How To Prevent QuickBooks Bank Reconciliation Problems

Following a consistent reconciliation routine can prevent many discrepancies.

Reconcile Regularly

Don’t wait until the end of the year to reconcile your accounts.

Monthly reconciliation makes discrepancies easier to identify.

Review Bank Feeds

Check downloaded transactions regularly and match them carefully.

Maintain Accurate Records

Enter checks, deposits, transfers, fees, and other transactions accurately.

Restrict Unnecessary Editing

Limit access to accounting records where appropriate.

Keep Documentation

Maintain copies of bank statements and reconciliation reports for your accounting records.

Investigate Differences Immediately

Small discrepancies are usually easier to locate when they are investigated promptly.

Related QuickBooks Banking Problems

QuickBooks Bank Reconciliation Problems may occur alongside:

• QuickBooks Bank Feed Not Updating
• QuickBooks Bank Transactions Missing
• QuickBooks Bank Account Not Updating
• QuickBooks Duplicate Bank Transactions
• QuickBooks Online Banking Error
• QuickBooks Bank Connection Error
• QuickBooks Reconciliation Discrepancy
• QuickBooks Beginning Balance Wrong
• QuickBooks Bank Balance Doesn’t Match
• QuickBooks Transactions Not Matching

Frequently Asked Questions

Why won’t my QuickBooks bank reconciliation balance?

The reconciliation may not balance because of missing transactions, duplicate entries, incorrect amounts, outstanding transactions, bank fees, or changes to previously reconciled transactions.

Why is my beginning balance different in QuickBooks?

A beginning balance can change when a previously reconciled transaction is edited, deleted, added, or has its reconciliation status changed.

Can duplicate transactions cause reconciliation problems?

Yes. Duplicate transactions can change the account balance and create a reconciliation difference.

Should I force QuickBooks reconciliation to balance?

No. Avoid creating unsupported adjustments simply to make the difference zero. Find the underlying discrepancy and correct the appropriate transaction.

Why are some transactions missing during reconciliation?

A transaction may have the wrong date, may not have been entered into QuickBooks, may belong to another account, or may not have been downloaded through the bank feed.

What should I do with old outstanding checks?

Review them individually. Determine whether they are still legitimately outstanding, were cleared under a different transaction, or require additional accounting attention.

How often should I reconcile my QuickBooks bank account?

Monthly reconciliation is a common practice because it allows discrepancies to be identified relatively soon after they occur.

Who can help with QuickBooks Bank Reconciliation Problems?

For assistance with QuickBooks Bank Reconciliation Problems, bank feed discrepancies, missing transactions, duplicate entries, incorrect beginning balances, or other QuickBooks accounting issues, call 866-798-4134.

Final Thoughts

QuickBooks Bank Reconciliation Problems can result from something as simple as a missing bank fee or outstanding check, but they can also indicate a larger issue involving duplicate transactions, changed reconciled entries, or an incorrect beginning balance.

The safest approach is to compare the QuickBooks register with the bank statement carefully, identify the exact source of the discrepancy, and correct the underlying transaction rather than forcing the reconciliation to balance. Regular reconciliation, careful bank-feed review, accurate transaction entry, and proper recordkeeping can significantly reduce future problems.

If you’re unable to identify why your QuickBooks reconciliation doesn’t match the bank statement, professional troubleshooting can help locate the discrepancy without unnecessarily changing your accounting records.

📞 866-798-4134
:::