Daily Summary Report: Revenue and Sales Summary

The Revenue and Sales category of the Daily Summary report gives you details of the following:

  • Projected Monthly Revenue
  • Amount collected from new and existing members
  • Revenue details (both collections and redemptions)
  • Modified and open Sales details

Table of Contents

Important Notes:

For the Revenue Summary, you must be aware of the following:

  • There are two scenarios when revenue is realized:
    • Payments: Revenue is realized when the amount for the service, class, or product is collected in the form of Cash, Card, Check, or Custom Payments.
    • Redemptions: Revenue is realized when guests redeem memberships, packages, gift cards, or pre-paid cards to purchase services, classes, or products.
      Important: Revenue is not realized on the immediate purchase of memberships, packages, gift cards, or pre-paid cards. The revenue is only realized if they are used to pay for services or products.
  • Invoices: Only Closed invoices are considered.
  • Payment Types: Redemptions (memberships, packages, gift cards, or pre-paid cards), Cash, Card, Check, and Custom Payments.
  • Day: Revenue is recognized the day on which the invoice is closed.
  • Discounts: Includes discounts.
  • Tax: Excludes taxes.

For the Sales Summary, you must be aware of the following:

  • Invoices: Only Closed invoices are considered unless Zenoti is configured to consider Open invoices as well.
  • Payment Types: Only sales realized through Cash, Card, Check, and Custom Payments are considered.
  • Day: The day on which the sale is reported varies as follows:
    • Services and Classes: The day on which the actual service or class took place and not the date on which the service was booked or the invoice was closed. 
      Example: If a guest books an appointment on 10th, avails a service on 11th but makes the payment on 12th and the front office closes the invoice (on 12th), the sale of the item (in this case, service) is reflected on 11th in Zenoti reports.
    • All other items: The sale of all other items (products, memberships, packages, gift cards, and pre-paid card) is reflected on the day the item was sold.
      Example: If a guest purchases a membership on 11th, but makes the payment on 12th, the sale of the item (in this case, membership) is reflected on 11th in Zenoti reports.
  • Discounts: Includes discounts
  • Tax: Excludes taxes

 

Field Descriptions

Consider the screenshot below:

The following are the entries in this category and explanation of the values:

Field Reading the Value Additional Information
Projected Monthly Revenue

This field displays the projected revenue for the month based on the collections till the selected date.

Example

In the screenshot, the value reads 46,6999. 

  • This means the projected revenue for the month is $ 46,6999.
  • You can validate the Projected Monthly revenue using the Month Revenue column in the Center Revenue report (Reports > Daily Reports > Center Revenue).
  • To derive the Projected Monthly revenue, do the following:
    1. Make a note of the Month Revenue on the selected date.
    2. Divide the Month Revenue by the selected date. You will arrive an average of daily revenue.
    3. Multiply the average of daily revenue by the number of days in the month. You will have your projected monthly revenue.
  • Example: If the Month Revenue value on 11th of November is 17,123.04, then:
    • Average Daily Revenue = 17,123.04/11 =  1556.64
    • Projected Monthly Revenue = 1556.64 * 30 = 46,669.20 (Avg Daily Revenue * no of days of in month)
Total Collected

This section displays the total amount collected through new and existing guests.

Example

From the screenshot, the interpretation of fields is as follows:

  • New Guests: This is the amount collected on the selected date from guests visiting your center for the first time.
    From the screenshot, $ 398.95 has been collected from new guests on the selected date.
  • Existing Guests: This is the amount collected on the selected date from guests who have visited your center before.
    From the screenshot, $ 1,188.87 has been collected from existing guests on the selected date.
  • The total collected amount for New and Existing guests is inclusive of tax.
  • If you add the total collected amount of New and Existing guests, it should match the Total field of the Collections category of the Daily Summary Report.
Total Revenue

