How to Undo a Bank Reconciliation in QuickBooks Online
Convert a PDF bank statement to a QuickBooks file
Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.
Short answer: Undoing an entire reconciliation in a single action is only available in QuickBooks Online Accountant. Open the client company through Accountant, go to Reconcile, then History by account, find the reconciliation, and choose Undo from the Action column. A standard QuickBooks Online user has no such button and has to unreconcile transaction by transaction in the account register, changing each status from R back to blank. Either way, undoing deletes the saved reconciliation report and anything attached to it, and it moves the beginning balance of every month that came after.
Almost nobody looks for this on a good day. You are here because a month that closed cleanly turned out to be wrong, or because you inherited a file where somebody reconciled a year of transactions against nothing in particular, or because the beginning balance is off by an amount that refuses to explain itself. Before you undo anything, it is worth knowing exactly what the button does, because it is more destructive than it looks and it is very often the wrong tool for what is actually broken.
Which undo method applies to you
| Your access | What you can undo | Where |
|---|---|---|
| QuickBooks Online Accountant, opening a client file | A whole reconciliation period in one action | Accounting, Reconcile, History by account, Action, Undo |
| Standard QuickBooks Online, including Accountant view | One transaction at a time | The account register, checkmark column |
| QuickBooks Desktop, any edition | The most recent reconciliation only | Banking, Reconcile, Undo Last Reconciliation |
| QuickBooks Desktop, older periods | Repeat the undo, newest first, one period per pass | Same screen, run it again |
Who can undo a reconciliation in QuickBooks Online?
Only a user working in QuickBooks Online Accountant can undo a full reconciliation in one step. That is the whole rule, and it is the reason so many people go looking for a menu item that is not on their screen. The Undo option lives in the accountant toolset, so it appears when a firm opens a client file from the Accountant dashboard, and it does not appear for the business owner or bookkeeper signed directly into the company.
If you have an accountant on the file, the fastest route is to ask them, and it costs them under a minute. If you do not, you are not stuck. The register method below achieves the same result, and it is genuinely better when only part of a month is wrong, because it leaves everything correct untouched.
One more limit is worth knowing before you start. Undoing a reconciliation clears the status on transactions that were reconciled by that reconciliation. Transactions somebody marked R by hand in the register were never part of a reconciliation, so they are not affected and will keep quietly propping up a beginning balance you thought you had reset. In files that have been cleaned up before, hand-marked transactions are a common reason an undo does not appear to have worked.
How to undo a reconciliation in QuickBooks Online Accountant
Open the client's company file from QuickBooks Online Accountant rather than signing into it directly, because the option is missing otherwise. Then:
- Go to Transactions and select Reconcile. In newer QuickBooks Online layouts the same screen sits under All apps, then Accounting, then Reconcile.
- Select History by account in the top right.
- Choose the account and a date range that includes the reconciliation you want to reverse.
- Download the reconciliation report first, along with any attachments saved with it. Undoing removes them permanently, and if anyone later asks how that month was closed, the report is the only evidence.
- In the Action column, open the dropdown next to View report and select Undo. Confirm when QuickBooks asks.
You can only undo one reconciliation at a time. If you need to reverse several consecutive months, undo them individually and work through the whole run rather than stopping partway, because a gap in the middle is worse than either end state.
How to unreconcile transactions in QuickBooks Online without an accountant
The register method is available to every QuickBooks Online user and works on any number of transactions from one to all of them. It is slower for a whole month and faster for a handful.
- Go to Transactions, then Chart of accounts, and select View register on the account.
- Find the transaction you need to unreconcile. Filtering the register by date or amount saves a lot of scrolling.
- Select the transaction to expand it, then click the checkmark column that currently shows R. Clicking cycles the status, so click until the field is blank.
- Save the transaction and confirm the warning QuickBooks raises about changing a reconciled entry.
- Repeat for each transaction, then reopen Reconcile and check that the beginning balance now shows what you expected.
The warning message deserves a moment rather than a reflexive click. QuickBooks raises it because unreconciling changes a period somebody already signed off on, and if that period is inside a closed book or a filed tax year, the right fix is usually an entry in the current period instead. Ask what changed and when before you agree to reopen history.
What happens when you undo a reconciliation in QuickBooks?
Three things, and the second one surprises people most.
Your transactions survive. Undoing a reconciliation does not delete, alter or move a single transaction. It only removes the reconciled status, so the amounts, dates, payees and categories are all exactly as they were. Nothing about your profit and loss changes.
Every later month shifts. QuickBooks does not store a beginning balance, it calculates one from every transaction currently marked reconciled in that account. Take the R off a month in the middle of the year and the beginning balance of the next reconciliation changes with it, which is why the fix for one month can make the following six look broken. This is also why undoing several months and re-reconciling from the earliest one forward is the only order that ends well.
The paperwork is gone. The reconciliation report for the undone period is deleted, and so is anything attached to it, which is why downloading first is step four above rather than an afterthought. Reports you already exported elsewhere still exist, but they now describe a state the file is no longer in, so they need reprinting once the month is closed again.
When you should not undo a reconciliation
Most of the time. Undoing is the right move for a genuinely bad reconciliation: a month closed against the wrong statement, a period forced to balance with an adjusting entry nobody can explain, or a run of months reconciled by someone who was ticking everything to make the screen go green. Those need reversing because the reconciliation itself was never true.
It is the wrong move for a single wrong transaction. If one payment was categorized to the wrong account or entered for the wrong amount, fix that transaction. Unreconcile just that line if you must, correct it, and mark it back to R. Reversing a whole month to reach one entry destroys the report and disturbs every period after it, for no gain.
It is also the wrong move when the real problem is missing data. A reconciliation that will not balance because a quarter of transactions were never imported is not a reconciliation error at all, and undoing earlier months will not produce the transactions. Import the missing period first, and often the month you were about to undo turns out to have been fine.
How do I undo a reconciliation in QuickBooks Desktop?
QuickBooks Desktop handles this differently and, for once, more generously. Open the Reconcile window for the account and choose Undo Last Reconciliation, which reverses the most recent period without any accountant-only restriction. The catch is in the name: you can only walk backwards from the latest one, so reaching a reconciliation from eight months ago means undoing the seven that followed it, in order.
Desktop also prompts you to back up the company file before it proceeds. Take the backup. It is the one moment in this whole process where a bad decision is completely reversible, and restoring a file is far quicker than reconstructing a year of reconciliations by hand.
What to do after you undo a reconciliation
Undoing is the easy half. Redoing the month correctly is where the time goes, and the sequence matters.
Start by fixing whatever caused the problem, not by reopening the Reconcile screen. Run the reconciliation discrepancy report from the beginning balance warning and clear every change it lists. If the trouble is duplicates from a bank feed that was connected twice, remove the duplicates before reconciling, or you will simply reconcile the same mess into a new month.
Then confirm the register is complete for the period. This is the step people skip, and it is the most common reason a redone reconciliation refuses to balance for a second time. Bank feeds hand QuickBooks roughly ninety days of history when an account is first connected, so any month older than that arrived only if someone imported it. Compare the transaction count on the statement against what is in the register for the same dates. If the register is short, the transactions were never there, and no amount of reconciling will conjure them.
That gap is filled from the statements themselves. Converting a PDF bank statement into a QBO file gives QuickBooks the same kind of file it accepts from a bank download, so the missing month lands in For Review, gets categorized, and becomes reconcilable. The full QuickBooks Online bank reconciliation walkthrough covers the rebuild and the reconcile together, which is the order to do them in. Firms that have to do this across several clients at once often pair it with automated account reconciliation for the high-volume accounts and keep the statement-by-statement method for everything else.
Finally, reconcile forward one statement at a time from the earliest undone month. Do not jump to the current month and work back. Each period's beginning balance is built on the one before it, so reconciling out of order produces mismatches that are entirely artificial and waste an hour proving they were never real.
Can I undo a reconciliation from a previous year?
Technically yes, and you should think hard first. If the year has been reported to the IRS or given to a lender, changing the reconciled state of it means the books no longer agree with what was filed. The reconciliation status by itself does not alter any number on a return, but people rarely stop at the status, and the corrections that follow do change balances.
If the prior year genuinely was reconciled wrongly, involve whoever prepared the return before you touch it. If the goal is only to correct a current error whose root is in an old period, ask whether an entry dated today can achieve the same thing. Most of the time it can, and the closed year stays closed.
Why does my beginning balance change after undoing a reconciliation?
Because that is exactly what undoing does. The beginning balance for any reconciliation is the sum of every transaction in that account still marked R. Removing the R from a month's worth of transactions removes them from that sum, so the next month opens on a different figure. It is not a bug and it does not mean the undo went wrong.
What it does mean is that a partial undo leaves the file in a state nobody can reconcile. If you have undone March, you cannot sensibly reconcile September until March through August are done again in order. Plan the work as a run rather than a single fix, and if that run is long, this is the point to ask an accountant with the one-click Undo whether the file would be better rebuilt from the statements instead.
Why won't my reconciliation undo, or why is the Undo option missing?
Nine times out of ten it is the access question: you are in standard QuickBooks Online rather than QuickBooks Online Accountant. Switching to Accountant view inside a normal company is not the same thing and does not add the button. The other common causes are that History by account is showing a different account, that the date filter is hiding the period, or that the month was never formally reconciled at all and someone simply marked transactions R in the register, in which case there is no reconciliation record to undo.
Does undoing a reconciliation delete my transactions?
No. Undoing a reconciliation only clears the reconciled status. Every transaction stays in the register with its date, payee, amount and category intact, and your profit and loss and balance sheet do not change. What you lose is the confirmation that those transactions were matched to a statement, plus the saved reconciliation report. This is why undoing is recoverable in a way that deleting transactions is not.
Deleting is a different operation with different consequences, and the two get confused constantly. If what you actually need is to remove a specific transaction rather than release a period, see how to delete a deposit in QuickBooks, which covers what happens to the payments inside it and when to void instead.
Can I undo a reconciliation my accountant did?
Not from a standard QuickBooks Online login, and you should talk to them before asking. An accountant who reconciled a period may have posted adjusting entries, closed the books, or filed a return based on those figures, so unwinding it silently creates a real problem at year end. If the books are closed, undoing inside the closed period will also trip the closing date password, which is a useful warning rather than an obstacle to work around.
The habit that prevents most of this
Reconciliations get undone for two reasons: somebody reconciled against incomplete data, or somebody edited a reconciled transaction later. Both are avoidable.
For the first, download and keep every statement each month, even for accounts whose feed is working perfectly. Feeds break, banks change their connection provider, and the ninety day window is unforgiving about months you did not think you would need. A folder of PDFs costs nothing and means any period can be rebuilt.
For the second, close the books in QuickBooks once a period is reconciled and reviewed. The closing date makes QuickBooks challenge anyone editing a transaction before it, which converts a silent change into a deliberate one. Most broken beginning balances start as a well-meant category cleanup in a month that should have been locked.
Reconcile monthly, against a complete register, and the Undo button stays a thing you read about rather than a thing you use.
Quick reference
| Question | Answer |
|---|---|
| Does a full undo exist in standard QuickBooks Online? | No. It is a QuickBooks Online Accountant feature only. |
| Does undoing delete transactions? | No. It only clears the reconciled status. |
| Does undoing April affect May and June? | Yes. Every later reconciliation is undone too. |
| Are manually reconciled transactions undone? | No. Clear those R marks by hand in the register. |
| Can QuickBooks Desktop undo an older period directly? | No. Only the last one, repeated as needed. |
| Is there a time limit on undoing? | No published limit, but a closing date password blocks a closed period. |
If the rebuild ahead of you covers months rather than weeks, redoing it by hand against the feed is the slow way and usually reintroduces the same gaps. Converting the statement PDFs into an importable file gives you a closing balance to check before anything posts, which is what our PDF to QBO converter is built for.
Skip the manual entry
Upload a PDF bank statement and get a QBO or IIF file ready to import into QuickBooks.
Convert a Statement Free