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 |
Comments
0 commentsPlease sign in to leave a comment.