1. Localization Information Guide
  2. Third-Party Quarterly Tax Filing Extract

Third-Party Quarterly Tax Filing Extract

The Third-Party Tax Filing Interface assists you in out-sourcing your employee tax filing through a third party.

It provides extracts for quarterly, monthly, and periodic reporting.

The quarterly extract produces:

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

  • 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 Quarterly Tax Filing Extract.

Note: To generate pay data for retirees, use the Third-Party Quarterly Tax Filing Extract for Retirees flow. For further info, see Third-Party Quarterly Tax Filing Extract for Retirees in the Help Center.

Before You Begin

Complete all payroll processing for the quarter. For further info, see Quarter-End Processing for the US in the Help Center.

Report Parameters

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

Process Configuration Group

Process configuration group for logging and performance purposes.

Submission Type

  • Select Exception Late Original File for late current quarterly filings.

  • Select Amendment File for closed-quarter amended files. For this type, you must also specify an issue identification date, the appropriate reason codes, and any special instructions needed.

  • Select W-2 Management File for changes to employee W-2s. Specifying the additional fields isn't required but is recommended.

  • For all others, select Original.

Issue Identification Date

The date when you had enough knowledge to correct the discovered 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.

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.

Extract Output

The quarterly extract produces two output files.

Output file

What this is

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.
Report Parameters

The Report Parameters section of the report contains the following.

Value

What this is

Year

Year you're reporting on

Quarter

Quarter you're reporting on

Submission Type

Submission type you selected

Issue Identification Date

Issue identification date for Amendment File and W-2 Management File submissions

Reason Code 1 - 10

Reason codes for Amendment File and W-2 Management File submissions

Special Instructions Needed

Special instructions needed for Amendment File and W-2 Management File submissions

LDG

Your US legislative data group

Report Category Name

US_THIRD_PARTY_QUARTERLY_TAX_EXTRACT

Flow Name

Flow name you provided when you ran the extract
Summary Tables

This section includes quarterly and yearly tables with the following.

Value

What this is

Tax Reporting Unit

TRU you're reporting on

Gross

Combined quarterly or yearly gross tax balance of all employees for this TRU, applicable to all tax codes

Subject

Combined quarterly or yearly subject wages of all employees for this TRU, applicable to all tax codes

Taxable

Combined quarterly or yearly taxable wages of all employees for this TRU, applicable to all tax codes

Withheld

Combined quarterly or yearly taxes withheld for this TRU, applicable to all tax codes
Detail Tables

This section includes quarterly and yearly tables with the following, sorted by:

  1. Client identifier

  2. TRU

Value

What this is

Tax Code

Oracle Fusion Global Payroll tax code

ST

Applicable state of the tax

City/County

Applicable locality of the tax

School or PSD

One of the following:

  • School district name

  • Political subdivision code (PSD) of Pennsylvania Act 32 subject work location

Gross

Combined quarterly or yearly gross tax balance for all employees

Subject

Quarter-to-date or year-to-date sum of the following applicable tax balances for all employees:

  • Reduced Subject Withholdable

  • Subject Not Withholdable balances

Taxable

Combined quarterly or yearly taxable balances for all employees

Withheld

Combined quarterly or yearly withheld balances for all employees

Related Topics