Consignment Store Spreadsheet Template

A spreadsheet can run a consignment store — up to a point. If you're just getting started with a few consignors and slow intake, it's a perfectly valid tool. The question isn't whether a spreadsheet works; it's how to build one that actually does the job, and how to recognise when you've reached its limits.

What a consignment spreadsheet needs to track

A functional consignment spreadsheet typically needs at least two linked sheets: a consignor register and an item log.

Consignor register

One row per consignor, with columns for:

• Name and contact details (phone, email)
• Commission rate (e.g. 40% to store, 60% to consignor)
• Payout schedule (monthly, on request)
• Running balance (what you currently owe them)
• Last payout date and amount

Item log

One row per item, with columns for:

• Consignor reference (linking back to the consignor register)
• Item description
• Asking price
• Intake date
• Status: on floor / sold / returned / donated
• Sale date and sale price (when sold)
• Consignor share (calculated: sale price × consignor rate)
• Store commission (sale price × store rate)

The commission formula

If your consignor rate is 60% and an item sells for $80:

• Consignor share = $80 × 0.60 = $48
• Store commission = $80 × 0.40 = $32

In a spreadsheet, you'd set this up as a formula that references the consignor's rate from the register: =sale_price * VLOOKUP(consignor_id, consignor_table, rate_column, FALSE). When the consignor rate changes, the formula updates automatically — but only for new sales, not ones already recorded.

Where it breaks down

The spreadsheet works until the volume grows. Specific failure points:

• Manual sale entry. Every sale at the register has to be manually found in the spreadsheet and marked sold. One missed entry throws off the balance.
• Generating statements. Producing a per-consignor payout statement means filtering, copying to a new sheet, and formatting — every month, by hand.
• Refunds. A returned item needs to reverse the credit, which is a manual edit with no audit trail.
• Multiple consignors, multiple rates. VLOOKUP formulas work, but they're fragile. A typo in a consignor ID and the wrong rate is applied silently.

The spreadsheet works until it doesn't — and when it fails, it fails quietly. A wrong formula or a missed entry produces a payout dispute, not an error message.

When to switch to dedicated software

Two clear signals: payout prep takes you more than an hour, or you've had a dispute that your records couldn't resolve cleanly. Either means the spreadsheet is costing you more in time and stress than a proper tool would cost in money.