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.
Select the center for which you want to run the report.
On the main menu, click the Reports tab.
On the dashboard, click Employee > Team (from the filter).
From the list of reports, click Purchases By Category.
The report opens in a new tab.
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 |
| Select the date on which the sale is made or invoice is closed. Select Custom to select a date range. NoteFor 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 |
| Select the status of the invoice. NoteSelect All to view sales of items with any invoice status. |
Date Type |
| Select the type of date (service/sale or closed) based on which you want to view the invoices. ImportantThis 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. NoteThis date can be different from the Sale date. |
Invoice No. NoteThis label can be different based on your organization set up. | The number generated for the appointment or point of sale entry. NoteClick the number to view the invoice. |
Receipt No. NoteThis label can be different based on your | A number auto-generated by Zenoti when the invoice is closed. NoteFor 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 NoteYou 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:
|
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:
NoteIf 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:
|
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. |