Cash Flow Forecast Calculator: How to Project Cash Flow

A cash flow forecast calculator answers one urgent question every business owner eventually asks: will I have enough money in the bank next month? It works by projecting your future cash position from a simple chain of arithmetic - your opening balance, plus everything you expect to receive, minus everything you expect to pay. Get that projection right and you spot a shortfall weeks before it hits, while you still have options.

This guide breaks down exactly how the calculation works. You will see the formula, learn what each input means and where to find it, walk through three fully worked numerical examples, and learn how to read the result so it actually changes what you do. Whether you are a freelancer, an agency owner, a startup founder or a bookkeeper, by the end you will be able to build and trust your own forecast.

What Is a Cash Flow Forecast Calculator?

A cash flow forecast calculator is a tool - a spreadsheet, an app feature, or a standalone web form - that projects how much cash your business will hold at the end of each future period. Unlike a profit and loss statement, which records what you earned and spent, a forecast deals with timing: when money actually lands in your account and when it leaves.

That distinction matters because a profitable business can still run out of cash. You might invoice $20,000 in a month but only collect $6,000 of it, while rent, payroll and software subscriptions all leave on schedule. A forecast captures that gap. The calculator does the repetitive maths so you can focus on the inputs and the decisions.

Most forecasts cover weekly or monthly periods over a horizon of 4 to 13 weeks, or 3 to 12 months. Short, frequent periods suit businesses with tight cash; longer monthly views suit planning and budgeting. The mechanics are identical either way.

It helps to be clear about what a forecast is not. It is not a guarantee, and it is not the same as your accounting records. A forecast is a deliberately simplified model of the future built on your best current assumptions. Its value comes not from being perfectly right but from being roughly right early enough to act. A forecast that says "you run short in six weeks" is useful even if the exact figure is off by a few hundred pounds, because it points you at the right problem at the right time.

The Cash Flow Forecast Formula

The entire forecast rests on one line of arithmetic, repeated for every period:

Closing Balance = Opening Balance + Total Inflows − Total Outflows

Then the crucial link that turns single periods into a forecast:

Next Period's Opening Balance = This Period's Closing Balance

That carry-forward is what makes a forecast a forecast rather than a one-off snapshot. Each period inherits the cash you ended the last one with. A small surplus or shortfall ripples forward into every future column.

You can also express the middle of that equation as Net Cash Flow = Total Inflows − Total Outflows. Net cash flow is the movement for the period on its own; the closing balance is your running cash position. Both numbers matter, and a good calculator shows you both.

What Each Input Means and Where to Find It

The calculator is only as good as the numbers you feed it. Here is every input, in plain English, and where to pull it from.

Opening balance

This is the cash you have available right now at the start of your first forecast period. Find it on your business bank statement or banking app - use the actual cleared balance, not the available balance that may include an overdraft facility. Only count money you genuinely control.

Cash inflows

Inflows are every pound, dollar or euro you expect to receive in the period. The main categories:

• Customer receipts - payments against invoices, projected on their expected payment date, not the invoice date. Look at each open invoice and its due date, then adjust for how reliably that client actually pays.
• New sales - cash from work you expect to win and bill within the period.
• Other income - tax refunds, grants, interest, asset sales.
• Financing inflows - a new loan drawdown, an investor injection, or owner's capital you plan to put in.

Your accounts receivable list and invoicing system are the primary sources here. If you use a platform that tracks invoice status and due dates, your expected receipts are already half-built.

Cash outflows

Outflows are everything leaving your account. Pull these from your accounts payable, recurring payment schedule and past bank statements:

• Payroll and contractor payments - usually your largest and most fixed outflow.
• Rent, utilities and insurance - predictable, scheduled.
• Supplier and inventory bills - from your accounts payable list, on their due dates.
• Software and subscriptions - recurring, easy to forget.
• Loan repayments and interest - on their fixed schedule.
• Tax payments - VAT, sales tax, payroll tax and income tax, which often hit in large lumps on known dates.

The forecast horizon and period length

Decide how far ahead to look and how granular each column should be. A cash-tight business benefits from weekly periods; a stable one can use months. Keep period length consistent across the whole forecast so the carry-forward stays clean.

The collection rate adjustment

