How to Create a Cash Flow Forecast for a Small Business

A business can have customers, active projects, and a healthy pipeline of new work while still facing a cash shortage.

The reason is often timing.

A customer might promise to pay next month, while your supplier expects payment this week. A large project might generate substantial revenue, but the associated costs may need to be paid before the customer settles the invoice.

Without a clear picture of upcoming cash inflows and outflows, these situations can be difficult to anticipate.

This is where a cash flow forecast becomes useful.

A cash flow forecast estimates how much cash your business expects to receive, how much it expects to spend, and how much cash should remain available over a future period.

It doesn't require a large finance team or complicated accounting software. Freelancers, contractors, consultants, and small-business owners can begin with a simple spreadsheet and a realistic list of expected payments.

In this guide, you'll learn how to create a cash flow forecast step by step, how to estimate customer payments, how to include expenses, how to handle uncertainty, and how to use your forecast to make better business decisions.

What Is a Cash Flow Forecast?

A cash flow forecast is an estimate of your business's future cash position.

It typically starts with your current cash balance and projects how that balance will change as money comes in and goes out.

For example, suppose your business starts the week with $12,000.

You expect to collect $5,000 from customers and pay $4,000 in expenses.

Your projected closing cash balance is:

$12,000 + $5,000 − $4,000 = $13,000

This calculation gives you an estimate of the cash available at the end of the week.

You repeat the process for subsequent periods, using each period's closing balance as the next period's opening balance.

A cash flow forecast can cover different time horizons:

• Weekly: Useful when payment timing is unpredictable or cash is tight.
• Monthly: Useful for regular budgeting and financial reviews.
• Quarterly: Useful for planning larger expenses, seasonal changes, and business priorities.
• Longer-term: Useful for strategic planning, provided the estimates are adjusted for greater uncertainty.

The right time horizon depends on your business. A freelancer with irregular customer payments may benefit from a weekly forecast, while a more established business may combine a weekly short-term forecast with a monthly outlook.

Why Do Small Businesses Need a Cash Flow Forecast?

A profit-and-loss report can help you understand financial performance, but it doesn't necessarily tell you whether you will have enough cash available on a particular date.

A forecast helps answer a different question:

Will my business have enough cash to cover its expected payments when they become due?

It can help you:

• Identify potential cash shortages before they happen.
• Understand when customer payments are expected.
• Plan supplier, contractor, and payroll payments.
• Decide whether a large purchase is affordable.
• Prepare for seasonal changes in revenue.
• Estimate how much money may need to remain in reserve.
• Evaluate whether a new project could create short-term cash pressure.
• Make more informed decisions about hiring and expansion.

A forecast is not a guarantee. Customers can pay late, expenses can change, and unexpected events can occur.

Its value comes from making assumptions visible so you can update them when circumstances change.

Cash Flow Forecast vs. Cash Flow Statement

These terms are related, but they serve different purposes.

You need both perspectives.

A forecast helps you prepare for what may happen. A cash flow statement helps you understand what actually happened.

Comparing your forecast with actual results also helps you improve future estimates.

Step 1: Choose Your Forecast Period

Before collecting numbers, decide how far into the future you want to forecast.

For many small businesses, a rolling 13-week forecast is a useful starting point. It provides a view of the next three months while keeping the period short enough for practical estimates.

However, you don't need to begin with 13 weeks.

A four-week forecast can be enough to get started.

Choose a period that answers your immediate questions.

For example:

• Do I have enough cash to cover next month's expenses?
• Can I afford to purchase new equipment?
• Will a delayed customer payment create a shortage?
• How much cash should I keep available before taking on another project?

If you have irregular customer payments or limited cash reserves, use weekly periods so that payment timing remains visible.

If your business has predictable monthly income and expenses, monthly periods may be sufficient for a broader planning view.

Step 2: Record Your Current Cash Balance

Start with the cash currently available to your business.

Review the relevant business bank accounts and cash balances as of a specific date.

For example:

Only include balances that are genuinely available for the purpose of your forecast.

If some funds are restricted or reserved for specific obligations, account for that distinction separately.

For example, money reserved for upcoming tax payments should not automatically be treated as freely available for discretionary spending.

Your opening balance should reflect the actual position at the beginning of the forecast period.

Step 3: List Expected Cash Inflows

