Cash flow forecast for Irish small businesses – 12 months and 13 weeks
Profit on paper does not pay wages on Friday. The forecaster starts from today's bank balance and places every receipt and payment in the month – or the week – it really hits the account: customers paying late, the VAT3 every second month, PAYE the month after the payroll.
- 10 sales streams with their own debtor days
- Bi-monthly VAT3 calculated from sales and costs
- 13-week forecast for the next quarter
- Base, optimistic and pessimistic scenarios

Timing is the whole point
- Sales streams with VAT rate and debtor days
- Overheads by frequency and first payment date
- Wages with employer PRSI and pension contributions
- VAT3 on the 23rd after the period via ROS, including refunds
- Up to 5 loans and 15 capital items
TAX CALENDAR lists up to 12 tax payments with their due dates.
Technical details
- START
- SETTINGS
- RECEIPTS
- PAYMENTS
- TAX CALENDAR
- CASH FLOW
- ACTUAL VS FORECAST
- 13-WEEK FORECAST
- SCENARIOS
- DASHBOARD
- File format
- .xlsx
- Tabs
- 10
- Capacity
- 10 sales streams · 20 overheads · 15 payroll lines · 5 loans · 15 capex items · 15 other receipts · 12 tax payments
- Requires
- Excel 2016+ / Microsoft 365
- Macros
- None
Twelve months, then thirteen weeks
CASH FLOW shows twelve months from any start month with the closing bank balance and a warning when you go past the overdraft limit. 13-WEEK FORECAST zooms in on the next quarter week by week, which is what a bank usually asks for when cash is tight.
Inside the workbook




Before you buy
Is it a three-way forecast?
Can I model a bad year?
Do I need to be VAT registered?
Actual against forecast
Each month, enter the actual cash by line in ACTUAL VS FORECAST. The variance shows where the forecast was wrong, and the next twelve months roll on from the real bank balance.