Payroll by Pay Period & Payroll by Pay Date Reports

Updated on 20 Jan 2025
3 Minutes to read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

This article reviews the 'Payroll by Pay Period' and 'Payroll by Pay Date' reports within Workforce Reports.

The 'Payroll by Pay Period' and 'Payroll By Pay Date' reports are downloadable reports that contain payroll payment information for a specified period, including earnings, tax, and contribution summaries, as well as payment details.

Navigation

The Payroll by Pay Period and Payroll by Pay Date reports are can be downloaded from the Workforce reports page.

To download the desired report, follow these steps:

1) In the Workforce application, in the left navigation, click Reports.

2) Click Workforce Reports.

3) Click download next to the desired report.

4) Select the desired period/date range, then click Download Report.

Payroll by Pay Period

Payroll by Pay Date

The report will be downloaded as a .xlxs file.

Report Pages

The downloaded report will have multiple pages:

Cover Page - Displays general information and report totals.
Summary by Department - Displays Employee details, subtotaled by department.
Summary by Title - Displays Employee details, subtotaled by Job.
Summary by Employee - Displays Employee details without subtotals.
Payment Detail - Displays full payment details for each Employee.
- For Payroll Runs that have been calculated, each earning and deduction associated with the selected period will be listed in additional columns.
One Time Payment Details - Displays details from One-Time Payments.
- If no One-Time Payments were included, the page will be blank.
Pullback: Displays details for payments that were pulled back in the selected time-frame.
- If no payments were pulled back for the selected time frame, the page will be blank.

Cover Page

The cover page displays general information and report totals for all Employees in the selected period:

Columns	Description
Company	Payroll Company included in the report.
Report Date	Full date range for the report.
Minimum For-Date	First date included in the report.
Maximum For-Date	Last date included in the report.
Gross Pay	Total gross pay for all Employees.
PreTax Deductions	Total pre-tax deductions for all Employees.
PostTax Deductions	Total post-tax deductions for all Employees.
Deferred Compensation	Total deferred compensation for all Employees.
Total Employee Tax	Total taxes paid by Employees.
Net Pay	Total net pay for all Employees.
Pullback	Total pullback for all Employees.
Total Contributions	Total Employer contributions.
Total Employer Tax	Total taxes paid by the Employer.
Total Expense	Total Employer expenses.

Report Columns

Column	Summary by Department	Summary by Title	Summary by Employee	One Time Payments	Payment Detail	Pullback
ACH Deposit					X	X
Amount				X
Approval Group	X	X	X	X	X	X
Business Name	X	X	X	X	X	X
Company ID				X	X	X
Current Payment Preference					X	X
Deferred Compensation	X	X	X		X	X
Department	X	X	X	X	X	X
Distribution Record					X	X
Double Time Hours	X	X	X		X	X
Earning Notes					X	X
Earning Type				X
Email				X	X	X
Funding ACH Record					X	X
Gross Pay	X	X	X		X	X
Instant Deposit					X	X
Name	X	X	X	X	X	X
Note				X
Net Pay	X	X	X		X	X
Overtime Hours	X	X	X		X	X
Pay Card Deposit					X	X
Pay Cycle					X	X
Pay Date					X	X
Pay Period End Date					X	X
Pay Period Start Date					X	X
Payment ID				X	X	X
Payment Status				X	X	X
Payroll Employee ID					X	X
Phone				X	X	X
PostTax Deductions					X	X
PreTax Deductions	X	X	X		X	X
Previously Paid Earnings	X	X	X		X	X
Pulled Back On						X
Regular Hours	X	X	X		X	X
Title	X	X	X	X	X	X
Total Contributions	X	X	X		X	X
Total Expense	X	X	X		X	X
Total Tax EE	X	X	X		X	X
Total Tax ER	X	X	X		X	X
Work Location	X	X	X	X	X	X
Worker Type	X	X	X	X	X	X

Columns and Descriptions

Column	Description
ACH Deposit	Amount deposited to the Employee's direct deposit account.
Amount	Amount of the One-Time Payment.
Approval Group	Approval Group the Employee is assigned to.
Company ID	Payroll Company's ID .
Company ID	Company's ID associated with R365 Payroll.
Current Payment Preference	Payment preference listed on the payroll tab of the employee record.
Deferred Compensation	Total deferred compensation for the Employee.
Department	Department the Employee is assigned to .
Distribution Record	How payment was distributed to the Employee. (ACH, check, pay card).
Double Time Hours	Total doubletime hours worked.
Earning Notes	Notes associated with a One-time payment.
Earning Type	Earning Type for the One-Time Payment.
Email	Employee's email address.
Funding ACH Record	ACH Record associated with the Employee's direct deposit for the payment.
Gross Pay	Total gross pay for the Employee.
Instant Deposit	Instant Deposit is not offered by R365
Name	Employee's full name.
Net Pay	Total net pay for the Employee.
Note	One-Time Payment comment.
Overtime Hours	Total overtime hours worked.
Pay Card Deposit	Amount deposited to the Employee's pay card.
Pay Cycle	Employee's pay frequency.
Pay Date	Pay date for the pay period.
Pay Period End Date	End date of the pay period.
Pay Period Start Date	Start date of the pay period.
Payment ID	Unique ID for the payment.
Payment ID	ID number for the ACH or pay card deposit.
Payment Status	Status of the payment to the Employee.
Payroll Employee ID	Employee's unique identification number within R365.
Payroll Employee ID	Employee's unique identification number within R365.
Phone	Employee's phone number.
PostTax Deductions	Total post-tax deductions for the Employee.
PreTax Deduction	Total pre-tax deductions for the Employee.
Previously Paid Earnings	Earnings already paid to the Employee.
Pulled Back On	Date the payment was pulled back.
Regular Hours	Total regular hours worked.
Title	Job associated with the Employee's earnings.
Total Contributions	Total Employer contributions for the Employee.
Total Expense	Total Employer expense for the Employee.
Total Tax EE	Total taxes paid by the Employee.
Total Tax ER	Total Employer-paid taxes for the Employee.
Work Location	Employee's Primary Location for the Payroll Company.
Worker Type	Either employee or contractor.

Was this article helpful?

What's Next

Employee Census

Table of contents

Navigation
Report Pages
Cover Page
Report Columns
Columns and Descriptions