How to Prepare a Cash Flow Forecast for Your Small Business

Last updated: 27 October 2026

Quick Summary

A small business cash flow forecast is a projection of money moving in and out of your business over a set period, showing when cash arrives, when it leaves, and your balance at the end of each month. Unlike profit, it reveals whether you have money available when you need to pay bills, helping you catch timing problems before they become crises.

• Gather 12 months of bank statements, invoices, and your business plan before starting your forecast.
• List all cash inflows and outflows month by month for the next 12 months, including irregular payments like tax bills and insurance renewals.
• A rolling cash flow forecast is updated every month, removing the finished month and adding a new month 12 months ahead to keep planning current.
• If your closing balance goes negative in any month, that's a warning you'll run out of cash unless circumstances change.
• Spreadsheets work for small businesses, but accounting software can save time and reduce errors for complex operations.

Table of Contents

• What a Cash Flow Forecast Is and Why Your Business Needs One
• What You'll Need Before Starting
• Step 1: Gather Your Historical Financial Data
• Step 2: List All Cash Inflows and Outflows
• Using a Small Business Cash Flow Forecast Template
• Cash Flow Forecast Example for a Small Business
• Understanding a Rolling Cash Flow Forecast
• Cash Flow Forecasting Software for Small Businesses
• When Your Forecast Shows a Funding Gap
• Frequently Asked Questions

What a Cash Flow Forecast Is and Why Your Business Needs One

A cash flow forecast is a projection of the money moving in and out of your business over a set period. It shows when cash arrives, when it leaves, and what your balance will be at the end of each month.

Many small business owners assume that if they're profitable, they're fine. That's not always true. A business can be profitable on paper but run out of cash because payments come in late or big expenses hit all at once. A cash flow forecast catches these timing problems before they become crises.

Seasonal businesses face cash droughts. Retail shops see lower sales in January. Construction firms wait months for project payments. Hospitality venues have quiet weeks between events. Without a forecast, you might miss payroll or miss the chance to buy stock when prices drop. With one, you can plan ahead, arrange funding if needed, or adjust spending to match your actual cash position.

At BusinessLoans.ie, we work with small business owners across Ireland who've discovered that a cash flow forecast prevents expensive surprises. It's one of the first things we recommend when a business owner asks about managing cash flow better.

What You'll Need Before Starting

Before you sit down to build a forecast, gather three things: your bank statements, your invoices, and your business plan for the coming months.

Bank statements show your actual cash movements. Pull the last 12 months of statements from your main business account. These reveal patterns: when money typically comes in, what your regular expenses are, and how much variation exists month to month.

Invoices and payment records tell you when customers actually pay. If you invoice on day 1 but customers pay on day 30, that gap matters. Review both sent invoices (to see when you expect cash in) and bills from suppliers (to see when cash goes out).

Your business plan includes any changes coming. Are you hiring staff? Launching a new product? Planning a renovation? These events change your cash flow, so you need to account for them.

You may also want to review Finance FAQ: The Questions Irish Business Owners Ask Every January, which covers common cash flow questions many owners have as they plan the year ahead.

If your forecast reveals funding gaps, Working Capital Finance: A Practical Solution as Costs Rise for Irish SMEs explains how flexible funding can bridge those gaps when cash flow dips.

Step 1: Gather Your Historical Financial Data

Start by pulling 12 months of actual financial records. This is your baseline.

Open your bank statements and note the opening balance for each month. Then list every deposit and every payment. You're looking for patterns. When does money typically arrive? Are there seasonal spikes or dips? What expenses are fixed (rent, salaries, insurance) and what varies (materials, fuel, stock)?

Many business owners skip this step and try to forecast from memory. Don't. Memory is unreliable, especially for small irregular payments that add up. A supplier invoice for €150 might happen three times a year. A utility bill might jump in winter. You need the actual numbers.

Create a simple spreadsheet. Put months across the top and line items down the side. For each month, fill in the actual cash in and cash out. This takes an hour or two, but it's the foundation everything else rests on.

Common expense categories to track when building your historical baseline:

The goal is not perfection. It's accuracy. If you spent roughly €500 a month on fuel but one month was €800, note both. The variation is real and the forecast needs to reflect it.

Step 2: List All Cash Inflows and Outflows

Now build your forecast month by month for the next 12 months.

Cash inflows are money coming in. This includes sales receipts, loan drawdowns, owner injections, and any other income. Be realistic, and record sales in the month you expect to be paid, not the month you invoice.

Cash outflows are money going out. List every expense you expect to pay: payroll, supplier invoices, tax, loan repayments, rent, utilities, stock purchases, equipment, professional fees, and anything else.

A common mistake is forgetting irregular payments. Tax bills come once or twice a year. Insurance renewals hit on specific dates. Equipment replacement happens every few years.

For each month, subtract outflows from inflows. The result is your net cash flow for that month. Add that to your opening balance to get your closing balance. That closing balance becomes next month's opening balance.

If your closing balance goes negative, that's a warning. It means you'll run out of cash that month unless something changes. That's the forecast doing its job.

Read Tax Time Pressure? Here's How Irish SMEs Can Protect Their Working Capital to understand how tax payments affect your forecast during key periods of the year.

Using a Small Business Cash Flow Forecast Template

