Business

User Tools

Site Tools

Trace: • Update Last Year Closing - BUD6000 • Accrual Overview • Mass Delete Credit Memos - FIN6200 • Out of Balance Correction • Perform an export
general:accrualoverview

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
general:accrualoverview [2021/05/06 16:13] – emorenogeneral:accrualoverview [2024/08/06 20:30] (current) – emoreno
Line 1: Line 1:
-====== August Accrual Overview ======+====== Accrual Overview ======
  
    
Line 53: Line 53:
  
  
-  * Accruals work by paying employees over 12 months what they have earned in 10 months (standard contract), districts accrue (accumulate) money in a ‘savings or reserve account code’ for employees. +  * Accruals work by paying employees over 12 months what they have earned in 10 months (standard contract), LEAs accrue (accumulate) money in a ‘savings or reserve account code’ for employees. 
-  * Accruing makes it possible for the district to account for an employee’s ‘earned pay’ each pay period while the employee is receiving a paycheck for the same standard pay amount for 12 months even though the employee does not work 12 calendar months.+  * Accruing makes it possible for the LEA to account for an employee’s ‘earned pay’ each pay period while the employee is receiving a paycheck for the same standard pay amount for 12 months even though the employee does not work 12 calendar months.
   * When payroll is run and salary is accrued, the system will debit the expenditure account (6XXX) and credit the accrual account (liability account-2XXX) and the cash account (1XXX), which increases the expenditure and increases the employee ‘savings’ account (accrual account code).   * When payroll is run and salary is accrued, the system will debit the expenditure account (6XXX) and credit the accrual account (liability account-2XXX) and the cash account (1XXX), which increases the expenditure and increases the employee ‘savings’ account (accrual account code).
   * When payroll is run and salary is withdrawn from accruals, the system will debit the accrual account (2XXX) and will credit cash (1XXX), which will decrease the employee savings account (accrual account code) and decrease cash.   * When payroll is run and salary is withdrawn from accruals, the system will debit the accrual account (2XXX) and will credit cash (1XXX), which will decrease the employee savings account (accrual account code) and decrease cash.
Line 63: Line 63:
  
   * Nonstandard employees are those who have a contract or work agreement beginning after June 30 but before September 1st of the same year and start receiving their new contract money in July or August.  These employees must have the **TRS Year** field selected on the [[payroll:maintenance:staffjobpaydata:jobinfo|Payroll > Maintenance > Staff Job/Pay Data > Job Info]] tab.   * Nonstandard employees are those who have a contract or work agreement beginning after June 30 but before September 1st of the same year and start receiving their new contract money in July or August.  These employees must have the **TRS Year** field selected on the [[payroll:maintenance:staffjobpaydata:jobinfo|Payroll > Maintenance > Staff Job/Pay Data > Job Info]] tab.
-  * By selecting the **TRS Year** field for employees who accrue, when accruals are calculated and posted for July and/or August payrolls, the system will create a School YTD for the following school year (e.g., 2021-2022).  The accrual amounts will display in the new school year and the actual pay amounts will remain in the current (e.g., 2020-2021) School YTD.  +  * By selecting the **TRS Year** field for employees who accrue, when accruals are calculated and posted for July and/or August payrolls, the system will create a School YTD for the following school year.  The accrual amounts will display in the new school year and the actual pay amounts will remain in the current School YTD.  
   * The system determines whether a new School YTD record for the accruals should be created based on the employee’s contract begin date and pay date. If the **TRS Year** is selected and the year of the contract begin date is equal to the pay date year, then the calculated accruals for the payroll will be recorded in the next school year.  **It is recommended** that this field is not selected when a nonstandard employee begins late in the school year; however, should be selected an employee contract starts again in July or August.     * The system determines whether a new School YTD record for the accruals should be created based on the employee’s contract begin date and pay date. If the **TRS Year** is selected and the year of the contract begin date is equal to the pay date year, then the calculated accruals for the payroll will be recorded in the next school year.  **It is recommended** that this field is not selected when a nonstandard employee begins late in the school year; however, should be selected an employee contract starts again in July or August.  
  
