Qoyod
Pricing

Sales Commission Template: Plans, Formulas, and Payroll Integration

نموذج جاهز قابل للتعديل — حمّله مجانًا واستخدمه في عملك مباشرة.

A free, editable template — download and use it directly in your business.

Every sales manager in Saudi Arabia hits the same question at month end: why did rep “A” close SAR 480,000 in deals and earn a commission of SAR 24,000, while rep “B” closed SAR 510,000 and earned only SAR 19,200? Why does the sales team complain every month that commissions are “unfair” even though the owner pays generous rates? And why do commissions eat into the profit margin in some months until the business loses money on deals it thought were profitable?

The answer does not come from raising the rate or from individual negotiation with each rep. It comes from a written commission plan and a digital model that turns the plan into objective monthly numbers. A commission plan is not a reward sheet for the “top performer”. It is an implicit contract between the business and its team that defines exactly what we want to sell, at what profitability, when the business pays, and how much the rep earns for every riyal that enters the treasury.

In this practical guide we build a sales commission model from scratch to operation: the definition of commission and its importance as a motivator, the five core commission types in the Saudi market, the legal framework under Saudi Labor Law and social insurance, calculation formulas with numeric examples for three reps, design mistakes that drain profitability, linking commissions to CRM and accounting reports, the difference between commission, allowance, and bonus, the tax and zakat impact, and how Qoyod turns the plan into an automated monthly cycle that ends with the commission appearing in the payslip and uploaded to the Wage Protection System (WPS) file.

Free Download

Editable sales commission template with automated monthly calculation

A model built in Excel and Google Sheets that supports flat rate, tiered, and quota-based commissions, with ready columns for returns, social insurance deductions, and exporting the approved commission to the monthly payslip.

What sales commissions are and why they cap your growth

A sales commission is a variable amount paid to a rep or sales team for achieving a measurable result: a closed deal, collected revenue, realized profit margin, or a composite target combining these elements. The idea is simple on the surface and deep in its effect; instead of a fixed salary paid for time, the business pays for results, so the rep moves from an employee who shows up to a partner who sells.

The Saudi market over the past decade has seen a fundamental shift in this area. With the expansion of retail, restaurants, contracting, and professional services, commission has become a standard part of the compensation package in every sales role: outside rep, telesales, account manager, branch rep, even cashiers in some chains. Businesses that design their plans intelligently grow faster because sales spend becomes a variable expense tied to actual cash inflow, not a fixed cost that drains the budget in weak months.

Practically, a well-designed commission plan delivers four functions a fixed salary alone cannot:

  • Behavior shaping: the rep sells what you reward. Reward revenue and the rep focuses on big low-margin invoices. Reward margin and the rep focuses on smarter products.
  • Risk sharing: in weak months commissions drop automatically and so does the business cost, so operating losses do not fall on management alone.
  • Talent retention: the strong rep earns visibly more, so does not have to hunt for an outside offer to prove market value.
  • Financial predictability: when commission is tied to collected revenue, it becomes a known percentage of sales, which makes building forecasted financial statements and a projected income statement much easier.

Before going deeper, it helps to separate four concepts many people mix: commission, allowance, bonus, and team incentives. Commission is tied to a direct individual sales result. Allowance is a fixed or near-fixed amount paid for a job-related commitment (transport, housing, communications). Bonus is a non-recurring recognition of an exceptional achievement. Team incentives are distributed across a full team when a shared target is hit. Mixing these in the payslip creates disputes with employees and complications in calculating social insurance contributions, as we will detail below.

Five calculation methods

Common sales commission types in Saudi businesses

01

Flat percentage of revenue

A fixed rate (e.g. 3%) calculated on the collected invoice value. Simplest to compute, weakest at shaping behavior.

02

Tiered rising rates

The rate rises as the rep crosses each tier (e.g. 2% up to 100K, 4% up to 200K, 6% above).

03

Fixed amount per unit

A fixed amount per sale (SAR 300 per annual subscription). Suitable for homogeneous products.

04

Quota-based

Commission paid only on exceeding a monthly or quarterly quota, with a higher OTE salary and Accelerator incentives.

05

Team-based