Next, estimate the cash your business expects to receive during each forecast period.

Possible inflows include:

• Payments from existing customers
• Deposits for new projects
• Milestone payments
• Recurring service payments
• Other operating receipts
• Financing proceeds, where relevant
• Other expected cash receipts

For an invoicing business, customer payments are often the most important inflow to forecast.

However, be careful not to confuse invoices issued with payments received.

An invoice tells you that a customer owes you money. It does not guarantee that the money will arrive on a particular date.

Example: Forecasting Customer Payments

Suppose you have three outstanding invoices:

The expected collection dates are estimates based on your current information and customer payment history.

The second invoice is expected to arrive later than its due date because that customer typically takes additional time to process payments.

This gives you a more realistic forecast than assuming every customer will pay on the contractual due date.

Use Evidence, Not Optimism

When estimating customer payments, consider:

• Whether the invoice has been approved.
• Whether the customer has confirmed a payment date.
• Whether the invoice is disputed.
• Whether the customer has paid late in the past.
• Whether additional documentation is required.
• Whether the payment depends on a project milestone.

You can classify expected receipts as confirmed, likely, or uncertain.

This helps distinguish money that is reasonably expected from money that may not arrive on time.

Step 4: Include New Sales Carefully

Your business may expect to win new customers or start new projects during the forecast period.

These opportunities can affect your future cash position, but avoid treating every sales opportunity as guaranteed cash.

Consider three categories:

Confirmed work: The customer has agreed to the project, and the payment schedule is known.

Likely work: The opportunity appears promising, but some uncertainty remains.

Potential work: The customer has expressed interest but hasn't committed.

Include confirmed work where the payment schedule is reasonably understood. Treat less certain opportunities separately or use them in an optimistic scenario.

For example, if a potential $10,000 project hasn't been approved, don't rely on that payment to cover an essential supplier bill next week.

A useful forecast should remain practical even if an uncertain sale doesn't happen.

Step 5: List Expected Cash Outflows

Now estimate the cash your business expects to pay during each period.

Common outflows include:

• Employee wages
• Contractor payments
• Supplier bills
• Rent
• Software subscriptions
• Insurance
• Marketing expenses
• Equipment purchases
• Loan repayments
• Taxes
• Other operating costs

Use actual payment dates wherever possible.

For example, if a supplier invoice is due on October 22, include it in the period containing October 22.

Don't simply divide monthly expenses evenly across four weeks if the actual payments fall on specific dates.

A business can have enough cash over an entire month but still face a shortage during one particular week.

Separate Fixed and Variable Expenses

Fixed expenses are relatively predictable.

Examples include rent, recurring software subscriptions, and certain insurance premiums.

Variable expenses can change with sales or business activity.

Examples include project materials, contractor costs, shipping, and some marketing expenses.

Separate these categories so you can identify which costs are relatively certain and which require estimates.

Step 6: Account for Taxes and Other Commitments

One common forecasting mistake is forgetting payments that don't occur every week.

Examples include:

• Quarterly tax payments
• Annual insurance renewals
• Loan repayments
• Equipment financing
• Annual software subscriptions
• Professional fees
• Contractual deposits
• Other irregular obligations

These payments can have a significant effect on your cash position.

Add known obligations to the relevant forecast period rather than spreading them evenly across the year unless you are specifically building a separate accrual or budgeting view.

If tax amounts are uncertain, use a reasonable estimate based on your available records and consult a qualified tax professional where necessary.

Step 7: Calculate Your Projected Closing Cash

Once you have listed expected inflows and outflows, calculate the closing cash balance for each period.

The basic formula is:

Closing Cash = Opening Cash + Expected Cash Inflows − Expected Cash Outflows

Then carry that closing balance forward as the next period's opening balance.

Example: A Four-Week Cash Flow Forecast

Suppose a small business begins October with $12,000.

It expects the following cash movements:

The closing balance at the end of Week 4 is projected to be $9,000.

Although the business ends the period with a positive balance, its cash decreases overall from $12,000 to $9,000.

That may be manageable, but it deserves attention if the decline is part of a continuing trend.

The business should also check whether any individual week has a projected balance below the minimum amount it needs to operate safely.

Step 8: Identify Your Minimum Cash Requirement

A positive cash balance doesn't automatically mean your business is financially comfortable.

You may need a minimum amount of cash to cover essential expenses, unexpected costs, and payment delays.

