WORKBOOKCOMMISSION STATEMENTS
BUILDER
createWorkbook()SHEETS
2OOXML PARTS
10 filesFEATURES
8DATASET
smallTwelve reps, their quota and closed-won, and a payout computed by Excel formulas: 8% to quota, 12% above it, plus SPIFFs. A deals sheet and a pivot by deal type sit behind it.
schema.ts
StatementsA1:J28, frozen at B4
click a cell to inspect itfx
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
Q3 2026 commission statements
Payout
Rep
Team
Deals
Quota
Closed won
Attainment
Base 8%
Accel. 12%
SPIFFs
Total
Ally Padberg
Mid-Market
9
$520,000
$726,800
140%
$41,600
$24,816
$1,000
$67,416
Sophia Haley
SMB
11
$260,000
$340,700
131%
$20,800
$9,684
$0
$30,484
Piper Lind
Enterprise
9
$900,000
$1,140,800
127%
$72,000
$28,896
$1,000
$101,896
Dannie Oberbrunner
Mid-Market
9
$520,000
$650,200
125%
$41,600
$15,624
$1,000
$58,224
Chanelle Kub
Mid-Market
6
$520,000
$558,100
107%
$41,600
$4,572
$2,500
$48,672
Tyrel Kutch
Enterprise
7
$900,000
$932,500
104%
$72,000
$3,900
$0
$75,900
Jonathon O'Connell
Enterprise
6
$900,000
$898,500
100%
$71,880
$0
$1,000
$72,880
Brandt Runte
Enterprise
6
$900,000
$729,300
81%
$58,344
$0
$1,000
$59,344
Jeffry Osinski
Mid-Market
4
$520,000
$365,900
70%
$29,272
$0
$0
$29,272
Destiney Wilderman
SMB
5
$260,000
$177,200
68%
$14,176
$0
$0
$14,176
Oda Nikolaus
SMB
5
$260,000
$162,100
62%
$12,968
$0
$1,000
$13,968
Mike Runolfsdottir
SMB
4
$260,000
$145,400
56%
$11,632
$0
$1,000
$12,632
$6,827,500
$584,864
Cell in the file