cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
Waldo69
Level 2

Reconciliation

How do I remove a past reconciliation that was done incorrectly? 

Solved
Best answer April 03, 2021

Best Answers
IamjuViel
QuickBooks Team

Reconciliation

It's great to have you here, @Waldo69.

 

Let me share additional information about how you can manage and reconcile your downloaded bank transactions.

 

C means that the transaction was cleared in your bank's statement. For instance, when you pay your credit card bill, your financial institution acknowledges the payment.

 

 

Meanwhile. R means that transaction actually matches your bank statement.

 

Know that we're always here to help if you have other questions or concerns. Feel free to leave your comments below.

View solution in original post

5 Comments 5
Jen_D
Moderator

Reconciliation

Thanks for posting here about your reconciliation, @Waldo69,

 

There are 2 ways to get a reconciliation undone in QuickBooks Online. First, you can request for an accountant use to undo it or use the second option to manually unreconcile an entry.

 

For the first option, see this link for the steps: Undo a client’s reconciliation in QuickBooks Online Accountant

 

If you opt for the latter option, follow the steps below:

 

  1. Click the Gear icon, then tap Chart of Accounts.
  2. Find the account you want to review.
  3. From the Action column, click View register.
  4. Locate the entry from the list that shows a code R (Reconciled).
  5. Click the field to remove the reconciled status. Leave the status Blank to uncleare it and be tagged as unreconciled.
  6. Once done press Save. To give you an idea on how it looks like in QBO, see this screenshot:

     

 

You can also find these steps from this article: How to unreconcile a transaction or undo a reconciliation.

 

If you have any additional questions about a reconciliation in QBO, let me know in the comment below. Have a wonderful day!

Waldo69
Level 2

Reconciliation

Thanks for the quick reply @Jen_D . Following the instructions, I found close to 1k entries with the "R" designation. I really messed something up, is there any way to make a bulk change or must it be one transaction at a time? 

MadelynC
Moderator

Reconciliation

Not to worry! I’m here to handle it for you, @Waldo69.


As mentioned by my colleague above, there are two ways to unreconciled transactions in QuickBooks Online. Either edit them individually or have your accountant undo the entire reconciliation by using the QuickBooks Online Accountant version.


If you choose option two, changing them by bulk isn’t possible at the moment. While there isn’t a way to do it, you may consider contacting an accountant. QuickBooks Online Accountant has a special tool that can undo reconciliation. Sometimes it's best to start over from scratch to make sure everything is accurate. In case you don't have one, you can follow the steps below to find an accountant.


Here's how:

 

  1. Visit the ProAdvisor site.
  2. Enter your city or ZIP code in the Location field. It will display a list of accountants or bookkeepers near you.
  3. You can also filter the service provided, industry served, and product supported to narrow down the results.


Check out this reference for complete instructions to undo the reconciliation. This also provides steps to redo the reconciliation process so records match your actual bank.


Don’t hesitate to post a comment below if you need further assistance with your reconciliation. We’re always here, ready to help you out. Take care!

Waldo69
Level 2

Reconciliation

Thank you so much for your help! The information has been very helpful. Quick question about "C" and when it should be used. Aside from the transaction labels with the "R", the remaining have the C designation. Should I be selecting "C" designation as I remove the reconciliation? 

IamjuViel
QuickBooks Team

Reconciliation

It's great to have you here, @Waldo69.

 

Let me share additional information about how you can manage and reconcile your downloaded bank transactions.

 

C means that the transaction was cleared in your bank's statement. For instance, when you pay your credit card bill, your financial institution acknowledges the payment.

 

 

Meanwhile. R means that transaction actually matches your bank statement.

 

Know that we're always here to help if you have other questions or concerns. Feel free to leave your comments below.