Start by estimating your essential short-term obligations.

For example:

In this example, a projected balance of $9,500 leaves only $500 above the indicative minimum.

That doesn't necessarily mean the business has a problem, but it shows that a small unexpected expense or delayed receipt could create pressure.

Your minimum cash requirement should reflect your business model, payment timing, risk tolerance, and financial obligations.

Step 9: Identify Potential Cash Shortages

Once your forecast is complete, review each period for possible problems.

Ask:

• Does the projected cash balance fall below the minimum required?
• Are several large payments due in the same week?
• Are important customer payments uncertain?
• Is too much cash dependent on one customer?
• Are expenses arriving before expected receipts?
• Is the cash balance declining consistently?

The goal is to identify the issue early enough to respond.

For example, if your forecast shows a potential shortage in Week 3, you might have time to follow up on outstanding invoices, discuss an appropriate payment schedule with a supplier, or reconsider the timing of a discretionary purchase.

The options available depend on your agreements and business circumstances.

Don't wait until the bank balance is nearly empty to review your forecast.

Step 10: Create Three Forecast Scenarios

One forecast is useful, but it may rely on assumptions that don't turn out as expected.

A better approach is to prepare three scenarios.

Base Case

This represents your most realistic estimate using current information.

It should reflect expected customer payment dates and known expenses.

Optimistic Case

This assumes some favorable outcomes, such as customers paying on time or a confirmed project generating cash earlier than expected.

Don't treat this as the amount you can safely spend.

Conservative Case

This assumes some customers pay late, new work starts later than expected, or certain costs increase.

The conservative case helps you understand how vulnerable your cash position may be.

Example

Suppose your projected closing cash for November is $15,000 in the base case.

These figures are illustrative.

The purpose of scenario planning is to identify how sensitive your cash position is to changes in customer behavior and business expenses.

If the conservative scenario produces a cash shortage, consider what actions would be available if those delays actually occur.

Step 11: Compare Forecasts With Actual Results

A forecast becomes more useful when you regularly compare it with what happened.

At the end of each week, review:

• Expected customer payments versus actual receipts
• Expected expenses versus actual payments
• Projected cash balance versus actual balance
• Payments that arrived earlier or later than expected
• Unplanned expenses

For example, suppose you forecast $5,000 in customer payments for the week, but only $2,000 arrives.

Don't simply change the forecast and move on.

Find out why the difference occurred.

Perhaps a customer needed an additional purchase order number, a payment was delayed by an internal approval process, or an invoice was disputed.

Understanding the cause can improve your future estimates.

If the same customer consistently pays late, adjust your collection assumptions accordingly.

Step 12: Update the Forecast Regularly

A cash flow forecast is not a document you create once and forget.

It should change as new information becomes available.

Update it when:

• A customer pays an invoice.
• An invoice becomes overdue.
• A new project is confirmed.
• A supplier changes its payment schedule.
• You approve a major purchase.
• An unexpected expense occurs.
• Your revenue expectations change.

A rolling forecast is particularly useful.

When one week ends, replace it with the next week in the future. This keeps the forecast focused on the coming period rather than becoming outdated.

The frequency of updates depends on how quickly your business's financial position changes.

How to Forecast Cash Flow When You Have Unpaid Invoices

Unpaid invoices are one of the most important considerations in a small-business forecast.

Start by listing every outstanding invoice and its expected collection date.

Then consider the reliability of each estimate.

For example:

The last invoice may eventually be paid, but relying on it as a certain receipt could make your forecast misleading.

The goal isn't to assume every overdue invoice is uncollectible. It is to reflect uncertainty honestly.

You should also avoid counting the same payment twice. Once an invoice is paid, record the actual receipt and remove the corresponding expected receipt from future periods.

How Payment Terms Affect Your Forecast

Payment terms influence when you expect money to arrive.

Suppose you issue a $6,000 invoice on October 17 with payment due in 30 days.

The contractual due date is around mid-November, depending on the applicable date-counting terms.

If your customer usually takes another week to process payment, your realistic cash forecast may place the receipt later.

This difference matters when you have expenses due in early November.

For future projects, consider whether your payment terms and billing schedule are compatible with your cash needs.

Where appropriate, deposits, milestone invoices, or shorter agreed payment periods may improve cash timing.

