What happens when you undo an old reconciliation in QuickBooks Online?

 When you undo an old reconciliation in QuickBooks Online, every reconciliation after it is undone too. The transactions stay, but they go back to uncleared, and the saved reconciliation reports and attachments for those months are permanently deleted. Only the primary admin, an accountant user or an in-house accountant can do it. ZeraBooks works differently: you can take back one month's sign-off and leave the rest alone.

That cascade is the part people don't expect. They want to fix one month and find they've reopened half a year.

A fictional account, January to September

A checking account in QuickBooks Online has been reconciled every month from January to September 2026. In May, the reconciliation wouldn't clear, and someone saved it with a 112.50 adjustment. Now the accountant wants that adjustment gone and the real cause found.

| Month | Before | After undoing May | To redo | |---|---|---|---| | January to April | Reconciled | Reconciled | Nothing | | May | Reconciled with a 112.50 adjustment | Undone | Find the 112.50, reconcile | | June | Reconciled | Undone | Reconcile | | July | Reconciled | Undone | Reconcile | | August | Reconciled | Undone | Reconcile | | September | Reconciled | Undone | Reconcile |

Five months to redo to fix one. That's the price, and it's worth knowing before you click.

Before you undo, try to find the 112.50

You'll need to find it anyway, and finding it first sometimes changes the plan.

112.50 divided by 9 is 12.5, not a whole number, so it's probably not two digits swapped. Look instead for a single line of exactly 112.50 that's missing from the books or entered twice. Then look for a line of 56.25 with its sign flipped, since a 56.25 withdrawal entered as a deposit moves the balance by twice that. Check May's bank fees, small card payments and any deposit split across two lines.

If you find it and it's a single transaction that was never recorded, you may be able to record it and fix the adjustment without undoing anything. Talk to your accountant about the cleanest way for your file.

If you do undo

Per Intuit's help article updated September 29, 2026:

  1. Download the reconciliation report and attachments for May through September. They're deleted, not archived.
  2. Write down each month's statement ending balance. Those don't change, and each redo has to land on them.
  3. Go to Reconcile, then History by account. Pick the account and a period that includes May.
  4. Choose undo from May's Action column. QuickBooks shows the new beginning balance. Confirm.
  5. Reconcile May again with the statement in hand, find the 112.50 this time, then June, July, August and September in order.

One wrinkle: transactions someone marked as reconciled by hand in the register, outside a reconciliation, aren't undone by this. Check the audit history for May to September for anything like that.

If you're not the primary admin or an accountant user, you can only clear reconciled transactions one at a time in the register. That's fine for one bad tick. For five months, ask whoever has the access.

Don't undo if the year is filed

If tax returns or financial statements were issued from those months, check with your accountant first. A correcting entry in the current period is often better than reopening a filed year.

How ZeraBooks handles the same situation

In ZeraBooks there are no ticks. A month is reconciled when its statement ties to the ledger to the cent, and then it's signed off. To take one back, open the finalized month in Reconciliations, click Finalized, then Remove sign-off. That month returns to the open queue. June to September stay signed off.

If the books are closed through that date, click Reopen first, with the closing password if there is one, and close the books again after. And because each statement has to tie before sign-off, a month can't be saved with an unexplained 112.50 in the first place.

ZeraBooks runs $79 a month billed yearly or $149 billed monthly, and there's a 7-day trial.

Xero's version, and when not to undo at all, are in our guide on how to undo a bank reconciliation.

Written by ZeraBooks, which makes one of the three products discussed.

Comments

Post a Comment

Popular posts from this blog

How to clean up messy books without redoing the same month twice

Image
Clean up books in this order: collect every statement , set opening balances from the last period your accountant signed off, then reconcile each account one month at a time, oldest first . Only once a month ties do you pair transfers, remove duplicates, place uncategorized lines and move owner spending out. A different order means categorizing lines you later delete. A month that doesn't tie, with the gap shown. During a cleanup you stay on that month until the gap is zero. The worked figures below belong to a fictional design studio whose books stopped being kept in February. They are illustrative only. What has to happen before any categorizing? Step 1: Build a statement grid Accounts down the side, months across the top. Tick a cell when you hold that month's statement as a PDF from the bank. Our studio has checking, savings and one card across eight months, so the grid has 24 cells. Any blank cell is a month you can't prove yet, so request it today. Activity...
Read more

How to convert a credit card statement PDF to Excel, step by step

 You need last quarter's card charges in a spreadsheet by Friday, and all you have is three PDFs from the issuer's website. To convert a credit card statement to Excel, download the PDF statement (not the activity export), run it through a converter or copy the tables out by hand, then fix three things: the signs on payments, the foreign currency detail lines, and the summary blocks. Finish by checking that your rows rebuild the printed new balance. Here's each step. Step 1: Download the statement PDF Go to the card's statements page on the issuer's site and download the monthly statement. Many issuers also offer a "download activity" CSV. Skip it for this job. It usually has no previous or new balance printed anywhere, and those two numbers are how you'll prove the spreadsheet is complete at the end. Watch the dates. A card statement ends on a closing date, not the end of the month. If you need the full quarter, you may need the statement after it too...
Read more

How to scan a bank statement so it converts to Excel cleanly

Image
To scan a bank statement so it converts to Excel cleanly, use 300 dpi and grayscale , keep pages straight, save each account's pages into a single PDF , and include the last page even if it looks empty. Then convert it and check that the opening balance plus the rows equals the printed closing balance. Most conversion problems with scanned statements are decided before the conversion starts, at the scanner. Here is how to get it right, step by step. Where a scanned PDF goes in ZeraBooks Convert: the Upload button, or drop the file on the page. Do you need to scan the statement at all? Step 1: Check online banking first Log in and look at the statements section. If the month is there, download the PDF. A downloaded statement carries the bank's own text and will always beat a scan. What scanner settings work best for bank statements? Step 2: Set the scanner Setting Use Why Resolution 300 dpi Lower loses faint digits; higher only makes bigger files Colo...
Read more