Measure a promotion after returns and supplier funding

A multistore and D2C athletic footwear retailer runs a 10-day '20% Off Performance Running' campaign (PROMO-RUN-20) on its flagship trainer (SKU-RUN-500, regular net selling price ₹2,500.00, promotional net selling price ₹2,000.00, landed unit cost ₹1,150.00). On the morning after the campaign closes, the merchandising dashboard declares a triumph: 250 pairs sold for ₹5,00,000 in gross promotional sales, compared with 120 pairs (₹3,00,000) during the prior 10-day non-promotional baseline. Three weeks later, however, commercial finance reconciles the cohort: 30 of the 250 promotional pairs were returned by size-shopping online buyers for ₹60,000 in refunds (incurring ₹7,500 in non-recoverable two-way courier and grading costs), paid-social campaign spend consumed ₹35,000, and ₹11,000 of the ₹44,000 supplier co-op funding assumed by the buyer was rejected by the vendor because the buyer discounted bundles excluded from the vendor's funding letter.

The operational decision for a commercial finance analyst and category buyer is how to construct a post-return, post-funding contribution bridge—linking retail discount execution, open-to-buy margin planning, and accounts-payable vendor funding settlement so promotional decisions are governed by realised contribution rather than gross sales volume (Microsoft Learn — Retail discounts and price adjustments overview in Dynamics 365 Commerce, Shopify Retail Blog — Open-to-buy (OTB) planning and inventory budgeting guide). By linking this control to SKU contribution after returns and supplier rebate and funding tracking, commercial finance analyst teams prevent downstream inventory, customer-promise, and financial breaks before stock or cash moves.

Bridging from gross promotional sales to net incremental contribution

Promotional reporting frequently fails because merchandising teams measure success on Day 11 using gross checkout value, whereas the true economics of a promotion only settle 14 to 30 days later after customer returns, variable fulfilment fees, and supplier funding claims are resolved. Furthermore, comparing a promotional period to a prior baseline without subtracting variable costs confuses volume acceleration (and pull-forward demand) with net contribution creation.

To evaluate any retail promotion on a consistent commercial basis, build a six-step contribution waterfall for the promotional cohort (Order Cohort = Orders placed during Promo Window, tracked through Return Window close):

Net Retained Promotional Revenue (₹) = Gross Discounted Sales − Cohort Customer Refunds

Net Kept Units = Gross Promotional Units Sold − Cohort Returned Units

Unfunded Promotional Contribution (₹) = Net Retained Promotional Revenue − (Net Kept Units × Landed Unit Cost) − (Net Kept Units × Outbound Fulfilment & Payment Fee) − (Cohort Returned Units × Return Processing Cost) − Attributable Promo Ad Spend

Confirmed Post-Funding Contribution (₹) = Unfunded Promotional Contribution + Confirmed Supplier Funding (Backed by Signed Agreement & AP Credit Note)

Baseline Comparison Variance (₹) = Confirmed Post-Funding Contribution − Stated Baseline Period Contribution