Line 75: Line 75:
 The August Accrual process is the beginning step in the process of accruing salaries and benefits through the Payroll application. The August Accrual process calculates salaries and benefits based on the employee’s days worked in August on their new contract salary, even though they will not be paid for the days worked in August until the new school year.  The number of workdays in August is multiplied by the daily rate for each employee that accrues. This amount is expensed in Finance in August when it was earned or incurred.   The August Accrual process is the beginning step in the process of accruing salaries and benefits through the Payroll application. The August Accrual process calculates salaries and benefits based on the employee’s days worked in August on their new contract salary, even though they will not be paid for the days worked in August until the new school year.  The number of workdays in August is multiplied by the daily rate for each employee that accrues. This amount is expensed in Finance in August when it was earned or incurred.  
  
-The Payroll application will access this reserve during the next school year when the employee’s actual pay is less than the earned pay (March and December) and when they are paid but not actually working during the summer months.    +The Payroll application will access this reserve during the next school year when the employee’s actual pay is less than the earned pay (March and December) and when they are paid but not actually working during the summer months. The date used for the August Accrual process should be a date after all actual August pay dates but not an actual pay date. **It is generally recommended to use August 31 in this process (only if there is not a payroll run on August 31)**. The August Accrual process is posted to payroll prior to the first September payroll being calculated for the new school year.  At this point, the Account Distribution Journal reflects an ‘ADJUST’ entry for each employee indicating the amount of salary earned/accrued and the related benefits calculated in the August Accrual process.   
- The date used for the August Accrual process should be a date after all actual August pay dates but not an actual pay date. It is recommended to use August 31 in this process.   +
-The August Accrual process is posted to payroll prior to the first September payroll being calculated for the new school year.  At this point, the Account Distribution Journal reflects an ‘ADJUST’ entry for each employee indicating the amount of salary earned/accrued and the related benefits calculated in the August Accrual process.   +
  
 {{:general:accrual_calculations_example.jpg|Accrual Calculations}} {{:general:accrual_calculations_example.jpg|Accrual Calculations}}
Line 102: Line 100:
 ^VCV|2. [[finance:inquiry:generalledgerinquiry:generalledgeraccountsummary|Finance > Inquiry > General Ledger Inquiry > General Ledger Account Summary]]\\  \\  Print the following object codes:\\  \\  <div indent>Accrued Wages 2161 (refer to print from Step 1 for correct code)\\  \\  Remaining Accrued fields 2211 by sub object (refer to Clearing Fund print from Step 1 for each sub object code)</div>| ^VCV|2. [[finance:inquiry:generalledgerinquiry:generalledgeraccountsummary|Finance > Inquiry > General Ledger Inquiry > General Ledger Account Summary]]\\  \\  Print the following object codes:\\  \\  <div indent>Accrued Wages 2161 (refer to print from Step 1 for correct code)\\  \\  Remaining Accrued fields 2211 by sub object (refer to Clearing Fund print from Step 1 for each sub object code)</div>|
 ^VCV|3. [[payroll:reports:yeartodatereports:schoolyeartodatereport|Payroll > Reports > Year to Date Reports > HRS3050 – School Year to Date Report]]\\  \\  <div indent>Verify the **School Year (YYYY)** parameter has the correct year.\\  \\  Generate the report and print the last page of this report.</div> |  ^VCV|3. [[payroll:reports:yeartodatereports:schoolyeartodatereport|Payroll > Reports > Year to Date Reports > HRS3050 – School Year to Date Report]]\\  \\  <div indent>Verify the **School Year (YYYY)** parameter has the correct year.\\  \\  Generate the report and print the last page of this report.</div> | 
-^VCV|4. Compare the amounts from each General Ledger Summary (from step 2) to the totals on the HRS3050 report. Keep in mind that all processed payrolls need to be interfaced to Finance in order for the reports to match.|+^VCV|4. Compare the amounts from each General Ledger Summary (from Step 2) to the totals on the HRS3050 report. Keep in mind that all processed payrolls need to be interfaced to Finance in order for the reports to match.|
  
 <WRAP center round tip > <WRAP center round tip >
Line 112: Line 110:
 =====Correcting Accruals===== =====Correcting Accruals=====
  
