ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
[ Insert Logo Here ]
2
Chartered Accountants & Business Advisors
3
4
5
12-MONTH CASH FLOW FORECAST
6
Category (€)Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9Month 10Month 11Month 12TOTAL
7
OPENING BALANCE
8
Opening Bank Balance-----------
9
10
CASH INFLOWS
11
 Sales Receipts-
12
 Debtor Collections-
13
 VAT Refunds-
14
 Grants / Funding-
15
 Loan Drawdowns-
16
 Director Loans In-
17
 Other Income-
18
Total Cash Inflows-------------
19
20
CASH OUTFLOWS
21
 Payroll / Wages-
22
 Employer PRSI-
23
 Rent / Rates-
24
 Supplier Payments-
25
 Utilities-
26
 Insurance-
27
 Professional Fees-
28
 Marketing / Advertising-
29
 VAT Payments-
30
 PAYE / PRSI-
31
 Corporation Tax-
32
 Loan Repayments-
33
 Asset Purchases / Capex-
34
 Other Expenses-
35
Total Cash Outflows-------------
36
37
SUMMARY
38
Net Cash Movement-------------
39
Closing Cash Balance-------------
40
41
NOTES
42
• Blue figures are manual inputs. Black figures are calculated automatically.
43
• Opening Balance for Month 2 onwards links automatically from the prior month's Closing Balance.
44
• Negative closing balances will highlight in red — review funding requirements with your advisor.
45
• This template provides a basic framework. For tailored cash flow analysis, contact Gallagher Keane.
46
47
Gallagher Keane | Chartered Accountants & Business Advisors | www.gallagherkeane.ie
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