Cash Flow Forecasting in Ireland: The 13-Week View That Stops Businesses Running on Empty

Your profit and loss says you’re making money. Your bank account says otherwise. That disconnect is the reason profitable Irish businesses miss payroll, delay supplier payments, and turn down growth opportunities. They don’t have a profit problem. They have a cash flow problem.

A cash flow forecast fixes this by showing you exactly what’s coming in, what’s going out, and when you’ll hit your lowest cash point. The 13-week rolling forecast is the format that works best for SMEs: short enough to be accurate, long enough to act on. This guide shows you how to create one and use it to make informed decisions before cash gets tight.

What Problem Does a 13-Week Cash Flow Forecast Solve?

“Profitable on paper, broke in the bank” is not a hypothor. It’s what happens when your customers pay in 60 days but your VAT, PAYE, and rent are due now. The gap between invoicing and receiving cash is where Irish businesses get caught.

The most common cash pinch points in Ireland:

• VAT payment dates: Bi-monthly VAT bills that arrive whether your customers have paid or not.
• PAYE/PRSI obligations: Payroll taxes due monthly regardless of your cash position.
• Seasonal trading swings: Revenue dips while fixed costs stay constant.
• Supplier payment terms: 30-day terms from suppliers while your own customers stretch to 60 or 90 days.

Without a forecast, you discover these gaps when it’s too late to do anything about them. A 13-week cash flow forecast gives you early warning signals, typically weeks before a shortfall hits, so you can accelerate collections, delay discretionary spending, or arrange funding while you still have options.

What Is Cash Flow Forecasting and How Is It Different from Profit?

Cash flow forecasting is the process of predicting future cash inflows and outflows over a specific period. It answers one question: will we have enough cash to meet our obligations?

This is fundamentally different from your profit and loss statement. The P&L tells you whether you earned more than you spent on an accrual basis. But accrual accounting recognises revenue when you invoice, not when you get paid. It recognises expenses when they’re incurred, not when the money leaves your account.

A cash flow forecast strips that away and works purely on cash movements: when does money actually arrive in the bank, and when does it actually leave? That’s what pays wages. That’s what keeps suppliers delivering. That’s what keeps Revenue off your back.

A basic cash flow forecast shows:

• Opening cash balance: What’s in the bank at the start of the week.
• Cash inflows: Cash receipts from customers, loan drawdowns, grants, tax refunds.
• Cash outflows: Payroll, rent, suppliers, tax payments, loan repayments, capital expenditure.
• Net cash flow: Total inflows minus total outflows for the period.
• Closing cash balance: What’s left at the end. This becomes next week’s opening balance.

The number that matters most is your lowest cash point across the forecast horizon. That’s your danger zone. If it dips below zero, or below a comfortable buffer, you need to act before you get there.

Why Is a Rolling 13-Week Forecast the Right Approach?

Thirteen weeks is roughly one quarter. It’s the sweet spot between two extremes: a monthly forecast that’s too vague to drive action, and a daily cash forecast that demands more effort than most SMEs can sustain.

At a weekly level of detail, you can see individual payroll runs, VAT payments, large supplier invoices, and expected customer receipts landing in specific weeks. That granularity makes the forecast actionable. If week 8 shows a projected cash shortage, you have seven weeks to do something about it.

A rolling forecast means you don’t build it once and forget it. Each week, you drop the completed week off the front, add a new week to the end, and update your assumptions. The forecast stays current, and you’re never looking at stale numbers.

Who benefits from this?

• Business owners and finance directors: Visibility into the cash position without waiting for month-end accounts.
• Managers: Clarity on whether planned spending is affordable right now.
• Lenders and investors: Evidence that you understand and manage your working capital. A well-maintained forecast demonstrates financial control in a way that backward-looking accounts never can.
• Your accountant: A shared tool for strategic planning conversations rather than reactive firefighting.

What Are the Essential Components of a Good Cash Flow Forecast?

Keep it simple. The best forecasts are the ones that get maintained, and complexity kills consistency.

Your forecast needs four blocks:

