Chat with an FTB Representative

Method 2 Match File "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 2 "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 Constant zero Numeric
029-037 9 Number of Trust Accounts Reported (All Types) Numeric
038-046 9 Constant zero Numeric
047-055 9 Blanks  
056-064 9 Constant zero Numeric
065-073 9 Blanks  
074-082 9 Total Number of Accounts Compared Against State File 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 Constant Zero
Zero fill all 9 positions.
020-028 9 Number of Accounts where Match Flag = 1
Count the number of "B" Records with a "1" entered in position 358 of the "B" Record and enter the total here. This comparison of the "Matched" last name to the last name on the Inquiry File may prevent financial institutions from receiving incorrect levies.
029-037 9 Number of Trust Account Reported
Count the number of "B" Records that are Trust accounts (all types of trusts) and enter the total.
038-046 9 Constant Zero
Zero fill all 9 positions.
047-055 9 Blanks
056-064 9 Constant Zero
Zero fill all 9 positions.
065-073 9 Blanks
074-082 9 Total Number of Accounts Compared Against State File
Count the total number of accounts held by the financial institution that were compared to the FTB Inquiry File and enter the total.
083-091 9 Total Dollar Amount Reported
Sum the account balances reported in positions 351-357 of the "B" Records and enter the total. Zero fill if account balances were not provided.
092-100 9 Total Number of IRAs Reported
Count the number of "B" Records that are IRAs and enter the total.
101-420 320 Blanks