A percentage of total team revenue distributed by role weight (Account Executive, SDR, Manager).

Advanced businesses mix two or three types to balance simplicity and intelligence.

The five commission types: when to use each

1) Flat percentage of sales

The simplest commission type and the most common in small and mid-sized businesses in Saudi Arabia. You pick a fixed rate (3% for example) and apply it to the value of every invoice collected under the rep’s name. Suitable for activities where products are similar and profit margin is relatively uniform, like car showrooms, real estate agents, or travel agencies.

Its weakness is that it does not shape behavior. The rep cannot distinguish a product with an 8% margin from one with a 35% margin, so they sell the easiest, not the smartest. It also drains profitability when prices are reduced or discounts granted. The common fix is to tie the rate to margin rather than revenue, so you pay 8% of gross profit instead of 3% of revenue, turning the rep from a volume seller into a value seller.

2) Tiered rising commission

The most common in professional sales teams: monthly sales are split into tiers and each tier gets its own rate. A practical example:

  • First SAR 100,000: 2%
  • From 100,001 to 200,000: 4%
  • Above 200,000: 6%

The deeper idea here is that the business rewards the stronger rep non-linearly. The advantage is a strong incentive to exceed the target, not just meet it. The disadvantage is that some reps push deals from a weak month into the next to reach a higher tier. The fix is to look at cumulative quarterly or annual performance, not only monthly.

3) Fixed amount per unit

Here you pay a defined amount per unit sold regardless of its value. For example SAR 300 per activated annual SaaS subscription, or SAR 50 per monthly maintenance contract. Suitable for homogeneous products that sell at a near-fixed price, where there is no major difference between deals. The big advantage is that it is easy for the rep to understand and forecast. The weakness is that it does not reward upsell or higher-tier bundles.

4) Quota-based commission

The most used in professional B2B teams and rooted in the OTE (On-Target Earnings) model widespread in tech companies. The idea: you set a monthly or quarterly quota (e.g. SAR 400,000) and a target salary when achieved (e.g. SAR 25,000 inclusive of commission and base salary). The rep earns the full commission rate only on reaching the quota, with an Accelerator above it. Below the quota, commission drops noticeably.

This model is the most effective in larger teams because it ties sales spend to defined outcomes, but it requires organizational maturity in setting targets. A too-optimistic quota demoralizes the team; a too-pessimistic one makes everyone exceed it and inflates commissions. The golden rule: 60-70% of the team should reach quota under normal conditions.

5) Team-based commission

A percentage of total team revenue distributed by role weight. For example 5% of team revenue distributed as: 50% to the Account Executive who closed the deal, 30% to the SDR who booked the meeting, 20% to the manager who led the deal. This boosts intra-team collaboration and reduces ownership disputes, but it weakens individual drive if not carefully designed. Suitable for long sales cycles involving multiple roles before close.

The legal foundation: what Saudi Labor Law says about commission

The legal framework for commissions in Saudi Arabia rests on the Saudi Labor Law issued by Royal Decree M/51 and its amendments. Three main articles govern how the business treats commission:

Article 2 of the Saudi Labor Law: defines wage as “everything given to the worker for their work under an employment contract” and includes commissions and percentages of sales within this definition. This means commission is part of the wage, and the statutory rights that follow cannot be waived by any agreement.

Article 88 of the Saudi Labor Law: regulates how the “actual wage” used to compute end-of-service benefit (EOSB) is calculated. The actual wage includes commissions if they are of a steady nature. This precise legal detail matters when computing end-of-service benefit, and has caused dozens of labor disputes before the labor office when businesses ignored including the average commission in the calculation.

Article 90 of the Saudi Labor Law: obligates the employer to pay wages on the agreed date and prohibits delaying them. Applied to commissions, this means the business cannot postpone paying a month’s commission for two or three months on the pretext of “confirming collection” unless the employment contract explicitly states so.

Social insurance contributions on commissions

The social insurance system distinguishes between allowances and commissions in the contribution base. Per Article 19 of the social insurance law and its executive regulations, commission enters the contribution base if it is “of a regular and steady nature”. Practically, most sales teams pay commission monthly on a regular basis, so it enters the contribution base at 9.75% on the employee and 11.75% on the employer (for Saudis). Ignoring inclusion of commission in the contribution base exposes the business to retroactive settlements with penalties that can exceed 25% of the amounts due.

