Sheet template · Sales managers
Sales commission calculator
Tiered commission per rep. Made from one message, so you can get your own in minutes.
Sales commission calculator
Q2 2026 Total Sales vs Quota by Rep
| Rep | Deal | Close date | Amount | |
| Priya Raman | Corvane Logistics – annual license | 2026-04-08 | 42,000 | |
| Priya Raman | Halden Foods – seat expansion | 2026-05-06 | 28,500 | |
| Priya Raman | Tidewater Clinics – new logo | 2026-05-27 | 36,000 | |
| Priya Raman | Ostrander Group – renewal + upsell | 2026-06-18 | 31,500 | |
| Marcus Webb | Pinecrest Schools – district license | 2026-04-14 | 24,000 | |
| Marcus Webb | Bluefin Marine – new logo | 2026-05-12 | 38,000 | |
| Marcus Webb | Alder & Finch – annual license | 2026-06-03 | 19,500 | |
| Marcus Webb | Northgate Realty – seat expansion | 2026-06-24 | 22,000 |
Tiered commission per rep
The prompt
Create a Sheet commission calculator for the Mid-Market Sales team at Brightwell Software for Q2 2026 (April to June). Deals tab with rep, deal, close date and amount; a reps tab with total sales, quota, attainment % and commission using tiers of 3% below 70% attainment, 5% from 70% to 99.9%, 8% from 100% to 119.9%, and 10% at 120% and above (formulas).
Make it yours
- Change the details in the prompt to fit sales managers.
- For example, change it so that it is for a four-person SaaS renewals team in Q3 2026 and the tiers pay 2% under quota, 6% at quota and 12% above 125% attainment.
- Ask for edits in plain words: tone, colors, length, layout or data.
- Share the result by link or export it when you are done.
More sheet templates
Browse allSpending by category, Jan–Mar 2026
Category Jan Feb Mar Apr Salaries 42,000 42,000 42,000 43,500 Rent 6,000 6,000 6,000 6,000 Software 1,650 1,720 1,800 1,850 Marketing 4,200 5,600 3,900 6,100 Travel 800 1,900 1,200 650 Equipment 2,400 300 0 1,200 Total 57,050 57,520 54,900 59,300 Budget tracker
Planned vs actual spend by month
Posts by channel
Date Channel Topic Format Owner 2026-11-02 Blog Why local sourcing beats delivery apps Article Maya 2026-11-04 LinkedIn Meet the farmers: Green Valley Co-op Carousel Priya 2026-11-06 Instagram Behind the kitchen: Monday prep Reel Sam 2026-11-09 Blog How to run a lunch budget for 50 people Guide Daniel 2026-11-11 LinkedIn Customer story: Brightline Studio Post Maya 2026-11-13 Instagram Seasonal menu reveal: autumn bowls Carousel Priya 2026-11-16 Blog Zero-waste packaging, one year in Article Sam 2026-11-18 LinkedIn Office lunch survey results Infographic Daniel Content calendar
Posts planned across channels
Deals by Stage, Q2 2026
Deal Company Contact Stage Deal Value Fleet Suite Rollout Harborline Logistics Dana Whitfield Negotiation 84,000 Maintenance Module Tri-County Haulers Marcus Obi Proposal 36,000 Telematics Add-on Cedar Ridge Transit Lena Hoffmann Closed Won 42,500 Fleet Suite Bluepeak Couriers Raj Malhotra Qualified 58,000 Compliance Reporting Summit Cold Chain Elena Voss Negotiation 67,500 Fleet Suite Ironwood Materials Greg Tanaka Prospecting 120,000 Maintenance Module Pinecrest School Buses Carla Reyes Proposal 28,000 Fleet Suite Redwater Dispatch Owen Park Qualified 49,000 Sales pipeline
Deals by stage with weighted value
Line items: quantity, rate and amount (USD)
Description Quantity Rate (USD) Amount (USD) Discovery workshop and competitor audit (hours) 8 95 760 Logo design: concepts plus 2 revision rounds (hours) 24 95 2,280 Color palette and typography system (hours) 10 95 950 Packaging label design, per coffee SKU 3 420 1,260 Brand guidelines PDF, 24 pages (flat fee) 1 1,150 1,150 Social media template kit, per template 6 65 390 Final file export and handoff (hours) 2 95 190 Subtotal 6,980 Invoice
A ready-to-send invoice with totals
Total vs. Reimbursable Spend by Category (USD)
Date Merchant Category Description Amount 2026-03-08 Skyline Air Airfare Round-trip economy SEA–DEN 412.6 2026-03-08 Rocky Ride Share Ground Transport Airport to hotel 48.25 2026-03-08 Gate Grill Meals Dinner at airport before connection 27.8 2026-03-09 Brewer's Bean Coffee Meals Breakfast before kickoff meeting 14.35 2026-03-09 Larkspur Kitchen Client Entertainment Dinner with 4 client stakeholders 186.5 2026-03-10 Mile High Cab Ground Transport Hotel to client site 22 2026-03-10 Print & Ship Depot Supplies Printed workshop handouts (40 copies) 63.9 2026-03-11 Copper Table Meals Working lunch 41.2 Expense report
Claims with categories and totals
Task Duration (Workdays) by Finish Date
Phase Task Owner Start End Discovery Stakeholder interviews (dispatch, billing, CS) Maya Ortiz 2026-03-02 2026-03-06 Discovery Requirements sign-off Maya Ortiz 2026-03-05 2026-03-11 Discovery Data and API audit (TMS, billing system) Dev Patel 2026-03-04 2026-03-13 Design User flows and wireframes Lena Brandt 2026-03-09 2026-03-18 Design UI design and clickable prototype Lena Brandt 2026-03-16 2026-03-25 Design Usability test with 6 customer contacts Maya Ortiz 2026-03-23 2026-03-27 Build Login, SSO and account setup Dev Patel 2026-03-16 2026-03-27 Build Shipment tracking dashboard Tom Reyes 2026-03-23 2026-04-08 Project timeline
Tasks, owners and week-by-week plan