Commission checks
Check commission statements against closed deals before payout.
Commission statements are checked by hand against closed deals, so wrong rates and missed deals slip through. Hops matches every statement line to a closed deal in your CRM, applies the comp plan and shows the difference in dollars.
How it runs: Scheduled. An automation runs monthly on day 3 at 9am, reminds you to upload the statement and saves the check as a Doc. You can also ask Hops any time.
What it does
- Matches every line to a deal. Hops reads the uploaded statement and finds the closed deal in Salesforce or HubSpot for each line.
- Applies the comp plan. It recomputes each payout with the plan rate and compares it to the statement.
- Flags what is wrong. Wrong rates, deals missing from the statement and deals paid twice are listed separately.
- Shows the dollar gap. Every flagged line has the amount paid, the amount expected and the difference.
- Never changes payouts. Hops reports differences and leaves corrections to you and finance.
Ask Hops
Copy a prompt into any chat with Hops, or mention @Hops in a Space.
Check the October commission statement against closed deals.Which deals are missing from the Northwind rep's statement?Did we pay any deal twice this quarter?Recompute commissions for Acme Corp at the new accelerator rate and show the difference.Example reply:
Commission check ready for October:
- 46 of 49 statement lines match closed deals.
- 2 deals paid at the wrong rate, $1,840 over in total.
- 1 closed deal is missing, Globex renewal, $2,100 owed.
What you get
- A Slack or Space post each month with the match count and flagged lines.
- A saved Doc in Docs with the full line-by-line check, dated for the month.
- On-demand checks. Upload a statement any time and ask Hops to check it.
Connections needed
Connect these apps. Each card opens Connections in the app.
Set it up
Connect your apps
Connect the apps above in Connections.
See Connections.
Pin context
Create a revops Space. Pin the comp plan and add the commissions spreadsheet to Space context.
See Spaces and Space context.
Add the skill
Create a skill with this prompt so the output has the same format every time.
Plain textYou check commissions. Match each statement line to a closed deal and apply the comp plan rate. Flag wrong rates, missing deals and deals paid twice. Show the difference in dollars.See Build a skill.
Schedule it
Run monthly on day 3 at 9am. Hops reminds you to upload the statement, posts the result to the Space and saves a Doc.
See Automation.