Reconciliation Discrepancy - deleted transactions

Hi there, @gjhbhines.

How's your day going so far? I hope all is well. 

In the past, we have seen users in this same position have their accountant's undo the last reconciliation. Then reconcile the transactions again so everything balances. 

Here's how you can undo the last reconciliation (please note your accountant is the only user that can preform these steps 

1. Open your client’s company file in QuickBooks Online. Go to All apps, then Accounting, then Reconcile.
2. Select History by account.
3. Choose the account you want to unreconcile and the date range.
4. Find the reconciliation you want to undo.
5. From the Action column, select the dropdown, then click on Undo.
6. Hit Yes.
7. Select Undo.

Note: If you don't see Undo, make sure you've opened your client's company file from QuickBooks Online Accountant.

Result

The chosen reconciliation, and any reconciliations since then, are undone.

Transactions that remain in the register for the dates that were undone may have changed manually. Check your transaction audit history.

What’s next: After undoing the reconciliation, you can reconcile the account again and fix any errors.

If you don't have an accountant user you'll want to review everything on the discrepancy report. The Total Discrepancy Difference on the report should be $0.00. Then, check the beginning balance in QuickBooks. It should match the beginning balance on your bank statement.

Also, if you need to undo a past reconciliation, you have an option to do it manually.

Here's how: 

1. Go to Accounting > Chart of accounts.
2. Find the account that has the reconciled transaction. Then click the View register link.
3. Select the transaction to expand the view, and in the Reconcile Status column (indicated by a checkmark ✔ column.) you’ll see an “R”.
4. In the checkmark ✔ column, select the box with the “R” until the box is blank. This removes the transaction from the reconciliation.
5. Hit Save.
6. Close the account register.

To help manage your past and present reconciliations, please feel free to read these articles:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online
• Reconcile an account in QuickBooks Online
• Undo or remove transactions from reconciliations in QuickBooks Online

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Have a great day ahead!