Purpose

The Projected Recurring Payment Report enables club admins to view projected PT revenue for their club during future date ranges. This report combines the functionality of the ‘PT Scheduled Draft Report’ and the ‘Projections Report’, and has replaced both in Club OS’s ‘Reports’ section. Click here to learn more about accessing and scheduling reports.

Note: This report is designed for viewing future date ranges. However, it is also possible to view past date ranges if desired.

Report Details

The columns contained within the report are as follows:

• Invoice Date
• Attempt Date: Date of the successful billing attempt (if applicable)
• Location ID: The ID number of the AF location from which the invoice was generated.
• Invoice Number
• Member Name: The name of the member who owns the agreement.
• Agreement Name: The name of the purchased service agreement package.
• Agreement Renewal: The renewal type selected for the agreement (if one exists).
• Auto renew (uncommitted): Invoices are considered uncommitted if they are projected to generate after an agreement has auto renewed, either by  ‘Auto Renew - Term or ‘Auto Renew - Open’. Members can choose to cancel auto renewals of their agreements up to 30 days before the renewal date, therefore payment of the projected invoice is not guaranteed. The member has not committed to the payment by renewing the agreement.
• Note:  If an auto renewal date for an agreement is less than 30 days away, then the projected invoices for the renewed agreement will be placed into the ‘Expected (committed)’ field.
• Expected (committed): Invoices are placed within this field if their projected ‘Invoice Date’ falls within the agreement’s original term length, the agreement has renewed on a ‘Auto Renew - Term’ basis, or is within 30 days of renewing on a ‘Auto Renew - Open’ basis. The member is considered committed to paying the invoice.
• Status: The status of the billing attempt, such as ‘Paid’, ‘Not Paid’, ‘Pending’, etc.
• $ Collected: The payment collected for the invoice. The invoice payment populates the ‘$ Collected’ field once ABC sends a ‘Success’ or ‘Success Pending’ settlement response.
• Payment Profile: The payment profile used to pay the invoice (Cash/Check, Credit Card, Checking/Savings).
• Salesperson: The staff member listed as selling the agreement to the member.
• Trainer: The trainer assigned to the agreement.