Sales Commission Tracking for Agencies: How to Pay Reps on Retainers Without a Spreadsheet

Pay commission when the invoice is marked paid, not when it is issued. That one rule removes most of the mess agency owners create for themselves with commissions — the clawbacks, the arguments, the month where you paid a rep on revenue the client never sent. Everything else in a commission plan is downstream of it.

This guide sets the rules an agency commission plan needs, then shows how to run them in sales commission tracking software for agencies instead of a spreadsheet you rebuild every month.

Published September 2026 · competitor pricing reviewed quarterly by the Wieldy team · next review December 2026

Why agency commissions break in a spreadsheet

A retainer sold in March is still generating commission in February. That is the whole problem. Enterprise sales commission tools assume a deal closes once and pays once. Agency revenue is a subscription with a sales rep attached, so the spreadsheet is never "filled in" — it is rebuilt every month, with last month's live retainers copied forward, churned ones deleted, scope changes typed in by hand.

Four things break, every time:

1. Commission paid on invoiced revenue the client never paid. The sheet is built from invoices issued. Accounts receivable is a separate tab, if it exists at all.
2. Media spend counted as commissionable revenue. The agency passes through the ad budget and keeps a management fee, but the invoice total is what lands in the sheet.
3. Tier thresholds recalculated by hand. A rep crosses a band mid-month and someone has to decide — and then defend — whether the earlier dollars re-rate.
4. Nobody can answer "what am I owed?" without asking the owner. The owner becomes the reporting layer, which means commission questions arrive on a Friday afternoon.

The cost is cash, not admin time. For illustration: a rep on 10% of a $6,000/month retainer, where the client stops paying for two months, produces $1,200 of commission paid against $0 collected. Two reps, two slow clients, and you have funded someone else's cash flow problem out of your own bank account.

The six decisions to make before you pick any software

Software cannot decide these for you. Write the answers down before you look at a single demo.

Do you pay on invoiced revenue or collected revenue?

Two options. Invoiced: commission is earned when you send the invoice. Collected: commission is earned when the payment is recorded against the invoice. Invoiced pays reps faster and feels generous, but it makes you the bank, and it forces you to build a clawback process for every non-payer. Collected ties the rep's income to the thing you actually care about — cash in the account — and it quietly makes reps chase their own slow payers.

Recommendation: pay on collected. It removes the clawback problem almost entirely, because you never pay out on money you have not banked. See also getting clients to pay on time.

Is the commissionable base gross revenue, fee only, or gross profit?

This is the media-buying trap. For illustration: a client sends $57,500. Of that, $50,000 is Meta Ads and Google Ads spend passed straight through to the platforms, and the agency keeps a 15% management fee of $7,500. If the rep is on 10% of "revenue", gross revenue pays $5,750 on $7,500 of actual agency income. That is 77% of the fee, gone.

The commissionable base is $7,500, not $57,500. Three sane options: fee only (simplest, recommended for agencies with pass-through spend), gross profit (fee minus direct delivery cost — fairer, but only if you track cost per account reliably), or gross revenue (only defensible when nothing passes through). More on the mechanics in re-billing ad spend to clients: the agency media buying reconciliation playbook.

One-off payout or recurring for the life of the retainer?

One-off: a single payout, often 1x or 2x the monthly fee, when the deal closes. Recurring: a smaller percentage every month the retainer is collected. One-off keeps reps hunting and keeps your cost of sale fixed and forecastable. Recurring gives the rep a reason to care about renewal and scope growth, and it aligns payout with MRR that actually arrives.

Recommendation for most agencies: recurring, at a lower rate, with a cap or step-down after month 12. Pure one-off makes the rep indifferent to a client who churns in month three. Pure perpetual recurring builds an annuity the rep can live on without selling again.

Flat rate or tiered — and are tiers retroactive or marginal?

Retroactive tiers re-rate every dollar once the rep crosses the threshold. Marginal tiers apply the higher rate only to the dollars above it. Same numbers, very different cheque.

For illustration, a rep at $60,000 of commissionable bookings, with 5% to $50,000 and 8% above:

• Marginal: (50,000 × 5%) + (10,000 × 8%) = $2,500 + $800 = $3,300
• Retroactive: 60,000 × 8% = $4,800

A $1,500 difference on one rep, from wording alone. Retroactive creates a strong sprint at the threshold and a cliff in your cost model; marginal is smoother and easier to fund. Whichever you pick, write the word "marginal" or "retroactive" into the plan you and the rep both sign. Read the agency sales commission plan: a template built for retainers, not one-off deals, then model your own bands in the free tiered sales commission calculator.

When does a clawback apply?

