ProductsBlogConsultingAboutContactGet Started
AppScript Tool

Sales Commission Tracker V3

Automate identity resolution, match aliases, and track platform sales securely within Google Sheets.

A powerful identity-matching engine and commission tracker. Effortlessly consolidate sales from platforms like FanBasis and Whop, resolve messy customer aliases, and calculate payouts—all within a protected Workspace environment.

The Problem

Why this matters

When selling across digital platforms (Whop, FanBasis, Stripe), customer data is notoriously messy. Customers use variations of their emails, aliases, or family members' credit cards. Tracking who bought what, and assigning the correct sales commission to your representatives, turns into a massive, error-prone manual reconciliation nightmare.

The Solution

How we solve it

The Commission Tracker V3 functions as an intelligent matching engine inside Google Sheets. It automatically ingests raw transaction data and uses its 'Auto-Match Engine' to resolve aliases to the correct master Customer Profile, calculating rep commissions seamlessly and keeping an immutable audit trail of every batch execution.

The Results

What you get

  • Eliminate 'alias pollution' with a centralized customer identity profile
  • Automate affiliate and sales rep commission calculations instantly
  • Maintain strict data governance with cell-level sheet protection
  • Cut weekly reconciliation time from hours down to seconds

Live Interactive Demo

Click the button below to experience Sales Commission Tracker V3 directly in your browser.

Key Features

Auto-Match Identity Engine

Automatically match messy payment emails and aliases (like spouse cards) to a single parent customer profile.

Consolidated Dashboard

A dark-mode command center to monitor pending transactions, total revenue, and auto-match success rates.

Cell-Level Protection

Advanced sheet security ensures that sales reps can only see what they need, while admins maintain full control over the engine.

Batch Execution History

Every automated matching run is logged with its duration and success rate, giving you a full, transparent audit trail.

Google Workspace Integration

Works seamlessly with your favorite Google apps

📊Google Sheets
🔗Google Apps Script
🚀 Coming Soon to Google Workspace Marketplace

What Does It Bring to Your Business?

Real business value, not just cool tech

Data Privacy

Keep sensitive customer payment identities completely private.

Reclaim Hours

Stop manually matching Excel rows. Let the engine do it in seconds.

High Accuracy

Remove human error from commission and payout calculations.

Fully Customizable

Tweak commission percentages and matching rules directly in the code.

Simple Pricing

Choose the plan that fits your needs

Standard

Script only — install it yourself, no support

$109one-time
  • Auto-Match Identity Engine
  • Customer Alias Profiling
  • Batch History Audit Trail
  • Cell-Level Security Models
  • 100% Unobfuscated Source Code
  • Lifetime Updates
Buy via WhatsApp
Most Popular

Managed

Script + professional installation + 2 weeks free support

$139one-time
  • Everything in Standard
  • Professional installation & setup by our team
  • 2 weeks of free priority support
  • Configuration assistance
Buy via WhatsApp

Custom+

Everything in Managed + custom features built on top

Custom
  • 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
Get a Quote

Frequently Asked Questions

Everything you need to know

It supports any platform that can export CSVs or webhooks (like Whop, FanBasis, Stripe, or PayPal) by mapping their transaction columns to the engine.

When a new transaction arrives, the system checks the customer's raw payment email against a database of known aliases and master profiles. If it matches an alias, the transaction is instantly assigned to the correct user.

Yes. All processing happens internally within your private Google Workspace. The sheet protection model also prevents unauthorized staff from altering critical matching logic.

Ready to get Sales Commission Tracker V3?

Starting from $109

Get Started Today