Okay, I am using QB Premier 2016 and have been trying to use the Profit and Loss Detail Report. I am finding that for the transaction type being displayed for Income that it is using "Invoice". I would like to show the report using Payments as there are many times that Invoice is not fully paid or paid at all. I see that I can filter on the Paid Status of an Invoice as being Open or Closed, but that still doesn't completely resolve the issue since if the Invoice is not completely paid, it is still considered to be Open.
I do see that I can set the Report basis to be based on Cash instead of Accrual, but was not sure if that is actually computing things as I want them to be. If that is all it takes, I'm fine with that.
I realize that I am probably not including enough information, so if you do need more, please let me know.
Solved! Go to Solution.
Gotcha. That might work for me still.
Okay, then, so is there a different report I should be using to view my "Profit" based on payments as opposed to Invoiced amount?
Not that I want something different... Just asking if there is a better report than the Profit & Loss on Cash Basis that I should be using.
Basically, I just want to present to others what we have received in income during the past fiscal year. The fact that the Cash Basis report is based on when the payment was received should be fine as I am trying to show the amount we actually received and if it was invoiced before the fiscal year, it should not matter.
Please allow me to join the thread and help share additional information about running the Profit and Loss Detail report in QuickBooks Desktop (QBDT).
The Profit and Loss report summarizes your income and expenses for the year to know whether you're operating at a profit or loss. As mentioned by our Established Community Backer (BRC), payments won't show up on the report because they don't use income accounts.
However, you can create/run a report which shows payments in QBDT. As of now, you can start opening the Transaction List by Customer report and make the necessary customization. Let me help guide you how.
To learn more about running and customizing reports in QBDT, you may check this article: Understand reports.
Please know that I'll be right here to help you if you have any other questions about running reports, just add a comment below. Wishing you the best!