Payroll Comparison

Activate User's Guide
Version
2025.2
Payroll Comparison

Use the Payroll Comparison wizard to upload legacy payroll data into Activate and compare it against Dayforce pay run data for Parallel testing automatically.

This wizard provides a guided process that standardizes and speeds up the Parallel testing process:

  • Simple data templates that enable you to upload legacy payroll data at the Company or Employee level.
  • Activate automatically outputs variances between legacy and Dayforce at the Company or Employee level.
  • You can save the status, owner, root cause, and make notes that are associated with each variance record at the Company or Employee level.
  • The ability to extract data from Dayforce to generate comparison reports with variances automatically.
  • The ability to track the review status and progress for each pay period being tested.

Note: You can’t use the Payroll Comparison wizard to import data or make changes directly in Dayforce. The Testing Team executes payroll recalculations directly in Dayforce and uses Activate to track the comparison progress.

Note: Tax comparison is currently supported for the USA, Canada, UK, Ireland, Australia, and New Zealand. Payroll Comparison doesn’t currently support a garnishment comparison.

Note: See the Important Information section (below) for additional information.

Note: 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 one environment invalidate the mappings in another environment, Activate notifies you when you access a wizard with invalid mappings that need to be updated.

Before you begin

You must load data and calculate the payroll in Dayforce.

Tasks

To add new tests:

  1. In Activate Central, click Prepare Environment for Parallel or Go Live. The Prepare Environment for Parallel or Go Live wizards show.
  2. Click Payroll Comparison.
  3. On the Payroll Comparison page, click Add Test.
  4. On the Test Parameters page, complete the questions.

    For information on each field see the Questions section (below).

  5. Click Done. The Payroll Comparison page opens with the new test included in the list of tests in the wizard.

To run tests:

  1. In Activate Central, click Prepare Environment for Parallel or Go Live. The Prepare Environment for Parallel or Go Live wizards show.
  2. Click Payroll Comparison.
  3. On the Payroll Comparison page, select the test to run.

    The Payroll Comparison page shows all of the tests that were created. Each test corresponds to a pay run in Dayforce.

    Note: If the organization has more than one pay group, you must add a separate test for each pay group.

    The Pay Run Test Steps page opens, The Parallel Comparison workflow indicates the completion status for each step on the list. The steps include:

    • Edit test parameters: Change the test name and whether the legacy data will be imported. If the test was created in error, you can delete it.
    • Review employee data in Dayforce: Run a standardized set of employee data audit reports provided in Activate directly in the Dayforce instance at any time to audit employee data. The audit reports show in the Report folder in Dayforce.
    • Generate Company Totals from Dayforce: You can create several payroll comparison tests. When you download the results file, Activate uses a naming convention that shows the actual test name that you populated. This naming convention enables you to differentiate between the files that you downloaded based on which organization you used. The naming convention for the results file is <File Type><Test Name><Date and Time file was downloaded>. The results file provides the Company ID, Type, Tax & Compliance Code, Source, Earning Name, Earning Description, Employee Count, Amount, and Hours.
    • Generate Employee Totals Report from Dayforce.
    • Upload data from legacy system: Use a guided process to upload payroll data for the entire pay period from the legacy system to Activate. This data is for comparison against the Dayforce selected pay run. If your legacy system doesn’t use two separate deductions for HSA, based on Self and Family limits, you can upload the HSA deductions as a single combined code with the HSA System Code - Federal Limit Unknown code. If you have more than one type of HSA code, a warning shows. You can click Next to continue.

      Note: Uploading the legacy data into Activate doesn’t import any data directly into Dayforce.

      The first step is to upload a Company Totals file that contains the total amount for each code for the entire payroll period. This information gives Activate the ability to run a comparison across organization totals between the legacy data and the payroll data in Dayforce.

      Compare company totals: The Compare Company Totals step, which becomes available after you complete the Company Upload of legacy data, shows an at-a-glance summary of the high-level variance between payroll and the legacy system.

      When discrepancies exist, you can make corrections that will result in a recalculated pay run in Dayforce. Refresh the values on this page to pull the updated payroll data from Dayforce into Activate and recalculate the variances. You can generate a Detailed Comparison report to review the line-by-line differences.

    • Track company review progress.
    • Compare employee totals: The Compare Employee Totals step becomes available after you complete at least one Employee Upload file for legacy data. It shows an at-a-glance summary of the employee-level variance between Dayforce payroll and the legacy system.

      Similar to the Company Totals page, when discrepancies exist, you can make corrections that result in a recalculated pay run in Dayforce. Refresh the values on this page to pull the updated payroll data from Dayforce into Activate and recalculate the variances. You can also generate a Detailed Comparison report to review the line-by-line differences. The format of the Employee report is similar to the Company report, with one significant difference: on the far left are several columns with details of the Employee record in Dayforce that can help with filtering and troubleshooting discrepancies.

    • Track employee review progress: The detailed comparison reports for Company Totals and Employee Totals include review tracking columns at the far right of the data set (Review Status, Review Owner, Root Cause, and Comments). After filling them out, you can import them back into Activate for tracking. Each time the comparison report is generated, it includes the latest review status on each row. You can iteratively update and upload the review columns to track the root cause and status of the variances.
    • Complete this test: You can mark the overall status of the test as Passed when you believe your review is complete. You can also save overall testing notes on this page.
  4. Select the step that you want to do from the list.

