Collections - Recurring Memberships reports (v1)
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Audience: Marketing manager, finance administrator
The Collections - Recurring Memberships report shows recurring-membership billing attempts over a date range. The report has two variants β Details (one row per collection attempt) and Summary (one row per membership with rolled-up totals). Use it to track billing-attempt success rates, identify members in dunning, and audit the recurring-payment pipeline.
This is a legacy report available under the classic reporting framework. The V2 successors are Collections - Recurring Memberships (Summary) and Collections - Recurring Memberships (Detail).
Before you begin
Permission: This classic report is controlled by View Admin Reports in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions). Select the report-area action that applies to this report (for example Sales, Collections, Revenue, or Accounting). Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.
Run the report
- Click the Reports icon.
- Search for and select Collections - Recurring Memberships (Detail) or Collections - Recurring Memberships (Summary).
- Set the date range and filters.
- Click Refresh.
Column reference
Some columns appear only in the Details variant, others only in the Summary variant. Both variants share a common spine.
| Column | Detail | Summary | Description |
|---|---|---|---|
| Invoice no | yes | yes | Invoice on which the membership payment was collected. |
| Invoice date | yes | yes | Date the invoice was generated. |
| Membership code | yes | yes | Unique membership identifier. |
| Guest Name | yes | yes | Guest on the invoice. |
| Membership name | yes | yes | Membership product name. |
| Due Date | yes | yes | Date the payment was due. |
| Tried On | yes | yes | Date the collection attempt was made. |
| Attempts | yes | yes | Number of attempts so far. |
| Payment collected | yes | β | Amount collected on this attempt. |
| Remarks | yes | β | Whether the attempt succeeded or failed. |
| Sold by | β | yes | Employee who sold the membership. |
| Price | β | yes | Membership sale price. |
Columns
| Column | What it shows |
|---|---|
| Guest | The guest's name, linked to their profile. |
| Code | The membership's code. |
| Membership Name | The name of the membership, linked to its details. |
| Invoice No | The invoice number for the collection, linked to the invoice. |
| Sold By | The staff member who sold the membership. |
| Price | The price of the membership. |
| ContractValue | The remaining value of the membership contract based on the price and number of recurring billing cycles. This is blank if no collection attempts have been made yet. |
| DueDate | The date the payment was due. |
| CollectionDate | The date the payment was collected. |
| Attempts | The number of times the system has attempted to collect this payment. |
| Collection Status | The current status of the collection: Pending, Collected, Refunded, or Failed. |
| Payment(s) | The payment method(s) used for the invoice. |