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:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
Search for and select Third-Party Periodic Tax Filing Extract.
Before You Begin
Before generating the periodic extract:
-
Run the necessary prerequisites for the Archive Periodic Payroll Results flow, such as payroll and prepayments.
-
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
.
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. |
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 |
---|---|
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 |
This section includes the following.
Value |
What this is |
---|---|
Tax Level |
Values can be:
|
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:
|
Taxable |
Combined Taxable balance for all employees and retirees |
Withheld |
Combined Total Withheld balance for all employees and retirees |
This section includes the following, sorted by:
-
TRU
-
Payroll frequency
-
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:
|
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 |
This section includes the following, sorted by:
-
Process date
-
TRU
-
Payroll frequency
-
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:
|
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.