To review employee data in Dayforce:

Important: Because the employee data drives the payroll calculations in Dayforce, complete this step first.

This step makes sure that the payroll calculated in Dayforce is accurate and the employee records are complete.

  1. On the Pay Run Test Steps page, select the radio button by the Review employee data in Dayforce field. The Review Employee Data page opens with a checklist of audit reports that are relevant for Parallel testing. This checklist is a way to track whether each audit report has been reviewed or not.

    Note: If you want to suggest a change to the checklist for all customers, log the suggestion in the Aha! Portal.

  2. Log in to Dayforce.
  3. Go to Reporting > Reports > Employee Data Audits.
  4. Run the reports listed on the page to verify the data.

    Note: You can run similar reports, if you prefer.

    For System Integrators:

    Note: The Dayforce Super User role and all customer Admin roles have access to the reports. The Dayforce System Administrator role also has access to all features and reports, updated nightly. The full list is: Dayforce Super User, Admin with Powerpay, Customer Admin, Client Administrator, HR Admin, PR Admin, WFM Admin, MS Client Admin, MS Benefits Admin, MS HR Admin, MS PR Admin.

    Add role access to the Report folder and the desired reports in Dayforce. You can also edit the report configuration in Dayforce. If you delete reports, any missing reports are automatically reinstalled each time you add a new test in Payroll Comparison. Activate can’t tell whether a report was deleted accidentally or intentionally.

    Note: If you want to request changes to the existing reports or suggest new reports, log the suggestion in the Aha! Portal.

  5. Review the audit reports on the Reports tab in Dayforce and verify that the payroll calculated in Dayforce is accurate.

    Note: If you didn't complete the Getting Started wizard in Activate, any missing reports will be installed automatically when you add a new test.

  6. As you verify the data in each report, select the appropriate checkbox on the Review Employee Data page to record your progress.

To upload company data from the legacy system:

  1. On the Pay Run Test Steps page, select the radio button by the Upload data from legacy system field.

    Breadcrumbs at the top of the page indicate where you are in the process.

  2. On the Load Company Totals page, click Download.

  3. Select the location on your computer where you want to save the files.

    You can download any of the following files:

    • Current Earning Mappings

      Note: If you load “negative deductions” from the legacy system that are mapped as earnings, Activate converts the amounts to positive earnings, Then, you can view them in the earning comparison without having to tweak the numbers or reload the data as an earning record. This applies to the amount in the Company Earnings from legacy system section of the Upload Summary table. It also applies to the amount in the Legacy column of the Earnings section in the Compare Company Totals summary. Deductions mapped to a memo earning code retain the original deduction amount.

    • Current Deduction Mappings
    • Current Tax Mappings
  4. Open the files on your computer.
  5. Complete all of the fields in the documents.

    Note: Earnings that are newly mapped in parallel to a memo code show in the Memo Codes row. Earnings that are newly mapped in parallel to a taxable benefit show in the Taxable Benefits row. Deductions that are newly mapped in parallel to a memo code show in the Memo Codes row on the Compare Company Totals Summary page.

    Note: If you’re working with a long list of earnings or deduction codes and need to stop, click Save in the bottom-left section of the page. You can later return to complete the mapping of the remaining codes.

    Note: If you don’t want to include an earning or deduction in the Total Amount, Total Hours, or count of Unique Legacy Codes in the Company Deductions and/or Deductions and Employee Deductions and/or Employee Earnings section of the upload summary, click Drop Deduction from Import and/or Drop Earning from Import as appropriate. Dropped deductions and earnings aren’t included in the Summary page amounts for the Compare Company Totals, Company Totals comparison report, summary page amounts for Compare Employee Totals, or the Employee Totals comparison report.

    Note: Dropped taxes aren’t included in the following: the summary page amounts for Compare Company Totals, the Company Totals comparison report, the summary page amounts for Compare Employee Totals, or the Employee Totals comparison report.

    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.

  6. Click Save and close the files.
    What happens next
    If you...This page opens...
    Can click Upload data from legacy on the Test steps page Upload Employee Totals.
    Haven’t mapped all codes from the Company Totals Mappings.
    Uploaded bad employee data Employee Upload.

    To upload employee data from the legacy system:

    1. On the Upload Employee Totals page, click Upload. You upload the individual Employee Totals files for Earnings, Deductions, Taxes, and Net Pay. See the Legacy Data Files section (below) for information about the Legacy Company Totals Template and the Legacy Employee Tax Template fields.

      Note: When uploading legacy company totals, you can upload Company ID values that are 1-20 characters in length. This enables you to upload legacy files for all supported countries for any pay group.

      Note: The upload of company totals from the legacy system is required. You can provide at least some totals data from your Payroll Register, even if you can't provide line items for every single code or tax. If you can’t upload this information, edit the Test Parameters page and click No for the question Will you upload data from the legacy system.

      Note: The Work Location field is required for rows with Code Type = Tax. This field is ignored for Deduction or Earning rows.

      Note: If you upload a Legacy Company Totals file containing records for the same tax code or description with both Y and N values for Employer Tax, Activate shows a message stating that the Tax code {code name} is listed as both employer and employee tax.

      “Tax code {code name} is listed as both employer and employee tax”

    2. On the Load Legacy Employee Totals page, click Download All Templates or click the download links for the individual templates you want to download.

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

    3. Select the location on your computer where you want to save the files. If you load “negative deductions” from the legacy system that are mapped as earnings, Activate converts the amounts to positive earnings. This conversion enables you to view them in the earning comparison without having to tweak the numbers or reload the data as an earning record.
    4. Open the files on your computer.
    5. Complete all of the fields in the documents.

      Note: If you upload a Legacy Employee Tax file that contains records for the same tax code/description with both Y and N values for Employer Tax, a message shows stating that the Tax code {code name} is listed as both employer and employee tax. This applies to the amount in the Employee Earnings from legacy system section of the Upload summary table. It also applies to the amount in the Legacy column of the Earnings section in the Compare Employee Totals summary. Deductions mapped to a memo earning code keep the original deduction amount.

    6. Click Save and close the files.

      You can use any file name for the files you upload. The document must be an Excel or CSV (comma-separated value) document and contain the data in the required format.

      Note: If you find any issues while loading Employee Totals or mapping, you can click Back to return to the Company Totals upload page so you can reload the file.

    7. On the Load Legacy Employee Totals page, click Upload to upload the files containing the legacy employee information.

      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.

      Note: You aren’t required to upload all four files to continue. If you’re unable to provide some or all of the employee-level data, upload what you can or skip this step.

