You have 47 affiliates. Your spreadsheet has seven tabs, three sheets people email you edits to, and formulas that broke three months ago when someone deleted a row. You know exactly 2% of your margin is leaking somewhere between their clicks and your bank account—you just can't prove it. The standard story here is: hire an ops person. But you're not there yet. You don't have enough volume to justify a full hire, and outsourced affiliate management costs 10–15% of payouts. So you need a system that automates commission math, payout scheduling, and dispute handling without requiring a person to manually babysit it. This is the blueprint. It starts with why spreadsheets fail at scale, moves through the actual workflow you need to build, then shows you the real cost and reconciliation trade-offs between native invoicing and bolting on a third-party platform. Why Spreadsheets Leak 8–12% Annually A spreadsheet works fine at 5 affiliates. By 47, it's systematically broken in ways that are hard to trace: Formula drift: You copy a commission formula down 200 rows, then someone edits a cell range and now rows 147–156 calculate differently. You don't find it for six months. Manual data entry: Affiliate reports come in via email, you paste them into the sheet, typos accumulate. A click ID is entered as "12345" instead of "123456". That affiliate never gets paid for those conversions. Version chaos: You email the sheet to your accountant, she makes changes, those edits don't sync back. You work from an old version. Duplicate payouts or missed affiliates. No audit trail: Who changed the commission rate for Partner X? When? Why? You have no idea. LHDN or a partner dispute finds you without evidence. Payout timing drifts: You say payouts run on the 15th. Three months you pay on the 18th because the sheet took longer to reconcile. Affiliates stop promoting. Reconciliation is manual and late: You spend 6 hours at month-end matching your sheet to your bank statement, then another 3 hours to your revenue data. Errors surface weeks later. The math: if your spreadsheet introduces a 2% error rate (missed conversions, duplicate payouts, late payouts that kill future volume), and your affiliate channel does ₹50L in revenue annually, you lose ₹10L in margin. One ops hire costs ₹10–15L but still requires human review. Automation wins. The Workflow You Actually Need A real affiliate system has five core processes. Each one needs automation, or you inherit the spreadsheet problem. 1. Click Tracking and Attribution Every affiliate gets a unique tracking link. When a customer clicks it, you record the click, the click ID, the affiliate ID, and the timestamp. This is not optional—it's where reconciliation starts. Use a dedicated tracking layer (Refersion, Impact, or custom built on Segment + your database) rather than trying to tag this in your CRM. CRMs are bad at high-volume event streams. Log every click, even if the visitor doesn't convert. You need that data to defend against affiliate disputes ("I sent 300 clicks but you only credited 42 conversions"). Validate the affiliate ID and link on every click. If an affiliate uses an expired or fake link, reject it immediately and log why. 2. Conversion Recording and Revenue Attribution A click becomes a conversion when the customer completes the target action: purchase, signup, trial start. Revenue attribution happens here. Store the conversion event with the click ID, affiliate ID, revenue amount, and timestamp. Do not rely on manual reporting from affiliates. If you use invoicing software with API access , hook it into your revenue stream. Every invoice tied to an affiliate link gets automatically tagged and revenue is recorded in your affiliate ledger. This eliminates the "did that conversion actually happen" argument. Set a conversion window (e.g., 30 days from click). Any conversion outside that window is rejected automatically and logged for disputes. If revenue is refunded, reverse the commission credit immediately. Track refunds separately so you can report them to affiliates. 3. Commission Calculation and Approval This is where spreadsheet math lives. Automate it completely. For each affiliate, store their commission structure: flat percentage, tiered (e.g., 8% on first ₹10L, 10% on ₹10–25L), or per-conversion bonus. Store it in a database or a config file, not a spreadsheet cell. Run a nightly batch job that calculates commission for all conversions recorded that day. Multiply revenue by rate, apply any caps or minimums, and log the result with a timestamp. No human intervention. Flag conversions for approval if they meet certain criteria: unusually large order, new affiliate, conversion outside the window but within appeal range. Log every flag with a reason. Approval is a human decision; the calculation is not. Once approved, commission is locked in the ledger. It cannot be changed without a signed amendment and an audit log entry. 4. Payout Scheduling and Execution Payouts ha