Consignor Management Software: How to Track Estimates, Approvals, and Payouts in One Place

The Consignment Management Problem

If you run a consignment shop or auction house that takes items from consignors, you already know the bookkeeping headache. Every consignor has different commission rates. Every item needs to be tracked from intake through sale (or return). And at the end of the month — or after every auction — you owe settlements to a dozen different people, each with a different payout calculation.

Most shops manage this with some combination of spreadsheets, paper receipts, and memory. It works until it doesn't — and it usually stops working right around the time you grow from 10 consignors to 40.

What Consignor Management Software Should Do

Before we get into specific tools, here's the workflow a consignor management system needs to support:

1. Consignor Intake and Tracking

Each consignor needs a profile: name, contact info, commission rate, and a running list of every item they've consigned. When new items come in, you assign them to the consignor and the system tracks them from that point forward.

2. Pre-Sale Estimates

For auction houses and higher-end consignment shops, consignors often want estimates before they agree to consign. The system should let you create and send value estimates, track whether the consignor approved or declined, and move approved items into your inventory.

3. Commission Rate Management

Different consignors get different splits. Your standard rate might be 60/40, but your biggest consignor negotiated 70/30, and that estate deal you just signed has a sliding scale based on hammer price. The system needs to track these per-consignor and apply them automatically at settlement time.

4. Item Lifecycle Tracking

Every consigned item moves through stages:

• Prospective — Estimate sent, waiting for approval
• Received — Item is in your possession
• Listed — Item is live in a catalog or on a selling platform
• Sold — Sold at auction or direct sale
• Returned — Item didn't sell and was returned to the consignor
• Declined — Consignor declined to consign after estimate

The system should track each item's current status and let you filter by stage.

5. Settlement Generation

After a sale, the system calculates what each consignor is owed: which items sold, at what price, minus your commission, equals their payout. This should happen automatically — not in a spreadsheet where one wrong formula means you overpay or underpay someone.

6. Reporting

You need to answer questions like: How much do I owe consignor X? What's still unsold from last month's intake? Which consignors bring in the highest-performing inventory? A good system answers these without manual data pulling.

How Estimint Handles Consignor Management

Estimint builds consignor management directly into the item and catalog workflow. Here's how each piece works:

Consignor Profiles

Create a profile for each consignor with:

• Name and contact information (email, phone)
• Unique consignor code (for quick lookup)
• Commission rate (percentage)
• Notes

All items assigned to a consignor are visible from their profile — you can see their complete consignment history in one place.

Estimates

Estimint's estimate workflow lets you:

1. Create an estimate for one or more items, with AI-generated value ranges
2. Send the estimate to the consignor via email with professional formatting
3. Track the response — Received, Approved, Declined
4. Move approved items directly into your inventory

This is especially valuable for auction houses that evaluate potential consignments before accepting them. The consignor sees a polished estimate document; you track the status without back-and-forth emails.

For more on estimates, see our text-only estimates guide.

Item Assignment

When items arrive, assign them to their consignor in a couple of clicks. The item carries that consignor assignment through its entire lifecycle — into catalogs, through the auction, and into settlement.

Automatic Settlements

After you close an auction catalog, Estimint generates consignor settlement statements automatically:

• Per-consignor breakdown of every lot: lot number, title, hammer price, commission, net payout
• Commission calculated based on each consignor's individual rate
• Summary totals for easy reference
• PDF export for your records or to send to the consignor

No spreadsheet formulas. No manual calculations. Close the auction, and settlements are ready.

Lifecycle Dashboard

Filter items by consignor and status to see:

• What's been received but not yet listed
• What's currently in an active catalog
• What sold and at what price
• What needs to be returned

The Spreadsheet Problem

Let's be honest about why spreadsheets break down for consignment:

Formula errors are invisible. One wrong cell reference in your commission calculation and you're paying the wrong amount. You won't catch it until the consignor does — or until your books don't balance.

Multiple sources of truth. The spreadsheet says an item is "received" but the email thread says the consignor hasn't approved it yet. When your data lives in three places, discrepancies are inevitable.

Reporting is manual. "How much do I owe all my consignors combined right now?" In a spreadsheet, answering that question means updating every sheet, checking every formula, and hoping nothing is stale.

Scaling breaks everything. 10 consignors with 20 items each is manageable. 40 consignors with 100 items each is a full-time job just maintaining the spreadsheet.

Who Needs Dedicated Consignor Management?

Not every business needs this. If you buy all your inventory outright and don't take consignments, you don't need consignor tracking.

But if any of these sound familiar, you do:

• You take items from consignors and owe them a percentage of the sale
• You send estimates to potential consignors before accepting items
• You have different commission rates for different consignors
• You need to generate settlement statements after sales
• You track items from intake through sale or return

This applies to auction houses, consignment shops, estate sale companies, and any reseller working with consigned inventory.

Getting Started

Estimint's consignor management features are available on the Pro plan ($89/mo) and above. You can test the workflow on the free trial:

1. Sign up free — 200 listings, 30 days
2. Create a few test consignors with different commission rates
3. Assign items and build a test catalog
4. Close the catalog and review the auto-generated settlements

For the full consignor workflow walkthrough, see our consignor tracking guide.

If you're currently managing consignors in spreadsheets and it's starting to hurt, this is worth 30 minutes of your time to test.