However, any changes should be agreed upon with customers and documented appropriately.

How to Forecast Cash Flow When Revenue Is Irregular

Freelancers, contractors, and consultants may not receive the same amount every month.

One month may include a large project payment, while the next has only smaller recurring receipts.

In this situation, avoid assuming that your latest month's revenue will continue unchanged.

Instead:

1. Review several months of historical receipts.
2. Identify recurring customers and contracts.
3. List confirmed future projects.
4. Record expected invoice dates.
5. Estimate realistic payment dates.
6. Include known seasonal changes.
7. Prepare a conservative scenario.

If you are starting a new business and have little historical information, your estimates will be less reliable.

Start with confirmed contracts, known expenses, and clearly documented assumptions. Update the forecast as actual results become available.

How Invoice Factory Can Support Your Forecasting Routine

Invoice Factory helps freelancers, contractors, and small businesses create invoices, manage clients, and track invoice status and outstanding amounts.

These records can provide useful inputs for a cash flow forecast.

For example, you can review:

• Which invoices remain unpaid
• Which amounts are outstanding
• Which invoices are overdue
• How revenue is changing
• How cash-flow summaries are trending
• How profit and loss compares over time

Invoice Factory also provides dashboard views for revenue, cash flow, profit and loss, invoice status, and outstanding comparisons.

These views can help you review your business's financial activity and identify areas that need attention.

However, a dashboard summary and a forward-looking forecast are not necessarily the same thing. A forecast requires estimates of future payment dates, expenses, and other cash movements.

You can use the information in Invoice Factory as part of your planning process, then maintain a separate forecast if you need a detailed weekly projection.

The objective is to connect the information you already have about your invoices and finances with a practical plan for upcoming cash requirements.

A Simple Cash Flow Forecast Template

You can begin with a spreadsheet using the following structure.

The numbers are illustrative.

You can adapt this structure to your own business and include additional rows for taxes, loans, equipment purchases, or other significant transactions.

For each period, calculate:

Total Inflows = Sum of Expected Cash Receipts

Total Outflows = Sum of Expected Cash Payments

Closing Cash = Opening Cash + Total Inflows − Total Outflows

Then use each period's closing cash as the next period's opening cash.

For better accuracy, include expected payment dates and distinguish confirmed receipts from uncertain ones.

Common Cash Flow Forecasting Mistakes

1. Assuming Every Invoice Will Be Paid on Time

Customers may pay late, even when your invoices are accurate.

Better approach: Use payment history and customer confirmations to estimate realistic receipt dates.

2. Counting Sales as Cash

A new sale doesn't necessarily produce immediate cash.

Better approach: Forecast when the customer is expected to pay, not just when the sale is recorded.

3. Forgetting Irregular Expenses

Annual renewals, quarterly taxes, and equipment purchases can create significant cash outflows.

Better approach: Add known commitments to the relevant forecast periods.

4. Making Unrealistic Revenue Assumptions

An unconfirmed sales opportunity should not be treated as guaranteed cash.

Better approach: Separate confirmed work from uncertain opportunities.

5. Ignoring the Timing of Payments

Monthly totals can hide a shortage during a particular week.

Better approach: Use weekly periods when payment timing is important.

6. Failing to Update the Forecast

An old forecast may no longer reflect the actual business position.

Better approach: Update it when payments, expenses, and business expectations change.

7. Confusing Profit With Cash

A profitable month does not guarantee that sufficient cash is available on every date.

Better approach: Review profit and loss alongside your cash flow forecast.

8. Forgetting to Account for Existing Obligations

Cash in the bank may already be committed to expenses or other obligations.

Better approach: Include known commitments and maintain a suitable reserve.

A Weekly Cash Flow Forecasting Routine

A simple routine can keep your forecast useful without making it unnecessarily complicated.

Step 1: Check the current balance

Record your actual opening cash position.

Step 2: Review incoming payments

Check expected receipts, outstanding invoices, and customer payment updates.

Step 3: Review upcoming expenses

Include supplier bills, payroll, subscriptions, taxes, and other known obligations.

Step 4: Update expected dates

Move uncertain payments to more realistic dates when new information becomes available.

Step 5: Recalculate projected cash

Check the closing balance for every period.

Step 6: Identify risks

Look for periods where projected cash falls below your minimum requirement.

Step 7: Decide on actions

