Calculation rules: Jan 1, 2026

Workday's Deduction Register, column by column

Workday's Pay Calculation Results – Deduction Register lists every deduction taken in a pay run, one row per worker per deduction, across 12 columns. Here is every column, what it held on a US weekly run, and what YourPayBot does with it.

Written from a US weekly run with invented workers. Your tenant's deductions and groups will differ. Workday is a trademark of Workday, Inc. YourPayBot isn't affiliated with Workday.

How the file is laid out

No prompt block. Row 1 is the header row and the data starts on row 2.
One row per worker per deduction. The employee and employer sides of a benefit are separate deductions with their own codes, like 440 Dental EE and 441 Dental ER, so most workers have two rows per benefit.
The last row totals the three amount columns and has nothing else in it, not even a label.
Excel caps sheet names at 31 characters, so the tab reads Pay Calculation Results - Dedu.

Every column

Payroll Result

What it holds: The pay result the line belongs to: worker, ID, pay date, run category and status in one cell.
Example: Harriet Vale (100231): 09/19/2026 (Regular) - Complete

Worker

What it holds: Name with the ID in brackets.
Example: Harriet Vale (100231)

Employee ID

What it holds: The ID alone. Keep it as text: IDs can start with 0.
Example: 004417

Company

What it holds: The legal company.
Example: Example Holdings, LLC

Organizations

What it holds: Several organizations stacked in one cell, one per line with a blank line between.
Example: Cost Center: Department 07 / Location: Site 02

Period

What it holds: The pay period, then the period schedule in brackets.
Example: 09/13/2026 - 09/19/2026 (Weekly (Sun-Sat))

Deduction

What it holds: Code and name together.
Example: 440 - Dental EE

Deduction Code

What it holds: The code alone.
Example: 440

Pay Component Groups

What it holds: Every group the deduction belongs to, stacked one per line. See below.
Example: Employer Paid Benefits / Withholding

Current Period Result

What it holds: The amount taken this period. 0 when nothing was taken.
Example: 4.10

Current Period Arrears

What it holds: What couldn't be taken this period and went to arrears.
Example: 18.75

Outstanding Arrears Balance

What it holds: The arrears still owed after this period.
Example: 75.00

Column	What it holds	Example
Payroll Result	The pay result the line belongs to: worker, ID, pay date, run category and status in one cell.	Harriet Vale (100231): 09/19/2026 (Regular) - Complete
Worker	Name with the ID in brackets.	Harriet Vale (100231)
Employee ID	The ID alone. Keep it as text: IDs can start with 0.	004417
Company	The legal company.	Example Holdings, LLC
Organizations	Several organizations stacked in one cell, one per line with a blank line between.	Cost Center: Department 07 / Location: Site 02
Period	The pay period, then the period schedule in brackets.	09/13/2026 - 09/19/2026 (Weekly (Sun-Sat))
Deduction	Code and name together.	440 - Dental EE
Deduction Code	The code alone.	440
Pay Component Groups	Every group the deduction belongs to, stacked one per line. See below.	Employer Paid Benefits / Withholding
Current Period Result	The amount taken this period. 0 when nothing was taken.	4.10
Current Period Arrears	What couldn't be taken this period and went to arrears.	18.75
Outstanding Arrears Balance	The arrears still owed after this period.	75.00

In Organizations and Pay Component Groups, the slashes above stand for line breaks inside the cell. Filter or pivot on either column and each combination of lines is its own value.

What Pay Component Groups tell you

The groups say how a deduction is treated, not what it is. An employee pre-tax deduction lists every tax it lowers the wages for. An employer-paid one lists Employer Paid Benefits. In the run behind this page:

Employee pre-tax (Dental EE)

Pay Component Groups: Federal Taxable Reduction, FICA Taxable Reduction, FUI Taxable Reduction, Local Withholding Taxable Reduction, Local Withholding Taxable Reduction Employer, Pre Tax Deductions, Section 125 Cafeteria Plan, State Withholding Taxable Reduction, SUI Taxable Reduction, Withholding, Withholding Order (All): Medical Insurance

Employer paid (Dental ER)

Pay Component Groups: Employer Paid Benefits, Withholding

Deduction	Pay Component Groups
Employee pre-tax (Dental EE)	Federal Taxable Reduction, FICA Taxable Reduction, FUI Taxable Reduction, Local Withholding Taxable Reduction, Local Withholding Taxable Reduction Employer, Pre Tax Deductions, Section 125 Cafeteria Plan, State Withholding Taxable Reduction, SUI Taxable Reduction, Withholding, Withholding Order (All): Medical Insurance
Employer paid (Dental ER)	Employer Paid Benefits, Withholding

So Employer Paid Benefits is how to tell employer lines from employee lines without relying on EE or ER in the name, and Section 125 Cafeteria Plan or Pre Tax Deductions marks the pre-tax ones.

What it leaves out

Taxable wages

What that means: No column holds the wages each line was worked out on, so no rate can be tested against it.

Taxes

What that means: The run this page is written from held benefit deductions only, dental for the employee and the employer. No tax lines.

Gross and net

What that means: Nothing to tie the deductions to a paycheck. That's the Payroll Register.

A pay date column

What that means: The date is only inside Payroll Result.

Missing	What that means
Taxable wages	No column holds the wages each line was worked out on, so no rate can be tested against it.
Taxes	The run this page is written from held benefit deductions only, dental for the employee and the employer. No tax lines.
Gross and net	Nothing to tie the deductions to a paycheck. That's the Payroll Register.
A pay date column	The date is only inside Payroll Result.

Pair it with the Payroll Register for gross and net.

How YourPayBot reads it

Drop the file as it comes on 2 · Register & deductions. It's recognized as a deduction export from its headers, with nothing to map.

Row 1 names all 12 columns, so it's the header. With no prompt block there's no report info.
Only the Cost Center line of Organizations is used, without its label. Location is ignored.
The pay date is read out of Payroll Result and names the workbook.
Each line is sorted by its Deduction name and code, so Dental EE and Dental ER both land in Benefits. The Taxable Reduction and Withholding groups are ignored; the groups only count when the name says nothing.
The unlabeled totals row is skipped.

The checks that run: deduction not taken, arrears increased, repeated deduction line, negative deduction, arrears growing (when the file covers two or more periods) and amount outliers, plus three Pro checks: payroll result not complete, employee and employer shares that don't pair, and large arrears balance. Without Pro, each Pro check that finds something shows as a count. A worker with Dental EE but no Dental ER is flagged when others in the file have both. An amount two or more workers share, like a family tier, isn't called an outlier. The Social Security and Medicare rate checks and the missing-FICA check sit out, since there are no taxable wages or tax lines.

Employer lines count toward Total withheld, the same as employee lines. The Breakdown tab, or By Deduction in the workbook, shows each code on its own.

Workday's Payroll Register, column by column
How the deduction audit works, with every check and bucket