A QuickBooks bank reconciliation issue occurs when the transactions or balances recorded in QuickBooks do not agree with the corresponding bank statement. You may notice that QuickBooks bank reconciliation is not balancing, the reconciliation difference does not reach $0.00, the beginning balance does not match, or transactions appear to be missing or duplicated. A discrepancy can also appear after an account that previously reconciled successfully was changed. The right fix depends on when the problem started and whether this is your first reconciliation or a later one. QuickBooks Online and QuickBooks Desktop also use different diagnostic reports and undo workflows. The safest approach is to identify the source of the difference first rather than immediately unreconciling transactions or creating an adjustment.
Why Is QuickBooks Bank Reconciliation Not Balancing?
When you reconcile an account, you compare the transactions recorded in QuickBooks with those shown on your bank statement. If everything is accounted for, the difference between the two balances should be $0.00. A non-zero amount means something in the records, balances, or timing does not agree.
The important thing is not to treat every reconciliation difference as the same problem. Start by determining whether the issue is related to the beginning balance, the current statement, individual transactions, or a previous reconciliation.
A. Incorrect Beginning or Opening Balance
An opening balance is the starting point for an account when you begin tracking it in QuickBooks. A beginning balance during a later reconciliation is generally based on the ending balance from the previous reconciliation. These are related, but they are not the same thing.
If this is your first reconciliation and the starting amount is incorrect, the opening balance may be the problem. QuickBooks Online’s current guidance recommends comparing the opening balance with the real-world account balance for the date you began tracking the account.
If the account has already been reconciled successfully, a beginning-balance problem usually requires a different investigation. QuickBooks expects the beginning balance to agree with the previous reconciliation’s ending balance. If a reconciled transaction was later changed, the previous ending balance can change, which then affects the next beginning balance.
B. Reconciled Transactions Were Edited, Deleted, Voided, or Unreconciled
A previously reconciled transaction is part of the history that supports your reconciliation. Changing that transaction can therefore affect later reconciliations. For example, the problem may result when:
- A reconciled transaction was deleted.
- A reconciled transaction was edited.
- A reconciled transaction was voided.
- A transaction was moved to another account.
- A previously reconciled transaction was manually unreconciled.
QuickBooks identifies these types of changes as causes of beginning-balance discrepancies in previously reconciled accounts. Suppose a $1,200 payment was reconciled in June and later edited to $1,500. The June reconciliation history has effectively changed, so the difference can carry into a later reconciliation. Instead of changing the new beginning balance manually, trace the change back to the original transaction.
C. Missing or Duplicate Transactions
A QuickBooks missing transactions reconciliation problem can occur when a transaction shown on the bank statement has not been recorded in the correct QuickBooks account. The opposite can also happen: QuickBooks may contain the same transaction twice. Common examples include:
- A payment appears on the bank statement but not in QuickBooks.
- A deposit was entered manually and also added from a bank feed.
- A transaction was downloaded but excluded.
- A transaction was categorized into the wrong account.
- A duplicate payment or deposit was recorded.
- Several bank transactions were combined differently from how they were recorded in QuickBooks.
Intuit identifies missing and duplicate transactions as common causes of ending-balance reconciliation issues. For this reason, compare the actual bank statement with the QuickBooks transaction list. Do not assume that everything on the bank statement must already be present simply because the bank account is connected.
D. Transactions in QuickBooks Have Not Cleared the Bank
Not every transaction entered in QuickBooks will appear on the current bank statement. For example, you may record a check on September 28, but the recipient may not deposit it until October. The check exists in QuickBooks, but it should not necessarily be included in the September bank reconciliation.
This is a normal timing difference. An uncleared transaction should not automatically be deleted simply because it is absent from the current statement. First check its date, amount, account, and the statement period you are reconciling. QuickBooks lists transactions that have not yet cleared the bank as one possible reason the ending balances do not match.
E. Previous Reconciliation or Adjustment Changed the Account
A reconciliation problem can also originate in an earlier period. For example, a previous reconciliation may contain an adjustment, or someone may have changed a transaction after that period was completed. The resulting difference can then appear during a later reconciliation. Incorrect statement dates can cause problems as well. If the wrong period is selected, transactions may appear to be missing or may be included when they should not be.
Do not use an adjustment simply to force the reconciliation to zero. An adjustment can make the numbers balance without identifying what actually caused the discrepancy. QuickBooks documentation treats adjustments as a corrective option only after the underlying issue has been investigated.
How to Fix QuickBooks Bank Reconciliation Issues
When QuickBooks reconciliation is not working, start with the records you can verify and move toward transaction-level investigation. Do not immediately undo the reconciliation or create an adjustment. The following sequence helps you isolate the problem without unnecessarily changing historical accounting data.
Step 1 — Confirm the Bank Statement and Reconciliation Details
First, make sure QuickBooks is being compared with the correct statement. Have the bank statement for the exact period available and verify:
- The correct bank or credit-card account.
- The statement beginning balance.
- The statement ending balance.
- The statement ending date.
- The transaction period covered by the statement.
Then compare the statement’s beginning balance with the beginning balance displayed in QuickBooks. Also record the exact QuickBooks reconciliation difference before making any changes. That number can provide an important clue. For example:
| What you find | Where to investigate next |
| Beginning balance is incorrect | Opening or previous reconciliation |
| Beginning balance is correct, but difference remains | Current transactions |
| Difference equals a specific transaction | That transaction’s history |
| Bank transaction is missing | Missing transaction or bank-feed status |
| QuickBooks has an extra transaction | Timing, duplicate, or incorrect entry |
QuickBooks Desktop specifically instructs users to verify the statement date, beginning balance, ending balance, and statement information before proceeding with reconciliation.
Step 2 — Determine Whether This Is a First-Reconciliation or Previous-Reconciliation Problem
This distinction is important because the investigation is different.
Scenario A: This is the first reconciliation
If you have never reconciled the account before, start with the opening balance. In QuickBooks Online, you can review the account register and locate the opening balance entry. Compare it with the real-world bank balance for the date you began tracking the account.
Also check whether transactions were incorrectly marked as reconciled before the first proper reconciliation. If the opening balance is wrong, correct the starting point using your actual accounting records before attempting to make the current reconciliation balance.
Scenario B: The account was reconciled successfully before
If the account reconciled correctly in the past, do not simply overwrite the beginning balance to make it agree with the bank statement. Instead, ask:
What changed after the last successful reconciliation?
- Edited transactions
- Deleted transactions
- Voided transactions
- Transactions moved to another account
- Transactions manually unreconciled
- Reconciliation adjustments
- Changes to bank-feed transactions
QuickBooks Online provides a Reconcile Discrepancy Report for identifying changes that affect a previously reconciled account.
Step 3 — Find the Transaction Causing the QuickBooks Reconciliation Discrepancy
Once you know whether the issue involves the current period or a previous reconciliation, investigate the transaction history.
QuickBooks Online
In QuickBooks Online, you can use the reconciliation discrepancy workflow to review changes affecting the beginning balance. The current workflow starts from:
All apps → Accounting → Reconcile
Select the relevant account and review the beginning-balance discrepancy information when QuickBooks identifies one. The Reconcile Discrepancy Report shows what changed and can help you determine how the change affected the balance. Review each suspicious transaction and its history. Do not automatically reverse every change you find. First determine whether the change was actually an error.
For additional history, use the Audit Log to investigate deleted or voided transactions and other changes. Also review the account register for transactions that may have been manually reconciled outside the normal reconciliation process.
QuickBooks Desktop
QuickBooks Desktop uses different reports and menu paths. You can review:
- Reports → Banking → Reconciliation Discrepancy
- Audit Trail
- Previous Reconciliation
- Appropriate missing-transaction reports
- Reconciliation adjustments
The Reconciliation Discrepancy report can help identify transactions that changed after a previous reconciliation. The Previous Reconciliation report lets you compare earlier reconciliation activity with your bank records. For every suspicious transaction, check:
- Date
- Amount
- Transaction type
- Whether it appears on the bank statement
- Whether it was previously reconciled
- Whether it was edited, deleted, voided, duplicated, or moved
- Whether the change amount explains some or all of the difference
The goal is to find the transaction or group of transactions that actually explains the discrepancy.
Step 4 — Fix Missing, Duplicate, or Incorrect Transactions
Once you identify transaction-level problems, correct the records based on the bank statement and your underlying accounting information.
Missing transactions
A transaction may be missing from the reconciliation for several reasons. It could be:
- Completely absent from QuickBooks.
- Downloaded but still waiting for review.
- Categorized into the wrong account.
- Excluded from the bank-feed workflow.
- Already recorded somewhere else.
- Affected by bank-feed timing.
In QuickBooks Online, downloaded transactions can appear in areas such as For Review, Categorized, or Excluded. Intuit also recommends checking the bank connection when expected downloaded transactions are missing.
Do not rely only on the bank-feed screen. Compare the actual bank statement with the QuickBooks account register. QuickBooks Online also does not download pending transactions through the normal bank-feed process, so a transaction that appears as pending at the bank may not yet be available in QuickBooks.
Duplicate transactions
For duplicate transactions, compare the date, amount, payee, and transaction type against the bank statement. Determine which record represents the legitimate transaction before removing anything.
A common cause is entering a transaction manually and then adding the same transaction again through the bank feed instead of matching it to the existing record. If the duplicate was already reconciled, be especially careful. Removing a reconciled transaction can affect the beginning balance of a later reconciliation.
Transactions that exist in QuickBooks but are not on the current statement
Do not automatically delete these transactions. They may be:
- Legitimate timing differences
- Uncleared checks
- Uncleared deposits
- Transfers that have not cleared
- Manually entered transactions
- Duplicate entries
- Transactions belonging to another period
Check the transaction date and previous bank statements before deciding that an entry is incorrect.
Step 5 — Correct the Reconciliation and Verify the Difference Is $0.00
After correcting the underlying problem, return to the reconciliation and verify the numbers again. Check:
- The beginning balance.
- The statement ending date.
- The statement ending balance.
- All legitimate statement transactions.
- Corrected duplicate or erroneous transactions.
- Previously reconciled transactions that were changed.
- The final reconciliation difference.
The difference should reach $0.00 when the QuickBooks records properly agree with the bank statement. After completing the reconciliation, review the reconciliation report and retain it with your accounting records.
Important: Do not use a reconciliation adjustment simply because the difference is inconvenient. An adjustment can hide the original problem instead of correcting it. Investigate the underlying transaction first. If an adjustment is genuinely appropriate and you are unsure about its accounting treatment, consider accountant guidance.
QuickBooks Beginning Balance Does Not Match
A QuickBooks beginning balance does not match problem deserves separate attention because it often points to an earlier issue rather than a simple current-period transaction.
1. If You Are Reconciling the Account for the First Time
If this is your first reconciliation, investigate the opening balance. In QuickBooks Online, the opening balance is the starting point for the account. Compare it with the actual bank balance for the date you began tracking the account.
Also check whether transactions were incorrectly marked as reconciled before you began the formal reconciliation process. Correct the starting information before trying to make the current statement balance.
2. If the Account Was Already Reconciled
When the account has reconciled successfully before, the expected beginning balance is tied to the prior reconciliation. Do not simply change the beginning balance to match the bank statement. Instead, investigate:
- Edited reconciled transactions
- Deleted reconciled transactions
- Voided transactions
- Moved transactions
- Unreconciled transactions
- Bank-feed changes
- Earlier reconciliation adjustments
QuickBooks Online’s current guidance specifically recommends using the Reconcile Discrepancy Report to identify changes affecting a previously reconciled account.
3. If the Difference Started After a Previous Reconciliation
Work backward from the last reconciliation that you know was correct. Compare that reconciliation with the current account history and identify the first change that explains the difference.
For example, if the last reconciliation ended at $18,400 but the next beginning balance is $18,150, look for changes totaling $250. The amount itself does not prove which transaction is wrong, but it gives you a useful starting point for your investigation.
QuickBooks Reconciliation Difference Is Not Zero
When the QuickBooks reconciliation difference is not zero, start with the statement details before changing transactions.
A. Check the Statement Date and Ending Balance
Make sure the statement date entered into QuickBooks exactly matches the bank statement. Then verify the ending balance digit by digit.
A wrong statement date can include or exclude transactions from the reconciliation period. A wrong ending balance can create a difference even when every transaction is recorded correctly. QuickBooks Desktop’s reconciliation workflow specifically instructs users to verify these details before proceeding.
B. Compare Every Statement Transaction With QuickBooks
Use the difference as a diagnostic clue rather than simply as a number that needs to disappear.
| What you see | What to investigate |
| Bank transaction missing in QuickBooks | Missing transaction or bank-feed status |
| QuickBooks transaction missing from bank statement | Timing or uncleared transaction |
| Same transaction appears twice | Duplicate entry |
| Beginning balance changed | Previously reconciled transaction changed |
| Difference appeared after an edit | Transaction history or audit information |
| Small unexplained difference | Continue investigating before considering an adjustment |
This comparison helps you narrow the problem without changing valid accounting records unnecessarily.
QuickBooks Reconciliation Discrepancy After Reconciliation
A QuickBooks reconciliation discrepancy after reconciliation is different from simply failing to balance during the current period. If an account reconciled correctly and later becomes out of balance, investigate what happened after that reconciliation.
1. Check for Changed Reconciled Transactions
Look for transactions that were:
- Edited
- Deleted
- Voided
- Moved
- Unreconciled
These changes can alter the ending balance of a previous reconciliation and therefore affect the beginning balance of a later one.
2. Review the Audit/Change History
In QuickBooks Online, use the Audit Log to investigate changes to transactions and determine who made a change when the available history supports that information.
Also review the transaction history associated with suspicious entries. If a transaction was deleted or voided, determine whether it belonged to a previously reconciled period before restoring or recreating anything. QuickBooks Desktop provides the Audit Trail, along with reconciliation-related reports, for investigating historical changes.
3. Check for Reconciliation Adjustments
An old reconciliation adjustment can continue affecting the account’s reconciliation history.
If you discover an adjustment, do not assume it is the correct solution simply because it exists. Determine why it was created and whether the underlying transaction problem was ever corrected.
QuickBooks Missing Transactions Not Showing in Reconciliation
When QuickBooks missing transactions are not showing in reconciliation, begin by determining whether the transaction is missing from QuickBooks entirely or simply has not reached the reconciliation screen.
A. Check Bank Transactions and Download Status
For QuickBooks Online, review the bank transaction areas for:
- For Review
- Categorized
- Excluded
Also check the account register and, where appropriate, update the bank connection. Downloaded transactions may require review and categorization before they are available for reconciliation. Intuit also notes that bank downloads can take time and that pending transactions are not downloaded through the normal bank-feed process.
B. Check Whether the Transaction Was Recorded Elsewhere
A transaction that appears to be missing may actually be recorded in the wrong place. Check for:
- The wrong bank account
- The wrong category or account
- An excluded transaction
- An uncategorized transaction
- A manually entered transaction
- A transaction already matched to another record
If you find the transaction in another account, correct its account assignment based on the underlying accounting records rather than creating another copy.
C. Compare With the Actual Bank Statement
The bank statement should remain the reference point for reconciliation. A bank-feed screen is useful for importing and reviewing transactions, but reconciliation is ultimately a comparison between your accounting records and the statement for the period.
If the bank statement shows a transaction that is genuinely absent from QuickBooks, investigate the transaction and record it correctly before trying to complete the reconciliation.
What to Do if a Reconciled Transaction Was Deleted
A QuickBooks reconciled transaction was deleted can affect subsequent reconciliations because that transaction may have contributed to the ending balance of the earlier period.
1. Confirm the Transaction Was Actually Deleted
In QuickBooks Online, review the Audit Log and transaction history to determine whether the transaction was deleted and when the change occurred.
Then determine whether the deleted transaction belonged to a previously reconciled period.
Do not recreate a transaction simply because the current reconciliation is showing a difference.
2. Determine the Effect on the Beginning Balance
If the deleted transaction was part of an earlier reconciliation, removing it can change the balance carried forward into a later reconciliation. Intuit identifies deleted, edited, voided, moved, and unreconciled transactions as causes of beginning-balance problems.
The amount of the deleted transaction can help explain the discrepancy, but you should still verify the original bank statement and accounting records.
3. Restore the Books Based on the Original Records
If the deletion was an error, restore the accounting records using the original transaction information and supporting documentation.
Do not invent a replacement transaction solely to force the reconciliation difference to $0.00.
If the correction affects a previously reconciled or historically important period, an accountant can help determine the appropriate correction while preserving the integrity of the books.
How to Undo a Reconciliation in QuickBooks
QuickBooks undo reconciliation should be treated as a situation-specific option, not the first response to every reconciliation difference. If you can correct one erroneous transaction without affecting the rest of the reconciliation, that may be less disruptive than undoing an entire period.
A. QuickBooks Online — Undo an Entire Reconciliation
In the current QuickBooks Online workflow, the process is:
- Sign in as the Primary Admin when required.
- Go to All apps → Accounting → Reconcile.
- Select History by account.
- Find the reconciliation you want to undo. You may need to change the report period.
- Open the Action menu.
- Select Undo.
- Review the warning.
- Confirm the undo operation.
Intuit states that undoing an entire reconciliation is irreversible and permanently deletes associated reconciliation reports and attachments, so save anything you need before proceeding. The scope can also be significant. Depending on the reconciliation being undone, subsequent reconciliations may be affected, so review the consequences before confirming the action.
B. QuickBooks Online — Unreconcile One Transaction Instead
There is an important difference between unreconciling one transaction and undoing an entire reconciliation. To remove a single transaction from a reconciliation in QuickBooks Online:
- Go to All apps → Accounting → Chart of accounts.
- Find the relevant account.
- Open View register.
- Locate the transaction.
- Select the transaction to expand it.
- Select the reconciliation-status box until the status changes from R to blank.
- Save the transaction.
QuickBooks cycles the status from reconciled to cleared and then to uncleared. Removing an individual transaction changes its reconciliation status but does not have the same scope as undoing the entire reconciliation. Only do this after confirming that the transaction is actually the source of the problem.
C. QuickBooks Desktop — Undo the Last Reconciliation
QuickBooks Desktop uses a different workflow. Before making a historical reconciliation change, create a backup of the company file. Then:
- Go to Banking → Reconcile.
- Select Undo Last Reconciliation.
- Confirm the operation.
- Review the affected transactions.
- Correct the underlying issue.
- Reconcile the affected period again.
QuickBooks Desktop’s standard workflow is designed around undoing the last reconciliation. If the problem originated in an older period, you may need to address reconciliations sequentially. Intuit also notes that undoing a previous reconciliation causes cleared transactions from that reconciliation to become uncleared and changes the beginning balance accordingly.
D. When You Should Not Undo a Reconciliation
Do not use undo simply because the current reconciliation difference is not zero. First investigate:
- The statement date
- Beginning balance
- Ending balance
- Missing transactions
- Duplicate transactions
- Uncleared transactions
- Changed reconciled transactions
- Previous adjustments
Also consider the effect on later reconciliations. For QuickBooks Desktop, maintain a backup before using the undo workflow. For complex historical corrections, particularly when several periods are affected, accountant review can help prevent additional changes to otherwise accurate records.
QuickBooks Online vs. QuickBooks Desktop Reconciliation Troubleshooting
The two products use different reports, menus, and undo workflows, so instructions should not be treated as interchangeable.
| Troubleshooting task | QuickBooks Online | QuickBooks Desktop |
| Investigate prior reconciliation changes | Reconcile Discrepancy Report | Reconciliation Discrepancy report |
| Review deleted or changed activity | Audit Log and transaction history | Audit Trail and related reports |
| Review prior reconciliation | Past/previous reconciliation information | Previous Reconciliation report |
| Undo full reconciliation | History by account → Undo | Banking → Reconcile → Undo Last Reconciliation |
| Investigate bank-feed activity | Bank Transactions workflow | Desktop Bank Feeds workflow |
| Advanced historical correction | Accountant review where appropriate | Backup and accountant review where appropriate |
QuickBooks maintains separate reconciliation guidance for Online and Desktop, and the current menu paths and available tools differ between the products. If you are creating documentation or screenshots, clearly label whether the instructions apply to QuickBooks Online or QuickBooks Desktop.
How to Prevent Future QuickBooks Reconciliation Problems
A good reconciliation process is not only about fixing today’s discrepancy. It is also about making future discrepancies easier to identify.
1. Reconcile Accounts Regularly: Regular reconciliation can help you identify problems while the transaction history is still easy to review. Compare your QuickBooks records with bank and credit-card statements consistently instead of allowing multiple periods to accumulate. QuickBooks recommends reconciling accounts regularly.
2. Match Bank-Feed Transactions Instead of Creating Duplicates: When a downloaded transaction corresponds to an existing QuickBooks entry, match the records rather than creating another transaction. This is particularly important when payments, deposits, or expenses have already been entered manually.
3. Review Changes to Previously Reconciled Transactions: Be cautious when editing or deleting transactions from previously reconciled periods. If a historical transaction genuinely needs to be changed, understand that the change can affect later reconciliation balances.
4. Keep Bank Statements and Reconciliation Reports: Retain your bank statements and completed reconciliation reports according to your normal recordkeeping practices. Having the original statement and reconciliation report makes it much easier to determine what changed when a historical discrepancy appears.
5. Avoid Using Reconciliation Adjustments to Hide Errors: A reconciliation adjustment should not become a routine way to make the difference disappear. If the adjustment does not have a clear accounting reason, continue investigating the underlying transaction instead. QuickBooks documentation warns that an adjustment does not fix the original error.
Conclusion
A QuickBooks bank reconciliation issue should be diagnosed before you adjust or undo anything. Start by verifying the bank statement, statement date, beginning balance, and ending balance. Then determine whether the problem comes from the opening balance, a previous reconciliation, missing or duplicate transactions, uncleared transactions, or a changed reconciled transaction.
Once you identify the cause, correct the underlying record and confirm that the reconciliation difference reaches $0.00. Keep in mind that QuickBooks Online and QuickBooks Desktop use different diagnostic reports and undo workflows, so always follow the instructions for the product you are using. For complex historical reconciliation problems that affect multiple periods, professional accounting guidance can help you correct the records without creating additional discrepancies.
FAQs Based on QuickBooks Bank Reconciliation Issue
Yes. QuickBooks Online Simple Start supports account reconciliation. If you encounter a reconciliation problem, the same basic process applies: compare the account with the bank statement, verify the beginning and ending balances, and investigate transaction differences. Current Intuit guidance includes Simple Start among the QuickBooks Online plans that support reconciliation.
Yes. QuickBooks Online Essentials includes reconciliation features. It also includes reconciliation reports and the Audit Log, which can help when you need to investigate historical changes affecting an account.
Yes. QuickBooks Online Plus supports bank reconciliation. Plus also includes the AI-powered reconciliation feature, which can compare uploaded bank-statement information with QuickBooks transactions.
QuickBooks Online Advanced uses the same core reconciliation workflow, but it supports additional reconciliation capabilities, including AI-powered reconciliation. The AI-powered feature can extract information from an uploaded statement and compare it with transactions already recorded in QuickBooks.
AI-powered reconciliation is currently available in QuickBooks Online Plus, QuickBooks Online Advanced, and Intuit Enterprise Suite. If you use Simple Start or Essentials, you may not see this particular reconciliation option because it is not included in those plans.
QuickBooks Online Accountant has accountant-focused reconciliation capabilities, including workflows for handling client reconciliations. However, the exact options available can depend on the accountant’s access and the client’s QuickBooks Online subscription. If a historical reconciliation requires significant corrections, review the client file carefully before undoing or changing previous reconciliations.
QuickBooks Online Ledger is listed among QuickBooks Online products with reconciliation support. However, the available accounting and reporting features differ from the full QuickBooks Online business plans. If a reconciliation problem involves a feature that is unavailable in Ledger, check the product-specific workflow rather than following instructions intended for Plus or Advanced.
QuickBooks offers different product configurations, and reconciliation capabilities can vary by subscription and product version. Current Intuit documentation lists QuickBooks Online Free and Lite separately from Simple Start, Essentials, Plus, and Advanced. If the reconciliation option is missing from your account, verify the exact product you’re using before attempting another troubleshooting method.
Yes. QuickBooks Desktop Pro Plus supports bank reconciliation. The Desktop workflow differs from QuickBooks Online, including the menus used to begin a reconciliation and investigate discrepancies. Intuit’s current Desktop reconciliation documentation specifically includes Pro Plus.
