Most teams kill their affiliate programs by month six. Not because the idea fails—but because manual tier tracking, commission disputes, and payout reconciliation spiral into chaos around 30–50 partners. By month nine, one person is drowning in spreadsheets and emails asking 'where's my payout?' A single error—a decimal place, a missed tier milestone, a timing drift between your CRM, invoicing system, and bank statement—erodes partner trust in days. The fix is not to hire someone. It's to build a three-layer automation system: tier assignment (based on clear, data-driven rules), commission calculation (tied to actual revenue events), and payout reconciliation (automated, auditable, monthly). All three live inside your CRM and accounting software, with zero manual intervention once set up. This playbook walks a team under 10 people through building an affiliate program that scales to 100+ partners without adding headcount. Layer 1: Automatic tier assignment (no grading handoff) Most teams assign tiers manually: a spreadsheet, a monthly review meeting, an email saying 'you're promoted to Gold.' This delays promotions, invites disputes, and requires someone to remember who qualified when. Instead, tier assignment should be rules-based and live in your CRM . Define tiers by a single metric: total referral revenue YTD, or total referral count, or both. The rule is locked in. When an affiliate crosses the threshold (say, ₹5 lakh in referral revenue), their tier updates instantly. No meeting, no email, no manual touch. How to build it Define tier thresholds with precision. Example: Bronze (₹0–₹2L), Silver (₹2L–₹5L), Gold (₹5L–₹15L), Platinum (₹15L+). Use revenue, not gut feel. Create a custom field in your CRM: 'Affiliate Tier'. Make it automated, not free-text. Use a formula or automation rule that reads the affiliate's lifetime referral revenue and assigns the tier automatically. Log all tier changes. Your CRM audit trail should show when the affiliate crossed each threshold and when the tier updated. This prevents disputes ('I should have been Gold months ago'). Trigger tier-specific commission rates automatically. The moment an affiliate's tier updates, their commission percentage changes in your system. No lag, no separate instruction email. The single biggest mistake: tying tier to 'effort' or 'potential' instead of actual revenue. Stick to one number. If an affiliate sees the rule, they know when they're getting promoted—and they know it's fair. Layer 2: Commission calculation tied to revenue events Commissions fail when they're calculated on invoices, not on actual customer payment or contract signature. An invoice generated in January might not pay until March. By then, your affiliate is asking if their commission is coming, and you're hunting through three systems to answer. Instead, tie commission calculation to the revenue event that matters to your business. For most teams, that's one of three moments: (1) invoice generated, (2) payment received, or (3) contract signed. Pick one. Lock it in. Automate it. The event-driven commission model Choose your revenue trigger. Invoice date is easiest for SaaS and services (most predictable). Payment date is safest (eliminates chargeback risk). Contract signature is earliest (but riskiest). Pick one, document it in your affiliate agreement, and stick with it. Embed commission calculation in your invoicing system. Every time an invoice is created (or marked paid, or a contract is signed), your invoicing tool should automatically calculate and log the commission. Example: new deal tagged 'Affiliate: Sarah' → invoice for ₹1L → system calculates 10% commission (₹10K) → logs it in a 'Commission Due' ledger. Handle multi-touch attribution with a rule. If two affiliates brought the same customer, how do you split the commission? Document the rule (first touch 70%, last touch 30%, or 50/50, or full credit to one). Build it into your automation—don't decide case-by-case. Track commission status at every stage. Your CRM should show: 'Calculated (awaiting payment)', 'Payable (payment received)', 'Paid (via transfer on [date])'. This status is visible to the affiliate via a partner portal or dashboard (or embeddable widget on your site), reducing 'where's my commission?' emails by 80%. Layer 3: Payout scheduling and reconciliation The easiest place for drift is between your commission ledger and actual bank payouts. An affiliate was owed ₹50K in November, but only received ₹45K in December. Was it a rounding error? A clawback for a failed renewal? A late-paid invoice not yet counted? By the time you investigate, the relationship is damaged. Payout automation eliminates this gap. Set a rule: every affiliate with a commission balance ≥ ₹5K gets paid automatically on the 15th of each month. The payout is generated from your ledger, transferred, and logged immediately. Reconciliation is instant because there's no manual step. Building payout automation Set a minimum payout thres