Skip to main content
J
Janfromearth1
September 27, 2020
Solved

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

  • September 27, 2020
  • 1 reply
  • 0 views

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

Best answer by AlexV

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!

1 reply

J
Joseph_A
September 27, 2020

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!

J
Janfromearth1Author
September 27, 2020

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
    AlexVAnswer
    September 27, 2020

    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!

    Terms & ConditionsAccessibility statement