Differences

This shows you the differences between two versions of the page.

--- humanresources:utilities:payrollaccrualvarianceextract:extract [2019/10/28 15:55] – emoreno
+++ humanresources:utilities:payrollaccrualvarianceextract:extract [2020/09/28 18:26] (current) – removed emoreno
@@ Line 1: / Line 1: @@
-======Extract - HRS8350======
-<div #message></div>
-//**Human Resources > Utilities > Payroll Accrual Variance Extract > Extract**//
-<WRAP round intro>This tab 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.
-<color #ed1c24>**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.</color>
-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.
-**Notes**:
-  * The purpose of the extract is to provide an accurate view of the proposed accrual calculations at this moment in time. Therefore, all unprocessed absence deductions and coded absence deduction transmittals are used in calculating the future amounts for the accruals. Any amounts entered in the **Days Earned** column of the absence deduction transmittal override the days earned from the Accrual Calendar table for that pay date. Unprocessed leave transmittals that result in dock amounts for the employee are also considered.
-  * When calculating the variance for a pay date that is the employee’s payoff date for the job, the program considers the days earned for the payoff date, if there are any. If the employee is in early payoff and not all accrual days have been earned, or if the accrual calendar has days earned for the payoff date, there most likely is a difference in the amount of accruals reported for the variance processing versus the amount of accruals reported for the payroll processing for the payoff date.
-**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.
-</WRAP>
-====Extract payroll accrual variances:====
-{{page>general:humanresources:utilities:payrollaccrualvarianceextract:extract:body}}
-{{indexmenu_n>5}}

Business

Differences

Americans with Disabilities Act (ADA) and Web Accessibility

Business

User Tools

Site Tools

Differences

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility