How to Undo a Reconciliation in QuickBooks Online

You close the books on the 3rd, reconcile the operating account, and everything ties out to the penny. Then on the 9th a client emails about a payment you already marked as cleared, you open the register, and there it is: a duplicate deposit the bank feed pulled in twice. The reconciled balance is wrong, last month's P&L is wrong, and now you have to walk the reconciliation back before you can fix anything.

The frustrating part is that QuickBooks Online makes this harder than it should be, and how hard depends entirely on which version you are in. That one-click undo you have seen in tutorials is not in every account. Get the wrong one and you either create hours of needless rework or leave the books quietly broken, so start with the version you are actually in.

First decide: undo the whole thing, or unreconcile a few transactions

Before you touch anything, be honest about the size of the problem. Most of the time you do not need to undo an entire reconciliation. You need to fix three or four transactions that got matched wrong.

Undoing the full period wipes the reconciled status off every transaction in it. If you reconciled 200 lines and only two are wrong, you just created 198 lines of rework for yourself. That is the single most common mistake here, and it usually happens because the full undo button is the one that shows up first in search results.

So sort it into one of two buckets:

• A handful of bad transactions (a duplicate, a wrong category that does not affect the balance, one payment matched to the wrong invoice). Unreconcile those individually. Leave the rest alone.
• A structurally broken reconciliation (wrong opening balance, wrong statement ending balance, wrong bank account, or a reconciliation done against the wrong month). Here the whole period is compromised and a full undo is the honest fix.

The method you use depends on that call and on your QuickBooks version. Full undo is an Accountant-only move.

How to undo a full reconciliation in QuickBooks Online Accountant

If you have QuickBooks Online Accountant, or your bookkeeper does, you get the batch undo. It reverses the entire reconciliation session in one action, per Intuit's support documentation.

1. Open the client's company file in QuickBooks Online.
2. Go to Accounting, then select Reconcile.
3. Select History by account.
4. Choose the account and the date range for the reconciliation you want to remove.
5. Find that reconciliation in the list. In the Action column, open the dropdown and select Undo.
6. Confirm with Yes, then Undo.

QuickBooks flips every transaction in that period from reconciled (R) back to cleared (C) and reopens the period. It does not delete transactions and it does not touch amounts. It only strips the reconciled flag so you can start the period over.

One warning that trips people up: if you undo a period, every reconciliation stacked on top of it can be affected, because balances carry forward. Undoing June when July and August are already reconciled means you are likely re-checking three months, not one. Undo from the most recent period backward, not from the middle.

How to unreconcile transactions in regular QuickBooks Online

Here is the part the tutorials gloss over. If you are on a standard QuickBooks Online plan without accountant access, there is no full-undo button. Intuit ties the batch undo to QuickBooks Online Accountant. Standard users unreconcile one transaction at a time in the register, per Intuit's help article on removing transactions from reconciliations.

To unreconcile individual transactions:

1. Go to Accounting, then Chart of accounts.
2. Find the bank or credit card account and select View register (also labeled Account history).
3. Locate the transaction that shows R in the checkmark column.
4. Select the transaction to expand it, then click the checkmark field. It cycles R to C to blank. Click until it is blank (or C if you only want it cleared, not reconciled).
5. Select Save.
6. Repeat for every transaction you need to remove from the reconciliation.

For three transactions, that is a minute of work. For a whole month, it is a slow, error-prone slog, and every click is a chance to leave one line half-changed. If you find yourself doing this across a full period, that is the signal to loop in someone with Accountant access rather than grind through 150 lines by hand.

The half-cleared trap

The checkmark cycles through three states, not two: reconciled, cleared, and blank. Clearing a transaction to C is not the same as unreconciling it, and a transaction stuck at C still shows as matched in the bank feed while no longer counting as reconciled. If your next reconciliation opens with a discrepancy you cannot explain, check for transactions you left at C by accident.

What quietly breaks when you undo a reconciliation

Reversing a reconciliation is not a clean rewind. A few things move that you will not see unless you go looking.

• The opening balance shifts. The next reconciliation's beginning balance is the last one's ending balance. Undo a period and the following period's opening balance changes, which can throw a reconciliation that was previously clean.
• Reports you already sent are now stale. A P&L or balance sheet exported before the undo no longer matches the file. If that report went to a lender, an investor, or a tax preparer, you need to reissue it, not just fix it quietly.
• Reconciliation discrepancy reports pile up. Editing or deleting a previously reconciled transaction generates a discrepancy QuickBooks tracks. Undoing and redoing without understanding the original discrepancy usually recreates the same break.
• Audit trail noise. Every undo and redo is logged. Auditors and reviewers read that log, and a month reconciled three times in a week raises a question you will have to answer.

