Payment Export File Layout

The Payment Export file contains payment activity that can be imported in to the client's system. Below is the standard file layout.

Download a sample Payment Export file.

File Layout:

01 payment-record.
    03 record-id                 pic x(01).    *> 0-ACH PAID
                                               *> 1-CREDIT CARD PAID
                                               *> 2-ACH POSTDATED
                                               *> 3-CREDIT CARD POSTDATED
                                               *> 4-ACH REVERSAL
                                               *> 5-CREDIT CARD REVERSAL
                                               *> C-CANCEL POST DATED TRANSACTIONS
                                               *> T-TOTAL (see below for more information)
    03 account-number            pic x(32).
    03 debtor-last-name          pic x(20).
    03 debtor-first-name         pic x(20).
    03 payor-name                pic x(40).
    03 scheduled-date            pic x(08).    *> YYYYMMDD
    03 payment-amount            pic zzzz9.99  *> Zero surpressed, right-justified with explicit decimal
    03 department                pic x(15).
    03 sequence                  pic x(10).
    03 reversal-date             pic x(08).    *> YYYYMMDD
    03 reversal-reason           pic x(80).
    03 login-id                  pic x(32).    *> Login ID of user who entered the original payment
    03 entry-date                pic x(08).    *> Date transaction entered into system (yyyymmdd)
    03 entry-time                pic x(08).    *> Time transaction entered into system (hhmmssdd)

Total Record Layout

The payment export layout will contain a "Total" record. This record will summarize the activity in the payment file. You should use these numbers as control totals on any process you run. Download a sample Payment Export file.

Record Layout:

01 total-record.
    03 record-id                    pic x(01)         *> T-Total
    03 total-record-count           pic zzzzz9.       *> Count of all record types
    03 ach-paid-count               pic zzzzz9.       *> Count of ACH payment records
    03 ach-paid                     pic zzzzzzzz9.99. *> Total ACH paid dollars
    03 credit-card-paid-count       pic zzzzz9.       *> Count of CC payment records
    03 credit-card-paid             pic zzzzzzzz9.99. *> Total of CC paid dollars
    03 ach-postdated-count          pic zzzzz9.       *> Count of post-dated ACH records
    03 ach-postdated                pic zzzzzzzz9.99. *> Total of post-dated ACH dollars
    03 credit-card-postdated-count  pic zzzzz9.       *> Reserved for future use
    03 credit-card-postdated        pic zzzzzzzz9.99. *> Reserved for future use
    03 ach-reversal-count           pic zzzzz9.       *> Count of ACH reversal records
    03 ach-reversal                 pic zzzzzzzz9.99. *> Total of ACH reversal dollars
    03 credit-card-reversal-count   pic zzzzz9.       *> Count of CC reversal records
    03 credit-card-reversal         pic zzzzzzzz9.99. *> Total of CC reversal dollars
    03 cancel-postdated-count       pic zzzzz9.       *> Count of post-dated ACH cancel records
    03 cancel-postdated             pic zzzzzzzz9.99. *> Total of post-dated ACH cancel dollars

Sample Files

Download sample files:

Sample Payment Export File

Previous Versions

View previous versions of this record layout:

Version 1