Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Concept: Data Entry in Payroll Input EIB Spreadsheets

Concept: Data Entry in Payroll Input EIB Spreadsheets

To add multiple payroll inputs, you can create an EIB based on the
Import Payroll Input
 web service. You can then enter data in a spreadsheet that corresponds to the inbound EIB.
These examples illustrate how to complete the EIB spreadsheet for the
Import Payroll Input
 web service.
Workday recommends that you use the
Import Payroll Input
 web service, because it's optimized for bulk import. This example also applies to EIBs based on the
Submit Payroll Input
 web service.
When you create an EIB spreadsheet, if you leave the
Run Category ID
 field blank, the EIB defaults to include all run categories.
Example: Add New Pay Input
You want to upload a new payroll input for a transportation allowance earning of 50.
Add this row to the EIB spreadsheet:
Spreadsheet Key
Row ID
Payroll Input ID
Earning
Amount
1
1
8000
Transportation allowance
50
If you leave the
Payroll Input ID
 blank, Workday generates a new reference ID when you import the spreadsheet. This new reference ID can cause duplicate input records if you run the same EIB spreadsheet multiple times.
Example: Modify Existing Pay Input
Global Modern Services terminated an employee on March 15, 2017. You want to end an existing ongoing pay input for transportation allowances for the terminated worker. The payroll input ID of the existing payroll input is 8000.
You can only modify a pay input end date after it was used in a payroll calculation.
Modify these columns in the EIB spreadsheet for the terminated worker:
Payroll Input ID
Earning
End Date
8000
Transportation allowance
2017-03-15
Ensure that the
Payroll Input ID
 refers to the existing payroll input. When you enter a new payroll input id or leave the
Payroll Input ID
 column empty, Workday creates a new payroll input.
Example: Include Related Calculations on Payroll Inputs
You have an earning for hourly pay with related calculations for worked hours and hourly rate. You want to add payroll input for:
  • Total pay: 1600.
  • Worked hours: 160.
  • Hourly rate: 10.
Add these rows to the EIB spreadsheet:
Spreadsheet Key
Row ID
Earning
Amount
Additional Input Details - Row ID
Related Calculation
Input Value
1
1
Hourly Pay
1600
1
Hours
40
1
1
2
Hourly rate
10
Example: Include Custom Worktags
You have custom worktags for loan numbers, and want to include loan numbers on the payroll input or off-cycle payment for a loan repayment deduction.
  1. Access the
    Custom Worktag Values
     report.
  2. Select
    Integration IDs
    View IDs
     from the related actions menu of the loan number worktag. View the reference ID type and ID. Example:
    Type
    ID
    Custom_Worktag_5_ID
    01
  3. Enter these values in the spreadsheet:
    Deduction
    Custom Worktag 05
    Loan repayment
    01