Keeping Estimated/Disputed Supplier Funding (₹11,000) on a separate memo line outside Confirmed Post-Funding Contribution (₹1,44,500) prevents buyers from launching margin-dilutive promotions on the strength of unverified vendor co-op promises.

  <path d="M219 85 L248 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r020)"/>

  <rect x="248" y="40" width="195" height="90" rx="8" fill="#fef9c3" stroke="#ca8a04" stroke-width="1.5"/>
  <text x="262" y="64" font-weight="700" fill="#854d0e">2. Direct Promo Costs</text>
  <text x="262" y="84">COGS (220 u): -₹2,53,000</text>
  <text x="262" y="102">Ops & Returns: -₹40,500</text>
  <text x="262" y="118" font-size="11" fill="#475569">Promo Ads: -₹35,000</text>

  <path d="M443 85 L472 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r020)"/>

  <rect x="472" y="40" width="195" height="90" rx="8" fill="#ffedd5" stroke="#ea580c" stroke-width="1.5"/>
  <text x="486" y="64" font-weight="700" fill="#9a3412">3. Unfunded vs Baseline</text>
  <text x="486" y="84">Unfunded: ₹1,11,500</text>
  <text x="486" y="102">10-Day Baseline: ₹1,42,000</text>
  <text x="486" y="118" font-size="11" fill="#475569">Unfunded gap: -₹30,500</text>

  <path d="M667 85 L696 85" stroke="#475569" stroke-width="1.8" marker-end="url(#arrow-r020)"/>

  <rect x="696" y="40" width="200" height="90" rx="8" fill="#dcfce7" stroke="#16a34a" stroke-width="1.5"/>
  <text x="710" y="64" font-weight="700" fill="#166534">4. Vendor Funding Split</text>
  <text x="710" y="84">Confirmed CN: +₹33,000</text>
  <text x="710" y="102">Final Contrib: ₹1,44,500</text>
  <text x="710" y="118" font-size="11" fill="#475569">Disputed ₹11,000 excluded</text>

  <rect x="24" y="166" width="872" height="164" rx="8" fill="#ffffff" stroke="#cbd5e1" stroke-width="1.2"/>
  <text x="44" y="194" font-weight="700" font-size="13" fill="#0f172a">Governance rule: Evaluate promotions on net post-return cohort contribution and confirmed AP vendor funding</text>
  <text x="44" y="220" fill="#334155">• Gate A: Cohort return gate holds final promotion sign-off for 21 days so the 30 returned pairs (-₹60,000 revenue, -₹7,500 return ops) are deducted.</text>
  <text x="44" y="246" fill="#334155">• Gate B: Baseline bridge compares unfunded contribution (₹1,11,500) against the stated 10-day baseline (₹1,42,000), exposing a -₹30,500 unfunded deficit.</text>
  <text x="44" y="272" fill="#334155">• Gate C: Vendor funding gate includes only the ₹33,000 AP-matched credit note (220 u × ₹150) and quarantines the ₹11,000 disputed claim.</text>
  <text x="44" y="302" font-weight="600" fill="#0369a1">Outcome: Post-funding contribution is verified at ₹1,44,500 (+₹2,500 vs baseline); future campaigns require pre-signed vendor funding letters.</text>
</g>
<defs>
  <marker id="arrow-r020" viewBox="0 0 10 10" refX="8" refY="5" markerWidth="6" markerHeight="6" orient="auto-start-reverse">
    <path d="M 0 0 L 10 5 L 0 10 z" fill="#475569"/>
  </marker>
</defs>

Worked illustrative example: reconciling a ₹5,00,000 running-shoe campaign after ₹60,000 in returns and supplier funding

Illustrative example (hypothetical scenario): Reconcile the 10-day '20% Off Performance Running' promotion (PROMO-RUN-20) on SKU-RUN-500 (regular net price ₹2,500.00, promo net price ₹2,000.00, landed unit cost ₹1,150.00, outbound fulfilment & payment fee ₹150.00/kept unit, reverse-logistics & grading cost ₹250.00/returned unit, campaign ad spend ₹35,000) against the stated 10-day pre-campaign baseline.

Step 1: Establish the baseline operational and commercial parameters

• Stated 10-Day Pre-Campaign Baseline (128 gross units sold, 8 returned = 120 net kept units at ₹2,500.00):
  • Baseline Net Retained Revenue: 120 units × ₹2,500.00 = ₹3,00,000
  • Baseline Landed COGS: 120 units × ₹1,150.00 = ₹1,38,000
  • Baseline Outbound Fulfilment & Payment Fees: 120 units × ₹150.00 = ₹18,000
  • Baseline Return Processing Cost (8 returns): 8 units × ₹250.00 = ₹2,000
  • Stated Baseline Net Contribution: ₹3,00,000 − ₹1,38,000 − ₹18,000 − ₹2,000 = ₹1,42,000 (₹1,183.33 contribution per kept unit)
