Daily summary report (v1)
Deprecated: This report is based on Version 1 (V1) reporting. Zenoti began phasing out V1 reports on July 31, 2025, and no longer accepts requests for enhancements or clarifications related to them.
Migrate to Version 2 (V2) as soon as possible. Contact your Customer Success Manager or Zenoti representative for the V2 equivalent.
Audience: Business owner, center manager, front-desk staff
The Daily summary report is a single dashboard that aggregates today's (or a date range's) sales, collections, register closures, revenue, guest activity, employee performance, and business-unit sales for a center. Open it once per day to see whether numbers are tracking, then drill into the underlying reports when something looks off.
This is a legacy report available under the classic reporting framework. It is one of the broadest V1 reports because it composes data from many specialized reports into a single view β every panel below has a dedicated V2 report that is the authoritative source for that data.
Data refresh: Real-time on Refresh. Each panel queries its underlying source at click time; numbers between panels are consistent only when the report is run in a single click (a long-open report can show stale values for one panel and fresh ones for another after multiple refreshes).
On this page
- Before you begin
- Run the report
- Panels
- Sales panel
- Collections panel
- Register closures panel
- Revenue and invoices panel
- Guests summary panel
- Employees summary panel
- Business unit sales summary panel
- Reconciliation matrix
- Tips
- Troubleshooting
- Related articles
Before you begin
- Your role must have View on the DailyReports row in the Administrator section of the security role. Classic report permissions are independent of the Reports(V2) permissions; a report a role cannot access does not appear.
Permission: This classic report opens on the daily-reports page, which is controlled by the DailyReports row in the Administrator section of the security role (Configuration > Security > Security roles > the role > Permissions) β select its View check box. Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.
Run the report
- Select the center for which you want to run the report.
- Click the Reports icon.
- On the Reports page, search for Daily Summary (display order 20 in the Admin category).
- Set the date range β
Todayis the default; you can extend it to multi-day for trend analysis. - Click Refresh.
To export, click the Excel or CSV icon. The export produces one row per panel column.
Panels
The report shows seven panels in order. Each panel below documents what it shows, the calculation rules that apply across all its columns, and the V2 report that is the authoritative source for the same numbers.
Sales panel
Sale amounts for the day or date range, grouped by item type.
Calculation rules (apply to every column in this panel):
Sale amount = List Price β Discounts. Taxes are NOT included in sales.- Only closed invoices are counted, unless the org-level setting
IncludeOpenInvoicesInSalesis on. - Cash, card, check, and custom payments are counted. Redemptions (gift cards, prepaid cards, loyalty points) do NOT count as sales β they are revenue realization only.
- For services and classes, the sale date is the date the service was performed or class conducted. For everything else, the sale date is the date the item was added to the invoice.
- Bracketed values next to a column indicate sold quantity (e.g.,
$240 (3)means three units sold for $240 total).
| Column | Description |
|---|---|
| Services / Products / Memberships / Packages / Gift Cards / Pre-paid Cards | Total sale amount collected for each item type. Items redeemed as part of a membership or package have sale quantity counted but contribute $0 to sales (no double-counting). |
| Total | Services + Products + Memberships + Packages + Gift Cards + Pre-paid Cards. |
| Products to Service % | Ratio of product-sale revenue to service-sale revenue. |
| Products to Total % | Products / Total Γ 100. |
| Average Service Value | Total / Number of services performed. |
| Average Product Value | Total / Number of products sold. |
| Average Invoice Value | Total / Invoice count. |
Authoritative source for each sub-category: Sales - Service, Sales - Product, Sales - Membership, Sales - Package, Sales - Gift Card, Sales - Pre-paid Card. Tally the Sale Value column in each of those against the corresponding Daily summary cell.
Collections panel
All payments received and all redemptions at the center for the day or date range.
Calculation rules:
- Collection amounts INCLUDE discounts and tax (unlike sales).
- Both open AND closed invoices are counted.
- Cash, card, check, and custom payments count as collections.
| Column group | Description |
|---|---|
| Cash / Card / Check / Custom | Total amount collected by each payment method. |
| Total | Sum of Cash + Card + Check + Custom. |
| Memberships / Gift Cards / Pre-paid Cards / Loyalty Points | Amount redeemed using each instrument. |
Authoritative source: Collections by invoices for payment-method totals; Collections by item type for the panel Total; the Collections by Transactions report (filtered by redemption type) for the redemption rows.
Register closures panel
Register-state summary for the day or date range.
| Column | Description |
|---|---|
| Closure time | Date and time the register was closed. |
| Cash | Total cash in the register (cash collection + opening balance). |
| Card / Check | Amounts collected by card and check. |
| Bank Deposit | Cash deposited in the bank. |
| Opening Balance | Cash available at center open. |
| Closing Balance | Cash available after the bank deposit. The closing balance becomes the next day's opening balance. |
Authoritative source: Register closure.
Revenue and invoices panel
Recognized revenue, projection, and open-invoice status.
Calculation rules:
- For revenue summary: collections include discounts and exclude tax. Both open and closed invoices count. Revenue from liabilities (memberships, packages, gift cards, prepaid cards, loyalty points) is realized on the redemption date, not sale date.
- For invoice summary: collections include discounts and exclude tax. Only closed invoices count (unless the org allows open invoices). Liability revenue here is realized on sale date, not redemption date.
| Column | Description |
|---|---|
| Projected Monthly Revenue | Projected revenue for the month, extrapolated from collections through the report's end date. |
| Total Collected | Total amount (with tax) collected from all guests. |
| Total Revenue | Total revenue from collections AND redemptions. |
| Invoices Modified | # Old Invoices Modified (count of pre-existing open invoices that received a payment today), Old Balance Paid (amount received on those invoices today), Unpaid Balance for Month (still-uncollected total for this month's sales). |
| Open Invoice Details | # Open Invoice, Total Invoices Value, Total Amount Paid, Total Due Amount. |
| Total Manual Discount | Manual discounts (not promotion-driven) applied to invoices today. |
Authoritative source: Center revenue report (if available in your org) for Projected Monthly Revenue and Total Revenue; Invoices for Open Invoice Details; the Collections panel of this same report for Total Collected.
Guests summary panel
Guest visit, purchase, and feedback summary.
| Column | Description |
|---|---|
| Total Guests | Unique guests who visited the center and purchased anything. |
| Total # Services | Total service count (a guest can purchase multiple services β so this may exceed Total Guests). |
| Total Guests that purchased Retail | Unique guests who purchased one or more products. |
| Avg Invoice Sale Value per Guest | Sale amount (List Price β Discounts β Tax) / Unique guests. Cash/card/check/custom payments only. |
| Avg Invoice Sale Value per Retail-only Guest | Same as above, filtered to invoices with only product purchases. |
| Avg Service Sale Value per Guest | Service-only revenue Γ· unique guests with at least one service. |
| Avg Retail Sale Value per Guest | Product-only revenue Γ· unique guests with at least one product. |
| Appointment Status | Counts of Cancellation, No Show, Deleted, and Walk-in appointments. |
| Guests# that gave feedback / no feedback | Feedback-submission counts. |
| Guests# that rated <3 | Guests whose feedback rating was below 3. |
| Center Utilization (Employee) % | Total service hours / Total clocked-in hours Γ 100. |
| Center Utilization (Room) % | Total booked room hours / Total available room hours Γ 100. |
Authoritative source: Invoices (filter First Visit for new vs. returning); Appointment details report (v1) for appointment status and rebooking; Guest Feedback report for the feedback columns.
Employees summary panel
Highlights of employee revenue, attendance, tips, and petty cash for the day.
| Column | Description |
|---|---|
| Therapist Service Revenue | Highest- and lowest-grossing therapists by service revenue. |
| Employee Product Revenue | Highest- and lowest-grossing employees by product revenue. |
| Therapists vs Targets | Count of therapists on track vs. off track against monthly service-revenue targets (only meaningful if monthly targets are configured). |
| Employee Attendance | Count of On Time, Late, and No Show employees. |
| Tips | Total service-tip amount collected from guests. |
| Petty Cash | Net receipts minus expenses from the petty-cash register. |
Authoritative source: Therapist Earnings (Day) report for revenue ranking; Daily petty cash details for petty cash; Employee Attendance report for attendance counts.
Business unit sales summary panel
Sales broken out by business unit, only appears when business units are configured and assigned to items.
Calculation rules:
Sale amount = List Price β (Discounts + Tax)(DIFFERENT from the Sales panel above, which excludes tax from the formula but applies the discount before tax).- Cash, card, check, and custom payments only.
- Sale date follows the same service-vs-other rule as the Sales panel.
| Column | Description |
|---|---|
| Services / Products / Memberships / Packages / Gift Cards / Pre-paid Cards | Sale amount per item type, per business unit. The sum across all business units for an item type matches the corresponding Sales-panel cell. |
| Total | Per-business-unit sum. |
| Service Hours | Total therapist hours rendering services tagged to each business unit. |
Authoritative source: Filter the corresponding Sales - <Item> report by Business Unit and sum the Sale Value column.
Reconciliation matrix
Quick reference for reconciling each Daily summary cell against the V2 source of truth.
| Panel | Daily summary column | Authoritative V2 report | Compare against |
|---|---|---|---|
| Sales | Services | Sales - Service | Sale Value column |
| Sales | Products | Sales - Product | Sale Value column |
| Sales | Memberships | Sales - Membership | Sale Value column |
| Sales | Packages | Sales - Package | Sale Value column |
| Sales | Gift Cards | Sales - Gift Card | Sale Value column |
| Sales | Pre-paid Cards | Sales - Pre-paid Card | Sale Value column |
| Sales | Total | Invoices | Total invoice count column |
| Collections | Cash / Card / Check / Custom | Collections by invoices | Matching payment-method column |
| Collections | Total | Collections by item type | Total amount column |
| Register closures | All columns | Register closure | Matching column |
| Revenue and invoices | Open Invoice Details | Invoices | Status = Open rows; Net Price + Total Tax for value; Due for due amount |
| Revenue and invoices | Total Manual Discount | Invoices | Filter Promotion = Manual Discount; sum Total Discount |
| Guests summary | All columns | Invoices and Guest Feedback report | See per-column source links above |
| Employees summary | Employee Attendance | Employee Attendance report | Compare Expected Checkin vs. Actual Checkin |
| Employees summary | Petty Cash | Daily petty cash details | Receipts and Expenses columns |
Tips
- Treat this as a dashboard, not a source of truth. When a number looks wrong, drill into the V2 report listed in the Reconciliation matrix. The V2 reports are the authoritative sources; this dashboard is a convenience aggregator.
- Refresh once. If a panel looks stale, refresh the entire report β refreshing only one panel via browser tricks risks inconsistent values across panels.
- For multi-day ranges, expect Projected Monthly Revenue to be more volatile. It extrapolates from collections through the report's end date, so the value moves materially as the month progresses.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Business unit panel does not appear | No business units are configured for the org, or no items are assigned to a business unit. | Confirm business unit configuration under Configuration > Business details > Business units, then assign items to business units. |
| Sales panel total does not match Collections panel total | Expected β Sales counts closed invoices only and excludes tax; Collections counts both open and closed invoices and includes tax. The two are not the same metric. | Use the Reconciliation matrix to check each sub-figure individually against its V2 source. |
| The report is not listed on the Reports Dashboard | The role lacks the classic report permission (View on the DailyReports row in the Administrator section of the security role). | Grant View on the DailyReports row in the security role. See Report permissions and customization. |
| Therapists vs Targets shows zero on/off track | No monthly service-revenue targets are configured for the therapists at this center. | Configure targets under Employees > Targets, then the panel populates the following day. |
Columns
| Column | What it shows |
|---|---|
| Card Type | The credit card type for a payment (when the payment-type breakdown is turned on). |
| Amount | The amount collected for that card type. |
| Custom Payment Type | The custom payment type for a payment (when the custom payment-type breakdown is turned on). |
| Cash | Cash collected. |
| Card | Card payments collected. |
| Check | Check payments collected. |
| Custom | Payments collected under custom payment types. |
| Total | Total collections across all payment types. |
| Loyalty Point Collection | Amount collected using loyalty points. |
| Closure Time | The date and time the register was closed. |
| Cash (Closure) | Cash counted at register closure. |
| Card (Closure) | Card total at register closure. |
| Check (Closure) | Check total at register closure. |
| Bank Deposit | Amount deposited to the bank for this closure. |
| Opening Balance | The register's balance at the start of the day. |
| Closing Balance | The register's balance at closure. |
| Cash Register | The register this closure information belongs to. |
| Business Unit | The business unit (Services, Products, and so on) the sales figures below belong to. |
| Services | Total sales from services. |
| Products | Total sales from products. |
| Total (Business Unit) | Total sales for that business unit. |
| Service Hours | Total booked service hours. |
| Avg Service Value | Average value of a service sale. |
| Avg Product Value | Average value of a product sale. |
| Avg Invoice Value | Average value of an invoice. |
| Tips | Tips collected (your organization may use a different label for this row). |
| Receipts | Petty cash receipts recorded. |
| Expenses | Petty cash expenses recorded. |
| Projected Monthly Revenue | Estimated revenue for the month based on the day's activity. |
| New Guests (cash collected) | Cash collected from new guests. |
| Old Guests (cash collected) | Cash collected from existing guests. |
| Collection (Total Revenue) | Total revenue collected. |
| Redemption (Total Revenue) | Total revenue redeemed (for example, against packages or memberships). |
| Old Sales Modified (count) | Number of prior invoices that were modified. |
| Old Balance Paid | Amount paid against prior outstanding balances. |
| Unpaid Month Balance | Balance still unpaid for the month. |
| Open Sales (count) | Number of invoices still open. |
Columns shown in specific views
Some rows only appear in the exported file, or only when your organization has the related feature turned on:
- Membership Collection, Gift Card Collection, Prepaid Card Collection β appear in the exported file, and only when your organization has memberships, gift cards, or prepaid cards enabled.
- Classes, Memberships, Packages, Gift Cards, Pre-paid Cards (as business-unit sales columns), and their related sale counts β appear in the exported file, and only for the business units your organization has enabled.
- A row for your organization's environmental/service fee, if configured β appears in the exported file.