How to Track Consignment Inventory as an Antique Booth Vendor
Consignment gets uncomfortable fast when an owner asks, "Where is my lamp, and what do you owe me?" You should be able to answer without searching old texts.
Start with a written agreement for each consignor. Give every accepted item a unique ID, keep ownership and deal terms separate from location, reconcile booth sales to those IDs, and send itemized settlements. Each piece needs a documented path from intake to sale, return, loss, or another action allowed by the agreement.
This guide covers vendor-side consignment tracking: you, the booth vendor, accept somebody else's property and owe that person an accounting. Parcel tracking only follows a shipment. The antique mall's point-of-sale system records the mall's transactions. Its statement is an important source document, but it cannot replace your consignor ledger.
Start by separating the three systems
Searches for “consignment tracking” often lead to tools for packages in transit or software for consignment-store operators. Antique booth vendors have a narrower job that overlaps with both inventory and bookkeeping.
1. Parcel tracking
Parcel tracking answers: Where is a shipment? It uses a carrier and tracking number to report events such as acceptance, transit, delivery, or exception. You may save a tracking number when returning an item to a consignor, but it says nothing about ownership terms, sale proceeds or the amount owed.
2. Mall-owner POS and vendor statements
The mall's register records customer purchases and usually attributes sales to a booth or vendor. Depending on the mall, a statement may include tag numbers, descriptions, discounts, taxes, commissions, fees, or returns. This is the mall's transaction record.
It may not know who owns each piece in your booth, the terms you promised that person, whether you reimbursed restoration work, or whether a settlement has been paid. Even when the mall provides item-level detail, you still need your own consignor records.
3. Vendor-side consignment inventory
Your ledger connects the physical item to:
* the consignor who owns it;
* the agreement governing it;
* its current location and status;
* the customer sale reported by the mall;
* deductions allowed by the agreement;
* the settlement owed and payment record.
Keeping these functions distinct prevents a common mistake: treating a mall payout as proof that every consignor has been paid correctly.
Agree on terms before accepting the item
Consignment creates obligations on both sides. Put the agreement in writing before the item enters your storage area or booth. Requirements vary by location and business structure, so use professional legal or accounting advice when needed rather than copying a generic form blindly.
At minimum, clarify:
* Legal or business names and current contact details
* A consignor ID
* Agreement start date and duration
* Who sets the initial price
* Whether either party may change the price
* Whether discounts are permitted and who absorbs them
* How sale proceeds will be divided
* Which expenses or fees may be deducted, and how
* When an item is considered sold
* Settlement schedule and payment method
* Responsibility for damage, theft, loss, returns, or chargebacks
* Unsold-item pickup or return process
* What happens if the consignor cannot be reached
* Any category restrictions or proof-of-ownership requirements
* Signatures or other evidence of acceptance
Avoid ambiguous language such as “split after fees” unless the agreement defines which fees, their order, and the calculation base. A reliable system cannot repair unclear terms after a sale.
Give every item a unique consignment ID
Descriptions alone are not enough. “Blue vase” can easily become three different objects. Assign a unique ID at intake and use it everywhere: the agreement or intake receipt, photographs, physical tag, inventory record, mall POS description or SKU field when supported, and settlement.
A readable ID might combine the consignor and a sequence, such as RIV-0042. The format is less important than uniqueness and consistency. Do not reuse an ID after an item leaves inventory.
Record these fields at intake:
Field
Why it matters
Item ID
Connects every later event to one object
Consignor ID
Establishes ownership
Description
Helps identify the item without the tag
Photos
Documents identity and intake condition
Condition notes
Reduces disputes about later damage
Date received
Starts the custody timeline
Agreed initial price
Preserves the approved starting point
Agreement version
Connects the item to the correct terms
Current status
Shows whether it can be sold or settled
Current location
Shows where to find it
For higher-risk categories, record maker marks, signatures, serial numbers, dimensions, materials, included parts, and known defects. Do not state uncertain age, origin, or authenticity as fact.
Track status and location as separate fields
An item's status tells you what is happening to it. Its location tells you where it is. Combining both in one free-text note creates confusion when inventory moves.
Useful statuses might include:
* Received: awaiting inspection or preparation
* Ready: accepted and available to place
* For sale: active in a booth or another channel
* On hold: temporarily unavailable
* Sold: transaction confirmed, not necessarily settled
* Returned: customer return recorded
* Settlement due: proceeds calculated and owed
* Settled: consignor payment completed
* Return to consignor due: unsold and ready for pickup or shipment
* Closed: returned, settled, or otherwise resolved
Locations might include storage, Booth A, Booth B, display case, market event, repair, or return transit. Record every move with a date. If you manage more than one selling location, the workflow in How to Track Inventory Across Multiple Antique Mall Booths can help keep transfers from disappearing between systems.
Reconcile the mall statement before calculating settlements
A sale alert is not always the final accounting event. The mall may apply a customer discount, commission, transaction fee, return, or other adjustment under your vendor agreement. Use the finalized statement or other authoritative mall record for the settlement period.
A disciplined reconciliation looks like this:
1. Import or enter each mall sale using the unique item ID.
2. Match the statement line to your inventory record.
3. Confirm sale date, gross selling price, discount, and any item-level adjustment.
4. Investigate unmatched lines instead of guessing which item sold.
5. Record returns or reversals under the original item ID.
6. Apply only the consignment deductions authorized by that item's agreement.
7. Calculate the consignor amount and your amount.
8. Review the period total against the mall's payout and fees.
9. Lock or preserve the settled record so later edits leave an audit trail.
This process also helps you distinguish consigned profit from cash flow. Money deposited by the mall is not automatically all yours; some may be payable to consignors.
For the broader booth economics around rent, inventory cost, and location fees, read How to Calculate Your Real Profit Selling at Antique Malls.
Work one settlement example all the way through
Assume a lamp sells for $140. The item's agreement says an authorized $14 sales-related deduction is taken before the remaining proceeds are divided: $126 remains, the consignor receives $75.60, and the vendor receives $50.40.
Settlement line
Amount
Customer sale
$140.00
Authorized deduction
-$14.00
Amount available for division
$126.00
Consignor amount
$75.60
Vendor amount
$50.40
These numbers and terms are illustrative only. They are not recommended fee or split percentages. In a real settlement, use the exact sequence, deductions, and share in the signed agreement. If the agreement instead divides gross proceeds, assigns the deduction to one party, or handles discounts differently, the result changes.
The settlement should show enough detail that the consignor can reproduce the calculation without calling you.
Issue an itemized statement and preserve proof of payment
A useful consignor statement includes:
* Consignor name and ID
* Settlement period
* Each sold item's ID and description
* Sale date and gross selling price
* Customer discount, if relevant
* Each authorized deduction
* Calculation base and agreed share
* Amount due for each item
* Prior adjustments or returns
* Total due
* Payment date, method, and reference
Marking a record “paid” is not enough. Save the payment confirmation, check number, receipt, or transaction reference. If the consignor acknowledges receipt, retain that too according to your record-retention practice.
Also keep an exceptions queue. Unmatched mall sales, missing tags, disputed deductions, returned merchandise, and failed payments should remain open until a person resolves them. Silent assumptions are where small discrepancies become trust problems.
Audit the physical inventory on a routine schedule
Consignment records should agree with what is physically present. Choose a count rhythm that matches your volume and access to the booth, then use the item IDs to compare the floor to the ledger.
For each expected item:
* find it physically;
* confirm tag and price;
* inspect condition;
* verify location and status;
* note any unauthorized price change;
* investigate anything missing.
Do not wait until an agreement expires to discover that an item moved, sold without a usable ID or was damaged weeks earlier. Photographing the booth after a restock can support the record, but photos do not replace a count.
Handle unsold items with the same care as sales
At the end of the agreed period, record the next authorized action. That might be renewal, a price review, movement to another venue, pickup, or return shipment.
For pickup, obtain a dated acknowledgment listing the returned item IDs. For shipment, record the carrier and tracking number. This is where parcel tracking supports your consignment ledger rather than replacing it. Keep packing evidence for valuable or fragile items and update status only when the return process is actually complete.
Never let “consigned” become a permanent status for abandoned records. Each item needs a documented resolution consistent with the agreement and applicable rules.
Vendor-side consignment checklist
At intake
* Signed or accepted agreement on file
* Consignor identity and contact details recorded
* Unique item ID assigned
* Description, condition, and photos captured
* Price and agreement version linked
* Physical tag matches the ledger
During the selling period
* Status and location kept separate and current
* Every transfer dated
* Mall POS identifiers match your item IDs where possible
* Physical counts performed on schedule
* Discounts and price changes authorized and logged
At settlement or return
* Mall statement reconciled
* Returns and adjustments resolved
* Only authorized deductions applied
* Itemized consignor statement issued
* Payment proof retained
* Unsold-item handoff or shipment documented
* Final status recorded without deleting history
Choose a tool that preserves accountability
A notebook can work at very low volume if you keep the IDs, agreements, moves, and settlements current. A spreadsheet adds filtering and calculations, although attachments and multiple versions can become awkward as consignors and locations multiply. Put any system through a simple test: Can it quickly tell you who owns an item, where it is, what happened to it, and what is owed?
MaxIMS includes consignment management on the Premium plan, alongside inventory and location tracking for small sellers. It is not a parcel-tracking service or a replacement for the mall owner's POS. It is an option for maintaining the vendor-side record that connects consignors, items, locations, sales, and settlements. Choose the system that leaves a clear trail for every item and every dollar owed.