Business

User Tools

Site Tools

Trace: • Extract MACM - FIN8500 • BAR3000 - Customer Statement • Initialize Yearly Inventory Files - BWH6200 • BAR7000 - Invoice Offset Accounts Report • Print Checks - GRT8020
payroll:utilities:payrollaccrualvarianceextract:extract

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
payroll:utilities:payrollaccrualvarianceextract:extract [2020/06/12 20:30] – emorenopayroll:utilities:payrollaccrualvarianceextract:extract [2020/09/01 20:44] (current) – emoreno
Line 5: Line 5:
 //**Payroll > Utilities > Payroll Accrual Variance Extract > Extract**// //**Payroll > 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.+<WRAP round intro>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.
  
 <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. <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.
Line 13: Line 13:
 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. 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.
  
 +<WRAP box>
 **Notes**:   **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.+  * 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 overrides 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.   * 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.
 +</WRAP>
    
 **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. **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.
payroll/utilities/payrollaccrualvarianceextract/extract.1591993802.txt.gz · Last modified: 2020/06/12 15:30 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

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.