Use the Third Party Payees wizard to upload third-party payee information for employee groups in Australia and New Zealand. This wizard removes the need for manual data entry, saving time and effort.
Third party payees, or payees, are accounts, or organizations, that receive payments on behalf of employees. Examples of payees include:
- A pension account that employers contribute to for their employees.
- An account that gets payments for benefits that are deducted and paid during the payroll process.
Note: The Third Party Payees wizard currently supports only employee groups in Australia and New Zealand.
You can use this wizard for the following Dayforce native payroll countries:
- Australia
- New Zealand
Prerequisites
Payee categories must be set up before using this wizard.
This wizard doesn’t support the following payee categories:
- Australian Taxation Office
- Self-Managed Superannuation Fund
- Default Superannuation Fund
- Superannuation Scheme
The categories above must exist before you use this wizard. Use the Dayforce Superannuation Form or the Superannuation Data For Australian Employees wizard to add superannuation funds.
Messages: Error, Warning, and Information
Activate sorts each generated message by severity:
Actively incompatible with the data in Dayforce. If you have a data error, you must resolve the error before you can complete the installation.
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.
A notable occurrence of data in the system. For example, an informational note shows if codes are dropped from the YTD import.
Tasks
- In Activate Central, click Build Dayforce. The Build Dayforce wizards show.
- Click Third Party Payees.
- On the What you need to know before you start page, review the information.
- Select the checkbox to confirm that all custom pay categories exist in Dayforce. If the pay categories don’t already exist in Dayforce, click Back.
- Click Next.
-
On the Third Party Data page, click Download.
Note: You can also download the empty templates from the Download Template Files page.
- Select the location where you want to save the template documents.
-
Open the
Third Party Payee Import.xlsx
template on your computer.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.
-
Complete all columns with the data for all employees in the organization.
Note: Instructions on populating the fields are in the Third Party payee Template FieldsThird Party Payee Template Fields section (below) and on the Instructions tab of the template.
Activate runs critical validations.
-
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 in the template. Activate uses the tab name to validate that the correct template is being uploaded. In addition, don’t change the column headings.
- On the Third Party Data page, click Upload.
- Go to the completed Third Party Payee Import template in the location where you saved it.
- Click Open. The Third Party Payees 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.
-
Click Next. The Third Party Payees Review page opens.
- Review the information shown in the grid.
- 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 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. The download file includes only the following information: Employee Number, First Name, Last Name, Effective Start Date, and the respective global properties and values selected.
To upload the file from your computer, locate the file and click Upload File. The data in the file shows in the grid.
- To download a complete list of all errors from the data load process so you can review and correct them, click Download Errors File. The document lists the Severity, Employee Identifier, Column Name, Message, and Value for each item.
To remove changes that you don’t want to save, click Refresh.
- When the data is complete, click Done & Install. The selected values stay in the grid after you leave the page.
When the third-party payee information is complete in Activate, you must install the information in Dayforce.
-
On the Third Party Review page, click Load.
Activate reruns the validation and the Review & Load page opens.
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.
-
Click one of the following:
- Add Email and enter your email address to receive an email when the installation process ends, instead of waiting for it to finish.
- Next w hen the installation is complete.
Activate Central opens with the name of the Wizard now shown in green text and a green checkmark to the left of the wizard’s name. The current day, date, and time of completion are included, 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 installed data is available in Dayforce on the Payroll Setup > Third Party Payees page.
Field in Template | Field in Dayforce | Page in Dayforce |
---|---|---|
Name |
Name |
Payroll Setup > Third Party Payees page, Payees tab, General section |
Description |
Description |
|
Operating Country |
Operating Country |
|
Payee Category |
Payee Category |
|
Current |
Active |
|
Assign To |
Assign To |
|
Reference Code |
Reference Code |
|
Address 1 |
Address |
Payroll Setup > Third Party Payees page, Payees tab, Address section |
Address 2 |
Address |
|
Address 3 |
Address |
|
State/Province |
State/Province |
|
City |
City |
|
Zip/Postal Code |
Zip/Postal Code |
|
Country |
Country |
|
Payment Method |
Method |
Payroll Setup > Third Party Payees page, Payees tab, Payment Method section |
Account Number |
Account Number | |
BSB Code |
Transit Number | |
Lodgement Reference Number |
Reference Code |
Payroll Setup > Third Party Payees page, Payees tab, Parameters section |
Payment Frequency |
Parameters | |
Start Date |
Parameters | |
Pay Date |
Parameters | |
Combine Employees |
Combine Employees |
Payroll Setup > Third Party Payees page, Payees tab, Payment section |
Combine Earnings and Deductions |
Combine Earnings and Deductions |
Payroll Setup > Third Party Payees page, Payees tab, Payment section |
Show Employee Details |
Show Employee Details |
Payroll Setup > Third Party Payees page, Payees tab, Payment section |
Next steps
Complete the next wizard, because appropriate.
Third Party Payee template 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.
Order | Data enter | Description | Examples | Why This Is Needed |
---|---|---|---|---|
1 | String1 between 1-128 characters. | The name of the third-party payee. | Services AU - Child Support IRD NZ - Child Support | Used in Payee selection list on earnings, deductions, and payroll elections screens. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
2 | String1 between 1-128 characters. | A short description of the third-party payee. | Services Australia - Child Support IRD NZ - Child Support | Provides additional information about the payee for reference. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
3 |
ISO Country Code. Accepted values2 |
The operating country of the third-party payee. |
AUS
|
Controls which other payee configuration settings are applicable, such as: 1. Payee Category field selection options 2. Payment Method field selection options and their associated parameters. |
Accepted Values | Country Name |
---|---|
AUS | Australia |
NZL | New Zealand |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
4 |
System Accepted Values: Australia:
New Zealand:
|
The reference code of a system or custom payee category to configure the type of third-party payment. The payee category must exist in Dayforce. | Child Support Payment | Select the category that the payee should be classified as. This category is used to narrow the selection list when configuring an earning, a deduction, or managing an employee payroll election. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
5
|
Accepted Values:
|
Identifies if the payee can be used with earnings, deductions or both.
|
ED | Select if the payee can be used with earnings and/or deductions. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
6
|
String1 between 1-128 characters. | A unique identifier for the third-party payee. |
AU_SERVAUS_CHILD_SUPPORT NZ_IRD_CHILD_SUPPORT |
Reference codes, also known as cross-reference codes, are used by Dayforce HCM, usually in exports and imports, to integrate into other applications and systems used by your organization. Reference codes can also help you identify the different elements in the system in the scripts and processes that export your organization's data from Dayforce HCM. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
7 | String1 between 1-128 characters. | Address line one for the third party payee. | 1 Brisbane Road | Used on payment output. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
8 | String1 between 1-128 characters. | Address line two for the third-party payee. | Used on payment output. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
9 | String1 between 1-128 characters. | Address line three for the third-party payee. | Used on payment output. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
10 |
State/Province code. Accepted Values 3 |
The third-party payee’s state or province. | AU-QLD
NZ-AUK |
Used on payment output. |
Accepted Values | State Name |
---|---|
AU-ACT | Australian Capital Territory |
AU-NSW | New South Wales |
AU-NT | Northern Territory |
AU-QLD | Queensland |
AU-SA | South Australia |
AU-TAS | Tasmania |
AU-VIC | Victoria |
AU-WA | Western Australia |
NZ-AUK | Auckland |
NZ-BOP | Bay of Plenty |
NZ-CAN | Canterbury |
NZ-CIT | Chatham Islands Territory |
NZ-GIS | Gisborne |
NZ-HKB | Hawke's Bay |
NZ-MBH | Marlborough |
NZ-MWT | Manawatu-Wanganui |
NZ-NSN | Nelson |
NZ-NTL | Northland |
NZ-OTA | Otago |
NZ-STL | Southland |
NZ-TAS | Tasman |
NZ-TKI | Taranaki |
NZ-WGN | Wellington |
NZ-WKO | Waikato |
NZ-WTC | West Coast |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
11 | String1 between 1-128 characters. | The third-party payee’s city. | Brisbane | Used on payment output. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
12 | Numeric. 4 digits. | The third-party payee’s zip or postal code. | 1 2 3 4 |
Used on payment output. |
Order | Data Type | Description |
Examples |
Why This Is Needed |
---|---|---|---|---|
13 |
ISO Country Code. 3 characters. Accepted values.2 |
The third-party payee’s country code. | AUS
NZL |
This information helps to map the payout category with countries. Different countries have different payout options and regulations. |
Accepted Values | Country Name |
---|---|
AUS | Australia |
NZL | New Zealand |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
14 |
Accepted Values:
New Zealand:
|
The payment method through which the third party payment is made. | Electronic Fund Transfer (EFT)
Direct Debit |
Select the payment method applicable to the payee. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
15 |
Numeric value. 1-12 digits for Australia. 7-10 digits for New Zealand. |
Account Number for the third party payment to be made to. Account Number is required when the Payment Method is Electronic Fund Transfer (EFT) or Direct Debit. |
987456320 | Account holder number for payee. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
16 | Numeric 6 digits |
BSB Code for the third party payment to be made to. BSB Code is required when the Payment Method is Electronic Fund Transfer (EFT) or Direct Debit. |
015305
010030 |
Enter the six-digit BSB Code used to route payments to the payee's financial institution correctly. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
17 | String1 between 1-18 characters. | The payment reference number for the third party payee. | 87654321 | This field might include Invoice Number, Unique Customer Identifier or PRN (Payment Reference Number). Any reference entered in this field shows in the Bank file. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
18 |
Accepted Values:
|
Defines the payment frequency for the third party payments to be made. Payment Frequency is required when the Payment Method is Electronic Fund Transfer (EFT) or Direct Debit. |
Monthly | This information tells about the frequency of payout to the payee. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
19 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. |
Defines the start date of any defined third party payments A Start Date is required when the Payment Method is Electronic Fund Transfer (EFT) or Direct Debit. |
Date formatted cells: Text formatted cells: |
This information is needed when the payment starts in the future. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
20 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. |
Defines the pay date of any defined third party payments in reference to the start date. The Pay Date can’t be earlier than the Start Date. A Pay Date is required when the Payment Method is Electronic Fund Transfer (EFT) or Direct Debit. |
Date formatted cells:
Text formatted cells: |
The date when you want the payment to be deducted. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
21 | String1 between 1-64 characters | Defines the short message that shows on checks issued to the payee. | Purpose of the check. | Details for what purpose the check is generated. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
22 | String1 between 1-64 characters. | The name that shows on checks issued to the payee if different from the payee name. | Payee Name | Required where the name to be shown on the check is different from the payee name. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
23 | Boolean
yes/no true/false |
Enable this option to combine all employees who contributed to the total into a single payment to the payee. | FALSE | Select this option to combine all employees who contributed to the total into a single payment to the payee. This setting controls whether employee amounts that are associated with this payee are submitted as single or separate payments. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
24 | Boolean
yes/no true/false |
Enable this option to combine all eligible earnings and deductions into a single payment to the payee. | FALSE | Select this option to combine all eligible earnings and deductions into a single payment to the payee. This setting controls if both earnings and deductions associated with this payee are submitted as single or separate payments. |
Order | Data Type | Description | Examples | Why This Is Needed |
---|---|---|---|---|
18 | Boolean
yes/no true/false |
Enable this option to list each employee who contributed to the total. | TRUE | Select this option to list each employee who contributed to the total. |