Follow up on overdue invoices, review discretionary spending, or investigate alternative arrangements where appropriate.

Step 8: Compare actual results

At the end of the period, compare the forecast with actual receipts and payments.

This process helps you improve the forecast over time.

What Should You Do if Your Forecast Shows a Cash Shortage?

A projected cash shortage is a warning that gives you an opportunity to prepare.

Start by identifying the date and estimated size of the shortfall.

Then investigate the main causes.

Are customer payments delayed? Contact customers to confirm payment status and resolve missing documentation or disputes.

Are several expenses due at once? Review whether payment timing can be adjusted through an agreed arrangement.

Is a discretionary purchase creating pressure? Consider postponing it if doing so will not harm essential operations.

Is the shortage recurring? Review pricing, margins, customer concentration, payment terms, and the business model.

Is additional funding necessary? Evaluate available options carefully, including their costs and repayment requirements.

Don't assume that every customer will pay early or that every expense can be postponed. Use realistic information and honor your contractual obligations.

If your business repeatedly struggles to cover essential payments, consider consulting an accountant or qualified financial adviser.

Final Thoughts

A cash flow forecast gives you a clearer picture of how money is expected to move through your business.

Instead of relying only on your current bank balance, you can estimate future receipts, plan expenses, and identify potential shortages before they become urgent.

Start with a simple process:

• Record your current cash balance.
• List expected customer payments.
• Include known expenses and commitments.
• Calculate projected closing cash.
• Identify periods of potential shortage.
• Prepare conservative scenarios.
• Update the forecast regularly.
• Compare forecasts with actual results.

Your estimates will not always be correct. The important part is to make reasonable assumptions, track what changes, and update your plans accordingly.

For freelancers, contractors, and small businesses, this can turn cash flow planning from an occasional reaction into a regular management habit.

Invoice Factory can support the process by helping you manage invoices, track outstanding amounts, and review financial dashboard information. Combine those records with a forward-looking forecast to understand both what your business has earned and what cash it may need in the weeks ahead.

The purpose of forecasting isn't to predict every transaction perfectly. It's to give yourself enough time and information to make better decisions.

Frequently Asked Questions

What is a cash flow forecast?

A cash flow forecast estimates future cash inflows, cash outflows, and closing balances over a specific period. It helps businesses anticipate cash shortages and plan upcoming expenses.

How do I create a cash flow forecast for a small business?

Start with your current cash balance, list expected customer payments, estimate expenses, calculate the closing balance for each period, and carry that balance forward. Review the forecast regularly and update it as circumstances change.

How far ahead should I forecast cash flow?

A four-week forecast is a practical starting point. Many businesses use a rolling 13-week forecast for short-term planning, while monthly and longer-term forecasts can help with broader budgeting.

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

A budget generally sets financial targets for revenue and spending over a period. A cash flow forecast estimates when cash is expected to enter and leave the business. A budget may show that a business expects to be profitable, while a cash flow forecast reveals whether money will be available when bills are due.

Should unpaid invoices be included in a cash flow forecast?

Yes, expected customer payments can be included, but they should be placed in the period when you realistically expect to receive them. Overdue or disputed invoices should be treated cautiously rather than assumed to be guaranteed cash.

How often should I update my cash flow forecast?

Weekly updates are useful for businesses with irregular receipts or tight cash positions. Businesses with more predictable finances may update less frequently, but should revise their estimates whenever significant changes occur.

Can a cash flow forecast predict financial problems?

It can help identify potential problems by showing when projected cash may fall below the amount needed to meet obligations. Its usefulness depends on the accuracy of the assumptions and how regularly it is updated.

Can I create a cash flow forecast in a spreadsheet?

Yes. A spreadsheet with opening cash, expected inflows, expected outflows, and closing cash is sufficient for a basic forecast. You can add payment dates, customer names, confidence levels, and different scenarios as your needs grow.

How does invoicing software help with cash flow forecasting?

Invoicing software can help organize invoice amounts, due dates, payment status, and outstanding balances. These records provide useful inputs for estimating customer receipts, although a detailed forecast may require additional information about future expenses and payment timing.

What is the biggest mistake in cash flow forecasting?

One common mistake is assuming that every invoice will be paid on its due date. Realistic collection estimates, regular updates, and conservative scenarios can make the forecast more useful for decision-making.