Undo a reconciliation

Only Accountant users can Undo prior reconciliations.

I have to hire an accountant to click a few buttons? How does this make sense? I'm stuck and can't move on until this is done? Can I get a different version of QB?

No, you don't have to hire an Accountant. You can remove the "R" for reconciled within the account register of the account you need to re-reconcile. If there are "many" transactions in the register and it would take a long time to do this, you can use a different email account to create a "QBOA" (QuickBooks Online Accountant) account, then send yourself an Accountant invitation. Once accepted, you can act as your own Accountant and "Batch Undo" the account reconciliations under the briefcase icon (Accountant Tools/Reconcile/History by account/Action/Batch Undo) for Accountants in the QBOA account login.

Ps: Also, I am an Accountant, and I do not charge my clients to "Undo" account reconciliations for them when they choose to do their own account reconciliations and need to redo them.

Even after creating an accountant log in, it still doesn't give this option. The briefcase isn't there once I access the company books.  Any other thoughts? 

 Log back into your regular QBO account and send yourself an Accountant invitation to the email address you used for your QBOA (Firm) account. Then go to that email account and accept the invitation. Then login to your QBOA account and go to your client list, you should be there as a client (Your Practice/Clients). Select your regular QBO client. Then go to "Reports" and "Reconciliation Reports", this will take you to the same screen as the Accountant Toolbox method.

Just creating the Accountant login (QBOA firm account) is not enough. You have to invite yourself as an Accountant under your original QBO account so you can access that account as the Accountant under the firm account. Make sense?

Hi,

I am trying to undo a batch for my reconciliation  from Feb. 2020 to fix a transaction QB duplicated. If I do this it will undo all my 13 reconciliation. 

This is what happened: We received an payment through QB but the payment was rejected. QB and our bank received this payment, and then it was debited. We had to resent the invoice to our client, he paid and the payment was received without any problem. Now, we have the 1st payment payment on our client account but because it was not applied to any invoice, only registered in account receivable, our invoices and account receivable do not match. Is there a way to fix this? Any help will help.

Hello @7Hills,

As of the moment, the feature to undo an entire reconciliation is only available for all Accountant users using the QuickBooks Online Accountant account.

With this, let's consider manually removing your newest to oldest transactions from reconciliation to undo them. Let me show you how.

1. Go to Accounting.
2. Select Chart of Accounts.
3. Find your bank account from the list of accounts.
4. Under ACTION, select View register.
5. Review your bank transaction.
6. On the Check column, remove the R status.
7. Click Save.

In the same manner, here's an article you can read to learn more about how you can undo a reconciled transaction: Undo and remove transactions from reconciliations in QuickBooks Online.

However, if you still wish to accomplish your goal easily as describe by the suggestions above, let's invite your accountant to access your company data. To do so:

1. Go to the Gear icon.
2. Under Your Company, select Manage Users.
3. Select Accounting firms.
4. Click Invite.
5. Enter the name and email address of your accountant.
6. Click Save.

On top of that, I've also included this reference for a compilation of articles you can use while working with us: Learn the reconcile workflow in QuickBooks.

If there's anything else that I can help you with, please let me know in the comments below. I'll be here to lend a hand.

Hi! Through a series of unfortunate events I accidentally reconciled my checking account using the wrong end balance. quickbooks is not showing a discrepancy, but the beginning balance is now wrong to start the next months reconciliation. If I do a batch undo will it allow me to start from scratch and enter the ending balance and date again?

Hello, Newbie21. 

I'll definitely guide you on how you can start over from scratch and ensure you'll be able to reconcile your checking account. 

Yes, undoing your previous reconciliation will allow you to start from scratch and fix the balances. 

Take note that the batch undo for QuickBooks Online is only available through QuickBooks Online Accountant. If you have an accountant, you can invite them to your account. 

Otherwise, you'll want to manually unreconcile the transactions one at a time in your checking account's register. Here's how: 

1. Go to your Chart of Accounts. 
2. Find your checking account, then click View register.
3. Take note of the transactions you've reconciled before, then select each one.
4. Click the check mark column (with an R) and keep doing it until a blank box appears. 
5. Click Save.

After unreconciling your transactions, review the records and fix any transaction amounts and balances. 

I'm sure you'll find these articles helpful in guiding you on how to fix your reconciled account:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online
• Edit an incorrect opening balance

If you need to check on your financial data, you can run a variety of reports like the Balance Sheet, Profit and Loss and more. This article will help you utilize the Reports feature well: Run reports in QuickBooks Online.

I'm up and ready to help you out again if you have more questions about handling your reconciliation. I'm also willing to address any other QuickBooks-related concerns.