ACH file: Entry detail record for tax deposits

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

Each tax deposit included in the Company/Batch Header Record of an ACH file includes one Entry Detail Record with the following information (position numbers are listed in parentheses):

Field Name Contents (and position numbers)
Record Type Code

The numeral 6. (01-01)

Record Type Code, example
Transaction Code

Determined by the nature of the transaction and the contents of the Checking/Savings field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). (02-03)

The possible entries are:

  • 22, Checking Credit Live
  • 23, Checking Credit Prenote
  • 27, Checking Debit Live
  • 28, Checking Debit Prenote
  • 32, Savings Credit Live
  • 33, Savings Credit Prenote
  • 37, Savings Debit Live
  • 38, Savings Debit Prenote
  • 52, Loan Credit Live
  • 53, Loan Credit Prenote
Transaction Code, example
Receiving DFI Identification

The nine-digit bank routing number associated with the ID entered in the Deposit Bank ID field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). (04-11)

Receiving DFI Identification, example
Check Digit

Based on the nine-digit bank routing number associated with the ID entered in the Deposit Bank ID field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). The check digit is verified at entry time. (12-12)

Check Digit, example
DFI Account Number

The number entered in the Deposit Account # field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). (13-29)

DFI Account Number, example
Amount

The amount entered on Display UAPUAD or calculated by the application. (30-39)

Amount, example
Individual Identification Number

If the Mark to use SSN/EIN field is marked, contains the relevant SSN or EIN (as indicated on the Direct Deposit tab of the File > Client Properties dialog.

If the Mark to use employee/agent number field is marked, contains the relevant employee ID or agent ID (as indicated on the Direct Deposit tab of the File > Client Properties dialog.

If neither option is selected, remains blank.

If this is an EFTPS tax deposit, the information comes from the Payer ID# (For EFTPS only) field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). (40-54)

Individual Identification Number, example
Individual Name (PPD)/Receiving or Company Name (CCD)

Contains the depositor name associated with the transaction.

If this is an EFTPS tax deposit, the information comes from the Payer Name field (as entered on the Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transactions Files dialog). (55-76)

Individual Name (PPD)/Receiving or Company Name (CCD), example
Discretionary Data

Completed by the bank that receives the ACH file. (77-78)

Discretionary Data, example
Addenda Record Indicator

The numeral 1. (79-79)

Addenda Record Indicator, example
Trace Number

Based on the bank routing number associated with the ID entered in the Originating DFI Bank ID field (as entered on the Direct Deposit tab of the File > Client Properties dialog. A 15-digit field in which positions 1-8 are the first eight digits of the originator's routing number, and positions 9-15 are the current total of records within the Company/Batch Header Record. (80-94)

Trace Number, example

See also

ACH file structure and contents

Direct Deposit tab of the File > Client Properties dialog

Tasks > Discretionary Tax Payments dialog of the Maintain Electronic Transaction Files dialog

Share This