The Memberships Report displays all memberships (accounts), active and inactive. This is available for all clubs.   

Data Selections

• Club: the report content is limited to the club(s) selected
• Membership Status: the report content is limited to memberships based on status 
  • Active: Not expired and in one of the following statuses:
    • (P) Paid in Full
    • (A) Statement – Term
    • (B) Statement – Open End
    • (V) Credit Card – Term
    • (I) Credit Card – Open End
    • (E) EFT – Term
    • (F) EFT – Open End
    • (Z) Cancel Pending
  • Inactive:
    
    • (P) Paid in Full and expired
    • (Z) Cancel Pending and expired
    • (R) Returned
    • (C) Cancelled
• Payment Status: the report content is limited based on selection
  • All Memberships: all accounts are included
  • All Outstanding: only accounts with a past due balance (membership dues and/or add-ons) are included 
  • Membership Dues Outstanding: only accounts with a membership dues past due balance are included
  • Add Ons Outstanding: only accounts with an add on payments past due balance are included

Data Filters

• Valid Payment Information: the report content is limited to whether the payment on file is valid or not (payment information is marked invalid based on payment rejection reason) 

Data

Each row of the report represents an account

• Club: the ID of the client where the membership exists
• Club Name: the display name of the client where the membership exists
• Account Number: the account number for the reported membership/account
• Contract Status: the status of the membership/agreement
• Contract Type: either "Open-end" or "Term"
• Name: the first and last name of the buyer on the account
• Card Code: the offer code of the account 
• Email: the email address of the buyer on the account
• Cell Phone: the cell phone number of the buyer on the account
• Next Due Date:
  • If the club is on Invoice Based Billing, then this is the date the next invoice is due
    • If the account is paid in full and no renewal is present, this is blank
    • If the account is paid in full and a renewal is present, this is the date of the renewal
  • If the club is not on Invoice Based Billing, then this is the date the next payment is owed, or the oldest payment due date for past due accounts
• Recurring Dues Payment: the recurring dues payment for the account
  • If the dues payment was made in one lump sum upfront at sign up, then $0.00 is displayed
  • If the account had recurring dues payments but currently has no balance outstanding, then recurring dues payment amount is displayed
• Payment Frequency: the payment frequency of the recurring dues payment
  • If the dues payment was made in one lump sum upfront at sign up, "PIF" is displayed
  • If the account had recurring dues payments but currently has no balance outstanding, then the recurring dues payment frequency is displayed
• Last Payment Date: the date of the most recent payment that was made across dues, add-ons, and fees; credits (waivers) are excluded
• Oldest Outstanding Invoice: the date of the oldest outstanding invoice across dues, add-ons, and fees
• Days Past Due: number of days since the oldest outstanding invoice across dues, add-ons, and fees
• Membership Dues Outstanding: the total amount of dues that are outstanding on the account
• Add Ons Outstanding: the total amount of add-ons that are outstanding on the account, including return item fees and late fees
• Total Outstanding: the total amount outstanding across all dues, add-ons and fees; total of Membership Dues Outstanding and Add Ons Outstanding
  • This amount matches the past due amount shown on the member account page
• Remaining Dues Contract Balance: if the contract is a term contract, this is the total amount remaining to be collected in the future to satisfy the total contract amount; outstanding balance that is past due is excluded
  • If the contract is an open-end contract,$0.00 is displayed
• Remaining Add Ons Contract Balance: the total balance across all add-ons (sum of ‘Balance to Bill’) where the add on has a set term and has not rolled over to open end
  • If the all add-ons are open-end or have rolled over to open-end, $0.00 is displayed
• Total Outstanding Incl Contract Balance: the sum of Total Outstanding and Remaining Dues Contract Balance and Remaining Add Ons Contract Balance
• Valid Pay Info?: 
  • "Yes" if the account has valid, unsuspended payment information on file 
  • "No" if the account has invalid or suspended payment information on file; payment is considered invalid when it is rejected with a hard decline
• Rejection: if the account is past due and has recent rejections present, the most recent rejection is displayed, formatted as [Code] - [Reason] (e.g. 301 - Account Closed)

Data Summary

• Record Count: the count of records returned in the report after filters are applied
• Total Monthly Recurring Dues: the total monthly payment amounts across all accounts after payment amounts have been normalized using the following rules:
  • Monthly payment frequency: no normalization needed
  • Bi-weekly payment frequency: payment amount is multiplied by 26 then divided by 12
  • Weekly payment frequency: payment amount is multiplied by 52 then divided by 12
  • Bi-monthly payment frequency: payment amount is multiplied by 6 then divided by 12
  • Quarterly payment frequency: payment amount is multiplied by 4 then divided by 12
  • Semi-annual payment frequency: payment amount is multiplied by 2 then divided by 12
  • Paid in Full (PIF): no monthly payment is included
• Total Outstanding: the sum of the Total Outstanding column values across all rows after filters are applied
• Total Outstanding incl. Contract Balances: the sum of the Total Outstanding Incl Contract Balance column values across all rows after filters are applied