Skip to main content
G
gside333
July 8, 2021
Solved

how do i create a monthly report that shows profit from all clients

  • July 8, 2021
  • 1 reply
  • 0 views

we invoice multiple clients and then subtract what the client paid in a given month minus what we paid to contractors ....how can we create a report we can use each month that shows

 

Client name |  total revenue paid for month | minus paid to contractor | profit

 

any insight would be a huge help ..newbie to this and manually doing it now ...also on the backend want to make sure the money paid to contractor is being entered correctly and is that in any way linked to a particular client so this report can automatically be generated each month if we do 2 things:  1. invoices are created and marked as paid during the month 2. the amount paid to contractors to service a client is recorded each month

 

thanks!

Best answer by KlentB

It's nice to see you here, gside333.

 

I can think of two reports that can generate this data. You'll want to export the Sales by Customer Detail and Transaction List by Vendor report to an Excel file. Then. combine them to compute the profit for each client. Here's  how:

 

  1. Select Reports from the top menu bar.
  2. Go to Sales, then choose Sales by Customer Detail.
  3. Set the appropriate reporting date and accounting basis.
  4. Click the Excel button, then select Create New Worksheet.
  5. Once the file is exported, go back to the Reports menu.
  6.  Select Vendors & Payables, then choose Transaction List by Vendor.
  7. Repeat steps 3 - 4 to download the report.
  8. Open the files, then combine the data of the two reports to calculate the profit.

In addition, here are some articles that you can read to help speed up the reporting process in QuickBooks:

 

If you need more help in completing your other tasks, please don't hesitate to post a comment on this thread. The Community always has your back.

1 reply

KlentB
KlentBAnswer
July 8, 2021

It's nice to see you here, gside333.

 

I can think of two reports that can generate this data. You'll want to export the Sales by Customer Detail and Transaction List by Vendor report to an Excel file. Then. combine them to compute the profit for each client. Here's  how:

 

  1. Select Reports from the top menu bar.
  2. Go to Sales, then choose Sales by Customer Detail.
  3. Set the appropriate reporting date and accounting basis.
  4. Click the Excel button, then select Create New Worksheet.
  5. Once the file is exported, go back to the Reports menu.
  6.  Select Vendors & Payables, then choose Transaction List by Vendor.
  7. Repeat steps 3 - 4 to download the report.
  8. Open the files, then combine the data of the two reports to calculate the profit.

In addition, here are some articles that you can read to help speed up the reporting process in QuickBooks:

 

If you need more help in completing your other tasks, please don't hesitate to post a comment on this thread. The Community always has your back.

KlentB
KlentB
July 15, 2021

Hi gside333,

 

Hope you’re doing great. I wanted to see how everything is going about your concern. Were you able to generate the report? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

G
gside333Author
July 16, 2021

appreciate the help!  i was hoping there was some more automated way than manually combining the 2 reports ...if i'm clear on what you mean there it's what we do now i think :   basically subtract the total paid to vendor from total sales of client ....create that final report manually that way yes?

Terms & ConditionsAccessibility statement