Memberships payment report
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
- Navigate to Reports and search for Memberships Payment.
- Select the report from the results.
- Configure the filters as needed (see Filter criteria below).
- 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. |
Footer aggregations
The report footer displays totals for: Sales (Exc. Tax), Sales (Inc. Tax), Amount Collected, Due, and Amount Waived.