cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Profit & Loss Report Not Showing Invoice and Not Payments

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.

 

Thanks,

Merg

Solved
Best answer 04-14-2019

Accepted Solutions
BRC
Established Community Backer ***

Re: Profit & Loss Report Not Showing Invoice and Not Payments

If you run your P&L on a cash basis then the invoices will show up but on the payment dates.  Payments won't show up because they don't use income accounts.

5 Comments
BRC
Established Community Backer ***

Re: Profit & Loss Report Not Showing Invoice and Not Payments

If you run your P&L on a cash basis then the invoices will show up but on the payment dates.  Payments won't show up because they don't use income accounts.

Not applicable

Re: Profit & Loss Report Not Showing Invoice and Not Payments

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?

 

Thanks,
Merg

BRC
Established Community Backer ***

Re: Profit & Loss Report Not Showing Invoice and Not Payments

Different than a P&L on a cash basis?  Why do you want something different?

Not applicable

Re: Profit & Loss Report Not Showing Invoice and Not Payments

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.

 

Thanks,
Merg

QuickBooks Team

Re: Profit & Loss Report Not Showing Invoice and Not Payments

Hello, @TheMerg.

 

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.

 

  1. Click on Reports at the top menu bar.
  2. Select Customers & Receivables.
  3. Click on Transaction List by Customer.
  4. Customize the dates of the report.
  5. Click on Customize report to customize the transaction type to Payment.
  6. Go to the Filter column.
  7. Look for Transaction Type.
  8. Select Payment.
  9. Click OK.e5 payment report.PNG

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!

Need to get in touch?

Contact us