ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Using this cash flow statement
4
5
Open the Cash flow statement tab to use this template.
6
7
This cash flow statement template lists suggested cash incoming and outgoing items a typical business may have. You can edit these items by removing or adding rows and typing in your own items. To get started enter the financial year at the top of the sheet and enter your opening balance figure in the first column.

Please note: This statement assumes all figures include GST.

Formulas
When you enter your figures, the sheet will automatically calculate your totals and balance at the bottom. If you are adding or removing rows please double-check your figures to ensure the calculations have been preserved.

Calculations
Monthly cash balance equals Total incoming minus Total outgoing
Closing balance equals opening balance plus total incoming minus Total outgoing

This cash flow statement is intended as a GUIDE ONLY and DOES NOT constitute financial advice, please always verify and discuss your financial statements with a qualified accountant, solicitor or financial advisor.

This cash flow statement has been developed by business.gov.au, located within the Department of Industry, Science, Energy and Resources.

Copies of the latest version of this spreadsheet can be downloaded from www.business.gov.au.

If you need further information, assistance or referral for a small business issue, please contact us on 13 28 46.

8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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