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 Name	Description
Company Name	Name of the shopper's company.
Country	Country where the shopper resides.
Date Created	Date the transaction was initiated.
Date Modified	Date that the status was updated from Pending to Approved or Canceled.
Description	Reason a transaction was canceled or refunded. If status is not Canceled or Refunded, this field is blank.
Invoice ID	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 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 ID	Unique value sent by the merchant with a transaction request.
Name	Shopper name.
Payout Cycle	Value of the Payout ID
Shopper ID	Unique value assigned to each shopper by BlueSnap.
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

Status
Time Period
Vendor/Affiliate

Updated 29 days ago