What to be able to hand over
Sales reporting depends on a consistent definition of the pipeline. Keep booked revenue separate from possible deals and make the assumptions behind weighted estimates explicit.
- A clean pipeline report
- Use stable deal IDs, agreed stages and clear ownership; check duplicated rows before totaling.
- A target-versus-actual review
- Compare the same reporting period and currency, then inspect the accounts that drive the gap.
- A scenario with stated assumptions
- Label weighted pipeline as an estimate and test how a changed win probability affects the result.
Build beyond this course
Product knowledge, customer communication, negotiation and CRM discipline matter alongside spreadsheet reporting. Compensation plans and deal-credit rules need their own careful review.
Occupational context: BLS: Wholesale and manufacturing sales representatives, except technical and scientific products. The handover examples above are our practice suggestions.
Work to practise
- Compare this period with its target and the prior period.
- Apply each commission rate only to its own band.
- Keep a summary tied to the underlying sales records.
All examples use original synthetic data. Source row numbers and column letters are shown so you can reproduce the formulas.
Explain a target report and marginal payout
A fictional rep sold USD 15,000 against a USD 12,000 target and USD 10,000 prior-period sales. Commission is 2% on the first USD 10,000 and 5% above it.
USD; target achievement and growth are ratios, displayed as percentages.
| Row | A · Measure | B · Value (USD or rate) |
|---|---|---|
| 2 | Current | 15000 |
| 3 | Target | 12000 |
| 4 | Prior | 10000 |
| 5 | Band threshold | 10000 |
| 6 | First-band rate | 0.02 |
| Row | D · Measure | E · Rate |
|---|---|---|
| 2 | Above threshold | 0.05 |
Worked solution and complete results
Target achievement · D4
=B2/B3Result: 1.25
Growth versus prior · D5
=(B2-B4)/B4Result: 0.5
Marginal commission USD · D6
=MIN(B2,B5)*B6+MAX(0,B2-B5)*E2Result: 450
A mistake to catch
Applying the top 5% rate to all USD 15,000 gives USD 750 and overstates the specified marginal payout by USD 300.
Correction. Calculate the first USD 10,000 at 2% and only the excess at 5%. Label 125% as target achievement and 50% as growth.
Read the result
The payout under this invented schedule is USD 450. It says nothing about an actual employer contract, returns, taxes or payment eligibility.
Practise the skills in order
- Tiered commission Read the guide, then open the actual lesson.
- SUMIFS Read the guide, then open the actual lesson.
- Percentage growth Read the guide, then open the actual lesson.
- Share of total Read the guide, then open the actual lesson.
- Profit margin Read the guide, then open the actual lesson.
- Pivot tables Read the guide, then open the actual lesson.
Start with percentages and IF/MIN/MAX. The schedule is an educational assumption and must be replaced by the applicable approved policy for real work.
Practice marginal commissionPay and remote work
U.S. pay reference
- Published occupation
- Wholesale and manufacturing sales representatives, except technical and scientific products
- Median annual wage
- USD 72,080
- Location and period
- United States · May 2025
This is one goods-sales occupation, not a benchmark for all sales or SaaS roles. BLS describes salary-plus-commission/bonus arrangements; this wage is not a guaranteed base salary or advertised on-target earnings.
These BLS figures cover employees across work arrangements. They are not a remote-only salary, an entry-level offer or an earnings outcome from this course. Median means half earn more and half earn less.
Source: U.S. Bureau of Labor Statistics, Occupational Outlook Handbook. Reviewed . Values are U.S. dollars; no currency conversion is applied.
Read a remote posting carefully
For an inside-sales or remote account role, check territory, customer hours and travel expectations. Compare base salary, variable commission and on-target earnings separately.
Check the allowed country or state, working hours, employment or contractor status, and the currency and components of the offer. A remote role can still have location restrictions and locally set pay.
One employer example: GitLab’s candidate handbook says to check each listing’s hiring country. Its current compensation policy uses local market data and local-currency ranges. This is an illustration of employer policy, not a claim about every remote job.
Continue in a downloadable workbook
Regional sales practice
Calculate row revenue and compare regional and channel totals from pivot-ready order records.
USD per unit and USD revenue. One fictional order per row, November 2026.
Bank version 2026-11-02. Includes Instructions, Practice, AnswerKey; 16 live answer formulas. All source records are invented for education.
The download is an additional practice task. Its Instructions sheet identifies the source coordinates; this page’s illustrative example may use different records.
- Working answers use scalar Excel 2007+ functions. No macros, external links or dynamic-array dependency. Native Excel has not been launched for verification.