cancel
Showing results for 
Search instead for 
Did you mean: 
Janfromearth1
Level 2

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

I am trying to clear up a complete mess and running into things I have not seen before. 

  • I went back to May to reconcile a checking account and I am seeing transactions marked with "R" in July and August when I got to July.  Could they have changed the cleared status manually?
  • When I am in the reconciliation function, the filter seems to be set to select all cleared statuses for July (the month I am reconciling) but it does not show any of the items already marked with an "R". 

I can get around this by downloading to excel but I am stumped as to what is going on. Thanks

Solved
Best answer September 26, 2020

Best Answers
AlexV
QuickBooks Team

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

I'm joining this thread to share more details about reconciliation, Janfromearth1.

 

The "R" means that the transaction is reconciled. It could be that it was manually reconciled through the register or it underwent the proper process. You can follow the steps shared by Joseph if you want to undo it.

 

Also, all reconciled transactions will be removed in the reconciliation page. Though the filter is set to All, it only refers to Cleared and Not cleared transactions.

 

Here are some of the articles for more details:

Comment again if you need anything else. Stay safe!

View solution in original post

6 Comments 6
Joseph_A
QuickBooks Team

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

Hello there, @Janfromearth1.

 

Are you trying to change the status of the reconciled transaction? You can actually edit your QuickBooks Online transaction status manually.

 

Here's how:

  1. Go to Accounting, then select Chart of Accounts.
  2. Look for the account and select View register
  3. Select the transaction you want to unreconciled.
  4. Review the check column. If the transaction is reconciled, you’ll see an “R.”
  5. Select the box and keep clicking it until the box is blank. This removes the transaction from the reconciliation.
  6. Once done click Save.

 

Here's a step-by-step guide in reconciling your account in QuickBooks Online: Reconcile an account in QuickBooks Online.


Also, learn what to do if your account in QuickBooks Online doesn't match your bank statement at the end of reconciliation: Fix issues when you're reconciling accounts in QuickBooks Online.

 

Feel free to ask questions if you need clarification. I'll be happy to assist you further. have a great day!

Janfromearth1
Level 2

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

Your answer is spot on for the solution to fixing the issue. 

 

My question was how the "R" occured in the first place and why it does not show up when the filter in the reconciliation process clearly says all statuses.   

AlexV
QuickBooks Team

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

I'm joining this thread to share more details about reconciliation, Janfromearth1.

 

The "R" means that the transaction is reconciled. It could be that it was manually reconciled through the register or it underwent the proper process. You can follow the steps shared by Joseph if you want to undo it.

 

Also, all reconciled transactions will be removed in the reconciliation page. Though the filter is set to All, it only refers to Cleared and Not cleared transactions.

 

Here are some of the articles for more details:

Comment again if you need anything else. Stay safe!

Janfromearth1
Level 2

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

HMM So the filter is only looking for cleared and uncleared which is what I am seeing and if they manually put an 'R' in the cleared field outside of the reconciliation process it will not be affected if I reverse the reconciliation?  

AlexV
QuickBooks Team

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

Thanks for the reply, Janfromearth1.

 

You don't need to reconcile them again if they are reconciled already.

 

If you'll undo or unreconciled the transactions, then you'll have to reconcile them back. They will appear back to the reconciliation page. 

 

Let me know if you have more questions. Thanks!

Janfromearth1
Level 2

Checking account reconciliation, not seeing "R" transactions in the month being reconciled.

Actually, what I wanted to do was to mark them all as cleared.  If they do not show up in the reconciliation screen, I can';t do that. Thanks anyway 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us