How to Build a Business Cash-Flow Forecast

A cash-flow forecast is a calendar of expected cash. It starts with cash available, places receipts and payments in the periods when money is expected to move, and shows the ending balance after each period. It answers a different question from a profit forecast: can the business pay its bills when they are due?

Choose a horizon that matches the decision

For a launch, build a monthly forecast covering at least the pre-opening period and the first 12 operating months. Add a rolling 13-week view when payment timing is tight. Weekly detail exposes payroll dates, card-settlement delays, rent, tax payments, and large vendor invoices that a monthly total can conceal.

Use one time scale per sheet. Put annual or quarterly bills in the week or month when they are paid rather than dividing every payment evenly by 12. You can still calculate a monthly economic cost elsewhere, but the cash schedule must reflect the payment terms.

Use the cash equation on every column

The core calculation is simple:

Ending cash = beginning cash + cash inflows − cash outflows.

The next period’s beginning cash must equal the prior period’s ending cash. A broken link here makes the entire forecast unreliable.

Organize the schedule into sections:

1. Operating inflows: cash sales, customer collections, subscription receipts, and other operating cash.
2. Operating outflows: inventory, payroll, rent, contractors, software, marketing, insurance, taxes, and other bills.
3. Investing cash: equipment and other long-lived assets.
4. Financing cash: owner contributions, loan proceeds, principal repayments, and distributions.

This structure mirrors the practical distinction between operations, investments, and financing. The SEC’s financial-statement guide explains why cash flow and net income are related but not equivalent.

Build revenue first, then convert it to collections

Do not put revenue directly into cash receipts unless customers pay immediately. Forecast revenue from operational drivers, such as customers × orders per customer × average order value. Then apply the collection pattern.

Suppose a service business invoices $20,000 in March, collects 25% at booking, and expects the remaining 75% in April. March revenue may be $20,000 under the model’s accounting assumptions, but the cash schedule shows $5,000 in March and $15,000 in April. If the client can pay late, create a slower-collection scenario instead of treating the due date as guaranteed cash.

For card sales, use the expected net settlement date and show processing fees consistently. For marketplaces, distinguish customer transaction volume from the amount the business is entitled to keep.

Schedule costs from commitments and drivers

Use contracts and quotes for fixed commitments. Model variable payments from the same activity assumptions used in the revenue forecast. Examples include units purchased, billable hours delivered, card volume processed, miles driven, or support tickets handled.

Separate:

• expense from cash payment when supplier terms create accounts payable;
• equipment purchases from ordinary operating expenses;
• loan principal from interest;
• sales tax collected for a government authority from operating revenue;
• owner contributions from customer receipts.

Worked example: timing creates the cash gap

Consider a hypothetical service company with $12,000 of opening cash. All figures below are illustrative.

The business ends month three with more cash, but its lowest forecast balance is $2,500 in month two. That minimum, plus a chosen contingency buffer, drives the working-capital decision. A three-month profit total would not show the same timing risk.

Add controls before adding complexity

A useful forecast includes checks that make errors visible:

• Roll-forward check: beginning cash equals the prior ending cash.
• Sources-and-uses check: launch funding equals the payments and minimum reserve it is meant to cover.
• Debt check: opening balance plus draws minus principal repayments equals closing debt.
• Receivables check: opening receivables plus invoiced revenue minus collections equals closing receivables.
• Inventory check: opening inventory plus purchases minus inventory used or sold equals closing inventory.

Do not hide an imbalance in an “other cash” line. Find the missing date, duplicated cost, or incorrect sign.

Test the forecast against actual cash

Once the business operates, compare forecast and actual cash every week or month. Record both the amount variance and the reason: lower volume, delayed collection, higher price, earlier payment, missing item, or timing shift. Then roll the forecast forward using current information.

Keep three versions distinct: the original approved plan, actual results, and the current forecast. Overwriting the original budget removes the baseline needed to learn whether assumptions were accurate.

Common errors

• Using sales as cash receipts regardless of payment terms.
• Leaving pre-opening payments outside the first forecast column.
• Ignoring deposits, annual renewals, taxes, debt principal, or owner draws.
• Treating an unused credit limit as cash without modeling the draw and repayment.
• Letting the cash balance go negative without an explicit funding source.
• Using one optimistic collection assumption for every customer.

Start with a business-specific tool from the calculator directory, and use the StartupByState methodology to document every external estimate and internal assumption.

Sources and scope

• U.S. Small Business Administration: Plan your business — financial projections and startup-cost planning.
• U.S. Small Business Administration: Manage your business — bookkeeping, revenue and expense tracking, and cash-flow planning.
• FDIC Money Smart for Small Business: Managing Cash Flow — cash-flow management curriculum developed with the SBA.
• U.S. Securities and Exchange Commission: Beginner’s Guide to Financial Statements — relationships among income, balance-sheet, and cash-flow statements.

Research reviewed September 6, 2026. Examples are planning illustrations, not tax, legal, accounting, investment, or lending advice.