Simple Cash Flow Template For SMEs

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2		WEEKLY CASHFLOW TEMPLATE FOR SMALL TO MEDIUM ENTERPRISES
3		Feel free to download (File > Download > Select File Option) and edit for your own business
4
5
6		Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
7	Week Start Date	4-Nov-2024	11-Nov-2024	18-Nov-2024	25-Nov-2024	2-Dec-2024	9-Dec-2024	16-Dec-2024	23-Dec-2024	30-Dec-2024	6-Jan-2025	13-Jan-2025	20-Jan-2025
8	Starting Cash Position	125,000.00	120,000.00	115,000.00	110,000.00	35,000.00	50,000.00	55,000.00	50,000.00	55,000.00	(10,000.00)	(5,000.00)	0.00	TURNS RED IF NEGATIVE CASH BALANCE
9
10	Customer 1	20,000.00				20,000.00				20,000.00				How certain are you that these will be paid and on time?
11	Customer 2			15,000.00				15,000.00				15,000.00		Checkout our tool that helps you to analyse your counterparties' creditworthiness.
12	Customer 3		5,000.00				5,000.00				5,000.00			Visit:	risktailsdemo.herokuapp.com
13	Customer 4				5,000.00				5,000.00					We quantify your risk exposure across the whole portfolio of your business customers.
14	Loan	10,000.00
15	XXX
16	XXX
17	XXX
18
19	Total Cash Inflow	30,000.00	5,000.00	15,000.00	5,000.00	20,000.00	5,000.00	15,000.00	5,000.00	20,000.00	5,000.00	15,000.00	0.00	SUM OF ALL CASH INFLOWS
20
21	Supplier 1	(30,000.00)
22	Supplier 2			(20,000.00)				(20,000.00)
23	Supplier 3
24	Supplier 4		(10,000.00)									(10,000.00)
25	Interest
26	Salaries				(80,000.00)					(80,000.00)
27	Office	(5,000.00)				(5,000.00)				(5,000.00)
28
29	Total Cash Outflow	(35,000.00)	(10,000.00)	(20,000.00)	(80,000.00)	(5,000.00)	0.00	(20,000.00)	0.00	(85,000.00)	0.00	(10,000.00)	0.00	SUM OF ALL CASH OUTFLOWS
30
31
32	Ending Cash Position	120,000.00	115,000.00	110,000.00	35,000.00	50,000.00	55,000.00	50,000.00	55,000.00	(10,000.00)	(5,000.00)	0.00	0.00	TURNS RED IF NEGATIVE CASH BALANCE
33
34	Total Cash Flow Change	(5,000.00)	(5,000.00)	(5,000.00)	(75,000.00)	15,000.00	5,000.00	(5,000.00)	5,000.00	(65,000.00)	5,000.00	5,000.00	0.00	WEEKLY CASH CHANGE
35	Numbers Add Up	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	TRUE	SIMPLE NUMBERS CHECK
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