ZenotiHelp

Memberships payment report

ZTZenoti Docs Team Updated November 3, 2026 2 min readReference

The Memberships Payment report tracks payment collection details for recurring memberships, including amounts collected, outstanding balances, payment failures, and waived amounts.

Navigation: Open the Reports dashboard, type the report name in Search Report, and select Memberships Payment.

Permission: Memberships Payment Report (under Marketing) — Required to open this report. Find it in the Reports(V2) section of the role.

This report can be viewed at the center level or rolled up across the organization, depending on the Sale Center filter selection.


Before you begin

  • The Enable V2 Membership Reports organization setting must be on for your organization. If it is off, the V2 membership reports do not appear for any role.

Steps

Access the Memberships Payment report

  1. Navigate to Reports and search for Memberships Payment.
  2. Select the report from the results.
  3. Configure the filters as needed (see Filter criteria below).
  4. Review the results grid and footer totals.

To export the report data, select Export to Excel or Export to CSV from the export options above the grid.

Filter criteria

The following filters are available on the Memberships Payment report filter panel. Open the filter panel, configure your selections, and select Show results to apply.

Filter Description
Sale Center Select one or more centers to include in the report.
Start Date / End Date The report period date range.
Categories Filter by membership category.
Statuses Filter by membership status.
Recurrence Statuses Filter by recurring payment status.
Membership Names Filter by specific memberships.
Membership Types Filter by type (Recurring, Non-Recurring, Setup Fee, Annual Fee).
Payment Type Filter by payment method (Credit Card, ACH (Automated Clearing House), Check).
Hard Decline Only When selected, shows only hard-decline records.
Bulk Charge Only When selected, shows only bulk-charged records.
Partial Payment When selected, shows only partially paid suspended memberships.
Show Cancelled Collections When selected, includes cancelled collections in the results.
Invoice Age Filter by the number of days the invoice has been outstanding.
Waived Benefits Type Filter by waived benefit type.
Reasons Filter by waive or cancel reason.

Column descriptions

Column Description
check_box Checkbox to select one or more rows for a bulk action.
Sale Center Center where the membership was sold.
Invoice# Billing cycle invoice number.
Membership Code Unique identifier for the membership.
Membership Name Name of the membership sold.
Membership Type Recurring, Non-Recurring, Setup Fee, or Annual Fee.
Guest Name Name of the member.
Sale Date Date the membership was sold.
Due Date Payment due date.
Collection Date Date the payment was collected.
Sales (Exc. Tax) Billed amount excluding tax.
Sales (Inc. Tax) Billed amount including tax.
Amount Collected Amount actually paid.
Due Outstanding amount owed.
Next Attempt Date Date of the next scheduled collection attempt.
Recurrence Cycle # Indicates the installment number in a recurring billing sequence.
Recurrence Status Status of the recurring billing cycle.
Collection Status Current status of the payment collection (Scheduled, Active, Failed, Cancelled).
Default Payment Type Payment method configured as the default for the membership.
Payment Type Payment method used for this collection.
charge Action to charge the outstanding due amount.
waive Action to waive the outstanding due amount.
cancel Action to cancel the collection.

The report footer displays totals for: Sales (Exc. Tax), Sales (Inc. Tax), Amount Collected, Due, and Amount Waived.


Was this article helpful?
Your feedback helps us improve our documentation.