Running Cannabis Consignment on Spreadsheets? Here's What It's Costing You.

I know this spreadsheet. I used to be the person building it.

Before I built ShelfSpace, I ran cannabis operations for a decade. And for most of that time, consignment lived in a spreadsheet. A big, color-coded, formula-heavy spreadsheet that someone on my team opened every Monday morning and spent the next several hours populating with data from our POS, cross-referencing against vendor contracts, calculating what we owed, and then handwriting checks at a desk.

It worked. Sort of. The checks went out. The vendors got paid. But every week, there was a nagging feeling that we were leaving money on the table, missing credits, overpaying on errors we couldn't see, and burning hours that could have been spent on things that actually grew the business. That nagging feeling turned out to be right — and it turned out to be worth a lot more than we realized.

The weekly spreadsheet ritual

If you're running consignment on spreadsheets, you know the drill. It goes something like this, every single week.

Step 1: Export POS data. Someone on your team logs into your POS — Dutchie, Treez, Flowhub, whatever you use — and exports a sales report filtered by consignment vendors. They download a CSV. They open it in Excel. They start cleaning up the data — removing test transactions, fixing product names that don't match, reconciling any discrepancies between what the POS shows and what they think actually happened.

Step 2: Match to vendor contracts. Now they need to apply the right profit split for each vendor. But vendor A has a 60/40 split on flower and a 70/30 on concentrates. Vendor B has a flat 65/35 but with an aging discount that kicks in after 30 days. Vendor C has a promotional offset that reduces their share by 5% this month. All of those terms live in contracts, and they need to be manually applied to the correct line items in the spreadsheet.

Step 3: Calculate settlements. The formulas fire. Revenue times split percentage, minus returns if anyone remembered to log them, minus credits if anyone is tracking them (they're probably not). The spreadsheet produces a number for each vendor. Is it right? Probably close. Maybe. There's no verification against Metrc. There's no system checking the math. There's just the person who built the spreadsheet, hoping the formulas haven't broken since last week.

Step 4: Write the checks. Handwritten checks, or printed from QuickBooks. Either way, someone is sitting at a desk, writing vendor names, dollar amounts, and dates on physical checks. Then those checks need to get to the vendor — mailed, hand-delivered, or held for pickup. Every week.

Step 5: Answer the emails. "Hey, my settlement looks low this week." "Can you send me a breakdown of what sold?" "I think you missed a return credit." "When can I pick up my check?" Every consignment vendor has questions, and every question lands in your inbox or on your phone. Every week.

What it costs in time

Let's be conservative. The weekly spreadsheet ritual — POS export, data cleanup, contract matching, settlement calculation, check writing, and vendor communication — takes 10 to 15 hours per week for a dispensary with 8 to 12 consignment vendors. Some weeks more, some weeks less, but that's the average.

At $25 to $35 per hour for the person doing this work, that's $250 to $525 per week. Multiply by 52 weeks: $13,000 to $27,300 per year. Just in labor. Just for one dispensary. And that person isn't doing strategic work. They're not analyzing vendor performance, or negotiating better terms, or figuring out which consignment relationships are actually profitable. They're pulling data and writing checks.

What it costs in errors

Spreadsheets don't verify themselves. One wrong formula — a VLOOKUP that pulls the wrong split, a SUM range that misses a row, a filter that excludes a product category — and the settlement is wrong. You're either overpaying the vendor (which costs you money) or underpaying them (which costs you the relationship).

Over 52 weeks, even small errors compound. A 2% error rate on $50,000 in monthly consignment settlements is $1,000 per month in overpayments or underpayments. That's $12,000 per year in settlement accuracy alone — money that's either leaving your account or creating vendor disputes that burn time and trust.

And those are the errors you eventually catch. The ones you don't — a missed return, a forgotten promotional credit, a contract term that was updated but never reflected in the spreadsheet — those compound silently in the background, week after week.

Moisture loss is another silent cost. Bulk flower you buy by the pound and sell deli-style sheds weight as the jar sits open, and a spreadsheet has no way to flag it. Here's how consignment counters moisture loss.

What you're not doing on spreadsheets

Here's where the real cost hides. It's not just what spreadsheets do poorly. It's what they don't do at all.

Credit recovery: $8,000 to $25,000 per month left on the table. Your consignment vendors owe you credits. Product that expired on your shelf with credit terms in the agreement. Returns that were processed in Metrc but never credited back. Co-marketing commitments that were fulfilled but never claimed. Promotional dollars that were earned but never invoiced. A spreadsheet can't scan Metrc for returns. It can't cross-reference vendor agreements for credit terms. It can't track promotional commitments. It just sits there, calculating what you owe the vendor — never what the vendor owes you. We routinely find $8,000 to $25,000 per month in recoverable credits during our first evaluation of a new dispensary. That money was always there. The spreadsheet just couldn't see it.

Vendor communication: your phone rings all day. Without settlement reports, vendors don't trust the numbers. Without a portal, they can't check their own payment history. Without AI-powered communication, every question comes to your team. The vendor calls. Your person stops what they're doing, opens the spreadsheet, finds the data, explains the settlement, and gets back to work — until the next vendor calls. Multiply that by 8 to 12 vendors and it's not just time. It's interruption cost.

Invoice verification: you pay what the vendor says. When a consignment vendor sends product, the invoice says what they shipped. But what actually arrived? In a spreadsheet workflow, there's no verification against Metrc manifests. You're trusting the invoice. We recently caught a $4,873 duplicate invoice at a dispensary that had been doing consignment on spreadsheets for years. They were about to pay it because the spreadsheet had no way to flag it.

The alternative: run consignment on a cannabis-specific system

ShelfSpace replaces the entire spreadsheet workflow with a cannabis-specific system that does the heavy lifting.

The platform pulls the data. ShelfSpace connects to your POS and Metrc. Sell-through data, package-level inventory, transfer manifests — it all flows in. No exports. No CSVs. No Monday morning data cleanup.

The platform runs the math. Every settlement is calculated against vendor contract terms — splits, aging discounts, credit offsets, promotional deductions. The output is accurate to the penny. No broken formulas. No missed rows.

The platform generates the checks; you sign and send. Check 21 compliant checks generated for every vendor, every cycle. Vendors download and deposit via mobile through their free portal. No handwriting. No envelopes. No trips to the post office.

The platform builds the credit memos. Returns in Metrc, expirations with credit terms, co-marketing commitments, promotional dollars — all surfaced into monthly credit memos. Those credits get documented and deducted from the next settlement. The money that was invisible in your spreadsheet shows up as real dollars back in your account.

ShelfiQ catches routine vendor questions. ShelfiQ answers the predictable stuff — settlement questions, credit explanations, payment confirmations, check instructions — pulling live numbers from the platform. Anything that needs a judgment call escalates to your AP person with the full thread attached. You own the vendor relationship; ShelfiQ keeps the inbox quiet.

You approve and move on. Your entire weekly consignment workload becomes this: review the settlement summary, approve the payment run, move on with your day. That's it. Under an hour per week, instead of 10 to 15.

What this actually looks like in dollars

Take a dispensary with 10 consignment vendors and $60,000 per month in consignment settlements. On spreadsheets, they're spending $20,000 per year in labor, losing $12,000 per year in settlement errors, and missing $10,000 per month in recoverable credits. That's $152,000 per year in total cost — and they don't even realize most of it.

With ShelfSpace, the labor drops to near zero. The errors drop to zero. The credits get recovered. The vendor communication gets handled. The checks get cut. The math works out, every week, to the penny. ShelfSpace is usage-based and priced during the free evaluation to be net-positive against the dollars we find — if the math doesn't clear, we don't take you on.

We'll run a free evaluation on your consignment program. We'll show you the credits hiding in your Metrc data, the hours your team is spending on the spreadsheet, and exactly what it costs to keep doing it yourself. No commitment. Just the math.