Skip to main content
cmb1
Feb 3, 2019 2:07 AM UTC
Solved

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)

qbteachmt
qbteachmtAnswer
Feb 4, 2019 6:02 PM UTC

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!


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

View in thread

10 replies

JanyRoseB
Feb 3, 2019 5:32 PM UTC

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. 

qbteachmt
qbteachmt
Feb 3, 2019 6:22 PM UTC

@JanyRoseB

 

Please Learn from this input.

 

@cmb1

 

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.

 

Example:

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.

cmb1Author
Feb 3, 2019 6:52 PM UTC

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.

Terms & ConditionsAccessibility statement