At $50K monthly in affiliate payouts, a spreadsheet feels fine. At $100K, it silently lies to you. By $200K, the gaps are large enough that your accountant flags them in audit. We've mapped nine specific ways reconciliation breaks as payouts scale, and built a diagnostic checklist that catches each one before your books drift. Nine Reconciliation Failures That Hide Above $100K These aren't hypothetical. They're the exact failures we see when teams rely on manual tracking, email confirmations, and spreadsheet formulas across multiple payment rails and currencies. 1. Rounding errors compound across batches You calculate commissions to two decimals. Stripe rounds to the nearest cent. Your accounting system rounds differently. At $50K it's noise ($5–10 per month). At $200K, it's $40–80 per reconciliation cycle. Over 12 months, that's $500–1000 of unexplained variance that your accountant will ask about. The trap: Each individual rounding is defensible. Together, they create systematic drift. 2. Chargeback deductions don't reverse the commission A customer pays via card, you pay the affiliate. Three weeks later, the payment is charged back. Your payment processor deducts the amount from your next settlement. But you never reversed the commission in your books. Now your affiliate ledger shows payout A paid, but your bank shows less cash out. At scale with hundreds of affiliates, you may not notice until reconciliation. And by then, you're matching five weeks of transactions across three systems. 3. Currency conversion gaps between source and payout rails Your affiliate in Singapore earned commissions in USD (your default). You pay them in SGD. The rate you quote them differs from the rate your payment processor uses. The difference is 0.5–1.2%. Across $100K monthly, that's $500–1200 per month unaccounted for. If you're paying via Wise, Stripe Connect, and bank transfer simultaneously (for different tiers), you now have three different conversion rates in play. 4. Payment rail delays split settlement and commission You issue a payout instruction on Tuesday. Wise settles on Thursday. Stripe settles Friday. Bank wire settles Monday. Your affiliate sees money Thursday but your bank feed doesn't update until Friday. When you reconcile Monday, the payout shows as pending in one system and settled in another. If you're not careful, you reconcile "paid" twice. 5. Partial payouts aren't tracked as two records An affiliate has $3,000 due. Their bank details are wrong, so the transfer fails. You retry and pay $1,500. They confirm receipt. You then pay the remaining $1,500 a week later. Your spreadsheet shows one row for $3,000, marked "paid." Your bank shows two payments. When you reconcile, the single line matches neither settlement date, and the total reconciles by accident rather than by proof. 6. Refund attribution to the wrong commission period A customer buys on January 15th. The affiliate earns $500 commission. Customer refunds February 3rd. Do you reverse the commission from January or February? If your system auto-dates the reversal to the refund date but your affiliate was paid in January, you've created a mismatch. The affiliate won't know why their January statement shows a reversal that arrived in February. 7. Tiered or holdback commissions aren't itemized in the payout An affiliate qualifies for a 5% base plus a 2% bonus if they hit $10K monthly volume. They hit $12K. You owe them $720 base plus $240 bonus. Your payout instruction shows $960 total. When the affiliate checks their records, they see $960 but no breakdown. If they later dispute the amount, you can't prove the tiering without digging into your spreadsheet. At $100K+ monthly across dozens of affiliates with different commission structures, this becomes impossible to audit quickly. 8. Platform fees are deducted from settlement, not itemized Wise charges 0.5% to convert and send. Stripe Connect charges 1%. Your payout instruction was $1,000. Settlement was $990. You booked $1,000 in affiliate expense but the bank moved $990. Now your GL doesn't match the bank feed, and you're forced to create a reconciliation journal entry instead of a clean match. 9. Duplicate payouts hide in batched instructions You generate a payout batch on Monday. Before it settles, you notice an affiliate is missing and regenerate the batch including them. The original batch already included them. Now they're paid twice. If batches aren't explicitly reconciled against settlement confirmations, the duplicate can hide for weeks. When Spreadsheets Fail: The $100K Inflection Point A spreadsheet with formulas can handle 20–30 affiliates cleanly. At 50 affiliates with variable commission structures, currency pairs, and payment rails, you need: Separate sheets for commissions earned, commissions paid, and payment settlements VLOOKUP or INDEX/MATCH to cross-reference exchange rates on payout date Manual entry of bank feeds and payment processor settlement reports A reconciliation tab t