Standard AQ - Cincinnati Local Tax Details

Report Description

This report offers a very detailed breakdown of all local Cincinnati taxes.

**Only pulls data for - ResidentGeoCode = '360610490' OR WorkGeoCode = '360610490'

Parameters

Parameter Name	Options	Description
Supplier	All available suppliers	Paycheck’s Supplier
Start Date (Check Date)
End Date (Check Date)
SSN		Filters results by Employee’s SSN
Result Type	Detail, Summary

Report Fields

Field Name	Description
When parameter “Result Type” set to “Detail”
Employee ID	Employee’s ID
BoldTalentID	Employee ID in AviontéBOLD (Front Office)
Last Name	Employee’s Last Name
First Name	Employee’s First Name
Middle Name	Employee’s Middle Name
SSN	Employee SSN
Check Number	Paycheck’s Check Number
Check Date	Paycheck’s Check Date
Cinci Taxable	Sum of ItemPay
Cinci Tax Calc Full	Sum of ItemPay * 0.021
Work Site Tax Withheld	Sum of total Local WH Tax Amount; VertexTaxID = 530 and GeoCode = 360610490 and TaxTypeID= 1001, 1002
Cinci Tax Calc Reduced	The difference between Cinci Tax Calc Full and Work Site Tax Withheld; If the value is < 0 then displays as 0; (Cinci Tax Calc Full - Work Site Tax Withheld)
Cinci Tax Actual Withheld	Sum of total Local WH  Tax Amount; VertexTaxID = 530 and GeoCode = 360610490
When parameter “Result Type” set to “Summary”
SSN Count	Count of Distinct SSN
Check Count	Count of Distinct Checks
Cinci Taxable	Sum of ItemPay
Cinci Tax Calc Full	Sum of ItemPay * 0.021
Work Site Tax Withheld	Sum of total Local WH Tax Amount; VertexTaxID = 530 and GeoCode = 360610490 and TaxTypeID= 1001, 1002
Cinci Tax Calc Reduced	The difference between Cinci Tax Calc Full and Work Site Tax Withheld; If the value is < 0 then displays as 0; (Cinci Tax Calc Full - Work Site Tax Withheld)
Cinci Tax Actual Withheld	Sum of total Local WH  Tax Amount; VertexTaxID = 530 and GeoCode = 360610490