This is the input most people skip, and it is the one that separates a useful forecast from a fantasy. Your collection rate is the percentage of invoiced amounts you actually collect within the period you expect to. If experience shows that, in any given month, roughly 85% of what is due actually lands and the rest slips, then forecast 85% of due invoices as inflow, not 100%. You can find this by looking back over the last several months: compare what you invoiced and when it was due against when the cash actually arrived. Apply that pattern, per client where you can, and your inflow line becomes trustworthy.

Worked Example 1: A Freelance Designer's Three-Month Forecast

Maya is a freelance brand designer. She starts the quarter with $4,200 in her business account. Let's project her cash flow over three months.

Month 1. Maya expects to collect $3,800 from two completed projects, and she will bill and collect a $1,500 deposit on a new one. Her outflows are software ($180), her own draw ($2,500) and an accountant ($120).

• Opening balance: $4,200
• Total inflows: $3,800 + $1,500 = $5,300
• Total outflows: $180 + $2,500 + $120 = $2,800
• Net cash flow: $5,300 − $2,800 = $2,500
• Closing balance: $4,200 + $2,500 = $6,700

Month 2. The new project's $1,500 final balance lands, plus $2,200 from another client. But Maya pays $1,800 in income tax on account, plus her usual $2,500 draw and $180 software.

• Opening balance: $6,700 (carried from Month 1)
• Total inflows: $1,500 + $2,200 = $3,700
• Total outflows: $1,800 + $2,500 + $180 = $4,480
• Net cash flow: $3,700 − $4,480 = −$780
• Closing balance: $6,700 − $780 = $5,920

Month 3. A quiet month: only $2,000 in receipts, with the $2,500 draw and $180 software.

• Opening balance: $5,920
• Total inflows: $2,000
• Total outflows: $2,500 + $180 = $2,680
• Net cash flow: $2,000 − $2,680 = −$680
• Closing balance: $5,920 − $680 = $5,240

Maya stays positive all quarter, but the trend is clear: two consecutive negative months are eating into her buffer. The forecast tells her to line up more Month 3 work now, or trim her draw, before the cushion thins further.

Worked Example 2: An Agency's 13-Week Forecast

A 13-week forecast is the standard tool for short-term liquidity management. Bright Lane, a five-person marketing agency, runs one weekly. We'll show three representative weeks. The agency opens Week 1 with $18,000.

Week 1. A $12,000 retainer payment clears. Payroll runs at $9,500, rent at $2,400.

• Opening: $18,000
• Inflows: $12,000
• Outflows: $9,500 + $2,400 = $11,900
• Closing: $18,000 + $12,000 − $11,900 = $18,100

Week 2. No client payments are due (a collection gap). Payroll does not run this week, but a $4,000 supplier bill and $600 in software are due.

• Opening: $18,100
• Inflows: $0
• Outflows: $4,000 + $600 = $4,600
• Closing: $18,100 + $0 − $4,600 = $13,500

Week 3. Two project invoices totalling $15,000 are due, but the agency knows one client pays late, so it forecasts only $8,000 collected this week. Payroll of $9,500 runs again.

• Opening: $13,500
• Inflows: $8,000
• Outflows: $9,500
• Closing: $13,500 + $8,000 − $9,500 = $12,000

The 13-week view exposes the Week 2 collection gap and the late-paying client in Week 3. Because Bright Lane forecasts realistic receipts rather than invoice-face values, it can see its balance trending down and chase the slow payer early or hold the supplier payment a few days.

Worked Example 3: A Startup Checking Its Runway

Forecasting also tells a pre-revenue startup how long its cash lasts. Northwind, a SaaS startup, opens with $120,000 raised. It has modest revenue and steady burn.

Month 1. Revenue (collected) of $4,000. Outflows: salaries $22,000, hosting $1,500, tools $900, office $2,600.

• Opening: $120,000
• Inflows: $4,000
• Outflows: $22,000 + $1,500 + $900 + $2,600 = $27,000
• Net cash flow: −$23,000
• Closing: $120,000 − $23,000 = $97,000

Month 2. Revenue grows to $5,200. Outflows hold at $27,000.

