Use pay run imports to bulk-add earnings or deductions to on-cycle and off-cycle pay runs when payroll data originates outside R365 or requires bulk entry. Imports are added through the Add Import wizard with either an Earnings Import template or a Deductions Import template. Imports apply to any employee who has been onboarded to payroll, including separated employees.
After upload, the system validates the import. Validation is usually quick, but large files may take longer. While validation is in progress, the import shows a Validating status on the Imports page. Once validation is complete, errors can be corrected before finalizing, and only valid rows are added to the pay run. Once complete, the pay run is ready for calculation and approval.
A pending import does not block calculation or approval of an unapproved pay run.
The associated Earnings Import Details page or Deductions Import Details page remains available for review at any time.
Security
To add or edit pay run imports, users must have the Edit Payments permission under Payroll → R365 Payroll → Payments.
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.
Add Import Wizard
The Add Import wizard is used to import earnings or deductions into an existing traditional pay run and can be used to import previously paid earnings. The wizard is launched from the Imports page by clicking Add. It guides the user through selecting a pay run to import to, downloading/uploading an import template, and reviewing errors. The pay run dropdown displays on-cycle and off-cycle pay runs from the Payroll Hub page that have not been finalized.
The template file must match the selected import type. Uploading an Earnings template when Deductions is selected (or vice versa) causes the upload to fail.
If the wizard is closed before clicking Complete Import, the import is not lost. It remains on the Imports page with a status of In Review (or Validating if validation is still running). Open the import from the Imports page to review errors and complete it.
Imports Page
The Imports page displays pending and completed pay run imports for earnings and deductions. Pending and completed imports can be viewed, completed, and added from this page. The Imports page is accessible from both the Payroll Overview page and the Pay Run Details page.
Earnings Import Details Page
The Earnings Import Details page shows all valid and invalid rows from an uploaded earnings import file. Before the import is completed, rows with errors can be updated, rows can be deleted, and the import can be completed.
The page appears in the Add Import wizard and is also accessible from the Imports page after the wizard is closed.
Deductions Import Details Page
The Deduction Import Details page shows all valid and invalid rows from an uploaded deductions import file. Before the import is completed, rows with errors can be updated, rows can be deleted, and the import can be completed.
The page appears in the Add Import wizard and is also accessible from the Imports page after the wizard is closed.
Import Templates
There are two import templates associated with pay run imports. When the import template is downloaded, all active employees and all valid earnings or deduction types are included in the blank template.
Earnings Import Template
The Earnings Import template is used to import earnings. Earning types that can be imported are automatically populated in the drop-down menu in the Earning Type column. 
Deductions Import Template
The Deductions Import template is used to import deductions. Deduction types that can be imported are automatically populated in the drop-down menu in the Deduction column. 