This section displays the revenue realized from the following:

  • Collections:  Collected in the form of Cash, Card, Check, or Custom Payments
  • Redemptions: Redemptions of memberships, packages, gift cards, or pre-paid cards to purchase services, classes, or products.

Example

From the screenshot, the interpretation of fields is as follows:

  • Collection: $ 659.30 has been collected on the selected date either through Cash, Card, Check, or Custom Payments.
  • Redemptions: $ 1,041.62 is the value of memberships, packages, gift cards, or pre-paid cards redemptions.

 

  • You can validate the Collections by adding the Service Revenue and Product Revenue columns in the Center Revenue report (Reports > Daily Reports > Center Revenue).
  • You can validate the Redemptions by adding the Membership Redemption,  Membership Credit Redemption, Membership Service Redemption, Package Redemption, Gift Card Redemption, and Prepaid Card Redemption columns in the Center Revenue report (Reports > Daily Reports > Center Revenue).
Sales Modified

This section displays the following for the selected date:

  • The number of payments made on old open invoices on the selected date (invoices that were created before the selected date and in an open state on the selected date).
  • Total amount received as payments for old open invoices.
  • Balance amount due for the sales made this month.

Example

From the screenshot, the interpretation of fields is as follows:

  • # Old Sales Modified: Displays the number of old open invoices for which payment is added on the selected date.
    From the example, 1 invoice was updated with the payment.
  • Old Balance Paid: Displays the amount received as payments for old open invoices on the selected date.
    From the example, $ 62.00 was received as payment.
  • Unpaid Balance for Month: Displays the total amount yet to be collected for the sales made this month.
    From the example, $ 799.87 is the outstanding amount to be collected.
  • After payment is made on old open invoices, it's not necessary for the invoices to be closed. 
  • The only criteria is that the invoice should have been created before the date you are running the report for and is in an open state when payment is made.
  • You can validate the # Old Sales Modified field from the Collections by Invoices report (Reports > Finance > Collections > Collections by Invoices (General)).
    1. Export the report to Excel.
    2. Filter the Invoice Date column and display only the dates prior to the date you are running the report.
    3. The resultant list gives you the number of old invoices that are modified.
Open Sales Details

This section displays the following for the selected date:

  • No. of open invoices on the selected date.
  • Total sales value of the open invoices.
  • Amount Paid and Amount Due

Example

From the screenshot, the interpretation of fields is as follows:

  • # Open Sales: Displays the number of invoices that are open on the selected date. From the screenshot, 2 invoices are in the open state.
  • Total Sales Value: Displays the total sales value of the open invoices. From the example, $ 119.98 is the value of the open sales
  • Total Paid Amount: Displays the amount paid by the guests against the open invoices. From the example, no amount was paid by the guests.
  • Total Due Amount: Displays the amount to be realized against the open invoices. From the example, $ 119.98 is the amount to be realized from the guests.

 

  • You can validate the Open Sales details using the Sales Reports - Invoices report (Reports > Finance > Sales > Invoices (General)).
  • Filter the Sales Reports - Invoices to consider only Open invoices.
    • The number of entries gives the number of open invoices.
    • Adding the Net Price and Total Tax columns gives the Total Sales Value. 
    • The Due column gives the Total Due Amount.
Total Manual Discount

This field displays the total amount entered by the front office in the Discount field of the Take Payment screen of all the invoices on the selected date.

Note

  • On the Take Payment screen, the front office can enter a discount value manually (applicable only if Allow adjustments to discounts is enabled at the organization level).
  • The discount offered manually is marked as Manual Discount in the Promotion column of the Sales Reports - Invoices report.

You can validate the Manual Discount details using the using the Sales Reports - Invoices report (Reports > Finance > Sales > Invoices (General)).

  1. Export the Sales Reports - Invoices to Excel.
  2. Filter the Promotion column by Manual Discount.
  3. Adding the values in the Total Discount field gives the total manual discount offered by the front office on the selected date.

See Also

Have more questions? Submit a request

Comments