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

jason52 · ‎November 20, 2019

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.

RenjolynC · ‎November 20, 2019

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.

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

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

View solution in original post

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.

jason52 · ‎November 20, 2019

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

jason52 · ‎November 20, 2019

That's not in play here.

None of the clients in question have projects linked to them. When I click on the dollar amount it takes me to the employee's paycheck...not any expenses tied to the client.

ChristieAnn · ‎November 20, 2019

Hi there, jason52.

I know that you've already been in contact with our chat support. However, to assist you further on your Profit and Loss by Client report to show the employee/payroll information, I suggest contacting them again. They have the necessary tools like screen sharing to check and pull up your account to see why the issue persists.

Follow the steps below on how to reach them:

1. Open your QuickBooks Account.

2. At the top right, click the Help icon.

3. Click Contact Us.

4. Under What can we help you with?, enter any concerns.

5. Click Let's Talk.

6. You'll be routed into the Choose a way to connect with us page.

7. Select how you want to contact them and fill in the information.

You may check this article on how to customize your reports to see the specific data or details that matter the most: Customize your reports in QuickBooks Online.

Let me know if there's anything else I can do to help you succeed with QuickBooks.

jason52 · ‎November 20, 2019

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.

RenjolynC · ‎November 20, 2019

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.

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

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

jason52 · ‎November 21, 2019

This is exactly what I needed. Thank you!

Topics

Training

Community

Resources

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