Current Sales Summary
Totals update automatically as you edit the tracker.
Itemized Sales Report
| Item | Status | Qty | Net Sale | Tax | Commission | Consignor Earnings | Payment |
|---|---|---|---|---|---|---|---|
| Add items to generate the report. | |||||||
How a Consignment Sales Tracker Helps
A consignment sales tracker organizes inventory that belongs to outside consignors. It connects each item with its price, status, commission rate, and payout details. This reduces manual calculations and gives both the store and consignor a clearer record. A strong tracker should show what arrived, what sold, what remains available, and what must be returned. It should also separate gross sales from discounts, taxes, commissions, and final consignor earnings.
Managing Sales and Commission Details
Each item can have its own pricing and commission rules. This is useful when premium products have different agreements. Enter the list price, actual sale price, discount, and commission percentage. The tracker calculates the net sale before commission. Taxes can be recorded separately so they do not become consignor earnings by mistake. Payment status also matters because a sold item may still have an unpaid consignor balance. Payout dates and references create an audit trail for completed payments.
Inventory Status and Reporting
Consignment inventory changes throughout its life cycle. An item can be available, reserved, sold, returned, expired, donated, damaged, or withdrawn. Recording these states helps staff find slow-moving items and approaching expiration dates. Sales channels also reveal where products perform best. A store may compare in-store sales with website, marketplace, auction, social media, and event transactions. Filters make larger reports easier to review.
Using This Generator
Start by entering the consignor and default agreement settings. Add one row for every consigned item. Use item-level rates when they differ from the defaults. Update statuses and payment details as transactions occur. The summary displays gross sales, discounts, tax, commission, consignor earnings, and outstanding payouts. The itemized report supports printing and record review. CSV export works well for spreadsheets and accounting systems. PDF export creates a shareable statement for consignors. Regular updates keep inventory counts accurate and payout records dependable. Clear records make consignment relationships easier to manage each day.
Example Consignment Data
| Item | Sale Price | Discount | Commission | Consignor Earnings |
|---|---|---|---|---|
| Vintage Jacket | $120.00 | $10.00 | 40% | $66.00 |
| Designer Handbag | $250.00 | $0.00 | 35% | $162.50 |
| Art Print | $80.00 | $5.00 | 30% | $52.50 |
Frequently Asked Questions
How is consignor earnings calculated?
Consignor earnings equal the net sale amount minus the store commission. Tax is displayed separately.
Can every item use a different commission rate?
Yes. Enter a custom rate on any item row. Blank rates use the default commission setting.
How are discounts handled?
The discount reduces the sale price before commission is calculated. This creates the net sale amount.
What does outstanding payout mean?
It totals consignor earnings for sold items not marked as fully paid.
Can I track unsold or expired inventory?
Yes. Use the status field and filters to find available, expired, returned, donated, or withdrawn items.
Do CSV and PDF exports include item details?
Yes. Both exports include tracker information, sales calculations, payment states, and summary totals.