1. Opening cash balance: Your actual bank balance (across all accounts) at the start of the forecast period. Include overdraft facilities if relevant, but label them separately so you can see when you’re relying on borrowed cash.
2. Cash inflows: Every source of cash coming in. Customer payments (broken down by major customer or customer type if helpful), loan drawdowns, grants, tax refunds, asset sales.
3. Cash outflows: Everything going out. Payroll, rent, key suppliers, insurance, loan repayments, VAT, PAYE/PRSI, corporation tax, capital expenditure. Separate fixed costs from variable costs so you can see which levers you can pull.
4. Net cash flow and closing balance: Total inflows minus total outflows gives you the net movement. Add that to the opening balance for the closing balance. That closing balance rolls forward as next week’s opening balance.

For a 13-week forecast, the direct method is the right approach. That means forecasting actual cash receipts and payments rather than adjusting your P&L for non-cash items (that’s the indirect method, which is better suited to longer-term forecasting).

How Do You Create a 13-Week Cash Flow Forecast Step by Step?

Step 1: Set Up Your Weekly Structure

Create 13 weekly columns. Label each with the week-ending date. Down the left, list your inflow and outflow categories. Keep it to 15-20 line items maximum. If you have more, consolidate smaller items into groups like “other operating costs.”

Step 2: Establish Your Opening Balance

Start with today’s actual bank balance across all accounts. If you have multiple bank accounts, sum them. Note any uncleared items (cheques issued but not yet cashed, pending transfers) that will affect the balance in the next few days.

Step 3: Estimate Cash Inflows

This is where most forecasts go wrong. The temptation is to be optimistic about when customers will pay. Don’t be.

1. Look at your aged receivables. What’s the actual average time your customers take to pay? Use that, not your payment terms.
2. For recurring revenue (retainers, subscriptions), place these in the weeks they’ll realistically land based on historical patterns.
3. For project-based or milestone payments, estimate conservatively. If a customer says “end of month,” assume the first week of the following month.
4. Build a base case, not a best case. You can run a best-case scenario separately.

Step 4: Estimate Cash Outflows

Outflows are easier to forecast because most are either fixed or predictable:

1. Payroll: You know exactly when this hits and roughly how much. Place it in the correct week.
2. Rent and fixed overheads: Monthly, predictable, place them in the week they’re debited.
3. Supplier payments: Use your accounts payable to see what’s due and when.
4. Tax payments: VAT (bi-monthly or quarterly), PAYE/PRSI (monthly), preliminary corporation tax (annually). These are known dates with estimable amounts.
5. One-off and irregular costs: Insurance renewals, annual software subscriptions, equipment purchases. These are the items people forget. Go through your calendar and prior year’s bank statements to catch them.

Step 5: Calculate Net Cash Flow and the Closing Balance

For each week: total inflows minus total outflows equals net cash flow. Opening balance plus net cash flow equals closing balance. Scan across the 13 weeks and find the lowest point. That’s your minimum cash position, the week where your cash is most stretched.

Step 6: Turn the Forecast into Actions

The forecast is a decision-making tool, not a report to file away. Set trigger points:

1. If projected cash drops below a threshold (say, two weeks of fixed costs), what actions kick in?
2. Pre-plan your levers: chase overdue invoices, delay discretionary spending, renegotiate supplier terms, draw on an overdraft facility, or explore short-term funding.
3. Assign owners. Someone needs to be accountable for updating the forecast weekly and flagging when trigger points are approaching.

What Does a Cash Flow Forecast Look Like for an Irish SME?

Here’s a simplified example for a services business with monthly invoicing and bi-monthly VAT:

	Week 1	Week 2	Week 3	Week 4
Opening balance	€45,000	€38,500	€31,000	€48,500
Customer receipts	€8,000	€5,000	€32,000	€6,000
Total inflows	€8,000	€5,000	€32,000	€6,000
Payroll	-€12,000			-€12,000
Rent		-€3,500
Suppliers	-€2,000	-€4,000	-€2,500	-€1,500
VAT payment		-€5,000
PAYE/PRSI			-€12,000
Total outflows	-€14,500	-€12,500	-€14,500	-€13,500
Net cash flow	-€6,500	-€7,500	€17,500	-€7,500
Closing balance	€38,500	€31,000	€48,500	€41,000

The story here: cash dips in weeks 1-2 as payroll, rent, VAT, and suppliers all hit before the big customer receipt lands in week 3. If that receipt is delayed, week 2’s closing balance of €31,000 is the danger zone. That’s the kind of insight a forecast gives you: not just “will we be fine eventually” but “where exactly is the squeeze?”

