Projected payments report

The Projected Payments report gives you information about the billing events that BillPro will process. This report describes billing events that are scheduled for subscription, instalment, and metered orders.

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

This report includes billing events for orders that have a status of Active (where the last payment or card registration was approved) or Failed (when the last billing event failed with a soft-decline).

This report does not include retries of payments that failed with a soft-decline.

You can customise the Projected Payments report to display payments using the following filters.

Date Range - If no start or end date are selected, it 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.
ZUID, which is the unique order ID created by BillPro.
Order Type, which can be Instalment and Subscription purchase types. See Purchase types
Currency, which can be any of the acceptance currencies of your merchant.
Order Status, which can be Active and Failed. There is an option for Paused orders, but there are no scheduled billing events for paused subscriptions, so there will never be any records in the report for this option.

The Projected Payments report contains the following fields.

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

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

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