Problem:
I need to define a formula for a deduction or a benefit and I would like it tiered. How do I go about this?
Solution:
Paymate uses Payroll Categories to define Earnings, Benefits, Deductions, Payroll Tax, Accrual, and miscellaneous items. When you define a formula deduction or a formula benefit, you may specify it as Two Tiered.
When you click on Two Tiered Calculation you will see 4 more fields:
Annual Threshold |
% to apply to Lower Tier |
% to apply to Higher Tier |
Prorate Threshold |
Example 1, if you specify:
- The formula as 100% of all Earnings
- The Annual Threshold as $40000.00
- The % for Lower Tier as 2%
- The Higher Tier as 4.8%
- Prorate Threshold is checked
Then the calculation on a single payroll would look like the following:
- Employee is paid Monthly
- Employee has $4000.00 paid on January timesheet
- Threshold on this timesheet would be $3333.33 (Annual Threshold / Employee Pay Frequency)
- 2% of $3333.33 is $66.67
- 4.8% of $666.67 is $32.00
- Result would be $98.67
Example 2, if you specify:
- The formula as 100% of all Earnings
- The Annual Threshold as $800.00
- The % for Lower Tier as 2%
- The Higher Tier as 4.8%
- Prorate threshold is unchecked
Then the calculation on a single payroll would look like this:
- Employee is paid Monthly
- Employee has $4000.00 paid on January timesheet
- 2% of $4000.00 is $80.00
- Result would be $80.00
Acclaim will use the lower tier percentage until the year-to-date of this category is reached to annual threshold ($800.00), then the program will use the higher tier percentage.