Commission Calculator

WHAT IT DOES

Commission Calculator scans CRM deal and opportunity pages, extracting deal amounts and assigned sales representatives, then applies configurable commission rates to calculate commissions per deal and total commissions. The tool supports multiple commission structures — flat percentage, tiered rates based on deal size, and rep-specific custom rates. It displays a complete commission summary with per-rep breakdowns, showing each rep's total commission and deal count. You can also apply tax deductions to net commissions and use weighted pipeline calculations based on deal probability. All settings are saved locally and persist across sessions.

WHERE IT RUNS

This userscript runs inside major CRM platforms including Salesforce, HubSpot, Pipedrive, Zoho, Freshworks, and Close in your browser, powered by the free BotGentz extension. It operates entirely on the page you are viewing — it does not send your sales data anywhere else. All data extraction and commission calculations happen locally in your browser. The script works on all CRM pipeline and deal list pages.

HOW TO USE

Install the BotGentz extension, then install this userscript from the BotGentz catalogue. Navigate to your CRM's deal or opportunity page. Configure your commission settings — enter a default commission rate, optional tiered rates (e.g., "10000:5, 50000:8" for 5% on deals over $10K, 8% over $50K), and per-rep custom rates (e.g., "Alice:12, Bob:8" for 12% for Alice, 8% for Bob). Toggle "Use weighted" to multiply deal amounts by their probability percentage. Set an optional tax deduction rate. Click "Save Settings" to persist your configuration, then "Scan Page" to calculate commissions for all visible deals. Click "Copy Results" to export the data to your clipboard.

HOW IT WORKS UNDER THE HOOD

The script uses a multi-strategy extraction approach to identify deal data across different CRM platforms. It first attempts to locate deal tables using platform-specific selectors like table.opportunity-table, .deals-table, and .pipeline-table. If those fail, it scans for any table containing CRM-related keywords like opportunity, deal, pipeline, amount, or owner. The script intelligently identifies table headers and maps values to deal name, amount, owner/rep, stage, and probability. For commission calculation, it applies the configured rate structure in priority order: rep-specific rate > tiered rate > default rate. If weighted pipeline mode is enabled, the deal amount is multiplied by the probability percentage (e.g., a $100K deal at 50% probability contributes $50K to commission calculations). All settings are saved using GM_setValue for persistence.

THE PANEL

The tool runs in the BotGentz panel, a draggable floating interface that stays on top of the page. You can drag the panel by its header, collapse it to a small bubble, and resize it. The panel remembers its position per site, so it stays where you left it when you return to your CRM. Press Escape to close the panel when you are done. The panel includes a settings section for commission configuration, a results section showing total deal value, total commission, and per-rep breakdown, and action buttons for scanning and copying.

PLEASE NOTE

This tool requires the free BotGentz extension to run. CRM platforms frequently update their interfaces — if the tool stops working, check for an updated version or report the issue. All data stays in your browser and is never sent to any external server. The tool works only on the current page; to calculate commissions from multiple pages, scan each page individually. The tool extracts visible data only and cannot access data not loaded on the current page. Commission calculations are estimates and should be verified against your organization's official commission policies.