Skip to main content
P
PattyF700
April 18, 2019
Solved

How to get labor costs from 3rd Party payroll service allocated to jobs?

  • April 18, 2019
  • 1 reply
  • 0 views

My company uses a 3rd party payroll service which provides me with the journal entry needed to record each week's payroll.  I use a general journal entry to record these transactions.  However when we have some labor costs that pertain to a job, even though I indicate the customer/job number and select the billable box, these numbers do not show up on the Job Work In Progress reports.  How do I allocate payroll costs to specific jobs in this situation?

Best answer by Rose-A

Thanks for getting back to me, PattyF700.

Allow me to help you further and provide you additional steps to allocate your payroll costs in QuickBooks Desktop for Mac.

 

I appreciate you getting back to me and letting me know you tried out the steps I previously sent. As a workaround, you can enter your payroll costs via checks in QuickBooks.

 

Through this, you can enter your Payroll Expense for gross pay and Payroll Liability for employee paid tax as a negative amount.

 

Here's how:

 

  1. Click Banking at the top menu bar and choose to Write Checks.
  2. Under Expenses, choose the accounts.
  3. Enter the amounts.

 

 

After that, you can pull up and run the report again. For company paid tax, you can use Journal Entry to record it.

 

You can always get back to me if there's anything else you need with allocating your payroll costs. I'll be here to help.

1 reply

Rose-A
Rose-A
April 18, 2019

Good day, PattyF700.

Allow me to help you allocate payroll costs for specific jobs in the Job Work in Progress report in QuickBooks.

 

To allocate payroll costs, you can customize and filter the report by the Transaction Type.

 

To do this, here's how:

 

  1. In the report screen, click Customize Report.
  2. Go to the Filters tab.
  3. Search and choose the Transaction Type.
  4. Under Transaction Type, choose Multiple Transaction Types.
  5. Choose the transaction type or Journal.
  6. Click OK.
  7. Hit OK.

 

 

You may find this article helpful: Customize item reports.

 

Let me know how it goes by leaving a reply below. I'll be around to help you allocate your payroll costs, have a good one.

P
PattyF700Author
April 18, 2019

Thank you RoseMarjorieA.  Unfortunately that didn't solve the problem.  When I filter it for the transaction type of "Journal", I get nothing at all.  It appears that job charges entered through a general journal entry don't flow through to the WIP report.  I'm thinking there must be some kind of workaround though.

Rose-A
Rose-AAnswer
April 18, 2019

Thanks for getting back to me, PattyF700.

Allow me to help you further and provide you additional steps to allocate your payroll costs in QuickBooks Desktop for Mac.

 

I appreciate you getting back to me and letting me know you tried out the steps I previously sent. As a workaround, you can enter your payroll costs via checks in QuickBooks.

 

Through this, you can enter your Payroll Expense for gross pay and Payroll Liability for employee paid tax as a negative amount.

 

Here's how:

 

  1. Click Banking at the top menu bar and choose to Write Checks.
  2. Under Expenses, choose the accounts.
  3. Enter the amounts.

 

 

After that, you can pull up and run the report again. For company paid tax, you can use Journal Entry to record it.

 

You can always get back to me if there's anything else you need with allocating your payroll costs. I'll be here to help.

    Terms & ConditionsAccessibility statement