Calculation rules: Jan 1, 2026

Workday's Payroll Register, column by column

Workday's delivered Payroll Register exports to Excel as Payroll Register General Excel: a block of prompts, then one row per payment across 30 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 setup can fill columns differently; where yours has amounts and this page says 0, trust your file. Workday is a trademark of Workday, Inc. YourPayBot isn't affiliated with Workday.

How the file is laid out

Row 1 is the report name, Payroll Register General Excel.
Rows 2 to 8 are the prompts it was run with, one per row, label then value.
Row 9 is blank apart from Payment, which sits over Method and Payment Amount.
Row 10 is the header row. The data starts on row 11.
The last row says Grand Total in the Employee ID column, with totals across.

The prompts

Country

What it sets: The payroll country.
Value in the run: United States of America

Period

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

Pay Group

What it sets: The pay group you ran.
Value in the run: Weekly

Organizations

What it sets: The organization to report on.
Value in the run: Top Company Hierarchy

Include Subordinate Organizations

What it sets: Whether organizations under it are included.
Value in the run: No

Status

What it sets: Left blank in the run this page is written from.

Worker

What it sets: Left blank in the run this page is written from.

Prompt	What it sets	Value in the run
Country	The payroll country.	United States of America
Period	The pay period, then the period schedule in brackets.	09/13/2026 - 09/19/2026 (Weekly (Sun-Sat))
Pay Group	The pay group you ran.	Weekly
Organizations	The organization to report on.	Top Company Hierarchy
Include Subordinate Organizations	Whether organizations under it are included.	No
Status	Left blank in the run this page is written from.
Worker	Left blank in the run this page is written from.

One row per payment, not per worker

When a worker's pay is split across bank accounts, each deposit gets its own row. Every one of those rows repeats the worker's full Gross Pay and Net Pay, and Payment Amount holds that deposit's share. A worker with two accounts looks like this:

700102

Gross Pay: 1,240.00
Net Pay: 902.44
Payment Amount: 800.00

700102

Gross Pay: 1,240.00
Net Pay: 902.44
Payment Amount: 102.44

Employee ID	Gross Pay	Net Pay	Payment Amount
700102	1,240.00	902.44	800.00
700102	1,240.00	902.44	102.44

Add up Gross Pay down the column and this worker counts twice. The Grand Total row counts each worker once, so use it, or total Payment Amount for net. In the run behind this page, a few workers had two or three rows, and a hand total of Gross Pay came out about 15% over the Grand Total.

Workers with nothing paid this period can still be listed, with 0 in Gross Pay, Net Pay and Payment Amount. YourPayBot lists them under No gross and no net pay.

Every column

Employee ID

What it holds: The worker's ID. Keep it as text: IDs can start with 0. The last row holds Grand Total here.
On the US run: Filled

First Name

What it holds: First name.
On the US run: Filled

Last Name

What it holds: Last name. There's no full-name column.
On the US run: Filled

Cost Center

What it holds: The worker's cost center, code and name together.
On the US run: Filled

Hire Date

What it holds: Hire date.
On the US run: Filled

Termination Date

What it holds: Termination date, for anyone terminated.
On the US run: Blank for everyone in the run

Annual Salary

What it holds: Annual pay. Hourly workers have an annualized figure here too.
On the US run: Filled on every row

Hourly Rate

What it holds: The hourly rate.
On the US run: Hourly workers only; blank for salaried

Basic Salary

What it holds: An earnings column.
On the US run: 0 on every row

Basic Wages

What it holds: An earnings column.
On the US run: 0 on every row

Bonus

What it holds: An earnings column.
On the US run: 0 on every row

Taxable Payment

What it holds: An earnings column.
On the US run: 0 on every row

Commission

What it holds: An earnings column.
On the US run: 0 on every row

Overtime

What it holds: An earnings column: overtime pay, not hours.
On the US run: 0 on every row

Holiday Pay

What it holds: An earnings column.
On the US run: 0 on every row

Vacation Pay

What it holds: An earnings column.
On the US run: 0 on every row

Non Cash Taxable Payment

What it holds: An earnings column.
On the US run: 0 on every row

Non Taxable Payment

What it holds: An earnings column.
On the US run: 0 on every row

Loan Payment

What it holds: An earnings column.
On the US run: 0 on every row

Advance Payment

What it holds: An earnings column.
On the US run: 0 on every row

Earnings Total

What it holds: The total of the earnings columns. Not the same as Gross Pay.
On the US run: 0 on every row, even with Gross Pay filled

Loan Recovery

What it holds: A deduction column.
On the US run: 0 on every row

Advance Recovery

What it holds: A deduction column.
On the US run: 0 on every row

Employee Pension

What it holds: A deduction column.
On the US run: 0 on every row

Gross Pay

What it holds: Gross pay for the pay result. Repeated on every payment row for that worker.
On the US run: Filled; 0 for workers not paid this period

Net Pay

What it holds: Net pay for the pay result. Also repeated on every payment row.
On the US run: Filled

Method

What it holds: How this payment went out.
On the US run: Direct Deposit or Check

Payment Amount

What it holds: This payment's share of net. One worker's payment rows add up to Net Pay.
On the US run: Filled

Employer Pension

What it holds: An employer cost column.
On the US run: 0 on every row

