How to Build a Cash Flow Forecast: Step-by-Step Guide

A business can report a healthy profit and still struggle to make payroll. The problem is usually timing. Revenue may appear on the income statement before customers pay, while payroll, rent, taxes, and supplier bills require cash on specific dates.

Learning how to build a cash flow forecast gives you a forward-looking view of that timing. Instead of relying on your current bank balance, you can see when cash is expected to arrive, when it must leave, and where a shortage may develop.

This guide explains how to build a practical forecast, create a cash flow model, test different scenarios, and keep the numbers useful as conditions change.

Key takeaways

• A cash flow forecast tracks when money enters and leaves the business, not simply when revenue and expenses appear in your accounting records.
• A 13-week weekly forecast usually provides the clearest view of near-term liquidity.
• The opening cash balance must match the actual cash available at the forecast start date.
• Customer payment timing, payroll dates, tax obligations, and supplier terms often matter more than monthly revenue totals.
• Every forecast should include documented assumptions, a minimum cash threshold, and at least one downside scenario.
• The forecast becomes more accurate when you replace estimates with actual results and investigate material variances.
• A useful model should lead to decisions about collections, spending, hiring, financing, pricing, or payment timing.

What a cash flow forecast should tell you

A cash flow forecast estimates the amount of cash your business expects to have at future points in time. It begins with the cash available today, adds expected inflows, subtracts expected outflows, and calculates the resulting closing balance.

The basic calculation is:

Opening cash balance + cash received – cash paid = closing cash balance

That closing balance becomes the next period’s opening balance.

The formula is simple. Building a reliable forecast is harder because the model must reflect when transactions will actually clear the bank.

Cash flow is not the same as profit

Profit measures whether revenue exceeds expenses under the accounting method used by the business. Cash flow measures the movement of money into and out of bank accounts.

Suppose an agency completes a $40,000 project in March and records the full amount as March revenue. If the client pays 50% in April and 50% in May, the income statement and cash flow forecast will show different timing.

The agency may look profitable in March while still lacking enough cash to cover April payroll.

The U.S. Small Business Administration explains that accrual accounting records a sale when it occurs, while cash accounting records it when payment is received. That timing difference is one reason business owners should review cash projections separately from profit reports.

What decisions should the forecast support?

A good forecast should help you answer specific questions, such as:

• Will there be enough cash for payroll on each pay date?
• When will customer payments need to arrive?
• Can the business afford a planned hire or equipment purchase?
• How much cash should be reserved for taxes?
• When could the business fall below its minimum operating balance?
• Would changing supplier terms relieve a temporary cash squeeze?
• How long can the business operate if sales decline?

If the spreadsheet cannot answer questions like these, it may contain financial data without functioning as a decision tool.

Choose the right forecasting period

Different planning horizons serve different purposes.

Forecast period	Best use	Level of detail
4 to 6 weeks	Immediate payment control and cash emergencies	Daily or weekly
13 weeks	Payroll, collections, supplier payments, and near-term decisions	Weekly
6 to 12 months	Hiring, investment, seasonality, and financing plans	Monthly
2 to 3 years	Strategic planning and lender or investor discussions	Monthly, quarterly, or annual

For many small and midsize businesses, a rolling 13-week forecast is the practical starting point. It covers roughly one quarter while remaining close enough to current operations for invoices, payroll, contracts, and payment dates to be estimated with reasonable detail.

A longer model can sit beside it. The weekly forecast protects short-term liquidity, while a monthly model supports broader planning.

Businesses facing repeated shortages may need more than a spreadsheet. A structured cash flow forecasting process can connect receivables, payables, operating plans, and decision-making instead of treating forecasting as an isolated finance task.

How to build a cash flow forecast in 10 steps

The following cash flow forecast steps use the direct method. This approach lists the cash the business expects to receive and pay during each period.

It works well for operational planning because it focuses on real bank activity rather than adjusting accounting profit through noncash items.

1. Decide what the forecast is for

