EOD Posting File Lockbox A v2

Lockbox A Version 2 of the EOD Posting File is known to work with several existing Patient Accounts Receivable. Specifically, this file when used will allow Member Payments to successfully post into Epic. Contact your Implementations Manager for further information.

File Name Standard: <Corporate ID> + <ReportGroupID> + “_” + <ReportGroupName> + “_” + 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

File Format: Fixed Position, Fixed Width

FieldLocationTypeDescriptionComments
Header
Record Code1ANConstant Value = “H”
Capture Date2-9DTYYYYMMDDBusiness Date for transactions
Lockbox Number10-15ANZero FilledLast 6 digits of Merchant ID. If EOD Posting File Groups are configured, the Merchant ID is replaced by the Report Group ID.
Detail Record
Record Code1ANConstant Value = “D”
Capture Date2-9DT – YYYYMMDDBusiness date of transaction, same as header
Check Number10-19NUMRight Justified/Zero FilledAll zeroes if cash or card
Paid Amount20-34NUMRight Justified/Zero Filled
Guarantor Account Number35-54ANPatient ID from payment form
Payment Source55-60NUMTender/Card Type
Payment Procedure61-66NUMDefault = “000001” or Transaction Code from payment form
Guarantor Account Number 267-86ANPatient ID from payment form. Default = Duplicate Value for original Guarantor Account Number field
Trailer Record
Record Code1ANConstant Value = “T”
Total File Amount2-16NUMNo Decimal PointSum total of all detailed transaction amounts
File Total Payment Count17-26NUMSum total of detail transaction count