Salesforce Commission Tracking: How Far You Get Natively

Can you track commission in Salesforce?

Yes, for simple plans. Salesforce Sales Cloud has no built-in commission statement, but a formula field on the opportunity can calculate a flat commission per deal, and a report can total it by opportunity owner. Tiers across a period, accelerators, clawbacks, draws, approvals of a statement and a payroll-ready file all need custom development, a spreadsheet or a separate system.

This guide is for sales leaders, RevOps and finance teams that run Salesforce as their CRM and calculate commission from a report export today. It covers what Salesforce offers natively in November 2026, a step-by-step flat-rate setup, the fields that decide the number, where the setup breaks, edge cases such as multi-currency and opportunity splits, and how to decide when commission should move out of the CRM. It also includes new data from public job ads on which companies run their sales on Salesforce.

Key findings

• 11.0% of 1,810 companies with open job ads in Prowi's dataset name Salesforce in at least one ad, against 18.2% for HubSpot (2 November 2026).
• 28.2% of the companies with 20 or more open ads name Salesforce, the same share as HubSpot. Among companies with 1 to 4 open ads, only 5.0% do.
• 45.0% of the companies that name Salesforce never mention HubSpot in any ad, so a large group runs sales on Salesforce alone.
• 100% is the ceiling for revenue splits on an opportunity. Overlay splits can go above it, which is why splits assign credit, not commission.
• $34,500 is the commission in our tiered example that no single opportunity can calculate on its own, because the rate depends on the other deals in the month.

What does Salesforce offer for commission today (November 2026)?

Salesforce gives you building blocks, not a commission module. Formula fields, roll-up summary fields, report formulas, opportunity splits, forecast quotas and Flow can be combined into a per-deal calculation and a monthly report. Salesforce also sells commission and incentive management as separate paid add-ons, which are outside the scope of this guide.

We went through Salesforce Help, Trailhead and the developer documentation. The table shows what each building block does and what it can be used for in a commission setup.

The limits come from Salesforce's own documentation (see the sources at the end). Editions and feature names change, so check your own org before you build. The figures that matter most are the formula size limits and the rule that roll-up summary fields only work across master-detail relationships.

Why the roll-up rule matters for commission

Commission is calculated per rep, and the rep is the opportunity owner. In Salesforce the owner is a lookup to the User object, not a master-detail relationship. That means you cannot put a roll-up summary field on the User record that totals a rep's won opportunities for the month. You can roll opportunities up to the account, because Salesforce supports roll-ups from opportunities to accounts, but the account is not the person who gets paid. Anything that needs a running total per rep has to be built in a report, with Flow or Apex, or outside Salesforce.

Which opportunity fields decide commission in Salesforce?

Six or seven fields decide almost every commission number: whether the opportunity is won, when it closed, the amount and currency, the owner, the opportunity type and the products. If any of them is wrong in Salesforce, the commission is wrong wherever it is calculated.

Amount versus products

If you add products to an opportunity, Salesforce calculates the Amount from the product lines. If you pay the same rate on everything, that is fine. If you pay 10% on software and 3% on hardware, the commission has to be calculated per product line and then summed back onto the opportunity. A formula field on the opportunity product can do the first part. Summing it back works through a roll-up summary on the opportunity, because opportunity products sit in a master-detail relationship to the opportunity. Check this in a sandbox before you rely on it, because discounts, schedules and price books all change what lands on the line.

Multi-currency

With multiple currencies enabled, each opportunity has its own currency and reports convert to your corporate currency. If advanced currency management with dated exchange rates is on, Salesforce's own Trailhead notes that Amount may not be available to aggregate in a roll-up summary field. Decide in the plan which rate applies (the rate on the close date, a fixed plan rate, or the rate on the payment date) and make sure the report uses the same one.

How do you set up flat-rate commission in Salesforce, step by step?

A flat commission rate on won opportunities can be built with one custom field, one formula field and one report. It takes an admin about an hour and works well as long as every won deal pays the same way.