Practical rule: if commission is a regular part of the rep’s pay, include it in the contribution base. If it is a one-off exceptional payment (such as a bonus for closing a large deal), it can be excluded with proper documentation in the payslip and employment contract.

Wage Protection System (WPS)

Since the Wage Protection System became mandatory for all businesses in Saudi Arabia, every salary payment must go through the bank WPS file. Commissions are not exempt; they must be included in the monthly payroll file the same way as base salary and allowances, and transferred in one payment to the employee’s bank account. Paying commission in cash or by a separate transfer outside the WPS file exposes the business to a regulatory violation and makes it harder for the employee to prove payment in any later dispute.

Commission calculation formulas: from flat rate to OTE

Each of the five commission types has its own formula. The downloadable template includes all of them in an Excel sheet, but it helps to understand the logic before applying it.

Formula 1: flat rate

The simplest formula: rep commission = (total collected sales in the month) × (agreed commission rate).

Example: a rep closed deals worth SAR 320,000 at a 4% commission rate. Commission = 320,000 × 4% = SAR 12,800.

Real-world adjustments to this formula:

  • Exclude returns: if returned goods worth SAR 30,000 were processed, deduct them from the base. Adjusted formula: commission = (320,000 − 30,000) × 4% = SAR 11,600.
  • Apply commission to collected, not invoiced: if SAR 80,000 of deals are not yet collected, it is better to defer commission to the month of actual collection.
  • Deduct excessive discounts: if the rep granted discounts above 5%, deduct a portion from the commission to motivate price preservation.

Formula 2: tiered

Tiers are computed cumulatively. Example with a (2% / 4% / 6%) structure and a rep who closed SAR 280,000:

  • Tier 1 (0 to 100,000): 100,000 × 2% = SAR 2,000
  • Tier 2 (100,001 to 200,000): 100,000 × 4% = SAR 4,000
  • Tier 3 (200,001 to 280,000): 80,000 × 6% = SAR 4,800
  • Total: SAR 10,800

The common mistake is applying the highest rate to all sales once a tier is crossed (280,000 × 6% = SAR 16,800), which drains profitability quickly. Cumulative tiered calculation is the standard in every professional commission plan worldwide.

Formula 3: OTE salary and Accelerator incentives

In the OTE model the structure is: fixed base salary + target commission at 100% quota, with a multiplier above it. Example:

  • Base salary: SAR 12,000 per month
  • Monthly quota: SAR 400,000 in revenue
  • Target commission at 100% quota: SAR 13,000 (OTE = 25,000)
  • Base commission rate: 3.25% (13,000 ÷ 400,000)
  • Accelerator above 100%: 4.875% (1.5× multiplier)
  • Accelerator above 130%: 6.5% (2× multiplier)

A rep who achieved SAR 520,000 (130% of quota):

  • First 400,000: 400,000 × 3.25% = SAR 13,000
  • From 400,001 to 520,000: 120,000 × 4.875% = SAR 5,850
  • Total: SAR 18,850 commission + SAR 12,000 base = SAR 30,850

This model is the most common in SaaS, insurance, and financial services in Saudi Arabia. The ready template computes it automatically once the quota and actual revenue are entered.

A practical example: three reps, one month, different outcomes

To anchor the logic, take a mid-sized business in Riyadh selling retail management software, with three reps under a unified commission structure:

  • Base salary: SAR 8,000
  • Housing allowance: SAR 2,000
  • Transport allowance: SAR 800
  • Monthly quota: SAR 150,000 in collected revenue
  • Tiered commission: 2% up to 100K, 4% from 100K to 150K, 6% above 150K
Numeric example

Commission calculation for three reps in one month

