Your affiliate program is leaking 8–12% of payouts every month, and the leak hides in plain sight: the spreadsheet. Not all of it. Most spreadsheet-based tracking works fine for small programs—10 to 50 affiliates, mostly repeat performers, same currency. But the moment you hit 50+ affiliates, add multi-currency settlement, or run a marketplace where sellers and affiliates overlap, the gaps multiply. Rounding errors compound. Currency conversions shift basis. Refunds reverse commissions but not always the payout. One seller's late batch holds three others' payments. By month three, you've leaked ₹35,000–₹50,000 without knowing which reconciliation gate failed. The Nine Leaks That Hide in Affiliate Spreadsheets Most affiliate program managers audit monthly: revenue in, commission rate applied, payout cut. The three-line logic is sound. The execution hides nine gaps where money disappears. 1. Rounding errors at scale A 5% commission on ₹1,234 is ₹61.70. Excel rounds it to ₹62. Multiply that by 80 transactions a month, and you've over-paid ₹8–₹12 without tracking where. Reverse it to under-pay, and affiliates churn. The real cost: neither your spreadsheet nor your payout system knows which direction rounding went. When you reconcile end-of-month, you're comparing rounded payouts against unrounded revenue—a gap that grows each month. 2. Currency conversion basis drift You have 15 affiliates in INR, 8 in USD, 6 in SGD. Revenue comes in INR, payout in local currency. Your spreadsheet uses today's exchange rate to convert both revenue and commission. Next month's rate shifts 2–3%. Your historical record now shows a different commission %, and you can't reconcile which rate applied when. Worse: if you paid in USD but recorded conversion in INR at a later rate, the mismatch is invisible until audit. 3. Refunds reverse commissions—but not always payouts Customer refunds a ₹5,000 purchase. The commission spreadsheet deducts ₹250. But if that refund landed after your payout batch closed, you've paid out a commission on revenue that no longer exists. Your next-month commission appears inflated. When you look for the refund reversal, it's buried three rows down with a note "catch next month." Three months later, it's still pending. 4. Double-counted refunds for split-commission deals One sale involves two affiliates: a referrer (who brought the lead) and a closer (who sealed the deal). You split the 5% commission: 3% to the referrer, 2% to the closer. Customer refunds the order. Your spreadsheet deducts the full 5% from the referrer's ledger but forgets to deduct the 2% from the closer's. Now the closer's lifetime commission is 2% inflated, and when you reconcile, you can't find where it came from. 5. Missing refunds from delayed settlement windows Your payment processor settles 48 hours after the order. Refunds settle 5–7 days later. Your affiliate spreadsheet records commission on day 2 (settlement) but refunds come in on day 8. If you run your affiliate reconciliation on day 3, the refund hasn't hit yet. When it arrives on day 8, you're reconciling day 3–9 data, and the refund now looks like a separate transaction—one you have to manually match to the original sale. 6. Late seller batches hold affiliate payouts hostage You run a marketplace. Affiliate A referred a seller. That seller's payout batch was delayed (compliance, missing docs, account verification). Your system holds Affiliate A's commission until the seller batch clears. But your payout schedule says Affiliate A gets paid on the 15th. You manually override it, pay them early, then forget to deduct the held commission later. When the seller batch finally clears on the 20th, the commission is already gone. 7. Bonus and accelerator tiers misaligned with payout dates An affiliate hits ₹50,000 in commissions this month, qualifying for a ₹2,500 bonus. You record it in the spreadsheet. But the bonus doesn't hit your payout system until two weeks later, after your accounting close. You reconcile, see the ₹2,500 pending, move on. Next month, the bonus appears twice because the payout system synced it retroactively. 8. Tax withholding inconsistency Your affiliate contract says: 15% withholding for non-compliant tax IDs. But your spreadsheet doesn't auto-check ID compliance; it's a manual flag. Affiliate B got flagged for withholding, so you deducted ₹1,500. Two months later, they provide a valid ID, but your spreadsheet still shows the withholding in force. You manually refund them ₹1,500, but you don't track whether you over-withheld in prior months. 9. Timing gaps between revenue recognition and commission payment Your accounting system recognizes revenue on invoice date. Your affiliate system recognizes it on settlement date (2–3 days later). An invoice dated the 28th settles on the 1st. Your revenue spreadsheet shows it in month one; your payout spreadsheet shows it in month two. When you reconcile, the commission appears to be a month late, and you can't tell if