Start with the decision you need the forecast to support.

A business worried about making payroll needs a weekly or even daily view. A company evaluating an additional employee may need a 12-month monthly model. A seasonal business may need both.

Write the forecast purpose at the top of the file. For example:

Purpose: Determine whether the company can hire an account manager on September 1 while maintaining at least $75,000 in available cash.

This prevents the model from growing into a complicated workbook that contains plenty of numbers but no clear use.

2. Select the start date and time intervals

Choose a start date that matches the opening balance you can verify. For a weekly model, many businesses use Monday through Sunday or Saturday through Friday.

Consistency matters more than the specific day.

Create one column for each forecast period. A 13-week model might include Week 1 through Week 13, with the corresponding start or end date shown in every heading.

Avoid mixing weekly receipts with monthly expenses. Convert every item to the same interval so the model does not hide timing gaps.

3. Confirm the opening cash balance

The first opening balance should reflect usable cash at the beginning of the forecast.

Begin with reconciled bank balances. Then decide which accounts belong in the model. Include operating and savings accounts that the business can use for normal obligations. Exclude restricted funds unless they can legally and practically cover those expenses.

Also account for transactions that have not cleared. An outstanding $25,000 check should not be treated as available cash simply because it still appears in the bank balance.

Document the balance date and source. For example:

Opening balance of $128,450 as of August 3, based on reconciled operating and reserve accounts, less $14,200 in outstanding payments.

A wrong opening balance affects every period that follows.

4. List expected cash receipts

Build the inflow section around the ways money actually reaches the business.

Common inflows include:

• Customer invoice payments
• Cash and card sales
• Recurring subscriptions or retainers
• Customer deposits
• Loan proceeds
• Owner contributions
• Tax refunds
• Interest income
• Asset sale proceeds
• Grants or other approved funding

Do not begin with the revenue shown in the budget and assume it will become cash in the same month. Review outstanding invoices, customer payment behavior, contract schedules, and sales terms.

Separate receipts by confidence level when uncertainty is meaningful:

1. Committed receipts: Signed contracts, approved invoices, and scheduled recurring payments.
2. Probable receipts: Work expected to complete based on active orders or reliable customers.
3. Pipeline receipts: Opportunities that have not yet become binding customer commitments.

The base forecast should not depend heavily on unsigned pipeline revenue. Keep uncertain opportunities in a separate scenario or apply a documented probability.

5. Estimate when customers will pay

This step often determines whether the forecast is useful.

An invoice due in 30 days does not guarantee payment on day 30. Review actual collection patterns by customer or customer type.

For example:

Customer group	Invoice terms	Typical payment behavior	Forecast assumption
Enterprise clients	Net 30	40 to 50 days	45 days
Small business clients	Net 15	15 to 25 days	20 days
Retainer clients	Due in advance	Usually on time	Contract date
New project clients	50% deposit	Before work starts	Expected start date

Use the most specific information available. A known customer’s recent payment history is usually more useful than the average for all customers.

When a payment date is uncertain, place it later rather than earlier. Conservative timing reveals potential pressure before it becomes urgent.

6. List cash outflows by payment date

Next, identify when cash must leave the business.

Typical outflows include:

• Payroll and payroll taxes
• Contractor payments
• Rent and utilities
• Supplier and inventory payments
• Insurance
• Software subscriptions
• Loan principal and interest
• Credit card payments
• Sales commissions
• Marketing expenses
• Equipment purchases
• Owner distributions
• Tax payments
• Professional fees
• Refunds and chargebacks

Use bank statements, the accounts payable aging report, payroll calendars, loan schedules, recurring subscriptions, tax records, and approved purchase plans.

Do not spread a quarterly bill evenly across three months unless you are actually transferring that amount into a reserve account. If the payment leaves the bank on September 15, show the full payment on September 15.

The IRS tax calendar can help businesses identify federal filing and payment dates, but exact obligations depend on entity type, payroll schedule, location, and tax situation. Confirm amounts and deadlines with a qualified tax professional.

