First, credit where it's due
The consignment spreadsheet is a rite of passage. It's free, you built it yourself, and for your first dozens of consignors it genuinely works. If you have 15 consignors and an hour of bookkeeping a week, you may not need anything else yet — bookmark this page and come back when it hurts.
How to know it's time
The spreadsheet doesn't fail loudly. It fails as a slow accumulation of small taxes:
- The Sunday session. Split math and balance updates have become a standing weekly appointment measured in hours.
- The unprovable payout. A consignor questions their check and you can't cleanly show, line by line, how the number was built.
- The "did my stuff sell?" tax. Texts and calls you answer by scrolling a 3,000-row sheet while a customer waits at the counter.
- The bus factor. Only you understand the workbook's tabs, colors, and formulas — so you can never be sick, and you can't delegate.
- The silent error. One overwritten formula or a sort applied to half the columns, and numbers are quietly wrong until a payout goes bad. Studies of real-world spreadsheets consistently find errors in the overwhelming majority of them; yours is not the exception.
- The expired-item mystery. Nothing tells you an item passed its 90-day window — you find out when the consignor asks for it back.
Three or more of those, and the spreadsheet is costing more than software would. (We did the direct feature-by-feature math in Consignloop vs. spreadsheets.)
What you're actually migrating
Good news: far less than you fear. You do not need to re-enter years of history. Three datasets matter:
| Dataset | What to bring | What to leave archived |
|---|---|---|
| Consignors | Name, contact info, each person's split | Consignors inactive for over a year (add them back if they return) |
| Inventory | Active items: description, consignor, price, date received | Items already sold or returned |
| Balances | Each consignor's current owed amount, as an opening balance | The old sale-by-sale ledger — keep the file as your historical record |
The week-by-week plan
Before you start: pick the destination
Choose software you've actually tested against your daily workflow — intake, tagging, sale, payout. Our buyer's guide and checklist covers what to look for. Make sure the trial is long enough to complete this whole plan inside it (Consignloop's is 21 days).
Day 1–2: Freeze and clean
- Make a dated copy of the workbook. This copy is sacred — it's your audit trail and your rollback plan.
- Clean the consignor list: one row per person, consistent name spelling, current phone/email, and — critically — each person's split written explicitly, not remembered.
- Clean active inventory: delete sold/returned rows from the working copy, standardize columns (item, consignor, price, date received), fix the "see note" cells.
- Compute each consignor's current owed balance and get comfortable with the numbers — this is the moment to settle any ambiguity, while the old system is still authoritative.
Day 3–4: Import and verify
- Export consignors and inventory as CSV.
- Import into the new system (in Consignloop: consignors first, then the inventory bulk upload, which links items to consignors).
- Enter opening balances.
- Spot-check 10 consignors end to end: right split, right items, right balance. Then check your totals — item count and total owed should match the spreadsheet to the penny. If they don't, fix it now, not after the first payout.
Week 1–2: Parallel run
- The new system becomes the source of truth: every intake, sale, and payout gets recorded there, at the counter, as it happens.
- Keep the frozen spreadsheet open in a tab if it comforts you — but stop editing it. Two live systems is how numbers drift.
- At the end of week one, run your first payout cycle from the new system and hand consignors the printed statement. This is the moment the switch pays for itself.
Week 3: Cut the cord
- Archive the old workbook (read-only, backed up).
- Train staff on the three core flows: intake + tag, record sale, record payout. If the software is any good this takes an hour.
- Optional but transformative: turn on consignor logins for your chattiest consignors. The "did my stuff sell?" texts stop that week.
What changes on day one
- Record a sale and the split is calculated instantly, at that consignor's rate — no lookup, no mental math, no Sunday session.
- Every balance is current the moment a sale or payout is recorded.
- Any statement, any consignor, any date range — printable in seconds.
- Items carry their own expiry clock, with warnings before the window closes.
- It works from your phone, your laptop, and your staff's register — the same numbers everywhere.
Do the whole migration inside a free trial
Consignloop's 21-day trial fits this entire plan with a week to spare. Bulk CSV import for inventory, per-consignor splits, and statements from day one. No card required to start.
Frequently asked questions
When should a consignment shop move off spreadsheets?
Common tipping points: 30–50+ active consignors, more than an hour or two a week on split math and reconciliation, a payout dispute you couldn't cleanly prove, hiring your first staff member, or realizing only one person understands the workbook.
Will I lose my history?
No. Import consignors, active inventory, and opening balances; archive the old spreadsheet as your read-only historical record. Years of past sales don't need re-entering.
How long does it take?
An afternoon to clean and export, a day to import and verify, then one to two weeks of parallel running. Most shops complete it inside a free-trial window without closing for a day.
What data do I need to bring over?
Three things: the consignor list with each person's split, active inventory with consignor/price/date received, and each consignor's current owed balance.