Rule of thumb: if you pay on collected cash, you do not need clawbacks. The money was banked; there is nothing to take back except in the case of a refund or chargeback, which you should name as the only two triggers.

If you pay on invoiced revenue, you need a written window — for illustration, commission is reversed if an invoice is still unpaid 90 days after issue, deducted from the next commission run rather than invoiced back to the rep. Put the window, the deduction mechanism and the refund clause in the signed plan. Undocumented clawbacks are how you lose a good rep.

Who owns the account after the sale — the rep or the account manager?

Rep owns it: they keep the trail for the life of the retainer, which motivates renewal but pays a hunter for farming. Account manager owns it after handover: the rep gets a larger front-loaded payout, the AM gets a growth or retention share on upsells. Split: rep keeps a reduced trail for 12 months, then it transfers.

Recommendation: split, with a stated handover date. It pays for the work each person is actually doing and stops the rep's trail becoming a permanent tax on accounts they no longer touch.

Three commission structures that work for agencies (worked examples)

All figures below are illustrative. They are not Wieldy customer data and not industry averages — they are worked examples to show the shape of each structure.

Structure 1: flat percentage of collected fee, paid monthly for the life of the retainer

Suits agencies with long retainers and low churn, where the rep genuinely stays involved. Failure mode: annuity reps. By month 18 the trail covers their bills and new business slows. Cap the trail or step it down at month 12.

Structure 2: tiered on rolling 12-month bookings, paid on collection

Suits a team of three or more reps where you want stretch behaviour near the threshold. Failure mode: month-end gaming — reps push clients to pay early or hold deals back to land in a better period. Use a rolling 12-month window rather than a calendar quarter to blunt it.

Structure 3: front-loaded — higher rate for months 1-3, lower trail after

Suits agencies that need new logos fast and accept a lower trail. Failure mode: churn. The rep has banked most of the value by month four and has little reason to defend the account. Pair it with a retention bonus at month 12, or hand the account to an AM with a growth share.

What commission tracking software actually has to do

Take this list to any vendor, Wieldy included, and ask them to show it on screen.

1. Commission triggers on the invoice payment status, not the deal stage. A deal marked "closed won" is not cash; a paid invoice is.
2. Tier bands configurable per rep and per period. Your senior rep and your new hire will not be on the same plan, and plans change in January.
3. Marginal and retroactive tiers both supported. If the tool only does one, it decides your comp plan for you.
4. Pass-through media spend separated from commissionable fee. Otherwise every media-buying client overpays commission by design.
5. Recurring recognition across the life of a retainer. Commission has to regenerate each month the retainer collects, without anyone re-entering the deal.
6. A rep-visible statement. If the owner has to send it, the owner is the reporting layer and nothing has been automated.
7. Role-based access. Reps see their own numbers, not each other's. This is not optional in a small team.
8. An export the bookkeeper can reconcile against payroll. CSV that lines up with the invoices it came from.
9. An audit trail on rate and tier changes. When a rate changed mid-period, you need to know who changed it and when — that is the conversation that ends badly without a log.
10. Handling for refunds, credit notes and partial payments. Real invoices get paid in halves.

Now the honest constraint. Tools in this space sit on one side of a line. Dedicated commission platforms — QuotaPath, Spiff, CaptivateIQ, Everstage — do the maths very well, but they sit outside the system holding your invoices, so they need a data pipe from your billing or accounting stack, and someone has to own that pipe. Agency management platforms hold the invoices, but commission handling varies a lot between them and is often a report or a manual line rather than an automatic calculation.

So ask every vendor one question: does commission status change automatically when an invoice is marked paid — and if not, who updates it? If the answer is "you can export it and calculate it", you have bought a nicer spreadsheet. Where a vendor's site does not make it clear, do not assume — check with them directly.

How Wieldy handles agency sales commissions

Wieldy is agency management software built by Zerak, and commissions run in the same order the money does.

The rep closes the deal in the sales CRM and lead pipeline (web forms and WhatsApp). The retainer and its invoices live on the client record. The client pays by card through Stripe and the payment is recorded against the invoice automatically; cash and bank transfers are recorded manually. Tiered commission is then calculated against paid invoices — not issued ones — so the payout only exists once the cash exists. Each rep sees their own statement under role-based access, without asking you. The whole thing exports to CSV for payroll and the accountant, alongside payroll and HR records held in the same workspace.

For media buyers, the link matters: media-buying money flow and reconciliation tracks pass-through Meta Ads and Google Ads spend separately from the agency's fee, so the commissionable base is the fee, not the client's budget. That feature sits on Pro, not Growth.