• Promotional Campaign Cohort (PROMO-RUN-20, tracked through Day-21 Return Cutoff):
  • Gross Promotional Sales (250 units @ ₹2,000.00): 250 × ₹2,000.00 = ₹5,00,000
  • Less Cohort Customer Refunds (30 returned units @ ₹2,000.00, a 12.0% return rate vs 6.25% baseline): 30 × ₹2,000.00 = ₹60,000
  • Net Kept Promotional Units: 250 − 30 = 220 units
  • Net Retained Promotional Revenue: ₹5,00,000 − ₹60,000 = ₹4,40,000

Step 2: Reconcile states, exceptions, and financial impact

1. Compute Unfunded Promotional Contribution and Compare with Baseline:
   • Landed COGS on 220 net kept units: 220 × ₹1,150.00 = ₹2,53,000
   • Outbound Fulfilment & Payment Fees on 220 net kept units: 220 × ₹150.00 = ₹33,000
   • Return Shipping & Grading Cost on 30 returned units: 30 × ₹250.00 = ₹7,500
   • Direct Campaign Paid-Media Spend: ₹35,000
   • Unfunded Promotional Contribution: ₹4,40,000 − ₹2,53,000 − ₹33,000 − ₹7,500 − ₹35,000 = ₹1,11,500
   • Unfunded Variance vs Stated Baseline: ₹1,11,500 − ₹1,42,000 = -₹30,500 (without vendor support, the promotion destroyed ₹30,500 of contribution despite lifting top-line sales to ₹5,00,000!).
2. Incorporate Supplier Promotional Funding (Separating Confirmed vs Disputed Support):
   • The category buyer expected ₹200.00/unit in vendor support across 220 kept units (220 × ₹200.00 = ₹44,000), but the signed supplier funding agreement only covered ₹150.00/kept unit on standalone footwear sales (220 × ₹150.00 = ₹33,000 confirmed on Vendor Credit Note CN-PROMO-09), leaving ₹11,000 (₹44,000 − ₹33,000 = ₹11,000) disputed and unaccepted:
     • Confirmed Post-Funding Contribution: ₹1,11,500 + ₹33,000 = ₹1,44,500
     • Confirmed Variance vs Stated Baseline: ₹1,44,500 − ₹1,42,000 = +₹2,500 (a slim +1.76% contribution gain that further assumes zero post-promo demand pull-forward dips in Week 3 and Week 4).

Verified scenario calculation summary

• 120 units × ₹2,500.00 = ₹3,00,000
• 120 units × ₹1,150.00 = ₹1,38,000
• 120 units × ₹150.00 = ₹18,000
• 8 units × ₹250.00 = ₹2,000
• ₹3,00,000 − ₹1,38,000 − ₹18,000 − ₹2,000 = ₹1,42,000
• 250 × ₹2,000.00 = ₹5,00,000
• 30 × ₹2,000.00 = ₹60,000
• 250 − 30 = 220 units
• ₹5,00,000 − ₹60,000 = ₹4,40,000
• 220 × ₹1,150.00 = ₹2,53,000
• 220 × ₹150.00 = ₹33,000
• 30 × ₹250.00 = ₹7,500
• ₹4,40,000 − ₹2,53,000 − ₹33,000 − ₹7,500 − ₹35,000 = ₹1,11,500
• ₹1,11,500 − ₹1,42,000 = -₹30,500
• ₹44,000 − ₹33,000 = ₹11,000
• ₹1,11,500 + ₹33,000 = ₹1,44,500
• ₹1,44,500 − ₹1,42,000 = +₹2,500

Bridging from ₹5,00,000 gross sales down to ₹1,11,500 unfunded contribution (a -₹30,500 loss against the ₹1,42,000 baseline) and separating ₹33,000 in confirmed vendor funding from ₹11,000 in disputed claims gives leadership an honest ₹1,44,500 (+₹2,500) post-mortem—showing that the 20% discount is unviable without pre-contracted supplier support.

Promotion contribution workflow and baseline governance

