Run the Third-Party Tax Filing Interface for the US

The Third-Party Tax Filing Interface assists you in out sourcing your tax filing through a third party, such as ADP, MasterTax, and Ceridian.

This third-party interface supports the following scenarios for tax filing.

• Quarterly tax reporting for employees

• Quarterly tax reporting for retirees

• Monthly tax reporting

• Periodic tax reporting

• Generating the detailed audit report

• Separate liability payment reporting on the periodic extract

Note: You must have properly configured the Oracle Fusion Human Capital Management application for tax interface reporting prior to running any extract.

Quarterly Tax Reporting for Employees

This extract uses payroll data to file quarterly and annual returns and, optionally, to print employee W-2s. For further info, see Third-Party Quarterly Tax Filing Extract in the Help Center.

Use the Run Third-Party Quarterly Tax Filing Extract flow to extract the payroll data to an output file. This flow includes employees with any action for the entire year. It always includes year-to-date balances, even if no transaction occurred in the quarter being reported; however, you can manually exclude tax reporting units (TRUs) from processing. For further info, see Configuration Requirements for Third-Party Tax Filing on the Help Center.

To run this extract:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group (LDG).

4. Search for and select Third-Party Quarterly Tax Filing Extract.

5. Enter the following.

   Field name	How you use it
   Extract Tax Quarter	The quarter you're reporting on. For example, enter 3 for the third quarter.
   Extract Tax Year	The 4-digit year you're reporting upon. For example, enter 2021.
   Payroll Statutory Unit	The payroll statutory unit (PSU) you want to report upon. If you leave it blank, the flow runs against all PSUs.
   Tax Reporting Unit	The TRU you want to report upon. If you leave it blank, the flow runs against all TRUs.
   Process Configuration Group	Process configuration group for logging and performance purposes.
   Submission Type	Select Original. For late current quarterly filings, select Exception Late Original File. For closed-quarter amended files, select Amendment File. For these filings, you must also specify: Issue Identification Date Appropriate reason codes Special Instructions Needed For changes to employee W-2s, select W-2 Management File. Specifying the additional fields isn't required but is recommended.
   Issue Identification Date	The date you identified the error. Required for Amendment File submission types. Recommended for W-2 Management File submission types.
   Reason Code 1 through 10	The amendment reason codes. Some amendment reason codes also require additional reason codes. Note: In responsive UIs, the list of values returns a maximum of 25 values. Enter an appropriate value to filter the list or enter the reason code directly.For example, to use the 1A code, enter 1A directly. To find the Administrative error code, enter Admin in the description. The more detailed your search value, the more useful the results will be. Required for Amendment File submission types. Recommended for W-2 Management File submission types. For further info, see your third-party supplier documentation.
   Special Instructions Needed	Enter Yes if the amendment requires any special instructions for the third-party provider. Required for Amendment File submission types. Recommended for W-2 Management File submission types.

   Note: Submission type, issue identification date, the reason codes, and the special instructions are specific to ADP. For further info about these fields, see their documentation. Based on what you enter, ADP performs additional validations. You might have to resubmit your file if the appropriate parameters aren't correctly populated. These fields aren't used by MasterTax.

6. Submit the flow. Upon successful completion, it creates two output files.

   Output file	How you use it
   ADPQuarterlyTaxExtractEtext	Extract text file supporting your third-party tax filing supplier.
   ThirdPartyQuarterlyTaxExtractAudit	PDF file summarizing wage and tax data by tax code. This audit report has no employee-level detail.

   Note: Depending on the transmission method you have chosen, you might have to change the name of the output file before sending it to ADP. For further info, see your ADP documentation.

7. Review the audit report for totals sent on the file.

8. Upload the tax file to your third-party tax filing provider.

Quarterly Tax Reporting for Retirees

This extract uses your retiree payment data to file quarterly and annual returns and, optionally, to enable your third-party provider to print retiree 1099-R forms. Use the Third-Party Quarterly Tax Filing Extract for Retirees flow to extract the retiree payment data to an output file. This flow includes retirees with any action for the entire year. It always includes year-to-date balances, even if no transaction occurred in the quarter being reported.

For further info, see Third-Party Quarterly Tax Filing Extract for Retirees in the Help Center.

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US LDG.

4. Search for and select Third-Party Quarterly Tax Filing Extract for Retirees.

