Payroll items and Cost of Goods Sold

lulubelle1956 · ‎March 26, 2019

I am using a very detailed Item List for a Design/Build Landscape Company. We track labor hours on timesheets by 30 +/- service items: Bed Prep, Excavation, Footers, Walls, Pool Decks, Patios, etc.

Payroll has all dumped into one 'Payroll Expense' account in the past. We want to see payroll go to each Cost of Goods Sold instead.

Do I have to create two Payroll Items for each Service Item in order to do this? I.e. Bed Prep Hourly, Bed Prep Overtime, Excavation Hourly, Excavation Overtime and so on.

This seems excessive! 60 +/- Payroll Items and then adding these Payroll Items to 25 +/- employees!

Is there a better option for this issue?

Thank you!

AldrinS · ‎March 26, 2019

Hi there, lulubelle1956.

Good to see you here in the Community. I'd be happy to provide some insight regarding this matter.

After some thorough research and testing, I found that you'll need to create a payroll item, with the correct Cost of Goods Sold (COGS) account to do this. Since you're unable to assign a COGS account to your items or use an Inventory item when entering timesheets. For additional insight about this, I'm also including these articles:

Let me know if there's anything else I can do for you, I want to make sure you're taken care of. Thanks for reaching out, wishing you and your business the best.

View solution in original post

JanyRoseB · ‎March 26, 2019

Thanks for getting back to us, lulubelle1956.

I appreciate you for considering the resolution provided by my colleague. It may be a long process, but this will surely help on resolving your issue.

Please know that you're always welcome to post if you have any other concerns. The Community team will always here to help. Wishing you and your business continued success.

View solution in original post

AldrinS · ‎March 26, 2019

Hi there, lulubelle1956.

Good to see you here in the Community. I'd be happy to provide some insight regarding this matter.

After some thorough research and testing, I found that you'll need to create a payroll item, with the correct Cost of Goods Sold (COGS) account to do this. Since you're unable to assign a COGS account to your items or use an Inventory item when entering timesheets. For additional insight about this, I'm also including these articles:

Let me know if there's anything else I can do for you, I want to make sure you're taken care of. Thanks for reaching out, wishing you and your business the best.

lulubelle1956 · ‎March 26, 2019

Thank you AldrinS,

If I understand the links, then I AM stuck with creating 2 payroll items per service item list and also adding each payroll item to the employee pay record so I can set up their pay rate!

This seems so cumbersome, time consuming, etc. I would have thought there was a was to over ride this in references for payroll.

Thank you for investigating for me! I was afraid this was going to be the answer.

JanyRoseB · ‎March 26, 2019

Thanks for getting back to us, lulubelle1956.

I appreciate you for considering the resolution provided by my colleague. It may be a long process, but this will surely help on resolving your issue.

Please know that you're always welcome to post if you have any other concerns. The Community team will always here to help. Wishing you and your business continued success.

Topics

Training

Community

Resources

Payroll items and Cost of Goods Sold