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

gside333 · ‎July 08, 2021

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!

KlentB · ‎July 08, 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:

Select Reports from the top menu bar.
Go to Sales, then choose Sales by Customer Detail.
Set the appropriate reporting date and accounting basis.
Click the Excel button, then select Create New Worksheet.
Once the file is exported, go back to the Reports menu.
Select Vendors & Payables, then choose Transaction List by Vendor.
Repeat steps 3 - 4 to download the report.
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.

View solution in original post

KlentB · ‎July 08, 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:

Select Reports from the top menu bar.
Go to Sales, then choose Sales by Customer Detail.
Set the appropriate reporting date and accounting basis.
Click the Excel button, then select Create New Worksheet.
Once the file is exported, go back to the Reports menu.
Select Vendors & Payables, then choose Transaction List by Vendor.
Repeat steps 3 - 4 to download the report.
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 · ‎July 14, 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!

gside333 · ‎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?

LeizylM · ‎July 16, 2021

Thank you for getting back to us here in the Community, gside333.

Yes, you're right. As mentioned by my colleague @KlentB you'll need to manually combine the data of the two reports to calculate the profit for each client. To do it, export the Sales by Customer Detail and Transaction List by Vendor report to an excel file to generate this data.

I've got some resources that you might need that covers basic information about the reports in QuickBooks Desktop: Customize reports in QuickBooks Desktop.

Reach out to me if you need further assistance when working in QuickBooks. I'll be glad to lend a helping hand. Have a great day!

Topics

Training

Community

Resources

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