Skip to main content
Solved

How to set up a formula to calculate a benefit amount


Hello!

We have 2 company benefits that we give the employee the option to pay the taxes on, so if they ever need to use it, they won’t be taxed on it.  The deduction is based on a formula, and doesn’t fit in to any of the preset options on the Deduction/Benefit set up (of being calculated as a flat amount, % of gross, % of net, % of custom, or amount by hour) 

The formulas are ((employee hourly rate x 2080)/52) x .00289 for the 1st benefit

for the 2nd benefit ((employee hourly rate x 40 x 0.60)/10) x 0.052

Any suggestions on how to set this up? 

Thank you!

Best answer by mikedavidson07

I have several companies using Acumatica payroll and have not encountered this situation yet.  It really sounds like there is a need for an advanced calculation method to handle this.  This is a good example for submitting a new idea, as I sure it will get a lot of up votes.  Acumatica development staff monitor these ideas and work hard to incorporate them into future versions. If you submit the idea, it might be helpful to include how you wound envision the new screen or calculation to work.

Link: https://community.acumatica.com/ideas

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

4 replies

mikedavidson07
Jr Varsity II
Forum|alt.badge.img+1

I don’t think Acumatica can handle this type of benefit calculation under the options available in the employer contribution settings.  This would be a manual process.  You can always submit it to the Acumatica Ideas section: https://community.acumatica.com/ideas


Laura Carpenter
Varsity II
Forum|alt.badge.img

I agree with Mike, I have the same issue.  I calculate the rates outside of the system and enter them as specific rates on the employee’s payroll deduction & benefits settings.  It would be great to have a formula creating these rates for the employees. 


mikedavidson07
Jr Varsity II
Forum|alt.badge.img+1
  • Jr Varsity II
  • 45 replies
  • Answer
  • March 24, 2022

I have several companies using Acumatica payroll and have not encountered this situation yet.  It really sounds like there is a need for an advanced calculation method to handle this.  This is a good example for submitting a new idea, as I sure it will get a lot of up votes.  Acumatica development staff monitor these ideas and work hard to incorporate them into future versions. If you submit the idea, it might be helpful to include how you wound envision the new screen or calculation to work.

Link: https://community.acumatica.com/ideas


  • Freshman I
  • 1 reply
  • June 17, 2024

Has Acumatica added the ability to do an advanced benefit calculation?  I need to setup LTD and Life insurance and it is based on a formula calculation.  

((employee hourly rate x 2080)/26) x .0133)


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