Department Store Shop-in-Shop (SIS) ERP: Concessionaire Tiered Margin Commissions, Minimum Guarantee Top-Ups, and Net Payout Settlement

Why Standard Vendor Consignment Modules Cannot Settle Department Store Concessions?

How should department stores automate shop-in-shop (SIS) concessionaire sales capture, tiered margin commissions, shared-promotion cost splits, and monthly net-of-deduction payouts? The critical distinction is governing a multi-deduction revenue-share and space-productivity contract under IFRS 15 Agent clearing rules rather than a simple goods-received purchase order. Unlike basic vendor inventory consignment (/retail-and-ecommerce/vendor-consignment-shop-in-shop-settlement-reconciliation), where a retailer takes physical custody of a supplier's goods on its own shelves and generates a standard PO upon sale, a department store Shop-in-Shop (SIS) is a dedicated counter (300 sq. ft. Cosmetics / Luxury Watch / Designer Apparel Bay) operated by the brand's own beauty advisors or stylists using the host department store's central POS and payment terminals.

When a department store chain attempts to settle 180 brand concessionaires at month-end using manual Excel downloads from the POS, four recurring financial leaks and audit failures occur:

1. Missed Minimum Monthly Guarantee (MMG) Shortfall Top-Ups: Every prime floor bay carries a contractual Higher of (Revenue Share Commission % OR Minimum Monthly Guarantee per sq. ft.) clause—evaluated either monthly or with a quarterly true-up ratchet. If Brand Counter X occupies $400\text{ sq. ft.}$ at an MMG of ₹550/sq. ft. ($\text{MMG} = \text{INR } 220,000\text{/month}$) and a $20%$ revenue share, and achieves only ₹800,000 in net sales during a slow month (generating $20% \times \text{INR } 800,000 = \text{INR } 160,000$ in turnover commission), the host store must deduct an extra ₹60,000 MMG Top-Up from the brand's payout. Manual settlement sheets routinely deduct only the straight $20%$ POS commission, forfeiting millions in guaranteed floor yield.
2. Unrecovered Co-Funded Promotional Markdown & Loyalty Burn Splits: During a store-wide "Spend ₹10,000, Get ₹1,000 Instant Discount" festival campaign or loyalty-point redemption event, the commercial agreement stipulates that the ₹1,000 discount is borne 50% by the Host Department Store and 50% by the SIS Brand (or shifts the host commission rate from $24%$ Full-Price tier to $19%$ Markdown tier). If the POS logs only the net discounted tender without tagging the Promo_Cost_Share_Rule, the host store inadvertently absorbs 100% of the promotional discount out of its own commission margin.
3. Omitted Payment-Gateway MDR, Gift-Voucher, and Utility Chargebacks: Customers pay at central department-store registers using premium reward credit cards, BNPL/EMI (1.8% to 2.5% MDR), and store gift cards. Without automated tender-level fee allocation, the host store pays the bank $2.1%$ MDR on ₹100,000 of concessionaire sales while remitting ₹80,000 to the brand free of card-processing fees.
4. Principal vs Agent Gross Revenue Overstatement: Recording 100% of SIS concessionaire sales as top-line department-store Merchandise Revenue—when the store never held inventory risk or pricing authority—violates IFRS 15 Paragraphs B34–B38.

[POS Checkout at Brand SIS Bay: Scan Concessionaire Barcode Prefix -> Capture Gross Price, Promo Discount Code & Tender Type]
       |
       v
[IFRS 15 Agent Clearing Posting: Credit Gross Tender to 'Concessionaire Payable Clearing GL' (Not Store Top-Line Sales)]
       |
       v
[Line-Item Commission Engine: Apply Full-Price vs Markdown Commission Rate + Co-Funded Promo / Loyalty Split Ratio]
       |
       v
[Month-End Counter Settlement Run: Compare Cumulative Retained Commission vs Floor-Area Minimum Monthly Guarantee (MMG)]
       |
       +---> [Retained Commission < MMG?] ---> [Auto-Post MMG Shortfall Top-Up Debit Note (INR MMG - Commission)]
       |
       v
[Deduct Pro-Rata Card/EMI MDR, HVAC/CAM Utility Chargebacks, POS Consumables & Brand-Staff Penalties -> Remit Net Payout]

