To prepare for Go Live in Dayforce, some customers required the import of employee Year-to-Date data for the many payroll codes. Use the Year-to-Date Payroll Totals (AUS/NZL) wizard to make sure that your employees’ deductions, earnings, and taxes totals are loaded in Dayforce correctly
Completing this task ensures that the mapping is correct from legacy systems to Dayforce and that the data is correct. At Go Live, data is successfully imported in anticipation of Year-End data being filed correctly for taxation and government purposes.
Before you begin
Note the following:
- Activate generates the Year-to-Date Import file with the ContributeToNetPay field populated based on the earning code that’s specific to the employees' respective pay group country. Shared earning definitions are differing earning types between earning codes of countries. When shared earning definitions exist between AUS and NZL in Dayforce, Activate uses the correct tax and compliance code to determine the ContributeToNetPay value.
- You can use any of the following wizards even if any of them are currently in use by other users: Payroll Deduction Codes, Payroll Earning Codes, Year-to-Date Payroll Totals (AUS/NZL).
- Activate shares all of your mappings across all applicable environments so you don't have to reconfigure each time you use a different environment. If the changes you make in an environment invalidate the mappings in a different environment, Activate notifies you when you use a wizard with invalid mappings that must be updated.
- If the Allow Future Dated Import setting is enabled in Dayforce (Pay Group > Payroll Properties), you can import Year-to-Date data into an ongoing or future pay period in Activate. This step gives you more time to prepare the Go Live data loads (for example, complete mappings). Also, you don’t have to wait until the period ends to start the Year-to-Date process.
Prerequisites
A native payroll pay group for Australia and/or New Zealand with pay calendars must exist.
Key concepts
Amounts that are subtracted from employees' gross pay during the calculation of net pay in Dayforce. Deductions can be pre-tax or post-tax. The four types include:
- Deductions that allow partial payments: Dayforce only deducts what an employee can pay if the employee doesn’t have enough pay to cover the entire deduction.
- Deductions that can go into arrears: Dayforce calculates whether the employee has enough pay to cover the entire deduction and carries forward any unpaid amount, attempting to deduct the amount in the next pay period.
- Declining balance deductions: Dayforce calculates the deduction against an outstanding balance that the employee owes.
- Payee deductions: Deductions that are paid to a third-party payee
Amounts that are added to create an employees' gross pay during the calculation of gross pay. In Dayforce, each earning code falls into one of the following categories or earning types:
- Normal: Represents earnings that are paid as income and taxed.
- Reimbursement: Represent expenses (such as hotel or gas costs) that employees have paid and the employer is paying back.
- Taxable Benefit: Can refer to benefits of employment other than cash compensation. Examples include low- and interest-free loans, gifts, and holiday trips and prizes. The values of these benefits are taxed as part of the employment income.
- Memo Calc: Payments or earnings that employees receive but aren’t paid as income. An employer putting money into an RRSP or pension plan is an example of a memo calc earning. For memo calc earnings, the employees aren’t receiving the money as income today (as a check or directly deposited to their bank account), but they’re earning some amount. Memo calc earning codes aren’t taxed.
Also known as Deduction Definitions, Payroll Deduction codes define the amounts deducted from an employee’s gross pay. These amounts can be pre-tax or post-tax. Examples include insurance plans, gym memberships, and pension plans. Each deduction code is mapped to a specific taxation method or Tax & Compliance code.
Using this wizard
You do the following in the Year-to-Date Payroll Totals (AUS/NZL) wizard:
With the Payroll YTD Data templates, you can upload the key information for importing Earning, Deduction, and Tax YTD amounts. This data loads the information equivalent of a full Pay Run into Activate.
Note: Complete this step using present-day employee information.
The wizard creates a summary of the unique codes from the template, and calculates the Total Amount of each Payroll code based on the legacy data. On this page, you can download reports that show the Total Amount for each code for the entire organization. You need to validate that the codes are in balance for the wizard to move to its next steps.
When the balance of each code has been verified against the data import files, the next step is to map the legacy codes to codes in the Dayforce environment.
Before you install the Year-to-Date Payroll Totals with Activate, the wizard validates the data being imported against the Dayforce environment. When the validation is complete, Activate shows all messages that cause, or could potentially cause, issues with the import. Review these messages and download an error log, if wanted. You can have Activate revalidate from this page or, if necessary, upload new templates.
If you click Upload New File(s), the wizard takes you back to the beginning so you can upload the data templates again. You’re required to go through each step of the wizard again.
When the payroll information is complete in Activate, you must install it in Dayforce.
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 and the Build Dayforce wizards show.
- Click Year-to-Date Payroll Totals (AUS/NZL).
- On the YTD Data page, click Download all templates, or DOWNLOAD for each of the individual templates.
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
EarningYTDTemplate.xlsx,DeductionYTDTemplate.xlsx, andTaxYTDTemplate_AUS_NZL.xlsxtemplate documents, as appropriate. - On the relevant data tabs, complete all columns with the data for all employees in the organization.
Note: Instructions for populating the fields are in the , YTD Data template fields, Deduction YTD Data template fields, and Tax YTD Data AUS NZL template fields sections (below) and on the Instructions tab of the templates.
Note: If you upload a Tax YTD file that contains a record with the Tax Level as “Australia Federal“ and the Employer Tax column value Y (or Yes, 1, true, and so on), Activate shows an error message stating that Tax code [0] is listed as an employer tax for Australia. This isn’t supported in Dayforce.
Note: If you upload a Tax YTD record with any AUS state as the Work Location and the Tax Level isn’t “Australia Federal,“ the file fails to upload. Activate then generates an error stating that Tax Level {0} isn’t allowed for Tax: {tax name} when the Work Location is Australia. If you upload a Tax YTD record with any NZL state as the Work Location and the Tax Level isn’t “New Zealand,“ the file will fail to upload and Activate will generate the following error: “Tax Level: {value} is not allowed for Tax: {tax name} when Work Location is in New Zealand.“
- 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 YTD Data page, click Upload files.
- Go to the completed YTD templates in the location where you saved them.
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.
- Click Open. The YTD wizard validates the uploaded files.
Important: If you upload YTD files on the Pay Period End date for a pay group, you must enable the Allow Future Dated field.
Note: You must upload valid files for all sections (Earnings and Deductions, and Taxes, if applicable) to continue.
Note: If the file you uploaded has any 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. A prompt open stating that the uploaded files will generate new payroll mappings, all new items must be mapped, and shows the number of new earnings, deductions, and taxes, as applicable.
-
Click one of the following:
- No to return to the Load page.
- Yes to continue.
You can click Download to download the Candidate Information document. This document contains the Type, Payroll Identifier, Code, Description, State/Province, Country, Tax Level, and Is Employer Tax information. Save the document to your computer for future reference.
- On the Balance page, click the Download the YTD Balance Totals for Deductions link.
- Select the location where you want to save the template documents.
-
Open the
DeductionBalance.xlsxdocument in the location where you saved it on your computer. -
Review and verify that the information in the document is correct.
Each line shows the total amount from the upload file, grouped by country, payroll identifier, code, and description. For earnings, it also shows the total hours.
Note: If any information is wrong, click Back, make the corrections in the appropriate templates, and upload them again.
- Repeat these steps for the Download the YTD Balance Totals for Earnings and the Download the YTD Balance Totals for Taxes links.
- After you verify that all data is correct, select the checkbox on the page to confirm that each row is in balance.
Note: You must click the checkbox to confirm that the validation is in balance to continue.
- Click Next.
Note: The tasks for the earnings and deductions pages are the same.
- On the YTD Deductions Mapping page, review the information and make sure that each deduction code is mapped to the appropriate Dayforce code.
Deductions codes with the same “code, description, and country“ are grouped into a single-line item on the page. This also applies to Earnings codes.
Note the following:
- New codes: If a code is new to this Activate project, its mapping status is New Unmapped Code Found. Select a code from the drop-down list to complete the mapping.
- Available codes are restricted based on their Country from legacy and the taxability of the Dayforce code.
- If a Dayforce code doesn’t show, the Implementation Consultant might need to create the code in the corresponding Dayforce environment. If this case, when the code has been created in Dayforce, refresh the page so the wizard can pull the new information from the environment when loading this page.
- Previous codes: If a code has been used in this Activate project before, it shows as Previous Mapping Found, and defaults to however you previously used this legacy code. For these codes, validate the information, and if any updates need to be made, select a new code from the drop-down list.
- YTD Deduction Mapping: You can remove codes that are no longer in use from the import. If a code was uploaded as a deduction, you can also mark it as an earning and you’ll have to map it on the Earnings Mapping page.
- YTD Earning Mapping: You can remove codes that are no longer in use from the import. If a deduction code has been uploaded as an earning, it shows here and you must map it.
Note: To filter the codes shown, select All Codes, Mapped Codes, and Unmapped Codes.
Note: To search for a code on the page, enter text in the Search field. To clear text in the Search field and clear the filter, click the Close button (
). - New codes: If a code is new to this Activate project, its mapping status is New Unmapped Code Found. Select a code from the drop-down list to complete the mapping.
- For any incorrectly aligned deductions, earnings, or taxes, select the drop-down list in the HCM Deduction, HCM Earning, or HCM Tax column for that deduction/earning. Then, select the correct deduction/earning/tax code.
Note: If you select an incorrect deduction/earning/tax, the Error icon (
) shows next to the selected deduction/earning/tax. Select a correct deduction/earning/tax to proceed. Note: If you select “Drop Earning from import,“ Activate ignores the earning and doesn’t include it in the election file. However, the previous mapping is retained unchanged and is available for use in elections. This also applies to dropped deductions and taxes. A warning prompts you to correct your data, if required, to prevent the risk of job errors in Dayforce. Activate shares the YTD payroll mappings across all environments (Config, Stage, and Train) so you don't have to reconfigure every time you use a different environment.
Note: In the HCM Deduction column, you can click Map as an Earning to map a deduction code to an earning on the following Earning mapping page. Activate creates an earning candidate (if none exists) and you can map the code to an earning on the following page. If you previously mapped a deduction as an earning in the Payroll Deduction Codes wizard or in a previous run of the Year-to-Date Payroll Totals AUS/NZL wizard, Activate respects that and shows the mappings accordingly when you load a Deduction Year-to-Date file with that code. Deductions that were previously mapped as an Earning in the Payroll Deduction Codes wizard or a previous run of the Year-to-Date Payroll wizard don’t show on the Deduction mapping page. The codes are shown on the Earning mapping page with the selected HCM earning. When a deduction is mapped as an earning, if it’s mapped to a Memo earning type, the converted amount is equal to the original amount in the Deduction Year-to-Date file. If it’s NOT mapped to a Memo earning type, the converted amount is equal to the original amount in the Deduction Year-to-Date file multiplied by -1. (The negative deduction is converted to positive earning.)
Note: Deductions that are mapped to earnings show with the “Map as Earning“ option selected. If you select a deduction code instead of “Map as Earning,“ the rows in the deduction file transform to the corresponding deduction code in the XML and not to an earning. If you select “Drop Deduction from Import“ instead of “Map as Earning,“ the rows in the deduction file are dropped from the XML but aren’t transformed to a deduction or an earning. If you revert the deduction mapping but load the same code in the Earning file, it’s handled the same as the previously existing earning mapping.
If mapped to a Memo earning type, the converted amount is equal to the original amount in the Deduction YTD file.
If not mapped to a Memo earning type, the converted amount is equal to the original amount in the Deduction YTD file multiplied by -1. (The negative deduction is converted to positive earning.)
- Click Next.
- Repeat this process for the earnings and tax codes.
- When all codes are mapped, click Done.
Note: Errors and warnings show in the right-hand column of the table. Hover over the icon to see more details. If any errors exist, you can’t continue. If warnings or information only messages exist, you can continue.
Before Year-to-Dates are loaded into the system, there is one more validation check using the employee YTD and the company YTD totals.
- On the Final Review page, review the following:Employee Summary Information
Gives a preview of the employees who have amounts in this YTD load.
- Separates the Pay Groups that have employees, including the Pay Period and Pay Date.
- The next two columns show the total active/inactive employee records with gross pay and the total terminated employee records with gross pay.
- The last two columns show the total active/inactive employee records with NO gross pay and total terminated employee records with NO gross pay.
Click Employee Summary to download a report containing the pay period detail, status, employee identifier, name, and gross pay total. You can use this report to double check the data and verify the employee information. The Gross Pay total = Normal + Reimbursement + Salary Sacrifice earning type.
Company Totals Summary InformationGives a preview of the company amounts that are being loaded in this YTD load. It gives the company information by Payroll Identifier and summarizes the amounts by code categories. Review and validate the following spreadsheets in this category. The Employer Taxes column shows the total amount of employer taxes for Australia and New Zealand.
Click Company Totals Summary to download a report containing the information in the Company Totals Summary table.
to download a report containing a breakdown of the categories used in the Company Totals Summary, but on an employee by employee level, click Employee Totals Summary Report. The amounts stated here are employee-specific. Unlike the Employee Summary Table, this spreadsheet shows only the employees with an amount that’s being loaded in by Activate.
Note: Deductions mapped as earnings are reflected in the appropriate earnings column, and don't count toward deduction totals. Dropped deductions and earnings don't count towards the company/employee totals at all.
-
If any changes are needed, click Back to return to the appropriate pages to make the necessary changes.
Important: You can’t use Activate to uninstall them when the Payroll Year to Date Totals are installed.
- When you’ve reviewed all tables and validate the data, click Next.
The Year-to-Date Payroll Totals wizard begins validating against the Dayforce environment to make sure that there aren’t any errors. When this validation is complete.
-
On the Validate page, review any Error, Warning, and Info messages resulting from validation.
The Count column shows the total of each message type. If any errors exist, you must resolve them to continue.
Note: Activate shows a warning if a NZL employee doesn’t have an IRD number in Dayforce as of the pay period end date. You must load a Personal Data file or enter it in Dayforce (Profile > Personal > Confidential Info > Identification).
- If any error messages are shown, do the following as appropriate:
- Click Back to go to the appropriate pages and make the corrections.
- Click Download to download a detailed Employee Totals report of the record-specific error messages by employee. The report contains three tabs: Errors, Warnings, and Info.
- Correct the template documents on your computer and click Upload New File(s) to upload them into Activate.
Important: If the Dayforce environment has any errors, you must resolve them in Dayforce.
- After correcting the errors, click Re-Validate.
- Repeat these steps until no error messages are shown.
- When there are no error messages, click Done & Install to import the data into Dayforce.
Important: If someone is signed directly in to Dayforce and potentially applying manual configuration, Activate shows a warning at Done & Install. Don’t continue with the Activate installation if users are actively applying configuration changes. Users’ changes might be lost if a failure occurs during the Activate installation. Download the User Report and follow up with the team members before you continue with the Activate wizard.
- On the Validate page, click Done & Install.
Activate reruns the validation.
Important: A dialog box states that at completion of this load, access to the Org Hierarchy solution will be limited to Dayforce users. If you have outstanding validation messages, by continuing, you confirm that you have reviewed all remaining validation results and commit to making the necessary updates to the applicable configuration and/or data in Dayforce to make sure that they are correct as soon as possible. You acknowledge that failure to do so could result in pay or year-end filing errors.
Important: If you have any outstanding validation messages, a prompt opens stating that if you continue, you confirm that you have reviewed all remaining validation results and commit to making the necessary updates to the applicable config and/or data in Dayforce to make sure that they’re correct as soon as possible. Your failure to do so could result in pay or year-end filing errors. Click No to return to the Validate page and make the corrections or click Yes to continue with the installation.
If any new validations are detected, you return to the Validate page and the new validations are shown for you to review.
Important: If someone is signed directly in to Dayforce and potentially applying manual configuration, Activate shows a warning at Done & Install. Don’t continue with the Activate installation if users are actively applying configuration changes. Users’ changes might be lost if a failure occurs during the Activate installation. Download the User Report and follow up with the team members before you continue with the Activate wizard.
- You can click Download to download and save the Deduction Generation History Excel document to your computer. This Excel spreadsheet lists all of the information to be downloaded by Activate. It also notes if any codes have been moved from the Payroll Deduction Codes wizard to the Payroll Earning Codes wizard for further Activate configuration.
- Click one of the following:
- No to cancel the installation and return to the Validate page.
- Yes to acknowledge the disclaimer and continue with the installation. The Loading YTD Data page opens.
During the installation, the current step in the process shows in bold text 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
Dayforce now contains the YTD Data that was imported during installation. Whichever pay period was used in the legacy system is now considered Committed data, and locks down the Taxation as well as calculation parameters on each earning and deduction code that was used in this pay period, setting these parts of the Payroll codes into unmodifiable states.
Activate generates the XML file, including the Total Taxable Wages field in the Pay Run Tax section. This value is equal to the existing Total Taxable Wages column of the TaxYTD template file.
Note: When installation completes, the Mapping Files, which are used as a basis for any future YTD load, can be downloaded by going to the User Menu (Person Icon), selecting Troubleshooting Resources, and then selecting the appropriate mapping under Customer Mapping Templates to download the file as an Excel spreadsheet.
The data uploaded from the Earning YTD template populates the fields on the following pages in Dayforce.
| Field in Template | Field in Dayforce | Page in Dayforce |
|---|---|---|
| Payroll Identifier | — |
— |
| Pay Period End Date | — |
— |
| Employee Identifier | Employee Reference/Number |
When the data is loaded for Parallel and Go Live, this information shows on the Payroll, Pay Run Management tab.
|
| First Name | First Name | |
| Last Name | Last Name | |
| Company ID | Business Number | |
| Earning Code | — | |
| Earning Description | — | |
| Amount | Amount | |
| Hours | — | |
| Work Location | Work State | |
|
Canada Workers Comp Code (Canada only) |
Workers Comp Code | |
|
Canada Workers Comp Acct Number (Canada only) |
Workers Comp Account | |
|
Canada Previous RP Number (Canada only) |
— | — |
|
Canada Previous EI Rate (Canada only) |
— | — |
The data uploaded from the Deduction YTD template populates the fields on the following pages in Dayforce.
| Field in Template | Field in Dayforce | Page in Dayforce |
|---|---|---|
| Payroll Identifier | — | — |
| Pay Period End Date | — | — |
| Employee Identifier | Employee Reference / Number |
When data is loaded for Parallel and Go Live, this information ends up on the Payroll, Pay Run Management tab.
|
| First Name | First Name | |
| Last Name | Last Name | |
| Company ID | Business Number | |
| Deduction Code | Name | |
| Deduction Description | Description | |
| Amount | Amount | |
| Work Location | Work State | |
|
Canada Workers Comp Code (Canada only) |
Workers Comp Code | |
|
Canada Workers Comp Acct Number (Canada only) |
Workers Comp Account | |
|
Canada Previous RP Number (Canada only) |
— |
The data uploaded from the Tax YTD template for Parallel and Go Live populates the fields on the Pay Run Management page in Dayforce (Payroll, Pay Run Management tab).
| Field in Template | Field in Dayforce |
|---|---|
| Payroll Identifier | — |
| Pay Period End Date | — |
| Employee Identifier | Employee Reference / Number |
| First Name | First Name |
| Last Name | Last Name |
| Company ID | Legal Entity |
| Tax Code | Code |
| Tax Description | — |
| Tax Level | — |
| Work Location | Work Location |
| Employer Tax | — |
| Tax Amount | |
| Total Taxable Wages |
After completing the Year-to-Date Payroll Totals AUS/NZL wizard, Activate automatically generates a single import file and places on the customer's FTP site.
HR Import:
- FTP Subdirectory: Import/PayRunHistoryImport
- Filename: <Namespace> PayRunHistoryImport <DateTime>.xml
<?xml version="1.0" encoding="UTF-8"?>
-<PayRunHistoryImport>
-<PayRunHistoryImportSetting>
<AutoCreateEarningDefinition>false</AutoCreateEarningDefinition>
<AutoCreateDeductionDefinition>false</AutoCreateDeductionDefinition>
<AutoCreateTaxDefinition>true</AutoCreateTaxDefinition>
<AutoCreatePayeeDefinition>false</AutoCreatePayeeDefinition>
<AutoCreateLegalEntityDefinition>false</AutoCreateLegalEntityDefinition>
</PayRunHistoryImportSetting>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-02-12</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>17</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-01-25</PayPeriodStart>
<PayPeriodEnd>2021-02-08</PayPeriodEnd>
<PayrollCommittedDate>2021-02-12</PayrollCommittedDate>
-<PayRunResult>
<!--970001: Smith, Jim - Company ID:12345678901-->
<EmployeeXrefCode>970001</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-TAS</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>30456.76000</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>30456.76000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970001</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:30456.76000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>30456.76000</Amount>
<Units>1543.00000</Units>
<Rate>19.73866</Rate>
<StateCode>AU-TAS</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-ACT</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>2569.40000</EmployeeEarningAmount>
<EmployeeDeductionAmount>100.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>2469.40000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:2569.40000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>2569.40000</Amount>
<Units>200.00000</Units>
<Rate>12.84700</Rate>
<StateCode>AU-ACT</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:100.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-NSW</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>100.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>0</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:100.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
</PayRun>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-01-01</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>14</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-12-14</PayPeriodStart>
<PayPeriodEnd>2020-12-28</PayPeriodEnd>
<PayrollCommittedDate>2021-01-01</PayrollCommittedDate>
-<PayRunResult>
<!--970008: Morningstar, Lucifer - Company ID:12345678901-->
<EmployeeXrefCode>970008</EmployeeXrefCode>
<PayDate>2021-01-01</PayDate>
<EmployeeWorkStateCode>AU-VIC</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>666.00000</EmployeeEarningAmount>
<EmployeeDeductionAmount>50.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>616.00000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-01-01</CheckDate>
<EmployeeNumber>970008</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:666.00000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>666.00000</Amount>
<Units>0</Units>
<Rate>0</Rate>
<StateCode>AU-VIC</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:50.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>50.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
</PayRun>
</PayRunHistoryImport><?xml version="1.0" encoding="UTF-8"?>
-<PayRunHistoryImport>
-<PayRunHistoryImportSetting>
<AutoCreateEarningDefinition>false</AutoCreateEarningDefinition>
<AutoCreateDeductionDefinition>false</AutoCreateDeductionDefinition>
<AutoCreateTaxDefinition>true</AutoCreateTaxDefinition>
<AutoCreatePayeeDefinition>false</AutoCreatePayeeDefinition>
<AutoCreateLegalEntityDefinition>false</AutoCreateLegalEntityDefinition>
</PayRunHistoryImportSetting>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-02-12</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>17</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-01-25</PayPeriodStart>
<PayPeriodEnd>2021-02-08</PayPeriodEnd>
<PayrollCommittedDate>2021-02-12</PayrollCommittedDate>
-<PayRunResult>
<!--970001: Smith, Jim - Company ID:12345678901-->
<EmployeeXrefCode>970001</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-TAS</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>0</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970001</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-ACT</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>100.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>-100.00000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:100.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-NSW</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>100.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>0</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:100.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
</PayRun>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-01-01</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>14</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-12-14</PayPeriodStart>
<PayPeriodEnd>2020-12-28</PayPeriodEnd>
<PayrollCommittedDate>2021-01-01</PayrollCommittedDate>
-<PayRunResult>
<!--970008: Morningstar, Lucifer - Company ID:12345678901-->
<EmployeeXrefCode>970008</EmployeeXrefCode>
<PayDate>2021-01-01</PayDate>
<EmployeeWorkStateCode>AU-VIC</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>50.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>-50.00000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-01-01</CheckDate>
<EmployeeNumber>970008</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:50.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>50.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
</PayRun>
</PayRunHistoryImport><?xml version="1.0" encoding="UTF-8"?>
-<PayRunHistoryImport>
-<PayRunHistoryImportSetting>
<AutoCreateEarningDefinition>false</AutoCreateEarningDefinition>
<AutoCreateDeductionDefinition>false</AutoCreateDeductionDefinition>
<AutoCreateTaxDefinition>true</AutoCreateTaxDefinition>
<AutoCreatePayeeDefinition>false</AutoCreatePayeeDefinition>
<AutoCreateLegalEntityDefinition>false</AutoCreateLegalEntityDefinition>
</PayRunHistoryImportSetting>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-02-12</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>17</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-01-25</PayPeriodStart>
<PayPeriodEnd>2021-02-08</PayPeriodEnd>
<PayrollCommittedDate>2021-02-12</PayrollCommittedDate>
-<PayRunResult>
<!--970001: Smith, Jim - Company ID:12345678901-->
<EmployeeXrefCode>970001</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-TAS</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>30456.76000</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>3065.00000</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>27391.76000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970001</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:30456.76000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>30456.76000</Amount>
<Units>1543.00000</Units>
<Rate>19.73866</Rate>
<StateCode>AU-TAS</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunTax>
<!--PAYG/Pay As You Go, Amount:3065.00000, TTW:30456.76000-->
<TaxAuthorityInstanceXrefCode>AUS-10360000-03</TaxAuthorityInstanceXrefCode>
<Amount>3065.00000</Amount>
<CurrentWageBasis>30456.76000</CurrentWageBasis>
<GrossWages>30456.76000</GrossWages>
<TotalTaxableWages>30456.76000</TotalTaxableWages>
</PayRunTax>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-ACT</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>2569.40000</EmployeeEarningAmount>
<EmployeeDeductionAmount>100.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>306.00000</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>2163.40000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:2569.40000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>2569.40000</Amount>
<Units>200.00000</Units>
<Rate>12.84700</Rate>
<StateCode>AU-ACT</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:100.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunTax>
<!--PAYG/Pay As You Go, Amount:250.00000, TTW:2569.40000-->
<TaxAuthorityInstanceXrefCode>AUS-10360000-03</TaxAuthorityInstanceXrefCode>
<Amount>250.00000</Amount>
<CurrentWageBasis>2569.40000</CurrentWageBasis>
<GrossWages>2569.40000</GrossWages>
<TotalTaxableWages>2569.4000</TotalTaxableWages>
</PayRunTax>
-<PayRunTax>
<!--STSL/STSL, Amount:56.00000, TTW:2569.40000-->
<TaxAuthorityInstanceXrefCode>AUS-10360000-05</TaxAuthorityInstanceXrefCode>
<Amount>56.00000</Amount>
<CurrentWageBasis>2569.40000</CurrentWageBasis>
<GrossWages>2569.40000</GrossWages>
<TotalTaxableWages>2569.4000</TotalTaxableWages>
</PayRunTax>
</PayRunResult>
-<PayRunResult>
<!--970002: Fae, Tina - Company ID:12345678901-->
<EmployeeXrefCode>970002</EmployeeXrefCode>
<PayDate>2021-02-12</PayDate>
<EmployeeWorkStateCode>AU-NSW</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>0</EmployeeEarningAmount>
<EmployeeDeductionAmount>0</EmployeeDeductionAmount>
<EmployerDeductionAmount>100.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>0</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>0</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-02-12</CheckDate>
<EmployeeNumber>970002</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:100.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>100.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
</PayRunResult>
</PayRun>
-<PayRun>
<NoOverride>false</NoOverride>
<IsOffCycle>false</IsOffCycle>
<PayDate>2021-01-01</PayDate>
<PayGroupXrefCode>AUSTRALIA_BI_WEEKLY_2016_08_01</PayGroupXrefCode>
<PayPeriod>14</PayPeriod>
<PayPeriodSuffix>00</PayPeriodSuffix>
<PayPeriodStart>2021-12-14</PayPeriodStart>
<PayPeriodEnd>2020-12-28</PayPeriodEnd>
<PayrollCommittedDate>2021-01-01</PayrollCommittedDate>
-<PayRunResult>
<!--970008: Morningstar, Lucifer - Company ID:12345678901-->
<EmployeeXrefCode>970008</EmployeeXrefCode>
<PayDate>2021-01-01</PayDate>
<EmployeeWorkStateCode>AU-VIC</EmployeeWorkStateCode>
<LegalEntityXrefCode>AUS_CORP</LegalEntityXrefCode>
<PRPayRunDefXrefCode>NORMAL</PRPayRunDefXrefCode>
<EmployeeEarningAmount>666.00000</EmployeeEarningAmount>
<EmployeeDeductionAmount>50.00000</EmployeeDeductionAmount>
<EmployerDeductionAmount>280.00000</EmployerDeductionAmount>
<EmployeeTaxationAmount>42.00000</EmployeeTaxationAmount>
<EmployerTaxationAmount>0</EmployerTaxationAmount>
<NetPayAmount>574.00000</NetPayAmount>
<PRPayRunCheckTypeXrefCode>Normal</PRPayRunCheckTypeXrefCode>
<CheckDate>2021-01-01</CheckDate>
<EmployeeNumber>970008</EmployeeNumber>
<IncludeOnYearEnd>true</IncludeOnYearEnd>
-<PayRunEarning>
<!--SAL/Normal Pay, Amount:666.00000-->
<PREarningXrefCode>AUS_NORMAL</PREarningXrefCode>
<Amount>666.00000</Amount>
<Units>0</Units>
<Rate>0</Rate>
<StateCode>AU-VIC</StateCode>
<IsWCBAssessable>false</IsWCBAssessable>
<ContributeToNetPay>true</ContributeToNetPay>
</PayRunEarning>
-<PayRunDeduction>
<!--SUPER ER/Superannuation Employer, Amount:280.00000-->
<PRDeductionXrefCode>SUPERANNUATION-EMPLOYER-AUS</PRDeductionXrefCode>
<Amount>280.00000</Amount>
<IsPreTax>false</IsPreTax>
<IsEmployerDeduction>true</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunDeduction>
<!--SUPER EE/Employee Salary Sacrifice - Superannuation, Amount:50.00000-->
<PRDeductionXrefCode>EMPLOYEE-SALARY-SACRIFICE-SUPERANNUATION-AUS</PRDeductionXrefCode>
<Amount>50.00000</Amount>
<IsPreTax>true</IsPreTax>
<IsEmployerDeduction>false</IsEmployerDeduction>
</PayRunDeduction>
-<PayRunTax>
<!--PAYG/Pay As You Go, Amount:42.00000, TTW:666.00000-->
<TaxAuthorityInstanceXrefCode>AUS-10360000-03</TaxAuthorityInstanceXrefCode>
<Amount>42.00000</Amount>
<CurrentWageBasis>666.00000</CurrentWageBasis>
<GrossWages>666.00000</GrossWages>
<TotalTaxableWages>666.00000</TotalTaxableWages>
</PayRunTax>
</PayRunResult>
</PayRun>
</PayRunHistoryImport>Activate also generates the following two reports to assist with Year-to-Date validation and balancing:
- FTP Subdirectory: PayRunHistoryImport/Activate Validation reports
- FilesNames:
<Namespace>-Activate PayRunValidationReports-<DateTimeStart> - <DateTimeEnd>.xlsx
Next steps
Review the pay period used for the YTD Load in Dayforce and validate against the legacy payroll for accuracy in mapping.
Complete the next wizard, as appropriate.
Commonly encountered issues
Before uploading the template, you must make sure that the data doesn’t have any errors. Some commonly encountered problems include:
- Missing required field or data.
- The Tax YTD Data tab is missing in the Excel spreadsheet.
- Incorrect formatting.
- If the file includes a filter, it might result in an error.
If a column has an error that you can't resolve, click the letter at the top of the column, in the menu, select Data and Text to Columns, and then click Next, Next, and Finish. This action converts the data in the column back to text. If the information was formatted incorrectly, it might resolve the problem.
Next steps
Complete the next wizard, as appropriate.
YTD Data 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.
Earning YTD Data template fields
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 1 | String1 between 1-64 characters. | This field uniquely identifies a group of employees. In some previous payroll provider systems, it could be defined as “Company Number.” It could be defined as “Salary Employees” or “Hourly Employees” if you segregate them into separate groups for Payroll Register purposes. It’s the identifier used to define the current payroll the employee is paid through. This value is the grouping of employees paid at the same time who are reported together in the same payroll totals reports. | B1234 Monthly Executive Payroll |
This data is used as part of the key to identify deduction definitions uniquely. It serves to preserve definitions that might have the same name or code but differing functionality between payrolls. |
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 | Date. Excel right-justified date format or Excel text format yyyy-mm-dd. | The Pay Period End Date of the period for provided YTD values. The Pay Period End Date being used should be the same date for each of the three YTD import files. | Date formatted cells:
09/24/2015 24/09/2015 Text formatted cells: |
This required date identifies the period in your payroll calendar that represents the YTD values provided on this import. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 3 |
Alphanumeric. Unique value between 1-40 characters.
For Canadian pay groups, a unique value between 1-9 characters. |
It enables the system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads. | 3241245 000000006 abc12349 |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 4 | String1 between 1-64 characters. | Legal first name of the employee. | Joe |
For this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 5 | String1 between 1-64 characters. | Legal last name of the employee. | Smith | For this import, the Employee Identifier, First Name, and Last Name helps users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 6 | Numeric. Length 9-20. Special characters and letters might be allowed based on the operating country. |
The unique identifier for the legal entity that the employee was paid through.
USA: Federal Employer Identification Number (FEIN) Canada: Business Number (BN) United Kingdom: HMRC/PAYE number Ireland: Legal Entity Identifier (LEI) Australia: Australian Business Number (ABN) NZL: New Zealand Business Number (NZBN). |
123456789
234/A1237634 12345678901 1234567890123 |
This required data assigns the correct Legal Entity to the specific deduction for tax reporting purposes. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 7 | String1 between 1-64 characters. | The payroll system Earning Code as defined on the previous payroll provider's system. | REG | This data is used with the Payroll Identifier and Earning Description to identify individual earning definition requirements. |
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 |
|---|---|---|---|---|
| 8 | String1 between 1-64 characters. | The payroll system Earning Description as defined on the previous payroll provider's system. | Regular | This data is used with the Payroll Identifier and Earning Code to identify individual earning definition requirements. |
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 | Numeric. | The accumulated dollar amount associated with this specific earning. | 2751
59.5 |
This data is required for the first step of the Activate process to balance to the source data. It’s required for the YTD accumulator data load files to load the “To Date“ amount for the specific earnings for tax reporting purposes. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 10 | Numeric. | The accumulated number of hours associated with this specific earning. |
2751
59.5 |
This data identifies specific earnings to be calculated by hours and rate for the first step of the Activate process. It can be loaded as zero (0.00) or Null (blank) when not required. When applicable to the earning type, the YTD accumulator data load files must load the “To Date” number of hours for various HR, Benefit (ACA) and Payroll reporting purposes. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 11 |
Work Location Accepted Value2 For US: 2-letter state identifier. For CAN: For the UK: For AUS: state identifier. For NZL: |
The two letter state/province code of the state the employee worked in which triggered this deduction.
If in the United Kingdom report as GBR for all records. If in Australia or New Zealand, provide the location identifier from the list below. Refer to the list below for Valid Work Location accepted value. |
USA State:
FL IL CAN Province: United Kingdom: Ireland: Australia: New Zealand: France: |
This data is required for the YTD data load files for tax reporting purposes. It’s possible for the employee to have values in multiple states or provinces, thus the requirement to identify the code for each line item. |
| Accepted Values | State Name | Country Name |
|---|---|---|
| AU-ACT | Australian Capital Territory | Australia |
| AU-NSW | New South Wales | Australia |
| AU-QLD | Queensland | Australia |
| AU-SA | South Australia | Australia |
| AU-TAS | Tasmania | Australia |
| AU-VIC | Victoria | Australia |
| AU-WA | Western Australia | Australia |
| ON | Ontario | Canada |
| QC | Quebec | Canada |
| NS | Nova Scotia | Canada |
| NB | New Brunswick | Canada |
| MB | Manitoba | Canada |
| BC | British Colombia | Canada |
| PE | Prince Edward Island | Canada |
| SK | Saskatchewan | Canada |
| AB | Alberta | Canada |
| NL | Newfoundland and Labrador | Canada |
| NT | Northwest Territories | Canada |
| YT | Yukon | Canada |
| NU | Nunavut | Canada |
| CN-11 | Beijing | China |
| CN-12 | Tianjin | China |
| CN-13 | Hebei | China |
| CN-14 | Shanxi | China |
| CN-15 | NeiMonggol | China |
| CN-21 | Liaoning | China |
| CN-22 | Jilin | China |
| CN-23 | Heilongjiang | China |
| CN-31 | Shanghai | China |
| CN-32 | Jiangsu | China |
| CN-33 | Zhejiang | China |
| CN-34 | Anhui | China |
| CN-35 | Fujian | China |
| CN-36 | Jiangxi | China |
| CN-37 | Shandong | China |
| CN-41 | Henan | China |
| CN-42 | Hubei | China |
| CN-43 | Hunan | China |
| CN-44 | Guangdong | China |
| CN-45 | Guangxi | China |
| CN-46 | Hainan | China |
| CN-50 | Chongqing | China |
| CN-51 | Sichuan | China |
| CN-52 | Guizhou | China |
| CN-53 | Yunnan | China |
| CN-54 | Xizang | China |
| CN-61 | Shaanxi | China |
| CN-62 | Gansu | China |
| CN-63 | Qinghai | China |
| CN-64 | Ningxia | China |
| CN-65 | Xinjiang | China |
| CN-71 | Taiwan | China |
| CN-91 | HongKong | China |
| CZ-CJC | Jihoceskýkraj | Czech Republic |
| CZ-CJM | Jihomoravskýkraj | Czech Republic |
| CZ-CSC | Severoceskýkraj | Czech Republic |
| CZ-CSM | Severomoravskýkraj | Czech Republic |
| CZ-CST | Stredoceskýkraj | Czech Republic |
| CZ-CVC | Východoceskýkraj | Czech Republic |
| CZ-CZC | Západoceskýkraj | Czech Republic |
| CZ-PRG | Praha | Czech Republic |
| DE-BB | Brandenburg | Germany |
| DE-BE | Berlin | Germany |
| DE-BW | Baden-Württemberg | Germany |
| DE-BY | Bayern | Germany |
| DE-HB | Bremen | Germany |
| DE-HE | Hessen | Germany |
| DE-HH | Hamburg | Germany |
| DE-MV | Mecklenburg-Vorpommern | Germany |
| DE-NI | Niedersachsen | Germany |
| DE-NW | Nordrhein-Westfalen | Germany |
| DE-RP | Rheinland-Pfalz | Germany |
| DE-SH | Schleswig-Holstein | Germany |
| DE-SL | Saarland | Germany |
| DE-SN | Sachsen | Germany |
| DE-ST | Sachsen-Anhalt | Germany |
| DE-TH | Thüringen | Germany |
| IN-AN | AndamanandNicobarIslands | India |
| IN-AP | AndhraPradesh | India |
| IN-AR | ArunachalPradesh | India |
| IN-AS | Assam | India |
| IN-BR | Bihar | India |
| IN-CH | Chandigarh | India |
| IN-DD | DamanandDiu | India |
| IN-DL | Delhi | India |
| IN-DN | DadraandNagarHaveli | India |
| IN-GA | Goa | India |
| IN-GJ | Gujarat | India |
| IN-HP | HimachalPradesh | India |
| IN-HR | Haryana | India |
| IN-JK | JammuandKashmir | India |
| IN-KA | Karnataka | India |
| IN-KL | Kerala | India |
| IN-LD | Lakshadweep | India |
| IN-MH | Maharashtra | India |
| IN-ML | Meghalaya | India |
| N-MN | Manipur | India |
| IN-MP | MadhyaPradesh | India |
| IN-MZ | Mizoram | India |
| IN-NL | Nagaland | India |
| IN-OR | Orissa | India |
| IN-PB | Punjab | India |
| IN-PY | Pondicherry | India |
| IN-RJ | Rajasthan | India |
| IN-SK | Sikkim | India |
| IN-TN | TamilNadu | India |
| IN-TR | Tripura | India |
| IN-UP | UttarPradesh | India |
| IN-WB | WestBengal | India |
| N/A | State is not required | Ireland |
| IT-21 | Piemonte | Italy |
| IT-23 | ValledAosta | Italy |
| IT-25 | Lombardia | Italy |
| IT-32 | Trentino-AlteAdige | Italy |
| IT-34 | Veneto | Italy |
| IT-36 | Friuli-VeneziaGiulia | Italy |
| IT-42 | Liguria | Italy |
| IT-45 | Emilia-Romagna | Italy |
| IT-52 | Toscana | Italy |
| IT-55 | Umbria | Italy |
| IT-57 | Marche | Italy |
| IT-62 | Lazio | Italy |
| IT-65 | Abruzzo | Italy |
| IT-67 | Molise | Italy |
| IT-72 | Campania | Italy |
| IT-75 | Puglia | Italy |
| IT-77 | Basilicata | Italy |
| IT-78 | Calabria | Italy |
| IT-82 | Sicilia | Italy |
| IT-88 | Sardegna | Italy |
| IT-AG | Agrigento | Italy |
| IT-AL | Alessandria | Italy |
| IT-AN | Ancona | Italy |
| IT-AO | Aosta | Italy |
| IT-AP | AscoliPiceno | Italy |
| IT-AQ | LAquila | Italy |
| IT-AR | Arezzo | Italy |
| IT-AT | Asti | Italy |
| IT-AV | Avellino | Italy |
| IT-BA | Bari | Italy |
| IT-BG | Bergamo | Italy |
| IT-BI | Biella | Italy |
| IT-BL | Belluno | Italy |
| IT-BN | Benevento | Italy |
| IT-BO | Bologna | Italy |
| IT-BR | Brindisi | Italy |
| IT-BS | Brescia | Italy |
| IT-BZ | Bolzano | Italy |
| IT-CA | Cagliari | Italy |
| IT-CB | Campobasso | Italy |
| IT-CE | Caserta | Italy |
| IT-CH | Chieti | Italy |
| IT-CL | Caltanissetta | Italy |
| IT-CN | Cuneo | Italy |
| IT-CO | Como | Italy |
| IT-CR | Cremona | Italy |
| IT-CS | Cosenza | Italy |
| IT-CT | Catania | Italy |
| IT-CZ | Catanzaro | Italy |
| IT-EN | Enna | Italy |
| IT-FE | Ferrara | Italy |
| IT-FG | Foggia | Italy |
| IT-FI | Firenze | Italy |
| IT-FO | Forlì | Italy |
| IT-FR | Frosinone | Italy |
| IT-GE | Genova | Italy |
| IT-GO | Gorizia | Italy |
| IT-GR | Grosseto | Italy |
| IT-IM | Imperia | Italy |
| IT-IS | Isernia | Italy |
| IT-KR | Crotone | Italy |
| IT-LC | Lecco | Italy |
| IT-LE | Lecce | Italy |
| IT-LI | Livorno | Italy |
| IT-LO | Lodi | Italy |
| IT-LT | Latina | Italy |
| IT-LU | Lucca | Italy |
| IT-MC | Macerata | Italy |
| IT-ME | Mesaina | Italy |
| IT-MI | Milano | Italy |
| IT-MN | Mantova | Italy |
| IT-MO | Modena | Italy |
| IT-MS | Massa | Italy |
| IT-MT | Matera | Italy |
| IT-NA | Napoli | Italy |
| IT-NO | Novara | Italy |
| IT-NU | Nuoro | Italy |
| IT-OR | Oristano | Italy |
| IT-PA | Palermo | Italy |
| IT-PC | Piacenza | Italy |
| IT-PD | Padova | Italy |
| IT-PE | Pescara | Italy |
| IT-PG | Perugia | Italy |
| IT-PI | Pisa | Italy |
| IT-PN | Pordenone | Italy |
| IT-PO | Prato | Italy |
| IT-PR | Parma | Italy |
| IT-PS | Pesaro | Italy |
| IT-PT | Pistoia | Italy |
| IT-PV | Pavia | Italy |
| IT-PZ | Potenza | Italy |
| IT-RA | Ravenna | Italy |
| IT-RC | ReggioCalabria | Italy |
| IT-RE | ReggioEmilia | Italy |
| IT-RG | Ragusa | Italy |
| IT-RI | Rieti | Italy |
| IT-RM | Roma | Italy |
| IT-RN | Rimini | Italy |
| IT-RO | Rovigo | Italy |
| IT-SA | Salerno | Italy |
| IT-SI | Siena | Italy |
| IT-SO | Sondrio | Italy |
| IT-SP | LaSpezia | Italy |
| IT-SR | Siracusa | Italy |
| IT-SS | Sassari | Italy |
| IT-SV | Savona | Italy |
| IT-TA | Taranto | Italy |
| IT-TE | Teramo | Italy |
| IT-TN | Trento | Italy |
| IT-TO | Torino | Italy |
| IT-TP | Trapani | Italy |
| IT-TR | Terni | Italy |
| IT-TS | Trieste | Italy |
| IT-TV | Treviso | Italy |
| IT-UD | Udine | Italy |
| IT-VA | Varese | Italy |
| IT-VC | Vercelli | Italy |
| IT-VE | Venezia | Italy |
| IT-VI | Vicenza | Italy |
| IT-VR | Verona | Italy |
| IT-VT | Viterbo | Italy |
| IT-W | ViboValentia | Italy |
| JP-01 | Hokkaidô | Japan |
| JP-02 | Aomori | Japan |
| JP-03 | Iwate | Japan |
| JP-04 | Miyagi | Japan |
| JP-05 | Akita | Japan |
| JP-06 | Yamagata | Japan |
| JP-07 | Hukusima | Japan |
| JP-08 | Ibaraki | Japan |
| JP-09 | Totigi | Japan |
| JP-10 | Gunma | Japan |
| JP-11 | Saitama | Japan |
| JP-12 | Tiba | Japan |
| JP-13 | Tôkyô | Japan |
| JP-14> | Kanagawa | Japan |
| JP-15 | Niigata | Japan |
| JP-16 | Toyama | Japan |
| JP-17 | Isikawa | Japan |
| JP-18 | Hukui | Japan |
| JP-19 | Yamanasi | Japan |
| JP-20 | Nagano | Japan |
| JP-21 | Gihu | Japan |
| JP-22 | Sizuoka | Japan |
| JP-23 | Aiti | Japan |
| JP-24 | Mie | Japan |
| JP-25 | Siga | Japan |
| JP-26 | Kyôto | Japan |
| JP-27 | Ôsaka | Japan |
| JP-28 | Hyôgo | Japan |
| JP-29 | Nara | Japan |
| JP-30 | Wakayama | Japan |
| JP-31 | Tottori | Japan |
| JP-33 | Okayama | Japan |
| JP-34 | Hirosima | Japan |
| JP-35 | Yamaguti | Japan |
| JP-36 | Tokusima | Japan |
| JP-37 | Kagawa | Japan |
| JP-38 | Ehime | Japan |
| JP-39 | Kôti | Japan |
| JP-40 | Hukuoka | Japan |
| JP-41 | Saga | Japan |
| JP-42 | Nagasaki | Japan |
| JP-43 | Kumamoto | Japan |
| JP-44 | Ôita | Japan |
| JP-45 | Miyazaki | Japan |
| JP-46 | Kagosima | Japan |
| JP-47 | Okinawa | Japan |
| KR-11 | SeoulTeugbyeolsi | Korea |
| KR-26 | BusanGwangyeogsi | Korea |
| KR-27 | DaeguGwangyeogsi | Korea |
| KR-28 | IncheonGwangyeogsi | Korea |
| KR-29 | GwangjuGwangyeogsi | Korea |
| KR-30 | DaejeonGwangyeogsi | Korea |
| KR-31 | UlsanGwangyeogsi | Korea |
| KR-41 | Gyeonggido | Korea |
| KR-42 | Gangweondo | Korea |
| KR-43 | Chungcheongbugdo | Korea |
| KR-44 | Chungcheongnamdo | Korea |
| KR-45 | Jeonrabugdo | Korea |
| KR-46 | Jeonranamdo | Korea |
| KR-47 | Gyeongsangbugdo | Korea |
| KR-48 | Gyeongsangnamdo | Korea |
| KR-49 | Jejudo | Korea |
| MX-AGU | Aguascalientes | Mexico |
| MX-BCN | BajaCalifornia | Mexico |
| MX-BCS | BajaCaliforniaSur | Mexico |
| MX-CAM | Campeche | Mexico |
| MX-CHH | Chihuahua | Mexico |
| MX-CHP | Chiapas | Mexico |
| MX-COA | Coahuila> | Mexico |
| MX-COL | Colima | Mexico |
| MX-DIF | DistritoFederal | Mexico |
| DistritoFederal | Durango | Mexico |
| MX-GRO | Guerrero | Mexico |
| MX-GUA | Guanajuato | Mexico |
| MX-HID | Hidalgo | Mexico |
| MX-JAL | Jalisco | Mexico |
| MX-MEX | México | Mexico |
| MX-MIC | Michoacán | Mexico |
| MX-MOR | Morelos | Mexico |
| MX-NAY | Nayarit | Mexico |
| MX-NLE | NuevoLeón | Mexico |
| MX-OAX | Oaxaca | Mexico |
| MX-PUE | Puebla | Mexico |
| MX-QUE | Queretaro | Mexico |
| MX-ROO | QuintanaRoo | Mexico |
| MX-SIN | Sinaloa | Mexico |
| MX-SLP | SanLuisPotosí | Mexico |
| MX-SON | Sonora | Mexico |
| MX-TAB | Tabasco | Mexico |
| MX-TAM | Tamaulipas | Mexico |
| MX-TLA | Tlaxcala | Mexico |
| MX-VER | Veracruz | Mexico |
| MX-YUC | Yucatán | Mexico |
| MX-ZAC | Zacatecas | Mexico |
| NL-DR | Drenthe | Netherlands |
| NL-FL | Flevoland | Netherlands |
| NL-FR | Friesland | Netherlands |
| NL-GE | Gelderland | Netherlands |
| NL-GR | Groningen | Netherlands |
| NL-LI | Limburg | Netherlands |
| NL-NB | Noord-Brabant | Netherlands |
| NL-NH | Noord-Holland | Netherlands |
| NL-OV | Overijssel | Netherlands |
| NL-UT | Utrecht | Netherlands |
| NL-ZE | Zeeland | Netherlands |
| NL-ZH | Zuid-Holland | Netherlands |
| NZ-AUK | Auckland | Netherlands |
| NZ-BOP | Bay of Plenty | Netherlands |
| NZ-CAN | Canterbury | Netherlands |
| NZ-CIT | Chatham Islands Territory | Netherlands |
| NZ-GIS | Gisborne | Netherlands |
| NZ-HKB | Hawke's Bay | Netherlands |
| NZ-MBH | Marlborough | Netherlands |
| NZ-MWT | Manawatu-Wanganui | Netherlands |
| NZ-NSN | Nelson | Netherlands |
| NZ-NTL | Northland | Netherlands |
| NZ-OTA | Otago | Netherlands |
| NZ-STL | Southland | Netherlands |
| NZ-TAS | Tasman | Netherlands |
| NZ-TKI | Taranaki | Netherlands |
| NZ-WGN | Wellington | Netherlands |
| NZ-WKO | Waikato | Netherlands |
| NZ-WTC | West Coast | Netherlands |
| PL-BB | Bielsko | Poland |
| PL-BK | Bialystok | Poland |
| PL-BP | BialaPodlaska | Poland |
| PL-BY | Bydgoszcz | Poland |
| PL-CH | Chelm | Poland |
| PL-CI | Ciechanów | Poland |
| PL-CZ | Czestochowa | Poland |
| PL-EL | Elblag | Poland |
| PL-GD | Gdansk | Poland |
| PL-GO | Gorzów | Poland |
| PL-JG | JeleniaGera | Poland |
| PL-KA | Katowice | Poland |
| PL-KI | Kielce | Poland |
| PL-KL | Kalisz | Poland |
| PL-KN | Konin | Poland |
| PL-KO | Koszalin | Poland |
| PL-KR | Kraków | Poland |
| PL-KS | Krosno | Poland |
| PL-LD | Lódz | Poland |
| PL-LE | Leszno | Poland |
| PL-LG | Legnica | Poland |
| PL-LO | Lomia | Poland |
| PL-LU | Lublin | Poland |
| PL-NS | NowySacz | Poland |
| PL-OL | Olsztyn | Poland |
| PL-OP | Opole | Poland |
| PL-OS | Ostroleka | Poland |
| PL-PI | Pila | Poland |
| PL-PL | Plock | Poland |
| PL-PO | Poznan | Poland |
| PL-PR | Przemysl | Poland |
| PL-PT | Piotrków | Poland |
| PL-RA | Radom | Poland |
| PL-RZ | Rzeszów | Poland |
| PL-SE | Siedlce | Poland |
| PL-SI | Sieradz | Poland |
| PL-SK | Skierniewice | Poland |
| PL-SL | Slupsk | Poland |
| PL-SU | Suwalki | Poland |
| PL-SZ | Szczecin | Poland |
| PL-TA | Tarnów | Poland |
| PL-TG | Tarnobrzeg | Poland |
| PL-TO | Torun | Poland |
| PL-WA | Warszawa | Poland |
| PL-WB | Walbrzych | Poland |
| PL-WL | Wloclawek | Poland |
| PL-WR | Wroclaw | Poland |
| PL-ZA | Zamosc | Poland |
| N/A | State is not required | United Kingdom |
| AL | Alabama | USA |
| AK | Alaska | USA |
| AS | AmericanSamoa | USA |
| AZ | Arizona | USA |
| AR | Arkansas | USA |
| CA | California | USA |
| CO | Colorado | USA |
| CT | Connecticut | USA |
| DE | Delaware | USA |
| DC | DistrictOfColumbia | USA |
| FL | Florida | USA |
| FM | FederatedStatesOfMicronesia | USA |
| GA | Georgia | USA |
| GU | Guam | USA |
| HI | Hawaii | USA |
| ID | Idaho | USA |
| IL | Illinois | USA |
| IN | Indiana | USA |
| IA | Iowa | USA |
| KS | Kansas | USA |
| KY | Kentucky | USA |
| LA | Louisiana | USA |
| ME | Maine | USA |
| MD | Maryland | USA |
| MA | Massachusetts | USA |
| MH | MarshallIslands | USA |
| MI | Michigan | USA |
| MN | Minnesota | USA |
| MP | NorthernMarianaIslands | USA |
| MS | Mississippi | USA |
| MO | Missouri | USA |
| MT | Montana | USA |
| NE | Nebraska | USA |
| NV | Nevada | USA |
| NH | NewHampshire | USA |
| NJ | NewJersey | USA |
| NM | NewMexico | USA |
| NY | NewYork | USA |
| NC | NorthCarolina | USA |
| ND | NorthDakota | USA |
| OH | Ohio | USA |
| OK | Oklahoma | USA |
| OR | Oregon | USA |
| PA | Pennsylvania | USA |
| PR | PuertoRico | USA |
| PW | Palau | USA |
| RI | RhodeIsland | USA |
| SC | SouthCarolina | USA |
| SD | SouthDakota | USA |
| TN | Tennessee | USA |
| TX | Texas | USA |
| UT | Utah | USA |
| VT | Vermont | USA |
| VA | Virginia | USA |
| VI | VirginIslands | USA |
| WA | Washington | USA |
| WV | WestVirginia | USA |
| WI | Wisconsin | USA |
| WY | Wyoming | USA |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 12 | String1 between 1-64 characters. | The Canadian WCB Code is applicable to this Earning. If left blank, the earning amount won’t be included in future WCB YTD totals for this code. | 4214
55264 |
Required for Canadian WCB YTD Limit. |
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 |
|---|---|---|---|---|
| 13 | String1 between 1-64 characters. | The Canadian WCB Account Number applicable to this Earning. If left blank, the earning amount won’t be included in future WCB YTD totals for this code. | 6274747 | Required for Canadian WCB YTD Limit. |
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 |
|---|---|---|---|---|
| 14 | String1characters. | If a different RP Number was used earlier in the tax year or the employee has an RP Number other than the legal entity default, this field is required for YTD reporting. If there has been no change or the employee is assigned the legal entity default rate, it can be left blank. | 0001 | Required for Canadian Tax Remittance YTD when a different RP Number or EI Rate Group was used earlier in the year. If left blank, the current RP Number is used. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
If you’re using any rate groups outside of default within your Legal Entity, every record should have specific RP Number and EI Rate data populated.
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 15 | Numeric between 1.0 and 1.40. | If a different EI Rate was used earlier in the tax year or the employee has an EI Rate other than the legal entity default, this field is required for YTD reporting. If there has been no change or the employee is assigned the legal entity default rate, it can be left blank. | 1.4 | Required for Canadian Tax Remittance YTD when a different EI Rate was used earlier in the year. If left blank the current EI Rate is used. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
Deduction YTD Data Template Fields
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 1 | String1 between 1-64 characters. | This field uniquely identifies a group of employees. In some previous payroll provider systems, it could be defined as “Company Number.” It could be defined as “Salary Employees” or “Hourly Employees” if you segregate them into separate groups for Payroll Register purposes. It’s the identifier used to define the current payroll the employee is paid through. This value is the grouping of employees paid at the same time who are reported together in the same payroll totals reports. | B1234 Monthly Executive Payroll |
This data is used as part of the key to identify deduction definitions uniquely. It serves to preserve definitions that might have the same name or code but differing functionality between payrolls. |
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 | Date. Excel right- justified date format or Excel text format yyyy-mm-dd. | The Pay Period End Date of the period for provided YTD values. The Pay Period End Date being used should be the same date for each of the three YTD import files. |
Date formatted cells:09/24/2015 Text formatted cells:
|
This date is required to identify the period within your payroll calendar that represents the YTD values provided on this import. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 3 |
Alphanumeric. Unique value between 1-40 characters.
For Canadian pay groups, a unique value between 1-9 characters. |
Allows our system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads. | 3241245 000000006 abc12349 |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This is a required field used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
4 |
String1 between 1-64 characters. | Legal first name of the employee. | Joe |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
5 |
String1 between 1-64 characters.
|
Legal last name of the employee. | Smith |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 6 |
Numeric
length 9-20. Special characters and letters might be allowed based on the operating country. |
The unique identifier for the legal entity that the employee was paid through.
USA: Federal Employer Identification Number (FEIN) Canada: Business Number (BN) United Kingdom: HMRC/PAYE number Ireland: Legal Entity Identifier (LEI) Australia: Australian Business Number (ABN) NZL: New Zealand Business Number (NZBN) |
123456789
234/A1237634 12345678901 1234567890123 |
This data is required to assign the correct Legal Entity to the specific deduction for tax reporting purposes. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 7 | String1 between 1-64 characters. | This is the payroll system Deduction Code as defined on the previous payroll provider's system. | H1 | This data is used in combination with the Payroll Identifier and Deduction Description to identify individual deduction definition requirements. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
8 |
String1 between 1-64 characters. | This is the payroll system Deduction Description as defined on the previous payroll provider's system. | Health | This data is used in combination with the Payroll Identifier and Deduction Code to identify individual deduction definition requirements. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
9 |
Numeric.
|
YTD value for this deduction definition. |
2751
59.5 |
This data is required for the first step of the Activate process to balance to the source data. It’s required for the YTD accumulator data load files to load the “To Date” amount for the specific deduction for tax reporting purposes. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
10 |
For US:
2-letter state identifier. For CAN: For UK: For AUS: For NZL: Work Location Accepted Value2. |
The two letter state/province code of the state the employee worked in which triggered this deduction.
If in the United Kingdom report as GBR for all records. If in Australia or New Zealand, provide the location identifier from the Appendix below. Refer below for Valid Work Location accepted value. See the Valid Work Location accepted value list below. |
USA State:
FL IL CAN Province: United Kingdom: New Zealand: |
This data is required for the YTD data load files for tax reporting purposes. It’s possible for the employee to have values in multiple states or provinces, thus the requirement to identify the code for each line item. |
| Accepted Values | State Name | Country Name |
|---|---|---|
| AU-ACT | Australian Capital Territory | Australia |
| AU-NSW | New South Wales | Australia |
| AU-QLD | Queensland | Australia |
| AU-SA | South Australia | Australia |
| AU-TAS | Tasmania | Australia |
| AU-VIC | Victoria | Australia |
| AU-WA | Western Australia | Australia |
| ON | Ontario | Canada |
| QC | Quebec | Canada |
| NS | Nova Scotia | Canada |
| NB | New Brunswick | Canada |
| MB | Manitoba | Canada |
| BC | British Colombia | Canada |
| PE | Prince Edward Island | Canada |
| SK | Saskatchewan | Canada |
| AB | Alberta | Canada |
| NL | Newfoundland and Labrador | Canada |
| NT | Northwest Territories | Canada |
| YT | Yukon | Canada |
| NU | Nunavut | Canada |
| CN-11 | Beijing | China |
| CN-12 | Tianjin | China |
| CN-13 | Hebei | China |
| CN-14 | Shanxi | China |
| CN-15 | NeiMonggol | China |
| CN-21 | Liaoning | China |
| CN-22 | Jilin | China |
| CN-23 | Heilongjiang | China |
| CN-31 | Shanghai | China |
| CN-32 | Jiangsu | China |
| CN-33 | Zhejiang | China |
| CN-34 | Anhui | China |
| CN-35 | Fujian | China |
| CN-36 | Jiangxi | China |
| CN-37 | Shandong | China |
| CN-41 | Henan | China |
| CN-42 | Hubei | China |
| CN-43 | Hunan | China |
| CN-44 | Guangdong | China |
| CN-45 | Guangxi | China |
| CN-46 | Hainan | China |
| CN-50 | Chongqing | China |
| CN-51 | Sichuan | China |
| CN-52 | Guizhou | China |
| CN-53 | Yunnan | China |
| CN-54 | Xizang | China |
| CN-61 | Shaanxi | China |
| CN-62 | Gansu | China |
| CN-63 | Qinghai | China |
| CN-64 | Ningxia | China |
| CN-65 | Xinjiang | China |
| CN-71 | Taiwan | China |
| CN-91 | HongKong | China |
| CZ-CJC | Jihoceskýkraj | Czech Republic |
| CZ-CJM | Jihomoravskýkraj | Czech Republic |
| CZ-CSC | Severoceskýkraj | Czech Republic |
| CZ-CSM | Severomoravskýkraj | Czech Republic |
| CZ-CST | Stredoceskýkraj | Czech Republic |
| CZ-CVC | Východoceskýkraj | Czech Republic |
| CZ-CZC | Západoceskýkraj | Czech Republic |
| CZ-PRG | Praha | Czech Republic |
| DE-BB | Brandenburg | Germany |
| DE-BE | Berlin | Germany |
| DE-BW | Baden-Württemberg | Germany |
| DE-BY | Bayern | Germany |
| DE-HB | Bremen | Germany |
| DE-HE | Hessen | Germany |
| DE-HH | Hamburg | Germany |
| DE-MV | Mecklenburg-Vorpommern | Germany |
| DE-NI | Niedersachsen | Germany |
| DE-NW | Nordrhein-Westfalen | Germany |
| DE-RP | Rheinland-Pfalz | Germany |
| DE-SH | Schleswig-Holstein | Germany |
| DE-SL | Saarland | Germany |
| DE-SN | Sachsen | Germany |
| DE-ST | Sachsen-Anhalt | Germany |
| DE-TH | Thüringen | Germany |
| IN-AN | AndamanandNicobarIslands | India |
| IN-AP | AndhraPradesh | India |
| IN-AR | ArunachalPradesh | India |
| IN-AS | Assam | India |
| IN-BR | Bihar | India |
| IN-CH | Chandigarh | India |
| IN-DD | DamanandDiu | India |
| IN-DL | Delhi | India |
| IN-DN | DadraandNagarHaveli | India |
| IN-GA | Goa | India |
| IN-GJ | Gujarat | India |
| IN-HP | HimachalPradesh | India |
| IN-HR | Haryana | India |
| IN-JK | JammuandKashmir | India |
| IN-KA | Karnataka | India |
| IN-KL | Kerala | India |
| IN-LD | Lakshadweep | India |
| IN-MH | Maharashtra | India |
| IN-ML | Meghalaya | India |
| N-MN | Manipur | India |
| IN-MP | MadhyaPradesh | India |
| IN-MZ | Mizoram | India |
| IN-NL | Nagaland | India |
| IN-OR | Orissa | India |
| IN-PB | Punjab | India |
| IN-PY | Pondicherry | India |
| IN-RJ | Rajasthan | India |
| IN-SK | Sikkim | India |
| IN-TN | TamilNadu | India |
| IN-TR | Tripura | India |
| IN-UP | UttarPradesh | India |
| IN-WB | WestBengal | India |
| N/A | State is not required | Ireland |
| IT-21 | Piemonte | Italy |
| IT-23 | ValledAosta | Italy |
| IT-25 | Lombardia | Italy |
| IT-32 | Trentino-AlteAdige | Italy |
| IT-34 | Veneto | Italy |
| IT-36 | Friuli-VeneziaGiulia | Italy |
| IT-42 | Liguria | Italy |
| IT-45 | Emilia-Romagna | Italy |
| IT-52 | Toscana | Italy |
| IT-55 | Umbria | Italy |
| IT-57 | Marche | Italy |
| IT-62 | Lazio | Italy |
| IT-65 | Abruzzo | Italy |
| IT-67 | Molise | Italy |
| IT-72 | Campania | Italy |
| IT-75 | Puglia | Italy |
| IT-77 | Basilicata | Italy |
| IT-78 | Calabria | Italy |
| IT-82 | Sicilia | Italy |
| IT-88 | Sardegna | Italy |
| IT-AG | Agrigento | Italy |
| IT-AL | Alessandria | Italy |
| IT-AN | Ancona | Italy |
| IT-AO | Aosta | Italy |
| IT-AP | AscoliPiceno | Italy |
| IT-AQ | LAquila | Italy |
| IT-AR | Arezzo | Italy |
| IT-AT | Asti | Italy |
| IT-AV | Avellino | Italy |
| IT-BA | Bari | Italy |
| IT-BG | Bergamo | Italy |
| IT-BI | Biella | Italy |
| IT-BL | Belluno | Italy |
| IT-BN | Benevento | Italy |
| IT-BO | Bologna | Italy |
| IT-BR | Brindisi | Italy |
| IT-BS | Brescia | Italy |
| IT-BZ | Bolzano | Italy |
| IT-CA | Cagliari | Italy |
| IT-CB | Campobasso | Italy |
| IT-CE | Caserta | Italy |
| IT-CH | Chieti | Italy |
| IT-CL | Caltanissetta | Italy |
| IT-CN | Cuneo | Italy |
| IT-CO | Como | Italy |
| IT-CR | Cremona | Italy |
| IT-CS | Cosenza | Italy |
| IT-CT | Catania | Italy |
| IT-CZ | Catanzaro | Italy |
| IT-EN | Enna | Italy |
| IT-FE | Ferrara | Italy |
| IT-FG | Foggia | Italy |
| IT-FI | Firenze | Italy |
| IT-FO | Forlì | Italy |
| IT-FR | Frosinone | Italy |
| IT-GE | Genova | Italy |
| IT-GO | Gorizia | Italy |
| IT-GR | Grosseto | Italy |
| IT-IM | Imperia | Italy |
| IT-IS | Isernia | Italy |
| IT-KR | Crotone | Italy |
| IT-LC | Lecco | Italy |
| IT-LE | Lecce | Italy |
| IT-LI | Livorno | Italy |
| IT-LO | Lodi | Italy |
| IT-LT | Latina | Italy |
| IT-LU | Lucca | Italy |
| IT-MC | Macerata | Italy |
| IT-ME | Mesaina | Italy |
| IT-MI | Milano | Italy |
| IT-MN | Mantova | Italy |
| IT-MO | Modena | Italy |
| IT-MS | Massa | Italy |
| IT-MT | Matera | Italy |
| IT-NA | Napoli | Italy |
| IT-NO | Novara | Italy |
| IT-NU | Nuoro | Italy |
| IT-OR | Oristano | Italy |
| IT-PA | Palermo | Italy |
| IT-PC | Piacenza | Italy |
| IT-PD | Padova | Italy |
| IT-PE | Pescara | Italy |
| IT-PG | Perugia | Italy |
| IT-PI | Pisa | Italy |
| IT-PN | Pordenone | Italy |
| IT-PO | Prato | Italy |
| IT-PR | Parma | Italy |
| IT-PS | Pesaro | Italy |
| IT-PT | Pistoia | Italy |
| IT-PV | Pavia | Italy |
| IT-PZ | Potenza | Italy |
| IT-RA | Ravenna | Italy |
| IT-RC | ReggioCalabria | Italy |
| IT-RE | ReggioEmilia | Italy |
| IT-RG | Ragusa | Italy |
| IT-RI | Rieti | Italy |
| IT-RM | Roma | Italy |
| IT-RN | Rimini | Italy |
| IT-RO | Rovigo | Italy |
| IT-SA | Salerno | Italy |
| IT-SI | Siena | Italy |
| IT-SO | Sondrio | Italy |
| IT-SP | LaSpezia | Italy |
| IT-SR | Siracusa | Italy |
| IT-SS | Sassari | Italy |
| IT-SV | Savona | Italy |
| IT-TA | Taranto | Italy |
| IT-TE | Teramo | Italy |
| IT-TN | Trento | Italy |
| IT-TO | Torino | Italy |
| IT-TP | Trapani | Italy |
| IT-TR | Terni | Italy |
| IT-TS | Trieste | Italy |
| IT-TV | Treviso | Italy |
| IT-UD | Udine | Italy |
| IT-VA | Varese | Italy |
| IT-VC | Vercelli | Italy |
| IT-VE | Venezia | Italy |
| IT-VI | Vicenza | Italy |
| IT-VR | Verona | Italy |
| IT-VT | Viterbo | Italy |
| IT-W | ViboValentia | Italy |
| JP-01 | Hokkaidô | Japan |
| JP-02 | Aomori | Japan |
| JP-03 | Iwate | Japan |
| JP-04 | Miyagi | Japan |
| JP-05 | Akita | Japan |
| JP-06 | Yamagata | Japan |
| JP-07 | Hukusima | Japan |
| JP-08 | Ibaraki | Japan |
| JP-09 | Totigi | Japan |
| JP-10 | Gunma | Japan |
| JP-11 | Saitama | Japan |
| JP-12 | Tiba | Japan |
| JP-13 | Tôkyô | Japan |
| JP-14> | Kanagawa | Japan |
| JP-15 | Niigata | Japan |
| JP-16 | Toyama | Japan |
| JP-17 | Isikawa | Japan |
| JP-18 | Hukui | Japan |
| JP-19 | Yamanasi | Japan |
| JP-20 | Nagano | Japan |
| JP-21 | Gihu | Japan |
| JP-22 | Sizuoka | Japan |
| JP-23 | Aiti | Japan |
| JP-24 | Mie | Japan |
| JP-25 | Siga | Japan |
| JP-26 | Kyôto | Japan |
| JP-27 | Ôsaka | Japan |
| JP-28 | Hyôgo | Japan |
| JP-29 | Nara | Japan |
| JP-30 | Wakayama | Japan |
| JP-31 | Tottori | Japan |
| JP-33 | Okayama | Japan |
| JP-34 | Hirosima | Japan |
| JP-35 | Yamaguti | Japan |
| JP-36 | Tokusima | Japan |
| JP-37 | Kagawa | Japan |
| JP-38 | Ehime | Japan |
| JP-39 | Kôti | Japan |
| JP-40 | Hukuoka | Japan |
| JP-41 | Saga | Japan |
| JP-42 | Nagasaki | Japan |
| JP-43 | Kumamoto | Japan |
| JP-44 | Ôita | Japan |
| JP-45 | Miyazaki | Japan |
| JP-46 | Kagosima | Japan |
| JP-47 | Okinawa | Japan |
| KR-11 | SeoulTeugbyeolsi | Korea |
| KR-26 | BusanGwangyeogsi | Korea |
| KR-27 | DaeguGwangyeogsi | Korea |
| KR-28 | IncheonGwangyeogsi | Korea |
| KR-29 | GwangjuGwangyeogsi | Korea |
| KR-30 | DaejeonGwangyeogsi | Korea |
| KR-31 | UlsanGwangyeogsi | Korea |
| KR-41 | Gyeonggido | Korea |
| KR-42 | Gangweondo | Korea |
| KR-43 | Chungcheongbugdo | Korea |
| KR-44 | Chungcheongnamdo | Korea |
| KR-45 | Jeonrabugdo | Korea |
| KR-46 | Jeonranamdo | Korea |
| KR-47 | Gyeongsangbugdo | Korea |
| KR-48 | Gyeongsangnamdo | Korea |
| KR-49 | Jejudo | Korea |
| MX-AGU | Aguascalientes | Mexico |
| MX-BCN | BajaCalifornia | Mexico |
| MX-BCS | BajaCaliforniaSur | Mexico |
| MX-CAM | Campeche | Mexico |
| MX-CHH | Chihuahua | Mexico |
| MX-CHP | Chiapas | Mexico |
| MX-COA | Coahuila> | Mexico |
| MX-COL | Colima | Mexico |
| MX-DIF | DistritoFederal | Mexico |
| DistritoFederal | Durango | Mexico |
| MX-GRO | Guerrero | Mexico |
| MX-GUA | Guanajuato | Mexico |
| MX-HID | Hidalgo | Mexico |
| MX-JAL | Jalisco | Mexico |
| MX-MEX | México | Mexico |
| MX-MIC | Michoacán | Mexico |
| MX-MOR | Morelos | Mexico |
| MX-NAY | Nayarit | Mexico |
| MX-NLE | NuevoLeón | Mexico |
| MX-OAX | Oaxaca | Mexico |
| MX-PUE | Puebla | Mexico |
| MX-QUE | Queretaro | Mexico |
| MX-ROO | QuintanaRoo | Mexico |
| MX-SIN | Sinaloa | Mexico |
| MX-SLP | SanLuisPotosí | Mexico |
| MX-SON | Sonora | Mexico |
| MX-TAB | Tabasco | Mexico |
| MX-TAM | Tamaulipas | Mexico |
| MX-TLA | Tlaxcala | Mexico |
| MX-VER | Veracruz | Mexico |
| MX-YUC | Yucatán | Mexico |
| MX-ZAC | Zacatecas | Mexico |
| NL-DR | Drenthe | Netherlands |
| NL-FL | Flevoland | Netherlands |
| NL-FR | Friesland | Netherlands |
| NL-GE | Gelderland | Netherlands |
| NL-GR | Groningen | Netherlands |
| NL-LI | Limburg | Netherlands |
| NL-NB | Noord-Brabant | Netherlands |
| NL-NH | Noord-Holland | Netherlands |
| NL-OV | Overijssel | Netherlands |
| NL-UT | Utrecht | Netherlands |
| NL-ZE | Zeeland | Netherlands |
| NL-ZH | Zuid-Holland | Netherlands |
| NZ-AUK | Auckland | Netherlands |
| NZ-BOP | Bay of Plenty | Netherlands |
| NZ-CAN | Canterbury | Netherlands |
| NZ-CIT | Chatham Islands Territory | Netherlands |
| NZ-GIS | Gisborne | Netherlands |
| NZ-HKB | Hawke's Bay | Netherlands |
| NZ-MBH | Marlborough | Netherlands |
| NZ-MWT | Manawatu-Wanganui | Netherlands |
| NZ-NSN | Nelson | Netherlands |
| NZ-NTL | Northland | Netherlands |
| NZ-OTA | Otago | Netherlands |
| NZ-STL | Southland | Netherlands |
| NZ-TAS | Tasman | Netherlands |
| NZ-TKI | Taranaki | Netherlands |
| NZ-WGN | Wellington | Netherlands |
| NZ-WKO | Waikato | Netherlands |
| NZ-WTC | West Coast | Netherlands |
| PL-BB | Bielsko | Poland |
| PL-BK | Bialystok | Poland |
| PL-BP | BialaPodlaska | Poland |
| PL-BY | Bydgoszcz | Poland |
| PL-CH | Chelm | Poland |
| PL-CI | Ciechanów | Poland |
| PL-CZ | Czestochowa | Poland |
| PL-EL | Elblag | Poland |
| PL-GD | Gdansk | Poland |
| PL-GO | Gorzów | Poland |
| PL-JG | JeleniaGera | Poland |
| PL-KA | Katowice | Poland |
| PL-KI | Kielce | Poland |
| PL-KL | Kalisz | Poland |
| PL-KN | Konin | Poland |
| PL-KO | Koszalin | Poland |
| PL-KR | Kraków | Poland |
| PL-KS | Krosno | Poland |
| PL-LD | Lódz | Poland |
| PL-LE | Leszno | Poland |
| PL-LG | Legnica | Poland |
| PL-LO | Lomia | Poland |
| PL-LU | Lublin | Poland |
| PL-NS | NowySacz | Poland |
| PL-OL | Olsztyn | Poland |
| PL-OP | Opole | Poland |
| PL-OS | Ostroleka | Poland |
| PL-PI | Pila | Poland |
| PL-PL | Plock | Poland |
| PL-PO | Poznan | Poland |
| PL-PR | Przemysl | Poland |
| PL-PT | Piotrków | Poland |
| PL-RA | Radom | Poland |
| PL-RZ | Rzeszów | Poland |
| PL-SE | Siedlce | Poland |
| PL-SI | Sieradz | Poland |
| PL-SK | Skierniewice | Poland |
| PL-SL | Slupsk | Poland |
| PL-SU | Suwalki | Poland |
| PL-SZ | Szczecin | Poland |
| PL-TA | Tarnów | Poland |
| PL-TG | Tarnobrzeg | Poland |
| PL-TO | Torun | Poland |
| PL-WA | Warszawa | Poland |
| PL-WB | Walbrzych | Poland |
| PL-WL | Wloclawek | Poland |
| PL-WR | Wroclaw | Poland |
| PL-ZA | Zamosc | Poland |
| N/A | State is not required | United Kingdom |
| AL | Alabama | USA |
| AK | Alaska | USA |
| AS | AmericanSamoa | USA |
| AZ | Arizona | USA |
| AR | Arkansas | USA |
| CA | California | USA |
| CO | Colorado | USA |
| CT | Connecticut | USA |
| DE | Delaware | USA |
| DC | DistrictOfColumbia | USA |
| FL | Florida | USA |
| FM | FederatedStatesOfMicronesia | USA |
| GA | Georgia | USA |
| GU | Guam | USA |
| HI | Hawaii | USA |
| ID | Idaho | USA |
| IL | Illinois | USA |
| IN | Indiana | USA |
| IA | Iowa | USA |
| KS | Kansas | USA |
| KY | Kentucky | USA |
| LA | Louisiana | USA |
| ME | Maine | USA |
| MD | Maryland | USA |
| MA | Massachusetts | USA |
| MH | MarshallIslands | USA |
| MI | Michigan | USA |
| MN | Minnesota | USA |
| MP | NorthernMarianaIslands | USA |
| MS | Mississippi | USA |
| MO | Missouri | USA |
| MT | Montana | USA |
| NE | Nebraska | USA |
| NV | Nevada | USA |
| NH | NewHampshire | USA |
| NJ | NewJersey | USA |
| NM | NewMexico | USA |
| NY | NewYork | USA |
| NC | NorthCarolina | USA |
| ND | NorthDakota | USA |
| OH | Ohio | USA |
| OK | Oklahoma | USA |
| OR | Oregon | USA |
| PA | Pennsylvania | USA |
| PR | PuertoRico | USA |
| PW | Palau | USA |
| RI | RhodeIsland | USA |
| SC | SouthCarolina | USA |
| SD | SouthDakota | USA |
| TN | Tennessee | USA |
| TX | Texas | USA |
| UT | Utah | USA |
| VT | Vermont | USA |
| VA | Virginia | USA |
| VI | VirginIslands | USA |
| WA | Washington | USA |
| WV | WestVirginia | USA |
| WI | Wisconsin | USA |
| WY | Wyoming | USA |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 11 | String1 between 1-64 characters. | The Canadian WCB Code applicable to this Deduction. If left blank, the deduction amount will not be included in future WCB YTD totals for this code. | 4214
55264 |
Required for Canadian WCB YTD Limit. |
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 | String1 between 1-64 characters. | The Canadian WCB Account Number applicable to this Deduction. If left blank, the deduction amount will not be included in future WCB YTD totals for this code. | 6274747 | Required for Canadian WCB YTD Limit. |
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 |
|---|---|---|---|---|
| 13 |
String1. 4 characters. |
If a different RP Number was used earlier in the tax year or the employee has an RP Number other than the legal entity default, this field is required for YTD reporting. If there has been no change or the employee is assigned the legal entity default rate, it can be left blank. | 0001 | Required for Canadian Tax Remittance YTD when a different RP Number or EI Rate Group was used earlier in the year. If left blank the current RP Number will be used. |
1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &
If you are using any rate groups outside of default within your Legal Entity, every record should have specific RP Number and EI Rate data populated.
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 14 | Numeric between 1.0-1.40. | If a different EI Rate was used earlier in the tax year or the employee has an EI Rate other than the legal entity default, this field is required for YTD reporting. If there has been no change or the employee is assigned the legal entity default rate, it can be left blank. | 1.4 | Required for Canadian Tax Remittance YTD when a different EI Rate was used earlier in the year. If left blank the current EI Rate will be used. |
Tax YTD Data AUS NZL Template Fields
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 1 | String1 between 1-64 characters. | This field is used to identify a group of employees uniquely. It could be defined as “Company Number“ in some previous payroll provider systems. It could be defined as “Salary Employees“ or “Hourly Employees“ if you segregate them into separate groups for Payroll Register purposes. It’s the identifier used to define the current payroll the employee is paid through. This is the grouping of employees paid at the same time who are reported together in the same payroll totals reports. |
B1234
Monthly Executive Payroll |
This data is used as part of the key to identify tax definitions uniquely. It serves to preserve definitions, which might have the same name or code but differing functionality between payrolls.
|
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 | Date. Excel right justified date format or Excel text format yyyy-mm-dd. |
The Pay Period End Date of the period for provided YTD values. The Pay Period End Date being used should be the same date for each of the three YTD import files.
|
Date formatted cells: 09/24/2015 24/09/2015 Text formatted cells: |
This date is required to identify the period within your payroll calendar that represents the YTD values provided on this import.
|
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 3 |
Alphanumeric. Unique value between 1-40 characters.
For Canadian pay groups, a unique value between 1-9 characters. |
Allows our system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads.
|
3241245
000000006 abc12349 |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This is a required field used to validate that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce. |
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
4 |
String1 between 1-64 characters. | Legal first name of the employee. | Joe |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Example | Why This Is Needed |
|---|---|---|---|---|
|
5 |
String1 between 1-64 characters.
|
Legal last name of the employee. | Smith |
In the context of this import, the Employee Identifier, First Name, and Last Name is included for the purposes of helping users identify employees when completing the template.
This required field validates that the data being loaded is assigned to the correct employee record. The values provided 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 (), &
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 6 | Numeric length 9-20. |
The unique identifier for the legal entity that the employee was paid through.
Australia: NZL: |
12345678901 1234567890123 |
This data is required to assign the correct Legal Entity to the specific tax for tax reporting purposes. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 7 | String1 between 1-64 characters. |
This is the payroll system Tax Code as defined on the previous payroll provider's system.
|
PAYG STSL |
This data is used to create a mapping between this particular tax and a corresponding HCM tax. |
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 |
|---|---|---|---|---|
| 8 | String1 between 1-64 characters. | The payroll system Tax Description as defined on the previous payroll provider's system. | Pay As You Go
PAYG Student Training Loan |
This data helps to identify the purpose of the existing legacy tax code. |
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 | String
Accepted Values:
Australia Federal New Zealand Federal |
Indicates if the tax is a Federal or State/Provincial tax, and the tax country. | Australia Federal
New Zealand Federal |
This data is help narrow down the possible HCM tax options this tax code could be mapped to. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 10 | For AUS:
State code identifier. For NZL: See Work Location Accepted Value2. |
Provide the work location identifier below. | Australia: AU-VIC AU-SA New Zealand: |
This data is required for the YTD data load files for tax reporting purposes. It’s possible for the employee to work in multiple states, thus the requirement to identify the code for each line item. |
| Accepted Values | State Name | Country Name |
|---|---|---|
| AU-ACT | Australian Capital Territory | Australia |
| AU-NSW | New South Wales | Australia |
| AU-NT | Northern Territory | Australia |
| AU-QLD | Queensland | Australia |
| AU-SA | South Australia | Australia |
| AU-TAS | Tasmania | Australia |
| AU-VIC | Victoria | Australia |
| AU-WA | Western Australia | Australia |
| NZ-AUK | Auckland | New Zealand |
| NZ-BOP | Bay of Plenty | New Zealand |
| NZ-CAN | Canterbury | New Zealand |
| NZ-CIT | Chatham Islands Territory | New Zealand |
| NZ-GIS | Gisborne | New Zealand |
| NZ-HKB | Hawke's Bay | New Zealand |
| NZ-MBH | Marlborough | New Zealand |
| NZ-MWT | Manawatu-Wanganui | New Zealand |
| NZ-NSN | Nelson | New Zealand |
| NZ-NTL | Northland | New Zealand |
| NZ-OTA | Otago | New Zealand |
| NZ-STL | Southland | New Zealand |
| NZ-TAS | Tasman | New Zealand |
| NZ-TKI | Taranaki | New Zealand |
| NZ-WGN | Wellington | New Zealand |
| NZ-WKO | Waikato | New Zealand |
| NZ-WTC | West Coast | New Zealand |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 11 | String Accepted Values: Y N |
Indicate whether this value is a tax to be paid by the employer instead of the employee.
|
Y N |
This data is help narrow down the possible HCM tax options this tax code could be mapped to. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 12 | Numeric. | YTD Amount of the Tax | 1234.56 | This data is required for YTD Tax reporting in addition to the correct calculation of tax on the following pay period. |
| Order | Data Type | Description | Examples | Why This Is Needed |
|---|---|---|---|---|
| 13 | Numeric. | Total Amount of Taxable Wages for reporting. This value is the amount above and beyond a Taxable Wage Limit amount. | 123456.78 | This data is required for YTD Tax reporting in addition to the correct calculation of tax on the following pay period. |