1. Pick the data: Write down which field commission is paid on (usually Amount, excluding tax), which stages count as won, and which date decides the period (usually Close Date). These are the three points reps dispute most often, so agree on them in writing first.
2. Calculate per opportunity: Create a percent field for the rate, either on the User record (Commission_Rate__c) if each rep has one rate, or on the opportunity if it varies by deal. Then create a currency formula field on the opportunity, for example IF(IsWon, Amount * Owner.Commission_Rate__c, 0). Wrap Amount in BLANKVALUE(Amount, 0) if some won deals have no amount.
3. Total per rep: Build an opportunity report filtered on Won = true and Close Date = last month, grouped by Opportunity Owner, showing the sum of the commission field. Save it in a folder that sales managers and finance can see.
4. Approve the statement: Have the sales manager check the report against the deals they know, and record who approved what and when. Salesforce has no commission statement record to approve, so this step usually happens by email or in a shared file.
5. Send to payroll: Export the report details to XLSX or CSV, add employee numbers and the pay code your payroll system expects, and keep a locked copy of the file as documentation.

Example: three opportunities at 10%

Example: an account executive closes three opportunities in October at a 10% rate.

The report shows $24,500 and the amount can go to payroll. This is as far as native Salesforce goes without extra building. The problems start when the plan looks more like real life.

Variant: different rates for new business and existing customers

Many plans pay more for a new customer than for an upsell. You can handle that in the same formula with the standard Type field: CASE(Type, "New Customer", Amount * 0.10, "Existing Customer - Upgrade", Amount * 0.05, 0). Check the picklist values in your own org first, because many orgs have renamed them. A validation rule that makes Type required before an opportunity can be closed won prevents the most common mistake: a blank type that pays nothing, or the wrong type that pays too much. Our guide to commission on new business vs existing customers covers how to set those rates.

If you calculate in a spreadsheet

With tiers, splits or clawbacks in the plan, most Salesforce teams end up exporting a report every month. A fixed routine makes it less fragile:

• Run the same saved report every month: won opportunities with a close date in the period, from the sales processes that pay commission.
• Export details with owner, amount, currency, close date, type, opportunity ID and any custom fields the plan uses.
• Calculate commission in the sheet, for example with our free commission statement template.
• Keep a locked copy per month, and compare opportunity IDs with last month's file to find deals that changed after they were paid.

The weakness is that the export is a snapshot. If an opportunity is reopened, reduced or reassigned after the file was made, the sheet does not notice. Clawbacks then depend on someone spotting the change by hand.

Where does native Salesforce commission tracking break?

A formula field only sees the opportunity it sits on and the records it looks up to. Anything that depends on other opportunities, on the period, or on what has already been paid has to be built around it with reports, Flow, Apex or a spreadsheet.

Why tiers are the big wall

A tiered plan pays a higher rate as the rep's total for the period grows. The table shows a typical monthly plan.

Example: a rep closes $450,000 in the month, in two opportunities. The first, $200,000 on the 10th, earns $7,500 on the first $150,000 and $4,000 on the next $50,000, so $11,500. The second, $250,000 on the 25th, starts in the 8% tier: $100,000 at 8% is $8,000 and $150,000 at 10% is $15,000, so $23,000. The month's commission is $34,500.

Neither opportunity can calculate its own commission, because the answer depends on the other deal and on the order they closed in. A formula that looks up the rate per deal gets it wrong. If it applied 8% to both deals because each falls in the 8% band on its own, it would pay $36,000. This is why tiered plans in Salesforce end up in Apex, Flow or a spreadsheet.

When a deal from an earlier month is cancelled, you also need a clawback at the rate that applied then. If the $200,000 deal is cancelled in December, the clawback is not 10% of $200,000. It is the $11,500 actually paid, or a recalculation of October without the deal, depending on your plan wording. Salesforce has no memory of either number.

How do opportunity splits work for commission?

Opportunity splits divide credit for an opportunity between team members. Revenue splits cannot exceed 100% of the amount, overlay splits can, and you can add up to six custom split types. Splits tell you who gets credit for how much. They do not apply a commission rate or record what was paid.

Example: a split deal

Example: an $80,000 opportunity with a 70/30 revenue split between the account executive and the SDR, plus a 100% overlay for the sales engineer. The plan pays the AE 10% of their share ($5,600), the SDR 5% of their share ($1,200) and the sales engineer 2% of the overlay credit ($1,600). Salesforce stores the three credit lines. The three rates, and the rule that the sales engineer is paid on overlay at all, live in your plan and your spreadsheet.

How do quotas and attainment work in Salesforce?

Collaborative Forecasts can hold a quota per user or territory per period, and forecast views show how much of it each rep has closed. That gives you quota attainment, which many plans use to decide the rate. It does not turn attainment into a payout.

