Current Ireland Employee RPN Data

Activate User's Guide
Version
2025.1
Current Ireland Employee RPN Data

Use the Current Ireland Employee RPN (Revenue Payroll Notification) Data wizard to load current RPN tax information for employees taxed in Ireland.

Organizations based in Ireland and organizations based outside of Ireland that have employees located in Ireland can use this wizard to import data for these employees in preparation for parallel testing.

Note: You must have IRL pay groups defined and installed to role feature access this wizard.

Note: Activate uses HR Version 2.0 (NextGen) when loading data during configuration.

Before you begin

The organization must fit at least one of the following:

  • Based in Ireland.
  • Has employees who are based in Ireland.

Using this wizard

You’ll use the Current Ireland Employee RPN Data wizard to do the following:

Upload the Tax Info Data IRL template

Use the Tax Info Data IRL template to load current tax information for employees filing taxes in Ireland.

Review the information

If you find any errors or missing information, correct the template document and upload it again. Or, you can correct the data on the page. You must resolve all errors to continue.

Install the earning codes in Dayforce

When the tax information is complete in Activate, install it in Dayforce.

Messages: Error, Warning, and Information

Activate sorts each generated message by severity:

Error codes

Actively incompatible with the data in Dayforce. If you have a data error, you must resolve the error before you can complete the installation.

Warning codes

Indicate nonstandard setup that could potentially cause an error in Dayforce. For example, if an earning code is defined as Hours x Rate and the data is amount only, the system creates a warning. However, you can still import the data into the system.

Informational codes

A notable occurrence of data in the system. For example, an informational note shows if codes are dropped from the YTD import.

Tasks

To complete and upload the Tax Info Data IRL template:
  1. In Activate Central, click Load Your Data. The Load Your Data wizards show.
  2. Click Current Ireland Employee RPN Data.
  3. On the IRL Tax Data page, click Download.

    Note: You can also download an empty Current Ireland Employee RPN Data template from the Download Template Files page.

  4. Select the location where you want to save the template document.
  5. Open the TaxInfoDataTemplateIRL.xlsx template on your computer.
  6. On the TaxInfoDataIRL tab, complete all columns with the data for all employees in the organization.

    Note: The Activate release version shows in cell B3 on the Instructions tab of the template. This information helps you later determine the version of Activate you were using when you downloaded the template.

    Note: Instructions for populating the fields are in the Tax Info Data Template IRL Fields section (below) and on the Instructions tab of the template.

  7. Click Save and close the template.

    You can use any file name for the template you upload. The file must be an Excel or CSV (Comma-Separated Value) document and contain the data in the required format.

    Important: Don’t change the name of the tab because Activate uses it to validate that the correct template is being uploaded.

  8. On the IRL Tax Data page, click Upload.
  9. Go to your completed Tax Info Data IRL template in the location where you saved it.
  10. Click Open. The Current Ireland Employee RPN Data wizard validates the data.

    Note: If the uploaded file has errors, a Validation Failed message shows in red at the bottom of the page. You must correct the errors in the file on your computer and upload the file again.

    Note: When you upload an Excel file, Activate includes the name of the uploaded file into the name of the XML file it generates and loads to the Dayforce File Server. The format of the generated XML file name is <NamespaceName>_<Import Type>_<file name provided>_YYY-MM-DD_HHMM. This information makes it easier to audit files later.

  11. Click Next.
To review and confirm the data:
  1. Review the information shown in the grid.
  2. To make updates to data on the page:

    • To insert a new row in the grid, click the row where you want to insert it and click New.

    • To delete a row, click the row and click Delete.

    • To save the changes you’ve made in the grid, click Save.
    • To download the error message list and save it to your computer, click Download Errors File.
    • To correct errors in the grid, click in the field containing the error. Click Tab to move to the right and Shift+Tab to move to the left in the row. Use the scrollbars on the right side and bottom of the grid to go to other areas of the grid.

    • To save information in the grid to your computer, click Download File and save it to the location you want.

    • To upload the file from your computer, locate the file and click Upload File. The data in the file shows in the grid.

    • To remove changes that you don’t want to save, click Refresh.

  3. When the data is complete, click Done & Install. The selected values stay in the grid when you leave the page.
