Spreadsheet vs Consignment Software
Most consignment stores start with a spreadsheet. It works — until it doesn't. The question isn't whether a spreadsheet can track consignment; it's when maintaining it starts costing more than switching would. Here's an honest comparison.
What a spreadsheet does well
For a small operation with a handful of consignors and slow intake, a spreadsheet is a perfectly reasonable tool. It's free, flexible, and you can build exactly the columns you want. If you're just getting started, there's nothing wrong with it.
Where it starts to break down
The cracks appear as volume grows. A few common failure points:
- Manual sales entry. Every sale has to be matched from your point-of-sale system to the right row in the sheet by hand. That's easy for ten items; it's error-prone and time-consuming for a hundred.
- Commission calculation errors. A formula that works for a flat 40% split gets complicated fast when different consignors have different rates, or an item was discounted mid-run.
- No history per consignor. You can see a snapshot, but reconstructing what happened to a specific consignor's items over six months requires digging through rows that were never designed for that.
- Payout statements. Generating a per-consignor statement from a flat spreadsheet means filtering, copying, formatting — every time, by hand.
- Nothing catches mistakes. A mistyped price or a deleted row has no audit trail. You find out when a consignor disputes the total.
What purpose-built software adds
| Task | Spreadsheet | Consignment software |
|---|---|---|
| Log a new consignor | Add a row | Create a record with contact details and terms |
| Record a sale | Find the row, update manually | Attributed automatically at point of sale |
| Calculate commission | Formula (fragile) | Automatic, per consignor rate |
| Handle a refund | Edit manually, easy to miss | Reverses the credit in the ledger |
| Generate a statement | Filter, copy, format | One click, itemised |
| Audit trail | None | Full history of sales and adjustments |
When to switch
The honest answer: when payout prep takes you more than an hour, or when you've had a dispute that your records couldn't resolve cleanly. Those are the two signals that the spreadsheet is costing you more in time and stress than a dedicated tool would cost in money.
A spreadsheet built for tracking inventory isn't built for consignment. The missing piece is ownership — every item tied to a person, every sale flowing back to the right ledger automatically.