Third-Party Periodic Tax Filing Extract

The Third-Party Tax Filing Interface assists you in out-sourcing your tax filing through a third party. It provides extracts for quarterly, monthly, and periodic reporting.

The periodic extract produces:

• Output file suitable for submission to your tax-filing supplier

• Audit report

• Detailed audit report

To run this flow:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group.

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

Before You Begin

Before generating the periodic extract:

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

2. Successfully run the Archive Periodic Payroll Results flow.

Report Parameters

Periodic Extract Start Date

The start date of the reporting period. For example, enter 3/1/2018.

Note: When selecting data for extraction, use overlapping dates to ensure you're capturing all appropriate periodic archives.

Periodic Extract End Date

The end date of the reporting period. For example, enter 3/15/2018.

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 tax reporting unit (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 Audit Output Files below.

Process Configuration Group

Process configuration group for logging and performance purposes.

Extract Output

Depending on your parameter selections, the periodic extract can produce three output files.

Output file	What this is
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. Note: You can also generate this report stand-alone by running the Third-Party Tax Filing Audit Report Detail flow. For further info, see Third-Party Tax Filing Audit Report Detail in the Help Center.

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.

Report Parameters

The Report Parameters section of the report contains the following.

Value	What this is
Legislative Data Group	Your US legislative data group
Process Start Date	Start date of the reporting period
Process End Date	End date of the reporting period
Override Payment Date	Override as specified at extract time with the Check Date parameter
Create Employee Detail Report	Identifies if you opted to generate the detail report during extract submission
Report Category Name	US Third Party Periodic Tax Extract
Flow Name	Flow name as specified when you ran the extract

Summary by Tax Code

This section includes the following.

Value	What this is
Tax Level	Values can be: Federal State County City School
Tax Code	Oracle Fusion Global Payroll tax code
State	Applicable state of the tax
County/City/School	Applicable locality of the tax
Gross	Combined Gross tax balance for all employees and retirees
Subject	Sum of the following balances for all employees and retirees: Reduced Subject Withholdable Subject Not Withholdable
Taxable	Combined Taxable balance for all employees and retirees
Withheld	Combined Total Withheld balance for all employees and retirees

Summary by Tax Reporting Unit and Payroll Frequency

This section includes the following, sorted by:

1. TRU

2. Payroll frequency

3. Process date

Value	What this is
Tax Reporting Unit/Payroll Frequency	TRU and pay frequency
1099-R Code	For retiree TRUs, the Form 1099-R Distribution Code you have assigned
Process Date	Date the payroll data was processed
Gross	Combined Gross tax balance for all employees and retirees
Subject	Sum of the following balances for all employees and retirees: Reduced Subject Withholdable Subject Not Withholdable
Taxable	Combined Taxable balance for all employees and retirees
Deposit Withheld	Total amount withheld and due for deposit to the third-party tax filing supplier

Details by Tax Reporting Unit by Payroll Frequency

This section includes the following, sorted by:

1. Process date

2. TRU

3. Payroll frequency

4. Tax code

Value	What this is
Process Date	Date the payroll data was processed
Client Identifier	Client identifier as issued by your third-party tax filing supplier
Tax Reporting Unit/Payroll Frequency	TRU and pay frequency
Tax Code	Oracle Fusion Global Payroll tax code
State	Applicable state of the tax
County/City/School	Applicable locality of the tax
Gross	Combined Gross tax balance for all employees and retirees
Subject	Sum of the following applicable tax balances for all employees and retirees: Reduced Subject Withholdable Subject Not Withholdable
Taxable	Combined Taxable balance for all employees and retirees
Withheld	Combined Total Withheld balance for all employees and retirees

This pipe-delimited audit detail report is suitable for viewing through a spreadsheet application, such as Microsoft Excel. For further info, see Third-Party Tax Filing Audit Report Detail in the Help Center.