Plan availability, stated plainly. Tiered sales commissions, the sales CRM and lead pipeline, invoicing with online card payments, e-signatures and payroll/HR records are included from Growth — $59/month at launch pricing (regular $99), 6 seats, flat per workspace, no per-client fees. Media-buying money flow, the branded client portal with approvals, live ads sync, automated client reports and the public API are Pro — $105/month at launch pricing (regular $175), 15 seats.

The built-in AI assistant answers questions against your live data, so "what does each rep earn this month on collected invoices" is a question you type, not a report you build.

How much does agency commission tracking cost compared with per-seat tools?

At a stated team size of 10 people:

Prices as listed on each vendor's pricing page in September 2026 and subject to change. Commission handling varies between these platforms — ask each vendor directly whether commission recalculates when an invoice is marked paid.

Honest caveat: a per-seat tool on an entry tier can be cheaper for a three-person agency. The flat price wins as the team grows — at 15 seats Wieldy Pro is still $105/month, while a $25/user tool would run to $375.

Set your plan up in an afternoon

1. Pick the commissionable base and write it down. Fee only, gross profit or gross revenue — one sentence, in the plan document. If you buy media, it is almost certainly fee only.
2. Choose collected cash as the trigger. Commission is earned when the invoice is marked paid. Say it in those words.
3. Set the tiers, and state marginal or retroactive. Do not leave it to interpretation. If you are still setting retainer prices, how to price agency retainers: the capacity and margin math and the retainer pricing calculator come first — commission rates only make sense against a margin you know.
4. Run the last three months of paid invoices through the free tiered sales commission calculator. You are sanity-checking what you would have paid under the new plan versus what you did pay. If the new plan costs 40% more, find out now. Cross-check the margin impact in the agency profit calculator.
5. Put the plan in writing and have every rep sign it. E-signatures are built into Wieldy, so the signed plan sits on the personnel record rather than in an inbox.
6. Run one month in parallel with the spreadsheet before switching it off. Two sets of numbers for one month is cheap insurance against a rate you configured wrong.

On historic data: start from the free trial or the live demo, and talk to the team about moving your existing data before you commit to a cutover date.

Frequently asked questions

Should agency sales commissions be paid on invoiced revenue or on money actually collected?

Collected. Paying on invoiced revenue means you fund commission out of your own cash while the client is still late, and it forces you to build a clawback process. Paying when the invoice is marked paid ties the rep's income to cash in the bank and gives them a reason to chase their own slow payers.

Do you pay commission on the full retainer or only on the agency's fee when media spend is passed through?

The fee. For illustration, if a client sends $57,500 and $50,000 goes straight to Meta Ads and Google Ads, your commissionable base is the $7,500 management fee. Paying 10% on the invoice total would hand over $5,750 of a $7,500 income. Define the base as "fee only" in writing.

How do tiered sales commissions work — are the tiers retroactive or marginal?

Either, depending on how you write it. Marginal applies the higher rate only to dollars above the threshold. Retroactive re-rates everything once the rep crosses it. On $60,000 with 5% to $50,000 and 8% above, marginal pays $3,300 and retroactive pays $4,800 — for illustration. Name the method in the plan.

Should a rep keep earning commission every month a retainer renews, or only on the first month?

Most agencies do better with a recurring trail at a lower rate, stepped down or capped after month 12. A one-off payout makes the rep indifferent to a client who churns in month three. A permanent trail creates an annuity that dulls hunting. A 12-month trail with handover to the account manager balances both.

When should an agency apply a commission clawback?

Rarely, if you pay on collected cash — the only triggers should be refunds and chargebacks. If you pay on invoiced revenue you need a written window: for illustration, commission reverses if an invoice is unpaid 90 days after issue, deducted from the next run. Unwritten clawbacks cost you reps.

Does Wieldy replace a dedicated commission platform like QuotaPath or Spiff?

For a 5–50 person agency, usually yes — because Wieldy already holds the invoices, so commission recalculates when a payment is recorded, with no data pipe to maintain. Dedicated platforms are built for large enterprise sales orgs with complex quota structures. Tiered commissions are included from Growth at $59/month; 7-day free trial, no credit card, 14 days through a partner link, month-to-month.

Try it on your own numbers

Open the live demo workspace with sample agency data from wieldyapp.com — email only, no account needed — and look at how a paid invoice moves a rep's commission statement. Then start the 7-day free trial on your own data: no credit card, month-to-month, cancel anytime (14 days through a partner link).

Launch pricing is 40% off regular and locked for as long as the subscription stays active. The offer ends 18 October 2026.

Written by Ed Kamel, founder of Zerak and Wieldy. Wieldy began as the internal system of the marketing agency he runs, so he writes from paying retainer commissions and reconciling media spend himself. Competitor pricing reviewed quarterly by the Wieldy team · next review December 2026.