Extract - HRS8350

This utility is used to select an individual or group of employees and calculate the proposed accrual calculations for the remainder of the unprocessed pay dates from the pay dates table to show employees/accounts that may be over- or under-accrued. This extract can be run before any payrolls are processed for a new school year or during the school year. It is highly recommended that a limited number of employees be selected for calculation as it takes some time to process the information and provide a report. The purpose of this feature is to assist you in verifying your data and making corrections to the employee Staff Job/Pay Data or Accrual Calendar, as needed.

Caution: If no pay dates have been processed for the school year, only pay dates that are greater than or equal to the first pay date of the school year in HR Options are considered. If pay dates have been processed for the school year, only unprocessed pay dates that are greater than the last processed pay date are considered. For example, if there is an unprocessed pay date for May 25 and a processed pay date for May 26, the May 25 pay date is not considered for the variance calculations. Once an employee has reached the TRS IRS salary cap, the accrual variance process should not be calculated for an employee if the employee has a federal fund in his master distribution. The accrual variance process attempts to synchronize the grant and TRS employer care amounts based on the accrued pay and not based on the amounts that normally would be reported for the employee when his salary cap is reached.

Only employees that are active and currently have a job that accrues are displayed. If an employee has multiple jobs, only the jobs that are selected to accrue are calculated, and each job is listed separately. The Accrual Calendar table and the Pay Date table must be completed for all school year pay dates. When performing calculations, the system uses the accrual calendar, the Pay Date table, the pay distribution history, the master distribution records, and the Accrual Expense table.

Example: An employee has a contract of $61,187.00 with 11 months in contract, 12 annual payments, and 220 days employed. The employee’s daily rate is $278.123. The first pay date for the contract was in August of the previous year with a payoff date of July 25. There are 6 days in the accrual calendar for the payoff pay date, thus indicating that the district is expecting to expense the 6 days during payoff. Currently, the employee has $1,761.46 in his school YTD for accrued pay with 153 days earned. His contract balance is $20,395.68 with a pay rate of $5,098.92 and 4 remaining payments. If the accrual variance is extracted for the employee, the variance indicates a $.02 variance. However, if the payrolls are calculated through payoff with the accrual calendar as defined, the employee expenses in the payoff pay date. For the 3 payments prior to the payoff, the additional accrued pay is $1668.74 or (61 x $278.123) - ($5,098.92 x 3) = $16,965.50 - $15,296.76. After the June payroll, the accrued pay on the school YTD would be $3,430.20. When the final pay roll is run, the accrued pay is zeroed and would cause an expense of $1,668.72 or $5,098.92 - $3,430.20. If the days earned for the payoff date are multiplied out and compared to the expense of the payoff pay date, you can see that the variance is correct or $278.123 x 6 = $1,668.74 - $1,668.72, thus indicating the variance of $.02.