Data Integration Options > Supported Formats > Flat Files > Company941Reports |
Field Name |
Required |
Data Type |
Max |
Description |
QuarterEnd |
Yes |
Datetime |
|
The quarter end date for the quarter being reported |
EmployeeCount |
|
Int |
|
Number of employees |
WagesTipsOther |
|
Decimal |
|
Total wages and tips for the quarter |
FederalTaxWithheld |
|
Decimal |
|
Federal tax withheld for the quarter |
SocialSecurityWages |
|
Decimal |
|
Total wages and tips for the quarter eligible for social security tax |
FicaSocialSecurityTaxRate |
|
Decimal |
|
Current Social Security tax rate |
TaxableTips |
|
Decimal |
|
Amount of social security tips |
MedicareWagesAndTips |
|
Decimal |
|
Wages and tips which are eligible for Medicare tax |
FicaMedicareTaxRate |
|
Decimal |
|
Current Medicare tax rate |
EmployeeCobra |
|
int |
|
|
CobraPremiumTotal |
|
money |
|
|
NumberQualifiedThisQuarter |
|
bigint |
|
|
TotalQualifiedQuarter |
|
bigint |
|
|
NumberExemptEmpMarch |
|
bigint |
|
|
ExemptFicaWages |
|
Decimal |
|
|
ExemptFicaWagesMarch |
|
Decimal |
|
|
ReportRanDate |
|
Datetime |
|
|
AdjustmentForTipsAndGroupTermLife |
|
Decimal |
|
|
AdjustmentForFractionOfCents |
|
Decimal |
|
|
AdvancedEICPayments |
|
Decimal |
|
|
TaxDueOnUnreportedTips |
|
Decimal |
|
|
AdjustmentForSickPay |
|
Decimal |
|
|
AdditionalTaxableMedicareWagesTips |
|
Decimal |
|
|
AdditionalMedicareTaxRate |
|
Decimal |
|
|