The Anatomy of a Producer Payout: Splitting a €38 Vegetable Box Between 11 Growers, the Co-op and the Van

What is actually inside a €38 vegetable box before anyone gets paid?

A €38 box is not €38 of vegetables. In the run we are dissecting, the shopper paid €38.00 for a box containing €30.15 of produce lines from 11 producers, €2.50 of delivery, €2.00 of returnable crate deposit, and the rest is the co-operative's margin embedded in the shelf prices. Settlement means unwinding that back into 11 payable amounts.

The first mistake most co-ops make on a spreadsheet is treating the box as a single product with a single cost. It is not. It is a bundle of line items, each one attached to a producer, a unit, a quantity picked, a quantity ordered and a price. A box priced at €38 that contains 14 lines can only be settled correctly if every one of those 14 lines is tracked individually from order through picking to delivery. If the picker substitutes one item, the split changes, and the box price does not.

Here is the shape of the box as it went out. Prices are shelf prices, what the shopper sees, inclusive of the co-op's margin.

Potatoes, 3 kg, Producer A, €4.50
Carrots, 1 kg, Producer B, €1.80
Onions, 1.5 kg, Producer B, €2.10
Mixed salad leaves, 200 g, Producer C, €2.40
Cherry tomatoes, 500 g, Producer D, €3.20
Cucumbers, 2 pcs, Producer E, €1.90
Courgettes, 1 kg, Producer E, €2.30
Kale, 1 bunch, Producer F, €1.95
Beetroot, 1 kg, Producer G, €2.20
Leeks, 2 pcs, Producer H, €2.10
Garlic, 3 heads, Producer I, €2.70
Free-range eggs, 10 pcs, Producer J, €3.60
Apples, 1 kg, Producer K, €1.90
Delivery to pickup point, €2.50
Crate deposit (refundable), €2.00

How is the co-operative's commission calculated, flat or per-producer?

Commission is deducted from each line's shelf price, not from the box total. Our default is a flat rate, 18% in this example, but the model supports a per-producer override, and in practice most co-ops end up with two or three tiers. The arithmetic is identical either way: producer payout per line equals shelf price multiplied by (1 minus that producer's rate).

A flat rate is simpler to explain and easier to defend at a general assembly. It breaks down the moment the co-op does genuinely different amounts of work for different producers. The grower who delivers pre-weighed, pre-labelled bags to the hub at 06:00 costs the co-op far less handling than the one whose kale is collected from the farm and bunched by co-op staff. Charging both 18% is a subsidy flowing from the first to the second, and the first one eventually notices.

So the rule we settled on is that the rate is a property of the producer agreement, defaulting to the co-op's standard rate, with overrides recorded with a reason and an effective date. Effective date matters more than it sounds. If a rate changes mid-fortnight, every line settles at the rate in force on the delivery date, not the payout date, otherwise a producer can be paid two different amounts for two identical deliveries in the same week.

Flat rate: one percentage for all producers. Transparent, trivial to audit, quietly unfair when handling effort differs.
Per-producer rate: negotiated per agreement. Fairer, needs a written reason per override or it becomes favouritism.
Tiered by service level: e.g. 14% for hub drop-off, 18% for standard, 24% when the co-op collects and packs. Our recommendation for co-ops above roughly 15 producers.
Per-category rate: lower on high-value, low-handling goods such as honey or oil, higher on wet, perishable, weight-loss-prone produce.

Who pays for a short weight, a refused item or a substitution?

The rule is simple to state and hard to apply: the party that caused the variance absorbs it. Short weight is deducted from the producer who supplied it, refused-on-quality items are deducted from the producer, a co-op picking error is absorbed by the co-op, and a substituted item is credited to the substitute grower, never the original one. Every deduction carries a reason code.

