ABCDEFGHIJKLMNOPQRSTUVWXYZ
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 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10Week 11Week 12
7
Week Start Date26-Aug-20242-Sep-20249-Sep-202416-Sep-202423-Sep-202430-Sep-20247-Oct-202414-Oct-202421-Oct-202428-Oct-20244-Nov-202411-Nov-2024
8
Starting Cash Position125,000.00120,000.00115,000.00110,000.0035,000.0050,000.0055,000.0050,000.0055,000.00(10,000.00)(5,000.00)0.00
TURNS RED IF NEGATIVE CASH BALANCE
9
10
Customer 120,000.0020,000.0020,000.00
How certain are you that these will be paid and on time?
11
Customer 215,000.0015,000.0015,000.00
Checkout our tool that helps you to analyse your counterparties' creditworthiness.
12
Customer 35,000.005,000.005,000.00Visit:
risktailsdemo.herokuapp.com
13
Customer 45,000.005,000.00
We quantify your risk exposure across the whole portfolio of your business customers.
14
Loan10,000.00
15
XXX
16
XXX
17
XXX
18
19
Total Cash Inflow30,000.005,000.0015,000.005,000.0020,000.005,000.0015,000.005,000.0020,000.005,000.0015,000.000.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 Position120,000.00115,000.00110,000.0035,000.0050,000.0055,000.0050,000.0055,000.00(10,000.00)(5,000.00)0.000.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.005,000.00(5,000.00)5,000.00(65,000.00)5,000.005,000.000.00
WEEKLY CASH CHANGE
35
Numbers Add UpTRUETRUETRUETRUETRUETRUETRUETRUETRUETRUETRUETRUE
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