Skip to main content
Answer

Accruing payroll costs

  • December 2, 2022
  • 2 replies
  • 272 views

We are setting up our construction program to track labor hours on the jobs.  We are going to be using a labor cost rate to accrue the cost of the payroll.  We run payroll bi-weekly using a third-party to process.  We will export the hours along with the job info to a spreadsheet to upload to our third-party.  They will run the payroll and send us a GL download of the actual costs on a per job basis that we will import in to Acumatica to get the actual labor costs to the projects. If we set it up to accrue to the labor cost on the job and have an offsetting liability account how to we reverse the accrual when we import the actual labor costs from the third-party or account for the difference in the accrual vs actual?

TYIA!

Best answer by raphrf

We are setting up our construction program to track labor hours on the jobs.  We are going to be using a labor cost rate to accrue the cost of the payroll.  We run payroll bi-weekly using a third-party to process.  We will export the hours along with the job info to a spreadsheet to upload to our third-party.  They will run the payroll and send us a GL download of the actual costs on a per job basis that we will import in to Acumatica to get the actual labor costs to the projects. If we set it up to accrue to the labor cost on the job and have an offsetting liability account how to we reverse the accrual when we import the actual labor costs from the third-party or account for the difference in the accrual vs actual?

TYIA!

We are the same questions and are in the same process! I think you can reverse GL project transactions, or you can calculate the difference(offset) from the theorical GL amount accrued and the real amount and import the difference. Hope this help, for my part I’m check first the export of timecard/time activity/expense claims. I will PM you 

2 replies

Forum|alt.badge.img+1
  • Captain I
  • Answer
  • December 2, 2022

We are setting up our construction program to track labor hours on the jobs.  We are going to be using a labor cost rate to accrue the cost of the payroll.  We run payroll bi-weekly using a third-party to process.  We will export the hours along with the job info to a spreadsheet to upload to our third-party.  They will run the payroll and send us a GL download of the actual costs on a per job basis that we will import in to Acumatica to get the actual labor costs to the projects. If we set it up to accrue to the labor cost on the job and have an offsetting liability account how to we reverse the accrual when we import the actual labor costs from the third-party or account for the difference in the accrual vs actual?

TYIA!

We are the same questions and are in the same process! I think you can reverse GL project transactions, or you can calculate the difference(offset) from the theorical GL amount accrued and the real amount and import the difference. Hope this help, for my part I’m check first the export of timecard/time activity/expense claims. I will PM you 


Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • December 5, 2022

@raphrf@mlatt   When you are accruing, are you posting to the GL as well?  If you accrue to a specific account group, maybe “accrlabor” instead of ”Labor” then it will be easier to reverse that entire account group with an entry.  Does this work for you?