ACH Direct Deposit File Audit Report
Issue/Symptom/Question
ACH Direct Deposit File Audit report
Applies To
Penta for Windows
Reference Manual
Resolution/Fix/Answer
Use the ACH Direct Deposit File Audit report to review the contents of the ACH Direct Deposit file. The Create AP ACH Direct Deposit file generation process creates this report. View or print it through the Report Monitor, Print, and View window.
Selection
The AP ACH file generation process creates this report based on Form Id and Check Date criteria specified in the Create ACH AP 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 Vendor 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. PENTA generates Accounts Payable pre-notifications with or without live transactions.
- 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 are submitting 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 as 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 the Direct Deposit Transmission window. |
Immediate Origin Name | 23 | The Immediate Origin Name associated with the Immediate Origin value in the Direct Deposit Transmission window. |
Company/Batch Header Record
Multiple company/batch header records may exist in an ACH file. PENTA creates a batch header record for each distinct Form Id specified in the Create AP ACH Direct Deposit File window and for each Standard Entry Class Code (CCD/PPD) applicable to records in the file.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 5 to identify the record as a Company/Batch Header Record as 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 and for descriptive purposes for the receiver (vendor). |
Company Discretionary Data | 20 | Data significant only to the Originator. PENTA enters the AP check form 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.
|
Standard Entry Class Code | 3 | Identifies the type of transaction. PENTA codes AP direct deposits as CCD (Corporate Credit or Debit Entry) for vendor transactions and as PPD (Prearranged Payment and Deposit Entry) for Accounts Payable payments made to employees (Vendors with Type 'E'). |
Company Entry Description | 10 | Describes the purpose of the entry the receiver will see. This comes from the Create AP ACH Direct Deposit File window’s Entry Description field. |
Company Descriptive Date | 6 | The date the originator wants displayed to the receiver for descriptive purposes. This is the entry in the Create ACH Direct Deposit File window’s Descriptive Date field. Format is YYMMDD. |
Effective Entry Date | 6 | The date the originator intends to have the entries settled. This is the check date of the pay run. Enter the date in YYMMDD format. |
Settlement Date | 3 | Blank as required by ACH. |
Originator Status Code | 1 | Identifies the ODFI initiating the entry. This is a 1 in PENTA, 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 the Direct Deposit Transmission window. This is generally the routing number of the bank to which you submit the direct deposit file. |
Batch Number | 7 | Ascending sequence number assigned to each batch within a file. PENTA identifies each distinct check form in the Form Id column 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 vendor payment. If you generate multiple checks with the same check date for a single vendor, PENTA generates one record per check in the ACH file.
Contents | Length | Description |
---|---|---|
Record Type Code | 1 | Contains 6 to identify the record as an Entry Detail Record as per ACH requirements. |
Transaction Code | 2 | Identifies type of entry. Per ACH requirements:
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 in the Direct Deposit pop-up in the Vendor Information window. |
DFI Account Number | 17 | Depository Financial Institution account number. This is the bank account number entered in the Direct Deposit pop-up in the Vendor Information window. |
Amount | 10 | The amount of the deposit. This is the net amount of a check. |
Individual Identification Number | 15 | Number used by the originator of the transaction to identify the recipient of the funds. In PENTA, this is the Vendor Id. |
Individual Name | 22 | Identifies the recipient of the funds. In PENTA, this is the Vendor Name. |
Discretionary Data | 2 | PENTA leaves this position blank. |
Addenda Record Indicator | 0 | 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. The sequence number is assigned—in ascending order—to individual transaction 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. As per ACH requirements, the hash is determined by summing the first 8 digits of the routing numbers associated with each individual vendor 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 accounts payable 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.
|
Message Authentication Code | 19 | Per ACH requirements, this is an optional code. PENTA does not use this code, 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 the 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 accounts payable entries are credit entries. |
Reserved for Future Use | 39 | Blank. |
Â