Business

User Tools

Site Tools

Trace: • Mass Delete Credit Memos - FIN6200 • Out of Balance Correction • fourarrowbuttons • Accrual Overview • 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/06/14 15:15] – 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 114: Line 112:
 **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** check box was incorrectly selected/unselected causing the accruals to apply to the incorrect school year in Payroll. +  * The **TRS Year** checkbox was incorrectly selected/unselected causing the accruals to apply to the incorrect school year in Payroll. 
-  * The **Total Days Worked** in the Accrual Calendar for the month of August do 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. 
-  * The Accrual Rate does not match the current Daily Rate. +  * The **Accrual Rate** does not match the current **Daily Rate**. 
-  * The 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**. 
-  * The Contract Total was changed on the Job Info tab at some point during the year. +  * The **Contract Total** was changed on the Job Info tab at some point during the year. 
-  * The 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. 
-  * The Job Code was changed on 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 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. 
-  * The employee is assigned to an incorrect Accrual Calendar - Total Days Worked in the calendar do 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. 
   * The 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?**
Line 136: Line 136:
    
 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 their 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 > Utilities > Payroll Accrual Variance Extract
Line 147: Line 147:
 **Requirements for accurate calculations**: **Requirements for accurate calculations**:
  
-  * The Accrual Rate on the Job Info tab must be correct. +  * The **Accrual Rate** on the Job Info tab must be correct. 
-  * The Accrual Code on the Job info tab must match an accrual code in the Accrual Calendar. +  * The **Accrual Code** on the Job info tab must match an accrual code in the Accrual Calendar. 
-  * The Accrual Calendar must have Pay Dates that match the dates in the Pay Dates table. +  * The Accrual Calendar must have Pay Dates that match the dates in the pay dates table. 
-  * The Accrual Calendar must also have the accurate number of Total Days Worked. +  * The Accrual Calendar must also have the accurate number of **Total Days Worked**. 
-  * Payoff Date on contract jobs (Pay Type 1 and 2) should be correct and should exist in 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. 
-  * All future pay dates for the school year must exist on the Pay Date 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.+  * 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.+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.
general/accrualoverview.1623683713.txt.gz · Last modified: 2021/06/14 10:15 (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.