Undoing Reconcilliations

Hi there, Sarah. 

I understand the importance of your reconciled bank accounts and having a closed book for the month in your QuickBooks Online (QBO) account.

As you have manually uploaded your transactions, it wasn't reconciled automatically. Therefore, we need to manually reconcile them in order to show up in your categorized transactions. You can follow the steps I’ll provide below:

1. Go to Gear Icon ⚙, then Chart of Accounts. 
2. Look for the reconciled account, then select View Register.
3. Look for the transaction, review the check column, and then click it until the "R" appears. This will reconcile the transaction from the reconciliation.
4. Select Save, then close the account register.

Furthermore, I recommend contacting your accountant upon doing this process to have more guidance regarding this matter. 

You can refer to this article for more information when reconciling a single transaction in QBO: Undo or remove transactions from reconciliations in QuickBooks Online.

Additionally, I have included an article to help you if you come across reconciliation issues: Fix issues at the end of reconciliation in QuickBooks Online.

Feel free to drop a comment below for further inquiries with reconciliation in your QBO, I’ll be here to answer your questions at any time. Have a great day ahead!

I was able to correct all but one transaction. When I look in my register, that each transaction that is reconciled appears twice (once with an R and once with a C in the check column). There is one transaction in my register that only appears once and with a C in the check column. This transaction amount is the amount my account is off by. How do I fix it?

You're almost there, Sarah. Allow me to assist you with fixing your bank reconciliation in QuickBooks Online (QBO) to ensure everything is balanced.

Just an overview, the R in the checkmark column represents that the transaction has been reconciled, while the C shows that it has been cleared/categorized from the For review tab.

Based on your statement, you seem to have uploaded/accepted the same transactions as what you have previously reconciled. In QBO, once you've reconciled transactions, you should only see each of them appear once with an R in the checkmark column.

To fix this, you'll want to reconcile that one "C" transaction that causes your balance to be off by selecting the box with the “C” until it becomes "R". Just make sure to double-check that all of your reconciled transactions match the ones on your bank statements. After that, your reconciliation should be balanced with a $0.00 difference.

From there, you can now delete all of the duplicate transactions that have been marked as cleared (C) in your account register. Before doing so, I'd still recommend seeking assistance from your accountant to ensure your books are accurate and to avoid messing up the data.

Here's how you can delete them from the register, one at a time:

1. Go to the Gear icon and then Chart of accounts.
2. Locate the account in question and click View register.
3. Find the duplicate transactions in the account register.
4. Select the transaction to expand the view.
5. Tap Delete and hit Yes to confirm.
   

Alternatively, you can undo them from the Banking page to remove them from your account register. See this article for more details: Unmatch downloaded bank transactions or move them to another account.

Please keep us updated on how it goes, or if you have other questions in mind, don't hesitate to reach out. I'll be here to lend a hand. Have a great day ahead!