Run the Product Sales Report – Vagaro Support

The Product Sales Report gives you a complete view of all product sales in Vagaro. Filter by date range to drill into transaction details, individual receipts, and all items sold during that period.

Prerequisites: This feature is available for all Vagaro businesses.

Run the Report

The report includes the following columns:

Brand: The name of the brand that sells the product.
Product: The name of the product customers purchased. Product bundles appear with a Gift Card icon. Select the link to see what's in the bundle.
Quantity: The number of items customers purchased for that product.
Business Cost: The amount the business paid to purchase the product for resale.
Net Sales: The total revenue from product sales before deducting business costs.
Net Profit: The total revenue from product sales after deducting business costs.
Net Profit Margin (%): The percentage of net sales retained as profit after deducting business costs.
Points Redeemed: The total points customers redeemed on product purchases.

Tip

Go to the bottom of the report to see a summary of all totals for the selected date range, including total quantity sold, net sales, net profit, and points redeemed.

On a Phone

On a phone, the report displays a card for each product sold during the selected date range.

To run the Product Sales report:

Select More → Reports → Product Sales Report.
At the top of the screen, select the Date Range to report on. The report updates automatically each time you change the date range.
Optionally, in the top-right corner, select Filters , set any of the following filters, and then select Run Report.
- Employees: Show data for all employees or a specific set of employees.
- Customer: Show data for all or a specific set of customers.
- Customer General Tag: Show data for customers with a specific customer tag.
- Business Location: If your business has multiple locations, show data for all locations or a specific set of locations.
- Include Past Employees: Include data for employee profiles removed from your business.
- Sort By: Reorder the report.
Optionally, in the top-right corner, select Action , then:
- Select Star or Remove Star to bookmark or unbookmark.
- Select Print to get a hard copy of the report.
- Select Export PDF or Export Excel to download this report.

Note

Product bundle details are not shown in printed or exported reports.

On a Computer, Tablet, Pay Desk, or PayPro

The Product Sales report lists products sold during the selected date range.

To run the Product Sales report:

Select Reports → Product Sales Report.
Optionally, in the top-right corner, select Filters , set any of the following filters, and then select Run Report.
- Date Range: Show a specific time range.
- Employees: Show data for all employees or a specific set of employees.
- Customer: Show data for all or a specific set of customers.
- Customer General Tag: Show data for customers with a specific customer tag.
- Business Location: If your business has multiple locations, show data for all locations or a specific set of locations.
- Include Past Employees: Include data for employee profiles removed from your business.
Optionally, sort, print, or export the report:
- Select a column header at the top of the report to sort the report.
- Select Print to get a hard copy of the report.
- Select Export to save the report to an Excel or PDF file (web version only).
Note

Product bundle details are not shown in printed or exported reports.

Drill Through Transaction Details

On a Phone

When viewing a product's transactions, the report will show the following information for each sale:

Select a product card to view its customer transactions.
Optionally, work with the transactions:
- Select Search to find transactions by date, customer name, item sold, or transaction type.
- In the top-right corner, select Action , then select Print to get a hard copy, or Export PDF or Export Excel.
Optionally, view a customer's receipt:
1. Select a transaction to open its receipt.
2. In the top-right corner, select Action , then select Print to resend or print the customer's receipt.

On a Computer, Tablet, Pay Desk, or PayPro

When viewing a product's transactions, the report will show the following information for each sale:

Select a Product to view customer transactions.
Optionally, work with the transactions:
- Select a column header to sort by that column.
- Use the search box to find transactions by date, customer name, item sold, or transaction type.
- Select Export or Print .
At the end of the transaction, select Receipt to view, reprint, or send the receipt to the customer via email.

Transaction Details

Each transaction shows the following details:

Transaction ID: The transaction's unique identification number.
Business Name: The name of the business.
Checkout Date: The date the customer paid for the service or class. This can differ from the Appointment Date.
Checkout By: The employee who processed the transaction. This can differ from the employee listed under Sold By.
Appointment Date: The date of the customer's appointment or class.
Customer: The customer's name.
Item Sold: The service or class the customer paid for.
Sold By: The employee who earns the commission for the sale, if any.
Quantity (Qty): The number of services or classes the customer paid for.
Business Cost: How much it cost the business to perform the service or class.
Price: The amount the business charges for the service or class.
Sales Tax(es): The tax charged on top of the price.
Tip: The tip the customer gave the employee.
Discount (Disc): The price reduction the customer received. The customer may have redeemed points, applied a promotional code, or paid with a package, membership, or Daily Deal.
Amount Paid (Amt Paid): The total the customer paid, after taxes and discounts and including tips.
Shipping & Handling: The amount charged to ship items to the customer, if any.
Cash: The amount the customer paid with cash.
Check: The amount the customer paid by check.
Gift Card (GC): The amount the customer redeemed from gift cards.
Package (Pkg): The amount the customer redeemed from a package.
Membership (Mbsp): The amount the customer redeemed from a membership.
Credit Card: The amount the customer paid by credit card.
Bank Account: The amount the customer paid from their bank account.
Buy Now, Pay Later: The amount the customer paid with Affirm.
IOU/Invoice: The amount the customer was issued an IOU for or invoiced.
Points: The number of points the customer redeemed.
Net Sale: The revenue earned after discounts, packages, and memberships
Merchant Account: The amount deposited into the business's or employee's merchant account.
Change Due: The amount owed back to the customer after payment.

Note

On a computer, tablet, Pay Desk, or PayPro, the report appears as a table. Some columns are abbreviated (Qty, Disc, Amt Paid, GC, Pkg, Mbsp), and some are combined into a single column. For example, Checkout Date, Checkout By, and Transaction ID.