Purpose
These reports help you analyze sold inventory data to better understand profit sharing (store vs. consignor) and differentiate between consignor-supplied and store-owned merchandise. They are essential for accurate payout calculations, inventory auditing, and profit analysis.
To learn more about creating customer reports, please view our Custom Reports Overview guide.
Report Setup
Store Split Sold Inventory
Description:
This report helps you see what percentage of sales revenue was retained by the store versus paid to consignors. It’s useful for auditing consignor terms, reviewing payout fairness, and analyzing overall profitability by date or consignor.
Base:
Sold Inventory
Fields to Include:
| Field Name | Description |
| SKU | Stock Keeping Unit identifier |
| Item Name (At Checkout) | Item name as shown on the sales receipt |
| Sold Price | Sale price per item |
| Quantity Sold | Number of units sold |
| Total Sold Price | Total revenue from the sale |
| Store Split % | Percentage of sale retained by the store |
| Payout Amount | Amount owed to consignor |
| Invoice # | Unique identifier for the sale |
| Sold Date | Date the item was sold |
Filters:
| Filter | Use Case |
| Sold Date is [MM/DD/YYYY] | View all sales for a specific day |
| Sold Date is after [start date], AND | Analyze sales over a custom date range |
| Sold Date is before [end date] |
Sold without Consignor
Description:
This report shows which store-owned items (not consigned) were sold during a specific timeframe. It’s helpful for separating sales by ownership type, tracking store-owned inventory movement, and confirming payouts only apply to consignor inventory.
Base:
Sold Inventory
Fields to Include:
| Field Name | Description |
| SKU | Stock Keeping Unit identifier |
| Item Name (At Checkout) | Item name as shown on the sales receipt |
| Sold Price | Sale price per item |
| Quantity Sold | Number of units sold |
| Total Sold Price | Total revenue from the sale |
| Invoice # | Sale identifier |
Filters:
| Filter | Use Case |
| Is Consigned is False AND Sold Date is [MM/DD/YYYY] | View store-owned sales for a single day |
| Is Consigned is False AND Sold Date is after [start date], AND Sold Date is before [end date] | Analyze store inventory sales over time |
Gift Cards
When reconciling the sales report with this report, please note the following:
- Gift card transactions that do not include other sold items are recorded as transactions but are not included in the Sales Total. These appear as separate line items on the End-of-Day report.
- Gift card sales are treated differently because gift cards represent prepaid value for future purchases rather than actual sales at the time of purchase.
- Gift cards are reported as inventory items with a retail value, but they do not have a sold price or SKU and are not included in the "Number of Items Sold."
- Items sold for less than $0.01 are also excluded from the "Number of Items Sold" metric.
- This behavior reflects a system update designed to ensure that coupon discounts and $0 informational line items are not counted in the "Number of Items Sold."
Tips
-
Use “Store Split %” alongside “Payout Amount” to ensure proper revenue sharing.
-
Combine this data with invoice and payment reports for full sales-to-payout tracking.
-
Filter by consignor ID to isolate and analyze individual consignor performance.