Skip down to the research record

Quota Forecast Quarter Shape Workbook

A spreadsheet that splits your yearly sales quota by quarter and month. It follows how listed US software companies bill. It checks your quota against what your reps can carry, and it paces your current quarter week by week.

$29, paid once for a single download, with no account to set up.

Get the workbook for $29

It is new this month. No sales team has run it on a live quarter yet. We recalculated every formula in LibreOffice. Each function it uses also exists in Microsoft Excel and Google Sheets. We have not opened the file in either of them.

Who it is for

Sales leaders, sales operations and finance people who set quarterly quotas. It suits anyone who doubts an even split fits their year.

Inside the download

Delivery

After payment you get a private download page. It holds your workbook, both CSV files, data dates and a help address. There is no sign-up and no later update.

Only in this workbook

  1. Team capacity lists up to 20 reps. Give each one a start date and a yearly quota. Then set how many months a new hire needs to ramp, and the share of quota each rep tends to hit. It sums what your team can carry by month and quarter. It sets that against your quota. It counts the full-speed reps any gap would need.
  2. Your history takes up to 12 quarters of past bookings. Paste them in and it finds your share for each quarter. Your shape sits beside the 2025 public share and the 2018 to 2025 middle. You can then plan a year with your own shape.
  3. Scenario compare lines up three splits for every quarter. They are an even split, a public shape and your own history. Pick any date to see what each split expects booked by then. It shows how far ahead or behind you are. Each split also gets a daily amount for every selling day left. A week-by-week table covers your current quarter.
  4. Selling days runs day by day for five years. You type its first year; it ships with 2026 to 2030. It works out eleven yearly federal holidays from federal law. Switch any holiday off, or add up to 60 days off of your own. Every month, quarter and pacing sum then follows. Those rules give the same 210 dates as OPM published for 2011 to 2030.
  5. Company quarters lists all 532 quarters behind the medians. Each one carries its SEC filing number. This site prints the medians alone.

Worked samples, line by line

Example: put your own numbers here. A team has a yearly quota of $1,200,000. It plans its year with a 2025 billings shape. By 4 November 2026 it has $100,000 booked.

On a phone, push this grid sideways to bring the Amount column into view.

Figures from Quota phasing and Pacing check sheets.
LineAmount
Yearly quota$1,200,000
First quarter$270,557
Fourth quarter$344,269
November 2026$105,502
Booked so far$100,000
Expected by 4 November 2026$133,265
Still to book this quarter$244,269
Open pipeline needed at a one-in-four win rate$977,077

Can six reps carry that quota in this example? Each rep has a yearly quota of $300,000. Each tends to reach 70% of it. A new rep takes 4 months to reach full speed. Two reps are new hires who join during 2026.

Drag this grid left to read every team amount.

Read off a Team capacity sheet.
LineAmount
4 reps at full speed all year$840,000
New hire starting 1 February 2026$166,250
New hire starting 1 June 2026$96,250
What the team can carry in 2026$1,102,500
Yearly quota$1,200,000
Gap to close$97,500
Full-speed reps that would close it1
What the team can carry in the first quarter$223,125
First-quarter quota$270,557

One fourth quarter, split three ways. Same quota, same $100,000 booked by 4 November 2026. Columns show an even split, a 2025 public shape and an own history. That last column uses rows shipped in your workbook. They hold eight quarters of billings for Tenable Holdings from its SEC filings. Type over them with your own bookings.

Slide this grid sideways to line up all three splits.

Copied from its Scenario compare sheet.
Fourth quarter of 2026Even split2025 public shapeOwn history example
Quarter quota$300,000$344,269$352,661
Expected booked by 4 November$116,129$133,265$136,514
Needed each selling day left$5,263$6,428$6,649

Samples use a 2025 middle company. It puts 22.72% of its year in quarter one. Its fourth quarter gets 28.91%. The four middle shares add up to a little more than the whole year, so the workbook scales them to exactly the whole before it splits a quota.

Nine worked cases

Each one is spelled out step by step on its Worked examples sheet.

  1. Split a new yearly quota into quarters (Quota phasing sheet).
  2. Set the billings shape against the revenue shape for the same quota (Quota phasing and Shape history sheets).
  3. Split a quarter into months that respect holidays (Quota phasing and Selling days sheets).
  4. Check mid-quarter whether a team is on pace (Pacing check sheet).
  5. Work out the open pipeline a gap needs (Pacing check sheet).
  6. Ask whether six reps, two of them new hires, can carry the year (Team capacity sheet).
  7. Set your own bookings history against the public middle company (Your history sheet).
  8. Line up three ways to split the fourth quarter on one date (Scenario compare sheet).
  9. Move the calendar to later years and switch off a holiday your team works (Selling days sheet).

2025 beside earlier years

On a phone the year columns sit past the right edge, so swipe the grid to reach them.

From US Securities and Exchange Commission (SEC), fetched 4 November 2026. Middle company's billings share by quarter, 2025 beside its lowest and highest earlier years.
Quarter2025Lowest year, 2018 to 2024Highest year, 2018 to 2024
Q122.7221.8423.2
Q224.1822.7224.31
Q324.9625.0525.69
Q428.9127.8829.7

Sources

Company figures come from SEC filings named above that table. From US Office of Personnel Management (OPM), fetched 28 October 2026. Some companies file only a yearly report. For those, quarter four is a full year less its first three. Missing deferred revenue is flagged, never guessed.

Its formulas call 21 spreadsheet functions in all, namely AND, CHOOSE, COUNT, COUNTIF, COUNTIFS, DATE, IF, IFERROR, INDEX, ISNUMBER, MATCH, MAX, MIN, MOD, MONTH, OR, ROUNDUP, SUM, SUMIFS, WEEKDAY, YEAR.

A salesman explains a new milking machine to farmers at the Vermont State Fair in Rutland.
Explaining a new milking machine at the State Fair, Rutland, Vermont, September of 1937. Arthur Rothstein took this in 1937 for the Resettlement Administration; the print is held by the Library of Congress with no known restrictions.

Send any question before buying to operations@quotaforecast.com.

Back to a free quarter-shape table