Report: ACH Direct Deposit File Audit
Issue/Symptom/Question
Report: ACH Direct Deposit File Audit
Applies To
Penta for Windows
Payroll
Reference Manual
Reports
Resolution/Fix/Answer
Use the ACH Direct Deposit File Audit report to review the contents of the ACH Direct Deposit file. The Create ACH Direct Deposit file generation process creates this report. You can view it through Report Monitor, Print and View window.
Selection
The ACH file generation process creates this report based on Legal Entity OU ID and Check Date criteria specified in the Create ACH Direct Deposit File window.
Sort
Company/Batch Header records sort alphabetically by Company Name.
Detail records for each Company/Batch sort by Individual Identification Number, which in PENTA is Employee ID.
Totals
Totals print for:
Live Transactions – The number of direct deposits in the ACH file that are not Pre-Notifications.
Pre-Notifications – The number of pre-notification transactions in the ACH file. Pre-notifications are sent only with live transactions. If there are no live transactions to send, available pre-notifications will not be in the file.
Detail Items – The number of Live Transactions plus the number of Pre-Notifications.
Dollars – The monetary amount of all Live Transaction.
File Contents
File Header Record
Record #1 in the ACH file is the File Header Record.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains a 1 that identifies the record as the File Header. |
Priority code | 2 | Contains 01, currently the only value approved by ACH. |
Immediate Destination | 10 | 9-digit number from the Immediate Destination field in the PENTA Direct Deposit Transmission window, preceded by a blank. This is the routing number of the bank where you submit the direct deposit file. |
Immediate Origin | 10 | The number from the Immediate Origin field in the PENTA Direct Deposit Transmission window. This is either the routing number of the bank to which the file is being directly submitted or the Employer Identification Number. Numbers with fewer than 10 digits are right justified and blank filled. |
File Creation Date | 6 | The system date in yymmdd format. |
File Creation Time | 4 | The system time hhmm format. |
File ID Modifier | 1 | The File ID Modifier distinguishes multiple files created on the same date between the same participants. File ID Modifier values are numeric 0-9 and upper case A-Z. |
Record Size | 3 | Contains 094, currently the only value approved by ACH. |
Blocking Factor | 2 | Contains 10 per ACH requirements. The Blocking Factor defines the number of physical records within a block (a block is 940 characters). If the number of records within the file is not a multiple of 10, PENTA fills the remainder of the block with nines. |
Format Code | 1 | Contains 1, currently the only value approved by ACH. |
Immediate Destination Name | 23 | The name of the receiving financial institution associated with the Immediate Destination value in PENTA’s Direct Deposit Transmission window. |
Immediate Origin Name | 23 | The Immediate Origin Name associated with the Immediate Origin value in PENTA’s Direct Deposit Transmission window. |
Reference Code | 8 | This is reserved for bank use so is blank in PENTA’s file. |
Company/Batch Header Record
Multiple company/batch header records may exist in an ACH file. PENTA creates a record for each distinct LEOU specified in the Create ACH Direct Deposit File window.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 5 to identify the record as a Company/Batch Header Record per ACH requirements. |
Service Class Code | 3 | Contains 200 to indicate the ACH entries are mixed debits and credits. |
Company Name | 16 | Further identifies the source of the entry for descriptive purposes for the receiver (employee). PENTA enters the name of the LEOU for which the ACH file was created. |
Company Discretionary Data | 20 | Data significant only to the Originator. PENTA enters the LEOU and the check date for which the ACH file was created. |
Company Identification | 10 | Identifies the originator of the transactions. This value comes from the Organization Unit Maintenance window, Direct Deposit pop-up. The first digit is the Company ID Prefix. Remaining digits are the Company ID. A first digit of 1 indicates the number following is the IRS Employer ID Number; a first digit of 3 indicates the number following is the company DUNS Number; a first digit of 9 indicates the number following is a user-assigned number. |
Standard Entry Class Code | 3 | Identifies the type of transaction. PENTA codes payroll direct deposits as PPD (prearranged payment and deposit entry). |
Company Entry Description | 10 | Describes the purpose of the entry displayed to the receiver. In PENTA, this comes from the Entry Description field in the Create ACH Direct Deposit File window. |
Company Descriptive Date | 6 | The date the originator wants displayed to the receiver for descriptive purposes. In PENTA, this is the entry in the Descriptive Date field in the Create ACH Direct Deposit File window. Format is YYMMDD. |
Effective Entry Date | 6 | The date the originator intends to have the entries settled. In PENTA, this is the check date of the pay run. Format YYMMDD. |
Settlement Date | 1 | Blank as required by ACH. |
Originator Status Code | 8 | Identifies the ODFI initiating the entry. In PENTA, this is a 1 (per ACH requirements), which identifies the originator as a depository financial institution that agreed to be bound by ACH rules. |
Originating DFI Identification | 8 | The value in the Originating DFI ID field in PENTA’s Direct Deposit Transmission window. This is generally the routing number of the bank where you submit the direct deposit file. |
Batch Number | 7 | Ascending sequence number assigned to each batch within a file. In PENTA, each distinct Id in the Legal Entity OU Id column is identified as a batch within the file. |
Detail Records
One or more detail records exist for each Company Header / batch record in an ACH file. Each detail record represents a recipient (employee) deposit. If multiple checks with the same check date process for a single employee, a record per check appears in the ACH file.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 6 to identify the record as an Entry Detail Record per ACH requirements. |
Transaction Code | 2 | Identifies type of entry. Per ACH requirements, 22 indicates an Automated Deposit (live transaction) to a checking account; 23 indicates a Pre-notification transaction to a checking account; 32 indicates an Automated Deposit (live transaction) to a savings account; 33 indicates a Pre-notification transaction to a savings account. PENTA does not use other Transaction Codes. |
Receiving DFI Identification & Check Digit | 9 | Depository Financial Institution routing number including the check digit. This is the Bank Number entered on the Direct Deposit tab of the Employee Information window. |
DFI Account Number | 17 | Depository Financial Institution account number. This is the bank account number entered on the Direct Deposit tab of the Employee Information window. |
Amount | 10 | The amount of the deposit. This is the net amount of a check. |
Individual Identification Number | 15 | The number by which the recipient of the funds is known to the originator of the transaction. In PENTA, this is the Employee Id. |
Individual Name | 22 | Identifies the recipient of the funds. In PENTA, this is the Employee Name. |
Discretionary Data | 2 | PENTA leaves this position blank. |
Addenda Record Indicator | 1 | Indicates whether addenda records are present in the file. PENTA does not create addenda records so the value is 0. |
Trace Number | 15 | Uniquely identifies an entry within a batch in the ACH file. The number consists of the 8 digits in the Originating DFI ID field in the Direct Deposit Transmission Information window and a 7 digit Entry Detail Sequence Number. PENTA assigns the sequence number to individual transactions in ascending order to entries within a batch in an ACH file. |
Company/Batch Control Record
A control record for each Company/Batch Header Record exists in an ACH file.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 8 to identify the record as a Company/Batch Control Record. |
Service Class Code | 3 | Contains 200 to indicate the file contains mixed debit and credit ACH entries. |
Entry/Addenda Count | 6 | A count of the number of detail records associated with the company/batch. |
Entry Hash | 10 | A validation providing a check against inadvertent changes of file contents due to hardware failure or program error. Per ACH requirements, the hash is determined by summing the first 8 digits of the routing numbers associated with each individual employee deposit (e.g., 11111111 + 22222222 = 33333333) |
Total Debit Entry | 12 | The total of all Detail Record debit amounts in the company/batch. In the PENTA ACH file, this is always zero. |
Total Credit Entry | 12 | The total of all Detail Record credit amounts in the company/batch. Direct deposit payroll entries are credit entries. |
Company ID | 10 | Identifies the originator of the transactions. This value comes from the Organization Unit Maintenance window, Direct Deposit pop-up. The first digit is the Company ID Prefix. Remaining digits are the Company ID. A first digit of 1 indicates the number following is the IRS Employer ID Number; a first digit of 3 indicates the number following is the company DUNS Number; a first digit of 9 indicates the number following is a user-assigned number. |
Message Authentication Code | 19 | Per ACH requirements, this is an optional code. It is not provided in PENTA so the 19 related positions are blank. |
Reserved for Future Use | 6 | Blank as required by ACH. |
Originating Destination Financial Institution | 8 | The value in the Originating DFI ID field in PENTA’s Direct Deposit Transmission window. This is generally the routing number of the bank to which you submit the direct deposit file. |
Batch Number | 7 | The batch number of the company/batch header record associated with this control record. |
File Control Record
There is one File Control Record in an ACH file.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 9 to identify the record as a File Control Record. |
Batch Count | 6 | The number of Company/Batch Header records in the file. |
Block Count | 6 | The number of blocks in the file. A block is 940 characters, the equivalent of 10 records. |
Entry/Addenda Count | 8 | A count of the number of detail records in the file. |
Entry Hash | 10 | This Entry Hash is the last ten digits of the summation of each Company / Batch Control Record Entry Hash. |
Total Debits | 12 | The total of all Detail Record debit amounts in the file. In the PENTA ACH file, this is always zero. |
Total Credits | 12 | The total of all Detail Record credit amounts in the file. Direct deposit payroll entries are credit entries. |
Reserved for Future Use | 39 | Blank. |