The Spreadsheet That Saves Consignment Shops From Losing Money (and Friends)

Consignment shops run on trust. A stranger hands you their grandmother's leather coat, you promise to sell it and split the money, and both of you have to believe the other one is keeping track. The shop that fumbles that trust — pays out late, loses track of items, forgets the 90-day rule — doesn't lose a sale. It loses every future consignor that person talks to.

I've spent time around enough small consignment and vintage shops to see the same three money leaks in all of them. None of them are glamorous. All of them are fixable with a spreadsheet and one script.

Leak #1: The 90-day rule nobody enforces

Most consignment shops have a standard policy: if an item hasn't sold in 90 days, you either mark it down or return it to the consignor. It keeps inventory fresh and it keeps consignors happy.

In practice? The date is written on a paper tag, the tag gets buried, and three months later the coat is still hanging there unsold while the consignor starts wondering where it went. When you finally "find" the item, it's been 140 days and the consignor is annoyed, the inventory is stale, and you ate the storage cost.

The fix is a countdown, not a calendar. Every consignment line gets a "days to 90-day" figure computed automatically. The sheet flags anything approaching the deadline — green, yellow, red — so the owner sees at a glance what needs marking down this week instead of discovering it in a drawer in January.

Leak #2: The payout math

Here's how it usually goes: consignor brings 6 items. Three sell this month at different prices with a 40% commission. Two more sell next month. One never sells and gets returned.

By the end of month two, the owner is doing arithmetic across a pile of handwritten receipts: "Item A sold at $85, so consignor gets 60% of that, minus the $10 markdown we agreed… and wait, did we return the green jacket?"

This is where money and trust both leak. The consignor does their own mental math, and if the payout is $7 short, they don't complain — they just never come back, and they tell their friends.

The fix is a per-consignor settlement sheet that builds itself. Every sale automatically rolls up to "what this consignor is owed," commission applied consistently, markdowns tracked, one total per person. The monthly statement is a one-click email, not an afternoon of reconciliation.

Leak #3: Nobody gets a statement

Even an honest shop loses consignors by looking disorganized. The consignor asks "how's my stuff doing?" and the answer is "uh, I think two of your pieces sold." No numbers, no dates, no statement.

A monthly itemized statement — here's what sold, here's what's still in the shop, here's your balance — turns a vague relationship into a professional one. It takes five minutes to send and it's the cheapest retention tool a consignment business has.

What I built

A self-contained Google Sheets workbook that does all three:

• Status that computes itself — each item is automatically Sold, In Stock, or 90-Day Due based on its dates, with a live countdown column.
• Per-consignor settlements — every sale rolls up to what each person is owed, commission included, with a running total.
• Automated reminders — a Google Apps Script checks daily for items hitting 90 days, and emails the owner. A second script emails monthly statements to every consignor with open balances.

No API keys, no monthly subscription, no install. Open the sheet, type in your consignments, and the columns, totals, and reminders take care of themselves.

I packaged the whole thing (workbook + the two Apps Scripts + setup instructions) over at AgentChip. It's aimed at the shop owner who'd rather spend Sunday afternoon pricing new arrivals than reconciling last month's payouts.

Trust is the inventory of a consignment shop. A good tracking sheet is how you protect it.

---

Originally published on the AgentChip blog.