cancel
Showing results for 
Search instead for 
Did you mean: 
judi-qb
Level 1

Commission based on sales AND payment

We purchased a small company and pay the previous owner based on PAID invoices for his customers, but we also need to calculate actual profit on any goods sold. I've tried manipulating reports to get this information, but I'm coming up empty. At this point, I have to go through each of his customers and record everything on a spreadsheet, including the inventory items that were sold and the cost of those items. Is there an easier way to do this? Again, he doesn't get paid until the customer pays us, which makes the equation even more complicated. I can't just use the P&L by class report because I also need to consider whether a payment has been made for each invoice produced.

Solved
Best answer April 28, 2020

Best Answers
ReyJohn_D
Moderator

Commission based on sales AND payment

Thanks for posting a question here in the Community, @judi-qb.

 

Allow me to share with you some insights on how you can run a report for your invoice payments transactions in QuickBooks Desktop.

 

First off, you'll have to make sure to record the payments when the invoices were paid and the items were taken by the customers. Check out this article to learn more on how to record invoice payments in QuickBooks Desktop: How do I enter invoice payments in QuickBooks Desktop.

 

 Also, you'll have to ensure to use Cash as the report basis when running your Profit and Loss such as detail, standard, by class, etc. I'll guide you how:

 

  1. Go to the Reports menu then choose Company and Financial option.
  2. Choose the desired report say Profit and Loss Standard report to view a summarized report for your income and expenses, Profit and Loss Detail to show detailed information for your income and expenses, etc.
  3. Once you've already selected your Profit and Loss report, you'll have to make sure you choose the date and the Report Basis as Cash to show only paid invoices transactions from your customers.

Please see screenshots below for visual reference:

A37.PNGA38.PNG

I'm also thinking of adding this article about customizing your reports which might come in handy to you so you can personalize your reports: How do I customize my reports in QB Desktop?

 

You're also able to memorize these customize reports. This way, you don't have to make another customization for the same report you wish to have: How do I memorize a report in QuickBooks Desktop.

 

Fill me in if you have more questions. I'll be here to help. Take care and have a great day!

View solution in original post

2 Comments 2
ReyJohn_D
Moderator

Commission based on sales AND payment

Thanks for posting a question here in the Community, @judi-qb.

 

Allow me to share with you some insights on how you can run a report for your invoice payments transactions in QuickBooks Desktop.

 

First off, you'll have to make sure to record the payments when the invoices were paid and the items were taken by the customers. Check out this article to learn more on how to record invoice payments in QuickBooks Desktop: How do I enter invoice payments in QuickBooks Desktop.

 

 Also, you'll have to ensure to use Cash as the report basis when running your Profit and Loss such as detail, standard, by class, etc. I'll guide you how:

 

  1. Go to the Reports menu then choose Company and Financial option.
  2. Choose the desired report say Profit and Loss Standard report to view a summarized report for your income and expenses, Profit and Loss Detail to show detailed information for your income and expenses, etc.
  3. Once you've already selected your Profit and Loss report, you'll have to make sure you choose the date and the Report Basis as Cash to show only paid invoices transactions from your customers.

Please see screenshots below for visual reference:

A37.PNGA38.PNG

I'm also thinking of adding this article about customizing your reports which might come in handy to you so you can personalize your reports: How do I customize my reports in QB Desktop?

 

You're also able to memorize these customize reports. This way, you don't have to make another customization for the same report you wish to have: How do I memorize a report in QuickBooks Desktop.

 

Fill me in if you have more questions. I'll be here to help. Take care and have a great day!

judi-qb
Level 1

Commission based on sales AND payment

Thank you so very much! The element I was missing is running the report as a Cash Basis!!!!! Thank you, thank you, thank you!!!!!!!!

Need to get in touch?

Contact us