Processed payments report

The Processed Payments report gives you information about all the transactions that have been processed for all purchase types.

To create and download this report, see the instructions at Create and download reports.

You can customise the Processed Payments report to display selected transactions using the following filters.

Date range. If no start or end date are selected, the report includes payments from any time. If you try to process too much data, errors can occur in report generation. If you experience issues, try reducing the time period included in the report.
Order Type, which is the same as the purchase type. See Purchase types
Currency, which can be any of the acceptance currencies of your merchant.
Payment Type, which can be Initial or Repeated.
Transaction Type, which can be DB for Debit, RF for Refund, and RG for Register a card and replace it with a token ID.
Payment Result, which can be Approved, Soft Declined and Hard Declined.

The Processed Payments report contains the following fields.

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. This 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	When the billing event was executed as a date and time in UTC format
Schedule Payment ID	Unique ID created by the system for a billing event in an order with recurring payments. When BillPro retries a payment, the retries will have the same Scheduled Payment 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 codes are the ones for 3D secure and external bank or payment systems. See Result codes for rejected transactions
Payment Status	The status of the payment billing event, which can be `Approved`, `Soft-declined`, `Hard-declined`. If the billing event is soft-declined, you can retry it up to 15 times within 30 days of the soft-decline. If it is hard-declined, you cannot retry it.
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 amount of the payment in 3-digit ISO 4217 format, e.g. `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	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

You can download the report as a CSV file, and the file name has the format 000_ProcessedPayments_MerchantName_DDMMYYYY.csv.

To create and download this report, see the instructions at Create and download reports.