Most affiliate programs start with enthusiasm and end in a spreadsheet mess. You have no idea which referral partner drove which lead. Conversion attribution happens weeks late. Payouts get disputed because no one can prove the deal closed. Then someone demos Refersion or Impact, you see the $500–1,500 monthly bill, and you wonder if you should just kill the program. You shouldn't. Affiliate tracking doesn't require specialty software if you're under 50 active partners or fewer than 500 referral leads per month. A spreadsheet, a CRM with basic automation , and Zapier can do the job for under $50 a month—and you'll actually understand your data instead of trusting a black box. Here's the playbook: how to track, validate, and pay without bleeding money on overengineered platforms. The three-layer structure: intake, conversion, payout Affiliate payouts fail because the handoff layers are invisible. The referral partner submits a lead. It lands in your CRM as a contact. A salesperson converts it. Somewhere in that chain, the affiliate attribution gets lost. Three months later, the partner emails asking why they weren't paid. You need three things to happen in order: Intake: Affiliate submits a lead with a unique tracking link or code. You capture the partner ID and the referred contact. Conversion: The referred contact becomes a qualified opportunity, then a closed deal. The affiliate record moves from "pending" to "qualified" to "paid." Payout: Once the deal closes, you calculate commission (fixed fee, percentage, tiered), generate a payout record, and trigger payment. Most affiliate platforms bundle all three. You don't need to. You can split them across tools that you already have. Layer 1: Intake—capture the source Your affiliate partners need an easy way to refer leads. They send you an email, fill a form, or share a unique link. Either way, you need to tag the contact with the partner's ID before they enter your CRM. Use one of these approaches: Google Form + Zapier → CRM: Create a simple form. Partners fill in the prospect's name, email, and phone. Zapier watches the form and creates a contact in your CRM with a custom field: "Affiliate Partner" = [partner name]. Cost: free form, $20–30 Zapier. Unique email address or UTM code: Give each partner a unique email (john.smith@youraffiliates.com) or UTM code (utm_source=john-smith). When they forward a lead or share a link, Zapier catches it and tags the contact. This works if partners are comfortable forwarding emails or sharing your link. Direct CRM form: If you use Orin's CRM , create a simple intake form with a dropdown: "Who referred you?" Partners share that link. No external tools needed. Pick whichever your partners will actually use. A form no one fills is worse than no form. The most common failure: partners don't tag leads consistently. Require the tag upfront, or you'll spend weeks validating historic data. Layer 2: Conversion—track movement from lead to deal Once a lead is tagged with an affiliate partner, your sales process happens normally. The lead moves through your pipeline, gets qualified, and hopefully closes. The affiliate attribution should follow automatically. In your CRM, add a custom field to opportunities or deals: "Affiliate Partner" (text or dropdown—auto-populate from the contact's partner tag) "Affiliate Status" (Pending, Qualified, Converted, Paid, Disputed) "Affiliate Commission" (calculated field or manual entry) When a deal closes, update the status to "Converted." Zapier watches for this and logs it in your tracking spreadsheet. The spreadsheet is your single source of truth for commissions. It should have columns for: Date referred Affiliate partner name Referred contact name Opportunity amount Deal close date Commission percentage or fixed amount Commission due Status (Pending, Paid, Disputed) Payment date Zapier can auto-populate most of these. When a deal closes in your CRM, Zapier pulls the partner ID, amount, and date, then appends a row. Why not just keep everything in the CRM? Because commissions change, disputes happen, and accountants need an audit trail. A spreadsheet is dumb, but it's transparent. Everyone can see the math. Layer 3: Payout—close the loop and prove it Once a deal is closed and the commission is calculated, you have two options: manual payout or automated. Manual (best for under 20 partners per month): Once a week, export your "Converted" leads from the spreadsheet. Calculate net commission. Write checks or process bank transfers. Update the "Payment date" column. Takes 30 minutes. Partners see proof immediately. Automated (if you process 50+ payouts per month): Use Zapier to watch your spreadsheet. When a row status changes to "Approved for Payout," Zapier triggers a payment via Stripe, PayPal, or your accounting software. This works if commission amounts are predictable (fixed fee or simple percentage). Complex tiered structures are harder to automate. Either way, send the affiliate partner a pa