Most affiliate programs leak money quietly. Not through fraud—through math. A 3% commission formula applied to rounded transaction values, settlement delays that don't match invoice dates, processor holds that sit for days, currency conversion slippage—each one picks off 0.2% to 2% of payouts. Stack them together and you're sending affiliates 8–12% less than you owe them, every year, without knowing it. The leak is invisible because spreadsheets don't flag it, and by the time anyone audits the numbers, three months of discrepancies have compounded across 50+ partners. The fix isn't better intentions. It's nine specific audit checkpoints, each tied to a real cause, each quantifiable. Run this audit once every quarter, and you'll catch drift before it becomes a liability. Why 12% Leaks Don't Raise Alarms Until Year Two Affiliate payouts look correct in isolation. Your system calculates 3% of $10,000 as $300. You pay $300. Done. But here's what's hidden: Commission formula applied to rounded transaction values: You invoice $9,999.47. Your system rounds to $10,000 for commission math. The affiliate earns $300 instead of $299.98. Multiply by 50 partners and 200 monthly transactions—that's ₹40–60K annual overpayment, or underpayment if you round down. Settlement lag between invoice date and payout date: You invoice on the 15th. Commission is calculated on the 20th. Payout hits the 28th. If a customer refunds on the 22nd, does it reverse the already-calculated commission? Most systems say no. Now you're paying commissions on refunded sales. Payment processor holds and fees: Stripe holds 3–5% for disputes for 7 days. You wire the full payout but Stripe returns only 95% on day 9. Your accounting records the full wire, affiliate gets 95%. Where's the 5%? Multi-currency conversion slippage: You pay in INR, affiliate lives in Singapore. Your wire rate is 4% worse than the mid-market rate. After 12 months and 12 wires, the aggregate loss is 2–3% of total payouts. Tiered commission thresholds missed by rounding: An affiliate hits ₹99,999 in sales—just shy of the 4% tier that kicks at ₹100,000. System calculates at 3%. Should have been 4% on the overage. Repeat 10 times a month across your partner base. Most affiliate programs leak 8–12% yearly not through malice, but through invisible rounding, settlement timing, and processor behavior. A real-time audit dashboard catches it in weeks, not years. Checkpoint 1: Commission Formula vs. Actual Invoiced Amount Pull your last 30 days of invoices. For each one, calculate commission two ways: Commission on the exact invoiced amount (e.g., $9,999.47 × 3% = $299.98) Commission on the system-recorded amount in your affiliate dashboard (often rounded to $10,000 × 3% = $300) If these differ, you have a rounding leak. Multiply the per-transaction delta by your monthly transaction volume. If the average transaction is $500 and you invoice 200 times a month, a ₹1 rounding error per transaction is ₹200/month or ₹2,400/year—and that assumes you round consistently. Most systems don't. Fix: Commission formulas must always reference the precise invoiced line total, never a rounded intermediate. Set up automated reconciliation in your billing system to flag any discrepancy >₹5 between calculated commission and invoiced total. Checkpoint 2: Refund-to-Commission Reversal Lag A customer refunds $1,000 on day 22. The affiliate already earned 3% commission ($30) on day 20. Does your system automatically reverse the $30 on day 22, or does it sit in the affiliate's account until next payout, or until you manually catch it? Run this test: Manually refund a $1,000 transaction today. Check the affiliate's dashboard 24 hours later. Is the commission adjustment reflected? If not, you have a reversal lag. That lag means you're holding the affiliate's money indefinitely—or paying out commission on refunded sales. Real impact: If 2% of your monthly invoice volume becomes refunds (industry average is 1–3%), and refund reversals lag by 7 days, you're carrying 14 days of reversed commissions in your payables at any given time. At $100K/month invoice volume and 3% commission, that's $4,200 in float that should not exist. Fix: Set up a daily reconciliation job that matches refunds issued against commissions earned. If refund date is within 5 days of commission date, auto-reverse the commission same-day. Flag anything older than 5 days for manual review—it's a customer dispute or a system error. Checkpoint 3: Settlement Date vs. Invoice Date Mismatch Your invoice date is May 15. Your commission calculation date is May 20. Your payout date is May 28. Now: if a customer disputes the charge on May 25 and you issue a refund on May 27, does the affiliate get hit? Or does the payout already include that $500 transaction because the commission was locked on May 20? Most affiliate systems lock commission on calculation date, not settlement date. That creates a 3–10 day window where transactions can be refunded after commi