User Tools

Site Tools


general:augustaccruals_verify_accrual_amounts_are_cleared

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:augustaccruals_verify_accrual_amounts_are_cleared [2023/05/04 18:42] emorenogeneral:augustaccruals_verify_accrual_amounts_are_cleared [2025/06/05 15:53] (current) emoreno
Line 1: Line 1:
 ======(For LEAs that accrue monthly) Balance accruals in Finance and Payroll====== ======(For LEAs that accrue monthly) Balance accruals in Finance and Payroll======
 <div keep> <div keep>
-If your LEA accrues monthly, complete the following steps to verify the accurate posting of monthly accruals in both  Finance and Payroll. It is critical that both areas agree to ensure accurate reporting on federal funds.+If your LEA accrues monthly, complete the following steps to verify the accurate posting of monthly accruals in both  Finance and Payroll. It is critical that both areas agree to ensure accurate reporting of federal funds.
  
-**It is recommended** that you balance accruals during the end-of-month Finance process to quickly identify and rectify errors.+**It is recommended** to balance accruals monthly to help identify and correct any errors. Use the [[payroll:utilities:payrollaccrualvarianceextract:extract|Payroll > Utilities > Payroll Accrual Variance Extract > Extract]] to assist you in this process.
  
 [[finance:tables:districtfinanceoptions:clearingfundmaintenance|Finance > Tables > District Finance Options > Clearing Fund Maintenance]] [[finance:tables:districtfinanceoptions:clearingfundmaintenance|Finance > Tables > District Finance Options > Clearing Fund Maintenance]]
Line 9: Line 9:
 {{:general:eoypayverify_clearingfundmaint.jpg|Clearing Fund Maintenance Tab}} {{:general:eoypayverify_clearingfundmaint.jpg|Clearing Fund Maintenance Tab}}
  
-<WRAP box>**Note**: Object codes at your LEA may differ as this is a sample screenshot.+<WRAP box>**Note**: Object codes at your LEA may differ as this is a sample screenshot.
 </WRAP> </WRAP>
  
Line 33: Line 33:
  
 Generate the report with the following parameters: Generate the report with the following parameters:
 +
 +{{:general:hrs3050_sytd_report_parameters.jpg|School Year To Date Report Parameters}}
  
 Print or save only the last page of the report. Print or save only the last page of the report.
  
-{{:general:hrs3050_sytd_report_parameters.jpg|School Year To Date Report Parameters}} 
  
 {{:general:eoypayverify_sytdreport.jpg|School Year To Date Report}} {{:general:eoypayverify_sytdreport.jpg|School Year To Date Report}}
Line 49: Line 50:
 |**General Ledger Inquiry Report**|**School YTD Report**|**Expenditure Object Code**| |**General Ledger Inquiry Report**|**School YTD Report**|**Expenditure Object Code**|
 |216X|Accrued Pay|6119 or 6129| |216X|Accrued Pay|6119 or 6129|
-|2211.11|Accrued Federal Deposit|6146| +|221X.11|Accrued Federal Deposit|6146| 
-|2211.12|Accrued Federal Care|6146| +|221X.12|Accrued Federal Care|6146| 
-|2211.14|FICA/Medicare Accrued|6141| +|221X.14|FICA/Medicare Accrued|6141| 
-|2211.15|Unemployment Accrued|6145| +|221X.15|Unemployment Accrued|6145| 
-|2211.16|Emplr Health Insurance Accrued + TEA Health Ins Accrued|6142| +|221X.16|Emplr Health Insurance Accrued + TEA Health Ins Accrued|6142| 
-|2211.17|Emplr 457 Accrued|6149| +|221X.17|Emplr 457 Accrued|6149| 
-|2211.18|Emplr Annuity Accrued|6149| +|221X.18|Emplr Annuity Accrued|6149| 
-|2211.19|Emplr TRS Care Accrued|6146| +|221X.19|Emplr TRS Care Accrued|6146| 
-|2211.20|Emplr Dependent Care Accrued|6149| +|221X.20|Emplr Dependent Care Accrued|6149| 
-|2211.21|Emplr Misc Ded Contrib Accrued|6149|+|221X.21|Emplr Misc Ded Contrib Accrued|6149|
  
 Assuming that only your 10-month employees accrue, the easiest time to complete accrual balancing is after completing the August payroll but before completing the August accruals. At this time, the amounts displayed on the School Year to Date Report and the General Ledger Inquiry liability accounts (216X and 221X.XX) are typically all zeros. Employees who accrue monthly and receive the first payment of their new contract prior to September will have accruals in Finance and the upcoming School Year to Date Report if the **TRS Year** field is selected on the Job info tab. These amounts should be considered during the accrual balancing process. Here are five common scenarios to consider. Assuming that only your 10-month employees accrue, the easiest time to complete accrual balancing is after completing the August payroll but before completing the August accruals. At this time, the amounts displayed on the School Year to Date Report and the General Ledger Inquiry liability accounts (216X and 221X.XX) are typically all zeros. Employees who accrue monthly and receive the first payment of their new contract prior to September will have accruals in Finance and the upcoming School Year to Date Report if the **TRS Year** field is selected on the Job info tab. These amounts should be considered during the accrual balancing process. Here are five common scenarios to consider.