• Opening: $97,000
• Net cash flow: $5,200 − $27,000 = −$21,800
• Closing: $97,000 − $21,800 = $75,200

If net burn stays near $21,000-$23,000 a month, Northwind's runway is roughly $75,200 ÷ $22,000 ≈ 3.4 more months from the end of Month 2, before its cash hits zero. That single number reframes every decision: hiring, marketing spend, and how urgently the team needs to raise again or reach break-even.

How to Interpret Your Closing Balance

The closing balance line is where the forecast earns its keep. Read it across the whole horizon, not one period at a time.

A healthy forecast keeps every closing balance comfortably above zero and above a buffer you set for yourself - many advisors suggest holding three to six months of fixed costs in reserve. A balance that stays flat and positive means your inflows and outflows are broadly matched. A rising line means you are accumulating cash.

A warning forecast shows the line trending steadily downward, even if it never goes negative. That is a slow leak: you are spending faster than you collect, and you will hit trouble if nothing changes.

A danger forecast dips below zero in any period. That projected negative balance is a cash shortfall - the moment you cannot meet your obligations. The earlier in the horizon it appears, the more urgent it is, and the fewer options you have. Spotting it five weeks out lets you chase receivables, delay non-critical spending, or arrange financing calmly.

Forecast Methods Compared

Not every forecast is built the same way. The table below compares common approaches so you can pick the one that fits your situation.

For most small businesses, a rolling monthly forecast is the sweet spot: detailed enough to act on, light enough to maintain. Add a 13-week view on top when cash gets tight.

When and Why to Use a Cash Flow Forecast

You don't need a finance team to justify forecasting. Reach for the calculator when:

• Cash feels unpredictable. If you are surprised by your bank balance, a forecast removes the guesswork.
• You face a large outflow. A tax bill, equipment purchase or new hire - model it before you commit.
• Revenue is seasonal or lumpy. Project the lean months so you bank surplus during the busy ones.
• You are pitching for finance. Lenders and investors expect a credible forecast as standard.
• You are scaling. Growth eats cash; a forecast shows whether you can afford the next step.

The deeper reason is control. A forecast converts vague anxiety into a specific, dated number you can act on. For a fuller treatment of the planning side, see Aviy's guide on how to forecast business cash flow.

Pros and Cons of Cash Flow Forecasting

Like any tool, forecasting has trade-offs worth understanding.

Pros:

• Surfaces cash shortfalls weeks in advance, while you still have options.
• Cheap and fast - a spreadsheet or app feature is enough to start.
• Turns timing risk into a visible, manageable number.
• Strengthens conversations with lenders, investors and partners.
• Builds discipline around chasing receivables and scheduling payments.

Cons:

• Only as accurate as your inputs and your collection assumptions.
• Requires regular updating; a stale forecast misleads more than it helps.
• Can create false confidence if you forecast invoice values instead of realistic receipts.
• Doesn't fix the underlying business - it only shows you the problem early.

Common Mistakes to Avoid

These errors quietly wreck otherwise sensible forecasts.

• Forecasting invoice dates, not payment dates. Your client's $10,000 invoice due on the 1st might land on the 20th. Use realistic collection timing, not the due date.
• Assuming everyone pays in full and on time. Apply your real collection rate. If 15% of clients routinely pay late, build that in.
• Forgetting irregular outflows. Quarterly VAT, annual insurance, and software renewals are easy to omit and large enough to cause a shortfall.
• Mixing cash and accrual. Only enter money on the date it actually moves. Don't record revenue when you earn it - record it when you collect it.
• Setting it and forgetting it. A forecast is a living document. If you never compare projection against actuals, you never learn how wrong you were or improve.
• Ignoring the buffer. A closing balance of $200 is technically positive but practically terrifying. Forecast against a minimum reserve, not zero.

Best Practices for Accurate Forecasts

Follow these steps to build a forecast you can actually trust.