Other Employer Cost

What it holds: An employer cost column.
On the US run: 0 on every row

Column	What it holds	On the US run
Employee ID	The worker's ID. Keep it as text: IDs can start with 0. The last row holds Grand Total here.	Filled
First Name	First name.	Filled
Last Name	Last name. There's no full-name column.	Filled
Cost Center	The worker's cost center, code and name together.	Filled
Hire Date	Hire date.	Filled
Termination Date	Termination date, for anyone terminated.	Blank for everyone in the run
Annual Salary	Annual pay. Hourly workers have an annualized figure here too.	Filled on every row
Hourly Rate	The hourly rate.	Hourly workers only; blank for salaried
Basic Salary	An earnings column.	0 on every row
Basic Wages	An earnings column.	0 on every row
Bonus	An earnings column.	0 on every row
Taxable Payment	An earnings column.	0 on every row
Commission	An earnings column.	0 on every row
Overtime	An earnings column: overtime pay, not hours.	0 on every row
Holiday Pay	An earnings column.	0 on every row
Vacation Pay	An earnings column.	0 on every row
Non Cash Taxable Payment	An earnings column.	0 on every row
Non Taxable Payment	An earnings column.	0 on every row
Loan Payment	An earnings column.	0 on every row
Advance Payment	An earnings column.	0 on every row
Earnings Total	The total of the earnings columns. Not the same as Gross Pay.	0 on every row, even with Gross Pay filled
Loan Recovery	A deduction column.	0 on every row
Advance Recovery	A deduction column.	0 on every row
Employee Pension	A deduction column.	0 on every row
Gross Pay	Gross pay for the pay result. Repeated on every payment row for that worker.	Filled; 0 for workers not paid this period
Net Pay	Net pay for the pay result. Also repeated on every payment row.	Filled
Method	How this payment went out.	Direct Deposit or Check
Payment Amount	This payment's share of net. One worker's payment rows add up to Net Pay.	Filled
Employer Pension	An employer cost column.	0 on every row
Other Employer Cost	An employer cost column.	0 on every row

Eighteen columns read 0 on every row: every earnings, deduction and employer cost column, Earnings Total included. Gross Pay is the column to trust. If your tenant does fill the earnings columns, check that they add up to Gross Pay before you use them.

What it leaves out

For a US gross-to-net review, these aren't in the file:

Federal, state and local income tax

What that means: None of them. There's no withholding column of any kind.

Social Security and Medicare

What that means: Not in the file, so neither rate can be checked. YourPayBot still flags net pay too high to have had them taken out.

Deductions by type

What that means: Pre-tax and post-tax deductions aren't broken out. Gross Pay minus Net Pay is everything withheld, as one number. The Deduction Register has them line by line.

Hours

What that means: No regular or overtime hours, so overtime and minimum wage can't be tested.

Pay date

What that means: Only the period, in the prompts at the top. No row carries a pay date.

Bank account

What that means: Method says Direct Deposit or Check, but not which account.

Missing	What that means
Federal, state and local income tax	None of them. There's no withholding column of any kind.
Social Security and Medicare	Not in the file, so neither rate can be checked. YourPayBot still flags net pay too high to have had them taken out.
Deductions by type	Pre-tax and post-tax deductions aren't broken out. Gross Pay minus Net Pay is everything withheld, as one number. The Deduction Register has them line by line.
Hours	No regular or overtime hours, so overtime and minimum wage can't be tested.
Pay date	Only the period, in the prompts at the top. No row carries a pay date.
Bank account	Method says Direct Deposit or Check, but not which account.

The Deduction Register fills in the deductions, one line per worker per deduction. For the tax checks you need a report with a column per tax, such as a custom register.

How YourPayBot reads it

Drop the file as it comes on 2 · Register & deductions. No renaming needed.

Row 10 is taken as the header because it's the row that names all 30 columns. Rows 1 to 9, the report name, prompts and the Payment label, are kept as report info: listed under the file name and on a Report Info tab in the workbook.
First Name and Last Name are joined into the name.
Cost Center fills the By Department tab. Hourly Rate is read as the pay rate.
Split deposits are read as one payment when the rows share an ID, Gross Pay and Net Pay and their Payment Amounts add up to Net Pay. The Grand Total row is dropped. So Employees, Total gross and Total net match the Grand Total.
Annual Salary feeds the salary check and Method the live-check list. Hire Date and Termination Date are checked against the dates in the Period prompt. Bonus and Commission are listed under columns need your confirmation, marked needs review. Neither feeds a check, so choose Don't include for both. Do the same with Overtime if yours has amounts in it: it's read as overtime hours by default.

Nine checks run. Four are free: negative or zero net pay, net pay over gross, duplicate payments and payments with no name. Five are Pro checks: salary against pay (weekly, from the Period prompt), net pay that leaves no room for FICA, live checks, workers with no gross and no net pay, and pay outside the hire and termination dates. Without Pro, each one that finds something shows as a count. The Summary names the six that can't run on this file: Social Security, Medicare, overtime, minimum wage, gross-to-net and shared bank accounts.

For more, use two of these registers, this period's and last period's, in the close checks. They list new payees, missing payees and big swings in gross.

Workday's Deduction Register, column by column
How the register audit works, with every check and threshold

Drop your Payroll Register on the audit