Memberships Payment Report β Invoice Age Brackets and Decline Reason Filter
The Memberships Payment Report (V2) helps you monitor the collection status of recurring membership invoices. This article explains how to use the Invoice Age and Decline Reason filters to narrow results to specific ageing brackets or failed-payment decline reasons.
Audience: Administrators and finance staff who review recurring membership collection activity.
On this page
Before you begin
Your organization must have at least one active recurring membership with invoices generated.
You need the following permission to view this report:
Permission: Memberships Payment Report (under Marketing) β Required to open the Memberships Payment report (V2). Admin path: Configuration > Security > Security roles > [your role] > Reports(V2) > Marketing > Memberships Payment Report
Steps
Open the report
- Open the Reports dashboard, type the report name in Search Report, and select Memberships Payment.
- The report loads with the default filter set applied.
Apply the Invoice Age filter
On the report filter panel, locate the Invoice Age filter.
Select one or more ageing brackets to include in the results:
Bracket What it shows 0β30 days Open invoices where the invoice date is within the last 30 days 31β60 days Open invoices where the invoice date is 31β60 days old 61β90 days Open invoices where the invoice date is 61β90 days old 90+ days Open invoices where the invoice date is more than 90 days old Collected Invoices that have been successfully collected Click Refresh to update the report grid.
Tip: Select Collected alongside an ageing bracket to compare outstanding invoices against recently collected ones for the same period.
Apply the Decline Reason filter
- On the report filter panel, locate the Decline Reason filter.
- Select the specific decline reason returned for failed payment attempts that you want to review.
- Click Refresh to update the report grid.
Note: The Decline Reason filter is populated from the decline codes returned by the payment processor for failed collection attempts. The available values depend on the payment methods and processors configured for your organization.
Clear filters
To reset the report to its default view, clear your filter selections and click Refresh.
Filter criteria
The following filters are available on the Memberships Payment Report (V2). This article covers the two filters listed below. Other filters on the report panel are described in the main Memberships Payment Report article.
| Filter | Description |
|---|---|
| Invoice Age | Filters results by the ageing bracket the open invoice falls into. Available brackets: 0β30 days, 31β60 days, 61β90 days, 90+ days, and Collected. |
| Decline Reason | Filters results by the specific decline reason returned for failed payment attempts. |
Column descriptions
The report grid includes the following columns relevant to invoice ageing and decline activity. Additional columns are described in the main Memberships Payment Report article.
| Column | Description |
|---|---|
| Invoice Age | The ageing bracket the invoice falls into based on the invoice date. |
| Decline Reason | The decline reason code returned by the payment processor for the failed collection attempt. |
| Sales (Exc. Tax) | The membership collection amount excluding tax. |
| Sales (Inc. Tax) | The membership collection amount including tax. |
| Recurrence Cycle # | The recurring billing cycle number the invoice corresponds to. |