ACH/Direct Debit Report
Returns a list of all ACH/Electronic Check, BECS Direct Debit, Pre-Authorized Debit, and SEPA Direct Debit transactions. Use this report to track the status of your invoices from Pending to Approved or Canceled. Data is delayed by approximately 1 hour.
Report Columns
Notes
- The report columns listed below with an asterisk (*) can be used to filter the results when you run the report.
- All reports show currency values in US format (i.e., 123,456.00) regardless of the currency being displayed.
| Column Name | Description |
|---|---|
| Company Name | The name of the shopper's company. |
| Country | The country where the shopper resides. |
| Date Created | The date transaction was initiated. |
| Date Modified | The date the status was updated from Pending to Approved or Canceled. |
| Description | The reason a transaction was canceled or refunded. If status is NOT Canceled or Refunded, this field will be blank. |
| Invoice ID | A unique value assigned by BlueSnap to each captured sale, refund, or chargeback. |
| Is Balance Funding | Indicates if the transaction added funds to an account balance. |
| Local Currency | 3-digit code of the currency charged to shopper. |
| Merchant Sales (local currency) | The order value less any VAT or Tax collected by BlueSnap. The value provided is in the local currency. |
| Merchant Sales (USD) | The order value less any VAT or Tax collected by BlueSnap. The value provided is in USD. |
| Merchant Transaction ID | A unique value sent by the merchant with a transaction request. |
| Name | The shopper name. For ACH transactions, this could be either an individual or company name depending if the shopper selected a consumer account or a business account. |
| Payment Type* | Direct Debit Payment Types: ACH / ECP, BECS Direct Debit, Pre-Authorized Debit, or SEPA Direct Debit. |
| Payout Cycle | value of the Payout ID |
| Shopper ID | A unique value assigned by BlueSnap to each shopper. |
| Status* | Approved, Canceled, Pending, or Refunded. |
| Transaction Type | Sale or Refund. |
| Vendor / Affiliate ID* | Applies to Marketplaces and Affiliates. A unique value assigned by BlueSnap to each marketplace vendor or affiliate. A value in this column means a vendor or affiliate is associated with a specific transaction. |
| Vendor / Affiliate Name* | Applies to Marketplaces and Affiliates. The name of the vendor or affiliate associated with a specific transaction. |
Parameter Names
- From date
- Payment Type
- Period
- Status
- To date
- Vendor/Affiliate
Updated 3 months ago