Line item Rep A Rep B Rep C
Total invoiced amount SAR 220,000 SAR 175,000 SAR 95,000
Returns deducted SAR 20,000 SAR 5,000 SAR 0
Uncollected deals SAR 0 SAR 25,000 SAR 0
Commission base SAR 200,000 SAR 145,000 SAR 95,000
Tier 1 commission (2%) SAR 2,000 SAR 1,900 SAR 1,900
Tier 2 commission (4%) SAR 2,000 SAR 1,800 SAR 0
Tier 3 commission (6%) SAR 3,000 SAR 0 SAR 0
Total commission SAR 7,000 SAR 3,700 SAR 1,900
Total monthly pay SAR 17,800 SAR 14,500 SAR 12,700

Rep A exceeded the quota and earned the top tier. Rep B saw some deals collected late and lost a tier. Rep C did not reach the base quota tier.

This simple table exposes two fundamental points often overlooked in plan design: returns eat the commission before the rep notices, and uncollected deals disappear from the calculation. These two points alone cost the business on average 8-12% of the monthly commission budget if not handled correctly.

How to design a fair commission plan: six rules before launch

Plan design matters more than the formula. A plan with a modest rate but clear, motivating logic beats a generous plan that everyone complains about.

Rule 1: start from profitability, not revenue

Ask yourself: what is the profit margin available after every direct cost of sale? If your gross margin is 30%, you cannot pay 12% of revenue as commission and still expect to be profitable. General rule for consumer products: do not exceed 15-20% of gross profit per deal. For services with 70-80% margin: you can go up to 25-35%.

Rule 2: tie payment to collection, not invoicing

In the Saudi market, especially in B2B, the gap between invoicing and collection can reach 90 days. A smart commission plan rewards cash that has actually entered the treasury, not invoices issued. This design forges an implicit alliance between sales and collections; the rep becomes a collector too because their commission is delayed if payment is delayed.

Rule 3: differentiate between new and repeat customers

The effort to win a new customer is much greater than selling an additional product to an existing one. Many professional commission plans pay a higher rate on the first deal with a new customer (e.g. 8%) and a lower rate on subsequent deals (3%) because the later deal comes with the help of the support team and an existing relationship, not the rep’s individual effort alone.

Rule 4: set a sensible cap or none at all

The debate is old among sales managers: should there be a monthly cap on commission? Financial logic says yes, to protect the budget from an exceptional mega-deal. Motivational logic says no, because a cap demotivates the rep the moment they hit it. The most common middle ground: no cap on normal commissions, but any single deal above a defined value (e.g. SAR 500,000) gets a lower rate (Mega-deal rate).

Rule 5: write the plan in a signed document

Every commission dispute in Saudi started from a verbal sentence. The commission plan must be written and signed as an addendum to the employment contract, including: the formulas, effective date, return-handling mechanism, payment timing, and modification rules (does it require 30 days’ notice?). A signed document protects both sides in any dispute.

Rule 6: review the plan every 6 to 12 months

The Saudi market changes fast. A quarterly target suitable today may be pessimistic after six months. Make the plan review a fixed appointment in the leadership calendar, and ask: do the rates balance business profitability and team enthusiasm? Do they steer behavior toward strategic products? Do they retain top talent?

The five most costly mistakes in commission plans

From reviewing dozens of commission plans across Saudi businesses, five mistakes recur strikingly:

Mistake one: rates so high they eat the profit. An owner sets commission at 10% of revenue because “the market does”, then discovers their gross margin is only 22%, meaning 45% of profit goes to sales before any operating expense. The fix: compute the highest payable rate based on profit margin, not market rumor.

Mistake two: ignoring returns and cancellations. The rep takes commission on a September deal, the customer cancels in October, and the commission stays in the rep’s pocket while the business eats the loss. The fix: a Clawback clause in the commission agreement allows deducting the cancelled deal’s commission from the next month’s payout.

Mistake three: delaying payment for months. The rep earns a commission they wait 90 days for, loses motivation, and looks for another offer. The fix: pay 70-80% of the expected commission in the payslip following the deal close, and hold 20-30% as reserve to be released after collection is confirmed.

Mistake four: mixing commission with bonus in the payslip. This mistake is financial and regulatory at once. The business pays a “monthly bonus” to a rep that is actually a commission, excludes it from the social insurance base, and later faces a retroactive settlement with social insurance. The fix: name each line item correctly in the payslip and in the payroll accrual entry.