7. Separate recurring, variable, and one-time payments

Categorizing outflows makes the model easier to review and adjust.

Recurring fixed payments remain relatively stable, such as rent, insurance, software, and scheduled debt payments.

Variable payments change with activity. These may include inventory, shipping, sales commissions, payment processing fees, and project contractors.

One-time payments include equipment, legal settlements, office moves, bonuses, tax catch-up payments, or major repairs.

This distinction also improves scenario planning. If revenue declines, variable costs may fall after a delay, while fixed obligations usually remain.

8. Calculate net cash movement and closing cash

For each period, subtract total outflows from total inflows.

Net cash movement = total cash inflows – total cash outflows

Then calculate the closing balance:

Closing cash balance = opening cash balance + net cash movement

Carry the closing balance into the next period.

A simple weekly structure might look like this:

Cash flow item	Week 1	Week 2	Week 3	Week 4
Opening cash	$120,000	$105,000	$92,000	$116,000
Customer receipts	$45,000	$38,000	$70,000	$42,000
Other inflows	$0	$5,000	$0	$0
Total inflows	$45,000	$43,000	$70,000	$42,000
Payroll	$32,000	$0	$32,000	$0
Suppliers and contractors	$18,000	$28,000	$9,000	$24,000
Overhead and other payments	$10,000	$28,000	$5,000	$12,000
Total outflows	$60,000	$56,000	$46,000	$36,000
Net cash movement	-$15,000	-$13,000	$24,000	$6,000
Closing cash	$105,000	$92,000	$116,000	$122,000

The example shows why totals alone are not enough. Week 2 creates pressure even though the four-week period ends with more cash than it started with.

9. Set a minimum cash threshold

A positive balance is not automatically a safe balance.

The business may need a minimum amount to cover payroll, essential suppliers, refunds, emergency repairs, and normal uncertainty. Define that threshold before reviewing the forecast so the decision rule does not change to fit the result.

For example, a company with $60,000 in biweekly payroll may set a minimum operating threshold of $100,000. Another business may use one month of fixed operating payments.

Add a visible threshold line to the model. A projected balance below that line should trigger action even if the account remains technically positive.

If the model shows repeated breaches, review the underlying causes rather than shifting payments indefinitely. Persistent timing pressure may indicate a deeper cash crunch involving slow collections, weak margins, debt obligations, or growth that consumes cash faster than operations replenish it.

10. Document every material assumption

A forecast without assumptions is difficult to challenge, update, or explain.

Create a separate assumptions tab or clearly labeled section. Record:

• Customer payment dates
• Sales growth assumptions
• Collection rates
• Payroll dates and planned raises
• Hiring dates
• Supplier payment terms
• Tax estimates
• Planned investments
• Financing assumptions
• Minimum cash threshold
• Scenario definitions

Include the source, owner, and review date for important assumptions.

For example:

Assumption	Base case	Source	Owner	Review date
Enterprise invoices collected	45 days after invoice	Prior 12-month average	Finance	Weekly
New salesperson starts	October 1	Approved hiring plan	CEO	Monthly
Equipment purchase	$48,000 in November	Vendor quote	Operations	Before order
Customer renewal	$90,000 in December	Signed agreement	Sales	Monthly

This makes disagreement useful. Instead of arguing that the forecast “looks too optimistic,” the team can discuss the specific assumption that needs to change.

How to create a cash flow model you can use

Knowing the cash flow forecast steps is only part of the job. The file must also be easy to maintain, check, and use in meetings.

A simple spreadsheet is often enough. The quality of the inputs and review process matters more than visual complexity.

Use a clear workbook structure

A practical model may contain five tabs:

1. Dashboard: Opening cash, lowest projected balance, threshold breaches, and key decisions.
2. 13-week forecast: Weekly inflows, outflows, net movement, and closing cash.
3. Long-range forecast: Monthly cash position for the next 12 to 24 months.
4. Assumptions: Payment timing, hiring dates, growth rates, and planned spending.
5. Actual versus forecast: Variances and explanations.

