Profit and loss by class using sales rep

pennees · ‎June 16, 2024

We use Quickbooks Accountant desktop. We use classes and subclass to track our jobs revenue and expense. For customer invoicing we use the "rep" field to track the sales person.

How can we run a profit and loss by class using the sales rep and see all revenue AND expense for the class?

I bolded the information so it's more understandable.

Thanks

Pennee

jenop2

Thanks for getting back here with additional information about what details you need in the report, Pennee.

The sales rep feature in QuickBooks is primarily used to track the performance of your sales team. You can assign a rep when creating invoices and other sales transactions.

However, there's no option to assign it to expenses. This is why you can only see the revenue or sales details when customizing reports to show the rep by class.

For a more in-depth understanding of how QuickBooks produces data when generating reports, you can find additional explanations and details in this article: Understand Reports.

Since we're unable to include everything in a single report, you'll want to run the Sales by Rep report, Profit, Loss by Class, and any expense-type related reports separately. Then, export them to Excel so you can combine the report using Excel's function.

This will allow you to then combine the data from the other reports using Excel's functions and formulas. This way, you can get a comprehensive view of the sales and profitability data by bringing the information together in a single Excel workbook.

I'd be glad to show you how:

Open the report that you want to export.
Click the drop-down list beside Excel ▼, then select Create New Worksheet.
If you see a message that says your report has too many columns, select Advanced, then uncheck Space between columns.
Select OK, then click Export.

I'd also like to share these articles in case you need additional resources when doing similar tasks in QuickBooks:

If you have any further questions about analyzing sales performance or running reports in QuickBooks, please don't hesitate to come back and ask. The entire QuickBooks Team is always available to assist you.

View solution in original post

Eman_E

I appreciate you laying out the details for your concern. Let me provide some insights on how to run a profit and loss report by class using sales rep in QuickBooks Desktop (QBDT), @pennees.

We can customize the Profit and Loss by Class report and use the filter option to limit report data by selected criteria (rep). Since we can't see the sales rep and class in the column together.

Here's how:

In your Profit and Loss by Class report, click on Customize report.
From there, select on Filters option.
Enter rep in the search bar, then select the specific sales representative.
Once done hit on OK button.

However, if you want to see both the sales rep and class in the column we can utilize another report, particularly the Sales by Customer Detail.

Here's how:

Go to the Reports menu, then hover your mouse to Sales, then click on Sales by Customer Detail.
Click on Customize report, then enter rep in the search bar and put a checkmark, also enter class then put a checkmark.
Once done hit on OK button.

Moreover, you can visit these helpful articles for future help on understanding basic reports and customizing them in QuickBooks Desktop:

Feel free to return to this thread for further assistance with managing your reports on QBDT. I've got your back.

pennees

Thank you for your response. I tried to be clear in my description of what we are hoping for:

How can we run a profit and loss by class using the sales rep and see all revenue AND expense for the class?

We want to see the Class (job number for performance in our case) and show the class by Rep, so that the CFO can run one report "Profit and Loss by Class" and see the jobs for a chosen rep with income, expense, and net income.

When we run the profit and loss by class, then customize using the Rep, we only see the revenue (sales) for the rep by class, we cannot see the expenses and net income. Even the report Sales by Rep does not include the expense and net income.

I would appreciate it if someone knows how to accomplish both Rep, Revenue, expense, and net income in one report for Profit and Loss by Class.