Consignment without the spreadsheet

Consignment is how a lot of UK card shops keep the cabinet full without buying every rare themselves. It is also how a quiet error in a spreadsheet becomes a difficult conversation at month-end, when the split was agreed, the sale happened, and the workbook does not quite believe either of them.

The pattern is familiar. A seller drops a binder or a small stack. Someone writes a percentage on a tab, or a cost as a share of retail, and the shop starts selling. Through the month, cards move, a few come back, a price changes after a tournament, a line gets typed twice. At month-end you rebuild the picture from till exports, notes, and memory.

That is not a character flaw. It is what happens when the commercial agreement lives in Excel and the sale lives somewhere else.

Where the month actually breaks

The break is rarely the headline split. Most shops can remember that a seller is on a cost-percentage, or that a particular binder is on a different cut. The break is everything that has to stay attached to that split as the month unfolds.

A card sells at the till. Did the line map to the right supplier? If it mapped to the shop's own stock instead, you have paid yourself a commission you do not owe, or you have underpaid a seller who will notice. If it mapped to the seller but the price was overridden in the queue, the payout is now a debate about which number counts.

Returns make the same mess in the other direction. The workbook still thinks the card is on the floor. The floor thinks it went home. Nobody is trying to defraud anyone. The records simply do not share a spine.

Then there is labour. Someone competent spends an evening matching names, printings and quantities. That is not merchandising and it is not buying. It is reconciling two systems that were never the same system. The more consignment you take, the more that evening grows, and the more a single mis-typed percentage poisons a payout.

High-value showcase stock makes people careful, as it should. Permission to adjust stock or override a price is a live control. Spreadsheet tabs are not. If anyone with the file can change a split after the fact, month-end becomes archaeology.

Payouts should follow the sale

The cleaner version is boring, which is the point. The seller is a supplier in the same sense the rest of your stock has a source. The split is a cost-percentage attached to that mapping. When the card sells, the payout is a consequence of the sale, not a reconstruction of it.

Stribe POS runs consignment that way: supplier mapping, cost-percentage splits, and payouts that do not need a separate workbook to invent the maths. You are not exporting a month of lines so that someone can multiply them by a remembered rate.

That still leaves room for the fact that no two shops split the same way. A binder from a regular, a case from a trader, a one-off high-value card — the percentages are not a national standard. Stribe is modular enough to tailor around the split, labels and onboarding a shop already runs, rater than forcing a single commission story onto every seller.

What you should not have to tailor is the idea that the till and the payout disagree. If the product sold, the supplier is on the line. If the product did not sell, it is not in the payout. Month-end becomes a review, not a rebuild.

Keep the books you already close

None of this is an argument for ripping out the back office. LA Accounting remains the authoritative engine for transactions, stock movements and the general ledger. Stribe is the frontend that has to be fast enough for a Friday night and strict enough that consignment stock is not a side ledger in someone's downloads folder.

Shops that already close the month in LA do not need a second set of books for sellers. They need the sale, the split and the stock movement to hit the engine they already trust. A POS that will not talk to that engine just adds another export to the evening.

Walk-in sellers notice the difference even if they never see the software. They get paid on what sold, with a record that matches the till, not on a conversation about a tab that "should be right." The shop keeps the relationship. The spreadsheet stops being part of the relationship.

Close the month on the sales, not the tab

The test is the first week of the new month. If you are still reconstructing who owns which line, consignment is costing you more than the split. If the payout is already sitting on the sales that happened, you can spend that week buying, staffing and running the next event.

Retail Sale Solutions put automated consignment into Stribe POS for shops that are done lending their month-end to Excel. If that is your week, have a look at retailsalesolutions.com and we can talk through how supplier mapping and cost-percentage splits sit on top of the books you already run.