-
QuickBooks Reconciliation Problem: Causes, Fixes, and Troubleshooting Steps
Answer Capsule
A QuickBooks reconciliation problem usually happens when the difference between QuickBooks and your bank or credit card statement does not reach zero, transactions are missing or duplicated, or a previously reconciled transaction has been changed.
The quickest way to find the cause is to compare the statement's beginning balance, ending balance, transaction dates, deposits, payments, and cleared transactions with QuickBooks. If the opening balance is wrong, a transaction was edited or deleted, or a reconciliation was accidentally undone, you may need to identify and correct that specific change rather than reconciling everything again.
What Is a QuickBooks Reconciliation Problem?
Account reconciliation is the process of comparing the transactions recorded in QuickBooks with your bank, credit card, or other financial statement.
When the account is reconciled correctly, the difference between the beginning balance plus cleared transactions and the statement's ending balance should be zero.
A reconciliation problem occurs when those figures don't match or when QuickBooks shows unexpected transactions during the reconciliation process.
Common symptoms include:- The reconciliation difference won't reach zero.
- The beginning balance is different from the previous statement.
- A transaction appears on the bank statement but not in QuickBooks.
- A QuickBooks transaction doesn't appear on the statement.
- A transaction was entered twice.
- A previously reconciled transaction has been edited.
- The reconciliation was accidentally undone.
- The cleared balance doesn't match the bank statement.
- Deposits or payments have the wrong amount or date.
Why Is My QuickBooks Reconciliation Off?
There are several possible reasons.
Incorrect Opening Balance
The beginning balance in a new reconciliation should generally agree with the ending balance from the previous reconciliation.
If it doesn't, something may have changed in the account after the previous reconciliation.
Missing Transactions
A transaction recorded in the bank but not in QuickBooks will affect the ending balance.
This commonly happens with:- Bank charges
- Interest
- Automatic payments
- Electronic transfers
- Checks
- Deposits
- Credit card charges
If the same payment or deposit was entered twice, QuickBooks' balance can differ from the bank statement.
Changed Reconciled Transactions
Editing the amount, date, account, or cleared/reconciled status of a previously reconciled transaction can cause a later reconciliation to become unbalanced.
Deleted Transactions
Deleting a transaction that was included in a previous reconciliation can also change the account's historical balance.
Incorrect Transaction Amount
Even a small difference can prevent reconciliation.
For example, if a bank statement shows a payment of $245.50 but QuickBooks contains $254.50, the account will remain off by $9.00.
How to Fix a QuickBooks Reconciliation Problem
1. Compare the Statement and QuickBooks
Start with the bank or credit card statement you are currently reconciling.
Check these figures carefully:- Beginning balance
- Ending balance
- Statement date
- Deposits
- Payments
- Fees
- Interest
- Transfers
Don't change transactions immediately. First identify where the difference appears.
2. Verify the Beginning Balance
The beginning balance is one of the first things to check when a reconciliation doesn't make sense.
The current statement's beginning balance should normally correspond to the previous reconciliation's ending balance.
If QuickBooks shows a different beginning balance, investigate what changed after the previous reconciliation.
Look for:- Deleted reconciled transactions
- Edited reconciled transactions
- Newly entered transactions with old dates
- Changes to transaction amounts
- Changes to reconciliation status
3. Check the Ending Balance and Statement Date
When starting a reconciliation, enter the information exactly as shown on the financial statement.
Double-check:- The financial institution.
- The statement date.
- The statement ending balance.
Likewise, entering the wrong ending balance can create a difference even when every transaction has been entered correctly.
4. Look for Missing Transactions
Compare the statement line by line with QuickBooks.
If a transaction appears on the statement but not in QuickBooks, enter it before completing the reconciliation.
Common examples include:- Monthly bank service fees
- ATM fees
- Interest earned
- Automatic withdrawals
- Electronic payments
- Merchant fees
- Direct deposits
5. Check for Duplicate Transactions
Duplicate entries are another common reason for a reconciliation difference.
Suppose your bank shows one payment for $500, but QuickBooks contains two identical $500 payments.
QuickBooks is then recording $1,000 while the bank is recording $500.
Review similar transactions carefully before deleting anything. Two transactions with the same amount aren't necessarily duplicates—they may represent separate payments.
Check:- Date
- Amount
- Payee
- Check number
- Memo
- Bank description
6. Review Cleared and Reconciled Transactions
During reconciliation, QuickBooks uses the transactions you mark as cleared.
Review each transaction against the statement rather than checking everything automatically.
For every item, confirm:- It appears on the statement.
- The amount is correct.
- The date is reasonable for the statement period.
- It belongs to the account you're reconciling.
7. Find Previously Reconciled Transactions That Changed
This is one of the most important troubleshooting steps when an account that used to reconcile correctly suddenly doesn't.
A previously reconciled transaction may have been:- Edited
- Deleted
- Duplicated
- Unreconciled
- Assigned to a different account
- Changed to a different amount
If your reconciliation was correct last month but the beginning balance is now different, investigate historical transactions before creating a new adjustment.
How to Find What Changed After a Previous Reconciliation
If you suspect that a previous reconciliation was altered, work backward from the last statement that reconciled successfully.
Step 1: Identify the Last Correct Reconciliation
Find the most recent bank statement for which QuickBooks reached a zero difference.
Keep that statement available.
Step 2: Compare the Historical Transactions
Review transactions included in that reconciliation.
Pay special attention to older transactions that have been modified since the reconciliation.
Step 3: Check the Audit Trail
QuickBooks Desktop provides an Audit Trail that can show changes made to transactions.
You can use it to investigate:- Who changed a transaction
- When it was changed
- What type of change occurred
What If the QuickBooks Reconciliation Difference Is Small?
Don't assume that a small difference is insignificant.
A difference of $1 or $2 can still indicate:- A transaction amount was entered incorrectly.
- A bank fee was omitted.
- A duplicate transaction exists.
- A decimal was entered incorrectly.
- A transaction was reconciled in the wrong period.
Find the source before posting an adjustment.
What If the Difference Is Exactly the Amount of One Transaction?
This is a useful clue.
If the reconciliation difference is exactly $75, look for a missing, duplicated, or incorrectly entered $75 transaction.
If the difference is $1,250, search for a transaction around that amount.
The difference doesn't always point directly to the problem, but matching the amount can make the investigation faster.
What If the Beginning Balance Is Wrong?
A wrong beginning balance often indicates that something from an earlier reconciliation has changed.
Possible causes include:- A previously reconciled transaction was deleted.
- A reconciled transaction was edited.
- The reconciliation status changed.
- A prior reconciliation was undone.
- An incorrect adjustment was entered previously.
First determine what caused the balance to change.
Should You Use a Reconciliation Adjustment?
A reconciliation adjustment can make an account appear balanced, but it shouldn't be the first solution when you don't know why the account is off.
An adjustment may hide the underlying problem.
Before creating one, investigate:- The beginning balance.
- Missing transactions.
- Duplicate entries.
- Incorrect amounts.
- Previously reconciled transactions.
- Deleted transactions.
- Bank fees and interest.
- The statement date and ending balance.
How to Handle a Previous Reconciliation That Was Done Incorrectly
If an earlier reconciliation contains errors, don't automatically start changing old transactions.
First create a backup of the company file.
Then determine:- Which reconciliation is incorrect.
- Which transactions are affected.
- Whether the error can be corrected without undoing multiple reconciliations.
- Whether an accountant or experienced QuickBooks professional should review the file.
QuickBooks Reconciliation Problem After Bank Feed Downloads
Bank Feeds can make reconciliation easier, but downloaded transactions still need to be reviewed.
A downloaded transaction isn't automatically proof that the entry is correct.
Before accepting or matching transactions, check:- The account
- Amount
- Date
- Payee
- Category
- Whether an existing transaction already exists
How to Prevent Reconciliation Problems
A few habits can make future reconciliations much easier.
Reconcile Regularly
Reconciling monthly gives you a smaller set of transactions to investigate.
Review Bank Feed Transactions
Don't automatically add every downloaded transaction without checking whether it already exists.
Keep Bank Statements
Save statements for your records so you can investigate historical discrepancies.
Limit Unnecessary Changes
Avoid changing old reconciled transactions unless you understand how the change will affect the account.
Back Up Before Major Corrections
Create a current company-file backup before making significant historical changes.
Review Reconciliation Reports
Use reconciliation reports to keep track of what was cleared and reconciled during previous periods.
When Should You Get Professional Help?
Consider getting help when:- Several previous reconciliations are incorrect.
- The beginning balance changes unexpectedly.
- Numerous reconciled transactions were edited or deleted.
- The company file has extensive historical discrepancies.
- You aren't sure whether to undo a reconciliation.
- A large reconciliation adjustment is being considered.
When asking for help, have the affected bank statement, reconciliation report, and exact difference available. That information can make the investigation much more efficient.
Frequently Asked Questions
Why won't my QuickBooks reconciliation balance to zero?
The difference may be caused by a missing transaction, duplicate entry, incorrect amount, changed reconciled transaction, deleted transaction, or incorrect beginning or ending balance.
Why is my beginning balance different in QuickBooks?
A previous reconciliation may have been changed. Check for edited, deleted, duplicated, or unreconciled transactions from earlier periods.
Can a deleted transaction affect reconciliation?
Yes. Deleting a transaction that was included in a previous reconciliation can change the account's historical balance and affect subsequent reconciliations.
Should I enter an adjustment to fix a reconciliation?
Not automatically. First investigate the reason for the difference. An adjustment should have a legitimate, documented reason rather than being used simply to force the reconciliation to zero.
How do I find a changed reconciled transaction?
Review the account's historical transactions and use the QuickBooks Audit Trail to investigate transaction changes, including when and how a transaction was modified.
What if my bank statement and QuickBooks have different transaction amounts?
Compare the transaction details carefully. Correct the QuickBooks transaction if it was entered incorrectly, or investigate the bank statement if the bank's records appear different.
Can Bank Feeds cause reconciliation problems?
They can contribute to problems if downloaded transactions are added as duplicates, matched incorrectly, assigned to the wrong account, or entered with incorrect details. Always review downloaded transactions before accepting them.
Is a small reconciliation difference a serious problem?
Even a small difference should be investigated. A few cents or dollars can indicate an incorrect amount, missing fee, duplicate entry, or another bookkeeping error.
Conclusion
A QuickBooks reconciliation problem is usually a sign that something in the account activity doesn't match the financial statement. The most useful approach is to identify the exact source of the difference instead of forcing the reconciliation to balance.
Start by checking the statement date, beginning balance, ending balance, missing transactions, duplicates, and previously reconciled entries. If the beginning balance has changed, investigate historical transaction changes and the Audit Trail before making adjustments.
With regular reconciliations, careful Bank Feed reviews, and backups before major corrections, it becomes much easier to catch discrepancies before they affect multiple accounting periods.
Sign in or register to take part in discussions.
Polyphone needs you!
Polyphone is free but there are costs associated with its website and development. A small donation will help a lot.
Donate
Learn the basics
Try a tutorial
Scroll to
top
top