Take the courgettes. Producer E was ordered 1 kg per box across 40 boxes and delivered 37.2 kg. The co-op filled the last three boxes short at 0.6 kg. Those three boxes shipped with 0.6 kg instead of 1 kg, and the shopper was credited €0.92 each at shelf price. That credit is recovered from Producer E's settlement, net of commission, because the co-op should not lose its margin on the volume it did sell, nor earn margin on volume that never existed. In line terms, Producer E is paid for 37.2 kg at €2.30 per kg less 18%, and the shopper credit is handled at shelf price against the box.

Substitution is where spreadsheets go wrong most often. Producer C's salad leaves failed quality check on the morning of packing, and 12 boxes went out with Producer F's chard instead at the same €2.40 shelf price. If the settlement sheet is built from the order, Producer C gets paid for 12 bags of leaves they never delivered. Our settlement is built from the delivery note, not the order, so the €2.40 line for those 12 boxes moves to Producer F entirely. Producer C receives nothing for them and no penalty beyond the lost sale, unless the failure was a repeat, in which case the co-op's quality policy, not the accounting engine, is the right tool.

SHORT_WEIGHT: producer supplied less than picked quantity. Deducted from producer at net price.
QC_REFUSED: item rejected at the hub. Line removed from producer settlement entirely.
SUBSTITUTED: line reassigned to the substitute producer at the shelf price actually charged.
PICK_ERROR: co-op packed the wrong item or missed one. Shopper refunded, cost absorbed by the co-op.
DAMAGED_IN_TRANSIT: absorbed by the co-op's delivery budget, not the producer, once goods have been accepted at the hub.

How are delivery cost, packaging and crate deposits recovered?

Delivery is charged to the shopper as a visible line, not apportioned across producers. Packaging that is consumed, bags and paper, is inside the co-op's commission. Returnable crates carry a €2.00 deposit that is a liability, not revenue: it never touches any producer's settlement, and it is refunded or rolled forward when the crate comes back.

We tried apportioning the van across producers early on, splitting the route cost by line value. It is defensible in theory and unworkable in practice. A grower whose €1.90 of apples travels in the same box as €30 of other produce ends up with an opaque €0.11 deduction they cannot verify, and the deduction moves every week depending on who else happens to be in the box. Producers stopped trusting the number. Charging delivery to the shopper as an explicit €2.50 makes the box price honest and keeps every producer statement free of costs they cannot influence.

There is one exception. Farm collection, where the van makes a detour to a producer instead of the producer delivering to the hub, is a service the co-op provides to that specific producer, and it is recovered either through a higher commission tier or a fixed per-stop fee agreed in advance. That is a cost the producer can actually influence, by delivering to the hub instead, which is exactly the property a fair deduction needs. Crate deposits sit in their own ledger: €2.00 charged, €2.00 refunded on return, and unreturned crates written off against the shopper's deposit after a set number of cycles.

How do VAT-registered and non-registered smallholders settle differently?

Both are paid the same net amount for the same goods, but the paperwork differs. A VAT-registered producer's settlement is a self-billed invoice showing net, VAT and gross, with VAT payable on top of the net figure. A non-registered smallholder's settlement is a purchase document with no VAT line at all, and the co-op cannot reclaim input VAT on those goods.

The trap is that shelf prices are usually set VAT-inclusive, because that is what the shopper pays. If your settlement engine calculates producer payout as a percentage of a VAT-inclusive shelf price without first stripping the VAT, you will pay VAT-registered and non-registered producers different net amounts for identical goods, and neither of them will be able to tell you why. The correct sequence is: shelf price to net-of-VAT, then commission, then add the producer's own VAT if applicable.

Concretely, at a 5% rate on fresh produce, a €2.30 shelf price is €2.19 net. Commission of 18% leaves €1.80 to the producer. A registered producer then invoices €1.80 plus €0.09 VAT, gross €1.89. A non-registered producer receives €1.80 flat. The co-op's margin is €0.39 in both cases. Getting this order of operations wrong is one of the most common defects we find when migrating a co-op off spreadsheets, and it usually shows up as a producer complaining that they are paid less than a neighbour for the same lettuce.

What do the rounding rules and the fortnightly reconciliation view look like?

Rounding happens once, at the producer total, not per line, and it rounds to the cent in the producer's favour. Half-cent differences accumulate into a rounding account owned by the co-op, which typically nets out to under a euro per settlement run. Producers see a single reconciliation screen: opening balance, lines delivered, deductions, adjustments, net payable.

Rounding per line is where cents disappear. If Producer B has 40 lines of carrots at €1.80 shelf, each netting €1.4759, rounding each line to €1.48 pays €59.20 while rounding the total pays €59.04, a sixteen cent gap that nobody can explain from the statement. Rounding once at the bottom, on a total computed at four decimal places, is both cheaper and easier to defend. The co-op absorbs the residual because the co-op, not the grower, chose the pricing scheme that created it.

We moved from monthly to fortnightly settlement after three specific disputes. The first was a substitution paid to the wrong grower and only spotted five weeks later, by which time the picking notes were gone. The second was a short-weight deduction a producer could not reconstruct because it was buried inside a month of aggregated lines. The third was a crate deposit treated as revenue in one month and as a liability the next. Shorter cycles do not prevent errors, they just keep the evidence fresh enough to resolve them. Fortnightly also matches how most small growers manage cash, and the reconciliation view in the Producer app is deliberately built to be readable on a phone in a field, because that is where it gets opened.

Opening balance carried from the previous run, including anything disputed and held
Delivered lines: product, date, quantity accepted, unit price, gross, commission rate, net
Deductions with reason codes and a link to the specific delivery note or shopper credit
Adjustments: crate deposits reconciled, per-stop collection fees, corrections from prior runs
Net payable, VAT treatment, and the payment reference the transfer will carry

Key Takeaways

Settle from the delivery note, not the order, so substitutions credit the grower who actually supplied the goods.
Deduct commission per line at the rate in force on the delivery date, and strip VAT from the shelf price before applying it.
Charge delivery visibly to the shopper rather than apportioning van cost across producers who cannot influence it.
Treat crate deposits as a liability in their own ledger, never as revenue and never inside a producer's payout.
Round once at the producer total, not per line, and let the co-op absorb the residual cent.

If you are still trying to run this arithmetic on top of a single-merchant storefront, we wrote about why Shopify breaks at the second producer, where payouts, shared stock and pickup slots all hit the same wall.

Frequently Asked Questions

How often should a food co-operative pay its producers?

Fortnightly is the sweet spot for most small co-ops. Weekly creates a lot of administrative churn and bank fees for small amounts, while monthly means disputes surface after the picking notes, weigh slips and delivery records have gone stale. Fortnightly keeps evidence fresh and matches how most small growers manage cash flow.

What commission rate do food co-operatives usually charge producers?

Rates vary widely because they cover different amounts of work. A co-op where producers deliver pre-packed goods to a hub can operate on a lower rate than one that collects from farms, grades, weighs and packs. The important thing is that the rate is written into the producer agreement with an effective date, and that any override from the standard rate has a recorded reason.

Should the shopper or the producers pay for delivery in a farm box scheme?

Charge it to the shopper as a visible line on the order. Apportioning van cost across producers produces small deductions that change every week depending on which other producers happen to be in the box, which producers cannot verify or influence. The exception is farm collection, a service the co-op provides to a specific producer, which is fairly recovered through a per-stop fee or a higher commission tier.

How do you handle a producer disputing a deduction on their settlement?

Hold the disputed amount rather than reversing or ignoring it, carry it into the next run as an explicit opening balance line, and resolve it against the underlying delivery note or shopper credit. Every deduction should carry a reason code and a link to the source document, so the conversation is about the evidence rather than about who remembers the week correctly.

Can a co-op run producer settlement in a spreadsheet?

Yes, up to a point, and most co-ops start there. Spreadsheets hold up while lines per run are low and substitutions are rare. They break when you need per-producer commission rates with effective dates, reason-coded deductions linked to delivery notes, a separate crate deposit ledger and different VAT treatment per producer, because each of those adds columns that have to stay consistent across every historical run.