Financial Report: Sales - Invoices

The Sales - Invoices report provides you details of all the sales (services, products, memberships, packages, prepaid cards, and gift cards) made at your center during a specified time period. The sale details include the invoice, guest, referral, and payment details.

 

Table of Contents

 

Navigation

Follow these steps to run the report:

  1. Make sure you have selected the center for which you want to run the report. 

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

  3. On the Reports Dashboard, click Finance > Sales (from filter).

  4. From the list of reports, click Invoices (General). The report opens in a new tab.

  5. Make your selections in the Filter Criteria and click Refresh.
    The report opens.

  6. To export the report, on the top right side of the report, click the Excel ()  or .CSV icons (). 

Filter Criteria

Criteria Options Description
Time Period Today,
Last 7 days,
Last 14 days,
1 Month,
2 Months,
3 Months,
6 Months,
Custom
Based on your requirement, from the drop-down list, select either today, last 7 or 14 days, 1, 2, 3, or 6 months.
You can alternatively choose Custom from the list and specify custom dates.
Note: For custom dates, you can view data for a maximum date range of 6 months at a time.
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,
Open,
Closed,
Open and Closed, No Show, Cancelled, Deleted
Select All to view sales of items with any invoice status.
To view sales of invoice with a particular invoice status, select that status from the list.
Sold By List of all Therapists Select Sold by - All to view service sales details of services performed by all therapists.
To view service sales of services performed by a particular therapist, select that therapist from the list.
 
Closed By List of all Employees Select Closed by - All to view sales details of invoices closed by all employees.
To view sales details of invoices closed by a particular employee, select that employee.


Column Descriptions

Column Description
Date The date on which the invoice was created.
Note: This date can be different than the Sale date.
Invoice No The invoice number. Clicking the invoice number opens the invoice details.
Receipt No The receipt number generated when the invoice was closed.
Note: If the invoice is open, no receipt number is generated.
Sale Date The date on which the sale is reported varies as follows:
  • Services: Sale is reported for the date the actual service took place and not the date on which the service was booked or the invoice was closed.
  • All other items: The sale of all other items (products, memberships, packages, gift cards, and prepaid card) is reflected on the date the item is sold.
Guest Code The unique identifier associated with the guest.
Guest Name The name of the guest who made the purchase.
First Visit Displays Yes or No to indicate if this is the guest's first visit to your center.
Member Displays Yes or No to indicate if the guest has an active membership.
Service Total The Net Price of the purchased service. 
Product Total The Net Price of the purchased product.
Membership Total The Net Price of the purchased membership.
Prepaid Card Total The Net Price at which the Gift card or Prepaid card was sold.
Package Total The Net Price of the purchased package (series and custom).
Net Price The price of the item before tax and after discount and redemptions.
The value here is List Price - (Discount + Loyalty Points Redemption + Membership Redemption + Prepaid Card Redemption + Gift Card Redemption + Cashback Redemption)
Total Tax The tax on the Net Price.
Rounding Adjustment The amount (in decimals) that is 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 for retail purchases made online.
Promotion The promotion name (if the item was sold as part of a promotion).
Note: If the front office gave a manual discount on an invoice, this field shows "Manual Discount" as the entry and not a promotion or campaign name.
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 credit value.
Loyalty Points Redemption The amount paid for the item using loyalty points.
Prepaid Card Redemption The amount paid for the item using a prepaid 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 custom payment.
Due If partial payment or no payment is made, this field reflects the amount that you must collect from the guest.
Status Shows the status of the invoice as Open, Closed, No Show, Cancelled, or Deleted. 
Closed By The name of the employee who closed the invoice.
Closed On The date on which the invoice was closed.
Appointment Source Displays Zenoti if the guest walked-in to purchase the item.
Else displays Web or Mobile if the guest made the purchase from the Webstore or Customer Mobile Application (CMA) respectively.
Comments Helpful suggestions or comments about the guest or transaction added by the front office.
Tips The amount paid by guests as tips.
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. This is available only if the Referral Source is Guest.
Referrer Code The guest code of the referrer.
Have more questions? Submit a request

Comments

Powered by Zendesk