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 |
