How to Create a Commission Calculation for Marketing & Digital Agencies
A standardised process for calculating, verifying, and processing sales commissions and variable compensation based on closed deals and performance metrics.
Purpose
To ensure sales commissions are calculated accurately, transparently, and paid on time, maintaining trust between the sales team and the organisation.
Scope
Covers the end-to-end commission process from deal verification through calculation, approval, dispute resolution, and payment submission. Applies to all commission-eligible roles.
Prerequisites
- Commission plan documents signed by all eligible sales staff
- CRM data reconciled and verified for the commission period
- Commission calculation tool or spreadsheet configured with current plan rules
- Finance team availability for payment processing within the agreed timeline
Includes provisions for Australian Consumer Law (ACL), Privacy Act compliance for customer data, and ACMA spam regulations.
Step-by-Step Procedure
Verify Eligible Deals
Pull and validate all deals closed during the commission period to ensure they meet eligibility criteria.
- 1.1Export all Closed Won opportunities from the CRM for the commission period
- 1.2Verify each deal has a signed contract or purchase brief on file
- 1.3Confirm deal values, close dates, and owner assignments are accurate
- 1.4Exclude any deals that do not meet eligibility criteria (e.g., pending payment, internal deals)
- Cross-reference CRM data with finance records to catch discrepancies early
Apply Commission Rates and Rules
Calculate commissions for each deal and each representative using the commission plan rules.
- 2.1Apply the base commission rate to each eligible deal
- 2.2Calculate accelerators for above-quota performance where applicable
- 2.3Apply any modifiers for multi-year deals, strategic accounts, or split credits
- 2.4Deduct any clawbacks for deals that were cancelled or refunded
- Double-check accelerator thresholds — errors here have the biggest financial impact
Calculate Total Compensation
Sum up all individual deal commissions, bonuses, and adjustments to arrive at the total variable compensation for each person.
- 3.1Aggregate deal-level commissions by representative
- 3.2Add any eligible bonuses (quarterly bonus, SPIF, contest winnings)
- 3.3Subtract any prior overpayments or adjustments
- 3.4Produce a commission statement for each representative
- Always show the calculation breakdown — transparency prevents disputes
Conduct Peer Review of Calculations
Have a second person review the commission calculations for accuracy before distribution.
- 4.1Assign a peer reviewer to check a sample of calculations (minimum 20%)
- 4.2Verify the correct commission rates were applied per each person plan
- 4.3Confirm mathematical accuracy of totals and adjustments
- Focus the review on the highest-value commissions and any unusual calculations
Distribute Commission Statements
Share individual commission statements with each sales representative for their review.
- 5.1Send personalised commission statements to each representative securely
- 5.2Include the deal-level breakdown, rates applied, and total payment
- 5.3Set a clear deadline for raising any questions or disputes (typically 5 business days)
- Deliver statements on the same day each period — consistency builds trust
Handle Disputes and Adjustments
Review and resolve any disputes or questions raised by sales representatives within the dispute window.
- 6.1Log each dispute with the specific deals and amounts in question
- 6.2Investigate the disputed items against CRM records and contracts
- 6.3Communicate the resolution to the representative with supporting evidence
- 6.4Process any corrections as adjustments in the next commission cycle
- Resolve disputes quickly — unresolved commission issues erode morale fast
Obtain Management Approval
Submit the finalised commission report to sales leadership and finance for approval before payment.
- 7.1Prepare the summary commission report showing total payable by person and in aggregate
- 7.2Submit for sales leadership sign-off on the amounts
- 7.3Submit for finance approval on budget and payment processing
- Include a comparison to the prior period to help approvers spot anomalies
Submit for Payment
Send the approved commission data to payroll or finance for inclusion in the next pay cycle.
- 8.1Format the commission data per the payroll system requirements
- 8.2Submit to payroll by the required deadline for the pay cycle
- 8.3Confirm payment will be included in the specified pay date
- 8.4Archive the commission records and approval trail for audit purposes
- Know the payroll submission deadlines and work backwards — late submissions delay payment
Quality Checkpoints
Common Mistakes to Avoid
Expected Outcomes
Percentage of commission payments that require no post-payment correction, targeting above 98%.
Percentage of commission payments processed by the committed pay date, targeting 100%.
Percentage of commission statements that result in a formal dispute, targeting below 5%.
Frequently Asked Questions
How do we handle commission during territory or role changes?
Deals that were in the pipeline before the change are typically assigned to the original owner. Deals that enter the pipeline after the change belong to the new owner. For overlapping periods, use a transition policy documented in the commission plan.
When should commissions be paid?
Best practice is to pay commissions in the pay cycle immediately following the end of the commission period (e.g., deals closed in January are paid in February payroll). Some organisations pay upon cash receipt rather than deal close — the key is transparency about the policy.
Who resolves commission disputes?
Commission disputes should be handled by sales operations as a neutral party. If the dispute cannot be resolved at that level, it escalates to the sales leader. Having a documented dispute resolution process in the commission plan prevents ad hoc decisions.
What happens if a deal is cancelled after commission is paid?
Most commission plans include a clawback provision. If a deal is cancelled or refunded within a specified period (typically 90 days), the commission is deducted from a future payment. The clawback policy should be clearly stated in the commission plan document.
How are split commissions handled?
Split commissions should be defined in the commission plan. Common approaches include a percentage split between participants (e.g., 60/40 between closer and SDR) or full credit to each party (double-counting for motivation). Document the split on the opportunity record at the time of the deal.
Want this customised for YOUR business?
We'll tailor every step to your exact operations, tools, and team structure.