To install employee data in Dayforce:

When the employee information is complete in Activate, you must install the information in Dayforce.

  1. Click Next on the Review page.

    The Load page opens with a list of the steps to complete and an estimate of how long the installation usually takes. During the installation, the current step in the process is bolded so you can monitor the progress.

  2. Click one of the following:
    • Add Email and enter your email address to be notified when the installation process ends instead of waiting for it to finish.
    • Next when the installation is complete.

    Activate Central opens with the wizard name now in green text and a green checkmark next to it. The day, date, and time of completion show, along with your name as the user who completed the wizard. The environment in which the installation was applied (Stage, Config, or Train) is also shown.

    Note: If you want to add more information, click I want to add more. See Executing a Rollback When Using the “Add More“ Feature in the Payroll Wizards.

Results

The resulting HR Import is available for reference or to import into another environment, if needed.

Fields populated in Dayforce

The data uploaded from the Tax Info Data IRL template populates the fields on the Dayforce Tax Definitions page (People > Payroll > Tax Definitions). If the current entry has an end date in the past or to see current and prior entries, you’ll need to click All in the View field.

Dayforce fields populated by the Tax Info Data IRL template
Field in Template Field in Dayforce
Employee Identifier A numeric identifier next to the employee name
First Name Employee First Name
Last Name Employee Last Name
Effective Start Date Effective From
Effective End Date Effective To
Tax Year Tax Year
(Revenue Payroll Notification (RPN) section)
RPN Number RPN Number
(Revenue Payroll Notification (RPN) section)
RPN Issue Date RPN Issue Date
(Revenue Payroll Notification (RPN) section,
General section)
Income Tax Calculation Basis Income Tax Calculation Basis
(Revenue Payroll Notification (RPN) PAYE section)
Exclusion Order This information doesn’t show on the employee profile but is stored in the database.
Yearly Tax Credits Yearly Tax Credits
(Revenue Payroll Notification (RPN) PAYE section)
Pay for Income Tax to Date Pay for Tax Date
(Revenue Payroll Notification (RPN) PAYE section.)
Income Tax Deducted to Date Tax Deducted to Date
(Revenue Payroll Notification (RPN) PAYE section)
USC Status USC Status
(Revenue Payroll Notification (RPN) section)
Pay for USC to Date Pay for USC to Date
(Revenue Payroll Notification (RPN) section,
USC section)
USC Deducted to Date USC Deducted to Date
(Revenue Payroll Notification (RPN) section,
USC section)
LPT to Deduct LPT to Deduct
(Revenue Payroll Notification (RPN) section)
PRSI Exempt PRSI Exempt
(Revenue Payroll Notification (RPN) section,
PRSI Info section)
PRSI Class PRSI Class
(Revenue Payroll Notification (RPN) section,
PRSI Info section)
Tax Rate Percent 1 Tax Rate Percent 1
(Revenue Payroll Notification (RPN) section,
PAYE section)
Yearly Rate Cutoff 1 Yearly Rate Cutoff 1
(Revenue Payroll Notification (RPN) section,
PAYE section)
Tax Rate Percent 1 Rate Percent 1
(Revenue Payroll Notification (RPN) section,
USC section)
Yearly USC Rate Cutoff 1 Yearly Rate Cutoff 1
(Revenue Payroll Notification (RPN) section,
USC section)
USC Rate Percent 2 Rate Percent 2
(Revenue Payroll Notification (RPN) section,
USC section)
Yearly USC Rate Cutoff 2 Yearly Rate Cutoff 2
(USC section)
USC Rate Percent 3 Rate Percent 3
(Revenue Payroll Notification (RPN) section,
USC section)
Yearly USC Rate Cutoff 3 Yearly Rate Cutoff 3
(Revenue Payroll Notification (RPN) section,
USC section)
USC Rate Percent 4 Rate Percent 4
(Revenue Payroll Notification (RPN) section,
USC section)
Yearly USC Rate Cutoff 4 Yearly Rate Cutoff 4
(Revenue Payroll Notification (RPN) section,
USC section)
Legal Entity XRefCode Legal Entity