Line 71: Line 72:
 </div> </div>
      
-The below are sample scenarios that have been collected: +Review the following scenarios, choose the best fit, then follow the appropriate steps.
- +
-VCV Identify the scenario that best matches your situation. +
- +
-VCV Locate the scenario details below. +
- +
-VCV Complete the outlined steps for the scenario.+
  
 <WRAP box> <WRAP box>
Line 103: Line 98:
 {{:general:eoypayverify_zeroytdextractreport.jpg|Zero School YTD Extract Report}} {{:general:eoypayverify_zeroytdextractreport.jpg|Zero School YTD Extract Report}}
  
-If the process is successful, close the Extract report.+  * If the process is successful, close the Extract report.  
 +  * If there were any errors encountered during the extract, the system displays the Zero School YTD Accruals Calculation Errors listing. [[general:printreport|Review the report.]] 
 +  * **It is recommended** that you clear all errors prior to continuing with the extract process.
  
 [[payroll:utilities:zeroschoolytdaccruals:reports|Payroll > Utilities > Zero School YTD Accruals > Reports]]  [[payroll:utilities:zeroschoolytdaccruals:reports|Payroll > Utilities > Zero School YTD Accruals > Reports]] 
Line 127: Line 124:
   * If these amounts match Finance, no action needed.   * If these amounts match Finance, no action needed.
   * If these amounts do not match in Finance, enter a JV on the Finance > Postings > Journal Actual tab to match the School Year to Date amounts.   * If these amounts do not match in Finance, enter a JV on the Finance > Postings > Journal Actual tab to match the School Year to Date amounts.
- +\\   
-Refer to the above chart to see the expenditure object that ties to each liability. For example, if the accrued FICA/Medicare liability line (object 221X.14) shows a balance of - +Refer to the above chart to see the expenditure object that ties to each liability. For example, if the accrued FICA/Medicare liability line (object 221X.14) shows a balance of -$158.56, you will need to debit a payroll expenditure account with an object code of 6141 for $158.56.
-$158.56, you will need to debit a payroll expenditure account with an object code of 6141.+
 </WRAP> </WRAP>
  
Line 138: Line 134:
  
 Complete the same steps listed in Scenario 2 **EXCEPT** on the Post to Master/Interface to Finance tab: Complete the same steps listed in Scenario 2 **EXCEPT** on the Post to Master/Interface to Finance tab:
 +
 +{{:general:eoypayverify_scenario4.jpg|Scenario 4}}
  
 VCV Select **Post to Master and Interface to Finance**. VCV Select **Post to Master and Interface to Finance**.
Line 159: Line 157:
   * If yes, select **Post to Master and Interface to Finance**.   * If yes, select **Post to Master and Interface to Finance**.
   * If no and the differences will be greater, select **Post to Master**. You may need to manually enter additional JVs on the [[finance:maintenance:postings:journalactual|Finance > Maintenance > Postings > Journal Actual]] tab to reconcile any remaining differences.   * If no and the differences will be greater, select **Post to Master**. You may need to manually enter additional JVs on the [[finance:maintenance:postings:journalactual|Finance > Maintenance > Postings > Journal Actual]] tab to reconcile any remaining differences.
 +\\
 Complete the same steps listed in Scenario 2 and 4 except on the Post to Master/Interface to Finance tab: Complete the same steps listed in Scenario 2 and 4 except on the Post to Master/Interface to Finance tab:
  
general/augustaccruals_verify_accrual_amounts_are_cleared.1683225752.txt.gz · Last modified: 2023/05/04 18:42 by emoreno