Payment Deposit File 1.0

The deposit file lists out all transactions included in the ACH deposit(s) to a merchant account. A file is generated for each Merchant ID or Account ID. This includes Chargebacks, Returns, and Settlement Errors.

The Payment Deposit File can be sent in a zero byte configuration for testing purposes.

File Format: Piped Delimited with no header record.

Record ID: IMPDF10

File Name:

  • Payment Deposit File v1.0 Merchant ID Level : PaymentDepositReport-CCYYMMDD-MerchantID.txt
  • Payment Deposit File v1.1 Account ID Level: PaymentDepositReport-CCYYMMDD-CorporateID.txt
Field #Field NameFormatRequired?MinMaxComment
1Record ID"IMPDF10"Y77
2Merchant IDANY150The unique ID associated with your merchant processing account, which will be given by your Implementations Manager.
3Store IDANY150Default value is 1.
4Terminal IDANY150May differ by location (at no extra cost to the provider) to enhance security and reporting.
5Deposit ACH Trace NumberANY150ODFI + Trace Number
6Deposit Effective DateDTY1414Date/time in CCYYMMDDHHMMSS format.
7Payment Transaction TypeANY135Supported values are: "CreditCard," "eCheck," "DebitCard" and "Cash.
8Payment Transaction ActionANY135Supported values are: "AuthCapt," "Credit," and "Return"
9AmountDECOAlways positive decimal value. Payment Transaction Action = "Credit" should cause this field to be interpreted as a refund.
10Card TypeANO125This field is returned when the transaction type is CreditCard. Values include: "VISA," "MC," "AMEX," "DISCOVER" and "OTHER."
11Transaction IDANY150This is a unique ID assigned by InstaMed, e.g., "3c4fabfad61e47e4aa10b52529476529."
12Authorization NumberANS150
13Transaction DateDTY1414Date/time in CCYYMMDDHHMMSS format.
14Transaction Status CodeANY110Supported values are: "S" "CB" and "RI" representing settled, chargebacks and returns
15Consumer LastNameANO150
16Consumer FirstNameANO150
17Consumer MiddleNameANO150
18Consumer Account NumberANO150
19Consumer Address 1ANO1150
20Consumer Address 2ANO1150
21Consumer CityANO150
22Consumer StateANO130
23Consumer ZipCodeANO115
24AdditionalInfo1ANO1100User-defined fields captured with the payment transaction.
25AdditionalInfo2ANO1100See AdditionalInfo1 comments.
26AdditionalInfo3ANO1100See AdditionalInfo1 comments.
27AdditionalInfo4ANO1100See AdditionalInfo1 comments.
28AdditionalInfo5ANO1100See AdditionalInfo1 comments.
29AdditionalInfo6ANO1100See AdditionalInfo1 comments.
30UserANO1100May also include punctuation (e.g., "@" or "."). User performed original sale
31Transaction CodeANO150Note: Transaction codes are passed in the EOD Posting file rather than descriptions. Consult your Implementations Manager to configure Transaction Codes on your account.
32Market SegmentANO115See Market Segment Codes.
33Is SwipedANS11Supported values are: "Y" or "N" indicating whether the card was swiped or not.
34ConsumerServiceBeginDateDTO1414
35ConsumerServiceEndDateDTO1414
36Consumer Medical Record NumberANO150
37Consumer DOBDTO1414
38Consumer CountryANO150
39Consumer Phone NumberANO113
40Account/Card Holder Address 1ANO1150
41Account/Card Holder Address 2ANO1150
42Account/Card Holder CityANO150
43Account/Card Holder StateANO22
44Account/Card Holder ZipCodeANO515
45Account/Card Holder CountryANO150
46Account/Card Holder Phone NumberANO113
47Account/Card Holder Email AddressANO150
48Estimated AmountDECO
49Reason CodeANO150
50Check NumberANO150
51Check Account TypeANO150Possible values are: checking, saving and business.
52Taken At Merchant IDANO150
53Taken At Store IDANO150
54Taken At Terminal IDANO150
55AdditionalCode 1ANO1100
56AdditionalCode 2ANO1100
57AdditionalCode 3ANO1100
58AdditionalCode 4ANO1100
59AdditionalCode 5ANO1100
60AdditionalCode 6ANO1100
61Processing MIDANC150Only required if account is using file version 1.1 with Account Level Deposit consolidation.
62Field62ANO1100Original Payment Transaction ID
63Field63DECOEffective Amount
64Field64ANO1100Reserved for future use.