You process 200 affiliate payouts a month across three currencies and two payment processors. Your spreadsheet shows ₹4.2 lakhs paid out. Your accountant reconciles ₹3.85 lakhs. The difference vanishes into rounding, processor settlement windows, chargebacks you never saw, and multi-currency conversions that don't match your bank statement. By month's end, ₹35,000 is unaccounted for—not fraud, not embezzlement, just the cost of manual payout tracking at scale. This drift compounds. Over a year, ₹4.2 lakhs becomes ₹3.6 lakhs in your ledger. Your affiliates see payouts they never expected to miss. Your finance team runs reconciliation queries that take six hours and still disagree with the processor. Your tax audit leaves the gap unexplained. The root isn't carelessness—it's that affiliate payouts touch too many systems in too many ways. A single order flows through your e-commerce platform, your CRM commission rules , your payment processor, your accounting software, and your affiliate's bank account. Each handoff introduces a small error. Ten handoffs, ten small errors, one big monthly mystery. Here's where the leaks hide, how to find them in ten minutes, and how to stop them for good. Where ₹35K disappears every month 1. Rounding arithmetic that compounds A ₹10,000 order with a 12% commission = ₹1,200 exactly. But split that across three affiliates (40%, 35%, 25%) and you get ₹480, ₹420, ₹300—total ₹1,200, clean. Now scale to 200 orders a month with variable split percentages. Rounding rules (round down, round to nearest, round up) differ between your spreadsheet, your CRM, your processor, and your accounting software. A 0.01 paise error per transaction looks invisible. At 6,000 affiliate transactions yearly, those rounding errors total ₹600–₹1,200 monthly. Worse: if your spreadsheet rounds down and your processor rounds to nearest, the affiliate sees a payment that doesn't match your calculation. You both think the other made a mistake. 2. Settlement delays and timing mismatches You calculate affiliate commissions on order date. Your payment processor settles in your bank account 3–5 days later. Your accounting software records the payout on the day you submit it. Your affiliate portal shows funds pending. Now your cash flow, your commission ledger, and your bank statement disagree on timing. If an affiliate requests early payment, you hand-cut a check or transfer. That's recorded as paid in your spreadsheet but hasn't left your account yet. One day later, the processor settlement arrives and you double-count the payout. Your cash reconciliation breaks. Across 200 payouts monthly, timing drift alone can create ₹8K–₹15K in temporary (but real) ledger gaps. 3. Multi-currency conversion slippage You work in INR. Your affiliates span Singapore (SGD), Malaysia (MYR), Thailand (THB), and Indonesia (IDR). Your payment processor (Stripe, Razorpay, Wise, Instamojo) applies its own FX rate. Your accounting software applies another. Your spreadsheet uses yesterday's rate because you copied it by hand. At a 2–3% FX spread per conversion, and 30% of payouts in foreign currency, you lose ₹5K–₹8K monthly to conversion drift alone. The audit nightmare: your bank statement shows ₹1,47,320 paid to affiliates in foreign currency. Your accounting ledger shows ₹1,48,050 because you used the opening rate, not the settlement rate. Off by ₹730. Your affiliate in Singapore received SGD 2,850 (worth ₹1,46,900 at their bank's rate) but you recorded ₹1,48,050. They think you shorted them. You think you paid in full. Both are right from your own system's perspective. 4. Chargebacks and refunds you never reconcile An affiliate's customer disputes the charge. The processor refunds ₹3,500. The commission on that order was ₹420. You have three choices: (a) reverse the commission and alert the affiliate, (b) leave the commission in place and eat ₹420, or (c) do nothing and let it live in your books as a floating item. Most spreadsheet-driven operations do (c). Over a month, ₹8–₹12K in unreimbursed chargebacks pile up. They're not lost—they're in accounting limbo, waiting for someone to notice them in a reconciliation that takes six hours. The 10-minute audit: Find your drift Stop guessing. Run this audit against your current spreadsheet or CRM: Pull your last 30 days of orders and calculate total commissions by hand. Use your stated commission rules (fixed %, split %, tiered %). Write down the exact total. If your spreadsheet does it automatically, recalculate in a separate tab to verify. Time: 2 minutes if you have 200 orders; more if you hand-calculate. Compare to your payment processor's settlement ledger. Log into Stripe, Razorpay, or Wise and export the last 30 days of payouts. Total them by currency and convert to INR using that processor's applied rate (not today's rate—the rate at settlement). Time: 2 minutes. Pull your accounting software's affiliate expense ledger. If you use Xero, Wave, Zoho, or Orin, export the last 30 days of