Example: YTD Pay Balances for Custom Reporting
You have workers who contribute post-tax payments into their retirement plan after reaching their pretax limit. You want to display their year-to-date retirement contribution balances on pay results.
- Create pretax and post-tax retirement deductions. See Steps: Create Deductions.
- Create a pay accumulation calledRetirement Pre and Post Taxand add the pretax and post-tax retirement deductions to it. Creating an accumulation for your retirement deductions enables Workday to report on retirement calculations specifically and to automatically combine pretax and post-tax amounts into a single year-to-date amount. You can map individual deductions, but the report will display each value as a separate line.Retirement Pre and Post Tax. See Create Pay Accumulations.
- Create a custom report for YTD Payroll Results. See Concept: Custom Reports.
- Security:Set Up: Payroll (Calculations - Payroll Specific)domain in the Core Payroll functional area.
- Access theMaintain Pay Results - Class Report Field Mappingtask.
- Select thePay Component Balance Resultstab.
- As you complete the task, consider:
Option Description Pay Components to IncludeSelectBy Calculation Type > Pay Accumulation (ALL) > Retirement Pre and Post Tax.Balance PeriodSelectYTD - Current Calendar Year (based on Payment Date).LabelEnter a descriptive label, such asYTD Pre/Post Tax Retirement. - Open your custom report YTD Payroll Results and add this field with these settings:
Option Description Business ObjectSelectPayroll Result.FieldSelectPayroll > YTD Pre/Post Tax Retirement.OptionsSelectDo Not Show if Empty.
Workday displays the accumulated pretax and post-tax retirement deductions as a single value in the year-to-date balance on your custom YTD payroll results report.