Skip to main content
S
Sarah_HM
March 14, 2024
Question

Undoing Reconcilliations

  • March 14, 2024
  • 1 reply
  • 0 views

I had some deposits that were somehow deleted after I had reconciled the month. I went back and manually added the transactions. When I compared the categorized transactions for that month to the bank statement all of the transactions for the month are there and there are no duplicates. When I view my reconciliation report it still says I am off by the amount  I was off before I added back those transactions. Do I need to undo and re-do the reconciliation for that month? How do I fix this?

1 reply

I
Irene R
March 14, 2024

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!

S
Sarah_HMAuthor
March 17, 2024

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?

K
Kevin_C
March 17, 2024

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!

Terms & ConditionsAccessibility statement