Projected payments report

The Projected Payments report lists the billing events BillPro has scheduled for your orders with recurring payments.

To generate it, see Create and download reports.

The report covers orders with the Active or Failed status. Failed means the last billing event was soft-declined. Retries of soft-declined payments aren't included.

Filters

All filters are optional. You can pick more than one value in each list.

Date Range: when the billing event is due. Only today and future dates. See Date ranges.
Order UID: the unique BillPro ID of one order.
Order Type: Instalment or Subscription. See Purchase types.
Order Status: Active, Failed or Paused. Paused subscriptions have no scheduled billing events, so Paused on its own returns an empty report.

Columns

Field	Description
Zing Unique ID	The unique BillPro ID of the order, in the format `ZUID-0000`
Scheduled Payment ID	The unique identifier of the billing event created by BillPro.
Payment Status	The payment status, which is `scheduled`.
Customer ID	The identifier of the customer that was entered by the user or created by BillPro.
First Name	The given name of the customer.
Last Name	The family name of the customer.
Customer Email	The email of the customer.
Amount	Amount of the billing event.
Currency	Currency code of the payment, in ISO 4217 format, such as `EUR`
Order Type	The purchase type of the order, which can be `instalment` or `subscription` or `metered`.
Billing Cycle	The billing cycle of the order, which can be in days, months, or years. For example, 14 days.
Processing Date	Date and time BillPro will process the billing event, in UTC. For example, `2026-03-23 07:00:00 UTC`.
Order Status	Status of the order, which can be `Active` or `Failed`.

The file name has the format 000_ProjectedPayments_MerchantName_DDMMYYYY.csv.

Filters

Columns

Recommended reading