Keep input cells separate from formulas. Use consistent signs, with inflows positive and outflows either negative or shown in a clearly labeled payment section.

Avoid hard-coding the same assumption in multiple places. If payroll growth appears in several formulas, link those formulas to one assumption cell.

Build the model from operational drivers

Revenue should not be a single number typed into a row without explanation. Connect it to the activity that produces it.

A professional services company might forecast revenue using:

Billable employees × available hours × utilization rate × average billing rate

A subscription business might use:

Opening customers + new customers – churned customers = closing customers

Then:

Average customers × average monthly revenue per customer = subscription billings

An eCommerce company may use:

Website sessions × conversion rate × average order value = gross sales

The cash model then adjusts those sales for payment processing delays, refunds, inventory purchases, shipping expenses, and vendor terms.

Driver-based forecasting makes it easier to explain why the result changed. It also allows leaders to test decisions rather than simply replacing one total with another.

Add base, downside, and upside scenarios

A single forecast can create false confidence because it presents one path as though it were certain.

Create at least three cases:

Scenario	Typical assumptions	Purpose
Base case	Expected collections, approved hiring, normal sales activity	Most likely operating plan
Downside case	Slower collections, lower sales, unexpected expense	Tests resilience and financing needs
Upside case	Faster growth, larger orders, earlier hiring or inventory needs	Tests whether growth creates cash strain

The downside case should be credible, not catastrophic. Examples include a major customer paying 30 days late, sales falling 10%, or a planned project beginning one month later.

The upside case matters because growth can also create shortages. A manufacturer may need to buy materials and pay labor weeks before collecting from customers.

Practical example: the profitable agency with a cash gap

Consider an agency with $300,000 in monthly revenue and a 15% accounting profit margin. Management wants to hire three employees because the sales pipeline looks strong.

The original plan assumes:

• The new employees start on September 1.
• Added payroll is $28,000 per month.
• A $120,000 customer project begins in September.
• The customer pays within 30 days.
• Existing clients continue paying on schedule.

The forecast reveals a different picture. The new customer requires work in September but pays in late October. Two existing customers usually pay 15 days after their due dates. Annual insurance and a quarterly tax payment also fall in September.

Under the original assumptions, cash drops from $210,000 to $42,000 before recovering. The company’s minimum threshold is $100,000.

Management now has several options:

• Move one hire to November.
• Require a project deposit.
• Accelerate collection of overdue invoices.
• Negotiate the insurance payment schedule.
• Arrange a line of credit before the shortage.
• Delay owner distributions.

The forecast does not choose the answer. It shows the timing and scale of the problem early enough for management to choose deliberately.

When a model affects hiring, financing, pricing, or owner compensation, outside financial leadership may be useful. Fractional CFO services can help connect the forecast to operating decisions, reporting, and accountability rather than leaving the file with one employee.

Choose tools based on complexity

Excel and Google Sheets work well when the model needs custom logic and the business has someone responsible for maintaining it.

Accounting platforms can reduce manual work. For example, the QuickBooks Online cash flow planner can draw from linked accounts and future transactions, while allowing users to add expected inflows and expenses. Intuit notes that adjustments made in the planner do not change the accounting records. 

Dedicated forecasting tools may be worthwhile when a business has multiple entities, departments, currencies, bank accounts, or scenario models. Software cannot correct weak assumptions, unreconciled accounting, or unclear ownership, however.

How to review and improve your forecast

A forecast starts losing value as soon as operations move forward. Customers pay early or late. Sales close at different amounts. Hiring dates shift. Suppliers change terms.

The solution is not to rebuild the model every quarter. Use a rolling review process.

Replace forecast periods with actual results

At the end of each week:

1. Reconcile the actual closing cash balance.
2. Replace forecast receipts and payments with actual amounts.
3. Move the forecast forward by one week.
4. Add a new period at the end.
5. Update changed assumptions.
6. Review threshold breaches and required actions.

