Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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
Solved! Go to Solution.
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:
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.
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:
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:
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.
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.
Thanks
Pennee
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:
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.
I am the treasurer of my Rotary club. I do a lot of invoicing which people will pay online or they may send checks in.
My problem is that when I then credit the payment to the invoice, the bank deposit also will get classified as uncategorized income. When I do my profit loss statement it will then show twice the income, that from the income of the invoice and then from the bank deposit.
I am not sure how I prevent that from happening
Thank you in advance
I can help you correct the Uncategorized Income to the correct account in QuickBooks Desktop (QBDT), @drmendbone.
The first thing is to ensure that when you receive a payment, you match it to the corresponding invoice. This way, QuickBooks will recognize it as a payment against an invoice rather than a new income.
Here's how:
The second thing is to categorize the deposits correctly. If deposits are already recorded, you can reclassify them to the correct account. Follow these steps:
The next thing is to check your Chart of Accounts. Make sure that your income accounts are set up correctly. Lastly, you can Run reports to verify. After making the changes run your Profit and Loss statement again to ensure that the income is not double counted.
Moreover, you can use this article for your future reference about reconciling accounts in QuickBooks Desktop. It has complete instructions to ensure everything is properly recorded.
If you have any other additional concerns regarding uncategorized income or any other concerns in QBDT, please add them below. I'll be sure to get back to you to help.
This seems like a good explanation but I'm still not clear how to do it. I have a merchant services account for our invoicing etc.
Is there a way I can schedule online help with you?
[Removed]
Treasurer, Homestead Rotary Club
This seems like a good explanation but I'm still not clear how to do it. I have a merchant services account for our invoicing etc.
Is there a way I can schedule online help with you?
[Removed]
Treasurer, Homestead Rotary Club
I appreciate you for the quick response to this thread, Drmendbone. I'd be glad to route you in the right direction for support regarding this matter.
In QuickBooks, you can request a call from our support whenever you need further assistance when utilizing the software to carry out different business tasks.
Here's how to get a callback from our Support Team.
After that, you'll expect to receive a callback from our Support Team within 5 minutes, depending on the queue.
You can also check out our operating hours to get help on their available time.
Furthermore, you can visit to this article to ensure your balance is the same as your actual bank account: Reconcile an account in QuickBooks Desktop.
If you ever need further assistance, do not hesitate to reply to this thread about uncategorized income transactions. I'll always be here to listen and help you.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here