ZenotiHelp

Sales Invoices Financial v1 report

ZTZenoti Docs Team Updated September 4, 2026 8 min readReference

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.

Deprecated: This is a legacy report. Businesses that have signed up with Zenoti after April 2022 do not have access to this report.

Audience: Finance admin, accountant

The Sales Invoices Financial v1 report lists every invoice raised at the selected center for a date range, with line-item totals broken out by sale type (service, product, membership, package, gift card, prepaid card), all redemption and payment buckets, taxes, rounding, tips, support-staff gratuity, and referral attribution. Use it when you need a single flat row per invoice with every financial component visible side by side.

This is a legacy report available under the classic reporting framework. The current equivalent is the V2 Invoices report under Finance > Sales > Invoices. Both reports return invoice-level sales data; the V2 report adds payment-type and sale-type filters and surfaces under the modern Reports Dashboard.

When to use this report vs. the Invoices V2 report: Use this v1 report only when an existing workflow or export pipeline depends on its exact column set and ordering. For new dashboards and exports, use the V2 Invoices report, which is granted per report under Financial in the Reports(V2) section of the security role.

Data refresh: Real-time on Refresh. Values reflect invoices, payments, and closures recorded at the moment of click.


On this page


Before you begin

  • Enable the report for your organization under Configuration > Reports > List of reports.
  • The report runs against the center you have selected in the top navigation; it cannot be run across multiple centers in a single execution.

Permission: This classic report is controlled by View Sales Reports in the Sales section of the security role (Configuration > Security > Security roles > the role > Permissions). Select the report-area action that applies to this report (for example View, Pipeline, or Conversion). Classic report permissions are independent of the Reports(V2) permissions. See Report permissions and customization.

Run the report

  1. Select the center for which you want to run the report.
  2. On the main menu, click Reports.
  3. From the dashboard, expand Sales and select Invoices.
  4. Set the filters described in Filter reference.
  5. Click Refresh.

To export, click the Excel or CSV icon.

Note on date range: When Invoice Status is Closed, the Date Type filter appears and lets you anchor the date range on either Service / Sale Date or Closed Date. For all other statuses, the date range anchors on the sale date. For custom date ranges, the maximum span supported is six months at a time; for a longer range, split the run into multiple windows.

Filter reference

Filter Values Description
Report Name List of reports for sales Choose Invoices as the report name.
Sale Date / Closed Date Today, Last 7 days, Last 14 days, 1 Month, 2 months, 3 months, 6 months, Custom Date range for the run. For Custom, the maximum window is six months.
Invoice Status All, Closed, Open, Open and Closed, No Show, Cancelled, Deleted, Voided Filters by invoice status. All returns invoices in every status.
Date Type Service Date / Sale Date, Closed Date Appears only when Invoice Status is Closed. Anchors the date range on either the sale/service date or the closed date.
Sold By List of employees Filters by the employee who made the sale. Choose All for every employee at the center.
Closed By List of employees Filters by the employee who closed the invoice. Choose All for every employee at the center.

Column reference

