EOD Posting File Lockbox A1.1

Lockbox Version A1.1 of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. Contact your Implementations Manager for further information.

File Name Standard: <Corporate ID> + <Account ID (without @ symbol)> + YYYYMMDD + “.txt”

  • Date is the processing date of the detail transactions
  • Report Group ID and Name are included only if End of Day File Groups are configured
  •  If End of Day File Groups are not configured, the Merchant ID is returned in the file name between the Corporate ID and date

Example: bWFR-WFR-WFR20100720.txt

Note: File only includes transactions that have a status of “Captured” or “Settled.”

File Format: Fixed Position, Fixed Width

FieldLocationTypeDescriptionComments
Header
Record Code1ANConstant Value = "H".
Capture Date2-9DTYYYYMMDD
Lockbox Number10-15ANZero FilledLockbox Number (last 6 characters of the Merchant ID, i.e., the "Merchant" or "M" of the MST)
Detail Record
Record Code1ANConstant Value = "D".
Capture Date2-9DTYYYYMMDDBusiness date of transaction same as header.
Check Number10-19NUMRight Justified/Zero FilledAll zeros if cash or card.
Paid Amount20-34NUMRight Justified/Zero FilledPaid Amount. If Negative, put negative sign on far left (e.g., 00000000000001).
No Decimal Point
Guarantor Account Number35-54ANGuarantor Account Number (Patient Account Number, If larger than 20 characters, take the last 20 characters).
Payment Source55-60NUMPayment Source (000001 - Cash, 000002 - Check, 000006 - American Express, 000007 - Discover, 000008 - Master Card, 000009 - Visa, 000010 - Other).
Payment Procedure61-66NUMDefault = "000001" or Transaction Code from payment form.
Patient Address 267-117Patient Address 2.
Trailer Record
Record Code1ANConstant Value = "T".
Total File Amount2-16NUMNo Decimal PointTotal File Amount, Negative Amounts have sign on far left (e.g., -00000000000001).
File Total Payment Count17-26NUMFile Total Payment Count.