Payroll Register report

The Payroll Register report is used to report payments and totals for non-closed payroll payments.

Select Payroll Administrator > Cycle Processing > Payroll Register.
Click a tab to view information.
- Payments tab—Each created employee payment with subtotals using columnar data.
- Payment Totals tab—Totals from created payments using columnar data.
- Wage And Deduction Totals tab—References to existing analytic cube views where the Payment Status is Created.
  - Data is displayed for the Employee Time Record and Employee Payment Deduction Detail cubes.
  - The payroll country is used as context for totals in a single currency.
On the Payments tab and Payment Totals tab, perform a search to retrieve data.
1. In the Currency field, specify a currency.
2. Optionally, specify information in other fields.
  - Select options to identify exceptions. For example, Net Pay < .0 or Gross Pay > 100,000.
  - Select options for Off Cycle Payments.
    - Leave blank to select all types of payments.
    - Select Yes to select payments and adjustments finalized from Off Cycle.
    - Select No to select payments created by Calculate Payments.
3. Click Search.
  
  Selected records are displayed with subtotals based on the selected aggregation chart.
  
  Payment records with a status of Created are included in the list.
On the Payments tab and Payment Totals tab, select an option from the Charts list to view payment data:
- Totals By Payment Schedule—This option is the default. This is the payment schedule for the payment.
- Totals By Legal Entity—The legal entity for the work assignment when Lock Payroll occurred.
- Totals By Location—The location for the work assignment when Lock Payroll occurred.
- Totals By Organization Unit—The organization unit for the work assignment when Lock Payroll occurred. If you search by parent organization unit, all organization units that roll up to the parent unit are displayed. Totals are displayed for each organization along with a final total.
- List for Payments—The columnar data not using an aggregation chart. Fifty records are returned at a time on this list. The grand total represents all the data that meet the search criteria.
Note:
- Payments have earnings and deduction details.
  - Year to Date amounts are included for deductions.
  - Year to Date includes the selected payment plus any other payments with a check date that is less than the current check date in the current year.
  - Taxes are separated from other deductions and include regulatory taxable wages and excess wages.
- The Payroll Register includes payments in Created status.
On the Payments tab, click these links to view more information:
- Click the link in the Cycle column to view the Employee Payroll Cycle record for that payment. The Employee Payroll Cycle form contains the data that was stored during the lock process for that payment. For example, employee name and address.
- Click the link in the Payment column to view all the related data for that payment on a form.
- Click the link in the Check Number column to view to the related Payroll Check record that is created when Print Payments is run. The record contains information such as the print serial number, bank reconciliation date and amount, and wage and deductions data used for printing payments.
On the Wage And Deduction Totals tab, Totals By Payment Schedule is the default aggregation. Click Totals By Payment Schedule to select additional views:
- Totals By Legal Entity—The legal entity on the payment’s time records and deductions calculated based on the time records. These totals do not balance to payment totals by legal entity if the time records have a different legal entity than the work assignment at the time of payment.
- Totals By Payment Legal Entity—The legal entity of the work assignment at the time of payment. Select this option to balance to payment totals by legal entity.
- Totals By Organization Unit—The organization unit for the work assignment when Lock Payroll occurred. If you search by parent organization unit, all organization units that roll up to the parent unit are displayed. Totals are displayed for each organization along with a final total.