How to Create a Cash Flow Forecast for Your Small Business

Small business cash flow forecast

A small business cash flow forecast helps you estimate when money will come in, when bills must be paid, and how much cash may remain during a future period. Consequently, you can identify potential shortfalls earlier, prepare for major expenses, and make more informed decisions about hiring, purchasing, and growth.

Even a profitable business can experience a cash shortage when customers pay late or expenses fall due before sales revenue arrives. Therefore, a practical forecast should focus on the timing of cash movements—not simply the revenue or profit shown in your accounting reports.

What Is a Small Business Cash Flow Forecast?

A cash flow forecast is an estimate of the money your business expects to receive and pay during a future period. It uses your current cash balance, expected receipts, planned payments, and reasonable assumptions to estimate how much cash may remain at the end of each period.

For example, a service business may expect to invoice customers this month but collect some payments next month. Meanwhile, payroll, rent, software subscriptions, and loan payments may become due before those customers pay. A forecast helps the owner see that timing difference in advance.

The U.S. Small Business Administration recommends using financial projections to explain expected revenue and expenses and support business planning. Review its guidance on growing your business.

Cash Flow vs. Profit: Why the Difference Matters

Profit and cash flow are related, but they do not measure the same thing. A profit and loss statement summarizes revenue and expenses for a reporting period. A cash flow forecast, by contrast, estimates when money will actually enter or leave your bank accounts.

Consider a business that completes a $10,000 project in October and sends the customer an invoice due in 30 days. Depending on its accounting method and circumstances, the business may recognize revenue before receiving the payment. However, it still needs enough available cash to cover expenses due in October.

Similarly, purchasing equipment may require a substantial cash payment even when the accounting treatment spreads the cost over time. For this reason, owners should review cash projections alongside profit and loss reports and other financial records.

The IRS explains the importance of maintaining accurate business records in its small-business recordkeeping guidance. For additional context, read our guide to business bank reconciliation, which explains why accurate bank records matter when assessing available cash.

Small Business Cash Flow Forecast: Build Yours Step by Step

A useful forecast does not need to begin with complicated software. Instead, start with reliable records, a clear time period, and a consistent method.

Step 1: Choose Your Small Business Cash Flow Forecast Period

First, select a time frame that matches the decision you need to make.

• Weekly forecast: Useful when cash is tight, receipts fluctuate, or major payments are approaching.
• 13-week forecast: Helpful for monitoring near-term liquidity and planning upcoming obligations.
• Monthly forecast: Useful for routine budgeting, seasonal planning, and reviewing longer-term trends.
• Longer-term projection: Helpful when evaluating expansion, equipment purchases, financing, or major operational changes.

The appropriate period depends on your business. A seasonal retailer may need to plan months ahead, while a business facing an immediate cash shortage may need a detailed weekly view. Moreover, you can maintain more than one forecast if each serves a distinct purpose.

Step 2: Confirm Your Starting Cash Balance

Next, establish the cash available at the beginning of your forecast period. Start with current bank balances and reconcile them against outstanding transactions. Then account for checks or electronic payments that have not cleared, deposits in transit, and other known timing differences.

However, do not automatically treat every available credit facility or expected loan as existing cash. Record financing proceeds only when the timing and likelihood of receipt are sufficiently supported. Your opening balance should reflect the cash you reasonably expect to have available—not an optimistic estimate.

Step 3: Estimate Expected Cash Inflows

After confirming the opening balance, list the cash you expect to receive during each period. Common inflows include:

• Customer payments on outstanding invoices
• Expected cash and card sales after applicable settlement timing
• Deposits and milestone payments
• Collection of overdue balances
• Loan proceeds or other financing, when sufficiently confirmed
• Other business receipts supported by a reasonable expectation

Use invoice due dates, customer payment history, signed contracts, sales patterns, and realistic collection assumptions. In addition, distinguish between an invoice issued and a payment actually expected during the forecast period. For instance, if a customer usually pays 30 days after receiving an invoice, forecasting the full amount in the invoice month may overstate available cash. When uncertainty is high, use a conservative estimate and document the assumption.

Step 4: List Expected Cash Outflows

Then estimate when your business will need to pay its obligations. Include both recurring and irregular costs, such as:

• Payroll, employer taxes, and employee benefits
• Rent, utilities, insurance, and subscriptions
• Inventory, supplies, and vendor invoices
• Loan principal and interest payments
• Sales tax obligations and other applicable business tax payments
• Equipment purchases and planned improvements
• Owner draws or distributions, where applicable
• Seasonal costs, renewals, and annual fees

Also, review payment terms and actual due dates. A bill recorded in your accounting system may not be paid until a later period, while a recurring payment may occur sooner than expected. Consequently, accurate bookkeeping is essential to a useful forecast. See the SBA’s guidance on managing your business finances.

Step 5: Calculate Your Projected Ending Cash

Once you have estimated inflows and outflows, calculate the projected cash balance for each period.

For example, suppose a business begins a month with $18,000, expects $32,000 in receipts, and anticipates $41,000 in payments.

In this simplified example, the business ends the month with a projected $9,000 cash balance. However, the owner should also examine the timing of receipts and payments within the month. A positive month-end balance does not rule out a cash shortage earlier in the period. These figures are illustrative only, not industry benchmarks or a prediction of business results.

Step 6: Test Different Scenarios

A forecast is more useful when it considers uncertainty. Therefore, prepare alternative scenarios when customer payments, sales, costs, or financing remain uncertain.

