Sales and invoicing

Sales reps and commission

Credit each sale to a salesperson, work out what they earned, and pay them.

The one thing to understand first

Commission is earned when the invoice is PAID, not when it is raised.

A sale in March that the customer settles in June earns commission in June. That is deliberate — you never pay commission on money you haven't collected — but it means the commission figures will not match the sales reports for the same month. If someone asks why, this is why.

A half-paid invoice earns half the commission. An invoice that is never paid earns nothing.

Before you start

  • Create at least one commission plan with a rate.
  • Create your sales reps and put each on a plan.
  • To pay a rep through the system, link them to a vendor. Their commission then becomes a bill you settle in Pay Bills like any other.

Steps — setting up

  1. Sales → Commission Plans → New plan. Give it a name and a default rate.
  2. Add specific rates if some products pay differently. Rates apply most-specific-first: a rate on an item beats a rate on a category, which beats the plan default.
  3. Sales → Sales Reps → New rep. Enter their name, pick their plan, and pick the vendor they should be paid as.
  4. On each invoice, choose the Sales Rep who made the sale.

Steps — running commission

  1. Go to Sales → Commission Run.
  2. Pick the month. It opens on last month, which is usually what you want.
  3. Check the preview. Each row shows what was collected, what the commission was calculated on, and the net after any clawback.
  4. Expand a row to see lines that earned nothing, and why.
  5. Tick the reps you want, or leave everything unticked to post them all.
  6. Click Post. This raises one bill per rep.
  7. Pay them in Purchases → Pay Bills, like any other bill.

Revenue or margin?

Your system is set to calculate commission on one of two things:

  • Revenue — the sale value. Simple, and everyone understands it.
  • Margin — sale value minus what the goods cost you. Stops reps discounting away your profit to win a sale.

A plan can override the company-wide setting, so you can put agents on margin and in-house staff on revenue.

Under Margin, lines with no stock cost earn nothing — services, delivery charges and fees. That's on purpose: they have no cost, so treating them as pure profit would pay commission at 100% margin.

Returns and clawback

If a customer returns goods, the commission on them is reversed automatically at the next run, in proportion to what came back. Return half, lose half.

The reversal is recorded as a separate negative line, never by editing the original — so the statement always shows both what was earned and what came back.

If a rep's clawback exceeds what they earned that month, the run will not post them. That negative carries into the next period.

Tips

  • A rep with no plan earns nothing. This is deliberate so commission is never paid by accident.
  • A rep with no vendor still shows their earnings, but can't be posted. Use this for staff paid through payroll.
  • The run tells you how much was collected on invoices with no rep — worth checking if it looks high, as it means sales aren't being credited.
  • Use each rep's Statement to answer "why is my commission low this month?" It lists every invoice behind the number.
  • Export the run to Excel before posting if you need a manager's sign-off.

Common problems

  • "Nothing earned in this period." → Either nothing was collected against that rep's invoices, or their invoices have no rep set. Check the unattributed figure at the top.
  • A big sale is missing. → The customer probably hasn't paid yet. Commission follows the money.
  • "No vendor is linked to this rep." → Add a vendor on the rep, or accept that they're paid outside the system.
  • Everything shows zero under Margin. → Your sales may not be posting stock costs — usually because invoices have no delivering department set. Switch to Revenue or fix the invoices.
  • "Already posted for this period." → That rep has been paid for that month. A period can only be posted once, so it can't double-pay.
  • The totals don't match my sales report. → Expected. Sales reports count sales made; commission counts money collected.

See it working on your own business

Start a 45-day free trial — no card needed — and follow this guide in your own practice company.