Deposit Details Report

The eCheck Deposit Details Report is a summary-level report of the funds deposited to your bank account during a particular day. The deposit amount is calculated using this method:
  • Total credits and debits (from the Funding Details Report).
  • Total credits and debits, minus total returns and chargebacks (from the Chargeback Details Report).
  • Total credits and debits, minus risk reserve, withholding, and other one-time adjustments.

Deposit Details Report Line Items

The Deposit Details Report contains these line items:
Category = Settlement
This line item depicts the funds transferred from your eCheck settlement account to your merchant bank account as part of the daily automated funding job.
Category = Manual funding
This line item depicts the funds transferred from your eCheck settlement account to your merchant bank account as needed outside of the daily automated funding.
Category = Deficit recovery
This line item depicts the funds transferred from your merchant bank account to your eCheck settlement account in order to recover any deficit in the balance caused by returns or chargebacks.
Category = Manual transfer from settlement account to reserve account
This line item depicts the funds transferred from your eCheck settlement account to your eCheck reserve account.
Category = Manual transfer from reserve account to settlement account
This line item depicts the Funds transferred from your eCheck reserve account to your eCheck settlement account.
The Deposit Details Report also includes line items for unscheduled activities such as these:
  • Funding
  • Deficit recovery
  • Fund transfers between your eCheck settlement and reserve accounts

Fields in the Deposit Details Report

This topic lists fields that appear in the eCheck Deposit Details Report. The fields are organized into these groups: Application, BillTo, Check, Funding, PaymentData, PaymentMethod, and Request.

Application Fields

Name
Name of an application applied to this request.
Field name in the report:
ApplicationName

BillTo Fields

Address1
First line of billing street address as it appears on credit card issuer's records.
Field name in the report:
BillTo_Address1
Address2
Additional address information.
Field name in the report:
BillTo_Address2
City
Billing address city.
Field name in the report:
BillTo_City
CompanyName
Name of customer's company.
Field name in the report:
BillTo_CompanyName
Country
Billing address country.
Field name in the report:
BillTo_Country
Email
Customer's complete email address.
Field name in the report:
BillTo_Email
FirstName
Billing customer's first name.
Field name in the report:
BillTo_FirstName
LastName
Billing customer's last name.
Field name in the report:
BillTo_LastName
Phone
Billing customer phone number.
Field name in the report:
BillTo_Phone
State
Billing address state.
Field name in the report:
BillTo_State
Zip
Billing address ZIP/postal code.
Field name in the report:
Bill_To_Zip

Check Field

BankTransitNumber
Bank transit number.
Field name in the report:
BankTransitNumber

Funding Fields

AdjustmentAmount
Amount of the adjustment made to the transaction amount.
Field name in the report:
AdjustmentCurrency
Currency of the adjusted transaction
Field name in the report:
AdjustmentCurrency
AdjustmentDescription
Description of the adjustment.
Field name in the report:
AdjustmentDescription
FundingAmount
Funding amount.
Field name in the report:
FundingAmount
FundingCurrency
Funding currency.
Field name in the report:
FundingCurrency
FundingDate
Funding date.
Field name in the report:
FundingDate
Status
Status.
Field name in the report:
Funding_Status

PaymentData Fields

Amount
Order grand total.
Field name in the report:
Amount
CurrencyCode
Payment currency code.
Field name in the report:
CurrencyCode
PaymentProcessor
Payment processor name.
Field name in the report:
PaymentProcessor
TransactionRefNumber
Transaction reference number.
Field name in the report:
TransactionReferenceNumber

PaymentMethod Fields

AccountSuffix
Last four digits of customer's payment account number.
Field name in the report:
AccountSuffix
AccountType
Account type. Possible values:
  • C
    : Checking
  • S
    : Savings
  • X
    : Corporate Checking
  • Y
    : Corporate Savings
Field name in the report:
AccountType

Request Fields

MerchantID
Merchant ID used for transaction.
Field name in the report:
MerchantID
MerchantReferenceNmber
Merchant's order reference or tracking number.
Field name in the report:
MerchantReferenceNumber
RequestID
Transaction request identifier.
Field name in the report:
RequestID
TransactionDate
Date of transaction.
Field name in the report:
RequestDate