Skip to main content
November 20, 2019
Solved

Why does my Profit and Loss by Client Report show employee/payroll information?

  • November 20, 2019
  • 1 reply
  • 0 views
I am trying to see my net income per client, by client, over the past year. I ran a P&L by Client report, but for some reason payroll data is showing up in this report. We don't charge payroll against client accounts; it comes out of our overall business funds. Payroll is not an expense that is "charged" against specific clients.

The strangest part is that the amounts charged against each client seem completely random. Some clients who provide thousands of dollars in income have no payroll charged against them, while some clients end up showing a net profit loss because they're being "charged" more payroll than they provide income.

I was in chat, with screen share, with QBO for over an hour a couple of days ago and never got an answer.

How do I get this line eliminated from this report? It's giving me false totals.
Best answer by RenjolynC

I did that already. I spent an hour with them. They couldn't find the issue in that time and promised to get back to me. They never did.

 

This is why I came to the forums.


You'll want to customize the report, jason52.

 

The Profit and Loss by Client will display all your income, expenses, and net income. The only difference is that this report is grouped by clients. This is why you still see the payroll expense accounts. 

 

You can follow these steps to exclude the payroll expense accounts.

  1. On the left panel, click Reports.
  2. Click the Profit and Loss by Client report under Business overview.
  3. Change the Report period, and click the Customize button.
  4. Select Filter, and from the Distribution Account drop-down menu, put a check mark on the Select All box.
  5. Un-check all payroll expense related accounts.
  6. Click the Run report button.

I'm just a few clicks away if you need more help with QuickBooks Online reports. Thanks.

1 reply

Rose-A
November 20, 2019

Hello, jason52.

 

Taxes paid by the employer and customer that has a project and it is linked to employee's payroll will show under Payroll Expenses on the Profit and Loss by Customer Report.

 

 

 

In case you want to know some "How do I" steps in QuickBooks Online, you can always visit our Help Articles page for reference.

 

Please get back to me if you have any other QuickBooks concerns. Have a nice day.

jason52Author
November 20, 2019

That makes sense, but none of the clients in question have projects linked to them.