Skip to main content
Solved

Accruing payroll costs

  • 2 December 2022
  • 2 replies
  • 206 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

mlatt wrote:

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 

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+1
  • Semi-Pro III
  • 140 replies
  • Answer
  • December 2, 2022
mlatt wrote:

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+2
  • Community Manager
  • 248 replies
  • 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?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings