Consignment stock: how it works and where it breaks

Consignment is common in cannabis retail for a simple reason: it lets a vendor get product onto a shelf without the store paying for it upfront, and lets a store carry more variety without tying up cash in stock that might not sell. The vendor is paid as - and only as - their stock actually sells.

The mechanics

• A vendor delivers stock to the store, which the store doesn't own outright
• The store sells it alongside everything else at the till
• The vendor's balance decreases with every sale of their product
• The store owes the vendor a payout, usually on a set schedule
• Stock the vendor wants back gets returned, adjusting the balance again

That's simple enough with one vendor and a handful of products. It stops being simple with several vendors, overlapping product lines, and returns happening at the same time as new deliveries.

Where it breaks in a spreadsheet

A spreadsheet tracks a snapshot, not a live balance. Every sale has to be manually logged against the right vendor and product. Miss one line, and the vendor's balance is wrong from that point forward - and it stays wrong until someone notices, usually at payout time, usually as an argument about a number nobody can fully reconstruct.

Returns make it worse. A returned item has to be matched back to the original sale, the vendor's balance corrected, and the store's own stock count adjusted - three edits, in three places, that all have to agree. In a spreadsheet, that's three chances for a typo to become a discrepancy nobody can explain a month later.

Licence and compliance details compound it

Each vendor typically has a licence number and expiry that needs checking before their stock goes on sale at all. That's a separate piece of information that has to be cross-referenced against every delivery - another manual step, another place for the tracking to fall out of sync with reality.

What a proper system changes

The fix isn't more discipline with the spreadsheet - it's not having the balance live in a separate place from the sale at all. Every sale of a consigned item should update the vendor's balance automatically, at the moment it happens, with returns and payouts handled the same way. Budstack tracks vendor balances this way, so the number a vendor sees on payout day matches what actually sold, without anyone reconstructing it by hand.