A typical accelerator pays the base rate up to 100% of quota and a higher rate above it. Salesforce can show that a rep is at 112% of quota. The commission on the 12% above quota, at the accelerated rate, still has to be calculated somewhere else. If quotas change mid-period, keep the old and new quota and the date of the change, because reps will ask which one applied.

Which companies run their sales on Salesforce? What job ads show

In Prowi's dataset of public job ads, 11.0% of companies name Salesforce in at least one open ad. The share rises steeply with the number of open roles, from 5.0% of companies with 1 to 4 open ads to 28.2% of companies with 20 or more, where Salesforce is level with HubSpot.

We count a company once if any of its open ads names the CRM. The data comes from Prowi's jobstore, a dataset of public job ads from company career pages, read on 2 November 2026: 1,810 companies with 16,406 open ads, with recruitment agencies left out. The number of open ads is a rough proxy for company size and hiring pace.

By region, we used the company's web domain as a rough guide. Companies on Nordic domains (.dk, .se, .no, .fi) name any of the three CRMs far less often in their ads, which partly reflects that Nordic ads list fewer tools.

How to read these numbers

• A mention is not proof of use. "Salesforce or HubSpot experience" is a wish list, and consultancies post Salesforce developer roles for client work.
• The dataset was first built from companies that use HubSpot, so HubSpot is over-represented. The size pattern for Salesforce is the more robust finding.
• A generic domain such as .com does not mean a US company. Many European companies use .com.
• The finding that holds up: the more people a company is hiring, the more likely it is that its sales team works in Salesforce, and those are also the companies with the most complex commission plans.

Salesforce vs HubSpot vs Pipedrive for commission: how do they compare?

None of the three CRMs has a native commission statement. Salesforce has the most powerful building blocks (formulas with conditions, splits, Flow and Apex), but it also takes the most admin work to turn them into a working plan.

For the details on the other systems, see our guides to HubSpot commission tracking, Pipedrive commission tracking, Dynamics 365 commission tracking and SuperOffice commission tracking.

Can you build commission in Salesforce with Flow or Apex?

Yes. A developer can build a custom commission object, a scheduled job that recalculates tiers per rep, an approval process on a statement record and an export class for payroll. It works, but you then own a small commission system inside your CRM, with its own testing, documentation and upkeep every time the plan changes.

The questions to ask before you build:

• Who maintains it? Commission plans change at least once a year. If the person who wrote the Apex leaves, the plan freezes.
• How are paid amounts stored? A correct design stores what was paid per period, so a later change creates a correction, not a silent recalculation.
• Can reps see it? Reps need a statement they can trust. A report they can filter to their own deals is not the same thing.
• What does it cost? Developer time, a sandbox, test coverage and admin time each month. Compare that with the cost of a dedicated tool or the spreadsheet you have now.

What are the most common mistakes when tracking commission in Salesforce?

Most errors come from data, not formulas: deals closed with the wrong date or type, owners changed at handover, and formulas edited after deals were paid. Fixing the data rules in Salesforce prevents more disputes than a better formula does.

1. Close Date left as the forecast date. A deal won on 2 November with a close date of 31 October lands in the wrong month. Use a Flow that sets Close Date to today when the stage changes to closed won, or agree that a separate "Won date" field decides the period.
2. Owner changed at handover. When the account executive hands the customer to an account manager by changing the opportunity owner, commission follows. Keep the original seller in a separate lookup field, or hand over the account, not the closed opportunity.
3. Formula edited mid-year. Changing the rate in the formula recalculates every past opportunity in reports. Store the rate on the opportunity at close (a Flow can stamp it), so past deals keep the rate they were sold at.
4. Reopened opportunities. A closed-won deal moved back to an open stage disappears from the report. If it was already paid, nothing flags it.
5. Amount versus invoiced value. Salesforce holds what was sold. If the plan pays on what was invoiced or paid, the numbers live in your ERP or billing system, and the two have to be reconciled.
6. Currencies mixed in one total. A report that sums Amount across currencies without conversion is wrong. Make sure the commission field is converted the same way as the plan says.

Which edge cases should your Salesforce setup handle?

The edge cases decide whether reps trust the number. Write a rule for each of these in the plan, then check that Salesforce holds the data the rule needs.

Example: a EUR 50,000 deal is converted at 1.08 USD per euro on the close date, which gives $54,000. At the rate on the payment date, 1.12, it would be $56,000. At a 10% rate the difference in commission is $200. Small per deal, but it adds up across a year, so the plan should say which rate applies.

