It will change to R when you have reconciled the account and only then. C indicates a tentative clear, when you have matched to bank feed, but is not R until you actually reconcile
Welcome, @jvanveen55 and thank you for coming to the QuickBooks Community for assistance. I have some insight into the differences between "c" and "r" to pass along.
A QuickBooks transaction report may display a C, R, or nothing in the CLR column of the report, or in the Register. C means cleared and R means reconciled. The difference between cleared and reconciled in QuickBooks Online is this:
A cleared (C) transaction is one that you know has hit the bank or credit card, but has not yet been officially reconciled in the standard QuickBooks reconciliation process. Transactions may be marked cleared in a few ways, including:
A transaction is marked reconciled (R) after you have gone through the standard month-end reconciliation process. All cleared transactions become reconciled transactions when the reconciliation is completed. A transaction is marked reconciled in two ways:
For more information on Reconciling accounts, click here.
Please remember, I'm always here for any other questions or concerns.
This caught my attention due to having issues reconciling bank account.
I undid most of the transactions but whenever i undo previous reconciled bank account it doesn't seem to match the beginning balance at all and am afraid that i'll have to go through the entire process of undoing everything which i do not want to do.
This statement i think might be the answer:
Manually marking the transaction reconciled in the Register. I advise that you do not mark transactions as reconciled in the Register. Using the standard reconciliation process is almost always a better way to ensure that your bank records match your books.
But am still unsure of what to do. I review the Discrepancy Report and saw that the Change Type of some transactions are changed as "Reconciled in Register".
If i click on one of the item there's a small box where i can change the status as R,C or Blank. My question is if i remove the status R on it will it return to the bank register for me to reconcile as standard process?
Attached is the email of what seems to be the problem why my beginning balance doesn't match on each month.
I hope this makes sense and hope to hear from you soon
I appreciate the detailed information and screenshot you've shared, @girlie16.
Let me provide some information about the beginning balance discrepancies upon reconciling bank accounts.
With regards on removing status, you're correct. If you remove and change the status from "R" (Reconciled) to "Blank" the transactions will return to the bank register for you to reconcile. However, if you need to completely start over, I suggest reaching out to your accountant to undo the entire reconciliation.
Also, there are most common causes for a beginning balance discrepancy upon reconciling. Here are the causes:
For more details, you can read this article: About Beginning Balance Discrepancies.
Then to fix the beginning balance issues, feel free to check out this article for the detailed information: How to Fix Differences Between QuickBooks Balance and Bank Balance.
You might also want to read these articles to know more about reconciliations:
Please know that you can always get back to this post if you have any other questions. I'll keep an eye on your response.