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'

Cincinnati1.png

 

Cincinnati2.png

 

 

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

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.