Level 1

Profit & Loss Detail report Clr column

In my P&L detail report (cash basis) come invoices and sales receipts have a check-mark in the "Clr" column (most do not). What does the check-mark indicate?

(This is in QBDT Pro 2019)

QuickBooks Team

Reports and accounting

Hello there, cmb1.


I'm glad you've  reached out to us. Let me help provide some insights about the Profit & Loss Detailed report Clr column in QuickBooks Desktop. 


The check marked in the Clr column of Profit and Loss Detailed report are the transactions that have been cleared in the reconcile process, to show that the balance in the bank account has been matched to the bank statement.


Don't hesitate to leave a comment below if you have any other questions about the report. Have a good one. 

Level 15

Reports and accounting



Please Learn from this input.




You should not be seeing checkmarks in the P&L perspective at all. The reason, as @JanyRoseB rightly stated, is that only Balance Sheet accounts get reconciled. That means the account for the Transaction Side, as Bank or credit card charge. are what gets reconciled. These details seen in the P&L, from the Expenses and Items tab of purchases, or from Sales, income and expense are never reconciled.



That's why, No, you should not be seeing Cleared Status, for these income and expense account details as the Transactions.



An Invoice is AR. The entries here are Income, and perhaps Sales taxes and the AR gets offset by your Receive Payment. Nothing in AR gets "reconciled". Then, if you use Undeposited Funds, the Payment flows to UF and later, you select it for Make Deposit. UF is "self-reconciling" and that means the UF register shows the In and Out are cleared against each other = have the checkmark. But your P&L only shows the Income from the invoice. It doesn't show AR or UF or even banking. Cash Basis means the Date of the Payment is used, but the Invoice is showing.


Can you give an image attachment or an example of what you put on the invoice for the detail you see as "cleared" when viewing the P&L Detail? Thanks.

Level 1

Reports and accounting

Yes. I understand the account entries and the process. That's why I have the question. I don't understand why a check-mark would be on some of the entries in a Profit & Loss Detail report. The P&L detail report in the attached file is the standard QBDT report, cash basis, except that I removed the Name column.

Please see attached file.

Level 1

Reports and accounting

I have attached a pdf of some screen prints.

QuickBooks Team

Reports and accounting

Thanks for the screenshot, cmb1.


JanyRoseB is right about the meaning of the check mark in the Clr column as this is written on the in-product article. However, I'd also agree with qbteachmt that we don't reconcile transactions on P&L reports, only Balance Sheet transactions. For this reason, I'd encourage you to send feedback on what you see on your P&L Detail report using these steps:

  1. From the Help menu, choose Send Feedback Online.
  2. Choose Bug Report.
  3. In the Product Area, select Report.
  4. Write a short description of your observation.
  5. Click Send Feedback.

I'll do the same thing on my end to make sure that this goes to our product development team. I won't promise for a reply, but at least we're making them aware about this.


Lastly, I'd like to thank you for asking this. If you have more questions, you can always go back to this thread.


Have a good day, cmb1!

Level 15

Reports and accounting

That is Weird. I recommend using File menu > Utilities, Rebuild this file.

View solution in original post

Level 1

Reports and accounting

Just for fun, I ran Verify and received message Verify Master: totTrans wrong. Is #### should be ####.

Although Intuit doesn't recommend a Rebuild for this error I did it anyway.

It didn't change my report, it still has check-marks is a few of of the transactions on the Profit & Loss by Detail Report.

I consider this issue closed.

QuickBooks Team

Reports and accounting

Hi there, @cmb1.


Allow me to join the thread and help share information about the Clr column in the Profit and Loss Detail report.


Yes, as mentioned by my colleague JanyRoseB, the transaction with the check-mark on the Clr column are those that have been cleared in the reconciliation process. It happens, especially if you have a payroll liability adjustment affecting to an expense account.


If you wish to check this further, I suggest getting in touch with our QuickBooks Support Team to access your account via a secured remote access. For the support's contact information:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

Keep posted if you have other concerns about running reports in QuickBooks Desktop, I'm always here to help. Have a great day ahead!

Level 1

Reports and accounting

If you take a look at the file I uploaded you will see that the transactions in question are invoices. Invoices are not part of the reconciliation process so a check-mark in the Clr column doesn't really make much sense. I'm not convinced that the Clr column should appear on that report at all as nothing on that report will be part of the reconciliation process.


Reports and accounting

Thanks for getting back, cmb1.


I want to make sure you are pointed to the right direction.


Your concern about the Profit and Loss Detail report showing check-mark in the Clr column is considered to be an ongoing issue. I encourage you to send a Bug Report straight to our Product Development Team so they can include your company information to the list of affected users.


Here's how:

  1. Go to the Help menu.
  2. Click Send Feedback Online.
  3. Choose Bug Report.


Once the issue is resolved, you will receive a notification via email from our QuickBooks Developers.


Thank you for your patience. Keep in touch if you have any other questions. I'm always happy to help.