Inventory sales report
Audience: Inventory manager, retail manager, center admin
The inventory sales report shows retail product sales activity at a center over a specified period — the quantities sold, with the product, vendor, sale date, invoice number, and the employee who made the sale. It is a quantity report: it carries no price, revenue, tax, or payment columns. Use it to identify high- and low-velocity products; for revenue and tender analysis use the sales reports on the Reports dashboard.
This is a legacy report available under the classic reporting framework.
Data refresh: Real-time on Refresh. Values reflect sales captured at the moment of click.
Margin analysis: Pair this report with the Cost of goods report for Sales − COGS margin reconciliation.
On this page
- Before you begin
- Run the report
- Filter reference
- Column reference
- Worked example
- Troubleshooting
- Related articles
Before you begin
- Enable the report for your organization under Configuration > Reports > List of reports.
Permission: Sales under View Inventory Reports in the Inventory Manager section of the security role — Required to access the Inventory sales report.
Run the report
- Select the center for which you want to run the report.
- Navigate to Reports > Inventory.
- Select the Sales report.
- Set the date range and filters from the Filter reference.
- Click Refresh.
To export the report, click the Excel or CSV icon.
Filter reference
| Filter | Values | Description |
|---|---|---|
| Date range | From / To dates | Filters by sale transaction date. |
| Product Type | Retail / Consumable / Both | Three-state classification: Retail, Consumable, or Both. |
| Category | Configured categories | Limits results to products in the selected category. |
| Sub-Category | Configured sub-categories | Further narrows the category filter. |
| Brand | Configured brands | Filter by product brand. |
| Vendor | Configured vendors | Filter by vendor (when org-level vendor display is enabled). |
| Employee | Center employees | Filter by the employee who processed the sale. |
| Sales channel | POS (Point of Sale) / Appointment Checkout / Class Booking / Self-Checkout | Filter by the channel that originated the sale. |
Column reference
| Column | Type | Description |
|---|---|---|
| Sold On | Date | The sale transaction date. |
| Invoice Number | Identifier | The invoice the sale appears on. |
| Vendor | Text | The vendor associated with the product. |
| Product Code / Name | Text | The product sold. |
| Quantity | Number | Units sold per invoice line (one row per invoice line). |
| Sold By | Text | The employee who processed the sale. |
What this report does not show: there are no sale-price, discount, tax, revenue, or payment columns in this report — it tracks movement of units, not money. For revenue, discounts, taxes, and tender methods, use the sales reports on the Reports dashboard.
Worked example
A center wants to identify the top-selling retail products for the month.
- Set Date range: 2026-04-01 to 2026-04-30.
- Set Product Type: Retail.
- Click Refresh.
Sample (5 invoice lines):
| Sold On | Invoice | Vendor | Product | Qty | Sold By |
|---|---|---|---|---|---|
| 2026-04-03 | INV-2041 | Acme | Shampoo A | 2 | Riley M. |
| 2026-04-09 | INV-2087 | Acme | Conditioner B | 1 | Jordan P. |
| 2026-04-12 | INV-2102 | Acme | Shampoo A | 1 | Riley M. |
| 2026-04-15 | INV-2118 | Beauty Co | Hair Oil C | 3 | Riley M. |
| 2026-04-18 | INV-2126 | Acme | Shampoo A | 1 | Jordan P. |
April movement: 8 units across 5 invoices. Top product by quantity: Shampoo A (4 units). For the revenue behind these sales, run the sales reports on the Reports dashboard for the same period.
Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Permission denied | The user role lacks Sales under View Inventory Reports. | Confirm the role permission. |
| Totals do not match POS day-end | Day-end reconciles revenue; this report counts units only. | For revenue and tender analysis use the sales reports on the Reports dashboard. |
| Online sales missing | Online (Webstore V2 / CMA (Customer Mobile App)) sales are surfaced in the Online product sales report, not here. Webstore V1 historical sales DO appear here. | Check the Online product sales report for the missing channel. |