The Payroll Register Report provides a register of employee payments — earnings, deductions, taxes, and check or direct deposit amounts — for a selected pay date range. Payroll administrators use this report to reconcile payroll and support audits. The report is available in My Reports.
Security
Users must have the following permission(s) to run the Payroll Register Report:
Payroll → R365 Payroll → Reports → View Reports
These permissions can be added to custom user roles or individual users. The Permission Access report can be used to determine which user roles or users already have these permissions assigned. For more information, see User Setup and Security.
Run the Payroll Register Report
Follow these steps to run the Payroll Register Report from My Reports:
Click steps to expand for additional information and images.
1) Open the Reports app and select ‘My reports.’
2) Enter all or part of "Payroll Register" in the search bar.
Search results appear under the My Reports tab.
3) Under the Other section, locate Payroll Register Report.
4) Click RUN to run with the current saved view, or click Customize to configure parameters first.
Clicking RUN opens the report in the viewer. Skip to step 6.
Clicking Customize opens the parameter panel. Continue to step 5.
5) Configure parameters in the panel, then click RUN.
Use the following parameters to filter and configure the report:
Parameter | Description |
|---|---|
Start | Start date of the pay date range. Click Today or Yest. for a quick selection, or use the date picker. |
End | End date of the pay date range. Click Today or Yest. for a quick selection, or use the date picker. |
Locations | Filters results to selected locations tied to the payroll company. Defaults to All Selected. |
Employees | Search for and select specific employees to include. Defaults to All. |
Pay Run Type | Filters results to the selected pay run type. Toggle between on cycle and off cycle. |
Employee Status | Filters results to employees with the selected employment status. Defaults to All. |
FLSA Status | Filters results to employees with the selected FLSA classification. Defaults to All. |
Employment Type | Filters results to employees with the selected employment type. Defaults to All. |
Summary | Controls the level of detail in the report. Set to Yes for totals only (Summary mode). Set to No for a full per-employee breakdown (Detail mode). Defaults to No. |
GroupBy | Groups report results and adds a sub-total row for each group value. Options: Pay Run Type, Locations, Pay Groups, FLSA Status, Employee. Defaults to None. |
Exclude Voided Paychecks | Set to Yes to exclude voided and deleted payments from the register. Set to No (default) to include all payments. Included voided payments appear without any visual indicator distinguishing them from active payments. |
6) Review the report in the viewer.
The report displays a header, payment data (per-employee in Detail mode, totals in Summary mode), and a summary section. See Report layout below for column and section details.
Export, email, or print the Payroll Register Report
To export, email, or print the report from the My Reports list, click the RUN dropdown arrow (▼), then select the desired option:
Export — downloads the report
Email — sends the report via email
Print — opens the report for printing
These options are also available from the toolbar within the report viewer.
Report layout
Header
The report header displays the following:
Report title
Pay date range
Selected Pay Run Type(s)
FLSA Status filter value
Date and time the report was run
Page number
Detail mode columns
In Detail mode, the report includes a row per employee payment. Earnings, deductions, and taxes each appear as one set of columns per code, sub-totaled by code and by section.
Column | Description |
|---|---|
Employee Name | Employee name from the employee record. |
Employee # | Employee identifier. |
Pay Run ID | Identifier for the pay run. |
Pay Date | Scheduled pay date for the pay run. |
Pay Period End Date | End date of the pay period. |
Earning Code / Hours / Rate / Amount | One set of columns per earning code, sub-totaled by code and by section. |
Deduction Code / Amount | One set of columns per deduction code, sub-totaled by code and by section. |
Tax Code / Amount | One set of columns per tax code, sub-totaled by code and by section. |
Check # | Check number. Populated for payments made by check. |
Check Amount | Amount paid by check. |
Direct Deposit Amount | Amount paid by direct deposit. |
Net Amount | Net pay for the employee payment. |
Summary section
Both Detail and Summary modes include a summary section at the end of the report:
Total earnings by earning code
Total deductions by deduction code
Total taxes by tax code
Grand totals: Direct Deposit amount, Check amount, number of pays, number of hours, and total earnings, deductions, and taxes
Voided or deleted payments are included in the register unless Exclude Voided Paychecks is set to Yes. Included voided payments appear without any visual indicator distinguishing them from active payments.