Skip to main content

Sales Invoices Financial v1 report

Important

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

The Sales - Invoices report provides you details of all the sales (services, products, memberships, packages, prepaid cards, and gift cards) made at the current center for a specific sale date (or date range). The sale details include the invoice, guest, referral, and payment details. You can view the report based on the sale date, invoice status, employee who sold it, and employee who closed the invoice.

  1. Select the center for which you want to run the report.

  2. On the main menu, click the Reports tab.

  3. On the dashboard, click Employee > Team (from the filter).

  4. From the list of reports, click Purchases By Category.

    The report opens in a new tab.

  5. Select the filter criteria and click Refresh to see the report.

Filters

Criteria

Options

Description

Report Name

List of reports for sales

Select Invoices as the name of the report.

Sale Date/Closed Date

  • Today

  • Last 7 days

  • Last 14 days

  • 1 Month

  • 2 months

  • 3 months

  • 6 months

  • Custom

Select the date on which the sale is made or invoice is closed. Select Custom to select a date range.

Note

For custom dates, you can view data for a maximum date range of 6 months at a time. For example, if you wish to see data from January to August, first view data from January to June and then view data from July to August.

Invoice Status

  • All

  • Closed

  • Open

  • Open and Closed

  • No Show

  • Cancelled

  • Deleted

  • Voided

Select the status of the invoice.

Note

Select All to view sales of items with any invoice status.

Date Type

  • Service Date/ Sale Date

  • Closed Date

Select the type of date (service/sale or closed) based on which you want to view the invoices.

Important

This filter appears only when you select the Invoice Status as ‘Closed’.

Sold By

List of all employees

Select a specific employee who made the sales. Select All to view sales done by all employees in the current center.

Closed By

List of all employees

Select a specific employee who closed the invoice. Select All to view invoices closed by all employees in the current center.

Column descriptions

Column

Description

Date

The date on which the invoice is created.

Note

This date can be different from the Sale date.

Invoice No.

Note

This label can be different based on your organization set up.

The number generated for the appointment or point of sale entry.

Note

Click the number to view the invoice.

Receipt No.

Note

This label can be different based on your

A number auto-generated by Zenoti when the invoice is closed.

Note

For open invoices, the receipt number is 0. This is because a receipt number is generated only after full payment is received.

Sale Date

The date on which the service is performed. In case of products, memberships, packages, gift cards, and prepaid card, it is the date on which the item was sold.

Guest Code

A unique identifier associated with the guest. It is auto-generated by Zenoti, as configured by your business.

Guest Name

The full name of the guest who made the purchase.

First Visit

Indicates if this visit was the guest’s first visit with a Yes or a No.

Member

Indicates if the guest has an active membership with a Yes or No.

Class Total

The price of the session including taxes. It is calculated as: Class Total = Net Price + Tax

Note

You will see this column only if classes is enabled for your business.

Service Total

The price of the purchased service and day packages including taxes. It is calculated as: Service Total = Net Price + Tax

Product Total

The price of the purchased product(s) including taxes. It is calculated as: Product Total = Net Price + Tax

Membership Total

The price of the purchased membership including taxes. It is calculated as: Membership Total = Net Price + Tax

Prepaid Card Total

The price of the purchased gift card or prepaid card including taxes. It is calculated as: Prepaid Card Total = Net Price + Tax

Package Total

The price of the purchased package (series and custom) including taxes. It is calculated as: Package Total = Net Price + Tax

Net Price

Expected amount to be paid by the guest excluding tax. It is calculated as, Net Price = Service Sale Price - (Discount + Redemption)

Total Tax

The amount of tax payable. It is calculated on the Net Price or Item Sale Price based on the tax definition.

Rounding Adjustment

The amount (in decimals) rounded off to help a guest pay the exact amount.

Shipping Charge

The charge levied for shipping a product to the guest. This is applicable to retail purchases made online.

Promotion

The name of the promotion in case of discount or name of liability in case of redemption. This column can have one of the following values:

  • Manual: Discount provided on the invoice

  • Price Adjusted: Price adjusted on the invoice

  • Campaign or Discount Name: Name of the campaign or discount applied on the invoice

  • Liability Type and Name: Type and name of the liability.

    For example, Membership: Monthly Membership

  • Cancellation Fee or No Show Fee, if charged

Package Redemption

The name of the redeemed package.

Total Discount

The total amount given as a discount on the invoice (manual discount or campaign).

Membership Redemption

The amount paid for the item using membership credits (if the liability sale was taxed).

Loyalty Points Redemption

The amount paid for the item using loyalty points, if redemption configuration, is set to the final sale price (Sale Price - Discount) without tax.

Prepaid Card Redemption

The amount paid for the item using a prepaid card or gift card.

Cashback

The amount paid for the item using a cashback coupon.

Cash

The amount paid for the item using cash.

Card

The amount paid for the item using a card.

Check

The amount paid for the item by means of a check.

Membership

The amount (in equivalent membership credits) deducted from the list price of the item (before adding any applicable taxes and discounts).

Prepaid Card

The amount from the prepaid card or gift card deducted from the final price of the item.

Custom

The amount paid for the item using a custom payment method.

Due

The balance amount to be received from the guest. It is calculated as: Due = (Net Price + Tax) - Price Paid

Status

The current status of the invoice. It can be one of the following:

  • Open

  • Closed

  • No Show

  • Canceled

  • Deleted

Note

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

Closed By

The name of the employee who closed the invoice. If the invoice is reopened and closed by another employee, this column is updated with the employee name who last closed the invoice. You can check the complete invoice logs on the invoice page.

Closed On

The date on which the invoice is closed. If the invoice is reopened and closed, this column is updated with the new date. You can check the complete invoice log on the invoice page.

Appointment Source

The source from which the appointment is booked. It is one of the following:

  • KioskWeb for Kiosk

  • Mobile for CMA

  • POS for Web POS Screen

  • Web for Webstore

  • Zenoti for Web Appointment Book

  • Zenoti-Mobile for Mobile POS

Comments

Helpful suggestions or comments about the guest or transaction added by the front-desk staff for the invoice.

Tip

The amount paid by guests as tips.

SSG

The amount paid by the guest for the support staff.

CashBack

The extra amount paid by the guest using a card so that she can give a tip to the provider using cash.

Example: Maria, a guest, wants to tip her provider $15. Her service costs $100. Maria does not have cash with her to pay the tip. She, therefore, asks the front-desk staff to swipe $115 and asks for $15 as cashback. This way, Maria pays $100 using her card and gets the $15 as cash to pay a tip to her provider.

Referral Source

The referral source selected by the front office during the guest profile creation. For example, Advertisement.

Referred By

The name of the referrer in case the Referral Source is ‘Guest’.

Referrer Code

The guest code of the referrer.