Sales Target Splitter: Turn One Annual Number into Quotas People Can Work To

Somewhere in the last quarter of the year, a founder or a sales director commits to a number. That number then has to become something a rep can act on in the second week of February. The distance between those two things is where most sales plans fall apart.

Today the split is usually done by the sales head in a spreadsheet over a weekend. The annual figure is divided by twelve, then by the number of reps, with some manual nudging for the reps everyone knows are stronger. New joiners get a full quota because reducing it feels like lowering the bar. Nobody writes down the assumptions, so when the plan misses in month three, the argument is about effort rather than about a distribution that was never realistic.

A sales target splitter's job is to make the assumptions explicit and the arithmetic reproducible, so the plan can be argued about before it is committed.

Everything below is an assumption. Writing them down is most of the value; the multiplication is trivial once they exist.

An illustrative example. The annual target is $2.4 million, the seasonality index is lower in January and rises through March, and one of the four reps starts in February on a ramp.

With an average deal size of $12,000 and a 25 per cent win rate, a $52,000 January means roughly four closed deals and sixteen qualified opportunities, which is the number a rep can actually plan a week around.

Build the plan in a spreadsheet. It is the right tool for scenario work, and no CRM will beat it for asking what happens if two reps start in May. The reason to move the result into a CRM is that the plan needs to meet reality every day.

Dividing by twelve

Almost no business sells evenly across the year. An equal split guarantees a miss in the quiet months and an unreachable catch-up later.

Ignoring ramp

Loading a full quota onto a rep in their first month makes the plan look funded and makes the forecast wrong from the start.

Splitting by headcount rather than potential

Two reps with equal numbers and unequal territories will produce one overachiever and one resignation, and neither outcome tells you anything about ability.

Stopping at the number

A quota without derived activity targets leaves reps guessing. Convert it into opportunities and meetings, and review those inputs quarterly.

Related tools and reading: the tool library, sales automation, CRM vs Excel, lead management software, CRM for small business, and pricing.