ZenotiHelp

Memberships Payment Report β€” Invoice Age Brackets and Decline Reason Filter

ZTZenoti Docs Team Updated September 5, 2026 2 min readReference

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

  1. Open the Reports dashboard, type the report name in Search Report, and select Memberships Payment.
  2. The report loads with the default filter set applied.

Apply the Invoice Age filter

  1. On the report filter panel, locate the Invoice Age filter.

  2. 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
  3. 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

  1. On the report filter panel, locate the Decline Reason filter.
  2. Select the specific decline reason returned for failed payment attempts that you want to review.
  3. 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.
Was this article helpful?
Your feedback helps us improve our documentation.