T Record - Tax Report Details
The following table lists the field name, description, format, length, position, and from where the data is retrieved.
Field Name | Description | Format | Length | Position | Location |
|---|---|---|---|---|---|
Record ID | T | Text | 1 | 1-1 | Not Applicable |
Total Number of “S” Records | The total number of “S” records. | Number | 7 | 2-8 | Not Applicable |
Taxing Entity Code | Wage | Text | 4 | 9-12 | Wage |
Employer Account Number | The ten-digit Employer Account Number. | Number | 10 | 13-22 | Retrieved from the Employer Account Number field on the CT Quarterly Wage Report - Employer Information page. |
Reserved | Blank | Not Applicable | 4 | 23-26 | Blank |
Total Reportable | Quarterly Gross Wages | Number | 14 | 27-40 | The sum of all “S” Records in position 64-77. |
Excess Wages | Quarterly Wages in excess of the current wage base. | Number | 14 | 41-54 | Calculated based on the wage limit set. |
Taxable Wages | Gross Wages minus Excess Wages. | Number | 14 | 55-68 | Gross Wages minus Excess Wages. |
Reserved | Blank | Not Applicable | 19 | 69-87 | Blank |
Remittance Authorization | The amount authorized to be debited for the employer’s tax filing. Required only if payment is made through a bulk Automated Clearinghouse (ACH) debit payment. Can be left blank. | Number | 13 | 88-100 | Not Applicable |
Reserved | Blank | Not Applicable | 126 | 101-226 | Blank |
Month 1 Employment | Employee count on the 12th of the first month of the quarter. | Number | 7 | 227-233 | Count of non-void checks from checkhis matching pay run selection for month 1. |
Month 2 Employment | Employee count on the 12th of the second month of the quarter. | Number | 7 | 234-240 | Count of non-void checks from checkhis matching pay run selection for month 2. |
Month 3 Employment | Employee count on the 12th of the third month of the quarter. | Number | 7 | 241-247 | Count of non-void checks from checkhis matching pay run selection for month 3. |
Reserved | Blank | Not Applicable | 29 | 248-276 | Blank |