Showing results for 
Search instead for 
Did you mean: 
Frequent Explorer *

Linking an expense/bill to a sales rep not reporting properly



I entered an expense (as a bill)  from a vendor to a sales rep (Rep RB) as well as the corresponding customer account  through the bill.  In our P&L by customer, this expense is shown but when I run the same P&L by Rep, the expense is not shown under Rep RB but under "No Sales Rep" even though it is linked through the bill as Rep RB.


What am i missing?


QuickBooks Team

Re: Linking an expense/bill to a sales rep not reporting properly

Hey there, @ryanavarisource.


You can verify the sales rep associated with your customer to show it on your Profit & Loss report. Let me guide you how.


To verify if the sales rep is saved on your customer information, you can follow the steps below:

  1. Click on Customers from the menu bar.
  2. Choose Customer Center.
  3. Select the customer associated with the bill.
  4. Click on Additional Info.
  5. Select the correct Rep.
  6. Click on Done.


Then pull up and customize your Profit & Loss Detail report again. Here's how:

  1. Click on Reports from the menu bar.
  2. Choose Company & Financial.
  3. Select Profit & Loss Detail.
  4. Click on Customize Report.
  5. From the Columns box, select Rep.
  6. Click on OK.



But if it still doesn't show, you can run the Verify & Rebuild Data utilities. This way, you can check if there's a damage in your company file.


Please fill me in if you have any other concerns. I'll be here to help.

Frequent Explorer *

Re: Linking an expense/bill to a sales rep not reporting properly

Thank you for the reply.  the sales rep ID is set up correctly in the customer info so i know that is not the issue.  The report i am running is P&L by Job and using the Show Columns Header to change from Customer:Job to Rep.  I will try doing a rebuild as this doesn't look right (and my balance sheet is off so maybe that is the issue).


On another note, we had a sales call from someone claiming to be QB support which i think is a third party company trying to sell services- no one from Inuit would call us, right?

QuickBooks Team

Re: Linking an expense/bill to a sales rep not reporting properly

Thanks for getting back to us, @ryanavarisource.

The No sales rep column should only include transactions without reps assigned to it. In this case, it’s a good idea to run the Verify and Rebuild Utility Tool to fix any damage to the company file.

Always create a backup to avoid any accidental data loss before performing the following steps.

  1. Go to the File menu.
  2. Select Utilities, then Rebuild Data.
  3. Click OK on the QuickBooks Information window. 
  4. Follow the prompt to save a backup.
  5. Hit OK when you see Rebuild has completed.

rebuild 1.PNG rebuild 2.PNG rebuild 3.PNG


Once done, follow the instructions above except select verify instead of rebuild. Check out this article for reference: Resolve data damage. In the same link, you’ll find other data damage troubleshooting steps for Windows.

When it comes to the call you received, the QuickBooks Team here in the Community doesn’t have the tools to initiate a callback. You have to send a request through your QuickBooks Desktop Help menu, so one of our representatives can reach you.

Do not provide any personal information for security reasons. I suggest calling us instead for questions related to billing and account status. 

Here's a link to guide you on how to contact phone support:  Contact the QuickBooks Desktop Customer Support Team.

That should answer your concern for today. 

Let me know how it goes and if you have any questions. I’m always ready to help. Have a great day!

Frequent Explorer *

Re: Linking an expense/bill to a sales rep not reporting properly

The rebuild did not change anything.  What is interesting is that when looking at this P&L, the expense that shows up under "No Sales Rep" instead of the correct "RB" Rep, shows up on the report when I change the filter to be only rep "RB".   It is like "no sales rep" is linked to "RB" but they don't show on the same column.  To make it more odd, when i drill down on the expense GL (8205 -consulting expenses) for No Sales Rep, the report is empty but when i drill down on the same expense GL (8205 -consulting expenses) for rep RB the expense shows correctly.Capture2.JPG Capture3.JPG Capture4.JPG



QuickBooks Team

Re: Linking an expense/bill to a sales rep not reporting properly

Hello @ryanavarisource,


Let me route you to the best help available so someone can privately review your account and get your concern about your transactions on your reports addressed.


But first, I'd like to thank you for taking the time to explain the results you've validated after following the steps shared by my colleague above.


please know that here in the Community, we don't have a direct view of your account for security reasons. Thus said, I'd recommend contacting our Customer Care Support.


They can pull up and look into your account in a secure environment and share the steps need so you can show your bill or expense transactions with Sales Rep in your Profit & Loss by Job report.


That being said, here's how you can contact our dedicated support:

  1. Go to Help.
  2. Select QuickBooks Desktop Help.
  3. Click Contact us.
  4. Enter Bill or Expense Transactions with Sales Rep not showing on Profit & Loss by Job Report in the Tell us more about your question: field.
  5. Select Search.
  6. Click Start a Message.

As always, you can visit our Help Articles page for QuickBooks Desktop if in case you need to learn some "How do I" steps.


Please let me know in the comment section below if you have any other questions. I'll be always around to help.