Business

User Tools

Site Tools

Trace: • Update accrual expense table • YTD Payroll Earnings Register Report Field Descriptions
general:ytdpayrollearningsregister_description

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:ytdpayrollearningsregister_description [2024/08/05 15:45] – emorenogeneral:ytdpayrollearningsregister_description [2024/08/09 16:39] (current) – emoreno
Line 1: Line 1:
-====== HRS3200 - YTD Payroll Earnings Register Explanation of Fields ======+====== YTD Payroll Earnings Register Report Field Descriptions ======
  
 <WRAP round intro>The Payroll Earnings Register report provides a listing of all employees receiving payment for the pay period. The report includes a breakdown of the payroll calculations including the standard gross, absence deductions, supplemental pay, deductions, benefits, and calculated net pay by the employee. <WRAP round intro>The Payroll Earnings Register report provides a listing of all employees receiving payment for the pay period. The report includes a breakdown of the payroll calculations including the standard gross, absence deductions, supplemental pay, deductions, benefits, and calculated net pay by the employee.
Line 40: Line 40:
 ^28. PR Sal Red|Displays the TRS employer contribution that is 8.25% of Performance Pay.| ^28. PR Sal Red|Displays the TRS employer contribution that is 8.25% of Performance Pay.|
 ^29. Ann Roth|Displays the Net Amount (employee contributions) that are coded Roth Annuities. The abbreviation code is R1 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]].| ^29. Ann Roth|Displays the Net Amount (employee contributions) that are coded Roth Annuities. The abbreviation code is R1 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]].|
-^30. Roth 457b|Displays the Net Amount (employee contributions) that are coded Roth 457b Annuities. The abbreviation code is R2 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]]|+^30. Roth 457b|Displays the Net Amount (employee contributions) that are coded Roth 457b Annuities. The abbreviation code is R2 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]].|
 ^31. N-Tax Bus|Displays the Non-Tax Businesses Allowance.  This is calculated if the employee has a business allowance tax amount (B type) on the [[payroll:maintenance:staffjobpaydata:payinfo ^31. N-Tax Bus|Displays the Non-Tax Businesses Allowance.  This is calculated if the employee has a business allowance tax amount (B type) on the [[payroll:maintenance:staffjobpaydata:payinfo
 |Payroll > Maintenance > Staff Job/Pay Data > Pay Info]] tab or a Non-TRS entry with a payment type 2 and a taxable amount on the [[payroll:maintenance:hourspaytransmittals:nontrs|Payroll > Maintenance > Hours/Pay Transmittals > Non TRS]] tab. Available only if the employee has a business allowance nontax amount on the Pay Info tab (T type) or a Non-TRS entry on the Payroll > Maintenance > Hours/Pay Transmittals screen with a payment type 2 and a Non-Taxable amount.| |Payroll > Maintenance > Staff Job/Pay Data > Pay Info]] tab or a Non-TRS entry with a payment type 2 and a taxable amount on the [[payroll:maintenance:hourspaytransmittals:nontrs|Payroll > Maintenance > Hours/Pay Transmittals > Non TRS]] tab. Available only if the employee has a business allowance nontax amount on the Pay Info tab (T type) or a Non-TRS entry on the Payroll > Maintenance > Hours/Pay Transmittals screen with a payment type 2 and a Non-Taxable amount.|