1. Start from the cleared bank balance. Anchor the whole model to a real, verifiable opening figure.
2. Forecast receipts conservatively. Discount invoice values for late payers and bad debt. It is far better to be pleasantly surprised than caught short.
3. List every recurring outflow. Build a standing schedule of payroll, rent, subscriptions, loan repayments and tax dates so nothing slips through.
4. Match your period length to your risk. Weekly when cash is tight, monthly when it is stable.
5. Compare forecast to actual every period. Record what really happened next to what you predicted, and refine your assumptions.
6. Run a worst-case scenario. Model a version where your biggest client pays 30 days late and a project slips. If you survive that, you are robust.
7. Keep it rolling. Each period, drop the one that just ended and add a new one at the far end so you always see the same distance ahead.

Direct vs Indirect Forecasting: Which Should You Use?

There are two recognized ways to build a cash flow forecast, and a calculator can support either.

The direct method is what every example in this guide uses. You list the actual cash receipts and payments you expect - invoice collections, payroll, rent, tax - and add them up. It is intuitive, granular and ideal for short-term operational forecasting. You can see exactly which client payment or supplier bill drives each movement.

The indirect method starts from your projected net profit and adjusts it for non-cash items (like depreciation) and changes in working capital (receivables, payables, inventory). It is the approach used in formal financial statements and longer-range planning, but it is less useful for spotting next week's shortfall because it hides the timing detail.

For day-to-day cash management, the direct method wins. Use it whenever your question is "will I have enough money on this date?" Reserve the indirect method for annual statements or investor decks where you are reconciling cash to profit. Most small businesses, freelancers and agencies will only ever need the direct approach, which is exactly what a simple opening-plus-inflows-minus-outflows calculator delivers.

Building scenarios on top of the base forecast

Once your base forecast works, the highest-value upgrade is scenario planning. Instead of one set of assumptions, build three:

• Base case - your realistic, most-likely expectation.
• Worst case - your biggest client pays 30 days late, a project slips, and a sale falls through.
• Best case - everything collects on time and a pipeline deal closes early.

Running all three through the same formula shows you the range of outcomes, not a single false-precision number. The worst case is the one that matters most: if your closing balance survives it, you can sleep. If it dips below zero, you know exactly which lever - a credit facility, a deposit policy, a cost cut - you need to pull before reality forces your hand.

How This Connects to Running Your Business

A cash flow forecast is not an academic exercise - it touches almost every operational decision you make. It tells you whether you can afford to hire, when to chase a late invoice, whether a discount for early payment is worth offering, and how much you can safely draw from the business.

Crucially, the quality of your forecast depends on the quality of your invoicing data. Your expected receipts come straight from your open invoices, their due dates and your clients' payment history. When that data is messy or scattered, your forecast inherits the mess. When it is clean, dated and tracked in one place, building the inflow side of your forecast takes minutes.

This is where good invoicing and analytics tools pull their weight. A platform that shows you which invoices are outstanding, when they are due, and how reliably each client pays gives you the raw material for an accurate forecast. Aviy's invoice analytics and business dashboard surface exactly these numbers - outstanding amounts, due dates and payment patterns - so your projected inflows reflect reality rather than wishful thinking. To go deeper on the actions a forecast points you toward, read how to improve cash flow in your business and the distinction between cash flow and profit.

Summary

A cash flow forecast calculator runs one formula across every period: Closing Balance = Opening Balance + Total Inflows − Total Outflows, with each closing balance carried forward as the next opening balance. Feed it your real cleared bank balance, conservatively projected receipts and a complete list of scheduled outflows, and it tells you your future cash position before you reach it.

The three worked examples - a freelancer, an agency and a startup - show the same arithmetic answering very different questions: am I draining my buffer, where is my collection gap, and how many months of runway do I have left? Read the closing-balance line across the whole horizon, watch for downward trends and any dip below your buffer, and update the model every period. Do that, and your forecast stops being a spreadsheet and becomes an early-warning system for the single thing that keeps a business alive: cash.

Frequently asked questions

What is the formula for a cash flow forecast?

The core formula is Closing Balance = Opening Balance + Total Inflows − Total Outflows. You apply it to each period, then carry that period's closing balance forward to become the next period's opening balance. Net cash flow for a single period is simply Total Inflows minus Total Outflows. That carry-forward chain is what turns isolated snapshots into a true forecast of your future cash position over weeks or months.

How do you calculate projected cash flow?