Mistake five: changing the plan retroactively. The owner discovers commission is too high and lowers it on deals already done. This change usually ends in a labor dispute lost before the labor office, because an agreed wage cannot be modified retroactively.

Linking commissions to CRM and accounting reports

A commission plan without a system to compute it automatically is a recipe for monthly arguments between management and team. The minimum automation links three layers:

  1. CRM captures the closed deal, the rep’s name, the value, and the date.
  2. Accounting system issues the invoice, tracks collection, and updates deal status from “invoiced” to “collected”.
  3. Payroll system receives the automatically computed commission and includes it in the monthly payslip.

Businesses using an integrated platform like Qoyod (which combines accounting, invoicing, and payroll in one platform) get the integration automatically. Businesses using fragmented systems need manual integrations or application programming interfaces (APIs) to link CRM with the accounting system.

At the reporting level, at least three monthly reports must be available:

  • Commission report per rep: deal detail plus computed base plus commission due.
  • Commission-to-sales ratio: an overall indicator measuring whether the plan is draining the budget.
  • Cancelled-deals list: to trigger the Clawback clause on commissions for deals that did not stick.

These reports tie the commission file to the monthly financial statements, and let leadership monitor cost-of-sales-to-revenue as a core operating KPI.

The difference between commission, allowance, and bonus in the payslip

The precise distinction between these three components matters accountingly and legally, because each is treated differently in social insurance, tax, and end-of-service benefit.

Accounting distinction

Commission, allowance, and bonus: three line items handled differently

Criterion Commission Allowance Bonus
Nature Variable monthly based on sales performance Fixed, paid for a job commitment Non-recurring, exceptional
Common examples Sales percentage, quota commission Housing, transport, communications Annual achievement bonus, Eid bonus
Included in actual wage Yes if of a regular nature Housing and transport yes, others vary No, as it is exceptional
Social insurance base Included when paid regularly Housing and transport included, others vary Not included in the base
Effect on end-of-service Last-year average is used Included in actual wage Not included in the calculation
Accounting treatment Variable sales expense Fixed payroll expense Non-recurring expense

This distinction is not academic, it is practical. A business paying a fixed “monthly bonus” of the same amount to every employee every month is effectively paying an “allowance” and exposes itself to higher-than-expected end-of-service claims. And a business that calls a regular commission a “bonus” to dodge social insurance contributions faces a retroactive settlement with social insurance plus penalties.

Tax and zakat impact on commissions

The tax angle has three sides:

First, Value Added Tax (VAT): internal commissions (paid to business employees) are not subject to VAT because they are part of an employment relationship. But external commissions (paid to independent agents or brokers by invoice) are subject to VAT at 15% and must be supported by a tax invoice per the e-invoicing system in Saudi Arabia. This difference costs businesses in every tax audit if not properly documented.

Second, income tax and withholding: Saudis and residents do not pay personal income tax in the Kingdom, so commissions reach the employee without local tax withholding. But if the sales agent is foreign and outside Saudi Arabia (e.g. a marketing agent in another country), Withholding Tax of 15% applies to the commission remitted, and the Saudi business must declare it to Zakat, Tax and Customs Authority (ZATCA) monthly.

Third, zakat: commissions are an operating expense deducted from revenue when computing the zakat base, so they have no direct impact on the zakat base other than through their effect on net profit.

At the accounting level, the typical commission entry:

  • Debit: sales commission expense (within selling expenses)
  • Credit: commissions payable (short-term liability)

On actual payment via WPS:

  • Debit: commissions payable
  • Credit: bank

This dual logic (accrual then payment) is essential to absorb the timing gap between closing a deal in one month and paying its commission in the next, and requires a good grasp of the double-entry rule (debit and credit).

How Qoyod helps you compute commissions and include them in the payslip

The biggest gap a mid-sized Saudi business faces is not designing the commission plan but executing it monthly without errors. Three separate teams work on the plan: sales closes deals, accounting collects invoices, and HR runs the payslip. Any delay or mistake in one hand disrupts the whole cycle.

Qoyod merges these three layers into a single system:

The sales module in Qoyod accounting lets you issue invoices under a rep’s name, so every sale is tagged with its source. On collection, the invoice status changes automatically from “invoiced” to “collected”, and the per-rep sales report updates accordingly.