Column Description
Date The date the invoice was created. Can differ from the sale date.
Invoice No. Number generated for the appointment or POS entry. Click to open the invoice. Label may be customized per organization.
Receipt No Auto-generated when the invoice is closed. 0 for open invoices, since the receipt number is generated only on full payment.
Sale Date Date the service was performed; for products, memberships, packages, gift cards, and prepaid cards, the date the item was sold.
Guest Code Unique identifier associated with the guest, auto-generated per business configuration.
Guest Name Full name of the guest who made the purchase.
First Visit Yes or No: whether this was the guest's first visit.
Member Yes or No: whether the guest has an active membership.
Class / Service / Product / Membership / Prepaid Card / Package Total Per-sale-type total including taxes, calculated as Net Price + Tax. The Class Total column is shown only when classes are enabled. Service Total includes day packages. Prepaid Card Total covers both gift cards and prepaid cards. Package Total covers series and custom packages.
Net Price Amount due from the guest excluding tax. Net Price = Sale Price - (Discount + Redemption).
Total Tax Tax payable, calculated on Net Price or Item Sale Price based on the tax definition.
Rounding Adjustment Decimal amount rounded off so the guest pays an exact total.
Shipping Charge Shipping charge for products shipped to the guest (online retail).
Promotion For discounts, the campaign or discount name. For redemptions, the liability type and name (for example, Membership: Monthly Membership). Special values: Manual, Price Adjusted, Cancellation Fee, No Show Fee.
Package Redemption Name of the redeemed package.
Total Discount Total discount on the invoice (manual or campaign).
Membership Redemption Amount paid using membership credits (if the liability sale was taxed).
Loyalty Points Redemption Amount paid using loyalty points, if loyalty redemption is configured on the final sale price (Sale Price - Discount) without tax.
Prepaid Card Redemption Amount paid using a prepaid card or gift card.
Cashback Amount paid using a cashback coupon.
Cash / Card / Check / Custom Amount paid by each payment method.
Membership Amount in equivalent membership credits deducted from the list price (before tax and discount).
Prepaid Card Amount from the prepaid card or gift card deducted from the final price.
Due Balance still to be received. Due = (Net Price + Tax) - Price Paid.
Status Current invoice status. See Invoice status values.
Closed By / Closed On Employee who closed the invoice and the closure date. If reopened and reclosed, reflects the latest closure. The invoice page log shows full history.
Appointment Source Booking source: KioskWeb (Kiosk), Mobile (Customer Mobile App), POS (Web POS), Web (Webstore), Zenoti (Web Appointment Book), Zenoti-Mobile (Mobile POS).
Comments Notes added by the front-desk team for the invoice.
Tip Tip amount paid by the guest.
SSG Support staff gratuity amount paid by the guest.
CashBack Extra amount charged to the card so the guest can hand cash to a provider as a tip (for example, $115 on card with $15 returned in cash for a $100 service plus $15 tip).
Referral Source / Referred By / Referrer Code Referral attribution captured during guest profile creation (for example, Advertisement); name and guest code of the referrer when the source is Guest.

Note: If an invoice is open, the sale commission is not yet considered in the employee payroll.

Invoice status values

The Status filter and column reflect the classic invoice-status enumeration.

Status Meaning
All All invoices in the date range, regardless of status.
Open The invoice has been created; payment has not yet been completed.
Closed Payment has been received in full and the invoice is closed.
Open and Closed Both open and closed invoices in the date range.
No Show The guest did not arrive; the appointment was recorded as a no-show.
Cancelled The appointment or sale was cancelled.
Deleted The invoice was deleted.
Voided The invoice was voided.

Worked example

A finance admin wants to reconcile last week's closed invoices by sale type.

  1. On the main menu, click Reports and select Invoices.
  2. Set Sale Date: Last 7 days.
  3. Set Invoice Status: Closed.
  4. Set Date Type: Closed Date.
  5. Set Sold By: All, Closed By: All.
  6. Click Refresh.

Sample result:

Invoice No Date Guest Service Total Product Total Membership Total Net Price Total Tax Status
INV-2041 2026-05-12 Maria Diaz 120.00 0.00 0.00 110.00 9.90 Closed
INV-2052 2026-05-13 Aisha Kapur 0.00 48.00 0.00 48.00 4.32 Closed
INV-2068 2026-05-14 John Lee 95.00 22.00 0.00 117.00 10.53 Closed

Exporting the rows to CSV gives the finance team a single flat record per invoice with every redemption and payment column for downstream ledger reconciliation.

Tips

  • Cross-check against payment-collection reports. The same closed invoices appear in Collections by invoices report grouped by invoice with payment details. Use Collections by invoices when you need only the cash, card, and check breakdown without line-item totals.
  • Choose the right date anchor for closed-invoice runs. For period-end reconciliation, set Invoice Status to Closed and Date Type to Closed Date so the run picks up invoices that were sold earlier but closed inside the period.
  • Sold By and Closed By are independent. A different employee may have closed the invoice after the sale; filter on the role you actually want to reconcile against.

Troubleshooting

Issue Cause Resolution
Custom date range rejected The selected window is longer than six months. Split the run into multiple windows of up to six months each.
Receipt No. is 0 for some rows Those invoices are still open; a receipt number is generated only on full payment. Re-run with Invoice Status Closed to exclude open invoices, or close the invoices and re-run.
Date Type filter is missing The Date Type filter appears only when Invoice Status is set to Closed. Set Invoice Status to Closed to expose the Date Type filter.
The report is not listed on the Reports Dashboard The role lacks the classic report permission (View Admin Reports in the Administrator section of the security role). Grant the report-area action in the security role. See Report permissions and customization.
Totals do not match the V2 Invoices report The V2 report applies the modern security model and a slightly different filter set (payment type, sale type). Align filters between runs, or treat the V2 report as the source of truth for new reconciliations.
Was this article helpful?
Your feedback helps us improve our documentation.