To compare company totals:

  1. On the Pay Run Test Steps page, select the radio button by the Compare Company Totals field. The Compare Company Totals page opens with a summary of the high-level variance between Dayforce payroll and the legacy system. This variance is for the entire pay period.
  2. Click Generate detailed comparison report.

    The Detailed Comparison report enables you to review the line-by-line differences.

    Note: Activate shows the deduction type based on the pay group country if the deduction is used in more than one country on both the Company and Employee Comparison reports.

    A prompt opens to help you filter the comparison results by a variance threshold to focus on large discrepancies. The report filename includes the test name to enable you to differentiate between files when working with multiple pay groups or pay periods.

    Each time you generate the Detailed Comparison report, it includes the latest review status on each row.

    Note: If you load “negative deductions” from the legacy system that are mapped as earnings, Activate converts the amounts to positive earnings. Then, you can view them in the earning comparison without having to tweak the numbers or reload the data as an earning record. This applies to the Legacy Amount column on the Earning tab of the Company Totals Comparison report.

    Note: Activate doesn’t automatically update the review status based on the variance amount. The Testing team determines and updates the status of specific line items.

  3. Enter the variance amount threshold for filtering comparison results.

    The default is $0.50. You can change the default in Edit Test Parameters.

  4. If you want to exclude codes that are only present in legacy or codes that are only present in Dayforce, select the appropriate checkboxes.

    For example, you can exclude legacy codes that weren’t configured in Dayforce to work with smaller datasets.

  5. Compare the legacy and Dayforce totals.
  6. If any discrepancies exist, click Download Report.
  7. Click the location on your computer where you want to save the Comparison report.

    The Comparison report is an Excel file with separate tabs for Earnings, Deductions, and Taxes. The report also has an Instructions tab that contains information for tracking the review status of the lime item variances in Activate.

    Each tab shows the Dayforce payroll amounts next to the legacy payroll amounts, and calculates the variant amount for review.

To track employee or company review progress:

  1. On the Pay Run Test Steps page, select the radio button next to one of the following fields:
    • Track company review progress
    • Track employee review progress

    The Load Company Comparison Review Status page opens.

  2. Complete the fields on the Comparison report you saved on your computer.

    Several columns on the far left provide details about the Dayforce payroll calculation (for example, the Source, Tax & Compliance Code) might help you filter and troubleshoot discrepancies.

    Several columns on the far right of the data set (Review Status, Review Owner, Root Cause, and Comments) provide information for tracking the review progress on each row. Completing these fields helps you to track your progress.

  3. Click Save and close the file.

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

  4. Click Upload and upload the updated Comparison report.
  5. On the Compare Company Totals page, compare the totals.
  6. If you find any discrepancies, log in to Dayforce and make the corrections.
  7. On the Compare Company Totals page, click Refresh values from Dayforce.
  8. Repeat these steps until there are no discrepancies.

To compare employee totals:

