Unreconciled transactions in QuickBooks are transactions that have not been matched and confirmed against a bank or credit card statement. To fix them, compare each transaction to the bank statement, identify whether it was missed, duplicated, edited, deleted, or incorrectly marked, and then correct the transaction before reconciling the account again.
Reconciliation problems are particularly risky because they affect your cash balances, financial reports, and tax preparation. A QuickBooks file that looks complete can still be inaccurate if transactions were never properly reconciled.
An unreconciled transaction exists in QuickBooks but has not been finalized against a bank or credit card statement. It may show up in your account register, but it has not been confirmed as matching a real statement entry.
QuickBooks tracks three reconciliation statuses for every transaction. Understanding the difference is the first step toward fixing the problem.
| Status | What It Means | Why It Matters |
| Blank (no mark) | The transaction has not been cleared or reconciled | It has not been matched to a statement at all |
| Cleared (C) | The transaction appears to have cleared the bank | It has been matched to a bank feed but not finalized in a completed reconciliation |
| Reconciled (R) | The transaction was included in a completed statement reconciliation | It is the most reliable status — the transaction has been confirmed against a statement |
A transaction can sit in your register for months or years without ever being reconciled. That does not mean the transaction is wrong — it means it has not been verified.
Cleared means a transaction appears to have passed through the bank. Reconciled means it was included in a completed, statement-by-statement reconciliation. These are not the same thing, and confusing them is one of the most common bookkeeping mistakes in QuickBooks.
Here is the distinction in plain terms:
Bank feed matching is not reconciliation. When QuickBooks automatically pulls in transactions from your bank and matches them, it marks them as cleared. But unless you have completed a formal reconciliation against a statement, those transactions are not reconciled.
Example: A payment may appear in the bank feed and be marked cleared, but if it was never included in a completed reconciliation, the account may still not be fully reconciled. The ending balance may look close, but the underlying records are not verified.
Transactions are unreconciled in QuickBooks for many reasons, including wrong dates, wrong amounts, duplicate entries, deleted transactions, or reconciliations that were never completed in the first place.
Common causes include:
Most common causes in practice: Edited or deleted reconciled transactions and duplicate entries from bank feeds. These tend to cause the most downstream damage because they affect prior completed reconciliations.
Unreconciled transactions often surface during catch-up bookkeeping or QuickBooks cleanup. If bank accounts have not been reviewed month by month, small errors can accumulate and compound over time.
Unreconciled transactions make your financial records unreliable. They can cause incorrect balances, duplicate income or expenses, inaccurate reports, and tax preparation errors.
Specific problems caused by unreconciled transactions:
If you recognize more than one of these, your books likely need a formal review before you rely on the numbers.
Open the account register in QuickBooks, review the reconciliation status column, and look for transactions with a blank status or an unexpected cleared (C) mark where you expected a reconciled (R) mark. Then compare those transactions against your bank statements.
Here is the general process:
Caution: Do not randomly change reconciliation status marks just to make the screen balance. Changing old transactions without understanding the source of the problem can create larger cleanup issues and affect prior periods.
Compare the transaction to the bank statement, identify the specific error (wrong date, wrong amount, duplicate, deleted, edited), correct the source problem, and then reconcile again. Do not force the reconciliation to close without addressing the actual issue.
The bank statement is usually the source of truth for reconciliation purposes. Find the corresponding entry on the statement and compare it to what is in QuickBooks.
Wrong dates can put transactions in the wrong reconciliation period. A payment dated December 31 instead of January 1 can affect two separate reconciliations.
Even a small difference — a few cents or a few dollars — can prevent reconciliation from closing. Compare the exact dollar amount on the statement to the QuickBooks entry.
Duplicates often happen when a transaction is manually entered and then added again from the bank feed. If you see two entries for the same amount on the same date, one is likely a duplicate.
Wrong categories may not directly break reconciliation, but they can affect your financial reports and tax preparation. If the amount and date are correct but the category is wrong, correct it while you are reviewing the transaction.
If a previously reconciled transaction was edited or deleted after the reconciliation was completed, that change can throw off the next reconciliation’s beginning balance. Use the audit log to check.
Fix the actual source of the problem. Do not simply force a reconciliation adjustment to close the difference. That approach hides the problem instead of solving it.
After making corrections, return to the reconciliation screen and verify that the ending balance now matches your bank statement.
Add a memo or note to the corrected transaction explaining what changed and why. This is especially helpful if another bookkeeper, accountant, or tax preparer reviews the file later.
Your beginning balance in QuickBooks changes when something in a prior reconciled period is modified. This is a major warning sign. Stop and identify what changed before you reconcile the next month.
The beginning balance for any reconciliation should match the ending balance from the last completed reconciliation. If it does not, something was changed after that reconciliation was closed.
Common causes:
Example: A check was originally reconciled for $228.75. Later, someone changed it to $248.75. That $20 change will cause the beginning balance for the next reconciliation to be off by $20. If that month was also reconciled without catching the change, the error can carry forward into future months.
If your beginning balance changed, do not attempt to force the next reconciliation. Find the source of the change first.
Use the reconciliation discrepancy report, prior reconciliation reports, and the audit log to identify what changed after a reconciliation was completed.
| Tool | What It Helps You Find |
| Reconciliation report | Which transactions were included in a specific completed reconciliation |
| Reconciliation discrepancy report | Transactions that were changed after a reconciliation was completed |
| Audit log | Who changed a transaction, when they changed it, and what was changed |
| Account register | Current state of all transactions in the account |
| Bank statement | The source of truth for what actually cleared the bank |
Compare what was in the completed reconciliation report to what is in the register now. Discrepancies will usually reveal which transaction was changed.
If a reconciled transaction was edited after the reconciliation was completed, it can change the beginning balance for the next period.
The best fix is usually to restore the correct amount, date, or details and then review the affected reconciliation.
What to do:
Example: If a reconciled payment was changed from $500 to $550, QuickBooks may show a $50 discrepancy in the next reconciliation’s beginning balance. Simply ignoring it and forcing the next reconciliation will carry the error forward.
Deleting a reconciled transaction will cause prior reconciliations to become inaccurate. Use the audit log to identify the deleted transaction, then recreate it using bank records or source documents.
What to do:
Caution: Do not recreate deleted transactions from memory. Use bank statements, receipts, invoices, or payment records. Recreating the wrong amount or date will not solve the underlying problem.
If a transaction was manually marked as reconciled (R) when it should not have been, it can make a completed reconciliation look correct when it is not. Before removing the R status, confirm whether the transaction actually belongs to a completed reconciliation period.
What to do:
Note: If tax returns have already been filed using records that include this transaction, be extra careful before changing old reconciliation statuses. In some cases, it is better to work with a bookkeeper or accountant before adjusting historical records that were used for tax purposes.
A reconciliation adjustment means the account was forced to balance even though the transactions did not fully match the bank statement. Adjustments hide the underlying problem and should be reviewed before you rely on the books.
Reconciliation adjustments are created when a user clicks through a reconciliation without resolving the difference. QuickBooks creates a journal entry to force the balance to zero. That journal entry is the adjustment.
Problems caused by adjustments:
Better approach: Instead of accepting an adjustment, stop and identify the real cause. Ask:
If you have old reconciliation adjustments in your QuickBooks file, a cleanup bookkeeper should review them before you rely on your financial reports.
Undoing an entire reconciliation is usually only necessary when the whole reconciliation was done incorrectly or many transactions are affected. If only one transaction caused the problem, fixing that transaction directly is usually a better first step.
Undoing old reconciliations — especially multiple months or years — can create significant additional cleanup work. It should be done carefully and, in most cases, with the help of a bookkeeper.
| Situation | Better First Step |
| One transaction was changed after reconciliation | Fix the transaction; reconciliation may self-correct |
| One reconciled transaction was deleted | Recreate the transaction from bank records |
| A duplicate transaction exists | Delete the duplicate; verify reconciliation still balances |
| Many months were reconciled incorrectly | Get help before undoing anything — scope the full cleanup first |
| Beginning balance is off and cause is unknown | Find the source before undoing any reconciliation |
| Multiple years are unreconciled | Work with a bookkeeper on a structured catch-up process |
Undoing a reconciliation does not fix the underlying problem. It only removes the completed status. The original error still needs to be identified and corrected.
Do not delete unreconciled transactions unless you are certain they are duplicates or incorrectly entered.
Some unreconciled transactions are legitimate — they may be outstanding checks, deposits in transit, or transactions that belong to a future period.
When deletion may be appropriate:
When deletion is risky:
Deleting valid transactions will make your reports inaccurate and create new reconciliation problems.
Yes. Unreconciled transactions can affect your taxable income, deductible expenses, and financial reports. If your books are not reconciled, your tax return may be based on incomplete or inaccurate numbers.
Specific tax risks:
Businesses should reconcile all bank and credit card accounts before filing taxes whenever possible. If you are preparing to file and your books are not reconciled, address the reconciliation problems first — or get help doing so.
OneBooks does not prepare income-tax returns, but we do get the books ready for filing: we reconcile the accounts, correct bookkeeping errors, and prepare tax-ready financial reports for your CPA or tax preparer. See Catch-Up Bookkeeping Before Filing Taxes.
You can fix simple unreconciled transactions yourself if the issue is easy to verify against the bank statement. If the problem affects prior periods, tax-filed years, multiple accounts, or many transactions, it is safer to work with a bookkeeper.
The risk of trying to fix complex reconciliation problems without experience is creating additional errors that require more cleanup later.
Get professional help when the reconciliation problem affects historical records, prior tax returns, multiple accounts, or many transactions.
The more periods affected, the higher the risk of making the problem worse on your own.
Signs you need outside help:
OneBooks helps small businesses with catch-up bookkeeping, QuickBooks cleanup, monthly reconciliation, and fixing messy QuickBooks files before tax season. If your file is behind or inaccurate, that is exactly the type of work we do.
OneBooks reviews your QuickBooks file, identifies unreconciled accounts and problem transactions, compares records to bank and credit card statements, corrects errors, and reconciles each account month by month.
Our process:
We work in your existing QuickBooks file. We do not require you to start over or set up a new company file in most cases.
OneBooks is a U.S.-based bookkeeping firm that helps small businesses restore and maintain accurate financial records. Our services include catch-up bookkeeping, QuickBooks cleanup, and ongoing monthly bookkeeping for businesses across the United States.
Still got questions? Check out our dedicated FAQ page.
Yes. OneBooks specializes in QuickBooks cleanup and catch-up bookkeeping.
We review QuickBooks files, identify unreconciled accounts and problem transactions, compare records to bank and credit card statements, correct errors, and reconcile each account month by month.
We also offer monthly bookkeeping to keep books current going forward. Book a discovery call to discuss your situation.
Unreconciled means a transaction exists in QuickBooks but has not been verified against a bank or credit card statement as part of a completed reconciliation.
A transaction can appear in your account register and still be unreconciled if it was never included in a formal statement reconciliation.
Cleared (C) means the transaction appears to have passed through the bank, often through automatic bank feed matching.
Reconciled (R) means the transaction was included in a completed, statement-by-statement reconciliation. Bank feed matching does not equal reconciliation.
Your reconciliation balance changed because something in a prior reconciled period was modified.
A transaction may have been edited, deleted, or had its reconciliation status manually changed after the reconciliation was completed.
Use the audit log and reconciliation discrepancy report to identify what changed.
Your beginning balance is off because something changed in a prior completed reconciliation.
The most common causes are an edited reconciled transaction, a deleted reconciled transaction, or a manually removed reconciliation status.
Stop and identify the source before moving forward with the next reconciliation.
Bank and credit card accounts should be reconciled every month, ideally within a few weeks of the statement closing date.
Monthly reconciliation helps catch errors while they are still easy to trace and prevents small problems from compounding over time.
Yes. Both bank accounts and credit card accounts should be reconciled every month. Credit card accounts are just as important as bank accounts — unreconciled credit card activity can cause duplicate expenses, missed expenses, and inaccurate liability balances on the balance sheet.
Yes. Reconciliation statuses can be manually changed in the account register.
If a transaction was marked reconciled (R) without being part of a completed reconciliation, it can make reports look accurate when they are not.
Check the reconciliation report for the period to confirm the transaction was actually included.
Start by gathering bank and credit card statements for all unreconciled months.
Then reconcile each month in order, starting with the earliest period. Do not skip months or reconcile out of order.
If the task feels overwhelming or the file has other problems, consider working with OneBooks.
Certified
QuickBooks ProAdvisor
Founder/Managing Partner
Robert Mitchell is the founder of OneBooks, a virtual bookkeeping firm specializing in catch-up bookkeeping, bookkeeping cleanup, QuickBooks cleanup, and monthly bookkeeping services for small businesses throughout the United States.
With more than 40 years of business, finance, and operations experience, Robert helps business owners organize financial records, reconstruct historical bookkeeping, and maintain tax-ready financials for their CPA and tax professionals.
Connect with me on LinkedIn
Book a Discovery Call with Bob and see if OneBooks is right for your business.
