SMEs · sole traders · start-ups

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
Add to basket
Cash Flow Forecaster – Dashboard

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?
No. It forecasts cash only, not a profit and loss account and balance sheet. That keeps it simple enough to update every month.
Can I model a bad year?
SCENARIOS lets you change sales, debtor days and costs for an optimistic and a pessimistic case and compare them with the base.
Do I need to be VAT registered?
No. If you are not registered, leave VAT out and the VAT3 lines stay empty.

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.

See the tight weeks before they arrive

Add the forecaster to your basket and continue to payment.

Add to basket