Note: The Compare Employee Totals page becomes available after you complete at least one employee upload file containing legacy data.

  1. On the Pay Run Test Steps page, select the radio button by the Compare employee totals field.

    The Compare Employee Totals page opens with an at-a-glance summary of the employee-level variance between Dayforce payroll and the legacy system.

  2. If you’re testing a sample subset of the entire organization population, select the Display only the employees uploaded from Legacy checkbox.

    Note: The Employee Count row in the summary also includes a Variance report of employees that are present in one system but not the other. This information helps you to identify employees who might have been missed in the legacy data load or aren’t set up correctly in Dayforce.

  3. Click Generate detailed comparison report.

    Note: Activate shows the deduction type based on the pay group country if the deduction is used in more than one country on both the Company and Employee Comparison reports.

    The Detailed Comparison report enables you to review the line-by-line differences.

    A prompt opens so you can filter the comparison results by a variance threshold to focus on large discrepancies.

    Each time you generate the Detailed Comparison report, it includes the latest review status on each row.

    Note: If you load "negative deductions" from the legacy system that are mapped as earnings, Activate converts the amounts to positive earnings. Now, you can view them in the earning comparison without having to tweak the numbers or reload the data as an earning record. This applies to the Legacy Amount column on the Earning tab of the Employee Totals Comparison report.

    Note: Activate doesn’t automatically update the review status based on the variance amount. The Testing team determines and updates the status of specific line items.

  4. Enter the variance amount threshold for filtering comparison results.

    The default is $0.50. You can change the default in Edit Test Parameters.

  5. If you want to exclude codes that are only present in legacy and/or codes that are only present in Dayforce, select the appropriate checkboxes.

    For example, you can exclude legacy codes that weren’t configured in Dayforce to work with smaller data sets.

  6. Compare the legacy and Dayforce totals.
  7. If any discrepancies exist, click Download Report.
  8. Select the location on your computer where you want to save the Comparison report.

    The Comparison report is an Excel file with separate tabs for Earnings, Deductions, and Taxes. The report also has an Instructions tab with information to help you track the review status of the lime item variances in Activate.

    Each tab shows the Dayforce payroll amounts next to the legacy payroll amounts, and calculates the variant amount for review.

To complete this test:

  1. On the Pay Run Test Steps page, select the radio button by the Complete this text field. The Complete Test opens.
  2. Complete the fields on the page.

    For information on each field see the Questions section (below).

  3. Click Done.

To edit test parameters:

  1. In Activate Central, click Prepare Environment for Parallel or Go Live. The Prepare Environment for Parallel or Go Live wizards show.
  2. Click Payroll Comparison.
  3. On the Payroll Comparison page, click Edit Test next to the test you want to update.
  4. On the Test Parameters page, make the necessary changes.

    For information on each field see the Questions section (below).

  5. Click Done. The Payroll Comparison page opens.

To delete tests:

  1. In Activate Central, click Prepare Environment for Parallel or Go Live.

    The Prepare Environment for Parallel or Go Live wizards are shown.

  2. Click Payroll Comparison.
  3. On the Payroll Comparison page, click Delete Test.

Next steps

Review the comparison results with the customer. You might also need to test exports and Year-end reports in Dayforce.

Questions

Let's name this test for easy identification

Enter a unique name for the test to help you to differentiate it from other tests.

Which Dayforce pay group will be used for this test?

Select the pay groups to include in the test.

Which Dayforce pay period (PPN) will be used for this test?

Select the pay period to use for the test.

