The Membership Recurring Fees Forecast - Details report surfaces every membership renewal payment that the system will attempt to process today and onward. All Finance reports are in UTC (Coordinated Universal Time).
This report is useful for:
Generating a list of future, pending membership renewal payments.
This report will not:
Generate a list of membership renewal payments that the system should have attempted in the past.
Forecast potential discounts applied to the renewal fees.
Pulling up the Report
Navigate to Reports from the left panel > Finance > Membership Recurring Fees Forecast - Details > View.
Specify the time frame from the date picker (today to a future date or a future date to another future date).
Apply any additional filters.
Understanding the Report
The Membership Recurring Fees Forecast - Details report includes 13 data fields:
Each row represents a membership renewal payment scheduled for each membership contract (that a customer has on their account within the selected date range).
Active memberships with expiration dates will appear if they have future, pending renewal payments before the expiration date.
Frozen memberships will appear based on the renewal date calculated from their reactivation date.
Example: If a membership reactivates on the 22nd with a new renewal date on the 28th, selecting a date range up to the 29th will list it.
Future and pending renewals will appear regardless of freeze status.
Memberships in ding/payment failure will appear if they have future renewal payments that haven’t yet been attempted.
Example: A membership in ding with renewals on the 22nd will still appear in a report covering Feb 22nd–Mar 22nd, as the system will process payments as scheduled.
Cancelled, Done, and Terminated memberships, as well as memberships with failed renewal payments, will not appear.
Charge Date: The scheduled renewal payment process date.
Charge Time: The scheduled renewal payment time is based on the time zone of the membership's purchase location.
Customer Name
Membership Type: Name of the membership type that determines the usage of a membership contract.
Membership Contract: Name of the membership contract that determines the payment terms.
active
frozen
cancelled
terminated
payment_failure
ding_failure
done
pending_customer_activation
pending_start_date
Currency Code: The currency of the sold membership.
Forecasted Charge Amount: The amount of money scheduled to be charged at the Charge Date and Time.
Purchase Location: The studio location where the membership was sold.
Customer Email
Customer Phone Number
Customer ID: Customer's unique ID generated by the system.
Membership Instance ID: ID generated by the system.