Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Problem solved

Sales Commission Calculation Errors Fix: Pay the Right Person the Right Amount

For sales heads, finance teams and business owners who pay commission to salespeople or channel partners: end the monthly disputes and pay from a record everyone can check.

Two salespeople with sheets beside a sample tile in a tile showroom

A sales commission calculation errors fix has to start with the base. Most wrong payouts come from commission worked out on the wrong invoices: cancelled ones, unposted ones, returned goods, or the same invoice counted for two people at full value.

In many Indian businesses the commission sheet is built at month end from a sales export. Rates sit in one tab, splits are agreed on calls, and returns from last month are forgotten. Every payout is followed by a week of arguments.

This page lists the usual errors, how to check them, an illustrative example, and how Apragya keeps commission as a ledger against invoices.

The common commission errors, and the fix for each

Six errors cause most disputes: commission on unposted or cancelled invoices; commission not reversed on returns or credit notes; shared sales counted at full value for both people; old rates applied after a change; a base that mixes taxable value and invoice total; and entries paid twice because paid status lives in another file.

Check each by listing the month's commission against invoice numbers, and matching every return to the invoice it reverses. Any entry without a posted invoice behind it is a mistake.

The fix is a written policy on the base and the splits, and a commission ledger with one entry per person per invoice, cancelled when the sale is reversed.

Decide the timing too. Some businesses pay when the invoice is raised, others only when the customer pays. Either works if it is written down and applied the same way every month, with any clawback on unpaid or returned sales stated in the policy.

  1. List commission by invoice number.
  2. Drop entries on unposted or cancelled invoices.
  3. Reverse entries for returned goods.
  4. Check shared sales add up to one hundred per cent.
  5. Mark paid entries in the same record.

What commission errors cost

Overpayment

Commission paid on returned or cancelled sales is rarely recovered.

Lost trust

Salespeople who are underpaid stop believing the numbers.

Finance time

Each payout cycle turns into a week of checking.

Partner disputes

Channel partners question every statement.

An example: a building materials distributor in Jaipur

Take an illustrative distributor of tiles and sanitaryware with eight salespeople and three dealer partners. Large orders were often shared between two salespeople, and returns were common.

One shared order, from invoice to payout

  1. Invoice posted

    Only a posted, submitted invoice earns commission.

  2. Credit split

    Sixty and forty per cent between two salespeople.

  3. Commission accrued

    Each person's rate applied to their share.

  4. Return received

    Part of the order came back the next week.

  5. Payout

    Only entries still accrued are marked paid.

The return is the step month-end sheets miss, and the one that causes overpayment.

When the return was booked, the commission entries on that invoice were cancelled and accrued again on the corrected sale. The payout matched what the business had actually kept, and neither salesperson disputed it, because each could see the invoice behind every entry.

Two stacks of coins with a returned tile and a few coins set apart
The returned tile took its share of commission with it, so the payout matched the sale kept.

How commission tracking software should work, and how Apragya does it

Step 1 of 5

Rates on the person

Each salesperson and partner carries a commission rate.

  1. Rates on the person: Each salesperson and partner carries a commission rate.
  2. Splits on the invoice: Allocate credit by percentage, with an optional rate for that sale.
  3. Posted invoices only: Commission is not accrued on drafts, cancelled invoices or credit notes.
  4. Reversal on returns: Returns can cancel the commission on the original invoice.
  5. Reports by person: Accrued, paid and cancelled amounts by person, partner, territory or month.

Sales commission calculation: sheets against Apragya

A spreadsheet recalculates everything each month from an export, so a changed rate or a late return silently rewrites history. A ledger records each entry once, against one invoice, with a status.

Commission sheets, against Apragya

FeatureMonth-end sheetApragya
BaseSales exportPosted invoices
Shared salesAgreed on callsPercentage split on the invoice
ReturnsOften missedCommission cancelled on the invoice
Double countingEasyOne active entry per person per invoice
Paid or notSeparate listStatus on every entry

Checked against public information on 16 September 2026.

Fixing incentive calculation errors

  1. Write down the commission policy in one page.
  2. Set each salesperson's and partner's rate.
  3. Record credit splits on every shared invoice.
  4. Accrue commission only on posted invoices.
  5. Reverse commission when goods come back.

The first clean month usually ends the disputes that the sheet could not.

What sets Apragya apart on commissions

One sales record

Orders, invoices, returns and commission sit together.

AI you can put to work

An agent can flag unusual payouts before approval.

Partners too

Dealers and resellers earn commission on their invoices.

Territories

Read commission by territory and its sub-territories.

Permissions

Accrue, pay and reverse can each be limited by role.

Audit log

Who marked a batch as paid is recorded.

See sales invoices, sales returns and sales reports.

What it costs to start

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Sales and POS
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

Commission errors, answered

Can two salespeople share one invoice?
Yes. Credit is split by percentage on the invoice, and each person earns on their share.
What stops commission being counted twice?
Only one active entry is kept for each person on each invoice, so accruing again does not duplicate it.
What happens when goods are returned?
Commission on the original invoice can be cancelled, including automatically from the return if you choose.
Can we pay commission in batches?
Yes. Select accrued entries and mark them paid together.
What does it cost to start?
Sales and POS is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Pay commission from a record, not a sheet

Set rates, split one shared invoice and see the commission ledger fill in.