Package payments report
The Package Payments report provides visibility into payment collection status for package purchases and scheduled payments. Use this report to track pending collections, review payment failures, and process bulk charges for scheduled installments.
On this page
- Before you begin
- Filter criteria
- Column descriptions
- Bulk charge operations
- Grouping options
- Footer aggregations
- Related articles
Before you begin
Permission: Packages Payments Report under Marketing in the Reports(V2) section of the security role — required to open this report.
- Select the centers for which you want to run the report.
Filter criteria
| Filter | Description |
|---|---|
| Date range | The start and end dates for the report period. |
| Date type | Determines what the date range filters against (collection date, scheduled date, etc.). |
| Centers | One or more centers to include in the report. |
| Categories | Filter by one or more package categories. |
| Statuses | Filter by payment status (Collected, Pending, Failed, Refunded). Leave blank for all statuses. |
| Packages | Filter to specific packages. |
| Invoice | Filter by a specific invoice. |
| Guest | Filter to a specific guest. |
| Group column | Select a grouping dimension to aggregate results. |
Column descriptions
Each row represents a single payment record associated with a package purchase or scheduled collection.
| Column | Description |
|---|---|
| PackageName | The name of the package program. |
| GuestName | The full name of the guest. |
| CenterName | The center where the payment was processed. |
| CollectionDate | The date the payment was collected or is scheduled. |
| CollectionAmount | The payment amount collected or due. |
| PaymentStatus | The status of the payment (Collected, Pending, Failed, Refunded). |
| PaymentMode | The payment method (Credit Card, ACH (Automated Clearing House), Cash, etc.). |
| InvoiceNumber | The invoice number associated with the payment. |
| ScheduledDate | The originally scheduled collection date. |
| AttemptCount | The number of collection attempts made. |
| FailureReason | The reason for payment failure, if applicable. |
Bulk charge operations
The Package Payments report supports bulk processing of pending scheduled collections:
- Filter the report to show Pending payment statuses.
- Use the select-all checkbox in the header to select all pending payments, or use per-row checkboxes to select specific payments.
- Click Bulk Charge to process all selected payments at once.
Note: Zenoti processes each selected payment in turn and updates the status accordingly. Review the report after the run completes to confirm the results.
This feature is useful for processing scheduled installments that are due for collection.
Grouping options
Use the Group column filter to aggregate payment data by dimensions such as center, package, or guest. Grouped views show subtotals for each group.
Footer aggregations
Numeric columns (CollectionAmount, AttemptCount) display sum totals in the footer row.