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

PattyF700 · ‎April 18, 2019

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?

Rose-A · ‎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:

Click Banking at the top menu bar and choose to Write Checks.
Under Expenses, choose the accounts.
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.

View solution in original post

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:

In the report screen, click Customize Report.
Go to the Filters tab.
Search and choose the Transaction Type.
Under Transaction Type, choose Multiple Transaction Types.
Choose the transaction type or Journal.
Click OK.
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.

PattyF700 · ‎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 · ‎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:

Click Banking at the top menu bar and choose to Write Checks.
Under Expenses, choose the accounts.
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.

PattyF700 · ‎April 18, 2019

Thank you so much! That should solve my problem :)

Rose-A · ‎April 18, 2019

Hi, PattyF700.

You know where to find me if you have any other questions. Don't work too hard. Take care.

Topics

Training

Community

Resources

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