1. 1. Establish baseline scope & cut-off: Large-format department stores, luxury gallerias, and airport duty-paid halls generate 50% to 75% of their floor turnover through **Brand Concessionaires / Shop-in-Shops (`SIS`)**—where the brand owns the inventory and staffs the counter, while the host department store processes customer checkout through central POS lanes and remits a monthly net payout.
2. 2. Verify transaction & valuation rules: An enterprise **concession management software** module must enforce [IFRS 15 Principal-vs-Agent accounting (`Paragraphs B34–B38`)](https://www.ifrs.org/issued-standards/list-of-standards/ifrs-15-revenue-from-contracts-with-customers/): recording gross customer tender in a **Concessionaire Clearing Liability Ledger**, recognizing only the host store's retained **Commission / Revenue-Share Margin** as net revenue, and automating self-billed tax invoices.
3. 3. Quarantine exceptions before posting: Concession contracts combine complex commercial rules: **Tiered Turnover Commission Slabs**, **Full-Price vs Markdown Margin Splits** (e.g., 24% host commission on full-price sales vs 18% during End-of-Season Sale), **Minimum Monthly Guarantee (`MMG`) per square foot**, and **Co-Funded Bank Offer / Loyalty Point Cost Sharing**.
4. 4. Close with named owner sign-off: Automating the monthly **Gross-to-Net Concessionaire Settlement Statement** eliminates spreadsheet disputes over payment-gateway MDR deductions, POS paper/bag consumables, common-area utility back-charges, and short-stock shrinkage responsibility.

Gross-to-Net Concessionaire Settlement and MMG Ratchet Math

Under IFRS 15 Principal vs Agent rules and IFRS 16 variable turnover rent standards, for a concessionaire brand counter $b$ occupying floor area $A_b$ ($\text{sq. ft.}$) with guaranteed minimum floor yield $g_b$ ($\text{INR / sq. ft. / month}$), let $S_{b,i}$ be the gross MRP of item $i$, $D_{\text{brand},i}$ be brand-funded markdowns, and $D_{\text{joint},i}$ be store-wide promotional/loyalty discounts with brand cost-share fraction $\theta_b \in [0, 1]$.

The Commissionable Net Turnover ($T_{b,i}$) and Earned Variable Commission ($C_{\text{var},b}$) across full-price and markdown tiers $r_b(\delta_i)$ are:

$$T_{b,i} = S_{b,i} - D_{\text{brand},i} - \theta_b \cdot D_{\text{joint},i} \quad \text{and} \quad C_{\text{var},b} = \sum_{i=1}^{N_b} T_{b,i} \cdot r_b\left(\frac{D_{\text{brand},i} + D_{\text{joint},i}}{S_{b,i}}\right)$$

At month-end close, the Concession management software evaluates the Effective Host Store Fee ($F_{\text{host},b}$) and Net Remittance Payable ($\text{NP}_b$) to the brand:

$$F_{\text{host},b} = \max\left( C_{\text{var},b},; A_b \times g_b \right)$$

$$\text{NP}b = \sum{i=1}^{N_b} \left(S_{b,i} - D_{\text{brand},i} - D_{\text{joint},i} + \text{GST}{b,i}\right) - \left( F{\text{host},b} + \theta_b \sum_i D_{\text{joint},i} + \text{MDR}b + \text{CAM}b + \text{Tax}(F{\text{host},b}) \right) + \text{TDS}(F{\text{host},b})$$

Where:

• $\text{MDR}_b$ is the exact tender-weighted payment gateway / credit-card / EMI merchant discount rate incurred on counter $b$'s baskets (or contractual pass-through above a $1.0%$ base threshold).
• $\text{CAM}_b$ is the counter's sub-metered electricity, housekeeping, shopping-bag, and EAS hard-tag fee.
• $\text{Tax}(F_{\text{host},b})$ and $\text{TDS}(F_{\text{host},b})$ reflect GST on the host store's commission/space service invoice and statutory Tax Deducted at Source reconciliations.

Worked Example: 12-Store Department Store Chain Concession Cohort

Illustrative example (12-store department store chain hosting $180\text{ brand Shop-in-Shop (SIS) counters}$ generating $\text{INR } 420,000,000$ in monthly gross concessionaire GMV across apparel, cosmetics, footwear, and accessories):

1. Automated Capture of Minimum Monthly Guarantee (MMG) Shortfall Top-Ups: Across the $180\text{ SIS counters}$, $24\text{ seasonal or newly launched brand bays}$ generate variable turnover commissions below their contractual floor-area MMG during the month (average shortfall ₹61,667 per counter between earned commission and $A_b \times g_b$). Previously, manual billing clerks missed applying the MAX(Variable_Commission, MMG) ratchet on 24 counters or delayed billing until contentious year-end audits. Automating the monthly MMG top-up debit note in the ERP captures: $$\text{Captured Monthly MMG Top-Up Revenue} = 24\text{ counters} \times \text{INR } 61,667 = \text{INR } 1,480,000\text{ per month}$$

2. Enforcement of Co-Funded Store-Wide Promotion & Loyalty Cost Splits: During monthly store-wide festival campaigns, bank instant-discount weekends, and loyalty-point redemptions totaling $\text{INR } 3,150,000$ across SIS counters, commercial agreements specify a $30%$ brand co-funding split ($\theta_b = 0.30$). Tagging every POS promotional rule with its contractual Brand_CoFund_Pct recovers: $$\text{Recovered Brand Promo & Loyalty Co-Funding} = \text{INR } 3,150,000 \times 30% = \text{INR } 945,000\text{ per month}$$

3. Tender-Weighted Credit-Card / BNPL MDR & Common-Area Chargeback Recovery: By tracking the exact tender mix of every basket containing SIS items (allocating the $1.85%$ premium credit-card and BNPL MDR surcharge plus sub-metered counter display lighting and shopping-bag fees), the host store recovers $\text{INR } 630,000\text{ per month}$ in direct operating expenses that previously leaked into corporate overhead.

Control Framework: Principal/Agent GL Routing, Markdown Tiers, and Owners

To ensure audit-proof IFRS 15 compliance and zero vendor payout disputes, the ERP enforces four controls:

Bounded Pilot & Acceptance Tests for ERP Implementation

Before migrating all 180 brand concessionaires, execute a 1-month parallel settlement pilot across 15 SIS counters (spanning Full-Price, EOSS Markdown, and Under-MMG scenarios) and run these four acceptance tests:

• ACT-R117-01 (IFRS 15 Agent Clearing GL Separation): Process a ₹10,000 (+18% GST = ₹11,800) POS sale for an SIS_CONCESSION_AGENT luxury watch carrying a $20%$ host store commission. Verify the ERP posts ₹11,800 to Bank/Tender Clearing, ₹2,000 to Earned Concession Commission Revenue, ₹360 to Output GST on Commission, and the net payable balance to SIS Brand Clearing Liability—with zero inflation of Owned Merchandise Sales.
• ACT-R117-02 (Discount-Depth Commission Tier Shift): Configure SIS Brand B-12 with Full-Price Commission = 25% and EOSS Markdown (>20% off) Commission = 18%. Sell 1 unit at full price (₹5,000 $\rightarrow$ ₹1,250 commission) and 1 unit at 30% approved EOSS markdown (₹3,500 $\rightarrow$ ₹630 commission). Verify the settlement ledger computes exact line-level commissions totaling ₹1,880.
• ACT-R117-03 (Minimum Monthly Guarantee Shortfall Auto-Top-Up): Configure Counter C-09 with $300\text{ sq. ft.} \times \text{INR } 600/\text{sq. ft.} = \text{INR } 180,000\text{ MMG}$ and $20%$ turnover commission. Simulate monthly net turnover of ₹700,000 (earned variable commission $= \text{INR } 140,000$). Run the month-end settlement job. Verify the ERP generates a ₹140,000 variable commission line plus a mandatory ₹40,000 MMG Shortfall Top-Up Charge (total host fee $= \text{INR } 180,000$).
• ACT-R117-04 (Multi-Brand Basket MDR & Voucher Proration): Process a mixed basket containing ₹3,000 from Brand X and ₹7,000 from Brand Y paid with a ₹1,000 co-funded store voucher ($50%$ brand share) and ₹9,000 on a $2.0%$ MDR BNPL tender. Verify Brand X is charged $30%$ of the brand voucher share (₹150) and $30%$ of the MDR (₹54), while Brand Y is charged $70%$ (₹350 and ₹126).

Next Steps

1. Segregate SIS_CONCESSION_AGENT SKUs from owned and consignment stock in your chart of accounts: Route all SIS POS receipts through an IFRS 15 Agent Clearing Liability account so top-line retail revenue and gross margin are never distorted.
2. Digitize every brand contract's commission matrix, MMG floor, and promo co-funding split: Eliminate manual spreadsheet formulas by storing square-footage MMG rates, markdown commission tiers, and MDR pass-through rules directly in the ERP contract master.
3. Prorate basket-level vouchers, loyalty redemptions, and payment-gateway MDR at POS checkout: Compute each brand's exact share of tender fees and store-wide discounts at the moment the receipt prints.
4. Launch a self-billed Concessionaire Settlement Portal with line-item drill-down: Publish T+1 automated Gross-to-Net statements so brand finance teams can reconcile every receipt, return, MMG top-up, and CAM deduction without email disputes.

Frequently Asked Questions

How should department stores automate shop-in-shop (SIS) concessionaire sales capture, tiered margin commissions, shared-promotion cost splits, and monthly net-of-deduction payouts?

Teams should govern concession management software by linking every transaction to its source evidence, timestamp, and assigned owner before permitting downstream posting. Distinct from R015 (pure inventory consignment); R117 covers concessionaire-staffed shop-in-shops using host POS terminals, minimum-guarantee (MG) top-up calculations, and common-area/card-MDR chargebacks. Rather than relying on informal spreadsheet overrides, the workflow enforces a documented verification gate and preserves the original observation whenever a correction is recorded.

How does department store erp handle exceptions and mismatches?

When a discrepancy occurs during department store erp, the system routes the blocked record into an owned exception queue rather than silently dropping or auto-adjusting the balance. Assigned operational, quality, and finance owners must review and approve exceptions before posting. Each exception retains the original quantity, date, and counterparty reference until the designated reviewer resolves the variance with supporting evidence.

What should teams test before automating mall management revenue share?

Before scaling mall management revenue share, run a bounded pilot using historical records that include partial receipts, late updates, duplicate messages, and rejected lines. Verify that the integration preserves idempotency, maintains a clear segregation of duties between operational entry and financial approval, and produces an auditable trail for every state transition.