Pay by Bank (Open Banking)

Returns a list of all Pay by Bank transactions. Use this report to track the status of your invoices from PENDING to ACCEPTED to APPROVED. Data is delayed by approximately 2 hours.

📘

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 NameDescription
Company NameName of the shopper's company.
CountryCountry where the shopper resides.
Date CreatedDate the transaction was initiated.
Date ModifiedDate that the status was updated from Pending to Approved or Canceled.
DescriptionReason a transaction was canceled or refunded.

If status is not Canceled or Refunded, this field is blank.
Invoice IDUnique value assigned by BlueSnap to each captured sale, refund, or chargeback.
Is Balance FundingIndicates if the transaction added funds to an account balance.
Local Currency3-digit code of the currency charged to the shopper.
Merchant Sales (Local Currency)Order value less any VAT or Tax collected by BlueSnap. This value is in the local currency.
Merchant Sales (USD)Order value less any VAT or Tax collected by BlueSnap. This value is in USD.
Merchant Transaction IDUnique value sent by the merchant with a transaction request.
NameShopper name.
Payout CycleValue of the Payout ID
Shopper IDUnique value assigned to each shopper by BlueSnap.
Status*Approved, Canceled, Pending, or Refunded.
Transaction TypeSale 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

  • Status
  • Time Period
  • Vendor/Affiliate