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 |
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.