ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Shopify财务报表模板Shopify Capital

Some financial support can go a long way.
Shopify Capital is here for you with quick and easy access to funds.
2
3
Make a copy and download this template and use it to forecast the financial details of your business by month. The mint green cells are input fields.

Step 1 - Download this template. Go to file --> download --> choose either csv or excel formats.
Step 2 - Make a list of everything you have to pay for - rent, salary, ads, ect.
Step 3 - Determine how much cash you have in the bank at the start of forecast period. (eg: If you start this forecast in March, determine how much cash you have as of March 1st. Input it at the "Opening Cash Balance" line 7.
Step 4 - Forecast revenue. You can use past data to help with your projections.
Step 5 - Plug in the rest of your data.
Step 6 - Keep updating your projections and plan for different scenarios. This is a living document.
4
More instructions on cash flow management here.
5
6
一月二月三月四月五月六月七月八月九月十月十一月十二月
7
现金余额
8
初现金余额$1,000.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00
9
10
收入
11
门店销售$500.00
12
线上销售
13
其他收入
14
总收入$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
15
16
毛利润
17
销售成本
18
毛利润$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
19
毛利率100.0%-----------
20
21
费用
22
固定成本
23
租金
24
保险
25
费用（银行手续费、执照等）
26
固定成本合计$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
27
变动成本
28
薪酬
29
物流运费
30
水电费
31
设备及耗材
32
营销支出
33
其他费用
34
变动成本合计$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
35
费用合计$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
36
37
净利润率
38
EBITDA
息税折旧摊销前利润		$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
39
利息
40
所得税
41
净利润 / 亏损$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
43
44
期末现金余额
45
净利润 / 亏损$500.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
46
期末现金余额$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00$1,500.00
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
101