Cash Flow Forecast: How to Plan 12 Months Ahead

Cash Flow Forecasting for Small Businesses | Cash Shortages, Payment Planning & Cash Runway

Your Business Is Making a Profit. So Why Is Cash Still Tight?

Imagine your business has just completed a successful month.

Sales are growing. Your profit and loss statement shows a profit. Customers are placing new orders.

But when supplier invoices, rent, and payroll become due, your bank balance isn't enough to cover everything.

How can a profitable business run short of cash?

The answer often comes down to timing.

Your business may record a sale today but receive payment weeks later. Meanwhile, suppliers and employees may need to be paid much sooner.

This is why understanding profit alone isn't enough. You also need to know when money is expected to enter and leave your business.

1. What Is a Cash Flow Forecast?

A cash flow forecast estimates how much cash your business may have available over a future period.

It starts with your opening cash balance, adds expected cash receipts, and subtracts expected cash payments.

The basic relationship is:

Closing Cash = Opening Cash + Cash Inflows − Cash Outflows

Unlike a profit and loss statement, a cash flow forecast focuses on the timing of money actually received and paid.

It can help you anticipate potential cash shortages, prepare for upcoming obligations, and evaluate whether you can afford planned business decisions.

2. Why Can a Profitable Business Have Cash Flow Problems?

Several situations can create pressure on cash availability.

Customers Pay Later Than Expected

A business may generate revenue through credit sales while waiting 30, 60, or more days to collect payment.

Suppliers Require Earlier Payment

Inventory, materials, or services may need to be paid for before the related customer revenue is collected.

Large Payments Arrive Together

Payroll, rent, taxes, supplier invoices, and loan payments may fall due within the same week.

Business Growth Requires More Cash

Higher sales can require more inventory, additional production, or increased operating expenses before the extra revenue becomes available as cash.

Profit Doesn't Include Every Cash Movement

Loan principal repayments, equipment purchases, and owner withdrawals can reduce cash even though they aren't all recorded as expenses in the same way as operating costs.

A profitable business can still face a cash shortage if payment obligations arrive before sufficient cash receipts.

3. How to Build a Simple Cash Flow Forecast

Start with four pieces of information:

Your available opening cash balance.
Expected cash receipts, including customer payments and other cash inflows.
Expected cash payments, including suppliers, payroll, rent, taxes, and other obligations.
The dates when those receipts and payments are expected.

A monthly forecast is useful for seeing the broader picture over 12 months.

However, when cash is tight, daily or weekly payment timing can be just as important. A positive month-end balance doesn't guarantee that every payment due during the month can be covered.

Let's look at a simplified three-month example that illustrates how a cash shortage can develop even when expected receipts are increasing:

4. What Does This Cash Flow Forecast Tell You?

In our example, the business starts January with $5,000 in cash.

Despite receiving $12,000 during the month, it pays out $13,500. That leaves an ending cash balance of $3,500.

In February, cash falls further to $1,200 because payments exceed receipts again.

March brings a small recovery to $1,400, but the business still has significantly less cash than it started with.

The important question isn't just whether your cash balance is positive. It's whether you have enough cash when your obligations become due.

A $1,200 balance may be sufficient for one business but dangerously low for another.

5. How to Identify a Potential Cash Shortage

A useful cash flow forecast should help you evaluate three questions.

Can You Cover Upcoming Payments?

Compare expected cash availability with supplier invoices, payroll, rent, and other obligations due.

If cash available before a payment is insufficient, you may face a payment shortfall.

Will You Maintain a Safe Cash Buffer?

Even if you can pay every bill, using nearly all available cash can leave your business exposed to unexpected expenses or delayed customer payments.

Consider setting a minimum cash buffer based on your business's operating needs and financial risks.

When Might Cash Become Tight?

A monthly forecast can reveal broad trends, but it may hide shortages that occur between month-end dates.

Review the expected timing of receipts and payments, especially when several large obligations fall due close together.

6. How to Improve Your Cash Flow Planning

Review Customer Payment Timing

Identify which customers are expected to pay and when.

If payment delays are common, consider whether earlier invoicing, payment reminders, or revised payment terms could help.

Plan Supplier and Operating Payments

Understand when major obligations fall due.

Where commercially appropriate, explore whether payment schedules can be better aligned with expected receipts.

Avoid Confusing Revenue With Cash Received

A sale recorded today doesn't necessarily create cash available today.

For cash forecasting, use expected receipt dates rather than sales dates when payment is delayed.

Evaluate Major Decisions Before Spending

Hiring, purchasing equipment, increasing inventory, or expanding operations can create additional cash requirements.

Consider whether your projected cash position can support these decisions without putting essential payments at risk.

7. Apply Cash Flow Forecasting to Your Business

Start With the Cash Flow & Runway Planner

GrowthYou's Cash Flow & Runway Planner helps you organize expected cash inflows and outflows, evaluate projected cash availability, and identify potential cash shortages.

It also supports evaluating whether planned business decisions can be funded while considering upcoming payment obligations and a minimum safe cash level.

Explore Cash Flow & Runway Planner on Etsy

Understand the Costs Affecting Your Cash Requirements

The Cost Clarity Tool helps you organize fixed, variable, and mixed expenses so you can better understand your business cost structure.

Explore Cost Clarity Tool on Etsy

Review Profitability Alongside Cash Flow

The P&L / Business Performance Dashboard helps you examine revenue, costs, and profitability.

Used alongside cash forecasting, it can help you distinguish financial performance from actual cash availability.

Explore P&L / Business Performance Dashboard on Etsy

8. Explore All GrowthYou Individual Business Decision Tools

Cash flow planning connects to many other business decisions.

GrowthYou offers 11 individual Excel Business Decision Tools covering:

Financial performance and profit tracking - Simple Profit & Loss or Intermediate Profit & Loss Dashboard
Cost analysis and break-even calculations - Cost Clarity & Break-Even Position
Cash flow forecasting and cash runway - Cash Flow & Runway
Pricing and profit margin decisions - Pricing & Margin Decision
Product profitability - Product Pofitability Decision
Price change and profit impact analysis - Price Change Impact & Profit Impact
Revenue growth forecasting - Revenue Growth Planner
Profit goal planning - Profit Goal Planner

Explore All Individual Business Decision Tools

9. Explore GrowthYou Business Tool Bundles

Sometimes, a cash shortage is connected to broader business performance issues.

GrowthYou bundles combine complementary tools to help you explore those connected questions.

B01 — Check Your Business Health

Understand your costs, profitability, break-even position, and projected cash availability.

Explore B01 — Check Your Business Health

B02 — Find What To Improve

Review costs, operating performance, pricing, margins, and product profitability to identify potential improvement opportunities.

Explore B02 — Find What To Improve

B03 — Test Business Decisions

Evaluate the potential financial impact of changes in prices, costs, and sales volume.

Explore B03 — Test Business Decisions

B04 — Plan The Next Target

Explore revenue growth scenarios, calculate sales requirements for profit goals, and review the financial starting point behind your targets.

Explore B04 — Plan The Next Target

Cash Flow Planning Helps You Prepare Before Problems Arrive

A profitable business can still struggle when money arrives later than payments are due.

By forecasting cash receipts, payment obligations, and expected balances, you can identify potential pressure points earlier and evaluate your options.

Your Business. Your Numbers. Your Growth.

Understand when cash is coming, when it's going, and what that means for your next business decision.