ABCDEFGHIJK
1
2
READ ME
3
4
5
INSTRUCTIONS:
6
7
1) Go to the "Container Inventory" Sheet. Set the starting amount of your Slim and Round Containers.
8
> DO NOT edit anything else on the sheet. Everything should autopopulate based on your inputs in the other sheets.
9
10
11
12
13
14
15
16
2) Go to the "Sales Log" Sheet. Set the prices of your products.
17
18
19
20
21
22
3) Enter your sales transactions. At the top of each column, there are guides on what to do for each column.
23
> If the top of the column says AUTO POPULATE, please DO NOT input anything in that column.
24
> This means that there are formulas written in each cell of that column, which should not be overwritten.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
4) Go to the "Expenses Log" sheet to record all your operating expenses for your business.
41
> You need to input your expense categories first, and then you can start inputting data in the table.
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
5) To view your daily and monthly business summary, you can go to either the "Daily Profit Summary" Sheet or the "Monthly Profit Summary" Sheet.
58
> NOTE: You don't need to edit ANYTHING on both of these sheets. You only need to set either the time period which you want to view.
59
> To select the month/year you want to view, you just need to click the respective dropdown lists.
60
61
62
63
64
65
66
67
68
69
70
71
72
73
6) To record everytime a customer returns their container, you need to go to the "Container Return Log" Sheet.
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
7) To easily view any unpaid orders that you may have, you can go to the "Unpaid Orders" Sheet.
91
> DO NOT edit ANYTHING on the sheet. Everything should autopopulate based on your inputs in the "Sales Log" Sheet.
92
93
94
95
96
97
98
99
100