Next steps

Complete the next wizard, because appropriate.

Tax Info Data template IRL fields

All templates have the same basic structure:

  • Instructions tab: Helps you understand the purpose of the data and complete the fields in the template.
  • Data tab: Contains headers for the data to be included in the template. The headers remain the same, but you can change the column order. If you add more columns, Activate ignores them.

All number ranges in the templates include the numbers at both ends of the range.

To see a list of the fields in the template, click here.
Employee Identifier (Required)
Order Data Type Description Examples Why This Is Needed
1 Alphanumeric. Unique value between 1-40 characters.

For Canadian pay groups, a unique value between 1-9 characters.

Allows our system to identify employees. You’ll want to use the same number assigned to the employee in the Getting Started HR data loads. 3241245
000000006
abc123499 		The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Use this required field to validate that the data being loaded is assigned to the correct employee record. The provided values must match exactly to an existing employee record in Dayforce.
First Name (Required)
Order Data Type Description Examples Why This Is Needed
2 String1 between 1-64 characters. The legal first name of the employee. Joe The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Use this required field to validate that the data being loaded is assigned to the correct employee record. The provided values must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Last Name (Required)
Order Data Type Description Examples Why This Is Needed
3 String1 between 1-64 characters. The legal last name of the employee. Smith The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. Use this required field to validate that the data being loaded is assigned to the correct employee record. The provided values must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Effective Start Date (Required)
Order Data Type Description Examples Why This Is Needed
4 Date. Excel right-justified date format or Excel text format yyyy-mm-dd. The start date for the tax record. Date formatted cells:
09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This date is used to identify when this tax begins.
Effective End Date (Required)
Order Data Type Description Examples Why This Is Needed
5 Date. Excel right-justified date format or Excel text format yyyy-mm-dd. The end date for the tax record. Date formatted cells:
09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This date is used to identify when this tax ends.
Tax Year
Order Data Type Description Examples Why This Is Needed
6 Integer. 4 characters. The year the provided settings apply to. 2021
2022
2023 		This information is required to make sure that RPN values are applied to the appropriate tax year. Defaults to the current tax year unless another value is provided.
RPN Number (Required)
Order Data Type Description Examples Why This Is Needed
7 Alphanumeric. Unique value between 1-20 characters. The unique value provided by Revenue Ireland to identify the employee level tax parameters. A123456789… This information is required to ensure that the most recently provided tax uses are applied to the appropriate employee.
RPN Issue Date (Required)
Order Data Type Description Examples Why This Is Needed
8 Date. Excel right-justified date format or Excel text format yyyy-mm-dd). The date that Revenue Ireland issued the RPN. Date formatted cells:
09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This information is required for audit purposes.
Income Tax Calculation Basis (Required)
Order Data Type Description Examples Why This Is Needed
9 Accepted Values:
Emergency
Cumulative
Week 1		 Used to determine the calculation method for PAYE income tax calculation. Emergency
Cumulative Week 1 		This information is required to determine the tax calculation method. Emergency and Week 1 represent a noncumulative tax basis.
Exclusion Order
Order Data Type Description Examples Why This Is Needed
10 Accepted Values:
YES
NO		 This field indicates whether the employee is exempt from PAYE. YES
NO 		If yes, the employee has an exclusion order in place.
If not, the employee doesn’t.
Yearly Tax Credits (Required)
Order Data Type Description Examples Why This Is Needed
11 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The total annual value of PAYE tax credits allowed for the employee 1200.00 This information is required for the calculation on PAYE (Ireland Income Tax).
Pay for Income Tax to Date (Required)
Order Data Type Description Examples Why This Is Needed
12 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The total annual PAYE taxable income received by the employee at the time of data load 45000.00 This information is required for the calculation on PAYE (Ireland Income Tax). The value must be provided on the file, even if that value is 0.00.
Income Tax Deducted to Date (Required)
Order Data Type Description Examples Why This Is Needed
13 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The total amount of PAYE tax paid by the employee at the time of data load 4500.00 This information is required for the calculation on PAYE (Ireland Income Tax). The value must be provided in the file, even if that value is 0.00.
USC Status (Required)
Order Data Type Description Examples Why This Is Needed
14 Accepted Values:
Ordinary
Exempt. 		Used to determine the tax rate for USC calculations. Ordinary
Exempt		 This information is required for the calculation of USC Tax (Universal Social Charge). Defaults to “Ordinary” unless another value is provided.
Pay for USC to Date (Required)
Order Data Type Description Examples Why This Is Needed
15 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The total USC taxable income received by the employee at the time of data load. 3/15/2023 This information is required for the calculation of USC Tax (Universal Social Charge). The value must be provided in the file, even if that value is 0.00.
USC Deducted to Date (Required)
Order Data Type Description Examples Why This Is Needed
16 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The total USC tax paid by the employee at the time of data load. 3/25/1901 This information is required for the calculation of USC Tax (Universal Social Charge). The vzZalue must be provided in the file, even if that value is 0.00.
LPT to Deduct
Order Data Type Description Examples Why This Is Needed
17 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The flat amount to deduct from employee pay for LPT. 12.00 This information is required for deduction of Local Property Tax.
PRSI Exempt
Order Data Type Description Examples Why This Is Needed
18 Accepted Values:
YES
NO 		This field indicates whether the employee is exempt from PRSI (Pay Related Social Insurance). YES
NO 		Used to mark if the employee is exempt from PRSI tax.
PRSI Class
Order Data Type Description Examples Why This Is Needed
19 Accepted Values:
A, B, C, D, H, J, K, M, S 		Indicates the PRSI Class applicable to the employee A
K 		Indicates the employee's PRSI Class. Not used for tax calculations.
PAYE Tax Rate Percent 1 (Required)
Order Data Type Description Examples Why This Is Needed
20 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The initial income tax rate. 0.1 This information is required to do tax calculations.
PAYE Tax Rate Percent 1 (Required)
Order Data Type Description Examples Why This Is Needed
21 Decimal. Numeric value between 1-12 characters. Decimal precision = 2 The annual income to be taxed at the initial rate. 2500.00 This information is required to perform tax calculations.
PAYE Tax Rate Percent 1 (Required)
Order Data Type Description Examples Why This Is Needed
22 Decimal. Numeric value between 1-12 characters. Decimal precision = 2 The secondary income tax rate. 0.4 This information is required to perform tax calculations.
USC Rate Percent 1 (Required)
Order Data Type Description Examples Why This Is Needed
23 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The initial USC tax rate. 0.15 This information is required to perform tax calculations.
Yearly USC Rate Cutoff 1 (Required)
Order Data Type Description Examples Why This Is Needed
24 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. Maximum annual income to be taxed at the initial rate. 4000.00 This information is required to do tax calculations.
USC Rate Percent 2 (Required)
Order Data Type Description Examples Why This Is Needed
25 Decimal. Numeric value between
1-12 characters. Decimal precision = 2.		 The secondary USC tax rate. 0.25 This information is required to perform tax calculations.
Yearly USC Rate Cutoff 2 (Required)
Order Data Type Description Examples Why This Is Needed
26 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The maximum annual income to be taxed at the secondary rate. 8000.00 This information is required to do tax calculations.
USC Rate Percent 3 (Required)
Order Data Type Description Examples Why This Is Needed
27 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The tertiary USC tax rate. 0.35 This information is required to perform tax calculations.
Yearly USC Rate Cutoff 3 (Required)
Order Data Type Description Examples Why This Is Needed
28 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The maximum annual income to be taxed at the tertiary rate. 15000.00 This information is required to do tax calculations.
USC Rate Percent 4 (Required)
Order Data Type Description Examples Why This Is Needed
29 Decimal. Numeric value between 1-12 characters. Decimal precision = 2. The quarternary USC tax rate. 0.45 This information is required to do the tax calculations.