Year-to-Date Payroll Totals (AUS/NZL)

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

Deductions

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

Earnings

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.

Payroll Deduction codes

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:

Complete and upload the Earnings YTD, Deductions YTD, and Taxes YTD template

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.

Review the 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.

Map the legacy codes to the codes in Dayforce

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.

Review the validation

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.

Install the information in Dayforce

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:

Error codes

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

Warning codes

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

Informational codes

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

Tasks

To complete and upload the Earnings YTD, Deductions YTD, and Taxes YTD AUS/NZL templates:

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, and TaxYTDTemplate_AUS_NZL.xlsx template documents, as appropriate.

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.

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 an error that states that the Tax Level: {value} is not allowed for Tax: {tax name} when the 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.

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 states 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.

To review YTD totals for deductions, earnings, and taxes:

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.xlsx document 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.

To map legacy codes to codes in Dayforce:

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 ().
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 continue.
Note: If you select “Drop Earning from import,“ Activate ignores the earning and doesn’t include it in the election file. However, the previous mappingremains 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.

To do the final reviews:

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 Information
Gives 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.

To review validation messages:

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 no error messages exist, 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.

To install the information in Dayforce:

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 states 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 the installation completes, you can download the mapping files, which are used as a basis for any future YTD load. To download the files, go to the User Menu (Person Icon), select Troubleshooting Resources, and then select the appropriate mapping under Customer Mapping Templates to download the file as an Excel spreadsheet.

Fields populated in Dayforce

The data uploaded from the Earning YTD template populates the fields on the following pages in Dayforce.

Fields populated in Dayforce from the Earning YTD template
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.

Fields populated in Dayforce from the Deduction YTD template
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).

Fields populated in Dayforce from the Tax YTD template
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

Files generated by the Year-To-Date Payroll Totals AUS/NZL wizard

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

Examples illustrating how Activate translates the template data to XML:

Earning:

Copy

<?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>

Deduction:

Copy

<?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>

Tax:

Copy

<?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 you upload the template, make sure that the data doesn’t have any errors. Some common 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

Payroll Identifier (Required)

Field information for the Payroll Identifier field
Order	Data Type	Description	Examples	Why This Is Needed
1	String¹ 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.

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

Pay Period End Date (Required)

Field information for the Pay Period End Date field
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: 2015-09-24	This required date identifies the period in your payroll calendar that represents the YTD values provided on this import.

Employee Identifier (Required)

Field information for the Employee Identifier field
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.

First Name (Required)

Field information for the First Name field
Order	Data Type	Description	Examples	Why This Is Needed
4	String¹ between 1-64 characters.	Legal first name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	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.

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

Last Name (Required)

Field information for the Last Name field
Order	Data Type	Description	Examples	Why This Is Needed
5	String¹ between 1-64 characters.	Legal last name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	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.

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

Company ID (Required)

Field information for the Company ID field
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.

Earning Code (Required)

Field information for the Earning Code field
Order	Data Type	Description	Examples	Why This Is Needed
7	String¹ 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.

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

Earning Description (Required)

Field information for the Earning Description field
Order	Data Type	Description	Examples	Why This Is Needed
8	String¹ 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.

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

Amount (Required)

Field information for the Amount field
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.

Hours

Field information for the Hours field
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.

Work Location (Required)

Field information for the Work Location field
Order	Data Type	Description	Examples	Why This Is Needed
11	Work Location Accepted Value² For US: 2-letter state identifier. For CAN: 2-letter province identifier. For the UK: record “GBR.“ For AUS: state identifier. For NZL: region identifier.	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: AB ON United Kingdom: GBR Ireland: IRL Australia: AU-VIC New Zealand: NZ-WGN France: FR	This data is required for the YTD data load files for tax reporting purposes. The employee can have values in multiple states or provinces, thus the requirement to identify the code for each line item.

² Accepted values for Work Location
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

Canada Workers Comp Code (Canada Only)

Field information for the Canada Workers Comp Code field
Order	Data Type	Description	Examples	Why This Is Needed
12	String¹ 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.

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

Canada Workers Comp Acct Number (Canada Only)

Field information for the Canada Workers Comp Acct Number field
Order	Data Type	Description	Examples	Why This Is Needed
13	String¹ 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.

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

Canada Previous RP Number (Canada Only)

Field information for the Canada Previous RP Number field
Order	Data Type	Description	Examples	Why This Is Needed
14	String¹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 is used.

¹ 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.