-How do accruals get out of balance? +**How do accruals get out of balance?** 
-• Adding and/or removing the employee’s Accrual Code throughout the year.  Once an employee begins accruing, the accrual code should NOT be removed, even for early payoff. +  * Adding and/or removing the employee’s **Accrual Code** throughout the year.  Once an employee begins accruing, the accrual code should NOT be removed, even for early payoff. 
-• The TRS Year box was incorrectly checked or unchecked causing the accruals to go to the wrong school year in HR. +  * The **TRS Year** checkbox was incorrectly selected/unselected causing the accruals to apply to the incorrect school year in Payroll. 
-• Total Days Worked in the Accrual Calendar for the month of August does not match the number of days that were actually used in the August Accrual process. +  * The **Total Days Worked** in the Accrual Calendar for the month of August does not match the number of days that were actually used in the August Accrual process. 
-• Accrual Rate does not match the current Daily Rate. +  * The **Accrual Rate** does not match the current **Daily Rate**. 
-• Daily Rate used in the August Accrual process does not match the current Accrual Rate. +  * The **Daily Rate** used in the August Accrual process does not match the current **Accrual Rate**. 
-• Contract Total was changed on the Job Info screen at some point during the year. +  * The **Contract Total** was changed on the Job Info tab at some point during the year. 
-• Employee started late in the year and the Days Earned were not adjusted. +  * The employee started late in the year and the **Days Earned** was not adjusted. 
-• Job Code was changed on Job Info screen. Since accruals are tied to the job code, there may be a possibility of the Accrual Code being removed from the Job Info screen as part of this change. +  * The **Job Code** was changed on the Job Info tab. Since accruals are tied to the job code, there may be a possibility of the **Accrual Code** being removed from the Job Info tab as part of this change. 
-• Employee is assigned to an incorrect Accrual Calendar - Total Days Worked in calendar does not match the employee’s total days worked for the school year.  +  * The employee is assigned to the incorrect Accrual Calendar - **Total Days Worked** in the calendar does not match the employee’s total days worked for the school year.  
-• Employee was not included in the August Accrual process. +  * The employee was not included in the August Accrual process. 
-NOTE:  Before making any corrections, the LEA should check and make sure the auditor did not make August accrual entries as audit entries.  If they made August audit entries, you would not want to expense again in the current year.+<WRAP box> 
 +**Note**:  Before making any corrections, the LEA should check and make sure the auditor did not make August accrual entries as audit entries.  If they made August audit entries, you would not want to expense again in the current year. 
 +</WRAP> 
 + 
 +**How do you correct accruals?**
  
-How do you correct accruals? 
 There are 4 different ways to correct accruals: There are 4 different ways to correct accruals:
-1. Days Earned field on the Absence Deduction tab – an employee starts late in the school year or when a replacement check is issued for an accrued employee. +  - **Days Earned** field on the Absence Deduction tab – an employee starts late in the school year or when a replacement check is issued for an accrued employee. 
-2. Payroll Accrual Variance Extract – process often to check accruals for accuracy +  - Payroll Accrual Variance Extract – process often to check accruals for accuracy 
-3. Zero School YTD Accruals – utility to zero accruals for both active and inactive or terminated employees +  - Zero School YTD Accruals – utility to zero accruals for both active and inactive or terminated employees 
-4. Special Adjustments – move accruals to another job code and/or fund code+  - Special Adjustments – move accruals to another job code and/or fund code
  
-Days Earned field on the Absence Deduction tab +Payroll > Maintenance > Hours/Pay Transmittals > Abs Ded 
-HR > Maintenance > Hours/Pay Transmittals > Abs Ded  +  
-The Days Earned field can be used to correct the number of days an employee should accrue for the specified pay date and overrides the number of days on the accrual calendar for the same pay date. +The **Days Earned** field can be used to correct the number of days an employee should accrue for the specified pay date and overrides the number of days on the accrual calendar for the same pay date. 
-To calculate the adjustment to days worked for an employee, add the days in the accrual calendar to which the employee is assigned beginning with the pay date the employee will receive his first pay check through the end of year.  Compare this number of days to the actual number of days the employee will work for the year.  The difference will then be added or subtracted, whichever is necessary, to the days in the accrual calendar for the pay date of his first pay check.   The resulting number of days will be entered on the Days Earned field for the pay date of his first pay check. +To calculate the adjustment to days worked for an employee, add the days in the accrual calendar to which the employee is assigned beginning with the pay date the employee will receive their first paycheck through the end of year.  Compare this number of days to the actual number of days the employee will work for the year.  The difference will then be added or subtracted, whichever is necessary, to the days in the accrual calendar for the pay date of his first paycheck.   The resulting number of days will be entered in the **Days Earned** field for the pay date of his first paycheck. 
-Use this field when an employee starts late in the school year or when you are reissuing a pay check to an accrued employee.  + 
 +Use this field when an employee starts late in the school year or when you are reissuing a paycheck to an accrued employee.   
 + 
 +Payroll > Utilities > Payroll Accrual Variance Extract
  
