Payroll - Job Costing

SUGGESTED

If anyone can offer suggestions on this I would greatly appreciate it. We issue payroll at our company bi-weekly. After payroll has been processed (we use an outside payroll company), I then come into sage and enter all the employees hours and job cost their time to the various jobs and work orders (we have the service module - but its the same thing as just posting it to a job if you don't have that). The issue I am running into is that we cannot see the labor until after two weeks. That is a serious lag for us when we want to review work orders that are completed in just one day. Does anyone have any better way of posting payroll to the various jobs or job costing their payroll? I thought that maybe the daily payroll would help, but again, it doesn't actually job cost anything. Nothing actually gets job costed until I hit the final compute. Help??

I tried calling support and she recommended making sure we input the hours the employee is supposed to work when we enter the work order but again that doesn't help us. We want to track how much time they actually are spending out there and see which jobs we are making or losing money, etc. So seeing the real costs.

Parents
  • 0

    If you use Daily Payroll, you can run the 6-1-12-31 report and get Accrued Payroll based on the unposted payroll hours.  Also, the 6-1-3-41 report shows the Payroll only detail with accrued payroll.  This only works for Job Costing and not Work Order only reporting.  Support is correct.  If you aren't using Jobs, then you should record actual payroll hours on the work order and import them into payroll.  That way you can easily reconcile payroll hours charged on a work order to the payroll hours paid to the employee.

  • 0 in reply to Kevin M Smith

    This still doesn't help me though because we want to see the costs for the work orders. (So if you look at a work order, and view - service order costs. Or by running various reports.) We are having issues with employees spending more time then they are supposed to out on the work orders. We can't put in the actual hours after the work order has already been posted/invoiced. So basically we have to do it from the payroll section. Support understood what I was asking but she didn't know of a good solution. I was hoping someone else would. We don't want to see a report of the employees hours, we just want to be able to look at different reports in the service module and see the labor hours spent on the job. But didn't want to have to wait until payroll is posted because there is a 2 week lag or more. Thank you so much though and hopefully someone has a good method for handling this situation!

  • 0 in reply to Exclusive

    You state that they are spending more "time" than they are supposed to on the work orders.  So you already know the "time" they are spending, just not the burdened cost.   You can probably write a work order report that will add the burden, but the "time" seems to really be the issue.

    If you are saying that they are turning in more hours on their timecards than what they reported on the work order for billing, then tell them from now on they only get paid for what they report on the work orders.  If you enter their time there before you bill it, then import their time.  When they only have 24 hours imported but claim they are working 40, show them what got imported and short pay them that week.  It will only happen once.  You should also look into GPS systems for tracking their whereabouts.  I know some companies have discovered their technicians were at home or elsewhere when they claim to be at the work site.

Reply
  • 0 in reply to Exclusive

    You state that they are spending more "time" than they are supposed to on the work orders.  So you already know the "time" they are spending, just not the burdened cost.   You can probably write a work order report that will add the burden, but the "time" seems to really be the issue.

    If you are saying that they are turning in more hours on their timecards than what they reported on the work order for billing, then tell them from now on they only get paid for what they report on the work orders.  If you enter their time there before you bill it, then import their time.  When they only have 24 hours imported but claim they are working 40, show them what got imported and short pay them that week.  It will only happen once.  You should also look into GPS systems for tracking their whereabouts.  I know some companies have discovered their technicians were at home or elsewhere when they claim to be at the work site.

Children
No Data