Chat with an FTB Representative

Method 1 "T" Record (Totals)

The "T" Record is a summary of all the "B" Records reported for the financial institution whose FEIN is entered in positions 007-015 of the "A" Record. The totals in the "T" Record are a count of a particular item reported in the "B" Records or a sum of dollar amounts reported in the "B" Records of a particular financial institution.

Enter numeric values. Right-justify information and zero-fill unused positions.

Method 1 "T" Record

Position Size Description Comments/Format

001 1 Record Type Constant "T"
002-010 9 Total Number of Accounts Reported Numeric
011-019 9 Number of Closed Accounts Reported Account Update Files Only Numeric
020-028 9 Constant zero Numeric
029-037 9 Number of Trust Accounts Reported (All Types) Numeric
038-046 9 Number of New Accounts Reported Account Update Files Only Numeric
047-055 9 Blanks  
056-064 9 Number of Address/Owner Changes Reported Account Update Files Only Numeric
065-073 9 Blanks  
074-082 9 Constant zero Numeric
083-091 9 Total Dollar Amount Reported Numeric, sign trailing
092-100 9 Total Number of IRAs Reported Numeric
101-420 320 Blanks May be a carriage return or a line feed character.

 

Position Size Description
001 1 Record Type
Enter "T"
002-010 9 Total Number of Accounts Reported
Count the number of "B" Records reported and enter the total.
011-019 9 Number of Closed Accounts Reported
For Account Update Files only, count the number of closed accounts reported in the "B" Record
and enter the total. Zero-fill if this is an Account File (reporting all open accounts).
020-028 9 Constant Zero
Zero fill all 9 positions.
029-037 9 Number of Trust Accounts Reported
Count the number of Trust Accounts (all types of trusts) reported in the "B" Record and enter the total.
038-046 9 Number of New Accounts Reported
For Account Update Files only, count the number of new accounts reported in the "B" Record and
enter the total. Zero-fill if this is an Account File (reporting all open accounts).
047-055 9 Blanks
056-064 9 Number of Changes
For Account Update Files only, count the number of accounts included in the "B" Record to report
changes in account ownership or owner addresses.
065-073 9 Blanks
074-082 9 Constant Zero
Zero fill all 9 positions.
083-091 9 Sum of Dollar Amounts Reported in the "B" Records
Show the sum in whole dollars only, with the sign trailing (positive/negative) or embed the sign in the account balance field without occupying an additional storage position. Embedded signs cannot be used in PC created files. For a total dollar amount greater than 999,999 (with trailing sign) or 9,999,999 (with embedded sign) enter 999,999 or 9,999,999 respectively.
092-100 9 Number of IRAs Reported
Count the number of IRAs reported in the "B" Record and enter the total.
101-420 320 Blanks