Actions and results
If you upload a... Then...
File containing a new USA deduction code You can map it to “HSA Combined” in the Deduction mapper grid.
Legacy Company Totals file that contains a code that’s mapped to HSA_COMBINED (whether directly in Payroll Comparison or previously in the Payroll Deduction Codes wizard The Summary page at the end of the Upload wizard loads successfully and the HSA_COMBINED code doesn’t count towards the number of unique Dayforce deductions.
Legacy Employee Deduction file that contains a code that’s mapped to HSA_COMBINED The Summary page at the end of the Upload wizard loads successfully and the HSA_COMBINED code doesn’t count towards the number of unique Dayforce deductions.
Legacy Company Totals file that contains a deduction that’s mapped to HSA_COMBINED Activate shows it in the comparison report against an aggregated row for all HSA deductions in the Dayforce pay run.
Legacy Employee Deduction file that contains a deduction mapped to HSA_COMBINED in the Payroll Deduction Codes wizard Activate shows the information in the comparison report against an aggregated row for all HSA deductions for that employee in the Dayforce pay run. For other employees or rows in the file who might have a different HSA legacy code that is mapped to an actual Dayforce deduction, it’s compared against the corresponding Dayforce deduction.

Will you import data from your legacy system for comparison?

  • Yes: Click this option to show the options to Upload Legacy Data and Compare Company and Employee Totals in the test steps.
  • No: Click this option to generate reports of the current Dayforce payroll totals for the pay period in question using the same format as the Detailed Comparison report. You can use the reports to track legacy amounts or review the status outside of Activate as needed. The reports include the test name in the file name. For example, “DayforceCompany Totals_test_name_timestamp.xlsx.”
Aggregating HSA totals

If your legacy system doesn’t use two separate deductions for HSA, based on Self and Family limits, you can map to “HSA Combined” as one of the options for new deduction codes on the Deduction mapper page. Activate aggregates all HSA Self and Family codes from Dayforce and compares them against the HSA combined codes in the legacy system. When the HSA combined code is loaded, Activate doesn’t count it towards the number of “unique mapped Dayforce codes” in the Company Deductions and Employee Deductions sections.

If you upload a legacy Employee Deduction file that contains a deduction that’s mapped to HSA_COMBINED in the Payroll Deduction Codes wizard, Activate shows the code in the Payroll Comparison report against an aggregated row for all HSA deductions for that employee in the Dayforce pay run.

If you aren’t uploading legacy data, you can use the comparison tool to extract Dayforce payroll data for the pay run in question.

What is the maximum acceptable variance between legacy and Dayforce amounts?

This question shows if you selected Yes to the question Will you import data from your legacy system for comparison?.

Enter the maximum amount of variance for filtering comparison results between the legacy system and Dayforce. This field defaults to $.50.

Payroll review and testing notes

Enter any testing notes.

Important information

Who Can Use the Payroll Comparison Wizard

Which projects/roles can use the Payroll Comparison feature?

Payroll Comparison is available to both Dayforce and customer roles, for any project that has access to Activate Central.

I didn't use Activate for payroll configuration or payroll loads. Can I use the feature?

The payroll configuration, payroll election, and year-to-date wizards aren’t required to use this wizard. Payroll Comparison uses any existing Legacy-to-Dayforce mappings created by those wizards. Using Activate for other payroll loads simplifies the process of loading legacy payroll data.

My company cannot provide data from the Legacy system. Can I still use the feature?

If you don't have data from your legacy system, you can use the data audit checklist in Payroll Comparison and generate reports for the Dayforce totals and compare them outside of Activate.

My company doesn't have the same pay groups or pay period dates as Dayforce. Can I still use the feature?

All Activate reporting is based on the pay group and pay period in Dayforce. Provide data for the same time frame as closely as possible if you don't have the same pay groups or pay period dates as Dayforce. (This information is also required for Year-To-Date loads.) If you can’t provide the data, you can still generate the reports for the Dayforce totals and compare them outside of Activate.

My company does not track Company ID (FEIN or BN). Can I still use the feature?

The Company ID is required to make sure that payroll for Dayforce is aligned with the legacy system. Provide the data by Company ID as closely as you can if the organization doesn't track Company ID (FEIN or BN). If you can’t provide the data, you can still generate reports for the Dayforce totals and compare the information outside of Activate.

My company has pay groups outside of the United States and Canada. Can I still use the feature?

Activate currently supports tax loads only for the United States and Canada. It doesn’t support uploading legacy data for taxes for other countries. However, if you’re located in another country, you can use the wizard to compare earnings, deductions, and net pay, and the reports do include the tax amounts in Dayforce.

My company has a lot of pay groups. Can I use the feature?

If you have several pay groups, add a separate test for each pay group.

My company is very large. Will it be too slow to use?

The Payroll Comparison wizard has been used successfully with large pay groups (over 6,000 employees). Using Activate might be faster than loading pages and reports in Dayforce.

Employee Data Audit reports

Can I add or remove items from the checklist in Payroll Comparison?

No. If you have an idea to change the checklist for all customers, log the suggestion in the Aha! Portal.

I don't see any reports installed in Dayforce Reporting.

The Report folder and all reports in it are installed during Getting Started automatically. If the folder or any reports in it are missing, they’re also automatically installed when you add a new test in Payroll Comparison.

Which roles have access to the Employee Data Audit reports?

Generally, the Dayforce System Administrator role and all customer Admin roles have access to the reports.

The full list is: Dayforce System Administrator, Dayforce Administrator, Admin with Powerpay, Customer Admin, Client Administrator, HR Admin, PR Admin, WFM Admin, MS Client Admin, MS Benefits Admin, MS HR Admin, MS PR Admin.

Can I add report access to other roles?

Yes! Update the role access to the Report folder and the reports directly in Dayforce.

Can I edit the reports to add or remove columns and filters that are relevant to my customer?

Yes! Edit the report configuration directly in Dayforce.

Can I create additional reports that are relevant to my customer?

Yes! Add them directly in Dayforce.

Can I delete reports that are not relevant to my customer?

Yes. Any missing reports are reinstalled automatically each time you add a new test in Payroll Comparison. This happens because Activate can’t tell whether a report was deleted accidentally or intentionally.

How do I request changes to the existing reports or suggest new reports for all customers going forward?

Log the suggestion in the Aha! Portal. We’ll review and update the template reports as needed.

Data Upload from Legacy System

What if I cannot provide Company Totals from the Legacy system?

The upload of Company Totals from the legacy system is required. Most customers can provide at least some totals data from their Payroll Register, even if they can’t provide line items for every single code or tax. If you can’t provide this data, edit the Test parameters and click No for the question Will you upload data from the legacy system?

What if I cannot provide some or all employee data files?

You can skip the upload and focus on working with the high-level Company Totals comparison. You can also work with a partial employee data load. The report has 100% variance from Dayforce on the tabs where no legacy data was uploaded.

I want to change one of the code mappings, but I don't see it in the mapping list in my Payroll Comparison test. What do I need to do?

You can’t edit codes that were mapped from a Year-To-Date or Payroll Election load in Payroll Comparison. To avoid potential issues with loading fresh data files, you must edit them in those wizards. Work with your Data Conversion Consultant (DCC) if you aren’t sure how to edit those mappings.

As an alternative, you can change the code name or description used in the Payroll Comparison load to map it as a "fresh" code.

I do not see my earning or deduction code on the mapping list. Why?

Verify the following: the code is configured in Dayforce, you selected the correct Tax and Compliance Code in Dayforce, and it matches the country of the pay group that you’re testing.

Actions to take
If the... Then...
Deduction is configured as an earning in Dayforce Select “Map as earning” and select the correct earning code on the next page.
Earning is configured as a deduction in Dayforce Correct the data upload file to indicate that it’s a deduction and upload the file again.

Note: Deductions mapped to earnings are shown in the Deduction mapper with the “Map as Earning” option selected. If you select a deduction code instead of Map as Earning, the rows in the deduction file are mapped to the corresponding deduction. They show under the Deduction sections in the Summary and Report Totals, and not as the earning. If a deduction was previously “map as earning” and you revert it to an actual deduction but load the same code in the Earning file, it’s handled per the previously existing earning mapping.

Why don't I see my tax code on the mapping list?

Verify that you provided the correct value for “Is Employer Tax?” in the upload file. You can upload the data file again if the value is incorrect. Also, verify that you selected the correct Tax Level and State/Province values.

I clicked Download Existing Totals but the Legacy data file is empty. What do I do?

No valid legacy data was previously uploaded for that file. The corresponding section in the Upload Summary is also blank.

Compare Company and Employee Totals

Why can't I see the options to Compare Company Totals or Compare Employee Totals in the workflow steps?

These options are available only if you selected Yes for the question”Will you upload data from the legacy system? in the Test set up. You can select Edit Test Parameters to change the answer, if needed.

Why can't I access the Compare Company Totals or Compare Employee Totals page?

The page is accessible only after you upload a valid legacy data file and complete all missing mappings for the corresponding page. Upload a valid legacy data file in the previous step and make sure that all mappings are complete for all codes in the file.

How can I tell whether the Dayforce totals are up-to-date?

The Last Refreshed time stamp shows at the top, above the Earnings section. The Dayforce values are refreshed each time you load the page, or click Refresh values from Dayforce. The comparison report is also generated using the current payroll data from Dayforce.

Note: Clicking Refresh values from Dayforce on this page doesn’t initiate a Calculate Payroll job in Dayforce. It retrieves the latest payroll totals to show in Activate.

How can I compare employee totals for only a subset of employees?

If you can’t provide legacy data for the entire employee population, click the following to focus on just that subset of employees in the comparison: the Display only the employees uploaded from Legacy checkbox and the Include only the employees uploaded from Legacy report filter.

Selecting the Display only the employees uploaded from Legacy checkbox includes employees that weren’t in the legacy data file. This includes the combined employee list from all of the Legacy Employee data files. For example, if you uploaded earnings but not deductions from an employee, that employee is still be included in the totals for the Deductions section. Activate can’t tell whether the employee was deliberately left off the deduction file, or whether they were left off because the deduction wasn’t calculated in the legacy system and therefore is a true variance.

Why does the "Display only the employees uploaded from Legacy" checkbox include employees that were not in my legacy data file?

The checkbox includes the combined employee list from all of the Legacy Employee data files. For example, if you uploaded earnings but not deductions from an employee, that employee is still included in the totals for the Deductions section. Activate can’t tell if the employee was left off the deduction file intentionally or they were left off because the deduction wasn’t calculated in the legacy system and is a true variance.

Can I change the default filter for Maximum Acceptable Variance Amount?

Yes, you can change the default filter from Edit Test Parameters in the test workflow. The default acceptable variance of 0.50 was selected to encourage testers to focus on significant differences and not waste time on variance amounts that might be rounding differences between Dayforce and the legacy system. You can change this default to the acceptable tolerance for your customer's project. You can also change the value when running individual reports, if you need a higher or lower tolerance to troubleshoot individual payroll codes or taxes.

Track Review Progress

Can I add additional columns to the report to help with troubleshooting or review tracking?

Yes. You can also upload the review tracking file with extra columns. However, any extra columns won’t be saved to Activate, and won’t persist the next time you generate the report.

Note: If you want to suggest additional columns for all customers or reports, log the suggestion in the Aha! Portal.

The Variance Amount is 0, but the Review Status is still marked as Needs Review. Why?

All rows are marked as Needs Review by default. Activate never automatically changes the Review Status. You’re responsible for updating the Review Status for each row. If you change it to Correct and upload the values for tracking, any fresh downloads show the values that you last uploaded.

Can I do a partial upload of Review tracking, for example if different people are working on different tabs?

Yes. You can upload any subset of rows for review tracking. Each upload replaces the values for all rows that are included in the upload. If different people are working in different tabs or with different codes, delete those lines from your report to make that you don’t accidentally overwrite each other's work.

The Review column values were reset for rows I was not editing. Why?

Uploading the Review status replaces the values for all rows that are included in the report. If different people are working in different tabs or with different codes, delete those lines from your report to make sure that you don’t accidentally overwrite each other's work. Activate has no way to tell what you intentionally edited or didn’t edit.

I get a validation error: Violation of UNIQUE KEY constraint. What does this mean?

Each report can only have one unique line for the Company ID, Employee Identifier, and payroll XRefCode. You can’t upload duplicate lines with the same unique identifiers. Activate must be able to match the uploaded review status to a single line in the report.

I get a validation error: Earning/Deduction XRefCode or Tax Authority Code could not be found in Dayforce. What does this mean?

Make sure that you didn’t edit the column value on the Comparison report. You might also have updated the earning or deduction XRefCodes in Dayforce since the last time you downloaded the report. Generate a fresh report and upload the Review columns again.

Other topics

How can I delete a test run?

The option to delete the test run is at the bottom of the Edit Test Parameters page.

Why can't I edit the pay group or pay period in the test parameters? I need to change the PPN being used for Parallel.

If you change these parameters, there’s a risk that test data will be out of alignment. You can delete the old test and add a new test for the correct pay group and pay period.

Why can't I see the Net Pay percentage accuracy on the Test Summary page?

The Net Pay percentage accuracy is only available to users after they:

  • Specify the acceptable variance amount in the Test Parameters and
  • Upload a legacy data file for Employee Net Pay.

The next time the Compare Employee Totals page is loaded or refreshed, Activate updates the percentage accuracy. This feature allows users to gauge immediately how much progress they have made in Parallel and how many employees are still inaccurate and need to be reviewed.

How is the Net Pay percentage accuracy calculated on the test summary page?

The Net Pay percentage accuracy is calculated based on the list of employees that were included in the legacy data load for Employee Net Pay. Each employee's legacy net pay is compared to the Dayforce net pay when the user loads or refreshes the Compare Employee Totals page. All employees whose net pay variance is within the maximum acceptable variance (as specified in the Test Parameters) are considered to be “correct.” The test summary shows the percentage of “correct” employees, based on all employees listed in the data load.

Does the comparison include garnishments in Dayforce?

No, as of R17. The feature will be enhanced to include garnishment comparison in an upcoming release of Activate.

Legacy Data Files

Legacy Company Totals template

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.

Code Type (Required)

Field information for the Code Type field
Order Data Type Description Examples Why This Is Needed
1 String Accepted values:
Earning
Deduction
Tax. 		Indicate whether this data is an earning, deduction, or tax. Earning
Deduction
Tax 		This field is used to identify the corresponding code in Dayforce payroll.

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

Payroll Identifier (Required)

Field information for the Payroll Identifier field
Order Data Type Description Examples Why This Is Needed
2 String1 between 1-64 characters. This field is used to identify a group of employees uniquely. It could be defined as “Company Number” in some previous payroll provider systems. It could be defined as “Salary Employees” or “Hourly Employees” if you segregate them into separate groups for Payroll Register purposes. It’s the identifier used to define the current payroll the employee is paid through. This is the grouping of employees paid at the same time who are reported together in the same payroll totals reports. B1234
Monthly
ExecutivePayroll 		This data is used as part of the key to identify Dayforce definitions uniquely. It serves to preserve definitions that might have the same name or code but differing functionality between payrolls.

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

Company ID

Field information for the Company ID field
Order Data Type Description Examples Why This Is Needed
3 Numeric length 9-30. Provide the Federal Employer Identification Number (FEIN) if the legal entity is in the US and the Business Number (BN) if the legal entity is in Canada. For the United Kingdom, enter the HMRC/PAYE number. 123456789 234/A1237634 This data is used to compare and report on totals broken down by Legal Entity in Dayforce payroll.

Legacy Code (Required)

Field information for the Legacy Code field
Order Data Type Description Examples Why This Is Needed
4 String1 between 1-64 characters. The payroll system Earning, Deduction, or Tax Code as defined on the previous payroll provider's system. H1 REG
Fed W/H 		This data is used with the Payroll Identifier and Legacy Description to identify individual earning, deduction, and tax definitions in Dayforce.

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

Legacy Description (Required)

Field information for the Legacy Description field
Order Data Type Description Examples Why This Is Needed
5 String1 between 1-64 characters. The payroll system Earning, Deduction, or Tax Description as defined on the previous payroll provider's system. Employee Health
Regular Federal Withholding 		This data is used with the Payroll Identifier and Legacy Code to identify individual earning, deduction, and tax definitions in Dayforce.

1 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
6 Numeric. Total value for the entire payroll period for this legacy code 2751
37659.5 		This data is required for the payroll comparison to balance to the Dayforce payroll data.

Hours (Only applicable for Earning code type)

Field information for the Hours field
Order Data Type Description Examples Why This Is Needed
7 Numeric. The accumulated number of hours associated with this specific earning. 2751
59.5 		This data is used by the payroll comparison to verify that Dayforce payroll calculates the same hours for applicable earnings as the legacy system. The earning hours might be required to balance for various HR, Benefit (ACA), and Payroll reporting purposes.

Is Employer Tax? (Required for Tax code type)

Field information for the Employer Tax? field
Order Data Type Description Examples Why This Is Needed
8 String Accepted Values:
Y
N

Indicate whether this tax is to be paid by the employer instead of the employee.

Y
N

This data is used to narrow down the possible HCM tax options this tax code could be mapped to.

Limited Taxable Wages (Only applicable for Tax code type)

Field information for the Limited Tax Wages field
Order Data Type Description Examples Why This Is Needed
9 Numeric. Amount of the Taxable Wages for this tax. If the taxable wages exceed the limit for the particular tax, enter the limit value. 123456.78 This data is used by the payroll comparison to verify that Dayforce payroll calculates taxes on the same wage basis as the legacy system.

Total Taxable Wages (Only applicable for Tax code type)

Field information for the Total Taxable Wages field
Order Data Type Description Examples Why This Is Needed
10 Numeric. Total Amount of Taxable Wages for this tax. This amount is above and beyond a Taxable Wage Limit amount. 123456.78 This data is used by the payroll comparison to verify that Dayforce payroll calculates taxes on the same wage basis as the legacy system.

Legacy Employee Tax Template

Employee Identifier (Required)

Field information for the Employee Identifier field
Order Data Type Description Examples Why This Is Needed
1 Alphanumeric. 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
abc123499		 This required field used to validate that the data being loaded is assigned to the correct employee record. The value provided must match exactly to an existing employee record in Dayforce.

Payroll Identifier (Required)

Field information for the Payroll Identifier field
Order Data Type Description Examples Why This Is Needed
2 String1 between 1-64 characters This field is used to identify a group of employees uniquely. It could be defined as “Company Number” in some previous payroll provider systems. It could be defined as “Salary Employees” or “Hourly Employees” if you segregate them into separate groups for Payroll Register purposes. It’s the identifier used to define the current payroll the employee is paid through. This is the grouping of employees paid at the same time who are reported together in the same payroll totals reports. B1234
Monthly Executive
Payroll 		This data is used as part of the key to identify Dayforce definitions uniquely. It serves to preserve definitions, which might have the same name or code but differing functionality between payrolls.

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

Company ID (Required)

Field information for the Company ID field
Order Data Type Description Examples Why This Is Needed
3 Numeric length 9-20. Provide the Federal Employer Identification Number (FEIN) if the legal entity is in the US and the Business Number (BN) if the legal entity is in Canada. For the United Kingdom, enter the HMRC/PAYE number. 123456789
234/A1237634		 This data is used to compare and report on totals broken down by Legal Entity in Dayforce payroll.

Legacy Code (Required)

Field information for the Legacy Code field
Order Data Type Description Examples Why This Is Needed
4 String1 between 1-64 characters The payroll system Tax Code as defined on the previous payroll provider's system. FED W/H This data is used with the Payroll Identifier and Tax Description to identify individual tax definitions in Dayforce.

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

Legacy Description (Required)

Field information for the Legacy Description field
Order Data Type Description Examples Why This Is Needed
5 String1 between 1-64 characters The payroll system Tax Description as defined on the previous payroll provider's system. Federal Withholding This data is used with the Payroll Identifier and Tax Code to identify individual tax definitions in Dayforce.

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

Work Location (Required)

Field information for the Work Location field

Order

 Data Type Description Examples Why This Is Needed
6 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 Value2.		 The two letter state/province code of the state the employee worked in when they reported this tax. If in the United Kingdom report as GBR for all records. If in Australia or New Zealand, provide the location identifier from below. See below for Valid Work Location accepted value.

USA State:
FL
IL

CAN Province:
AB
ON

United Kingdom:
GBR

Australia:
AU-VIC

New Zealand:
NZ-WGN

 This data is required to associate the tax with the correct location for reporting purposes. It’s possible for the employee to have values in multiple states or provinces, so the requirement to identify the code for each line item.
2 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

Is Employer Tax? (Required)

Field information for the Is Employer Tax? field
Order Data Type Description Examples Why This Is Needed
7 String Accepted Values:
Y
N		 Indicate if this tax is to be paid by the employer instead of the employee. Y
N		 This data is used to narrow down the possible HCM tax options this tax code could be mapped to.

Amount (Required)

Field information for the Amount field
Order Data Type Description Examples Why This Is Needed
8 Numeric Total value for the employee in the given payroll period for this legacy code 27.30
659.5 		The payroll comparison uses this data to balance to the Dayforce payroll data.

Limited Taxable Wages

Field information for the Limited Taxable Wages field
Order Data Type Description Examples Why This Is Needed
9 Numeric Amount of the Taxable Wages for this tax. If the taxable wages exceed the limit for the particular tax, enter the limit value. 1234.56 The payroll comparison uses this data to verify that Dayforce payroll calculates taxes on the same wage basis as the legacy system.

Total Taxable Wages

Field information for the Total Taxable Wages field
Order Data Type Description Examples Why This Is Needed
10 Numeric Total Amount of Taxable Wages for this tax. This amount is above and beyond a Taxable Wage Limit amount. 1234.56 The payroll comparison uses this data to verify that Dayforce payroll calculates taxes on the same wage basis as the legacy system.