EFTPS Payroll Tax and FUTA Quarterly Tax Export File Layout

The EFTPS File Creation process for the EFTPS Payroll Tax Deposit File and the EFTPS  FUTA Quarterly Tax Deposit file both export information in a CSV file format with the following specifications:

Company/Batch Header Record

#	Field Name	Costpoint Table	Length	Column #	Format/Source
1	Record Type Code		1	01-01	5
2	Service Class Code	DIR_DEP_SETTINGS	3	02-04	If the screen DD Setup pay cycle’s Debit Bank ABA Number is NULL in the Direct Deposit Setup screen, populate with 220. Otherwise, populate with 200.
3	Company Name	TAXBLE_ENTITY	16	05-20	TAXBLE_ENTITY.taxble_entity_name where TAXBLE_ENTITY.taxble_entity_id = screen Taxable Entity and TAXBLE_ENTITY.company_id = <Login Company>
4	Company Discretionary Data		20	21-40	Blank
5	Company Identification	TAXBLE_ENTITY	10	41-50	Screen Leading Value for Tax ID concatenated with the TAXBLE_ENTITY.tax_id where TAXBLE_ENTITY.taxble_entity_id = screen Taxable Entity and TAXBLE_ENTITY.company_id = <Login Company> (right-justified and padded with spaces)
6	Standard Entry Class		3	51-53	CCD
7	Company Entry Description		10	54-63	Tax Payment
8	Company Descriptive Date		6	64-69	Blank
9	Effective Entry Date		6	70-75	Screen Effective Deposit Date (YYMDD format)
10	Reserved		3	76-78	Blank
11	Originator Status Code	DIR_DEP_SETTINGS	1	79-79	The first digit fro the Batch Header Record - Original Status and DFI, from the Direct Deposit Settings screen. This should be a 1.
12	Originating DFI Identification		8	80-87	The last eight digits fro the Batch Header Record - Original Status and DFI, from the Direct Deposit Settings screen.
13	Batch Number		7	88-94	0000001 (6 zeroes and a 1)

Company/Batch Control Record

#	Field Name	Costpoint Table	Length	Column #	Format/Source
1	Record Type Code		1	01-01	8
2	Service Class Code	DIR_DEP_SETTINGS	3	02-04	If the Direct Deposit Setup Pay Cycle's Debit Bank ABA Number field value is NULL in the Direct Deposit Setup screen, populate with 220. Otherwise, populate with 200.
3	Entry/Addenda Count		6	05-10	This is the total number of Record Type Code ‘6’ (Entry Detail Record) and Record Type Code ‘7’ (Addenda Record) within the file.
4	Entry Hash		10	11-20	If Bank One is selected in the Financial Agent Bank field, populate with 007103621. Otherwise, if Bank of America is selected, populate with 0006103600.
5	Total Debit Entry Dollar Amount in the batch in dollars and cents, no decimal	DIR_DEP_SETTINGS	12	21-32	If the Direct Deposit Setup Pay Cycle's Debit Bank ABA Number field value is NULL in the Direct Deposit Setup screen, populate with 000000000000. Otherwise, populate with the sum of the following: Soc. Sec. Withheld + Soc Sec Accrued + Federal Tax Withheld + Medicate Withheld + Medicare Accrued.
6	Total Credit Entry Dollar Amount in the batch in dollars and cents, no decimal		12	33-44	populate with the sum of the following: Soc. Sec. Withheld + Soc Sec Accrued + Federal Tax Withheld + Medicate Withheld + Medicare Accrued.
7	Company Identification	TAXBLE_ENTITY	10	45-54	Screen Leading Value for Tax ID concatenated with the TAXBLE_ENTITY.tax_id where TAXBLE_ENTITY.taxble_entity_id = screen Taxable Entity and TAXBLE_ENTITY.company_id = <Login Company>
8	Reserved		19	55-73	Blank
9	Reserved		6	74-79	Blank
10	Originating DFI Identification	DIR_DEP_SETTINGS	8	80-87	The last eight digits fro the Batch Header Record - Original Status and DFI, from the Direct Deposit Settings screen.
11	Batch Number		7	88-94	0000001 (6 zeroes and a 1)