Mid-quarter AE departures and starts go wrong when you round to the quarter, so count each rep by the days they actually worked.
The two errors are treating a mid-quarter departure as a full-quarter zero (or keeping the rep on through quarter end) and treating a mid-quarter start as a full-quarter headcount (or skipping them entirely).
Key takeaways
- Use effective-dated rows: end a departing AE's capacity on their last day, start a new or promoted rep's capacity on their actual start or role-change date.
- Split the quarter into day count before and after the change, apply the rep's quota attainment to the days worked, and add remaining days at zero for that seat. The result is a fractional effective AE equivalent.
- Sum days on roster (not heads at quarter end), convert to a fraction of the quarter, apply expected attainment, and compare the summed effective AE equivalent to target.
- Account for the roughly 90-day hiring lag: requisitions must open about 90 days before the target start, aligned to quarter-start cadence, so a mid-quarter loss means the replacement arrives in a later cohort.
- Check the roster row by row for any date that lands on a quarter boundary by coincidence, and confirm modeled production still lines up against target after the date fixes.
The two mistakes, plainly
You are sitting down for the coverage review. One AE quit on August 15. Another starts on August 1 from an SDR promotion. That is where the first error lives.
CaptivateIQ puts it directly: if an AE leaves on August 15, removing that rep from all of Q3 understates capacity before the departure, but keeping the rep through September overstates it afterward. That is error number one. You have a choice, and both choices are wrong if you treat the quarter as all-or-nothing.
Error number two is the mirror image. A new AE starts mid-quarter, and you either book them for the full quarter from their start date or you skip them entirely until the next clean quarter. Both flatten the same thing: the actual calendar days each rep is working.
These two errors compound. Understate before a departure, overstate after it, then round the new hire up to a full quarter. Your modeled production number drifts away from what the team can actually cover, and by the time the shortfall shows up in bookings, the quarter is already over.
This post walks through both errors, shows how to count partial quarters honestly, and gives you a checklist for the coverage review.
Error one: treating a mid-quarter departure as a full-quarter zero
Sales productivity, as Xactly defines it, is how efficiently a sales team turns its time and resources into sales results. A rep who works eight weeks of a thirteen-week quarter is turning time into results for eight weeks, not zero and not thirteen.
When you remove a departing AE from the whole quarter, you tell your forecast that the deals in their name will never close. But those deals were live pipeline for most of the quarter. The rep was working them. Renewals were in motion. Pipeline coverage looked fine until the last two weeks.
The opposite mistake is worse for credibility. Keeping the rep on the roster through September when they left in mid-August means you show capacity that did not exist. When actuals come in short, the first question from the CRO is why the plan showed a headcount that was never real.
Both errors share a root cause. The roster is a snapshot of "who is here right now," not a time-aware record of who was here when. A snapshot cannot answer a mid-quarter question. It can only answer a start-of-quarter question.
The fix is effective-dating. Roster worksheets were introduced as objects in Planning in the February 2026 product update, so teams can add, update, and remove reps using effective-dated rows, tying changes to when they take effect instead of just maintaining the latest roster snapshot. That is the mechanism that lets you say "this rep's capacity ends August 15" without editing history or lying about the future.
In practice, the effective-dated row means your Q3 capacity line is not one number. It is a weighted blend. The rep contributes to Q3 for the portion of the quarter before their last day, then contributes nothing after. The math is simple. The discipline is in entering the actual date, not a quarter boundary.
If your planning tool does not support effective-dated rows, you can still do this by hand. Split the quarter into the day count before and after the departure. Apply the rep's quota attainment to the days they worked. Add the remaining days at zero for that seat. The result will be a fractional AE equivalent, and that is correct.
Error two: treating a mid-quarter start as a full-quarter headcount
The second error is the mirror image. But ramping matters. The rep needs territory, pipeline, and first meetings. The first weeks of a new AE seat do not produce at the same rate as an established rep. For ramp inputs, see New AE ramp rates.
CaptivateIQ is explicit about role changes: when an SDR becomes an AE, update the rep's role and capacity assumptions as of that date. The date is the trigger. Not the quarter boundary, not the review cycle. For how plan changes shift quota timing, see quota and plan changes.
The other direction of this error is skipping the new hire entirely until the next quarter. If the AE starts on July 1, that is the first day of the quarter. But if the start slips to mid-quarter, skipping them means you understate capacity for the days they were working.
Quarters are convenient for reporting. They are terrible for capacity math when people join and leave on real dates.
Here is the side-by-side view of what each error does to your number.
| Situation | Full-quarter error | Effective-dated fix |
|---|---|---|
| AE leaves August 15 | Remove from all of Q3, or keep through September | End capacity August 15 |
| Planned April 1 start slips to May 15 | Keep April 1, or push to Q3 | Start capacity May 15 |
| AE moves into management in August | Leave on roster through year-end | End AE capacity at move date |
The pattern in every row is the same. The bad option rounds to a boundary. The good option honors the real date.
Why the rounding compounds
One mid-quarter change is a rounding error you can explain in the room. Two or three, across a team, start to move the number in a way you cannot explain away.
Consider a planning year with staggered starts. CaptivateIQ's headcount guide models a team that averages roughly 31.5 effective AE equivalents across the four quarters. That average is not the same as the roster count at any single point. It is the time-weighted reality of who was actually selling.
The margin between model and target is thin. A few reps rounded the wrong way can erase it.
That is why mid-quarter changes are not a bookkeeping detail. They are the difference between a plan that holds and a plan that misses. The effective AE equivalent is the unit that survives contact with a real calendar.
Another compounding factor is the hiring lag. CaptivateIQ notes a 90-day hiring lag: requisitions for two AEs starting April 1 need to open around January 1. If a departure happens mid-quarter, your replacement does not arrive mid-quarter. The gap between exit and start is where capacity really breaks.
The requisition timing follows the same pattern across the year. Requisitions for the July 1 starts need to open around April 1, and those for the October 1 starts need to open around July 1. If you lose an AE on August 15, the earliest realistic replacement start aligned to that cadence is the October 1 cohort, and that requisition should already be open.
That is a real planning consequence of error one. If you kept the departing AE on the roster through September, you never opened the requisition in time. The understatement was uncomfortable but honest. The overstatement was comfortable and wrong, and it cost you a quarter of coverage.
Planned starts slip too. A planned April 1 start may push to May 15, or an AE may move into management in August. Both are mid-quarter events. Both break a snapshot roster. Both require an effective-dated row to model correctly.
How to run the coverage review without the two errors
Start with the roster as effective-dated rows, not a snapshot. A rep still employed has no end date. A departing rep has their last day. A promoted SDR has a role change date.
Convert days to a fraction of the quarter. That fraction is the weight you apply to that rep's quota contribution.
Then, apply expected attainment to the weighted quota. The result is a fractional effective AE equivalent for the quarter. Sum across the roster. Compare the sum to your target.
Run the same math for the next quarter with the same rows. The departing AE contributes nothing. The new hire contributes from their start date. The promoted SDR contributes at AE capacity from their role change date.
The review conversation then becomes about dates, not about whose number is right. You are no longer arguing about whether a rep "counts." You are agreeing on when they were here and what they were doing while they were.
Illustrative example: one AE leaves after 40 days
Take a quarter of 90 days. An AE works the first 40 of them, then leaves. Multiply the share of the quarter they worked by their expected attainment of 85%, then count the rest of the quarter at zero for that seat. The result is a fraction of one effective AE equivalent, not a full seat. Enter the real last day, and the fraction follows from the dates.
The checklist for the coverage review
Check every mid-quarter departure. Confirm the last day is entered as an effective-dated end, not a quarter boundary.
Check every mid-quarter start. Confirm the start date drives capacity, not the quarter start.
Check every role change. A promotion or transfer changes capacity assumptions from the change date forward.
Check requisition timing. Open the requisition roughly 90 days before the target start. Align to the quarter-start cadence your team already runs.
Check for slipped starts. If a planned start moves, update the effective date. Do not leave the old date on the roster.
Check the modeled production against target. Confirm the effective AE equivalent and the dollar figure still line up after the date fixes.
Check that nobody rounded to a quarter. Walk the roster row by row. If any date is a quarter boundary by coincidence, ask whether it is real.
Next step today: open the roster, find any AE who left mid-quarter and the newest starter, and enter their real end or start dates as effective-dated rows. For the wider review, see AE capacity planning checks.
Related guides: Maine rep departure pay: 3 amounts to check.
FAQ
What is an effective AE equivalent? It is a rep's contribution to a quarter, weighted by the days they actually worked in that role during the quarter. A rep present the whole quarter is one. A rep present half the quarter is half. The concept lets you average across a year, as in the roughly 31.5 effective AE equivalents in the headcount guide, and compare quarters that had different comings and goings.
Why not just use the headcount at the end of each quarter? Because a snapshot cannot see a mid-August departure or a mid-quarter start. The end-of-quarter headcount answers a different question than the one your forecast depends on. Your forecast needs capacity over time, and capacity over time is a function of dates.
How does the hiring lag interact with a mid-quarter loss? The lag means the replacement is not immediate. Requisitions for two AEs starting April 1 need to open around January 1, so a departure in one quarter does not produce coverage in that same quarter. The gap between exit and the next aligned start is where the plan is most exposed. If your plan assumed same-quarter replacement, that assumption is the error, not the departure.
Does this change how I set quota? It changes how you model coverage against quota, not how you set an individual rep's quota. The quota is annual and per seat. The capacity math decides how much of that quota is actually in play during a given quarter. Keep those two separate in the review.
If the checklist items above all check out, both errors are out of your model.
To check a quota against what your reps can carry each quarter, the Quota Forecast Quarter Shape Workbook has a team capacity sheet that counts each rep's start date, ramp time and share of quota hit, and splits the yearly number by quarter and month.