Take a snapshot before you undo anything: export the reconciliation report for the period and note the ending balance. If the redo does not land on the same number, you have a real discrepancy to hunt, not a reconciliation to repeat.

Why you keep needing to undo reconciliations

Undoing a reconciliation is almost never a QuickBooks problem. It is a symptom of something upstream feeding bad data into the books. The recurring causes are boringly consistent: duplicate transactions from a bank feed that double-pulls, payments matched to the wrong invoice because the memo field is ambiguous, a Shopify or Stripe payout landing as one lump sum that nobody split back out, or a month-end done by hand under time pressure with copy-paste doing the reconciling.

Fix the upstream feed and the undos mostly stop. This is what we build at bottta, and it is where a studio build beats another spreadsheet macro.

• Integrations. A clean sync between the payment processor, the sales platform, and QuickBooks that posts each transaction once, with the invoice, customer, and category already attached, so the bank feed is confirming reality instead of inventing duplicates. Our Shopify QuickBooks integration playbook walks through what that looks like for e-commerce payouts specifically.
• AI Automation. LLM-based matching and extraction for the messy cases: reading a payout statement, splitting a lump deposit into its line items, and flagging the ambiguous match for a human instead of guessing wrong. See how we think about AI for accountants before you hand any of this to a model.
• Custom Builds. A pre-reconciliation check that runs before you ever open the Reconcile screen, catches duplicates and unmatched transactions, and hands you a clean register. This connects to the broader account reconciliation software picture and the wider case for accounting automation software.

We scope this as a $4K fixed-price project when it is one well-defined workflow, like cleaning up a Stripe-to-QuickBooks feed with integrations included and 30 days of post-launch support. When the books touch several systems and need ongoing monitoring as volume grows, the $3K/month retainer covers up to three active workflows with the fixes and check-ins that keep a reconciliation clean month after month. No free tier, because none of this is a button you flip on.

When to fix it yourself vs bring in bottta

Some of this genuinely does not need us. Take the honest split.

Do it yourself when: you have a handful of bad transactions, you or your bookkeeper have Accountant access, and the cause is a one-off (a manual entry error, a single duplicate). Unreconcile the affected lines, redo the period, move on.

Bring in help when: you are undoing reconciliations most months, the same duplicate pattern keeps returning, a lump payout from Shopify or Stripe never splits cleanly, or month-end is a manual fire drill that eats a day. That is not a QuickBooks skill gap. It is a missing integration, and grinding through the register by hand every month costs more than fixing the feed once.

DIY tools have a place at the edges. A Zapier or Make scenario can de-duplicate a simple feed, and if your volume is low and your data is clean, that may be all you need. They tend to break the moment the mapping gets conditional, a payout needs splitting, or a match needs judgment. That is the wall most operators hit, and it is where a built-and-monitored workflow earns its keep.

Frequently asked questions

Can I undo a reconciliation in QuickBooks Online without QuickBooks Online Accountant?

Not as a single action. Standard QuickBooks Online has no batch undo. You unreconcile transactions one at a time in the account register by clicking the checkmark field until it is blank, per Intuit's help article. To undo a whole period at once, you or your bookkeeper need Accountant access.

Does undoing a reconciliation delete my transactions?

No. Undo only removes the reconciled status. The transactions stay in the register with their amounts and details intact. They revert from reconciled (R) to cleared (C), and you can reconcile them again later.

Why is my next reconciliation off after I undid the previous one?

The opening balance of each reconciliation is the ending balance of the one before it. When you undo a period, the following period's beginning balance changes, and any reconciliation stacked on top can fall out of balance. Work backward from the most recent period when you undo, and re-check every period above the one you reversed.

What is the difference between R and C on a transaction?

R means reconciled: the transaction was matched during a completed reconciliation. C means cleared: it has hit the bank feed but has not been through a reconciliation. Leaving a transaction at C when you meant to blank it out is a common cause of an unexplained discrepancy in your next reconciliation.

How do I stop needing to undo reconciliations every month?

Fix the source of the bad data. Recurring undos usually trace to a duplicating bank feed, a payout that never gets split, or a manual month-end. A clean integration that posts each transaction once, plus a pre-reconciliation check for duplicates, removes most of the cause. That is the kind of workflow bottta designs and builds.

The next time you are staring at a reconciliation you have to walk back, treat it as a flag, not a chore. One bad transaction is a fix. A monthly pattern is a broken feed, and fixing the feed once costs less than grinding through the register every month. Book a call with bottta to close the gap the duplicates are slipping through.