Cash Flow Forecast Template for Small Businesses: Track Runway, Receipts, and Upcoming Bills
cash-flowsmall-business-financeforecastingfinancial-templatesbusiness-planning

Cash Flow Forecast Template for Small Businesses: Track Runway, Receipts, and Upcoming Bills

CClipboard Editorial Team
2026-11-18
7 min read

Build a 13-week cash flow forecast to track receipts, bills, runway, late payments, and scenarios before cash shortages become urgent.

A cash flow forecast helps you answer a practical question before it becomes urgent: will the business have enough available cash to cover upcoming bills? This guide shows how to build a reusable 13-week cash flow forecast, track expected receipts and payments, calculate cash runway, and test scenarios such as late customer payments or seasonal revenue changes.

Overview

Cash flow forecasting is a forward-looking estimate of money expected to enter and leave the business during a defined period. It is different from a profit and loss report: a business can show sales or accounting profit while still facing a short-term cash shortage if customers pay late, inventory must be purchased in advance, or large bills fall due before receipts arrive.

A 13-week cash flow forecast is useful because it provides a detailed near-term view without requiring a full-year prediction. Use one column for each week and separate cash receipts from cash payments. The basic calculation is:

Ending cash balance = Opening cash balance + Total cash received − Total cash paid

The ending balance for one week becomes the opening balance for the next. Comparing each projected ending balance with a minimum cash buffer can reveal when you may need to delay discretionary spending, follow up on invoices, adjust payment timing, or arrange funding.

This forecast works for many small businesses, including consultants, creators, retailers, studios, and product businesses. It can be built in a spreadsheet, accounting software, or another workflow tool that allows dated cash entries and recurring reviews. The important feature is not the software; it is the discipline of recording expected timing rather than only recording total revenue and expenses.

How to estimate

Set up 13 weekly columns, beginning with the next full week or the next practical planning date. Add these rows:

Forecast areaWhat to record
Opening cashCash available at the start of the week
Customer receiptsPayments expected from invoices, subscriptions, sales, or deposits
Other receiptsOwner contributions, financing proceeds, refunds, or other inflows
Total receiptsAll expected cash entering the business
Operating paymentsPayroll, contractors, software, rent, utilities, shipping, and supplies
Tax and statutory paymentsAmounts set aside or scheduled according to the business's applicable calendar
Debt and financing paymentsPrincipal, interest, or other scheduled repayments
Owner withdrawalsPlanned draws or distributions
Total paymentsAll expected cash leaving the business
Net cash movementTotal receipts minus total payments
Ending cashOpening cash plus net cash movement

Use the formula in each weekly column. If cell B2 contains opening cash, B3 through B5 contain receipt categories, and B6 through B10 contain payment categories, a spreadsheet version might use:

Total receipts = SUM(B3:B5)
Total payments = SUM(B6:B10)
Net cash movement = Total receipts − Total payments
Ending cash = Opening cash + Net cash movement

For the next week, link its opening cash to the previous week's ending cash. Do not overwrite that link with a new estimate unless you are intentionally resetting the forecast with an updated bank balance.

To calculate a simple cash runway, divide available cash by average weekly cash burn:

Cash runway in weeks = Available cash ÷ Average weekly net cash outflow

Use this only when the business is consistently spending more cash than it receives. If weekly cash flow varies substantially, the 13-week forecast is more informative than a single average. A runway estimate is a planning indicator, not a guarantee, because it depends on the assumptions used.

Inputs and assumptions

Good forecasts distinguish between confirmed, likely, and uncertain cash movements. Create an assumptions column or notes field for every material entry. Record the expected date, amount, source, confidence level, and any action needed.

Accounts receivable tracking table

Customer or sourceInvoice or saleAmount dueExpected receipt dateConfidenceFollow-up
Customer AInvoice 1041,200Week 2MediumConfirm payment date
Customer BRetainer payment800Week 1HighNone

Include only cash you reasonably expect to receive in the relevant week. An issued invoice is not the same as a receipt. For uncertain invoices, create a conservative version of the forecast that moves the receipt to a later week or excludes it temporarily. This prevents the forecast from treating every sale as immediately spendable cash.