This keeps the forecast horizon at 13 weeks rather than allowing it to shrink.

A monthly model follows the same principle. Close the completed month, compare actual results with expectations, and add another future month.

Investigate variances instead of overwriting them

A variance is the difference between the forecast and actual result.

Do not simply replace the old number and move on. Identify why the difference occurred.

Useful variance categories include:

• Timing variance: The amount is still expected, but in another period.
• Amount variance: The receipt or payment differs from the estimate.
• Missing item: The transaction was omitted from the forecast.
• Assumption error: The business driver was wrong.
• Decision variance: Management intentionally changed the plan.
• Classification issue: The transaction appeared in the wrong category.

Suppose customer receipts were $50,000 below forecast. The response depends on the cause. A three-day banking delay is different from a disputed invoice or lost customer.

Variance analysis gradually improves the model because it exposes where assumptions repeatedly fail.

Review the forecast in an operating meeting

The forecast should not belong only to accounting. Sales, operations, and leadership often hold the information needed to update it.

A weekly review can cover:

• Changes to major expected receipts
• Overdue invoices and collection owners
• New contracts or cancellations
• Purchase commitments
• Hiring or contractor changes
• Tax and debt deadlines
• Threshold breaches
• Decisions required before the next review

The SBA describes projections as tools for planning, setting goals, assessing feasibility, and comparing actual performance with expectations. It also stresses recording assumptions and revisiting projections as conditions change.

Common cash flow forecasting mistakes

Forecasting revenue instead of receipts

Revenue does not pay bills until the customer pays. Translate invoices and sales expectations into realistic collection dates.

Ignoring overdue invoices

An overdue invoice should not remain on its original payment date. Investigate its status and move it to a realistic period, reduce its probability, or remove it from the base case.

Using averages that hide payment timing

A monthly payroll average can hide two large pay dates. Enter payments when they occur.

Forgetting taxes, debt principal, or owner distributions

These items may not appear where management expects them in the profit and loss statement. They still reduce cash.

Treating unused credit as cash

A line of credit may be a contingency, but it is not operating cash until drawn. Show the draw separately, along with interest and repayment requirements.

Assuming the sales pipeline will close

Keep unsigned opportunities outside the committed forecast or apply conservative probabilities. Otherwise, projected cash may depend on sales that never occur.

Making the model too complicated

A model with hundreds of rows can still be unreliable. Include the level of detail needed to support decisions, then group immaterial items.

Failing to assign ownership

Receipts and payments should have owners. Sales may own customer follow-up, operations may own purchasing commitments, and finance may own payroll, tax, and debt schedules.

When professional support may be appropriate

Consider professional help when:

• Forecasts repeatedly fail to match actual results.
• The company is profitable but regularly runs short of cash.
• Growth requires financing, inventory, or hiring before revenue arrives.
• Multiple entities or locations move cash between accounts.
• Management cannot agree on assumptions.
• Lenders or investors require integrated projections.
• The model needs to connect income statements, balance sheets, and cash flow.
• No one inside the company owns the weekly forecasting process.

The appropriate support may come from an experienced controller, certified public accountant, financial planning and analysis professional, or CFO. The right choice depends on whether the problem is transaction accuracy, tax treatment, model design, financing, or strategic decision-making.

Businesses comparing ongoing financial leadership options should review the expected scope, decision support, and fractional CFO pricing rather than judging the engagement only by the number of reports produced.

This article provides general educational information. Cash planning can involve tax, financing, legal, and accounting considerations specific to your business. Consult qualified professionals before making material financial decisions.

Build a forecast that supports real decisions

The goal is not to predict every transaction perfectly. It is to identify pressure early enough to act.

Start with verified cash, realistic payment dates, complete outflows, and documented assumptions. Update the model regularly, compare it with actual results, and connect every material variance to an operational cause.

A forecast earns its place in the business when it changes a decision before the bank balance forces one.

FAQs