Tracking consignment inventory requires a system that records who owns each item, where it sits, what has sold, and what the consignee owes the consignor at any given time. Unlike standard inventory, consignment goods belong to the supplier until they sell or get used, which means both parties need visibility into the same data. Whether you use a spreadsheet or dedicated software, the core challenge is the same: maintaining an accurate, shared record from the moment goods arrive through final payment.
Why Consignment Inventory Needs Its Own System
Standard inventory tracking assumes you own everything on your shelves. Consignment flips that assumption. The supplier (consignor) retains ownership of the goods until a triggering event, typically a sale to the end customer, consumption in manufacturing, or loss or damage at the consignee’s location. Under ASC 606, revenue isn’t recognized until control of the goods actually transfers. A supplier who ships product to a retailer on consignment and retains the right to demand its return hasn’t made a sale yet, even if the retailer has physical possession.
This split between physical possession and legal ownership creates a tracking problem that regular inventory tools aren’t built for. You need to capture not just quantities and locations, but also ownership status, the terms of each consignment agreement, and the financial settlement that follows every sale or usage event. Without that, one side ends up with inaccurate books, disputed invoices, or both.
Essential Data Points to Track
Every consignment tracking system, whether it’s a spreadsheet or enterprise software, needs to capture a specific set of fields for each item or batch. At minimum, you need:
- Item description and SKU: A unique identifier for every product, including any variant details like size, color, or model number.
- Consignor name and contact info: Which supplier owns the goods. If you work with multiple consignors, this field is critical for sorting obligations.
- Quantity received: The number of units delivered, recorded at the time of receipt.
- Receipt date: When the goods physically arrived at your location.
- Location: Where items are stored or displayed. If you operate multiple sites or zones, tracking location prevents lost inventory.
- Ownership status: Whether the item is still consignor-owned, has transferred to the consignee, or has been sold to an end customer.
- Sale or consumption date: When ownership changed hands, triggering a financial obligation.
- Agreed price and commission split: The retail price, the consignor’s share, and the consignee’s share (or a wholesale cost if the arrangement works that way).
- Amount owed and payment status: What you owe the consignor for sold or consumed items, and whether it’s been paid.
- Condition notes: Any damage, defects, or quality issues noted on receipt or during storage.
A vendor list section in your tracking file should also store supplier details like lead times, preferred contact methods, and the terms of each consignment agreement, including return policies and settlement schedules.
Setting Up a Spreadsheet-Based System
For small operations or consignment shops handling a manageable number of items, a spreadsheet works well as a starting point. Create separate tabs for intake, current inventory, sales, and settlements. The intake tab logs every shipment you receive, with columns for the consignor, item details, quantities, date received, and agreed pricing. The current inventory tab should reflect what’s physically on hand right now, organized by consignor so you can quickly see who owns what.
Your sales tab records each transaction: the item sold, the date, the sale price, the consignor’s cut, and your commission. This tab feeds directly into settlements. On a weekly or monthly cycle (whatever your agreements specify), you total up sales by consignor and generate a settlement report showing what you owe. A drop-down list linking items to their consignor makes this process faster and reduces errors.
The biggest risk with spreadsheets is human error. Every sale needs to be logged immediately, or your on-hand counts drift out of sync with reality. Build in a simple reconciliation step: at least once a month, physically count everything on your shelves and compare it to what the spreadsheet says you should have. Any gap is either a missed sale entry, theft, damage, or a receiving error, and you need to figure out which one before settling with the consignor.
The Intake-to-Settlement Workflow
Regardless of the tool you use, the tracking lifecycle follows the same steps:
Step 1: Receive and log. When goods arrive, count them against the consignor’s packing list or delivery note. Record quantities, item details, condition, and the date. If something arrives damaged, note it immediately and notify the consignor. At this stage, you’re recording physical quantities only. No purchase is being made, so there’s no cost hitting your books.
Step 2: Store and display. Assign the items a location in your system. If you carry goods from multiple consignors in the same category, clear labeling or tagging prevents mix-ups. Some consignees use color-coded tags or prefix codes tied to each consignor.
Step 3: Record sales or consumption. When an item sells or gets used (in a manufacturing context, when raw materials go into production), update the record. This is the ownership transfer moment. The item moves from “consignor-owned” to “sold” in your system, and a financial obligation is created. In a manufacturing setup, this step often involves an ownership change journal that generates a corresponding purchase order.
Step 4: Settle and pay. On your agreed schedule, compile all sales or consumption events since the last settlement. Generate a report showing what was sold, at what price, and the consignor’s share. The consignor reviews this, issues an invoice (or you issue a self-billing statement, depending on your agreement), and you remit payment. Keep a record of every settlement with dates and amounts paid.
Step 5: Handle returns. Unsold goods may be returned to the consignor at the end of a season, contract period, or at any time if the agreement allows it. Log returns the same way you log receipts: update quantities, note the date, and confirm with the consignor that they’ve received the goods back.
Reconciliation and Shrinkage
Physical counts are non-negotiable in consignment. Because you’re holding someone else’s property, discrepancies aren’t just an operational problem; they’re a financial liability. If an item goes missing, your consignment agreement likely specifies whether you owe the consignor for it.
Schedule regular physical counts, monthly at minimum for high-volume operations, quarterly for smaller ones. Compare the count to your system’s on-hand quantity for each consignor. When numbers don’t match, investigate before adjusting the records. Common causes include unrecorded sales, items moved to a different location, breakage that wasn’t logged, or theft.
After investigating, adjust your records and document the reason. Share the reconciliation results with the consignor, especially if shrinkage triggers a payment obligation. Transparency here builds trust and prevents disputes at settlement time. Both parties should have access to the same data, or at minimum receive the same reports, so discrepancies surface early rather than festering into disagreements.
When to Move Beyond Spreadsheets
Spreadsheets start breaking down when you’re managing more than a few dozen active consignors, handling high transaction volumes, or operating across multiple locations. Signs you’ve outgrown a manual system include frequent count discrepancies, settlement delays because reports take too long to compile, and consignors questioning your numbers.
Dedicated consignment or inventory management software solves these problems by automating several things spreadsheets can’t do well. Look for features like real-time inventory visibility that both you and the consignor can access, automatic calculation of commissions and amounts owed at the point of sale, integration with your POS or barcode scanning system so sales deduct from consignment counts instantly, and reporting tools that generate settlement statements on demand.
Standard inventory software often lacks the ability to track ownership separately from possession, which is the fundamental requirement. Consignment-specific platforms or modules (available in systems like NetSuite and others) handle this natively. They let you predefine fulfillment rules, use historical and seasonal data to manage reorder points, and give both parties a shared view of inventory levels, which reduces the data discrepancies that cause most consignment disputes.
Keeping Both Parties Aligned
The most common source of consignment tracking failure isn’t the tool; it’s a lack of clear communication between consignor and consignee. Before the first shipment arrives, put the following in writing: how often settlements happen, what happens when items are damaged or lost, who pays for shipping on returns, and how long the consignor’s goods will remain on your floor before being returned if unsold.
Give consignors regular access to their inventory data. Some software platforms include a vendor collaboration portal where suppliers can monitor their on-hand quantities, see what’s sold, and track expected payments without needing to call or email you. If you’re using spreadsheets, a shared cloud document or a periodic email report accomplishes the same thing at a smaller scale. The goal is making sure both sides are always looking at the same numbers, so settlement day is a formality rather than a negotiation.