Skip to main content
Answer

Post Payroll Transactions Based on Date Worked

  • April 30, 2025
  • 4 replies
  • 83 views

Hello,

 

Is it possible to have Acumatica post payroll transactions based on the date worked rather than the period end date or the pay date?  

 

We pay employees bi-weekly, and there are instances where the majority of the hours worked fall into the month prior to the end date/payment date, but the entire payroll is posted in the following month.  It affects job costing and WIP calculations and makes month over month comparatives look questionable. Our previous system did this through an option in the payroll preferences, but I can’t find a way to do it in Acumatica without having to do allocation entries, which is incredibly time consuming.  I’m hoping I’m just missing something.

 

Thank You :)

Best answer by Sonia Echols

Hi tdawson,

There is an idea in community you may want to vote on, 

Sonia Echols

4 replies

pbennett
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • April 30, 2025

Hello ​@tdawson 

I believe that the transaction date is the driver for the paycheck per the government; having said that, what you can do is at the end of the month create a reversing entry to accrue the portion of the payroll to the correct month. That is what we do here and we also do payroll on a biweekly basis.

 


Sonia Echols
Acumatica Moderator
Forum|alt.badge.img+1
  • Acumatica Moderator
  • Answer
  • April 30, 2025

Hi tdawson,

There is an idea in community you may want to vote on, 

Sonia Echols


  • Author
  • Freshman I
  • April 30, 2025

Hi tdawson,

There is an idea in community you may want to vote on, 

Sonia Echols

 

I went in and upvoted.  Looks like it’s 3 years in the making, so that’s unfortunate, but I’m happy to lend my support either way!


  • Author
  • Freshman I
  • April 30, 2025

Hello ​@tdawson 

I believe that the transaction date is the driver for the paycheck per the government; having said that, what you can do is at the end of the month create a reversing entry to accrue the portion of the payroll to the correct month. That is what we do here and we also do payroll on a biweekly basis.

 

This is a good idea; however, with the significant number of entries to projects, it creates an extraordinarily large number of additional transaction lines, and it frustrates the Project Managers to see all of these debits and credits.  That being said, I do recall being told something about an adjustment period that I may be able to use to achieve this, so I’m going to look more into that.  

In every other system I’ve worked in, the transactions get posted to a payroll clearing account upon entry and are then cleared out through the cash account on the pay date.  This allows for accruals to be recorded in the correct month.  Having it come straight out of the cash account through the payroll posting is a strange accounting practice, but maybe that’s typical in the US, whereas I’m in Canada.