Benefit Table
Use this table to add, change, delete, and print employerpaid benefits extracted from Human Resources' Deduction table. When you run the extraction, the system ignores records that do not include benefits since they have no bearing on budgeting employer costs.
In Personnel Budgeting, you may need to update benefit records before running the employee extraction to reflect any changes in rates and distributions expected in the budget year.
The Benefit Table report includes benefit codes and titles, benefit methods, rates/amounts, number of pays, benefit charging codes, accounting distributions, and subject to FICA flags. The report's default file name is pdedtabl.rpt.
For the steps for adding, updating, deleting, and printing table records, refer to Table Options and Procedures.
Menu Path: Personnel Budgeting > Reference Tables > Reference Tables > Benefit Table
Important
- When benefits are extracted, the Number of Pays field defaults to zero. Be sure to update this field with the appropriate value.
- If your account structure needs to be changed in accordance with the Every Student Succeeds Act (ESSA), refer to the PowerSchool ERP Human Resources and Payroll Every Student Succeeds Act Fiscal Year-End Checklist for information on updating Deduction, Pay Code, and Tax tables with new year information.
Fields | Description |
|---|---|
Benefit Code | Code identifying the benefit. Character/4 |
Benefit Title | Title or description of the benefit. Character/25 |
Number of Pays | Number of times the benefit is to be paid during the budget year. The system uses the number of pays in calculating the benefit’s annual cost: Pay Period Amount x Number of Pays = Annual Cost The pay period amount can be either a percentage of the employee’s pay or a flat amount, as determined by the Benefit Method field. However, no entry is required for percentage benefits (methods P and R), since the system can determine the costs by multiplying the annual salaries by the percentages. |
Benefit Method | Setting identifying the method used to calculate the benefit’s per period cost. Select: N - None - No amount or percentage For budgeting purposes, you may enter a benefit method different from the one used in Human Resources, as long as you make the corresponding changes in the Number of Pays and Benefit Rate/Amt. fields. For example, if a benefit cost is being increased and you know the average cost per employee, you could change an R or S method to A, and then enter the average amount in the Benefit Rate/Amt. field. |
Benefit Rate/Amt | Percentage or amount used to determine the benefit’s per period cost. An entry is only required with the following benefit methods: P - % from table rec - Enter the percentage as a decimal (5% = 0.05). The system calculates the annual cost as follows: Annual Base Salary x Percentage. A - Amt from table rec - Enter the dollar amount per pay period. For R and S methods, which use employees’ pay rate records to store rates or amounts, leave the field at its zero default. |
Benefit Charging | Code determining how the benefit’s costs are distributed in the Budget Preparation System. You can apply the distributions stored in employees’ rate records or override these defaults. Select: A - All Payrates The O - Use Override Accounts setting requires you to complete the *Budget Unit*, *Project*, and Benefit Account fields. The other benefit charging methods use the distributions stored in employee pay rates. |
Budget Unit | Low organization for distributing the benefit costs in Fund Accounting. If you selected O - Override Accounts in the Benefit Charging field, you must identify the budget unit being charged for this benefit. Also, the budget unit and benefit account combination must identify a valid expense ledger. |
Note | As indicated by the asterisks, the titles of the *Budget Unit* and *Project* fields are defined in the Budget Preparation Profile. |
Project | If you enter O - Override Accounts in the Benefit Charging field, you can specify a project ledger if needed. |
Benefit Account | Expense account for distributing benefit costs. The budget unit and account combine to identify the expenditure ledger to charge. The distribution depends on your entry in the Benefit Charging field: A - All Payrates - Uses the budget unit-benefit account combinations stored in primary and secondary pay rates. P - Primary Payrate - Uses the budget unit-benefit account combinations from primary rates only. O - Use Override Accounts - Uses the budget unit-benefit account combination entered in this window, overriding the distributions in pay rates. If you are not charging the benefit to an expense ledger, enter 99999999. |
Benefit Subject to FICA | Checkbox indicating whether the benefit is subject to FICA and Medicare taxes. Select the box if the taxes apply, in which case, the tax amounts should be added to employees’ FICA/Medicare gross wages. Leave the box blank if the employer contributions are not considered a taxable benefit. |
Subjective Gross | Setting determining the gross amount to use as the basis for calculating benefits with the Salary and Fringe Calculation option. This field applies to P - % from table rec, R - % from empl rec, and M - % grs+add’l benefit methods. Select: TT - Total Gross - Benefit calculated on total gross pay. FI - FICA Tax Gross - Benefit calculated on FICA taxable gross. MD - Medicare Tax Gross - Benefit calculated on Medicare taxable gross. FD - Federal Tax Gross - Benefit calculated on federal taxable gross. ST - State Tax Gross - Benefit calculated on state taxable gross. LC - Local Tax Gross - Benefit calculated local taxable gross. SP - Subject Tax Gross - Benefit calculated on gross amount, as determined by deduction exemptions on individual pay codes. The field’s default is SP-Subject Tax Gross, which should apply to most circumstances. |