What must a commission plan say, whatever the CRM? (US, UK, EU)

The CRM holds the data, but the plan document is what reps are paid by. In many places the rules for how commission is computed must be in writing, and commission counts as pay. This is general information, not legal advice; check with local employment counsel.

• United States. Wage laws vary by state. California Labor Code section 2751, for example, requires commission contracts to be in writing and to set out the method by which commissions are computed and paid.
• United Kingdom. Commission counts as wages under section 27 of the Employment Rights Act 1996, so the rules on deductions from wages also cover clawbacks.
• EU and the Nordics. The Transparent and Predictable Working Conditions Directive (EU) 2019/1152 requires employers to inform workers in writing of their remuneration, including its component parts and how it is paid. National rules add more.

For the CRM setup, this means the field definitions in Salesforce should match the plan's definitions word for word: what "won" means, which date counts and what happens when a deal changes.

When should you move commission out of Salesforce?

Keep commission in Salesforce while the plan is one flat rate per rep and nobody shares deals. Move it out when the plan has tiers, quotas, splits or clawbacks, or when someone spends a day or more each month exporting and checking.

A quick way to check where your plan stands is the commission plan health check, which scores clarity, rules, process and data in a few minutes.

How does Prowi connect to Salesforce?

Prowi reads won opportunities from Salesforce with the fields you choose and calculates commission by your plan, outside the CRM. Changes in Salesforce are picked up on a schedule, typically within about 15 minutes, and reps see their earnings update in the Prowi app.

Prowi's Salesforce integration fetches recently changed records every 15 minutes, with an overlap so that a change is not lost between runs. The rules are built in Prowi: which stages count, which date decides the period, rates per opportunity type, tiers, accelerators, splits and clawbacks. When a period starts, Prowi creates a statement for each rep that updates live through the period. When the period closes, the statement moves to awaiting approval, and once approved the amount is added to the rep's balance and passed on to payroll, either straight into Zenegy or as a payroll file. If an opportunity changes after the period is approved, the difference lands as a correction on the next statement.

Read more about the Prowi Salesforce integration, or book a demo to see it on your own Salesforce data.

FAQ

Does Salesforce have a built-in commission feature?

Not in Sales Cloud itself. You can calculate commission per opportunity with a formula field and total it in a report. Salesforce sells commission and incentive management as separate paid add-ons, and many teams use a spreadsheet or a dedicated tool instead.

How do I calculate commission in Salesforce?

Create a percent field for the rate, then a currency formula field on the opportunity such as IF(IsWon, Amount * Owner.Commission_Rate__c, 0). Build a report of won opportunities in the period, grouped by owner, with the sum of the commission field.

Can Salesforce calculate tiered commission?

Not with standard fields. The rate depends on the rep's total for the period, and roll-up summary fields cannot total opportunities per owner because the owner is a lookup, not a master-detail relationship. You need Apex, Flow, a spreadsheet or a separate system.

Can a roll-up summary field total commission per sales rep?

No. Roll-up summary fields only work on the master side of a master-detail relationship. Opportunities can roll up to the account, but not to the User record of the owner. Use a report grouped by owner instead.

Do opportunity splits calculate split commission?

No. Splits assign credit: revenue splits up to 100% of the amount, overlay splits above it. The commission rate for each person and the rules for who is paid on overlay still have to be applied in your plan or tool.

How often does Prowi sync with Salesforce?

Prowi fetches changed Salesforce records on a schedule every 15 minutes, with an overlap so nothing is missed. Reps see their commission update in the app after the next sync and recalculation.

Sources

• Salesforce Trailhead: Roll-Up Summary Fields
• Salesforce: Tips for Reducing Formula Size (PDF)
• Salesforce: Team Selling and Opportunity Splits Implementation Guide (PDF)
• Salesforce Trailhead: Sell as a Team and Split the Credit
• Salesforce Developers: ForecastingQuota object
• Salesforce Trailhead: Apply a Discount with a Custom Summary Formula
• Salesforce Trailhead: Build a Record-Triggered Flow
• Salesforce Trailhead: Manage Reported Data (export)
• California Labor Code section 2751
• UK Employment Rights Act 1996, section 27
• EUR-Lex: Directive (EU) 2019/1152 on transparent and predictable working conditions
• Prowi jobstore, public job ads from company career pages, read 2 November 2026 (1,810 companies, 16,406 open ads, recruiters excluded)