Tax Remittance EE AQ

October 02, 2026 17:34

Provides a detailed list of employee tax amounts paid by the employee broken down by tax type.

Parameter Name	Options	Explanation
Supplier	All available Supplier
Branch (Paycheck)	All available Branches
Start Date
End Date
Tax Type(s)	All available Tax Types (Tax Headings)
Date Type	Accounting Period Date, Check Date	Run this AQ by Check Date to reconcile to your payroll tax filings (ie. 941, state withholding returns)
Tax State(s)	All available State codes
Show Local Zero Tax Amounts	True/False	If True, then include tax records for Tax Type 11 (Local Taxes), Tax Type 16 (City), Tax Type 17 (School District) even if Tax Amount = 0 If False, then exclude tax records for Tax Type 11 (Local Taxes), Tax Type 16 (City), Tax Type 17 (School District) if Tax Amount = 0
Employee Summary	True/False	When set to True, the function will: - Remove the "Check Date" column from the results - Retain all other columns - Aggregate numeric values where appropriate, specifically: - Sum the "Gross Wages" column - Sum the "Taxable Gross" column - Sum the "Subject Gross" column - Sum the "Tax Amount" column

Field Name	Description
EmployerName	Paycheck Supplier
BranchName	Paycheck Branch
TaxId	Identifier for Tax
TaxTypeId	Identifier for Tax Type
TaxStateCode	State Code of Tax
TaxName	Tax Name
GrossWages	Total Gross Wages earned by Employee in range
TaxableGross	Total Wages in which actual Tax is calculated in range
SubjectGross	Total Wages Subjected on which Tax is applicable in range
TaxAmount	Total Tax amount deducted in range
CheckDate*	Check Date
EmployeeName	Employee/Payee Name
EmployeeID	Unique Identifier for Employee
SSN	SSN of Employee
EmployeeAddress	Full Address of the Employee (Address1, Address2, City, State, Zip)
FEIN	Employer's FEIN
EmployerAddress	Employer's Address
EmployerPhone	Employer's Phone
EmployerFax	Employer's Fax
ResidentTax	Resident/Non-Resident Tax

Comments