Should You Build Your Forecast in a Spreadsheet or Use Software?

A spreadsheet works. For many small businesses, it’s the right starting point. You get full control over the layout, it costs nothing, and you can tailor it exactly to your business.

The downsides show up over time: version control (which spreadsheet is current?), formula errors that go unnoticed, manual data entry when your accounting software already has most of the information, and difficulty collaborating with your accountant or co-founders.

Cash flow forecasting tools and solutions (Fathom, Float, Futrli, or built-in features in Xero and Sage) automate much of the data entry by pulling from your accounting software and bank feeds. They offer scenario modelling, variance tracking (forecast vs actual), and dashboards that make it easier to spot trends.

If you’re starting from nothing, begin with a spreadsheet. Get the discipline of weekly updates established first. Move to software when the manual effort becomes the bottleneck or when you need scenario planning and collaboration features.

What Are the Most Common Cash Flow Forecasting Challenges?

The forecast itself is straightforward. Maintaining it is where businesses stumble.

1. Optimistic assumptions: Forecasting that customers will pay on terms when your actual debtor days say otherwise. Use historical data, not hopes.
2. Forgetting irregular payments: Annual insurance, quarterly tax, one-off capital expenditure. Go through your prior year’s bank statements and flag every non-monthly payment.
3. Not updating weekly: A forecast that’s three weeks old is fiction. The whole point of a rolling 13-week view is that it stays current. If nobody is updating it, it provides false confidence.
4. Confusing profit with cash: A sale invoiced is not cash received. A bill recorded is not cash paid. The forecast must reflect actual cash movements, not accrual entries.
5. No ownership: If nobody is accountable for the forecast, it won’t get done. Assign one person to update it weekly and present the picture of your cash position at a regular meeting.

The fix for most of these is the same: a weekly cadence with variance tracking. Each week, compare what you forecast to what actually happened. The gaps teach you where your assumptions are wrong, and the forecast gets more accurate over time.

Frequently Asked Questions About Cash Flow Forecasting

How far ahead should I forecast: 13 weeks or 12 months?

Both serve different purposes. A 13-week forecast is your short-term cash management tool: detailed, weekly, highly accurate. A 12-month forecast is for strategic planning and financial health conversations with lenders or investors. Most businesses benefit from having both. Start with 13 weeks if you’re choosing one.

What’s the difference between a cash flow forecast and a cash flow statement?

A cash flow statement is backward-looking: it reports what happened to cash in a past period. A cash flow forecast is forward-looking: it predicts what will happen to cash in future periods. The statement is a reporting tool; the forecast is a planning and decision-making tool.

How do I forecast cash flow if my customers pay late?

Use your actual collection data, not your payment terms. If your terms say 30 days but your average debtor days are 52, forecast based on 52. Build scenarios: a base case using average collection times, and a worst case assuming your slowest payers get even slower. The gap between those scenarios is your risk exposure.

What’s the best method for a small business?

The direct method: forecast actual cash receipts and payments week by week. It’s practical, intuitive, and gives you the level of detail you need for short-term cash management. The indirect method (adjusting net income for non-cash items) is better suited to medium-term and long-term forecasting.

How often should I update a rolling 13-week forecast?

Weekly. Every week, drop the completed week, add a new week at the end, update your assumptions for any changes, and compare the prior week’s forecast to actual results. This takes 20-30 minutes once the routine is established. Skip it for two weeks and the forecast loses its value.

Ready to Build a Cash Flow Forecast for Your Business?

If cash feels tight and you’re not sure when it will get better, a 13-week forecast will give you the answer. If cash is fine today but you’re growing and want to stay ahead of the curve, the forecast will show you exactly how much runway you have and when you’ll need more.

We build 13-week cash flow forecasts for Irish SMEs and set up the weekly review process so the forecast stays live. You get a usable template, setup guidance, and a rhythm that keeps you in control of your cash position rather than reacting to surprises.

Get in touch today with your latest bank balances, aged receivables, aged payables, payroll schedule, and upcoming tax dates. We’ll build the forecast and walk you through what it’s telling you.

Contact First Accounts

Disclaimer: This guide is for general information purposes only and does not constitute tax advice. Tax rules and thresholds can change. Always consult a qualified accountant or tax adviser for advice specific to your circumstances.