SCORE-12-Month-Cash-Flow.gdoc
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKAL
1
This is a TEMPLATE
You cannot edit directly on this doc
Please make a copy of this doc and delete this row
2
Converted to gdoc from SCORE.ORG's 12-Month Cash Flow Statement Excel Template (Jan 2017)
3
https://www.score.org/resource/12-month-cash-flow-statement
4
5
6
Cash Flow (12 months)
Enter Company Name Here
Fiscal Year Begins:
Jan-17
7
Pre-Startup ESTJan-17Feb-17Mar-17Apr-17May-17Jun-17Jul-17Aug-17Sep-17Oct-17Nov-17Dec-17Total Item EST
8
Cash on Hand (beginning of month)0000000000000
9
10
CASH RECEIPTS
11
Cash Sales
12
Collections fm CR accounts
13
Loan/ other cash inj.
14
TOTAL CASH RECEIPTS00000000000000
15
Total Cash Available (before cash out)00000000000000
16
17
CASH PAID OUT
18
Purchases (merchandise)
19
Purchases (specify)
20
Purchases (specify)
21
Gross wages (exact withdrawal)
22
Payroll expenses (taxes, etc.)
23
Outside services
24
Supplies (office & oper.)
25
Repairs & maintenance
26
Advertising
27
Car, delivery & travel
28
Accounting & legal
29
Rent
30
Telephone
31
Utilities
32
Insurance
33
Taxes (real estate, etc.)
34
Interest
35
Other expenses (specify)
36
Other (specify)
37
Other (specify)
38
Miscellaneous
39
SUBTOTAL00000000000000
40
Loan principal payment
41
Capital purchase (specify)
42
Other startup costs
43
Reserve and/or Escrow
44
Owners' Withdrawal
45
TOTAL CASH PAID OUT00000000000000
46
Cash Position (end of month)00000000000000
47
48
ESSENTIAL OPERATING DATA (non cash flow information)
49
Sales Volume (dollars)
50
Accounts Receivable
51
Bad Debt (end of month)
52
Inventory on hand (eom)
53
Accounts Payable (eom)
54
Depreciation
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...
 
 
 
Twelve-month cash flow
Instructions
 
 
Main menu