-^32. EIC Amt|Earned Income Credit Amount. Obsolete for years greater than 2019: The EIC is a tax credit for certain workers who have a qualifying child who lives with them in the United States. The tax credit is based upon a percentage of their earned income.| +^32. EIC Amt|Displays the Earned Income Credit Amount. Per IRS requirements, EIC is obsolete for calendar years greater than 2019. The EIC is a tax credit for certain workers who have a qualifying child who lives with them in the United States. The tax credit is based upon a percentage of their earned income.| 
-^33. TRS Grs|Gross Pay that is TRS Eligible.| +^33. TRS Grs|Displays Gross Pay that is TRS eligible.| 
-^34. TRS Fd Grs|Gross Pay that is paid out of Federal Funds| +^34. TRS Fd Grs|Displays Gross Pay that is paid from federal funds.| 
-^35. NP Tax Bus|Non-TRS nonpaid business allowance taxable amount. Non-TRS entry on the Payroll > Maintenance > Hours/Pay Transmittals screen with a payment code N, payment type 2, and a Taxable Amt.| +^35. NP Tax Bus|Displays the Non-TRS nonpaid business allowance taxable amount. This is calculated if the employee has a  Non-TRS entry with a payment code N, payment type 2, and a taxable amount on the [[payroll:maintenance:hourspaytransmittals:nontrs|Payroll > Maintenance > Hours/Pay Transmittals > Non TRS]] tab.| 
-^36. PR Ins|TRS employee contribution that is .65% of Performance Pay.| +^36. PR Ins|Displays the TRS employee contribution that is .65% of Performance Pay.| 
-^37. Empr DC Tax|Employer Dependent Care Taxable amount. Once the total dependent care (employee and employer) exceeds $5,000, the employer contribution amount will be displayed.| +^37. Empr DC Tax|Displays the Employer Dependent Care Taxable amount. Once the total dependent care (employee and employer) exceeds $5,000, the employer contribution amount is displayed.| 
-^38. Empr TRS Ins|TRS employer contribution that is .65% of TRS Gross| +^38. Empr TRS Ins|Displays the TRS employer contribution that is .65% of TRS Gross| 
-^39. Abs Ded|The amount to be deducted from an employee’s gross pay that reflects leave taken in excess of leave balance.| +^39. Abs Ded|Displays the amount to be deducted from an employee’s gross pay that reflects leave taken in excess of leave balance.| 
-^40. Café 125|Net Amount (employee contributions) of deductions marked as Café 125 (pre-tax) under Deductions tab.| +^40. Café 125|Displays the Net Amount (employee contributions) of deductions marked as Café 125 (pre-tax) on the [[payroll:maintenance:staffjobpaydata:deductions|Payroll > Maintenance > Staff Job/Pay Data > Deductions]] tab.| 
-^41. TRS Dep|TRS Deposit which is 8.25% + .65% of TRS Gross| +^41. TRS Dep|Displays the TRS Deposit which is 8.25% + .65% of TRS Gross| 
-^42. TRS Fd DP|TRS Grant Deposit calculated by multiplying TRS Federal Gross x 8.25%.| +^42. TRS Fd DP|Displays the TRS Grant Deposit calculated by multiplying TRS Federal Gross x 8.25%.| 
-^43. NP NT Bus|Non-TRS nonpaid business allowance non-taxable amount. Non-TRS entry on the Payroll > Maintenance > Hours/Pay Transmittals screen with a payment code N, payment type 2, and a Non-Taxable Amt.| +^43. NP NT Bus|Displays the Non-TRS nonpaid business allowance non-taxable amount. This is calculated if the employee has a Non-TRS entry with a payment code N, payment type 2, and a non-taxable amount on the [[payroll:maintenance:hourspaytransmittals:nontrs|Payroll > Maintenance > Hours/Pay Transmittals > Non TRS]] tab.| 
-^44. Ret Pen Gr|Retiree Pension Gross amount.| +^44. Ret Pen Gr|Dipslays the Retiree Pension Gross amount.| 
-^45. HSA Emp|Net Amount (employee contributions) that are coded Health Savings Account. Abbrev Code under Payroll > Tables > Tax/Deductions > Deduction Cd would be HS.| +^45. HSA Emp|Displays the Net Amount (employee contributions) that are coded Roth 457b Annuities. The abbreviation code is HSon the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]] tab.| 
-^46. Abs Ref|Absence refund amounts applied to an employee’s gross pay.| +^46. Abs Ref|Displays the Absence Refund amounts applied to an employee’s gross pay.| 
-^47. Annuity|Net Amount (employee contributions) of annuity deductions.| +^47. Annuity|Displays the Net Amount (employee contributions) of annuity deductions.| 
-^48. TRS Ins|TRS employee contribution that is .65% of TRS Gross| +^48. TRS Ins|Displays the TRS employee contribution that is .65% of TRS Gross.| 
-^49. TRS Fd Cr|TRS Grant Care calculated by multiplying TRS Federal Gross x 1.25%| +^49. TRS Fd Cr|Displays the TRS Grant Care calculated by multiplying TRS Federal Gross x 1.25%.| 
-^50. N-TRS Excs|Non-TRS reimbursement in excess of the base amount.| +^50. N-TRS Excs|Displays the Non-TRS reimbursement in excess of the base amount.| 
-^51. Ret Pen Sur|TRS Retiree Pension Surcharge. Calculated by multiplying the Pension Surcharge rate (TRS Rate + District Rate) by the Ret Emplr Pension Gross.| +^51. Ret Pen Sur|Displays the TRS Retiree Pension Surcharge. This is calculated by multiplying the Pension Surcharge rate (TRS Rate + District Rate) by the Ret Emplr Pension Gross.| 
-^52. HSA Emplr|Employer contributions that are coded Health Savings Account. Abbrev Code under Payroll > Tables > Tax/Deductions > Deduction Cd would be HS.| +^52. HSA Emplr|Displays employer contributions that are coded Health Savings Account. The abbreviation code is HS on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]] tab.| 
-^53. Units Wrkd|Number of units worked for the employee. Matches the amount entered for Regular Hours on the REG HOURS tab.| +^53. Units Wrkd|Displays the number of units worked by the employee. This should match the amount entered for regular hours on the [[payroll:maintenance:hourspaytransmittals:reghours|Payroll > Maintenance > Hours/Pay Transmittals > Reg Hours]] tab.| 
-^54. Dep Care|Net Amount (employee contributions) that are coded Dependent Child Care. Abbrev Code under Payroll > Tables > Tax/Deductions > Deduction Cd would be DC.| +^54. Dep Care|Displays the Net Amount (employee contributions) that are coded Dependent Child Care. The abbreviation code is DC on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]] tab.| 
-^55. TRS Sal Red|TRS employee contribution that is 8.25% of TRS Gross| +^55. TRS Sal Red|Displays the TRS employee contribution that is 8.25% of TRS Gross.| 
-^56. Unemp Grs|Employee’s Unemployment Gross amount.| +^56. Unemp Grs|Displays the employee’s Unemployment Gross amount.| 
-^57. N-TRS Base|Non-TRS reimbursable base amount. Non-TRS entry on the Payroll > Maintenance > Hours/Pay Transmittals screen with payment type 1 and a Non-Taxable Amt.| +^57. N-TRS Base|Displays the Non-TRS reimbursable base amount. This is calculated if the employee has a Non-TRS entry with payment type 1 and a non-taxable amount on the [[payroll:maintenance:hourspaytransmittals:nontrs|Payroll > Maintenance > Hours/Pay Transmittals > Non TRS]] tab.| 
-^58. Emplr Care|Employer .75% contribution of TRS Gross.| +^58. Emplr Care|Displays the employer's .75% contribution of TRS Gross.| 
-^59. Emplr FICA|Employers 6.2% contribution of FICA Grs.| +^59. Emplr FICA|Displays the employer's 6.2% contribution of FICA Grs.| 
-^60. Hrly Rate|Employee’s Hourly Pay Rate.| +^60. Hrly Rate|Displays the employee’s Hourly Pay Rate.| 
-^61. Emplr Cont|Employer Contribution is the amount of the contribution, per pay period, by the district to the employee. Designated by the Emplr Contrib field located on the Deduction tab for the employee. Payroll > Maintenance > Staff Job/Pay Data > Deductions.| +^61. Emplr Cont|Displays the Employer Contribution, which is the amount of the contribution, per pay period, by the LEA to the employee. This is designated by the **Emplr Contrib** field on the [[payroll:maintenance:staffjobpaydata:deductions|Payroll > Maintenance > Staff Job/Pay Data > Deductions]] tab.| 
-^62. W/C Tx|Worker’s Compensation Tax based on the rate assigned by the district's insurance carrier for each code. For detailed examples, visit the Calculating Workers' Compensation page on ASCENDER help.| +^62. W/C Tx|Displays the Worker’s Compensation Tax based on the rate assigned by the LEA's insurance carrier for each code. Review the [[general:calculatingworkerscomp|Calculating Workers' Compensation]] for examples.| 
-^63. Unemp Tax|Taxable rate of employees unemployment gross if the LEA is set up as taxable under Payroll > Tables > Tax/Deductions > Unemployment.|+^63. Unemp Tax|Displays the taxable rate of the employee's unemployment gross if the LEA is set up as taxable employer on the [[payroll:tables:taxdeductions:unemployment|Payroll > Tables > Tax/Deductions > Unemployment]] tab.|
 ^64. TRS Suppl|Obsolete?| ^64. TRS Suppl|Obsolete?|