5. Enter the following.

   Field name	How you use it
   Extract Tax Quarter	The quarter you're reporting on. For example, enter 3 for the third quarter.
   Extract Tax Year	The 4-digit year you're reporting upon. For example, enter 2011.
   Payroll Statutory Unit	The PSU you want to report upon. If you leave it blank, the flow runs against all PSUs.
   Tax Reporting Unit	The TRU you want to report upon. If you leave it blank, the flow runs against all TRUs. Note: For retirees, a TRU represents a distribution code. Don't run this extract by individual TRU.
   Process Configuration Group	Process configuration group for logging and performance purposes.
   Submission Type	Select Original. For late current quarterly filings, select Exception Late Original File. For closed-quarter amended files, select Amendment File. For these filings, you must also specify: Issue Identification Date Appropriate reason codes Special Instructions Needed
   Issue Identification Date	The date you identified the error. Required for Amendment File submission types.
   Reason Code 1 through 10	The amendment reason codes. Some amendment reason codes also require additional reason codes. Note: In responsive UIs, the list of values returns a maximum of 25 values. Enter an appropriate value to filter the list or enter the reason code directly.For example, to use the F1 code, enter F1 directly. To find the FFCRA code, enter FF in the description. The more detailed your search value, the more useful the results will be. Required for Amendment File submission types. For further info, see your third-party supplier documentation.
   Special Instructions Needed	Enter Yes if the amendment requires any special instructions for the third-party provider. Required for Amendment File submission types.

   Note: Submission type, issue identification date, the reason codes, and the special instructions are specific to ADP. For further info about these fields, see their documentation. Based on what you enter, ADP performs additional validations. You might have to resubmit your file if the appropriate parameters aren't correctly populated. These fields aren't used by MasterTax.

6. Submit the flow. Upon successful completion, it creates two output files.

   Output file	How you use it
   ADPQuarterlyTaxExtractEtext	Extract text file supporting your third-party tax filing supplier.
   ThirdPartyQuarterlyTaxExtractAudit	PDF file summarizing wage and tax data by tax code. This audit report has no retiree-level detail.

   Note: Depending on the transmission method you have chosen, you might have to change the name of the output file before sending it to ADP. For further info, see your ADP documentation.

7. Review the audit report for totals sent on the file.

8. Upload the tax file to your third-party tax filing provider.

Monthly Tax Reporting

Use the Third-Party Monthly Tax Filing Extract flow to extract monthly payroll data to an output file. This tax extract doesn't include retirees.

Use this extract for	What it does
State unemployment wage and tax reporting	This extract uses payroll data to report state unemployment wages and taxes on a monthly basis. Currently, Illinois is the only state requiring this reporting.
Pennsylvania Act 32 combined filing	This extract passes Pennsylvania Act 32 earned income tax (EIT) data to support combined filing. Note: Not all third-party tax filing providers support combined filing. Confirm with your provider that they support filing to your chosen tax collector.

Note: If you opt to include Pennsylvania Act 32 data, the output file includes both Illinois and Pennsylvania data.

For further info, see Third-Party Monthly Tax Filing Extract in the Help Center.

Before you start, consider the following.

• If you're a Pennsylvania Act 32 combined filer only, you run this extract monthly.

• If you're an Illinois filer only, don't run this extract on the months you run the quarterly extract.

• If you're a Pennsylvania Act 32 combined filer and an Illinois filer, run this extract monthly.

  The third-party tax provider ignores the Illinois data for months 3, 6, 9, and 12. The quarterly tax file processes your Illinois data for those months.

• The monthly tax file doesn't include:

  • Philadelphia jurisdictions

  • Pennsylvania Local Service Taxes

  • Retirees

  Neither is part of combined filing.

• The monthly tax file doesn't include employee year-to-date totals for Pennsylvania Act 32 EIT data if there was no activity for that jurisdiction in the current month.

  The third-party tax filing provider uses data in the fourth quarterly file for your annual tax filings.

• Configure your designated tax collector for Pennsylvania Act 32 combined filing through your third-party tax provider. The monthly file doesn't include it.

• If you're registered as a combined filer for Pennsylvania Act 32 taxes, provide your Tax Collection District (TCD) combined-filing proxy.

  For further info, see Configuration Requirements for Third-Party Tax filing in the Help Center.

• The monthly tax file passes the employee's resident address.

To run this extract:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US LDG.

4. Search for and select Third-Party Monthly Tax Filing Extract.

5. Enter the following.

   Field name	How you use it
   Month	The month you want to report upon. For example, January, February, March, and so on.
   Year	The 4-digit year you're reporting upon. For example, enter 2011.
   Payroll Statutory Unit	The PSU you want to report upon. If you leave it blank, the flow runs against all PSUs.
   Tax Reporting Unit	The TRU you want to report upon. If you leave it blank, the flow runs against all TRUs.
   Include Pennsylvania Data for Combined Filing	Select Yes to include Pennsylvania Act 32 data in the extract.
   Process Configuration Group	Process configuration group for logging and performance purposes.

   Note: Depending on the transmission method you have chosen, you might have to change the name of the output file before sending it to ADP. For further info, see your ADP documentation.

6. Submit the flow. Upon successful completion, it creates two output files.

   Output file name	How you use it
   ADPMonthlyTaxExtractEtext	Extract text file supporting your third-party tax filing supplier.
   ThirdPartyMonthlyTaxExtractAudit	PDF file summarizing wage and tax data by tax code. This audit report has employee level detail.

   Note: Depending on the transmission method you have chosen, you might have to change the name of the output file before sending it to ADP. For further info, see your ADP documentation.

7. Review the audit report for totals sent on the file.

8. Upload the tax file to your third-party tax filing provider.

9. The monthly tax file passes the employee's resident address.

Periodic Tax Reporting

