KiloClawPowered by OpenClaw
Back to Cookbook
OpenClaw recipe

Real-Time Sales Commission Calculator

aka “Commission Tracker”

Know exactly what you're owed before the commission statement arrives

Commission statements are often disputed or hard to verify. This skill calculates your commissions in real time from your deal data, so you never have to maintain a shadow spreadsheet or wonder if finance got it right.

House RecipeWork10 min setup
Try in KiloClawFree 7-day trial

INGREDIENTS

📄Google Docs💬Slack

PROMPT

Create a skill called "Commission Tracker". I'll input my compensation plan rules: base commission rate, quota, tier breakpoints, accelerators, decelerators, SPIFs, and any special conditions. As deals close in my CRM, calculate my earned commission in real time. Show: per-deal commission earned, cumulative earnings, progress toward accelerator thresholds, and projected total earnings based on pipeline. Support what-if modeling: "if I close deals X, Y, Z this quarter, what's my total payout?" When I upload my official commission statement, compare line-by-line against my calculated amounts and flag any discrepancies with deal-level detail.

How It Works

Input your comp plan rules and the skill calculates commissions as deals close.

Real-time earnings visibility, what-if modeling for pending deals, and automatic

reconciliation against your official commission statement.

What You Get

  • Real-time commission calculation as deals close
  • Deal-level earnings breakdown
  • What-if calculator: "if I close these 3 deals, my commission is..."
  • Accelerator/decelerator tracking (where are you relative to thresholds?)
  • Statement reconciliation: compare your calculated amount vs. official statement
  • Monthly earnings summary with trend tracking

Setup Steps

  1. Input your comp plan: base rate, tiers, accelerators, SPIFs
  2. Connect your CRM or provide a recurring export or provide a recurring export closed-won data
  3. The skill calculates commissions automatically going forward
  4. Upload official statements for reconciliation

Tips

  • Update your plan immediately when comp changes are announced — don't wait for a pay cycle to discover errors
  • The what-if calculator changes how you prioritize deals — you can see exactly how accelerators kick in
  • Flag discrepancies immediately with specific deal-level data — finance resolves faster when you show your work
  • Share your calculation methodology with your manager for transparency
Tags:#compensation#commissions#sales#finance

Related Recipes

CRM Hygiene Bot

Continuous data cleanup that runs while you sleep

Deduplication, data decay detection, and field standardization on autopilot. Stop running quarterly "data cleanup projects" that take weeks. Let your Claw keep the CRM clean continuously.

Work5 min setup

Pipeline Review Autopilot

Your Monday morning pipeline deck, built overnight

Stop spending Sunday night in Salesforce. This skill auto-generates your weekly pipeline review — snapshots, deltas, risk flags, and talking points — delivered before you pour your coffee.

Work5 min setup

CLAWBITE AI

Local-first AI assistant that automates small daily tasks safely on your device

A personal, local-first AI assistant that automates small daily tasks—organizing files, setting reminders, and monitoring system events—without touching sensitive data or taking risky actions without your approval.

Personal5 min

The De-Botinator

Wikipedia-grade AI pattern removal

Comprehensive AI writing cleanup based on Wikipedia's WikiProject AI Cleanup guidelines. Catches 24+ distinct patterns including inflated symbolism, em dash overuse, rule of three, copula avoidance, and sycophantic tone.

Creative1 min