A template saves time and keeps your forecast consistent.

The simplest template has columns for each month and rows for income categories, expense categories, and totals. Start with opening balance, add inflows, subtract outflows, and calculate closing balance. That's it.

Many templates include a section for assumptions. Write down your reasoning: "Sales forecast assumes 10% growth based on current pipeline" or "Payroll includes one new hire starting March." These notes help you update the forecast later when circumstances change.

Apply here →

More detailed templates break down sales by customer or product, or expenses by department. Use as much detail as helps you make decisions. A sole trader might use a simple one-page template. A business with multiple revenue streams might use a more detailed version.

You can build a template in a spreadsheet, use accounting software, or download a ready-made template. The format matters less than consistency. Whatever you choose, use it every month.

Use our business loan calculator to estimate how monthly repayments on business funding would affect your cash flow projections, so you can model scenarios and check that any borrowing fits your forecast.

Cash Flow Forecast Example for a Small Business

Let's walk through a simple example. Imagine a small retail shop with seasonal sales.

February is traditionally slower, so sales drop to €8,000. Stock costs stay the same because the order was placed before the slowdown. Outflows are still €13,400 but inflows are only €8,000, so the shop's balance falls to €6,200.

The shop is still fine. But if March is slow too, and April takes time to recover, the balance could dip below €3,000. That's when the owner might arrange short-term funding or delay a stock purchase.

That's what the forecast reveals: not disaster, but the timing and size of the squeeze. Armed with that knowledge, the owner can plan.

Understanding a Rolling Cash Flow Forecast

A rolling cash flow forecast is updated every month. You remove the month that just finished and add a new month 12 months ahead. This keeps your forecast always looking 12 months forward.

In January, you forecast February through January of the following year. In February, you remove January (which is now actual data) and add February of the following year. You're always planning a year ahead.

This approach has two benefits. First, it forces you to revisit assumptions regularly. When a month actually happens, you see where your forecast was right and where it was wrong, and adjust the coming months based on what you learned. Second, it keeps your forecast fresh, rather than leaving you with a plan that's already half finished.

Many businesses find that the first forecast is rough. By the third or fourth month of updating it, the forecast becomes much more accurate because you've refined your assumptions and caught patterns you missed initially.

Cash Flow Forecasting Software for Small Businesses

Spreadsheets work, but software can save time and reduce errors.

Many accounting packages include cash flow forecasting tools. They pull your actual bank data and let you add projected inflows and outflows. Some forecast automatically based on historical patterns. Others let you input custom assumptions for specific months.

The advantage of software is speed and accuracy. A spreadsheet is fast to build but easy to break with a formula error. The disadvantage is cost and learning curve: software usually requires a subscription and setup time.

For a sole trader or very small business, a spreadsheet is often enough. For a business with multiple income streams, complex expenses, or fast growth, software can pay for itself by saving time and catching errors. Look for bank-feed integration, the ability to model multiple scenarios, and reporting that shows you what you need to see.

A cash flow forecast isn't a one-time exercise. It's a tool you build once, then update every month as your business changes. The first forecast takes a few hours. Updates take around 30 minutes.

When Your Forecast Shows a Funding Gap

A forecast is also useful when you talk to lenders. It shows you understand your numbers, when the gap appears, how much you need and how repayments fit around your trading pattern.

Depending on your business, options can include unsecured business loans for businesses with at least 12 months trading and a year of profitable accounts, flexible repayment loans for businesses with steady monthly deposits, short-term business loans and merchant cash advances from 6 months trading, or invoice finance if customers are slow to pay. Our guide to a business loan with seasonal cash flow compares these in more detail.

BusinessLoans.ie puts one application to several lenders and returns the offers that fit. All finance is subject to lender assessment. Check your eligibility or call 01 55 636 55.

Frequently Asked Questions

How far ahead should a small business forecast cash flow?

Most small businesses benefit from forecasting 12 months ahead and updating the forecast every month so they always have a 12-month view. Seasonal businesses, such as hospitality and retail, may find it useful to look further ahead, for example 18 months, so a full trading cycle and the following peak are always visible.

What's the difference between a cash flow forecast and a profit forecast?

A cash flow forecast tracks actual money moving in and out of your account. A profit forecast measures income minus expenses on an accrual basis, which may not match when cash actually arrives. You can be profitable on paper but run out of cash if customers pay late or you purchase stock upfront. Both matter, but cash flow directly determines whether you can pay staff, suppliers, and bills on time.

How can a small business forecast cash flow when income is irregular?

Use historical data from the past two to three years, where available, to identify patterns and seasonal peaks. For new income streams, research industry benchmarks or speak to similar businesses. Use conservative estimates for uncertain months and review your forecast monthly. Finance options like invoice finance or merchant cash advances may help smooth gaps during slower periods.

What should I do if my cash flow forecast shows a shortfall?

First, review your assumptions and timings to confirm the shortfall is real. Then explore options: delay non-urgent spending, negotiate longer payment terms with suppliers, chase customer payments earlier, or reduce stock purchases. If the gap persists, speak to your bank or explore business finance. Flexible funding options can help bridge predictable shortfalls.

Apply here →

Information is for general guidance, not a personal recommendation or lending offer. All finance is subject to lender approval and the terms of the agreement.