Canada Previous EI Rate (Canada Only)

Field information for the Canada Previous EI Rate field
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.

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

Deduction YTD Data template fields

Payroll Identifier (Required)

Field information for the Payroll Identifier field
Order	Data Type	Description	Examples	Why This Is Needed
1	String¹ 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.

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

Pay Period End Date (Required)

Field information for the Pay Period End Date field
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: 2015-09-24	This date is required to identify the period within your payroll calendar that represents the YTD values provided on this import.

Employee Identifier (Required)

Field information for the Employee Identifier field
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	The Employee Identifier, First Name, and Last Name help users identify employees when completing the template. This required field is 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.

First Name (Required)

Field information for the First Name field
Order	Data Type	Description	Example	Why This Is Needed
4	String¹ between 1-64 characters.	Legal first name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	Joe	The Employee Identifier, First Name, and Last Namehelp 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.

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

Last Name (Required)

Field information for the Last Name field
Order	Data Type	Description	Example	Why This Is Needed
5	String¹ between 1-64 characters.	Legal last name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	Smith	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.

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

Company ID (Required)

Field information for the Company ID field
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.

Deduction Code (Required)

Field information for the Deduction Code field
Order	Data Type	Description	Examples	Why This Is Needed
7	String¹ 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.

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

Deduction Description (Required)

Field information for the Deduction Description field
Order	Data Type	Description	Example	Why This Is Needed
8	String¹ 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.

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

Amount (Required)

Field information for the Amount field
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.

Work Location (Required)

Field information for the Work Location field
Order	Data Type	Description	Example	Why This Is Needed
10	For US: 2-letter state identifier. For CAN: 2-letter province identifier. For UK: record “GBR“ For AUS: state identifier For NZL: region identifier Work Location Accepted Value².	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: AF ON United Kingdom: GBR New Zealand: NZ-WGN	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 for Work Location
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

Canada Workers Comp Code (Canada only)

Field information for the Canada Workers Comp Code field
Order	Data Type	Description	Examples	Why This Is Needed
11	String¹ 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.

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

Canada Workers Comp Acct Number (Canada only)

Field information for the Canada Workers Comp Acct Number field
Order	Data Type	Description	Examples	Why This Is Needed
12	String¹ 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.

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

Canada Previous RP Number (Canada only)

Field information for the Canada Previous RP Number field
Order	Data Type	Description	Examples	Why This Is Needed
13	String¹. 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.

¹ 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.

Canada Previous EI Rate (Canada only)

Field information for the Canada Previous EI Rate field
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

Payroll Identifier (Required)

Field information for the Payroll Identifier field
Order	Data Type	Description	Examples	Why This Is Needed
1	String¹ 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.

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

Pay Period End Date (Required)

Field information for the Pay Period End Date field
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: 2015-09-24	This date is required to identify the period within your payroll calendar that represents the YTD values provided on this import.

Employee Identifier (Required)

Field information for the Employee Identifier field
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	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.

First Name (Required)

Field information for the First Name field
Order	Data Type	Description	Example	Why This Is Needed
4	String¹ between 1-64 characters.	Legal first name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	Joe	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.

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

Last Name (Required)

Field information for the Last Name field
Order	Data Type	Description	Example	Why This Is Needed
5	String¹ between 1-64 characters.	Legal last name of the employee. Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.	Smith	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.

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

Company ID (Required)

Field information for the Company ID field
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: Australian Business Number (ABN) NZL: New Zealand Business Number (NZBN)	12345678901 1234567890123	This data is required to assign the correct Legal Entity to the specific tax for tax reporting purposes.

Tax Code (Required)

Field information for the Tax Code field
Order	Data Type	Description	Examples	Why This Is Needed
7	String¹ 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.

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

Tax Description (Required)

Field information for the Tax Description field
Order	Data Type	Description	Examples	Why This Is Needed
8	String¹ 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.

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

Tax Level (Required)

Field information for the Tax Level field
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.

Work Location (Required)

Field information for the Work Location field
Order	Data Type	Description	Examples	Why This Is Needed
10	For AUS: State code identifier. For NZL: Region identifier See Work Location Accepted Value².	Provide the work location identifier below.	Australia: AU-VIC AU-SA New Zealand: NZ-WGN	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 for work location
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

Employer Tax (Required)

Field information for the Employer Tax field
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.

Tax Amount (Required)

Field information for the Tax Amount field
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.

Total Taxable Wages (Required)

Field information for the Total Taxable Wages field
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.