Group Sales Tracking Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet is a simple tool you can use to keep track of each seller that you give product to for your fundraising project.
2
For example: You gave Ann Smith 400 random round bracelets, 200 flat no bead and 50 key chains to sell on 10/29/2017.
3
On 11/15/17 she gave you $650 from sales and returned 250 random round, 100 flat no bead and 30 keychains.
4
On 1/1/2018 Ann gave you $75 and returned 5 keychains. Now the group is done selling.
5
In summary, Ann submitted $725, which was from the sale of 150 random round, 100 flat no bead and 15 keychains.
6
7
Seller # 1
Ann Smith
Seller Phone Number123-456-5455Seller Email Addressasmith@gmail.com
8
DateFunds CollectedProduct IN or OUTProduct Type 1Product 1 QuantityProduct Type 2Product 2 QuantityProduct Type 3Product 3 QuantityProduct Type 4Product 4 QuantityProduct Type 5Product 5 Quantity
9
10/29/2017OUTRR400FN200KC50
10
11/15/2017650IN-250-100-30
11
1/1/201875IN-5
12
13
14
15
Total Collected
$725.00Qty SoldRR150FN100KC1500
16
17
Seller # 2
John Smith
Seller Phone Number123-456-7890Seller Email Addressjsmith@gmail.com
18
DateFunds CollectedProduct IN or OUTProduct Type 1Product 1 QuantityProduct Type 2Product 2 QuantityProduct Type 3Product 3 QuantityProduct Type 4Product 4 QuantityProduct Type 5Product 5 Quantity
19
10/29/2017OUTRR300FN100KC50
20
12/5/2017700IN-100-50-20
21
22
23
24
25
Total Collected
$700.00Qty SoldRR200FN50KC3000
26
27
Seller # 3Seller Phone NumberSeller Email Address
28
DateFunds CollectedProduct IN or OUTProduct Type 1Product 1 QuantityProduct Type 2Product 2 QuantityProduct Type 3Product 3 QuantityProduct Type 4Product 4 QuantityProduct Type 5Product 5 Quantity
29
30
31
32
33
34
35
Total Collected
$0.00Qty Sold00000
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
Loading...
 
 
 
Sample
Sheet1
 
 
Main menu