ABCDEFGHIJKLM
1
MonthRevenueAvg Box CostTotal Postage Cost
Marketing Expenses (FB Ads, Cratejoy Platform, Bloggers)
Labor ExpensesQuarterly Sales Tax
Total Box Costs
Total FeesNet IncomeAVG Profit Per Box
2
2018 January$243.72$12.00$45.00$0.00$0.00$0.00$96.00$33.68$69.04$8.63
3
2018 February$0.00$0.00$0.00$0.000
4
2018 March$0.00$0.00$0.00$0.000
5
2018 April$0.00$0.00$0.00$0.000
6
2018 May$0.00$0.00$0.00$0.000
7
2018 June$0.00$0.00$0.00$0.000
8
2018 July$0.00$0.00$0.00$0.000
9
2018 August$0.00$0.00$0.00$0.000
10
2018 September$0.00$0.00$0.00$0.000
11
2018 October$0.00$0.00$0.00$0.000
12
2018 November$0.00$0.00$0.00$0.000
13
2018 December$0.00$0.00$0.00$0.000
14
Totals$243.72$69.04
15
16
INPUTSDERIVED VALUES
17
Change the BLUE Inputs to match your business.Leave the YELLOW values alone, they are calculated from your inputs.
18
19
20
21
Notes
22
Avg Box Cost
*Cost of goods per box
23
Total Postage Cost
*Total amount of money spent on purchasing postage labels
24
Marketing Expenses
*Total amount of money spent on FB ads, google ads, etc...
25
Labor Expenses
*Total amount of money spent on labor contractors
26
27
DISCLAIMER - This template was designed to be used with Cratejoy's transaction details export, the formula's can be applied to other systems but will not be plug and play unless using Cratejoy. This was not built by a CPA and is not a replacement for sound financial advice and planning. It is a tool designed to give you a basic understanding of the health of your business. The calculated numbers are done on a cash basis, there are additional liabilities with prepaid subscriptions that should be better accounted for.
28
29
30
31
32
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