Sales Commission Tracker V3
Sales Commission Tracker V3 turns messy Whop, FanBasis and Stripe payments into accurate rep commissions — inside your own Google Sheet, no subscription, no data ever leaves your Workspace.
A commission tracking and customer identity system for teams selling on Whop, FanBasis, Stripe, Gumroad, or any platform that can POST a JSON webhook. Sales Commission Tracker V3 ingests every charge and refund, resolves aliases and spouse/family cards to the correct customer, calculates tiered rep commissions, handles partial refunds with clawbacks, and exports payroll-ready CSVs — all from a Google Sheet you own. One-time purchase. No monthly fees. Runs entirely inside your Google Workspace.
The Problem
Why this matters
If your team sells across Whop, FanBasis, Stripe, Gumroad, or a mix of platforms, Monday mornings look the same: a pile of CSV exports, a spreadsheet of reps, and three hours of detective work. Customers pay from their personal email one week and a work email the next. Spouse or family cards appear on renewals. A partial refund comes through and nobody remembers which rep to claw back from. Someone types a customer name wrong and the same buyer gets counted twice. The wrong rep gets paid. A real rep spots it and you're now in a disputed-payroll conversation. SaaS tools that solve this start at $200/month, lock your customer list behind someone else's login, and still can't touch your exact commission rules.
The Solution
How we solve it
Sales Commission Tracker V3 is a Google Apps Script that installs into a spreadsheet you own and turns it into a commission engine. Zapier, Make, or any platform that can POST JSON (Whop, FanBasis, Stripe, Gumroad) sends every charge and refund to your Web App URL, protected by a shared-secret key. The auto-match engine scores each incoming payment against your customer list on five signals — canonical email, known alias, card-last4 history, email domain, and outstanding balance — and flags clear winners, ambiguous matches, and new customers separately so you never silently pay the wrong rep. Tiered commission rules resolve per product, per rep, per cumulative revenue band (all-time, yearly, or monthly). Partial refunds issue a matching clawback against the original rep. A per-rep tokenised portal lets reps see their own sales and earnings — nothing else. Every mutation is written to an append-only audit log. Every payroll cycle, export a ready-to-pay CSV. Your customer data never leaves your Google Workspace.
The Results
What you get
- Cut weekly commission reconciliation from hours of spreadsheet archaeology to a single Run Batch Match click
- Stop paying the wrong rep: ambiguous matches surface as PARTIAL with the top candidates and scores — you decide, the engine never silently guesses
- Handle spouse and family cards cleanly — a new email bound to another customer is logged as a Shared Payment Source instead of polluting the alias graph
- Partial refunds create matching clawbacks automatically, with per-refund-id deduplication so duplicate webhooks never double-claw
- Tiered commission rules pay your reps correctly as they cross revenue milestones — no more manual payroll overrides
- One-time purchase. No monthly SaaS fees. No per-seat pricing. No vendor with visibility into your customer list
- Your data stays in your Google Workspace — no MageSheet servers, no third-party database, no external API caching your customers
- Audit Log and CSV exports (Payroll, Commission Ledger, Customers, Audit Log) give you and your accountant a clean paper trail
Interactive Product Tour
A click-through demo with realistic sample data. Browse tabs, filter tables, explore the UI. Save, import, and other write actions happen for real in the live app — one click away.
Key Features
Auto-Match Engine With Scored Candidates
Every incoming payment is scored against your customer list on five identity signals — canonical email (100), known alias (95), card-last4 history (80), same email domain (40), and outstanding balance (30). If there's a clear winner (top score 90+ with no runner-up above 70) the payment is flagged AUTO_MATCH. Ambiguous ones are flagged PARTIAL with every candidate, score, and reason listed for you to choose from. Unknown buyers surface as NEW. The engine never silently picks a customer when the signal is weak.
Webhook Ingestion From Whop, FanBasis, Stripe, Gumroad — Or Anything
Deploy as a Google Apps Script Web App and point Zapier, Make, Pabbly, or a native platform webhook at your URL. Any source that can POST JSON with email, amount, and a platform transaction id works out of the box. Shared-secret authentication via ?key= or a body secret. Idempotent on platform_txn_id — duplicate webhooks never create double-paid commissions. CSV imports also work for historical or offline sales.
Tiered Commission Rules Per Rep, Per Product
Commission Rules sheet supports flat rates and cumulative-revenue tiers over all-time, yearly, or monthly windows. Rules resolve by product, rep, and priority — so a rep's rate can step up from 15% to 22% once they cross $10k in a year, with a different band for a different product. When no rule matches, the default rate applies. Edit rules directly in the sheet; no code changes needed.
Partial Refunds & Clawback Handling
When a refund webhook arrives, the system finds the original charge by platform_txn_id, creates a matching clawback entry against the original rep, and tracks the cumulative refunded balance. Full refunds close the transaction; partials leave it open for further refunds. Duplicate refund webhooks with the same platform_refund_id are deduplicated, so a retrying payment processor can never claw back twice.
Per-Rep Tokenised Portal
Generate a private, tokenised URL per sales rep from the Commission V3 menu. Each rep opens their link and sees only their own sales, commissions earned, and payout totals — never other reps' numbers, never admin controls. Tokens are stored in a protected Rep Tokens sheet and can be rotated any time. The portal is mobile-responsive (v3.1.1), so reps can check earnings from their phone.
Cell-Level Protection & Audit Log
Initial Setup applies Google Sheets cell-level protection to the ledger, alias registry, raw transactions, batch log, error log, shared payment sources, rep tokens, and audit log — a rep or assistant can view, but edits are blocked with a warning. Every mutating action (register, clawback, alias learn, batch match) is written to an append-only Audit Log with timestamp, actor email, target, and details. You always know who did what and when.
One-Click CSV Export For Payroll
The Export tab produces four ready-to-send CSVs: Payroll Summary (pay this rep $X this cycle), Commission Ledger (every charge and clawback line), Customers (the master profile list), and Audit Log (full mutation history). Hand the Payroll CSV to your accountant, keep the Audit Log for compliance, and re-run any cycle without re-doing the work.
Configuration Wizard & Pre-Flight Validation
A modal Configuration Wizard sets your company name, default commission rate, currency, Slack notification webhook, and rotates your webhook secret. Before processing the Registration Queue, a pre-flight check blocks on hard errors (missing customer, duplicate assignments) and surfaces soft warnings (unassigned rep) — so you catch payroll mistakes before the ledger is written, not after.
Google Workspace Integration
Works seamlessly with your favorite Google apps
What Does It Bring to Your Business?
Real business value, not just cool tech
Your Customer Data Stays Yours
Every charge, alias, and commission line lives in your own Google Sheet. No MageSheet server, no third-party database, no vendor who can see your customer list, change their pricing, or lock your account.
Reclaim Your Reconciliation Day
The auto-match engine processes every pending transaction in one batch run. What used to take half a Monday — chasing aliases, spouse cards, and refund clawbacks — is now a single click and a short review queue.
Accurate Payouts, Every Time
Tiered commission rules, deterministic partial-refund clawbacks, and pre-flight validation mean your reps get paid exactly what they earned. No double-paid commissions on retried webhooks. No silent wrong-rep assignments.
Built For Non-Technical Teams
Reps get a private, mobile-friendly portal showing their own sales and earnings. Admins run the batch match and export payroll CSVs from a clean web UI. Nobody has to learn Apps Script to use it day-to-day.
Own It Forever
One-time purchase. No per-seat pricing, no monthly SaaS creep, no renewal email that doubles your bill next year. One year of free updates; after that, your version keeps running.
Simple Pricing
Choose the plan that fits your needs
Standard
Script only — install it yourself, no support
- Auto-Match Engine (5-signal scored matching)
- Webhook ingestion from Whop, FanBasis, Stripe, Gumroad, or any JSON source
- Tiered commission rules (all-time / yearly / monthly)
- Partial refunds with automatic clawback handling
- Per-rep tokenised portal (mobile-responsive)
- Cell-level sheet protection + append-only Audit Log
- CSV export: Payroll, Commission Ledger, Customers, Audit Log
- Configuration Wizard + pre-flight batch validation
- 100% unobfuscated source code — yours forever
- 1 year of free updates (renewal at 50% after)
Managed
Script + professional installation + 2 weeks free support
- Everything in Standard
- Professional installation — we paste source files, deploy the Web App, and hand over the working URL
- Configuration Wizard walkthrough with you (company name, currency, webhook secret, notification settings)
- Sanity check against sample data to confirm end-to-end operation
- 2 weeks of priority response on code-level questions
- (Zapier / Stripe / Whop / FanBasis / Make / Pabbly webhook setup remains your responsibility — see Custom+)
Custom+
Everything in Managed + custom features built on top
- Everything in Managed
- Custom feature development on top of the script
- Tailored to your specific workflow
- Delivered via Upwork (escrow protection)
- Full source code ownership
Frequently Asked Questions
Everything you need to know
Anything that can POST a JSON webhook — Whop, FanBasis, Stripe, Gumroad, Paddle, Lemon Squeezy, and so on — either natively or through Zapier, Make, or Pabbly. The fields the engine needs are platform_txn_id, email, amount, currency, and a platform label; card_last4 and product_id are optional but improve matching. You can also paste historical sales as CSV into the Sales Intake tab.
Every incoming payment is scored on five signals: canonical email (100), known alias (95), card-last4 history (80), same email domain (40), and outstanding balance (30). A clear winner (top score 90+, runner-up below 70) becomes AUTO_MATCH. Ambiguous payments become PARTIAL with the top candidates listed for your review. When you tick "Learn alias" on registration, the new email links to that customer forever — unless it's already bound to another customer, in which case the system writes a Shared Payment Source record instead of corrupting the alias graph.
Everything — customer profiles, transactions, commission ledger, audit log — lives in your own Google Sheet, inside your Google Workspace (or your personal Gmail account). MageSheet has zero access after purchase. No external server, no third-party database, no API caching your customers. The script runs as your Google account. Google's native version history acts as your automatic backup.
Yes. You receive 100% unobfuscated Apps Script — readable JavaScript you paste into your own project. Modify anything you like. Note from our Terms of Service: free updates during your licence period apply to the unmodified delivered code. Third-party modifications void the update and support warranty for the affected areas, so keep a pristine backup if you plan to customise and still want upgrades.
Standard is the script itself — you install it yourself using the setup guide. Managed adds professional installation in your Workspace, a walkthrough of the Configuration Wizard, and two weeks of priority support. Managed covers installation of OUR product only. It does NOT include setting up your Zapier, Make, Stripe, FanBasis, or any third-party account — that's Custom+ (hourly engagement). Custom+ also covers custom commission logic, bespoke integrations, and data migration. Current pricing is shown in the package selector on this page.
No. Zapier, Make, Stripe, FanBasis, and Whop configuration lives in your accounts and uses your credentials — that's a Custom+ engagement. The Standard and Managed tiers include detailed setup docs showing you the exact fields to map (platform_txn_id, email, amount, etc.) so a non-technical admin can typically wire it up in 20–45 minutes per platform, depending on how familiar you are with the source platform's webhook interface.
All new versions released during the 12 months after your purchase — bug fixes, new features, compatibility updates when Google or payment platforms change their APIs. You get the updated files and a short changelog. After year 1, your installed version keeps working forever; renewal for continued updates is 50% of the then-current price.
Out of the box, the webhook endpoint uses shared-secret authentication — the caller passes your secret on the URL (?key=YOUR_SECRET) or in the JSON body, and the script compares it with constant-time equality. That's a pre-shared key, not full HMAC request signing. If you specifically need HMAC-SHA256 with per-request signatures (e.g. native Stripe signature verification), that's a short Custom+ add-on.
Data migration is not included in Standard or Managed — those tiers cover the script and its installation. If you have an existing commission sheet with historical customers, transactions, and rep assignments to bring over, that's a Custom+ engagement. Going forward, a plain CSV drop into the Sales Intake tab handles routine historical imports.
Ready to get Sales Commission Tracker V3?
Starting from $149