| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||
2 | SALES COMMISSION TRACKER 💰 | ||||||||||||
3 | |||||||||||||
4 | |||||||||||||
5 | TOTAL NUMBER OF SALES | TOTAL SALES | TOTAL COMMISSION EARNED | ||||||||||
6 | 20 | ₱ 32,135,475.48 | ₱ 1,295,052.03 | ||||||||||
7 | |||||||||||||
8 | TOTAL NUMBER OF LEADS | LARGEST SALE | GOALS | ||||||||||
9 | 20 | ₱ 2,451,141.69 | 20 Sales in Q3 | ||||||||||
10 | |||||||||||||
11 | |||||||||||||
12 | CLOSING DATE | CLIENT NAME | PRODUCT / PROPERTY | SALES REPRESENTATIVE | REFERRAL CHANNEL | STATUS | ORIGINAL SALES PRICE | FINAL SALES PRICE | COMMISSION RATE | COMMISSION EARNED | COMMISSION PAID? | ||
13 | Jan 1, 2023 | Client 1 | Property 1 | Sales Rep 1 | Phone | SOLD | ₱ 1,000,000.00 | ₱ 1,000,000.00 | 2.50% | ₱ 25,000.00 | |||
14 | Jan 15, 2023 | Client 2 | Property 2 | Sales Rep 2 | SOLD | ₱ 1,050,000.00 | ₱ 1,050,000.00 | 3.50% | ₱ 36,750.00 | ||||
15 | Feb 1, 2023 | Client 3 | Property 3 | Sales Rep 3 | Ads | SOLD | ₱ 1,102,500.00 | ₱ 1,069,425.00 | 5.00% | ₱ 53,471.25 | |||
16 | Feb 17, 2023 | Client 4 | Property 4 | Sales Rep 4 | SOLD | ₱ 1,157,625.00 | ₱ 1,122,896.25 | 2.50% | ₱ 28,072.41 | ||||
17 | Mar 1, 2023 | Client 5 | Property 5 | Sales Rep 5 | Ads | SOLD | ₱ 1,215,506.25 | ₱ 1,179,041.06 | 2.50% | ₱ 29,476.03 | |||
18 | Mar 8, 2023 | Client 6 | Property 6 | Sales Rep 6 | SOLD | ₱ 1,276,281.56 | ₱ 1,237,993.12 | 3.00% | ₱ 37,139.79 | ||||
19 | Apr 5, 2023 | Client 7 | Property 7 | Sales Rep 7 | Ads | SOLD | ₱ 1,340,095.64 | ₱ 1,299,892.77 | 3.00% | ₱ 38,996.78 | |||
20 | Apr 12, 2023 | Client 8 | Property 8 | Sales Rep 8 | Networking | SOLD | ₱ 1,407,100.42 | ₱ 1,364,887.41 | 3.00% | ₱ 40,946.62 | |||
21 | May 15, 2023 | Client 9 | Property 9 | Sales Rep 9 | Ads | SOLD | ₱ 1,477,455.44 | ₱ 1,433,131.78 | 3.00% | ₱ 42,993.95 | |||
22 | May 18, 2023 | Client 10 | Property 10 | Sales Rep 10 | SOLD | ₱ 1,551,328.22 | ₱ 1,504,788.37 | 5.00% | ₱ 75,239.42 | ||||
23 | Jun 2, 2023 | Client 11 | Property 11 | Sales Rep 11 | SOLD | ₱ 1,628,894.63 | ₱ 1,580,027.79 | 5.00% | ₱ 79,001.39 | ||||
24 | Jun 30, 2023 | Client 12 | Property 12 | Sales Rep 12 | Website | SOLD | ₱ 1,710,339.36 | ₱ 1,659,029.18 | 5.00% | ₱ 82,951.46 | |||
25 | Jul 8, 2023 | Client 13 | Property 13 | Sales Rep 13 | Ads | SOLD | ₱ 1,795,856.33 | ₱ 1,741,980.64 | 5.00% | ₱ 87,099.03 | |||
26 | Jul 28, 2023 | Client 14 | Property 14 | Sales Rep 14 | SOLD | ₱ 1,885,649.14 | ₱ 1,829,079.67 | 5.00% | ₱ 91,453.98 | ||||
27 | Aug 20, 2023 | Client 15 | Property 15 | Sales Rep 15 | SOLD | ₱ 1,979,931.60 | ₱ 1,920,533.65 | 4.00% | ₱ 76,821.35 | ||||
28 | Sep 10, 2023 | Client 16 | Property 16 | Sales Rep 16 | SOLD | ₱ 2,078,928.18 | ₱ 2,016,560.33 | 4.00% | ₱ 80,662.41 | ||||
29 | Oct 15, 2023 | Client 17 | Property 17 | Sales Rep 17 | SOLD | ₱ 2,182,874.59 | ₱ 2,117,388.35 | 4.00% | ₱ 84,695.53 | ||||
30 | Nov 14, 2023 | Client 18 | Property 18 | Sales Rep 18 | SOLD | ₱ 2,292,018.32 | ₱ 2,223,257.77 | 4.00% | ₱ 88,930.31 | ||||
31 | Nov 27, 2023 | Client 19 | Property 19 | Sales Rep 19 | Website | SOLD | ₱ 2,406,619.23 | ₱ 2,334,420.66 | 4.50% | ₱ 105,048.93 | |||
32 | Dec 1, 2023 | Client 20 | Property 20 | Sales Rep 20 | SOLD | ₱ 2,526,950.20 | ₱ 2,451,141.69 | 4.50% | ₱ 110,301.38 | ||||
33 | | | |||||||||||
34 | | | |||||||||||
35 | | | |||||||||||
36 | | | |||||||||||
37 | | | |||||||||||
38 | | | |||||||||||
39 | | | |||||||||||
40 | | | |||||||||||
41 | | | |||||||||||
42 | | | |||||||||||
43 | | | |||||||||||
44 | | | |||||||||||
45 | | | |||||||||||
46 | | | |||||||||||
47 | | | |||||||||||
48 | | | |||||||||||
49 | | | |||||||||||
50 | | | |||||||||||
51 | | | |||||||||||
52 | | | |||||||||||
53 | | | |||||||||||
54 | | | |||||||||||
55 | | | |||||||||||
56 | | | |||||||||||
57 | | | |||||||||||
58 | | | |||||||||||
59 | | | |||||||||||
60 | | | |||||||||||
61 | | | |||||||||||
62 | | | |||||||||||
63 | | | |||||||||||
64 | | | |||||||||||
65 | | | |||||||||||
66 | | | |||||||||||
67 | | | |||||||||||
68 | | | |||||||||||
69 | | | |||||||||||
70 | | | |||||||||||
71 | | | |||||||||||
72 | | | |||||||||||
73 | | | |||||||||||
74 | | | |||||||||||
75 | | | |||||||||||
76 | | | |||||||||||
77 | | | |||||||||||
78 | | | |||||||||||
79 | | | |||||||||||
80 | | | |||||||||||
81 | | | |||||||||||
82 | | | |||||||||||
83 | | | |||||||||||
84 | | | |||||||||||
85 | | | |||||||||||
86 | | | |||||||||||
87 | | | |||||||||||
88 | | | |||||||||||
89 | | | |||||||||||
90 | | | |||||||||||
91 | | | |||||||||||
92 | | | |||||||||||
93 | | | |||||||||||
94 | | | |||||||||||
95 | | | |||||||||||
96 | | | |||||||||||
97 | | | |||||||||||
98 | | | |||||||||||
99 | | | |||||||||||
100 | | | |||||||||||