-^65. Care Surch|Employer paid TRS Care Surcharge (RI deduction code). Calculated if “Take Retiree Surcharge” is selected on Personnel > Maintenance > Employment Info.| +^65. Care Surch|Displays the employer paid TRS Care Surcharge (RI deduction code). This is calculated if **Take Retiree Surcharge** is selected on the [[personnel:maintenance:employmentinfo|Personnel > Maintenance > Employment Info]] page.| 
-^66. Emplr Misc|Employer contribution that is coded Miscellaneous. Abbrev code under Payroll > Tables > Tax/Deductions > Deduction Cd would be M1, M2, and/or M3.| +^66. Emplr Misc|Displays the employer contribution that is coded Miscellaneous. The abbreviation code is  M1, M2, and/or M3 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]] tab.| 
-^67. Tot Gross|Stand Grs + Suppl Pay + Tax Bus| +^67. Tot Gross|Stand Grs + Suppl Pay + Tax Bus = Total Gross| 
-^68. Other Ded|Net Amount (employee contributions) not to include additional withholding.| +^68. Other Ded|Displays the Net Amount (employee contributions) not to include additional withholding.| 
-^69. Emp 457|Net Amount (employee contributions) that are coded 457 deferred comp. Abbrev Code under Payroll > Tables > Tax/Deductions > Deduction Cd would be D1 or D2.| +^69. Emp 457|Displays the Net Amount (employee contributions) that are coded 457 deferred comp. The abbreviation code is  D1 or D2 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]] tab.| 
-^70. Ovtm Grs|Total Gross Pay that is equal to Ovtm Hrs x Ovtm Rate.| +^70. Ovtm Grs|Displays the Total Gross Pay that is equal to Ovtm Hrs x Ovtm Rate.| 
-^71. TEA Hlth Ins|TEA Health Insurance amount| +^71. TEA Hlth Ins|Displays the TEA Health Insurance amount.| 
-^72. New TRS Gr|New Member TRS Eligible Gross Pay| +^72. New TRS Gr|Displays the New Member TRS Eligible Gross Pay.| 
-^73. Emplr Med Tx|Employer’s Medicare tax is calculated as 1.45% of the Medicare Gross amount.| +^73. Emplr Med Tx|Displays the Employer’s Medicare tax that is calculated as 1.45% of the Medicare Gross amount.| 
-^74. Net Pay|Net pay is the amount of money employees take home after all deductions are subtracted. The below examples represent how net pay is calculated on the Earnings Register.\\  \\  Employee with a business allowance: Standard Gross + Suppl Pay + Taxable Bus Allowance - W/H tax - Med tax - Annuity - TRS Insurance - TRS Sal Red - Cafe 125 = Net Pay\\  \\  Employee without a business allowance: Standard Gross + Suppl Pay - W/H tax - Med tax - Annuity - TRS Insurance - TRS Sal Red - Deductions Employee paid NOT Cafe 125 = Net Pay| +^74. Net Pay|Displays the net pay, which is the amount of money employees take home after all deductions are subtracted. The below examples represent how net pay is calculated on the Earnings Register.\\  \\  Employee with a business allowance: Standard Gross + Suppl Pay + Taxable Bus Allowance - W/H tax - Med tax - Annuity - TRS Insurance - TRS Sal Red - Cafe 125 = Net Pay\\  \\  Employee without a business allowance: Standard Gross + Suppl Pay - W/H tax - Med tax - Annuity - TRS Insurance - TRS Sal Red - Deductions Employee paid NOT Cafe 125 = Net Pay| 
-^75. Net Adjust|Amount subtracted from Standard Gross, Suppl Pay, & Taxable Bus Allowance to calculate Net Pay. Equal to W/H tax + Med tax + Annuity + TRS Insurance + TRS Sal Red + Cafe 125.| +^75. Net Adjust|Displays the amount subtracted from Standard Gross, Suppl Pay, & Taxable Bus Allowance to calculate Net Pay. Equal to W/H tax + Med tax + Annuity + TRS Insurance + TRS Sal Red + Cafe 125.| 
-^76. Emplr 457|Employer contributions that are coded 457 deferred comp. Abbrev Code under Payroll > Tables > Tax/Deductions > Deduction Cd would be D1 or D2.| +^76. Emplr 457|Displays the Employer contributions that are coded 457 deferred comp. The abbreviation code is D1 or D2 on the [[payroll:tables:taxdeductions:deductioncd|Payroll > Tables > Tax/Deductions > Deduction Cd]].| 
-^77. Ovtm Units|Number of overtime units worked for the employee. Matches the amount entered for Overtime on the OVTM HOURS tab.| +^77. Ovtm Units|Displays the number of overtime units worked by the employee. This should match the amount entered for overtime on the [[payroll:maintenance:hourspaytransmittals:ovtmhours|Payroll > Maintenance > Hours/Pay Transmittals > Ovtm Hours]] tab.| 
-^78. TRS ASB|TRS ASB (Above State Base) which is the Statutory Minimum Contribution. Typically (Pay Rate – Adj Stat Min) x 8.25%| +^78. TRS ASB|Displays the TRS ASB (Above State Base), which is the Statutory Minimum Contribution. Typically (Pay Rate – Adj Stat Min) x 8.25%| 
-^79. New TRS Co|Employer New Member Surcharge that is calculated on the employees first 90 days of TRS membership. 8.25% of TRS Eligible Gross Pay.| +^79. New TRS Co|Displays the Employer New Member Surcharge (8.25% of TRS Eligible Gross Pay) that is calculated on the employees first 90 days of TRS membership.| 
-^80. CYTD Med Grs|Employee’s calendar year to date (as of January) Medicare gross amount.|+^80. CYTD Med Grs|Displays the employee’s Calendar Year To Date (as of January) Medicare Gross amount.|
general/ytdpayrollearningsregister_description.1722872705.txt.gz · Last modified: 2024/08/05 15:45 by emoreno

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.