YTD Report Samples from Previous Payroll Providers

What does a year-to-date (YTD) or quarter-to-date (QTD) report look like from my previous payroll provider?

Purpose: When switching to BambooHR Payroll, you will need to provide current year-to-date (YTD) and quarter-to-date (QTD) payroll data (including wages, taxes, and deductions) from your last payroll provider. Providing this data will ensure that W-2s are accurate at the end of the year. The data comes in a variety of formats and can be confusing to figure out which reports we will need. This help guide shares examples of report names and helpful screenshots from the more common payroll providers. 


Samples from Common Payroll Providers

If your previous payroll provider is not listed, take a look at some of the screenshots to see what kinds of reports are most helpful to upload to the Previous Provider Data section of the Payroll Onboarding checklist.  The report you supply during Payroll Implementation will need to include all wages, taxes, and deductions for each employee. 

Expand or collapse content ADP

ADP Payroll Allocation PDF

ADP Payroll Register Excel 

ADP Payroll Details PDF

ADP Client List PDF

ADP YTD Summary Excel

ADP Wage & Tax Register Excel 

ADP Workforce: Payroll Register Excel

Expand or collapse content A Plus Payroll

A Plus Payroll Payroll Register (By Pay Statements): Payroll Register By State Excel

Expand or collapse content Ceridian

Ceridian Excel YTD

Expand or collapse content Escalon

Escalon Payroll Wage, Tax, and Deduction Summary PDF

Expand or collapse content ExecuPay

ExecuPay Employee Summary Earnings PDF

ExecuPay Payroll Register PDF

Expand or collapse content Gusto

Gusto Payroll Journal Report (Payroll Journal Summary by Employee) PDF

Expand or collapse content Heartland

Heartland Check History Summary Report PDF

Expand or collapse content iSolved/PayLogics

iSolved/PayLogics Employee Payroll Breakdown YTD PDF

iSolved/PayLogics Periodic Payroll Register

Expand or collapse content Namely

Namely Payroll Register for Period Report PDF

Expand or collapse content Paychex

Paychex Payroll Register PDF

Paychex Employee Earnings Record PDF

Paychex Payroll Journal PDF

Expand or collapse content Paycom

Paycom Employee YTD Balance Report PDF

Expand or collapse content Paycor

Paycor Expanded YTD List PDF 

Expand or collapse content Paylocity

Payroll Register Summary

Expand or collapse content PrimePay

PrimePay Labor Distribution Report

Expand or collapse content Quickbooks

Quickbooks Desktop Excel Export

Quickbooks Cumulative Payroll Details Excel YTD

Quickbooks YTD Employee Payroll Summary Excel

Quickbooks Payroll Summary by Employee Report (Excel only)

Expand or collapse content SurePay

SurePay Payroll Summary PDF

SurePay Year-to-Date PDF 

Expand or collapse content Zenefits

Zenefits Payroll Journal Report PDF

Zenefits Individual Earnings Report Excel