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:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
Search for and select Third-Party Quarterly Tax Filing Extract.
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 UnitThe 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. |
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.
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 |
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 |
This section includes quarterly and yearly tables with the following, sorted by:
-
Client identifier
-
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:
|
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:
|
Taxable |
Combined quarterly or yearly taxable balances for all employees |
Withheld |
Combined quarterly or yearly withheld balances for all employees |