• Expected case: Uses the most reasonable assumptions supported by current information.
• Conservative case: Assumes slower collections, lower sales, or higher costs where those risks are plausible.
• Improved case: Reflects stronger collections or sales only when there is a reasonable basis for that outcome.

For example, ask what happens if a major customer pays two weeks late, a supplier raises prices, or a planned equipment purchase occurs earlier than expected. These scenarios help you identify decisions you may need to make. They do not eliminate uncertainty; rather, they make the consequences easier to evaluate.

Step 7: Decide What to Do About Potential Shortfalls

If your forecast shows that cash may fall below the amount needed to operate comfortably, address the issue early. Depending on your circumstances, you might:

• Follow up on overdue invoices and clarify customer payment dates.
• Review discretionary purchases and the timing of planned investments.
• Discuss reasonable payment terms with suppliers before bills become overdue.
• Adjust the timing of hiring or expansion plans.
• Evaluate financing options before a cash shortage becomes urgent.
• Seek professional guidance when obligations, tax matters, or forecasts are difficult to assess. Our article on business tax advisory explains when specialized tax guidance may help.

However, do not assume that delaying a payment is always appropriate. Payroll, tax obligations, loan terms, and supplier contracts can carry specific requirements. Evaluate the consequences before changing a payment plan. A forecast should support timely decisions—not encourage you to ignore obligations.

A Simple Cash Flow Forecast Example

Imagine a small business with a starting cash balance of $12,000. The owner expects customer receipts of $20,000 and cash payments of $25,000 during the first month. In the following month, the business expects $28,000 in receipts and $24,000 in payments.

The first month ends with a projected $7,000 balance. That amount becomes the opening balance for the second month, assuming no additional cash movements or adjustments. Although the second month improves the projected balance, the owner should still confirm that the business can cover every payment when it falls due. If a major payment arrives before expected customer receipts, the business may need a short-term plan even when the monthly forecast looks positive.

How Often Should You Update Your Forecast?

Update your forecast regularly and whenever a significant change affects expected cash. For many small businesses, a monthly review provides a useful baseline. Nevertheless, weekly updates may be more appropriate when cash is tight, sales are volatile, or large obligations are approaching.

During each review:

1. Compare actual receipts and payments with the previous forecast.
2. Identify important differences and determine why they occurred.
3. Update expected collection dates, sales, costs, and payment dates.
4. Review the lowest projected cash balance during the period.
5. Record assumptions and assign responsibility for follow-up actions.

Furthermore, use the updated forecast to inform budgeting and operating decisions. A forecast that is never reviewed will become less useful as conditions change. If you need to strengthen the underlying records, our guide to business expenses and accurate records can help you organize information for better financial planning.

Common Cash Flow Forecasting Mistakes

Even a simple spreadsheet can produce misleading results when the underlying assumptions are weak. Watch for these common problems:

• Treating invoices as cash received: An issued invoice does not mean the customer has paid.
• Ignoring payment timing: Monthly totals can hide a shortage that occurs earlier in the month.
• Forgetting irregular expenses: Insurance renewals, equipment purchases, taxes, and annual fees can materially affect cash.
• Using unsupported sales estimates: Forecast assumptions should reflect evidence, not only hoped-for growth.
• Overlooking financing costs: Loan payments, fees, and repayment dates can affect available funds.
• Failing to update the forecast: Actual results should inform future projections.
• Confusing profit with cash availability: Profitability does not automatically mean cash is available when bills fall due.

Ultimately, the goal is not to predict every transaction perfectly. Instead, build a forecast that is transparent, realistic, and easy to update as new information becomes available.

Frequently Asked Questions

What is a small business cash flow forecast?

A small business cash flow forecast estimates the money a business expects to receive and pay during a future period. It helps owners assess projected cash balances, plan for obligations, and identify potential shortfalls.

How far ahead should I forecast cash flow?

The appropriate period depends on your business and the decisions you need to make. A weekly or 13-week forecast can help monitor near-term cash needs, while monthly projections can support budgeting and longer-term planning. You should choose a period that reflects the timing of your receipts and obligations.

Can a profitable business still run out of cash?

Yes. A business may record revenue before customers pay, while payroll, suppliers, rent, and other bills may be due sooner. Therefore, owners should monitor cash timing as well as profit.

What information do I need to create a cash flow forecast?

Start with your current cash balance, outstanding customer invoices, expected sales receipts, vendor bills, payroll, taxes, loan payments, recurring costs, and planned purchases. In addition, use payment dates and realistic assumptions to estimate when each transaction will affect cash.

Should I use a spreadsheet or accounting software?

Either can work. A spreadsheet may be sufficient for a straightforward business, while accounting software or a more structured model can help manage complex transactions and recurring updates. Choose a system that you can maintain accurately and review consistently.

How can professional bookkeeping help with cash flow forecasting?

Reliable bookkeeping helps organize transactions, reconcile accounts, track receivables and payables, and produce financial reports. As a result, you can build a forecast using more dependable information and identify differences between expected and actual cash movements.

Final Thoughts

A practical small business cash flow forecast gives you a clearer view of what may happen to your available cash before the next bills arrive. By confirming your opening balance, estimating receipts and payments, testing scenarios, and reviewing actual results, you can make more informed decisions about day-to-day operations and future growth.

Most importantly, keep the forecast current and base it on reliable records. When you identify a potential shortfall early, you have more time to evaluate your options and prepare an appropriate response.

Disclaimer: This article provides general educational information and is not individualized accounting, tax, legal, or financial advice. Your business’s needs and obligations may vary. Consult an appropriate professional about your specific circumstances.