This extract uses payroll data captured by the Archive Periodic Payroll Results flow to report tax liabilities on an as-needed basis. Payroll data captured by an extract run isn't recaptured in subsequent runs, even if you attempt to extract the same time period.

This extract reports the tax data by:

• TRU

  Note: You can process employee and retiree TRUs in the same periodic file.

• Liability date

• Payroll frequency

• Tax code

Note: The extract file contains columns for both male and female employees.

Use the Third-Party Periodic Tax Filing Extract flow to extract the payroll data to an output file. For further info, see Third-Party Periodic Tax Filing Extract in the Help Center.

1. Run the necessary prerequisites for the Archive Periodic Payroll Results flow, such as payroll and prepayment.

2. Run the Archive Periodic Payroll Results flow.

3. From My Client Groups, click Payroll.

4. Click Submit a Flow.

5. Select your US LDG.

6. Search for and select Third-Party Periodic Tax Filing Extract.

7. Enter the following.

   Field Name	How you use it
   Periodic Extract Start Date	The start date of the reporting period. For example, enter 3/1/2021.
   Periodic Extract End Date	The end date of the reporting period. For example, enter 3/15/2021.
   Payroll Statutory Unit	The PSU you want to report upon. If you leave it blank, the flow runs against all PSUs.
   Tax Reporting Unit	The TRU you want to report upon. If you leave it blank, the flow runs against all TRUs.
   Check Date	The override for the liability date of all data you're sending on the periodic tax file.
   Create Employee Detail Report	Select Yes to create a detailed audit report with employee-level info. Select No if you plan to generate the report independently. For further info, see Generating the Detailed Audit Report below.
   Process Configuration Group	Process configuration group for logging and performance purposes.

   When selecting data for extraction, use overlapping dates to ensure all appropriate periodic archives are captured.

8. Submit the flow. Upon successful completion, depending on your parameter selection, it creates up to three output files.

   Output file	How you use it
   ADPPeriodicTaxExtractEtext	Extract text file supporting your third-party tax filing supplier.
   ThirdPartyPeriodicTaxExtractAudit	PDF file listing wage and tax data, organized by payroll frequency and tax code. This audit report has no employee-level detail.
   ThirdPartyPeriodicTaxExtractAuditDetail	Pipe-delimited text file listing wage and tax data, organized by employee name, tax code, and payroll frequency. Use this report to reconcile to the audit report. This file is created only if you selected Yes for Create Employee Detail Report.
   ThirdPartymonthlyTaxExtractAudit	PDF file summarizing wage and tax data by tax code. This audit report has employee-level detail.

   Note: Depending on the transmission method you have chosen, you might have to change the name of the output file before sending it to ADP. For further info, see your ADP documentation.

9. Review the Audit and Audit Detail reports for totals sent on the file.

10. Upload the tax file to your third-party tax filing provider.

11. For employers in Missouri, you must apply for your tax credit directly from the Missouri tax authority.

    The periodic extract file doesn't pass any year-to-date withheld amounts.

Generate the Detailed Audit Report

You can generate the detailed audit report as part of the Third-Party Periodic Tax Filing Extract flow. To generate this report independently:

1. Run the necessary prerequisites for the detailed audit report, such as the Archive Periodic Payroll Results flow and the Third-Party Periodic Tax Filing Extract.

2. From My Client Groups, click Payroll.

3. Click Submit a Flow.

4. Select your US LDG.

5. Search for and select Third-Party Tax Filing Audit Report Detail.

6. Enter the following.

   Field name	How you use it
   Periodic Extract Start Date	Start date of the reporting period. For example, enter 3/1/2021.
   Periodic Extract End Date	End date of the reporting period. For example, enter 3/15/2021.
   Flow Name	Name of a particular periodic tax filing flow to report upon.
   Tax Reporting Unit	TRU you want to report upon. If you leave it blank, the flow runs against all TRUs.
   Employee Name	Name of a particular employee to report upon. Note: You can't select a retiree in this field. However, if you leave this field blank, the flow runs for all retirees.
   Process Configuration Group	Process configuration group for logging and performance purposes.

7. Submit the flow. Upon successful completion, it creates one output file.

   Output file	How you use it
   ThirdPartyTaxFilingAuditRepotDetail	Pipe-delimited text file listing wage and tax data by employee and tax code. Use this report to reconcile to the audit report generated by the Periodic Tax Filing Extract.

8. Review the Audit and Audit Detail reports for totals sent on the file.

Separate Liability Payment Reporting on the Periodic Extract

For periodic tax reporting, you might want to capture the individual payments made toward a liability and the dates they were paid.

To report these payments separately on the periodic extract:

1. Run the necessary prerequisites for the Archive Periodic Payroll Results flow, such as payroll and prepayments.

2. Run the Archive Periodic Payroll Results flow date effective for each payment made toward the liability.

3. Run the extract, and submit the tax info according to standard periodic reporting.

4. If required, use Check Date to specify an override liability date.

   This applies a single liability date to all data on the extract, regardless of when you archived it.

   For further info, see Payment Date Options for Tax Liabilities in the Help Center.