To institutionalise post-return, post-funding promotional evaluation across your buying and finance teams, implement four operational controls:

1. Tag every promotional order line with a unique campaign_id and lock the baseline definition before launch (Owner: Commercial Finance Analyst). When configuring a campaign in retail discount management, record the comparison baseline window (e.g., prior 10 non-promotional days or matched control store group) and target contribution floor before the promotion goes live.
2. Link customer refunds and return-processing costs back to the originating campaign_id cohort (Owner: Inventory & Returns Analytics). Use your SKU contribution after returns framework so returns arriving on Day 18 of an order placed during the 10-day promo window deduct from PROMO-RUN-20 net revenue and add ₹250/return in handling cost to the campaign ledger.
3. Split supplier funding into Estimated/Pending and Confirmed/Settled buckets (Owner: Category Buyer + AP Controller). Connect promotional funding claims to your supplier rebate and funding tracker and AP invoice/credit matching. Only funding backed by a signed vendor deal sheet and an accepted credit note enters realised campaign contribution.
4. Measure post-promotion demand dip (pull-forward) before approving repeat campaigns (Owner: Merchandising Planner). Check unit sales during the 10 days immediately following the promotion. If post-promo volume drops below the pre-promo baseline (120 units), the campaign merely pulled forward full-price buyers into a discounted window, eroding open-to-buy margin.

Choosing between observational baseline bridges and controlled experiments: For routine category promotions, a transparent accounting bridge against a stated pre-promo baseline (with explicit caveats that seasonality or weather can shift the baseline) is sufficient to catch margin-negative campaigns. When evaluating permanent promotional mechanics across 50+ stores or large CRM segments, pair the accounting bridge with a holdout control group.

Operational governance and audit controls for sustained compliance

To prevent this workflow from eroding after the initial implementation sprint, embed four recurring governance checkpoints into your weekly retail operations cadence:

1. Version-locked rule and threshold tables: Store every tolerance band, status-transition rule, and exception-routing map in a versioned configuration table rather than ad-hoc personal spreadsheets. Any threshold change requires sign-off from commercial finance analyst and commercial finance, recording the effective timestamp and the cohort of SKUs or locations affected.
2. Automated daily orphan and stale-state sweep: Run a scheduled morning query that flags records stuck in an intermediate state (Pending Verification, In Transit, Awaiting Confirmation, or Held for Review) beyond their agreed service-level cutoff. Route aged exceptions directly to the named role owner before customer promises or period-close cutoffs are breached.
3. Separation of operational execution from financial write-off authority: Staff who execute physical picks, catalogue edits, or customer service actions should never have unilateral system permission to clear reconciliation variances or post financial write-offs. Require dual sign-off once cumulative weekly adjustments on a SKU, store, or vendor exceed your materiality floor.
4. Monthly root-cause retrospective tied to source-system hygiene: Aggregate exception logs by upstream root cause—such as missing supplier identifiers, delayed webhook deliveries, or uncalibrated store stock counts—and require the responsible upstream team to remediate the top three recurring defects before the next monthly cycle.

Observable acceptance tests for your retail systems

Before relying on this workflow in production, execute three deterministic acceptance tests (ACT-R020-01 to ACT-R020-03) in your staging environment or controlled worksheet:

Auditing your last major promotional campaign

To replace vanity top-line promo recaps with contribution-grounded evaluation:

1. Pull one completed promotion from 30 days ago and reconstruct its cohort bridge from gross checkout sales down to net retained revenue after late customer returns.
2. Deduct all directly attributable variable costs (landed COGS on kept units, outbound pick/pack/shipping fees, two-way return handling costs on returned units, and campaign ad spend) before comparing against your pre-promo baseline.
3. Separate confirmed supplier credit notes from unaccepted funding claims so buyers cannot justify deep discounts using uncollected vendor support.
4. Run acceptance tests ACT-R020-01 to ACT-R020-03 on your promotional reporting template before locking your next seasonal open-to-buy budget.