-Payroll Accrual Variance Extract 
 The Extract 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.  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. The Extract 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.  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.
 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 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. 
-Requirements for accurate calculations: + 
-1. The Accrual Rate on the Job Info screen must be correct. +**Requirements for accurate calculations**: 
-2. The Accrual Code on the Job info screen must match an accrual code in the Accrual Calendar. + 
-3. The Accrual Calendar must have Pay Dates that match the dates in the Pay Dates table. +  * The **Accrual Rate** on the Job Info tab must be correct. 
-4. The Accrual Calendar must also have the accurate number of Total Days Worked. +  * The **Accrual Code** on the Job info tab must match an accrual code in the Accrual Calendar. 
-5. Payoff Date on contract jobs (Pay Type 1 and 2) should be correct and should exist in the Pay Dates table. +  * The Accrual Calendar must have Pay Dates that match the dates in the pay dates table. 
-6. All future pay dates for the school year must exist on the Pay Date table. +  * The Accrual Calendar must also have the accurate number of **Total Days Worked**. 
-7. No future supplemental (non regular payroll) pay dates should exist on the Pay Dates table. +  * The **Payoff Date** on contract jobs (Pay Type 1 and 2) should be correct and should exist in the pay dates 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 Dates table must be completed for all school year pay dates. When performing calculations, the system uses the accrual calendar, the Pay Dates table, the pay distribution history, the master distribution records, and the Accrual Expense table.+  * All future pay dates for the school year must exist on the pay dates table. 
 +  * No future supplemental (non regular payroll) pay dates should exist on the pay dates 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 dates table must be completed for all school year pay dates. When performing calculations, the system uses the accrual calendar, the pay dates table, the pay distribution history, the master distribution records, and the Accrual Expense table. 
 Employees in payoff will usually appear on the accrual variance report, but you can disregard them.  Do not include them in this process when posting the process to payroll and finance. Employees in payoff will usually appear on the accrual variance report, but you can disregard them.  Do not include them in this process when posting the process to payroll and finance.
 +
 This extract process can be performed as often as necessary to review the status of employee accruals and to confirm employee accruals are correct.  At the very least, this extract should be processed before the September payroll and after the May payroll.  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.  This extract process can be performed as often as necessary to review the status of employee accruals and to confirm employee accruals are correct.  At the very least, this extract should be processed before the September payroll and after the May payroll.  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. 
-NOTE:  Resolve the following payroll calculation error message for all employees prior to running the accrual variance extract: “Warning: School YTD Job record exists with accrual amounts for job: XXXX which does not exist in the employee’s job master. This situation will cause a FAILURE message upon payoff.”    Use special adjustments or Zero SYTD Accruals utility to fix this issue for an accrued employee. 
-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. 
  
 +<WRAP Box>
 +**Note**:  Resolve the following payroll calculation error message for all employees prior to running the accrual variance extract: “Warning: School YTD Job record exists with accrual amounts for job: XXXX which does not exist in the employee’s job master. This situation will cause a FAILURE message upon payoff.”    Use special adjustments or Zero SYTD Accruals utility to fix this issue for an accrued employee.
 +</WRAP>
 +
 +<WRAP center round alert>
 +**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.
 +</WRAP>
  
-Payroll > Utilities > Payroll Accrual Variance Extract  
  
  
general/accrualoverview.1620317587.txt.gz · Last modified: 2021/05/06 11:13 (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.