Updated for 2026 by the EasyFinance.com editorial team • Small-business financial planning guidance • Forecasts are estimates and should be updated with actual results
Cash Flow Forecasting for Small Businesses: A Practical Step-by-Step Guide
Cash flow forecasting estimates how much money a business expects to receive and pay over a future period. A well-maintained forecast can reveal when the company may run short of cash, when additional working capital could be needed, and when the business may be able to invest, hire, purchase inventory, or repay debt.
Quick answer: To create a cash flow forecast, begin with the opening cash balance, estimate when customer payments and other cash inflows will actually arrive, list payroll, suppliers, rent, taxes, debt payments, and other cash outflows by date, and calculate the projected closing balance for each week or month. Update the forecast regularly by replacing estimates with actual results and revising future assumptions.
A forecast is not a promise that a particular outcome will occur. It is a decision-making tool built from current information, historical patterns, contracts, payment behavior, and clearly documented assumptions.
Table of Contents
- What Is a Cash Flow Forecast?
- Why Cash Flow Forecasting Matters
- Cash Flow vs. Profit
- Cash Flow Forecast Formula
- 13-Week vs. 12-Month Cash Flow Forecasts
- How to Create a Cash Flow Forecast
- Forecasting Cash Inflows
- Forecasting Cash Outflows
- Cash Flow Forecast Example
- Best-, Base-, and Worst-Case Scenarios
- What Does a Cash Flow Forecasting Tool Do?
- How to Choose Forecasting Software
- Benefits of Cash Flow Forecasting
- What to Do When a Cash Shortfall Is Forecast
- Cash Flow Forecasts and Business Financing
- Invoice Factoring and Working-Capital Gaps
- Common Cash Flow Forecasting Mistakes
- Cash Flow Forecast Checklist
- Frequently Asked Questions
What Is a Cash Flow Forecast?
A cash flow forecast, also called a cash flow projection, estimates the movement of cash into and out of a business over a future period. It normally shows:
- The opening cash balance
- Expected cash receipts
- Expected cash payments
- Net cash flow for the period
- The projected closing cash balance
A forecast may be prepared daily, weekly, monthly, quarterly, or annually. The appropriate level of detail depends on the company’s size, cash position, payment cycles, and financial risk.
The U.S. Small Business Administration identifies cash flow projections as part of managing business finances, while FDIC and SBA small-business education materials describe cash flow management as an essential business competency.
Cash Flow Forecast vs. Cash Flow Statement
| Cash Flow Forecast | Cash Flow Statement |
|---|---|
| Looks forward | Reports historical cash movement |
| Uses estimates and assumptions | Uses completed accounting records |
| Supports planning and early warnings | Explains what happened during a completed period |
| Changes when assumptions change | Changes only when records are corrected or reclassified |
| May be prepared weekly or monthly for management | Is commonly presented as a formal financial statement for a historical period |
Use historical statements to improve the assumptions in the forecast. Customer payment patterns, seasonal sales, payroll timing, supplier terms, and tax dates can make future estimates more realistic.
Why Is Cash Flow Forecasting Important?
A profitable company can still experience a cash shortage. Sales may be recorded before customers pay, inventory may require upfront cash, or taxes and payroll may become due before expected receipts arrive.
A cash flow forecast can help a business:
- Identify future cash shortages before bills become overdue
- Schedule payroll and supplier payments
- Plan inventory purchases
- Prepare for taxes and debt payments
- Decide when hiring or expansion is affordable
- Determine whether external financing may be needed
- Evaluate the effect of slower customer payments
- Compare alternative business scenarios
- Set minimum cash-reserve targets
A forecast does not prevent a cash-flow crisis by itself. Management must review the warning and take action before the projected shortage occurs.
Cash Flow Is Not the Same as Profit
Profit is generally calculated by subtracting recognized expenses from recognized revenue. Cash flow measures the actual movement of money.
The two can differ because:
- A sale may be recorded before the customer pays.
- Inventory may be purchased before it is sold.
- A loan provides cash but is not operating revenue.
- Loan principal repayments use cash but are not always treated as an expense on the income statement.
- Depreciation reduces accounting profit but does not require a current cash payment.
- Equipment purchases use cash but may be recognized as an asset rather than an immediate expense.
- Taxes may be paid in a different period from the income that created them.
Example: Profitable but Short of Cash
A business invoices a customer for $40,000 in March and records the revenue. The customer is permitted to pay in 60 days, so the cash may not arrive until May. If payroll, rent, suppliers, and taxes totaling $35,000 must be paid in April, the company can report a profit while still lacking enough cash to meet April obligations.
Cash Flow Forecast Formula
A basic cash flow forecast uses the following calculations:
Net cash flow = Total cash inflows − Total cash outflows
Closing cash balance = Opening cash balance + Net cash flow
The closing balance from one period normally becomes the opening balance for the next period.
Simple Example
- Opening cash balance: $20,000
- Expected cash inflows: $45,000
- Expected cash outflows: $52,000
- Net cash flow: â$7,000
- Projected closing balance: $13,000
The company remains cash-positive in this example, but the declining balance may require management attention if the trend continues.
13-Week vs. 12-Month Cash Flow Forecasts
Businesses often benefit from maintaining more than one forecasting horizon.
| Forecast Type | Best Used For | Typical Detail |
|---|---|---|
| Daily forecast | Severe liquidity pressure, restructuring, or highly volatile cash | Individual receipts and payments |
| 13-week forecast | Short-term working-capital and liquidity management | Weekly customer receipts, payroll, suppliers, taxes, and debt |
| 12-month forecast | Seasonality, annual budgeting, hiring, inventory, and financing | Monthly categories and assumptions |
| Three-year projection | Business plans, investment decisions, and long-term financing | Monthly, quarterly, or annual estimates |
Why Use a 13-Week Forecast?
A rolling 13-week forecast covers approximately one quarter and provides enough detail to manage near-term payments while still showing problems early enough to respond.
It can help identify:
- Which week payroll may create a deficit
- Whether a large customer payment is arriving too late
- When tax payments are due
- Whether suppliers need revised payment dates
- How much working capital may be required
Why Use a 12-Month Forecast?
A 12-month forecast can reveal seasonality and the longer-term effects of pricing, hiring, capital spending, and sales assumptions. SCORE provides 12-month and longer-term cash flow templates for small-business planning.
How to Create a Cash Flow Forecast in 9 Steps
1. Choose the Forecast Period
Select daily, weekly, or monthly periods based on the company’s needs. A business under cash pressure usually requires more detail than a company with a large reserve and predictable receipts.
2. Enter the Opening Cash Balance
Use cash that is genuinely available at the start of the period. Consider whether any amount is restricted or reserved for a specific purpose.
3. Estimate Customer Cash Receipts
Forecast when invoices will be paid, not merely when sales will be recorded. Use actual payment history where available.
4. Add Other Cash Inflows
Include financing, owner contributions, tax refunds, asset sales, grants, and other receipts separately from operating sales.
5. List Fixed Cash Outflows
Enter recurring obligations such as rent, salaries, insurance, software, and debt payments.
6. Estimate Variable Cash Outflows
Estimate inventory, materials, commissions, shipping, transaction fees, utilities, and other costs that vary with activity.
7. Add Irregular and One-Time Payments
Include taxes, annual insurance premiums, equipment purchases, bonuses, repairs, legal costs, and other payments that are easy to overlook.
8. Calculate Net Cash Flow and Closing Balance
Subtract the period’s outflows from inflows and add the result to the opening cash balance.
9. Compare Forecast With Actual Results
At the end of each period, replace estimates with actual amounts. Record the variance and update future assumptions.
How to Forecast Cash Inflows
Cash inflows should be forecast according to expected receipt dates.
Common Cash Inflows
- Cash sales
- Customer invoice payments
- Subscription receipts
- Loan proceeds
- Owner contributions
- Investor funding
- Grants
- Tax refunds
- Insurance proceeds
- Sale of equipment or other assets
- Interest or investment income
Forecast Customer Payments Realistically
Do not automatically assume that every invoice will be paid on its due date. Group customers according to payment behavior, for example:
- Customers who usually pay early
- Customers who pay close to the due date
- Customers who regularly pay 15 to 30 days late
- High-risk or disputed invoices
Separate uncertain receipts from committed receipts. A signed sales contract does not necessarily mean that cash will arrive immediately.
How to Forecast Cash Outflows
Common Operating Cash Outflows
- Payroll and payroll taxes
- Supplier and contractor payments
- Inventory and raw materials
- Rent and utilities
- Insurance
- Software and subscriptions
- Marketing and advertising
- Shipping and fulfillment
- Professional fees
- Sales and income taxes
- Loan principal and interest
- Equipment purchases
- Owner distributions
Use the Actual Payment Date
A cost may appear on an income statement in one month but be paid in another. The cash forecast should reflect when the money is expected to leave the bank account.
Separate Essential and Deferrable Payments
Categorizing payments can help management respond to a projected shortage.
| Priority | Examples |
|---|---|
| Critical | Payroll, payroll taxes, essential suppliers, required insurance, and debt obligations |
| Important | Inventory replenishment, maintenance, key software, and marketing tied to measurable revenue |
| Potentially deferrable | Optional upgrades, discretionary travel, nonessential equipment, and some expansion projects |
Do not delay taxes, wages, or contractual payments without understanding legal and business consequences.
Monthly Cash Flow Forecast Example
| Cash Flow Category | January | February | March |
|---|---|---|---|
| Opening cash balance | $25,000 | $21,000 | $13,500 |
| Customer receipts | $48,000 | $44,000 | $58,000 |
| Other inflows | $2,000 | $0 | $0 |
| Total inflows | $50,000 | $44,000 | $58,000 |
| Payroll | $24,000 | $24,000 | $24,000 |
| Suppliers and inventory | $16,000 | $18,000 | $20,000 |
| Rent and overhead | $8,000 | $8,000 | $8,000 |
| Taxes and debt payments | $6,000 | $1,500 | $4,000 |
| Total outflows | $54,000 | $51,500 | $56,000 |
| Net cash flow | â$4,000 | â$7,500 | $2,000 |
| Closing cash balance | $21,000 | $13,500 | $15,500 |
The business remains cash-positive, but the forecast shows a significant decline during February. Management could investigate whether customer collections can be accelerated, inventory orders rescheduled, discretionary costs delayed, or a working-capital facility arranged before the low point.
Create Best-, Base-, and Worst-Case Forecasts
A single forecast may create false confidence. Scenario analysis shows how cash changes when important assumptions differ.
| Scenario | Possible Assumptions |
|---|---|
| Best case | Sales exceed plan, customers pay quickly, costs remain controlled, and no major disruption occurs. |
| Base case | Sales, payment timing, and expenses follow the most realistic current assumptions. |
| Worst case | Sales decline, collections slow, costs rise, or a major customer or supplier problem occurs. |
Useful Sensitivity Tests
- What happens if sales are 10%, 20%, or 30% below plan?
- What happens if customer payments arrive 15 days later?
- What happens if payroll increases?
- What happens if material costs rise?
- What happens if the largest customer does not pay?
- What happens if inventory must be purchased earlier?
- What happens if interest rates or debt payments rise?
Link each scenario to a management response rather than only calculating the numbers.
What Does a Cash Flow Forecasting Tool Do?
A cash flow forecasting tool can organize expected inflows and outflows, automate calculations, connect with accounting or banking data, and present projected balances through tables, ratios, charts, or alerts.
Potential features include:
- Accounting software integration
- Bank-feed integration
- Invoice and accounts-receivable data
- Accounts-payable schedules
- Payroll and tax calendars
- Scenario modeling
- Rolling weekly or monthly forecasts
- Variance analysis
- Cash-shortfall alerts
- User permissions and approval controls
- Reports for lenders or investors
A provider such as PayPie may offer cash flow and financial analysis tools. Review current product capabilities, pricing, integrations, privacy terms, data-security controls, and support directly with the provider before connecting accounting or banking information.
Automation Does Not Remove the Need for Judgment
Software can import records and calculate projections, but management must still decide:
- Whether sales assumptions are realistic
- Which invoices are likely to be paid late
- Whether one-time expenses are missing
- How external events may affect cash
- Which corrective actions are practical
A forecast based on inaccurate or incomplete data can produce a precise-looking but unreliable result.
How to Choose a Cash Flow Forecasting Tool
| Selection Factor | Questions to Ask |
|---|---|
| Accounting integration | Does it connect with the company’s existing accounting platform? |
| Bank integration | Which financial institutions and account types are supported? |
| Forecast horizon | Can it produce weekly, 13-week, monthly, and long-term forecasts? |
| Scenario modeling | Can users create and compare best-, base-, and worst-case scenarios? |
| Manual adjustments | Can management override or explain assumptions? |
| Variance tracking | Does it compare forecast values with actual results? |
| Security | How is data encrypted, stored, accessed, and deleted? |
| User controls | Can permissions be limited for employees, accountants, and advisors? |
| Exporting | Can forecasts be exported to spreadsheets, PDFs, or lender-ready reports? |
| Pricing | What subscription, integration, support, or implementation costs apply? |
Benefits of Cash Flow Forecasting
Earlier Warning of Cash Shortages
A forecast can identify a likely deficit before payroll, supplier bills, taxes, or debt payments become due. Earlier notice provides more time to act.
Better Accounts Receivable Management
Forecasting highlights which customer payments are essential to the company’s cash position. Management can prioritize invoicing, reminders, dispute resolution, and collection activity.
More Informed Spending Decisions
A positive accounting result may not mean that the company can safely purchase equipment or hire employees. A cash forecast shows whether the timing of the spending is manageable.
Stronger Inventory Planning
The business can compare the cash required for inventory with the expected timing of sales and customer receipts.
Improved Financing Preparation
A documented forecast can help management determine the amount, timing, and purpose of potential financing before the cash account reaches a crisis point.
Better Risk Assessment
Scenario forecasts help management quantify the impact of delayed receipts, lost customers, rising costs, and unexpected expenses.
Clearer Management Accountability
Comparing forecast and actual results shows which assumptions were accurate and which business processes require improvement.
What to Do When the Forecast Shows a Cash Shortfall
A projected negative balance should trigger a review of both inflows and outflows.
Actions to Improve Cash Inflows
- Issue invoices promptly.
- Resolve billing disputes.
- Follow up on overdue accounts.
- Request deposits or milestone payments for future work.
- Review customer credit terms.
- Offer early-payment discounts only after calculating the cost.
- Sell unused inventory or equipment.
- Evaluate an appropriate working-capital facility.
Actions to Manage Cash Outflows
- Delay nonessential capital purchases.
- Renegotiate supplier payment schedules.
- Reduce slow-moving inventory orders.
- Cancel unused subscriptions.
- Review pricing and gross margins.
- Reduce discretionary expenses.
- Refinance debt only when the complete cost is lower and the obligation remains manageable.
Do not delay payroll taxes, wages, or required payments without qualified legal and financial advice.
Using Cash Flow Forecasts When Applying for Business Financing
A lender or investor may request projections to understand how much money the business needs, how the funds will be used, and how repayment may occur.
The SBA notes that financial management includes cash flow projections, balance sheets, income statements, and other records that support business planning and financing.
A Financing-Ready Forecast Should Show
- The amount and timing of the cash need
- The assumptions supporting expected sales
- Customer collection timing
- Payroll and operating obligations
- Existing debt payments
- The proposed financing inflow
- Future principal and interest payments
- A downside scenario
- The expected lowest cash balance
Do not include loan proceeds as ordinary sales revenue. Show financing separately so the reader can distinguish operating performance from borrowed cash.
Invoice Factoring and Temporary Cash Flow Gaps
Invoice factoring involves selling eligible customer invoices to a factoring company, usually at a discount. It may provide cash sooner than waiting for customers to pay, but the business receives less than the invoice’s face value and may incur additional charges.
Before using factoring, compare:
- The advance rate
- The discount or factoring fee
- Additional service and processing charges
- Recourse and non-recourse terms
- Customer notification and collection procedures
- Minimum volume or contract periods
- The effect of slow or disputed invoices
- The effective cost compared with a line of credit
Factoring may address a temporary timing gap, but it does not correct weak margins, unprofitable sales, chronic late invoicing, or ongoing operating losses.
Common Cash Flow Forecasting Mistakes
Confusing Revenue With Cash Receipts
Enter customer payments when cash is expected, not merely when an invoice is created.
Assuming Every Customer Pays on Time
Use actual customer payment patterns and separate doubtful invoices.
Forgetting Taxes and Annual Payments
Include payroll taxes, sales taxes, income taxes, insurance renewals, licensing, bonuses, and annual subscriptions.
Failing to Include Loan Repayments
Loan principal and interest both use cash, even though the accounting treatment differs.
Using Only One Scenario
A base case should be accompanied by downside assumptions when uncertainty is material.
Not Updating the Forecast
A forecast becomes stale when sales, customer behavior, expenses, or financing arrangements change.
Using Overly Optimistic Sales Assumptions
Separate signed contracts, qualified opportunities, and speculative pipeline revenue.
Ignoring the Minimum Cash Reserve
A projected positive balance may still be inadequate if the company requires a safety buffer for payroll, taxes, returns, or emergencies.
Failing to Reconcile With Accounting Records
Forecast categories should align with the company’s accounting and management reports so actual-versus-forecast analysis remains useful.
Treating Software Output as Certain
A tool can automate calculations, but it cannot guarantee that customers will pay or that estimated sales will occur.
Cash Flow Forecast Checklist
| Forecast Question | Completed? |
|---|---|
| Is the opening balance accurate and unrestricted? | |
| Are customer receipts entered by expected payment date? | |
| Are doubtful or late invoices treated conservatively? | |
| Are loan and investment inflows shown separately from sales? | |
| Are payroll and payroll taxes included? | |
| Are supplier and inventory payments timed correctly? | |
| Are taxes, insurance, and annual costs included? | |
| Are loan principal and interest payments included? | |
| Are one-time equipment and repair expenses included? | |
| Has a minimum cash-reserve target been defined? | |
| Have best-, base-, and worst-case scenarios been prepared? | |
| Is each major assumption documented? | |
| Has the forecast been compared with actual results? | |
| Is there an action plan for the lowest projected balance? |
Key Takeaways
- A cash flow forecast estimates future cash receipts, payments, and balances.
- Profit and cash flow are different because accounting recognition and payment timing may not match.
- A rolling 13-week forecast supports short-term liquidity management.
- A 12-month forecast helps identify seasonality, financing needs, and the impact of major decisions.
- Customer receipts should be forecast according to expected payment dates rather than invoice dates.
- Payroll, suppliers, taxes, debt payments, capital purchases, and irregular expenses should all be included.
- Best-, base-, and worst-case scenarios help management prepare for uncertainty.
- Forecasting software can automate data and calculations but cannot replace management judgment.
- Forecast-to-actual variance analysis improves future assumptions.
- A projected shortage should lead to an action plan before the low-cash period occurs.
- Financing inflows should be separated from operating revenue.
- Invoice factoring can accelerate cash receipts but creates costs and does not solve an unprofitable business model.
Official Small-Business Cash Flow Resources
- U.S. Small Business Administration: Manage Your Finances
- FDIC: Money Smart for Small Business
- SCORE: 12-Month Cash Flow Statement Template
- SCORE: Three-Year Cash Flow Statement Template
- SCORE: Financial Projections Template
Frequently Asked Questions About Cash Flow Forecasting
What is cash flow forecasting?
Cash flow forecasting is the process of estimating when money will enter and leave a business and calculating the expected cash balance over future periods.
Why is a cash flow forecast important?
It can identify future shortages, support payroll and supplier planning, improve spending decisions, and help determine when financing may be required.
What is the basic cash flow forecast formula?
Net cash flow equals total cash inflows minus total cash outflows. Closing cash equals opening cash plus net cash flow.
What is the difference between cash flow and profit?
Profit measures recognized revenue less recognized expenses. Cash flow measures actual money received and paid. A profitable company can still experience a cash shortage.
How far ahead should a business forecast cash flow?
Many businesses use a rolling 13-week forecast for short-term management and a 12-month forecast for planning. Longer projections may be useful for a business plan or financing request.
How often should a cash flow forecast be updated?
A business under liquidity pressure may update it daily or weekly. A stable company may update monthly, but material changes should be reflected promptly.
What should be included in a cash flow forecast?
Include opening cash, customer receipts, other inflows, payroll, suppliers, inventory, rent, taxes, debt payments, capital spending, and other expected cash outflows.
Should invoices be included when issued or when paid?
Cash forecasts should normally show the expected receipt date. An issued invoice does not create available cash until the customer pays.
What is a 13-week cash flow forecast?
It is a rolling weekly forecast covering approximately one quarter. It is commonly used to manage near-term liquidity, collections, payroll, suppliers, and financing needs.
What is cash flow scenario planning?
It involves preparing forecasts under different assumptions, such as stronger sales, expected performance, and a downside case with lower sales or slower customer payments.
Can cash flow forecasting software predict the future accurately?
Software can improve organization and calculations, but the forecast remains dependent on data quality and assumptions. It cannot guarantee customer payments or sales.
Can a cash flow forecast help a business get financing?
It can help explain the amount and timing of a funding need and how the business expects to meet future payments. Approval remains subject to the lender’s requirements.
What is invoice factoring?
Invoice factoring involves selling eligible invoices to a factor for earlier cash, usually at a discount. Fees, recourse terms, customer interaction, and contract conditions should be compared carefully.
What is the most common cash flow forecasting mistake?
A common mistake is treating invoiced sales as immediate cash. Other frequent errors include unrealistic payment timing, forgotten taxes, missing debt repayments, and failure to update the forecast.
How can a small business improve cash flow?
Possible steps include faster invoicing, stronger collections, customer deposits, better inventory control, supplier negotiations, cost review, pricing improvements, and appropriate financing.
What should a business do when the forecast shows negative cash?
Identify the timing and cause, accelerate realistic receipts, delay nonessential spending, negotiate terms, revise inventory or hiring plans, and arrange suitable financing before the deficit occurs.

Leave a Reply: