FMCG Wholesale Depot, Beverage Bottling & Returnable Glass Crate (RGB) Distribution ERP: Empties Deposit Reconciliation, Van-Sales Geofencing, and Trade-Promo Rebates

In high-velocity Fast-Moving Consumer Goods (FMCG) distribution—spanning carbonated soft drinks, beer and spirits depots, bottled water plants, commercial bread bakeries, and multi-brand wholesale distributors—margins are measured in single-digit percentages while daily route truck volumes run into tens of millions of shillings. For beverage and bakery distributors operating Returnable Glass Bottle (RGB), plastic bread crate, or 18.9L polycarbonate water dispenser bottle loops, the physical returnable crate and glass shells on a route truck are often worth more than the liquid or bread being sold.

At devManue, we engineer high-speed FMCG Wholesale Depot, Beverage Bottling & Returnable Crate Distribution ERP systems that combine dual liquid-and-empties inventory accounting, offline Android van-sales geofencing, dynamic trade-promotion ("buy 10 cases get 1 free") rebate engines, and real-time M-Pesa BuyGoods / Paybill + KRA eTIMS fiscalization.

1. Eliminating the Three Profit Killers in FMCG & Beverage Route Sales

• Returnable Crate & Glass Empties Shrinkage ("Paper Empties"): When a route truck leaves the depot at 6:00 AM with 450 full 24-bottle crates, the driver must return at 6:00 PM with an exact combination of unsold full crates, physical empty crates + glass bottles, or cash/approved container deposit loans. Without a strict mobile van-sales lock, drivers collude with warehouse gate clerks to log fictitious empty returns until thousands of crates vanish.
• Territory Poaching & Promotional Free-Issue Abuse: When a manufacturer runs a 5% off-invoice trade discount or a 12+1 free case promotion for rural stockists, unscrupulous van-sales reps sell the discounted stock at full wholesale price to urban supermarkets and pocket the free promotional cases.
• Cash-in-Transit (CIT) Theft & Short-Banking by Van Crews: Allowing route sales crews to collect physical cash all day leads to short-banking ("I was robbed of KES 45,000") and delayed working-capital turnover.

2. Automated Trade-Promotion Engine & Route Truck Gate Settlement

Instead of letting a sales rep manually type discount percentages or free bonus quantities on their handheld device, our Van-Sales Pricing Engine calculates channel-specific trade promotions deterministically based on the outlet's verified tier (Key Account, Stockist, Bar/Restaurant, or Kiosk) and GPS check-in:

# Python / Django: FMCG Van-Sales Trade Promo & Returnable Empties Settlement
from decimal import Decimal

class BeverageRouteSettlementEngine:
    @classmethod
    def compute_route_gate_reconciliation(
        cls,
        loaded_full_crates: int,
        invoiced_sold_crates: int,
        promo_free_issue_crates: int,
        physical_unsold_full_crates_at_gate: int,
        physical_empty_crates_at_gate: int,
        new_crate_deposits_paid_qty: int,
        crate_deposit_value_kes: Decimal,
    ) -> dict:
        '''
        Reconciles both liquid product cases and physical returnable crates/bottles
        at the depot security gate before clearing the route driver.
        '''
        expected_unsold_fulls = loaded_full_crates - (invoiced_sold_crates + promo_free_issue_crates)
        full_product_shortage = max(0, expected_unsold_fulls - physical_unsold_full_crates_at_gate)

        # Every crate dispatched to customers (sold + free issue) must return as an empty crate
        # OR be covered by a paid container deposit
        total_crates_dropped = invoiced_sold_crates + promo_free_issue_crates
        expected_empty_returns = total_crates_dropped - new_crate_deposits_paid_qty
        empty_crate_shortage = max(0, expected_empty_returns - physical_empty_crates_at_gate)

        driver_debit_penalty_kes = Decimal(empty_crate_shortage) * crate_deposit_value_kes
        return {
            "full_crates_shortage": full_product_shortage,
            "empty_crates_shortage": empty_crate_shortage,
            "driver_empties_debit_kes": driver_debit_penalty_kes,
            "gate_clearance_passed": (full_product_shortage == 0 and empty_crate_shortage == 0),
        }