EOD Posting File Lockbox C

Lockbox Version C of the EOD Posting File is known to work with several existing Patient Accounts Receivable systems. The header record of this format includes an identifier for EOD Posting File Groups. Contact your Implementations Manager for further information.

File Name Standard: <BusinessDate> + <Account/Group/Outlet> + “.pmt”

  • File can be generated by Account, End of Day File Group or Outlet.

File Format: Fixed Position, Fixed Width

FieldLocationTypeDescriptionComments
Header
Account Identifier3-8ANRight Justified/Space FilledInstaMed EMC ID.
Group Identifier9-18ANRight Justified/Zero Filled (space filled if empty)EOD Posting File Group Name.
Total Number of Payments19-24NUMRight Justified/Zero FilledRefunds included in count.
Total Payment Amounts25-34NUMRight Justified/Zero Filled No Decimal PointTotal Amount = Total Sale Amount - Total Refund Amount.
Patient Payment Transaction Code35-39AN"P0000" or P.
Total Number of Adjustments40-45NUMAll Zeros.
Total Adjustment Amount46-55NUMAll Zeros.
Patient Adjustment transaction Code56-60ANAll Spaces.
Filler61-250ANAll Spaces.
Transaction Record
Record Type1-2ANConstant Value = "01".
Patient Account Number3-12ANRight Justified/Zero FilledIf PatientID is greater than 10 characters, map the first 10 characters.
Facility Indicator13ANUpper Case/Blank FilledPrefix for Patient Account Number.
Patient last Name14-28ANRight Justified/Space Filled
Patient First Name29-40ANRight Justified/Space Filled
Patient Middle Initial41ANRight Justified/Space Filled
Transaction Type42AN"P" = Payment, "A" = Adjustment.
Date Paid43-48DTYYMMDDBusiness date of transaction
Payment Amount Indicator49AN"0" for payments, "-" for adjustments.
Payment Amount50-59NUMRight Justified/Zero Filled No Decimal Point2 places assumed.
Payment Type60AN"C" = Credit Card , "A" = all other payment methods (e.g., check or cash).
Credit Card or Bank Account Owner Name61-100ANRight Justified/Space FilledCardholder Name if Payment Type = "C," otherwise Bank Account Holder Name if available.
Credit Card Type101-125ANRight Justified/Space Filled"AMEX," "VISA," "MASTERCARD," "DISCOVER" or "OTHER" when applicable.
Account Number126-129NUMRight Justified/Space FilledLast 4 digits of card if Payment Type = "C," otherwise last four digits of bank account, if applicable.
Confirmation Code130-159ANRight Justified/Zero FilledAuthorization Number if Payment Type = "C".
Transaction ID160-191AN32-character InstaMed Platform ID.
Filler192-250ANSpace FilledBlank.