Third-Party Tax Filing Audit Report Detail

The Third-Party Tax Filing Audit Report Detail is a pipe-delimited text file that lists wage and tax data generated by the Third-Party Periodic Tax Extract.

This report is organized by employee name, tax code, and payroll frequency. Use it to validate your payroll data before submitting the extract file to your third-party tax filing supplier.

Note:

The Third-Party Periodic Tax Filing Extract flow automatically generates this report. For further info, see Third-Party Periodic Tax Filing Extract in the Help Center.

Report Output

This pipe-delimited report is suitable for viewing in a spreadsheet application, such as Microsoft Excel. It includes the following.

Column	What this is
Flow Name	Flow name as specified when you ran the extract.
Tax Reporting Unit	TRU as specified when you ran the extract.
Form 1099-R Distribution Code	For retiree TRUs, the Form 1099-R Distribution Code you have assigned.
Effective Date	Effective date of the archived data. Unless you specify otherwise when you run the extract, this is the liability date.
Payroll Frequency	Frequency as set on the payroll definition.
Employee Number	Employee number of the person.
Employee Name	Name of the person.
Payroll Relationship Number	Person's payroll relationship number.
Gender	Person's gender. Note: The actual extract doesn't use the Male count, so values in that file are always 0. The extract uses the Female column to report each tax type and the number of employees with wages subject to them. Each row represents a different tax and payroll frequency. For further info, see Troubleshoot the Third-Party Tax Filing Interface in the Help Center.
Balance Category Order	Level of the tax, to assist you with data filtering.
Tax Code	Oracle Fusion Global Payroll tax code.
State	Applicable state of the tax.
County	Applicable county of the tax.
City	Applicable city of the tax.
School District	Applicable school district of the tax. Not populated for jurisdictions subject to Pennsylvania Act 32.
Work PSD	Political subdivision (PSD) code for persons working in jurisdictions subject to Pennsylvania Act 32.
Residence PSD	PSD code for persons living in jurisdictions subject to Pennsylvania Act 32.
Tax Collection District Code	Tax Collection District Code of the person's work PSD.
Residence Geocode	Geocode of residence for people working or living in a jurisdiction subject to Pennsylvania Act 32.
Residence County	County of residence for people working or living in a jurisdiction subject to Pennsylvania Act 32.
Residence City	City of residence for people working or living in a jurisdiction subject to Pennsylvania Act 32.
Withheld	Amount withheld for this tax and jurisdiction.
Gross Wages	Person's gross wages for this jurisdiction and tax.
Subject Wages	Person's subject wages for this jurisdiction and tax.
Taxable Wages	Person's taxable wages for this jurisdiction and tax.
Exempt Wages	Person’s exempt overtime wages for this jurisdiction and tax.