What fields are on the Payroll Report in Tilt?

Quick answer

The Payroll Report provides HR and Payroll teams the info they need to understand how an employee's pay is distributed across sources and what's owed during their leave of absence. There are two types of information on the report:

Standard Payroll Data — general information about payments for the leave
Pay Adjustment Data — information about changes that occurred to an employee's pay calculation from a previously paid-out pay period (a recalculation)

Who this applies to / Prerequisites

You are an HR or Payroll user at a Tilt customer.
You want to understand what each column on the Payroll Report means.
You've previewed or exported the Payroll Report. See How do I download a payroll report from Tilt?

Note about conditional columns: Any pay category, benefit, or leave type column only appears when at least one employee in the pay period has data in that category. If nobody has PTO pay during the period, the Company PTO Pay columns won't appear. This applies to all pay, benefit, and Company Paid Leave columns.

Standard Payroll Data

Column	What it shows
Employee	First and last name of the employee (combined).
Employee First Name / Employee Last Name	Employee's first and last name (separate columns).
Employee ID	Unique ID associated with the employee.
Salary	Employee's current salary.
Leave Type	Parental, Medical, Caregiver, Military, or Other.
Leave Start / Leave Return	Dates the leave started and is expected to end (DD/MM/YYYY).
Leave Frequency	Intermittent or Continuous.
Total Leave Hours	Total leave hours across the pay period.
Pay Period Time Off Dates	Date(s) in the pay period the employee was on leave. Individual dates or a date range.
Location	Employee's state of residence (state abbreviation; CD = Canada).
Period Start / Period End	Start and end dates of the pay period.
Employee Wages / Employee Wages Hours	Employee's total wages for the pay period, and the hours associated. Pre-tax.
Company Regular Wages	Total company-paid regular wages for the pay period.
Company PTO Pay / Company Holiday Pay / Company Sick Pay	Wages associated with PTO, holiday, or sick time. Each has a matching Hours column when applicable.
Company Paid Parental Leave / Caregiving Leave / Medical Leave / Military Leave / Disability Leave / Extras / Leave Other / Unpaid Leave	Company-paid amounts broken out by leave category. Column name matches the leave type. Each has a matching Hours column when applicable.
STD Paid Benefit / LTD Paid Benefit	Short-term or long-term disability benefits paid.
State Paid Benefit	Amount paid by a state benefit program. The column is named by the specific state law — for example, Colorado FAMLI Act: Paid Benefit, California PFL: Paid Benefit, or New York PFL: Paid Benefit.
Federal Government Paid Benefit	Amount paid by a federal benefit program.
Tilt Administrative Unpaid	Administrative unpaid time recorded by Tilt.
Total Company Paid	Total the company should pay the employee across all wage sources for the pay period.
Total Pay Received	Total the employee will take home across all sources for the pay period. Pre-tax.

Pay Adjustment Data

Pay adjustments appear when an employee's pay calculation needs to be recalculated and the change affects an already-paid pay period. Each data point above can include a matching adjustment column when applicable.

Column	What it shows
Adjustment Benefit / Adjustment Benefit Hours	The adjusted amount for the affected pay or benefit category, plus the hours associated.
Total Adjustments to be Made by My Company	Total of all adjustments the company should pay the employee in the pay period.
Reason for Adjustment (also called Comment/Modified Reason)	Why the adjustment was made. Options: Salary Change, Date Change, State Benefit Adjusted, Disability Adjusted, Other.
Added Pay Periods	Previously closed pay period(s) that were retroactively applied to a leave. Displays date range(s).

Important note on Added Pay Periods: Tilt only calculates pay for periods within an employee's specified leave time. If a leave change affects a pay period Tilt didn't originally include, the affected periods appear in Added Pay Periods. Tilt doesn't have historical pay data for those periods, so Payroll teams should manually review what the employee was paid during those periods and reconcile the adjustment.

What if it doesn't work

If a column you expected to see isn't in the report, no employees had data in that category during the pay period.
If adjustment amounts look unfamiliar, check the Reason for Adjustment column for context.
If Added Pay Periods shows values, review the employee's historical pay records for those periods manually.

Limits and exceptions

Column availability depends on whether any employee had data in that category during the pay period.
All amounts are pre-tax. Actual take-home pay may differ based on taxes and deductions.
State benefit columns are named by the specific state law, so the exact column depends on the states your employees are on leave in.
Tilt only calculates pay for periods within an employee's specified leave time.