Start with your current cleared bank balance as the opening figure. Add every payment you realistically expect to receive in the period - discounting for late payers - to get total inflows. Subtract every payment leaving your account, including payroll, rent, subscriptions, loan repayments and tax. The result is your closing balance. Repeat for each future period, carrying each closing balance forward, and you have a projected cash flow forecast.

What is a good closing cash balance?

A good closing balance stays comfortably above zero and above a personal buffer - many advisors suggest three to six months of fixed operating costs held in reserve. The exact figure depends on your volatility: seasonal or lumpy businesses need a larger cushion. More important than any single number is the trend. A stable or rising closing balance across your forecast horizon is the real signal of health.

How far ahead should you forecast cash flow?

It depends on your cash situation. Businesses with tight liquidity use a 13-week forecast with weekly periods for sharp short-term visibility. Stable businesses use a rolling 12-month forecast with monthly periods for planning. Many run both: a 13-week view for survival and a 12-month view for strategy. Keep your forecast rolling so you always see the same distance ahead.

What is the difference between a cash flow forecast and a budget?

A budget plans what you intend to earn and spend, usually on an accrual basis tied to performance goals. A cash flow forecast tracks the timing of money actually entering and leaving your bank account. A budget can show profit while a forecast shows a shortfall, because invoicing a sale and collecting the cash happen on different dates. You need both, but the forecast keeps you solvent day to day.

How accurate is a cash flow forecast?

Accuracy depends entirely on your inputs. Near-term forecasts - the next week or two - can be highly accurate because most receipts and payments are already scheduled. Accuracy falls the further out you project, as new sales and timing become uncertain. The fix is to forecast receipts conservatively, compare projections to actuals each period, and update assumptions. A rolling, regularly reconciled forecast becomes steadily more reliable over time.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast projects your cash position weekly over roughly a quarter. It is the standard tool for short-term liquidity management and crisis recovery because it shows precisely which weeks face a collection gap or a large outflow. Each week's closing balance carries into the next. It demands weekly updating but gives the sharpest possible view of near-term solvency.

Should I forecast on a cash or accrual basis?

Always cash basis. The entire purpose of a forecast is timing - when money clears your account. Enter income on the expected payment date, not the invoice date, and enter expenses on the date they will actually be paid. An accrual forecast would tell you when you earned money, not when you can spend it, which defeats the object of forecasting liquidity.

How do I forecast receipts from outstanding invoices?

List each open invoice with its due date, then adjust for how reliably that specific client pays. If a client routinely pays 20 days late, forecast the receipt 20 days after the due date. Apply a haircut for bad debt where relevant. Your invoicing system's record of outstanding amounts, due dates and client payment history is the source for this - clean data here makes the inflow side fast and realistic.

What should I do if my forecast shows a negative balance?

Act early - the projected shortfall gives you lead time. Chase outstanding receivables and offer early-payment incentives. Delay or stagger non-essential outflows where you have flexibility. Negotiate longer terms with suppliers. If the gap is structural, arrange financing such as an overdraft or short-term facility before you need it. The whole value of forecasting is that you respond from a position of choice, not panic.

Conclusion

A cash flow forecast calculator is one of the highest-leverage tools a business owner can build, and it rests on arithmetic simple enough to do on the back of an envelope: opening balance, plus inflows, minus outflows, carried forward period after period. The discipline is not in the maths but in the honesty of the inputs - realistic receipts, complete outflows, and a buffer you respect.

Treat your forecast as a living document. Update it every period, compare your projections against what actually happened, and let the closing-balance line guide your real decisions about hiring, spending and chasing payment. Done consistently, a cash flow forecast calculator turns the most stressful question in business - will I have enough money? - into a number you can see coming and plan around.

Related guides

• Cash Flow Calculator: How to Calculate Cash Flow
• How to Forecast Business Cash Flow: A Practical Cash Flow Forecasting Guide
• How to Improve Cash Flow in Your Business
• Cash Flow vs Profit Explained: The Difference That Sinks Businesses
• Runway Calculation Guide for Startups: Master Your Startup Runway
• The Ultimate Guide to Cash Flow Management

Sources and further reading

• Cash flow forecasting (Wikipedia)
• Manage your cash flow (U.S. Small Business Administration)
• Cash Flow Statement (Investopedia)
• Cash flow management for your business (GOV.UK)