Payroll by Pay Period & Payroll by Pay Date Reports

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

To download the desired report, navigate to the Workforce Reports page, locate the desired report in the 'Payments' section, then click 'Download'.

Select the desired period from the dropdown menu, then click 'Download report'. 

Payroll by Pay Period  Contains payroll payment information for a selected Pay Period.
Payroll by Pay Date Contains payroll payment information for a selected date range.

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

• One-Time Payment Details - Displays details from One-Time Payments

Cover Page

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

Company - Payroll Company 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

Summary Pages

The downloaded report has three summary pages with the same columns and different subtotals. 

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

Columns

• Name - Employee's full name

• Business Name - Name of the business associated with contractors

• Title - Job associated with the Employee's earnings

• Approval Group - Approval Group the Employee is assigned to

• Department - Department the Employee is assigned to 

• Work Location - Employee's Primary Location for the Payroll Company

• Regular Hours - Total regular hours worked

• Overtime Hours - Total overtime hours worked

• Double Time Hours - Total doubletime hours worked

• Gross Pay - Total gross pay for the Employee

• PreTax Deduction - Total pre-tax deductions for the Employee

• PostTax Deductions - Total post-tax deductions for the Employee

• Deferred Compensation - Total deferred compensation for the Employee

• Total Tax EE - Total taxes paid by the Employee

• Net Pay - Total net pay for the Employee

• Total Contributions - Total Employer contributions for the Employee

• Total Tax ER - Total Employer-paid taxes for the Employee

• Total Expense - Total Employer expense for the Employee

Payment Detail

The 'Payment Detail' page displays additional columns for payment details associated with each Employee:

Additional Columns

• Email - Employee's email address

• Phone - Employee's phone number

• Pay Cycle - Employee's pay frequency

• Pay Period Start Date - Start date of the pay period

• Pay Period End Date - End date of the pay period

• Pay Date - Pay date for the pay period

• Payment Status - Status of the payment to the Employee

• Funding ACH Record - ACH Record associated with the Employee's direct deposit for the payment

• Distribution Record - How payment was distributed to the Employee. (ACH, check, pay card)

• Earning Notes - Notes associated with a One-Time Payment

• Previously Paid Earnings - Earnings already paid to the Employee

• ACH Deposit - Amount deposited to the Employee's direct deposit account

• Pay Card Deposit - Amount deposited to the Employee's pay card

• Payment ID - Unique ID for the payment

• Payroll Employee ID - Employee's unique identification number within R365

• Company ID - Payroll Company's ID 

Earnings and Deductions

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 Detail

The 'One-Time Payment Detail' page includes information for One-Time Payments included in the selected period. If no One-Time Payments were included, the page will be blank.

One-Time Payment Columns

• Payment ID - ID number for the ACH or pay card deposit

• Payroll Employee ID - Employee's unique identification number within R365

• Company ID - Company's ID associated with R365 Payroll

• Earning Type - Earning Type for the One-Time Payment

• Amount - Amount of the One-Time Payment

• Note - One-Time Payment comment