Sales team stops fixing its commission sheet every month
Commission rules changed with pricing, old and new.
Sales teams
Every month someone fixes the commission sheet before we can pay the closers.
- The problem
- Every month someone fixes the commission sheet before we can pay the closers.
- What we built
- A dashboard per closer. Built in Google Sheets.
- What changed
- Delivered, with updates after launch.
The problem
Every month someone fixes the commission sheet before we can pay the closers.
- Commission rules changed with pricing, old and new.
- Formulas broke when rows were added, and data went into the wrong tab.
- Each closer’s monthly stats had to be right for payouts.
What we built
- A dashboard per closer. Built in Google Sheets.
- Old and new pricing. Commission logic that handles both.
- Monthly reporting. Revenue collected, month by month.
- Ranges that grow. New rows no longer break the formulas.
What changed
Delivered, with updates after launch.
Fixing the commission sheet every month?
Send the report you rebuild by hand. We will tell you what can build itself.
Two more like this
- ConstructionHas a video, 1 minute 4 seconds
Contractor asks his CRM on WhatsApp
My CRM has years of deals. I never have time to dig through it.
- Home services
HVAC owner gets his numbers by asking
My numbers sit in the CRM and the invoices. A revenue picture means pulling it by hand.
Tools
- Google Sheets
- Apps Script