You're running a regional agency across three countries. Partners bring you deals. You owe them commission—but it's not simple: tier shifts when they hit $50k in referrals per quarter, different partners take different cuts, and you need one source of truth by Friday for accounting. Your spreadsheet was born in desperation and now it's your prison. Every time a partner emails asking about their balance, you rebuild three columns and send a screenshot. The real problem isn't the spreadsheet itself—it's that your CRM doesn't know about it. A deal closes in your pipeline. Commission calculates in your sheet. Your accountant syncs invoicing data from a third system. No single tool tracks revenue, splits, and payouts together. So you're in limbo: good enough to avoid immediate chaos, bad enough that you're losing an hour per week to reconciliation. Most CRM platforms—including the big names—require custom development to handle revenue splits and tiered payout structures natively. But you don't need custom code. You need a tool that lets you define commission rules once, attach them to deals as they close, and watch payouts calculate automatically. Here's how to evaluate that fit and move off the sheet without losing control. The three-layer problem most CRMs miss Affiliate commission tracking breaks into three distinct problems: Revenue attribution: Which partner gets credit for this deal? (Often split across multiple partners, not 50/50.) Commission calculation: What percentage or flat fee do they earn? (And does it change based on quarterly volume, geography, or partner tier?) Payout reconciliation: How much do we owe them across all deals, and when did we actually pay it? A basic CRM handles the first—tagging a deal with a partner—but stops there. The second and third require either a spreadsheet outside the CRM, or a system that lets you define rules, attach them to revenue, and track state changes (calculated → invoiced → paid). Spreadsheets fail because they're static: a partner moves from tier 1 to tier 2, and you have to manually update ten cells retroactively. They also fail because they don't talk to your actual pipeline or accounting system. A deal closes in your CRM, but the commission lives elsewhere. Your accountant doesn't see it. Your finance tool doesn't record it. By the time you reconcile, three weeks have passed. Orin: native revenue splits and partner tiers Orin's CRM module includes a revenue-split feature designed for exactly this scenario. Here's what it actually does: Multi-party deal splits: Assign percentages or fixed amounts to multiple contacts or partner records on a single deal. A deal worth $100k can be split 60% to your company, 30% to partner A, 10% to partner B. Automated calculations: Once the deal closes (or moves to 'won'), Orin calculates each party's share. It doesn't wait for you to update a formula. Commission tiers: Define rules that change payouts based on volume triggers. If a partner hits $200k in closed deals this quarter, their commission lifts from 15% to 20%. Orin recalculates retroactively. Payout tracking: Mark each commission as calculated, invoiced (if you're paying them via invoice), or paid. This feeds directly into your accounting sync. The setup is one-time: define your partner tiers, assign commission percentages by tier or geography, then attach the rule to your deal pipeline. When a deal moves to 'won', Orin calculates payouts in seconds. Your accountant can see commission liability by partner by quarter. Real example: A Jakarta-based agency with 8 referral partners across Indonesia, Thailand, and Vietnam set up three tiers in Orin. Tier 1 partners (under $50k YTD) earn 12% per deal. Tier 2 (over $50k) earn 15%. Tier 3 (over $150k) earn 18% plus a $500 bonus per deal. Each deal in the pipeline is tagged with the referring partner. When the deal moves to 'won', Orin calculates commission based on that quarter's cumulative closed deals—so a partner's tier can shift mid-quarter, and all prior deals in that tier recalculate. No spreadsheet. No manual checks. By the 5th of each month, they export a CSV of commissions due, reconcile against bank transfers, and mark them paid in Orin. Zoho CRM: the connector approach If you're already deep in Zoho's ecosystem, commission tracking is possible—but it requires more manual plumbing. Zoho CRM itself doesn't have a revenue-split feature. However, Zoho Books (their accounting tool) has a partner/affiliate module. The workflow is: deal closes in Zoho CRM → you manually (or via Zapier) create a partner invoice in Zoho Books → Zoho Books calculates commission and tracks payout status. This works if your affiliate relationships are simple: one partner per deal, fixed commission %. It breaks when you have multi-partner splits or tiered calculations. The advantage: if you're already using Zoho Books for accounting, invoicing, and payroll, adding the affiliate module gives you one financial system. Everything feeds into yo