To unreconcile in QuickBooks Online, you either clear the reconciled mark on one transaction in its account register, or an admin or accountant undoes a whole reconciliation from the Reconcile history. The first changes one line. The second removes the report and every later reconciliation, so choose the smaller tool whenever it fixes the problem.
Unreconciling one transaction in QuickBooks Online
Unreconciling one transaction means changing its status in the account register from reconciled back to cleared or uncleared. It touches only that line and leaves the saved reconciliation reports alone, which makes it the right first move when a single transaction was ticked by mistake.
These steps follow Intuit's help article, Undo or remove transactions from reconciliations in QuickBooks Online. Menu labels vary by release, so match them against your own screen.
- Open the Chart of accounts from the Accounting menu.
- Find the account that holds the transaction and open its register.
- Find the transaction. A reconciled item shows an R in the checkmark column.
- Click the transaction to expand it.
- Click the checkmark-column box until it is empty. Each click moves the status from reconciled (R) to cleared (C) to uncleared (blank).
- Select Save.
- Reconcile the account again so the change is accounted for.
Before step 5, confirm that this transaction really is the cause of the problem. Intuit's article says to verify that the transaction is truly the cause of a discrepancy before removing it. A transaction you unreconcile by guesswork becomes a new unexplained item in the next reconciliation.
What the register shows afterwards
After you save, the transaction no longer counts toward the closed reconciliation. Its amount is back in the pool of uncleared items, and it will appear on the reconcile screen the next time you open it for that account. You then tick it again against the correct statement, or leave it unticked if it did not clear the bank.
Can you undo a whole QuickBooks Online reconciliation without an accountant user?
Yes, if you are the primary admin. Intuit names the primary admin, an in-house accountant, or an accountant user with access to the client's company as the people who can undo a whole reconciliation. Anyone else should ask one of them, or unreconcile single transactions in the register instead.
The steps come from Intuit's page Undo a client's entire reconciliation:
- Select the gear icon, then select Reconcile.
- Select History by account, then choose the account and the report period.
- Find the reconciliation. In the Action column, select View Report, then select Batch Undo.
- If you are a primary admin with an accountant attached, QuickBooks asks you to talk to your accountant first. Check with them, then select Undo Reconciliation.
- Review the list of changes, including how the beginning balance will shift.
- Tick the box confirming you understand, then select Undo Reconciliation. Select Cancel to leave without changes.
- Read the confirmation, which shows the statement ending date and balance. Reconcile each listed statement again, then select Done.
Download the reconciliation report and any attachments first. Intuit warns that the undo permanently deletes the related attachments and reports, and that it cannot itself be undone. If you keep reconciliation reports as audit evidence, a saved copy is the only way to show what the original month looked like. A reconciliation report sample shows what a reviewer expects that copy to contain.
Why you cannot undo one month in the middle
Undoing a reconciliation also undoes every reconciliation after it. If you pick March while April and May are done, all three go. Plan for that before you start: you will redo each month, in order, against its original statement.
What does unreconciling do to the QuickBooks opening balance?
Unreconciling changes the beginning balance that QuickBooks Online shows for your next reconciliation by the amount of whatever you unreconciled. The beginning balance is the sum of everything already reconciled, so any deposit or payment that leaves that group takes its amount with it.
For a single transaction, Intuit's article says removing a cleared transaction changes the beginning balance of the next reconciliation. For a full undo, the beginning balance returns to what it was before the reconciliation, service charges and interest entered during that reconciliation are removed, and the R marks come off the register.
Here is an example with made-up figures. A reconciled balance of $20,000.00 includes a $500.00 deposit you unreconcile. The next reconciliation then opens with a beginning balance of $19,500.00. If the statement still shows that deposit as cleared, your Difference will be off by $500.00 until you tick the deposit again.
Intuit also says that transactions in the register for the affected dates may have been changed by hand, so check the audit history. If the beginning balance is wrong because someone edited or deleted a reconciled line, do not unreconcile to chase it. Finding which changed transaction caused the discrepancy is the right route, because it names the line and the person who changed it.
When not to unreconcile in QuickBooks: closed periods and filed returns
Leave a reconciliation alone when its period is closed, a return was filed from those books, or a reviewer has signed the work. Undoing it reopens figures other people have relied on, and the original report is deleted in the process.
Three situations deserve a pause:
- A filed return or issued financials. Changing cleared status does not change the ledger balance, but the undo also removes adjustments such as bank fees and interest entered in that reconciliation. Those entries feed your books. Ask your accountant before you remove them.
- A closed period with a closing date set. If the books are closed, fix the error in the current period with a dated correcting entry and document why.
- A reconciliation that only looks wrong. If the statement and the report agree, the reconciliation is sound. The problem is likely elsewhere, such as a later edit.
When you must reverse something, write down what you changed, the date, who approved it, and which statement you reconciled to afterwards. A small log beats memory a year later. Credit card accounts follow the same rules, and the credit card reconciliation steps cover how a card payment enters the picture.
If you review reconciled work for clients, PreciseBankFlow can check each statement's footing and list the lines that match your ledger before anyone unreconciles anything; it is opening to firms in small groups, and you can request a spot.