Enter Sales Inputs
Use the form below to estimate current pace, target attainment, and forward run rate.
Example Data Table
Use this example to understand how pace and attainment can change across different selling conditions.
| Scenario | Adjusted Bookings | Elapsed Days | Total Days | Projected Period | Period Target | Attainment |
|---|---|---|---|---|---|---|
| Mid-month steady pace | $312,930.00 | 18 | 30 | $521,550.00 | $420,000.00 | 124.18% |
| Slow start recovery | $145,000.00 | 12 | 30 | $362,500.00 | $420,000.00 | 86.31% |
| Quarter-end acceleration | $680,000.00 | 22 | 30 | $927,272.73 | $780,000.00 | 118.88% |
| Conservative weighted view | $250,000.00 | 15 | 30 | $500,000.00 | $550,000.00 | 90.91% |
Formula Used
The calculator combines gross bookings, deductions, and forecast modifiers to estimate current and projected pace.
Core formulas
- Gross Bookings = New Bookings + Expansion Bookings + Renewal Bookings + Backlog Converted
- Net Bookings = Gross Bookings − Cancellations / Credits
- Adjusted Bookings = Net Bookings × (Confidence Factor ÷ 100) × (Seasonality Factor ÷ 100)
- Daily Pace = Adjusted Bookings ÷ Elapsed Days
- Projected Period Run Rate = Daily Pace × Total Days in Period
- Projected Annual Run Rate = Daily Pace × 365
- Projected Period Attainment = (Projected Period Run Rate ÷ Period Target) × 100
- Required Daily Pace = (Period Target − Adjusted Bookings) ÷ Remaining Days
- Deals Needed = Remaining Target Gap ÷ Average Deal Size
Confidence and seasonality make the calculator more practical for real sales forecasting. They let you discount uncertain deal quality or amplify periods that historically close stronger.
How to Use This Calculator
- Enter all bookings already closed in the current period.
- Add expansion, renewals, and any backlog that converted.
- Enter cancellations or credits that should reduce reported bookings.
- Set confidence and seasonality percentages to reflect forecast quality.
- Provide elapsed days and total days for the current reporting window.
- Add your period target, annual target, average deal size, and rep count.
- Press Calculate Bookings Run Rate to display results above the form.
- Review projected pace, attainment, target gap, and the Plotly trend graph.
- Use the CSV and PDF buttons to export the calculated summary.
Frequently Asked Questions
1) What is a bookings run rate?
A bookings run rate estimates how much total business you may book by period end if the current pace continues. It turns partial-period results into a projected full-period outcome.
2) Why include renewals and expansions?
Many sales teams report total bookings, not only new logos. Including renewals and expansions creates a fuller view of the revenue commitment pace entering the business.
3) Why subtract cancellations or credits?
Cancellations, downward amendments, or credit adjustments reduce the true booked value. Subtracting them avoids inflated run rate projections and improves management reporting accuracy.
4) What does the confidence factor do?
The confidence factor discounts or preserves current bookings before projection. Teams use it when some recorded value is softer, conditional, or likely to slip from the current forecast view.
5) Why use a seasonality factor?
Seasonality adjusts pace for known selling patterns. For example, quarter-end or year-end periods may close faster than average, while vacation-heavy months may close more slowly.
6) Is annualized run rate always reliable?
No. Annualized run rate is useful for quick directional planning, but it assumes the current pace stays consistent. Sudden pipeline shifts, market changes, or large one-off deals can distort it.
7) How should I use average deal size?
Average deal size helps estimate how many additional deals are required to close the remaining target gap. It is most useful when deal values are reasonably consistent.
8) Can this calculator work for monthly or quarterly planning?
Yes. The calculator is period-agnostic. Just set elapsed days, total days, and the matching target for whichever reporting cycle your sales team follows.