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

Third-Party Monthly 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 monthly 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 Monthly Tax Filing Extract.

Before You Begin

Complete all payroll processing for the month.

This extract supports Illinois unemployment and Pennsylvania Act 32 combined filing. Run this extract with the quarterly extract according to your business needs.

If you're

Then you

Pennsylvania Act 32 combined filer only

Run this extract monthly.

Illinois filer only

Don't run this extract on the months you run the quarterly extract.

Both Pennsylvania Act 32 combined filer and Illinois filer

Run this extract monthly. Your 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.

Report Parameters

Month

The month you want to report upon. For example, enter 2 for February.

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.

Include Pennsylvania Data for Combined Filing

Select Yes to include Pennsylvania earned income tax data.

Process Configuration Group

Process configuration group for logging and performance purposes.

Extract Output

The monthly extract produces two output files.

Output file

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 does have 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

Month

Month you're reporting on

Include Pennsylvania Data for Combined Filing

Yes or No to indicate whether to include this data

LDG

Your US legislative data group

Report Category Name

US_THIRD_PARTY_MONTHLY_TAX_EXTRACT
Summary Tables

This section includes monthly, quarterly, and yearly tables with the following.

Value

What this is

Tax Reporting Unit

TRU you're reporting on

Gross

Combined Gross balance for all employees

Subject

Combined Reduced Subject Withholdable balance plus any applicable Subject not Withholdable for all employees

Taxable

Combined Taxable balance for all employees

Liability

Combined Liability or Withheld balance for all employees
Note: If you elected to include Pennsylvania data, this data is included in these totals.
Detail MTD

This section includes tables with the following columns, sorted by:

  1. Client identifier

  2. TRU

  3. State tax code

  4. Full name

Value

What this is

State Tax Code

Oracle Fusion Global Payroll tax code

Full Name

Name of the person

Employee Number

Employee number of the person

Gross

Illinois SUI Employer Gross balance

Note: The monthly extract output file doesn't include gross balances.

Subject

Illinois SUI Employer Reduced Subject Withholdable balance

Taxable

Illinois SUI Employer Taxable balance

Liability

Illinois SUI Employer Liability balance

If you elected to include Pennsylvania data, it appears in a separate section with the following, sorted by:

  1. Client identifier

  2. TRU

  3. Local tax code

  4. Full name

Value

What this is

Local Tax Code

Oracle Fusion Global Payroll tax code

Full Name

Name of the person

Employee Number

Employee number of the person

Gross

Local Gross balance

Note: The monthly extract output file doesn't include gross balances.

Subject

Local Reduced Subject Withholdable balance plus Local Subject not Withholdable balance

Taxable

Local Reduced Subject Withholdable balance plus Local Subject not Withholdable balance

Liability

Local Withheld balance

Related Topics