EFTPS payment file format

Alerts and notices

The Electronic Federal Tax Payment System (EFTPS) offers you the convenience of making clients' federal tax payments electronically 24 hours a day and 7 days a week. EFTPS allows tax payments to move electronically from the taxpayer's bank account to the federal government's account. The taxpayer's records with the IRS are automatically updated for each such payment.

See also

EFTPS file example

The following image shows a typical Electronic Federal Tax Payment System (EFTPS) file from the Actions > Process EFTPS screen.

EFTPS sample file

Note: For clients that are set up as Household type employers, the file differs. It will include I (for Individual) rather than B (for Business) and it will use the code 10406 for the 1040 tax type. 

EFTPS file format details

EFTPS Excel format

More information about the fields

  • Batch Filer ID and Master inquiry PIN - These can be set up for the firm (globally) in the Actions > Process EFTPS screen. Click the Setup button at the bottom of the screen to open the Setup dialog.

Process EFTPS Setup dialog

  • File Date. This is the date of the file creation.
  • Filer sequence number. Begins with 001 and increments for each file that is created per day.
  • Payment Reference Number. Begins with 0001 and increments for each file that is created per day.
  • Action Code. Is always P for payment.
  • Taxpayer TIN. The file extracts this from the Actions > Setup Clients screen.
  • Taxpayer PIN. The file extracts this from the Payment Preferences section of the Main tab of the Setup > Vendors screen for the 94X vendors.

Vendors screen payment preferences

  • Taxpayer Type. The type is generally B for business. However, if the client is set up as a Household type employer, the Taxpayer Type is I for individual.
  • Tax Type Code. The available tax types are 940, 941, 943, 944, and 945. For clients set up as a Household type employer, the tax type is 1040. The codes for each one are as follows:
  • Tax Period. This is the period for which there are liabilities. For 940, 943, 944, 945, and (for Household type employers) 1040 tax codes, the tax period is the year-end date of the liabilities. A separate file is create for each subsequent year for which there are liabilities. For 941 tax codes, the tax period is the quarter-end date of the liabilities. A separate file is created for each subsequent quarter for which there are liabilities.
  • Settlement Date. This is the due date of the liability. If you have marked the Use transaction date as settlement date checkbox in the Actions > Process EFTPS screen, then the settlement date is the check date that appears on the checks.
  • Payment Amount. This is the amount of the liabilities that appears on the checks.

Was this article helpful?

Thank you for the feedback!