Processed payments report
Report on all transactions
The Processed Payments report lists every transaction BillPro processed, for all purchase types, with its gateway result.
To generate it, see Create and download reports.
Filters
All filters are optional. You can pick more than one value in each list, except Payment Type.
- Date Range: when the payment was processed. See Date ranges.
- Order Type: the purchase type of the order. See Purchase types.
- Currency: the currencies set up for this profile.
- Payment Type: Initial or Repeated. Pick one, or leave it empty for both.
- Transaction Type: DB (debit), RF (refund) or RG (card registration). See Transaction types.
- Payment Result: Approved, Soft Declined or Hard Declined.
Columns
| Field | Description |
|---|---|
| Zing Unique ID | Unique identifier for the order created by the system |
| Order ID | Identifier for the order that can be entered by the user or automatically generated. On the Order Summary, this is the Invoice ID |
| Order Type | Purchase type of the order, which may differ from the purchase type in the payment configuration of the product if the product payment configuration is not locked. |
| Order Status | See Order status |
| Billing Cycle | Interval (time) between scheduled billing events |
| Payment Time Stamp | Date and time the payment was processed, in UTC |
| Schedule Payment ID | The BillPro ID of the billing event, for orders with recurring payments. Retries of a payment keep the same ID. |
| Result Description | Description of the response codes, which is the result of the attempt to authorise the transaction from the payment gateway. |
| Payment UID | Unique identifier of the transaction created by the gateway |
| Response Code | Response code for the transaction from the payment gateway. For full details, see Gateway documentation on result codes. If a transaction is declined, the most useful response codes are from 3D secure and external bank or payment systems. See Result codes for rejected transactions |
| Payment Status | The result of the payment: Approved, Soft-declined or Hard-declined. You can retry a soft-declined billing event up to 15 times within 30 days. You can't retry a hard-declined one. |
| Transaction Type | See Transaction types |
| Card Brand | The brand of the card, such as Visa or Master (for Mastercard) |
| Card Bin | The first six digits of the card number. |
| Last 4 | The last four digits of the card number. |
| Payment Type | The payment type of the billing event, which can be Initial or Repeated |
| Amount | The amount of the payment |
| Currency | Currency code of the payment, in ISO 4217 format, such as EUR |
| Customer ID | Identifier for the customer that was entered by the user or automatically generated by BillPro |
| First Name | Given name of the customer |
| Last Name | Family name of the customer |
| Email address of the customer | |
| Agent Email | Email address of the user that created the order |
| Channel Name | The name of the merchant where the payment was processed |
| Clearing Institute | The acquirer |
| Payment Source | The payment source can be PL for payment link or VT for virtual terminal. This field only applies to initial payments and card registrations. |
The file name has the format 000_ProcessedPayments_MerchantName_DDMMYYYY.csv.
Updated 30 days ago
Recommended reading
You can also view all processed payments on the dashboard and in the Payments section
Did this page help you?