cancel
Showing results for 
Search instead for 
Did you mean: 
cmcclung
Level 2

How do I get job related payroll to show in COGS on the Standard P&L in stead of Payroll Expense?

We use QB Time for entering our timesheets and hours are tracked to each job there.  The job profitability reports show the labor to the COGS items just fine but when I run a Standard P&L for the company, those labor costs are showing in Payroll Expenses instead of COGS.  

 

Is there a way to fix this so that job related payroll shows in COGS on the main P&L? 

3 Comments 3
JamaicaA
QuickBooks Team

How do I get job related payroll to show in COGS on the Standard P&L in stead of Payroll Expense?

You need to link the job-related payroll expenses to a sales transaction to categorize it under COGS, cmcclung. I can clarify when it becomes a Payroll Expense in the P&L report.

 

Once you enter the paychecks for the employees, the labor costs for each job will be visible on the Job Profitability report. Since the company covers their worker's payroll, it's recorded as Payroll Expense in the Profit & Loss report.

4.png

 

Additionally, the service item will appear under COGS after you add the billable timesheet to an invoice or sales receipt. This account type is for a profit center associated with customer tasks or jobs. Here's an article for more information about tracking the money you spend and make: Track job costs in QuickBooks Desktop.

5.png

 

Moreover, this material outlines the steps to personalize reports according to your needs: Customize payroll and employee reports.

 

This thread will remain open for additional questions about tracking jobs or reports. Post here anytime you need immediate help with QuickBooks.

cmcclung
Level 2

How do I get job related payroll to show in COGS on the Standard P&L in stead of Payroll Expense?

So, what I am gathering is if I pull the billable items into an invoice and bill to the customer, it will then move the costs on the P&L from Payroll Expense to COGS ?   

GenmarieM
QuickBooks Team

How do I get job related payroll to show in COGS on the Standard P&L in stead of Payroll Expense?

Thanks for getting back here in the Community, cmcclung. Let me share details about showing job-related payroll expenses in Cost of Goods Sold (COGS) instead of Payroll Expenses on your Profit and Loss report.

 

It is crucial to understand that billing a client for billable items will not automatically transfer the costs from Payroll Expense to COGS. The expenses remain in the Payroll Expense account unless the payroll item's associated account is specifically modified to COGS. This action guarantees the items are recorded under Cost of Goods Sold on QuickBooks Enterprise's Profit and Loss report.

 

Here's how to change the tracking expense account of your item:

 

  1. Go to Lists, then click Payroll Item List.
    .1.png
  2. Choose an item and double-click to edit.
    .2.png
  3. Click Next.
    .4.png
  4. Hit the dropdown arrow and look for the Cost of Goods sold account
    .5.png
  5. Once done, click Finish.
    .6.png

 

That will cause your labor costs to be categorized under COGS when running a Profit and Loss report.

 

Moreover, feel free to visit these articles as your reference for customizing different types of reports in QBDT:

 

 

Shoot me a reply if you need further assistance with tracking your payroll items and running payroll reports in QuickBooks Enterprise. I'll be here to lend a hand.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us