Accounts payable tracking table

Supplier or paymentAmountDue dateExpected payment weekEssential?Action
Software renewal300Week 3Week 3ReviewConfirm renewal terms
Contractor invoice950Week 2Week 2YesApprove for payment

Separate committed payments from flexible spending. Payroll, contractual obligations, and required tax payments may have limited flexibility. Equipment purchases, optional subscriptions, campaigns, or inventory orders may be easier to reschedule, but any change should be considered against operational commitments and applicable terms.

Use cash amounts rather than accounting amounts. If a payment platform deposits sales after fees, enter the expected net deposit. If a customer pays in a different currency, note the exchange-rate assumption and consider using a conservative estimate. Keep taxes, restricted funds, and money held on behalf of others clearly separated from cash that is available for ordinary spending.

Worked examples

Example 1: A late customer payment

Suppose a business begins Week 1 with 6,000 in available cash. It expects 4,000 in receipts and 5,200 in payments, producing an ending balance of 4,800:

6,000 + 4,000 − 5,200 = 4,800

A 2,000 customer payment expected in Week 2 is then delayed by two weeks. The original forecast may show 5,100 at the end of Week 2, but the revised forecast shows 3,100. That change does not necessarily mean the business is unprofitable; it means the timing of available cash has changed. The owner can now investigate collection timing, postpone a nonessential purchase, or negotiate a payment date before the balance becomes uncomfortable.

Example 2: Seasonal revenue

A creator or retailer may expect stronger receipts in Weeks 9 through 12 and lower receipts earlier in the period. Do not spread the expected total evenly across all 13 weeks. Enter receipts in the weeks when customers are actually expected to pay, then add known production, inventory, advertising, or fulfillment payments before those receipts arrive.

Build at least two views:

  • Base case: the most reasonable expectation based on confirmed orders, recurring receipts, and scheduled bills.
  • Conservative case: later customer payments, lower variable revenue, and no optional receipts unless they are substantially supported.

You can also add an upside case for planning capacity, but avoid using it to justify commitments that the base case cannot support. A scenario is useful when it changes a decision, such as whether to place an order, hire help, or move a planned purchase.

A cash flow forecast is strongest when paired with other business calculators. Use a profit margin calculator to distinguish margin from cash availability, or a break-even calculator to estimate the sales volume needed to cover fixed and variable costs. If pricing is changing, an hourly-to-project rate calculator can help test whether proposed work supports the forecast. These tools answer different questions and should not replace the weekly cash view.

When to recalculate

Review the forecast at least once a week during periods of tight cash, rapid growth, seasonal demand, or major spending. For a more stable business, a monthly review may be sufficient, provided the 13-week window is refreshed with actual bank balances and updated dates.

At each review:

  1. Replace the opening balance with the verified available cash balance.
  2. Mark each forecast receipt and payment as actual, delayed, cancelled, or still expected.
  3. Compare forecast cash movement with actual cash movement and note the reason for significant differences.
  4. Move unpaid invoices to a realistic expected date rather than leaving them in the original week.
  5. Add new bills, renewals, payroll changes, tax-calendar items, and planned purchases.
  6. Recalculate the lowest projected ending balance and compare it with the minimum cash buffer.
  7. Run a conservative scenario if a major receipt is uncertain or a large bill has been added.

Refresh payment-platform terminology, accounting-software labels, tax-calendar examples, and any benchmark assumptions when your systems or operating environment change. Keep an archived copy of each forecast so you can see whether errors came from missing transactions, optimistic receipt dates, unexpected costs, or changing demand.

The most useful cash flow forecast is not the one with the most rows. It is the one updated often enough to guide a real decision. Start with 13 weeks, enter confirmed dates first, label uncertainty clearly, and use the lowest projected cash balance to decide what deserves attention next.

For a broader operations routine, pair this forecast with a client onboarding checklist to clarify deposits and billing milestones, or a weekly operations dashboard to connect planned work with expected receipts and costs.

Related Topics

#cash-flow#small-business-finance#forecasting#financial-templates#business-planning
C

Clipboard Editorial Team

Editorial Team

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.