QuickBooks HelpQuickBooksHelpIntuit

Undo transactions from reconciliations in QuickBooks Online

by Intuit•1• Updated 4 days ago

Learn how to unreconcile an individual transaction from a completed reconciliation.

icon of an agentIf you need help using QuickBooks, you can partner with a QuickBooks Live Bookkeeper to feel more confident. Find out more about QuickBooks Live Bookkeeping.

If you’ve reconciled a transaction by mistake, we’ll show you how to remove individual transactions from the reconciliation. Keep in mind, even small changes can unbalance your accounts. To minimize the impact, you can only unreconcile one transaction at a time. 

If you need to completely start reconciliation over, reach out to your accountant. Accountants can undo entire reconciliations. Don't have an accountant? We can help you find one.

Or, if you’d like help with reconciliation, you can partner with a QuickBooks Live Bookkeeper to feel more confident. Find out more about QuickBooks Live Bookkeeping.

If you’re ready to undo your transactions, follow the steps below: 

The QuickBooks design has been updated! If this video doesn't match what you see in QuickBooks, use the in-app Search bar to navigate to the page you need.

Hi. This is Katheryn from the QuickBooks team. When you reconcile an account, you might see an alert saying your account isn’t ready to reconcile yet. This means something changed about your reconciled transactions since you last reconciled. Let’s go over how to correct your beginning balance. You may need to do this if the dollar amount of a transaction was changed, if a transaction was unreconciled from the register or reconciled from the register without a proper reconciliation, if a transaction was deleted, or if there have simply been too many changes and you’d like to undo a reconciliation. If you’re having trouble with your beginning balance during your first reconciliation, check out this video instead because you may need to enter or adjust your beginning balance journal entry. To start, select Settings, then Reconcile. This is where you’ll see an alert if you have a problem with your beginning balance. Select the link to look at your discrepancy report. Use the Change Type column to find out why the transaction changed your beginning balance.. You’ll see “Amount Changed” if someone changed the dollar amount after it was reconciled. To fix this, select the transaction and change the Amount to match the Reconciled Amount. On some transaction types you may need to select Edit to change the dollar amount. Then select Save. You could also see “Unreconciled in Register.” This happens if the transaction was reconciled and then someone unreconciled it - usually by mistake. To reconcile it again select the transaction then select this box until you see an R. Select Save and the transaction should disappear. The third change type is “Reconciled in Register.” This happens when someone clears a transaction without reconciling. To fix it, select the transaction. Then select the box until it's blank or you see a C. This unreconciles the transaction so you can include it in future reconciliations. Select Save and the transaction should disappear. “Deleted” appears when someone deletes a reconciled transaction. Select View to see this transaction’s history. If this was deleted by accident, then recreate the transaction exactly as it appears in the history. Select the “global create” button and then the type of transaction that was deleted. Complete the form with the correct amount and date. Then select Save and Close When you’re done, select Settings. Then select “Chart of Accounts” and then “View Register” next to the appropriate bank account. Find the transaction and select it. Select the box in the checkmark column until you see an R. This reconciles the transaction. If you see more changes than you’d like to fix, and you just want to start over from a previous reconciliation, ask your accountant to log in and undo a reconciliation from the History by Account screen. If you haven’t invited your accountant to your company, check out this video to learn how to add them. Those are the reasons you might receive a beginning balance alert and now you know what to do if you see one.

Step 1: Review the account

If an account isn't balancing correctly after a reconciliation, we recommend reviewing your opening, beginning, and ending balances first to be sure you’ve ruled out any possible errors.

Step 2: Unreconcile transactions

When you know which transaction you need to change, here's how to edit and unreconcile the transaction:

  1. Go to Settings âš™, then Chart of accounts (Take me there).
  2. Find the account that has the reconciled transaction. Then select View register.
  3. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
  4. Select the transaction to expand the view.
  5. In the checkmark ✔ column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
  6. Repeat for any other transactions you need to unreconcile. 
  7. Select Save.

Learn more about reconciling and related errors.

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start