Projected Revenue Report

The projected revenue report is a sales report that shows the expected revenue for a given time period. This report takes into account all auto-renewal payments and auto-payments scheduled for the selected date range. Purchase Options sold individually, Purchase Options sold as part of a package, and installment plan payments will be included in this report.

For example, if you have five $100 auto-payments that are scheduled for the current week, your Projected Revenue Report will show each auto-payment, with a total projected revenue of $500 for the week.

Note If a Purchase Option has a duration that is longer than one month, this report will only display payments that are scheduled to take place before the Purchase Option’s auto-renewal date. The report will also display all future auto-renewal payments. For example: A client purchases an auto-renewing 12-month membership with monthly payments on January 1st, 2018. The Projected Revenue Report will only display monthly payments up to the auto-renewal date, January 1st, 2019. The report will also display the auto-renewal payment scheduled on January 1st, 2019 and the yearly auto-renewal payments for every January 1st in the future. When the auto-renewal payment scheduled for January 1st, 2019 is processed, all monthly payments until January 1st, 2020 will be displayed.
This article describes how to view the Projected Revenue Report, and provides details of the columns that appear in the report. To learn how to customize and filter the report, see Viewing a report.

In this article:

    To view the Projected Revenue Report:

    1. Click the App Drawer button .
    2. In the App Drawer, click Reports.
    3. On the Reports menu, click Sales.
    4. On the Sales menu, click Projected Revenue. The Projected Revenue Report is displayed.

    Headings in the Projected Revenue Report

    Heading Description
    DATE The scheduled date of the payment.
    CLIENT The client who is expected to make the payment. Relevant details about this client, such as pass status, waiver status, contract status, special notes, unpaid visits, and account balance will be noted here by small icons. Hover over any icon to learn more.
    PURCHASE The name of the Purchase Option being paid for. If the payment is part of an installment plan, this field will be marked as Installment Plan.
    LOCATION The location to which the revenue from the payment will be assigned.
    AMOUNT The total amount of the payment, including taxes and discounts.
    PAYMENT TYPE The payment method that will be used to make the payment.
    REVENUE CATEGORY The revenue category under which the payment is categorized.
    ACTION Click the More button in this column to open the menu. From the menu, select View Details to view the payment details in the client’s profile. If the payment has been completed, you can select Refund to refund the payment.

    Advanced filters in the Projected Revenue Report

    Filter Description
    Locations Use this filter to determine which business location(s) to include in the report.

    You can also use this filter to view purchases clients are making online. For example, if one of your business locations is named Location A, there will be both a Location A filter and a Location A Online filter available. The Location A filter will filter for sales made by staff members who are signed into Location A and purchases made through the Achieve Client App by clients whose home location is Location A. The Location A Online filter will filter for purchases made through the Client Web App by clients whose home location is Location A.

    Appointments Purchase Options Use this filter to determine which Appointments Purchase Options to include in the report. Appointments Purchase Options are Purchase Options with the Appointments Purchase Option Service Category.
    Gym Purchase Options Use this filter to determine which Gym Purchase Options to include in the report. Gym Purchase Options are Purchase Options with the Gym Visits Purchase Option Service Category.
    Revenue Categories Use this filter to determine which sales to include in the report based on the revenue categories they are classified under.
    Groups Use this filter to determine which clients to include in the report based on their client group.
    NoteThis filter will pull any relevant information from the available fields. For example, if you filter for groups a, b, and c, the filter will find clients from group a, group b, group c, and any combination thereof, as opposed to only finding clients who belong to all three groups.
    Class & Events Purchase Options Use this filter to determine which Class & Events Purchase Options to include in the report. Class & Events Purchase Options are Purchase Options with the Class/Events Purchase Option Service Category.
    Was this article helpful?
    (50 out of 50 people found this article helpful)
    Still need help? Contact us
    Cancel