Blog · Territory, capacity and quota planning · Software
Compare commission payouts under explicit usage-revenue rules. Build a workbook from approved usage, credited revenue and payout assumptions, then test timing, rate changes and reconciliation checks.
Consumption based sales compensation ties payouts to a defined customer-usage revenue measure, an approved seller credit and a stated commission rate. The workbook must also specify when the amount becomes eligible for payment. Otherwise an apparently lower commission expense might simply reflect delayed billing or collection.
Consumption changes the amount customers generate after signing. Stripe's usage-based billing documentation describes the underlying pricing approach as charging according to use of a product or service. That describes customer billing, not a required compensation rule; your company still needs to decide which amount earns sales credit.
Write down the eligible revenue basis, the owner of usage approval, the seller-credit rule, the rate and the eligibility event. Also state exclusions such as taxes, promotional credits, refunds and noncommissionable services. Have the compensation owner resolve uncertain terms before comparing scenarios.
The consumption-based pricing article covers the customer pricing question. Here the job is narrower: calculate payout exposure under explicit assumptions, then prove that the workbook follows them.
Distinguish the estimated payout from the accounting treatment of commission costs. The calculations below estimate amounts under a hypothetical plan; they do not establish whether a cost should be expensed or capitalized in the financial statements.
Start with one approved row per customer and usage period. Keep customer ID, contract ID, usage period, approval status, billable units, net unit price, eligible revenue, seller ID, credit percentage, rate and eligibility date. Add invoice and collection references if those events affect eligibility.
Keep usage corrections as identified adjustments. Do not overwrite an earlier approved period without retaining enough detail to explain the change. Restrict the calculation to the agreed period and approval status, then reconcile eligible revenue to the finance-approved usage report.
Seller credits need their own check. The sales crediting rules article explains split credits and overlays; here, assume the entire eligible amount is credited to one seller. Do not join an account summary to several credit rows and then sum the repeated revenue as though it were new business.
A hypothetical US software company pays an 8% commission on approved usage revenue. There are no discounts, refunds, minimum commitments or accelerators in this example. Every listed unit is eligible, the net unit price is $2, and seller credit is complete.
| Usage month | Approved units | Net unit price (USD) | Eligible revenue (USD) | Rate | Estimated payout (USD) |
|---|---|---|---|---|---|
| July | 10,000 | 2 | 20,000 | 8% | 1,600 |
| August | 15,000 | 2 | 30,000 | 8% | 2,400 |
| September | 12,000 | 2 | 24,000 | 8% | 1,920 |
| Total | 37,000 | 74,000 | 5,920 |
Use columns A:F in Google Sheets as shown. In D2 calculate eligible revenue, then calculate estimated payout in F2:
=B2*C2
=D2*E2
Fill both formulas down through row 4. This assumes the approved export already establishes the billable quantity and net price. A tiered contract needs its approved revenue calculation first; multiplying all units by a single displayed rate would not reproduce tiered charges.
Estimated payout = Eligible usage revenue × Seller credit percentage × Commission rate
The revenue check is 37,000 units × $2 = $74,000. The payout check is $74,000 × 8% = $5,920. With the constant rate, both checks must match the column totals. All dollar results here are exact; real workbooks should retain full precision and round at the payment level specified in the plan.
For varying rates, use an independent total calculation:
=SUMPRODUCT(D2:D4,E2:E4)
Google's SUMPRODUCT documentation confirms that it multiplies corresponding values and sums the results. This checks the row formulas without relying on a simple average commission rate.
Suppose finance wants to compare a 6% rate with the existing 8%, keeping the same eligible rows and credit rules.
| Usage month | Eligible revenue (USD) | Payout at 8% (USD) | Payout at 6% (USD) | Difference (USD) |
|---|---|---|---|---|
| July | 20,000 | 1,600 | 1,200 | 400 |
| August | 30,000 | 2,400 | 1,800 | 600 |
| September | 24,000 | 1,920 | 1,440 | 480 |
| Total | 74,000 | 5,920 | 4,440 | 1,480 |
Calculate the comparison column with =B2*6% and the difference with =C2-D2. The total difference also equals $74,000 × (8% − 6%) = $1,480. This is a rate effect because the eligible revenue and timing are held constant.
A rate comparison does not establish whether either plan encourages the desired behavior. Sales leadership owns that judgment. Finance checks affordability and exposure; sales operations checks credit assignment and source completeness.
Now retain the 8% rate but assume the company pays only on eligible collected amounts. These are the amounts collected by the chosen cutoff against each usage month's charges.
| Usage month | Usage revenue (USD) | Collected by cutoff (USD) | Payout eligible at cutoff (USD) |
|---|---|---|---|
| July | 20,000 | 16,000 | 1,280 |
| August | 30,000 | 28,000 | 2,240 |
| September | 24,000 | 22,000 | 1,760 |
| Total | 74,000 | 66,000 | 5,280 |
The cutoff payout is $66,000 × 8% = $5,280. The $640 difference from $5,920 is potential later eligibility on uncollected amounts, subject to the plan and eventual collection. It is not a reduction in the rate.
For a collection export with collection date in A and eligible collected amount in B, a monthly summary can use:
=SUMIFS(B2:B1000,A2:A1000,">="&DATE(2026,10,1),A2:A1000,"<"&DATE(2026,11,1))
Google's SUMIFS documentation supports the multiple date criteria. Use collection dates for this summary and retain the original usage period separately. Apply the commission-run data checks before treating a calculated amount as ready for approval.
Covirage is not affiliated with Google or Stripe.
Bring your approved usage export, credited revenue and compensation assumptions to Covirage, which maps the columns and uses its tools to compute and check the figures. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for spreadsheet analysis for the supporting workflow.
That depends on the written compensation plan. Revenue-based rules respond to approved usage revenue, while collection-based rules delay eligibility until the specified cash event. Compare both under the same seller credits and rates before deciding; the choice changes timing and who bears collection risk.
State whether the minimum is commissioned when signed, when invoiced, or as usage consumes the commitment. If a commitment earns an initial payout, define how later usage avoids earning the same commission again. Keep the commitment and usage reconciliation visible.
Yes, if the plan permits adjustments for approved usage corrections, refunds, credit memos or seller-credit changes. Preserve the original calculation and show the adjustment separately. An updated estimate should explain the affected usage period and the period in which the adjustment becomes payable.