Sales Invoices Financial v1 report
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
- Run the report
- Filter reference
- Column reference
- Invoice status values
- Worked example
- Tips
- Troubleshooting
- Related articles
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
- Select the center for which you want to run the report.
- On the main menu, click Reports.
- From the dashboard, expand Sales and select Invoices.
- Set the filters described in Filter reference.
- 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.
- On the main menu, click Reports and select Invoices.
- Set Sale Date: Last 7 days.
- Set Invoice Status: Closed.
- Set Date Type: Closed Date.
- Set Sold By: All, Closed By: All.
- 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
Closedand Date Type toClosed Dateso 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. |