The reporting module produces the monthly commission report per rep with the breakdown of invoices, returns, and collected amounts, per the approved commission plan. The sales manager reviews, the accounting manager approves, and the result is exported directly to the payroll module.

The payroll module receives the approved commission and includes it in the monthly payslip alongside base salary, allowances, social insurance accrual (computing 9.75% on the total due including commission), and any deductions. It then generates the monthly Wage Protection System (WPS) file ready to upload to the bank portal.

The e-invoicing module integrated with ZATCA Phase 2 ensures every invoice tagged to a rep is fully documented for tax, so no deal is missed from the commission base.

At the integrations layer, Qoyod connects to common CRM systems via application programming interfaces (APIs), so the deal moves from CRM to invoice in Qoyod automatically, and collection moves from Qoyod back to CRM to close the follow-up loop. This integration removes manual entry and turns the commission report from a monthly manual exercise into a real-time snapshot.

FAQs about the sales commission template

Does commission count in the end-of-service benefit calculation?

Yes, if the commission is of a regular and ongoing nature. The standard practice in the Saudi market is to take the average monthly commission of the last twelve months and add it to the base salary and fixed allowances to form the “actual wage” used for end-of-service benefit. For more detail, see our full guide on end-of-service benefit calculation.

Can commission be paid in cash outside the Wage Protection System file?

No. All recurring cash entitlements (salary, allowances, regular commissions) must go through the bank WPS file. Paying commission in cash or by a separate transfer exposes the business to a regulatory violation and penalties can extend to suspension of Ministry of Human Resources and Social Development services.

What is a reasonable commission rate in the Saudi market?

It varies by sector. In luxury car showrooms it may be 1-2% of the sale value. In SaaS it can reach 8-10% of the annual subscription value. In real estate 1.5-2.5% of the deal value. Practical rule: use 15-25% of the deal’s gross profit as the ceiling, then derive the revenue percentage accordingly.

Do I need to sign an addendum to the employment contract for every change to the commission plan?

Yes, especially if the change reduces the rate or raises the quota. Unsigned changes count as a material modification to the employment contract and open the door to labor claims. Good practice: 30 days’ notice before any change plus a signed formal addendum.

How do I handle deals shared by more than one rep?

Best practice is to define an “Account Owner” in the customer contract who earns the primary rate, with a secondary share for the other roles (lead generation 10-15%, manager 10%, technical specialist 5%). Documenting this split in the CRM before deal close prevents disputes.

Are external agent commissions subject to VAT?

Yes. If the agent is outside an employment relationship (independent with an invoice), VAT at 15% applies on the commission value. An agent registered with ZATCA issues a tax invoice, and the business reclaims the tax as input VAT. Internal employee commissions are not subject to VAT because they fall under an employment contract, not a service contract.

How do I protect the business from “commission manipulation” by a rep through fake deals?

Three mechanisms work together: a Clawback clause to reclaim commission on any deal cancelled within 90 days, tying commission to actual collection rather than invoicing alone, and periodic review of large deals by the sales manager before approval.

Conclusion: from commission plan to competitive advantage

A sales commission model is not a side Excel sheet in an HR drawer. It is a full system linking the business’s strategic goal (revenue growth with profitability) with the daily behavior of the sales team. Businesses that succeed here combine a written and signed plan, error-free automated calculation, integration with a unified accounting system, and full compliance with the Saudi Labor Law, social insurance, and the Wage Protection System.

The template attached on this page is ready for a Saudi business with 5-50 employees, adjustable to your activity (retail, services, real estate, SaaS, distribution). Run it directly inside Qoyod to merge the commission plan with invoicing, collection, payroll, and the WPS file into a single monthly cycle that needs no re-entry and no guessing.

Fill in your information to download the template.

من النموذج إلى الدفاتر بدون عناء

قيود يسجّل ويصنّف ويُطابق العمليات في دفاترك تلقائيًا

جرّب قيود مجانًا لمدة 14 يومًا — بدون بطاقة ائتمان.

From template to ledger — effortless

Qoyod automatically records, classifies, and reconciles your transactions.

Try Qoyod free for 14 days — no credit card required.