cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

I have a payroll check that has a c in the column where all other checks have an r - can I change that back to a r

 
4 Comments
Highlighted
Community Champion

I have a payroll check that has a c in the column where all other checks have an r - can I change that back to a r

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

Highlighted
QuickBooks Team

I have a payroll check that has a c in the column where all other checks have an r - can I change that back to a r

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:

  • Manually marking the transaction cleared in the Register. Toggle between C, R, and neither by clicking in the cleared column of the Register (signified by a check mark).
  • Importing a transaction via online banking.  All transactions imported via online banking are automatically flagged as cleared since the transactions come straight from the bank, and therefore you know they have in fact hit the bank.
  • Starting the reconciliation process and clicking the checkbox for a transaction, but leaving the reconciliation without finishing.


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:

  • 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.
  • Reconciling the transaction using the standard QuickBooks reconciliation process.

 

For more information on Reconciling accounts, click here.

 

Please remember, I'm always here for any other questions or concerns.

Highlighted
Level 1

I have a payroll check that has a c in the column where all other checks have an r - can I change that back to a r

Good day!

 

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

 

Thank you

 

 

 

Highlighted
QuickBooks Team

I have a payroll check that has a c in the column where all other checks have an r - can I change that back to a r

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:

 

  • The amount or account of a previously-reconciled transaction was changed.
  • A previously-reconciled transaction was deleted.
  • The amount or account of a transaction that was connected to a previously-reconciled transaction was deleted or changed.
  • A transaction's reconciliation status was changed in the register. 
  • The account's opening balance is incorrect.

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.

Need to get in touch?

Contact us