This is an old revision of the document!
Human Resources > Utilities > Payroll Accrual Variance Extract > Extract
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.
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.
The Run button is enabled when an employee is selected and moved to the right side of the page. When the user clicks Run, the system performs the accrual calculations for the selected employee's current and future pay dates. The Report tab is enabled when calculations are completed.
Notes:
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.
The system displays all available employees for the pay frequency on the left side of the page. Select which employees to extract using the following buttons:
- Click to move selected entries from the left side to the right side of the page.
- Click to move all entries from the left side to the right side of the page.
- Click to move selected entries from the right side to the left side of the page.
- Click to move all entries from the right side to the left side of the page.
Only the employees selected on the right side of the window are processed. After employees are selected, the Run button is enabled.
Click Run. The accruals are calculated for the selected employee's unprocessed pay dates.
Note: This process should only be run by one user at a time.
If variance processing records already exist in the temporary tables when the user clicks Run, the user will be prompted to clear all previously calculated accrual variances.
If another user has initiated the calculation process, a message box is displayed indicating that the accrual variance is already being calculated.
If there were any errors encountered during the extract, the system displays the Payroll Accrual Variance Calculation Errors listing. Users have the option to click Print to capture the error listing or Cancel to continue with the extract.
Review the report using the following buttons:
Click
to go to the first page of the report.
Click
to go back one page.
Click
to go forward one page.
Click
to go to the last page of the report.
The report can be viewed and saved in various file formats.
Click
to save and print the report in PDF format.
Click
to save and print the report in CSV format. (This option is not available for all reports.) When a report is exported to the CSV format, the report headers may not be included.
Click X to close the report window. Some reports may have a Close Report, Exit, or Cancel button instead.
It is highly recommended that users clear all errors prior to continuing with the extract process.
Once the extract is complete, the Reports tab is enabled.
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.