Lockbox Payment Import Format
Before payments can be loaded from a file. the file data must be in a specific format. The format is delimited, With no header or trailer records. Each record must have 8 fields (7 commas). The fields are in the following order:
Customer Account Number
Payment Amount
Payment Type Code
Payment Date
Description (optional)
Apply to Invoice Number (if applicable)
Check Number (if applicable)
Batch (optional)
ACH (Export) File
The ACH file has a file header, batch header, detail records, credit record, batch trailer, file trailer, and padding lines if needed. The number of line in the ACH file will be divisible by 10, the padding will be added when needed to ensure that. The ACH file is a fixed length file
File Header
Field | Length | Details |
Record Type Code | 1 | 1 |
Priority Code | 2 | 01 |
Immediate Destination | 10 | Script setting. Left padded with spaces. |
Immediate Origin | 10 | Script setting. Left padded with spaces. |
File Creation Date | 6 | Format YYMMDD |
File Creation Time | 4 | HHMM |
FileID Modifier | 1 | A |
Record Size | 3 | 094 |
Blocking Factor | 2 | 10 |
Format Code | 1 | 1 |
Immediate Destination Name | 23 | Script setting. Right padded with spaces. |
Immediate Origin Name | 23 | Script setting. Right padded with spaces. |
Reference Code | 8 | Filled with zeros |
Batch Header
Field | Length | Details |
Record Type Code | 1 | 5 |
Service Class Code | 3 | 200 |
Company Name | 16 | Script setting. Right padded with spaces. |
Company Discretionary Data | 20 | Filled with spaces |
Company Identification | 10 | Script setting. Right padded with spaces |
SEC Code | 3 | Script setting |
Company Entry Description | 10 | Script setting. Right padded with spaces |
Company Descriptive Date | 6 | Format YYMMDD |
Effective Entry Date | 6 | Format YYMMDD |
Settlement Date Julian | 3 | Filled with spaces |
Originator Status Code | 1 | 1 |
Originating DFI Identification | 8 | File script setting. Right padded with spaces. |
Batch Number | 7 | Starts with 1 and is incremented for each batch. Left padded with zeros. |
Detail Record
Field | Length | Details |
Record Type Code | 1 | 6 |
Transaction Code | 2 | Possible values: 22 – Credit to Checking Account 27 – Debit to Checking Account 32 – Credit to Saving Account 37 – Debit to Checking Account |
Receiving DFI Identification | 9 | ABA Routing Number of the Epay Account. Left padded with zeros |
DFI Account Number | 17 | Bank Account Number. Right padded with spaces |
Amount | 10 | Amount. Two decimal places are included in the numbers. Left padded with zeros |
Individual ID Number | 15 | Filled with spaces |
Individual Name | 22 | FirstName + MiddleInitial + Last Name. Right padded with spaces. |
Discretionary Data | 2 | Filled with spaces |
Addenda Record Indicator | 1 | 0 |
Trace Number | 15 | Record Number in the batch. Left padded with zeros |
Credit Record
Field | Length | Details |
Record Type Code | 1 | 6 |
Transaction Code | 2 | Possible values: 22 – Credit to Checking Account 27 – Debit to Checking Account |
Receiving DFI Identification | 9 | Immediate Destination. Left padded with zeros |
DFI Account Number | 17 | Script setting: Bank Account Number. Right padded with spaces |
Amount | 10 | Sum of previous record amounts in the batch. Two decimal places are included in the numbers. Left padded with zeros |
Individual ID Number | 15 | Filled with spaces |
Individual Name | 22 | Script setting: Company Name + Credit. Right padded with spaces. |
Discretionary Data | 2 | Filled with spaces |
Addenda Record Indicator | 1 | 0 |
Trace Number | 15 | Record Number in the batch. Left padded with zeros |
Batch Trailer
Field | Length | Details |
Record Type Code | 1 | 8 |
Service Class Code | 3 | 200 |
Entry Addenda Count | 6 | Number of records in the batch. Left padded with zeros |
Entry Hash | 10 | Sum of the first 8 digits of ABA Routing Numbers in the batch. Left padded with zeros |
Batch Total Debit Dollar Amount | 12 | Sum of debit amounts in the batch. Two decimal places are included in the numbers. Left padded with zeros |
Batch Total Credit Dollar Amount | 12 | Sum of credit amounts in the batch. Two decimal places are included in the numbers. Left padded with zeros |
Company Identification | 10 | Script setting. Right padded with spaces |
Message Authentication Code | 19 | Filled with spaces |
Reserved | 6 | Filled with spaces |
Origination DFI Identification | 8 | Script setting. Right padded with spaces |
Batch Number | 7 | Starts with 1 and is incremented for each batch. Left padded with zeros. |
File Trailer
Field | Length | Details |
Record Type Code | 1 | 9 |
Batch Count | 6 | Number of Batches in the file. Left padded with zeros |
Block Count | 6 | Number of times the record count is divisible by 10. Left padded with zeros. |
Entry Addenda Count | 8 | Number of records in the file. Left padded with zeros |
Entry Hash | 10 | Sum of first 8 digits of ABA Routing Numbers in the file. Left padded with zeros |
Total Debit Amount in File | 12 | Sum of debit amounts in the file. Two decimal places are included in the numbers. Left padded with zeros |
Total Credit Amount in File | 12 | Sum of credit amounts in the file. Two decimal places are included in the numbers. Left padded with zeros |
Reserved | 39 | Filled with spaces |
File Padding lines
Field | Length | Details |
Filler | 94 | Filled with 9s |