It's the last day of the month, and you're sitting with a shoebox of receipts and a spreadsheet that has three tabs, two of them out of date. Somewhere in there is the answer to a simple question: which of Dana's pieces sold, and what do you owe her for them. You know it's in the numbers. You just have to reconstruct it, line by line, the way you do every single month.
Then the text lands, right on cue. "Hey, no rush, but did the blue vase ever find a home?" It's friendly. It's also the third maker to ask this week, and each of those little messages means you stop what you're doing and go dig through the box.
Stocking local work runs on two things: a shared trust and a messy spreadsheet. The trust is real and worth protecting. The spreadsheet is where it quietly frays, because the maker can't see into it and you can't always remember it. A small automation patches most of that gap, and it won't ask you to learn accounting software you'll come to resent.
Capture the sale the moment it rings up
Everything else depends on one thing: knowing a piece sold the instant it sells, not at closing when the memory's already gone fuzzy. If that fact lives only in your head between the sale and the end of the day, you've lost the thread before you started.
The fix is to tie each maker's work to your register so the sale tags itself. Most point-of-sale systems (Square, Clover, Shopify, the app that runs your card reader) let you attach a category or a short code to every item. Give each maker their own tag, and every ring-up quietly records whose piece just left the shop.
- Give every maker a code. Something short and human, like DANA-CERAMICS or the maker's initials. You'll use it everywhere.
- Tag each item as it comes in. When you take in new work, enter it once with the price and the maker's code. This is the ten minutes that saves you the hour later.
- Let the register do the remembering. When it sells, the system already knows the piece, the price, the date, and the maker. That's the whole record, captured without a sticky note.
If your POS can't tag items cleanly, a shared spreadsheet with one row per piece works too. The point isn't the tool. It's that the sale gets written down the second it happens, by something other than your memory.
What the alert should actually say
Once the sale is captured, an automation can send the maker a note the moment their piece rings up. A tool like Zapier or Make (services that watch one app and act in another) can catch the sale and fire off a text or email without you touching a thing.
Keep it warm and keep it short. A maker at their bench doesn't need a spreadsheet in their inbox. They need to know their work found a home and that you've got the math handled.
- What sold: "Your blue stoneware vase just sold."
- For how much, and their cut: "Sold for $85. Your share is $51." Do the split for them so nobody's reaching for a calculator.
- When: the date, so it lines up with the statement later.
- A human sign-off: "Nice one. Full statement comes at month-end."
One honest caution here. A ping on every single sale is lovely for a maker who sells a piece a month, and a nuisance for one whose earrings fly off the shelf. Ask each maker which they'd prefer: a text per sale, or a quiet daily or weekly digest. The automation can do either, and letting them choose is the difference between a thoughtful touch and a buzzing phone.
Log the split so the math is never a mystery
Consignment lives and dies on the split, whether it's 60/40, 70/30, or a flat booth fee. When that number lives only in a handshake and your head, month-end turns into archaeology. Write it down once, per maker, and let every sale reference it.
Have your automation drop each sale into a running log: date, piece, sale price, the split, your cut, their cut. That's it. No formulas to babysit, no tab that goes stale. The moment a sale is captured, the row appears, already split.
This does something quieter than save time. It makes the arrangement visible. A maker who can see the same tidy record you see never has to wonder if they've been forgotten, and you never have to defend a number from memory. Honest paperwork is mostly just paperwork that both sides can look at.
Build the month-end statement on autopilot
The payout statement is the part everyone dreads and nobody should have to hand-build. If every sale is already logged and split, the statement is just that log, filtered to one maker and one month. The automation can assemble it for you and send it out on the first, before anyone thinks to ask.
A clean statement doesn't need to be fancy. It needs to answer every question a maker might have before they ask it.
- Each piece that sold, with the date and price.
- Their share of each, and the total owed.
- Anything you're deducting (a booth fee, a card-processing cut), spelled out plainly.
- How and when they'll be paid.
Send it the same way every month, on the same day. Predictable beats fancy every time. When a statement shows up like clockwork on the first, the nudging texts stop, because there's nothing left to nudge about. The maker trusts the rhythm, and you get your month-end evening back.
Keep the actual payment human if you like. Plenty of shops still hand over a check with a real thank-you. The automation handles the counting and the record. You handle the part that's about the relationship.
Worth doing this week
You don't have to wire all of this up at once. Start with the piece that removes the most guesswork, and build from there.
- Give each maker a code and tag their work in your register or a simple sheet. This is the foundation, and it's an afternoon of work at most.
- Write down every split in one place, so the math stops living in your memory.
- Turn on one alert for your most anxious maker first. Watch how fast the "did it sell?" texts dry up.
- Draft the statement layout once, using last month's sales, so the format's ready to run on the first.
- Ask each maker how often they want to hear from you. Two minutes of asking saves a lot of second-guessing.
If wiring the register to the texts and the statement sounds like one project too many, that's the kind of plumbing we set up for shops around here all the time. Either way, the goal is the same: your makers stop wondering, and you stop reconstructing sales from a shoebox.