Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-07-26
Create a Payroll Register Spreadsheet

Create a Payroll Register Spreadsheet

  • Set up pay components and pay component groups.
  • Set up a payroll register for your payroll country.
This topic provides instructions for creating a payroll register spreadsheet for these payroll countries:
  • Australia
  • Canada
  • Ireland
  • United Kingdom
  • United States
You can configure a payroll register spreadsheet to provide more data formatting options when reconciling payroll results. The payroll register spreadsheet displays worker totals for predefined columns. Example:
  • Base salary
  • Bonus
  • Advance payments
You can configure which pay components display in each column.
Regardless of configuration, Workday displays a worker's:
  • Annual salary, based on the
    Total Base Pay Annualized - Amount
     report field.
  • Hourly rate, based on the
    Hourly Rate - Amount
     report field.
  • Payment method.
  • Hire and termination dates.
  1. Access the
    Edit Earning
     or
    Edit Deduction
     task.
    Security:
    Set Up: Payroll (Calculations - Payroll Specific)
     domain in the Core Payroll functional area.
  2. On the
    Non-Effective Dated
     tab, select a Payroll Register Excel Group pay component group from the
    Groups
     prompt.
    Example: Select
    Payroll Register Excel Group Advance Payment
     to include the value of the pay component in the Advance Payment column on the payroll register spreadsheet.
    These pay component groups and corresponding columns only apply to the payroll register configurations for Payroll for the UK:
    • Payroll Register Excel Group Child Care Vouchers
    • Payroll Register Excel Group Pennies from Heaven
    For Payroll for the UK, Workday automatically reports the sum of pay components in the
    GBR Court Order (All): Deductions [GBR]
     pay component group in the Court Order column of the payroll register spreadsheet.
  3. Access the
    Payroll Register
     task.
    Select
    Excel
     from the
    Generate as
     prompt.
    For best performance, Workday recommends running payroll register reports for pay groups of 25,000 or fewer employees.
    Depending on your payroll country, the
    Payroll Register
     task is secured to these domains:
    • Reports: Pay Calculation Results for Pay Group (Results) - AUS
       domain in the AUS Payroll functional area.
    • Reports: Pay Calculation Results for Pay Group (Results) - CAN
       domain in the CAN Payroll functional area.
    • Reports: Pay Calculation Results for Pay Group (Results) - IRL
       domain in the IRL Payroll functional area.
    • Reports: Pay Calculation Results for Pay Group (Results) - UK
       domain in the UK Payroll functional area.
    • Reports: Pay Calculation Results for Pay Group (Results) - USA
       domain in the USA Payroll functional area.
    • Worker Data: Payroll (Payroll Input)
       domain in the Core Payroll functional area.
Workday generates the payroll register spreadsheet and sends it to
My Tasks
.