Cash Flow Forecast Template: Track Runway, Invoices, and Upcoming Expenses
cash flowsmall business finance13-week forecastcash runwaybusiness calculators

Cash Flow Forecast Template: Track Runway, Invoices, and Upcoming Expenses

PProficient Editorial Team
2026-11-17
7 min read

Build a practical 13-week cash flow forecast to track opening cash, invoices, expenses, runway, and upcoming decisions.

A cash flow forecast template turns uncertain business finances into a rolling view of what may enter and leave your bank account. This guide explains how to build a practical 13-week cash flow forecast, record expected invoices and expenses, estimate cash runway, and use the worksheet to test decisions before they affect your available cash.

Overview

Cash flow forecasting is the process of estimating when money will be received and when it will be paid out. It is different from measuring profit. A business can show a profit on an invoice while still experiencing a cash shortage if the customer pays later, or if taxes, software bills, payroll, and supplier costs are due before the payment arrives.

A 13-week cash flow forecast is useful because it is detailed enough to show upcoming pressure points without requiring a long-range prediction that is difficult to maintain. Each column represents one week. The rows usually include opening cash, expected receipts, expected payments, net cash flow, and closing cash.

MeasureWhat it answers
Cash flowHow much cash is expected to enter or leave during a period?
ProfitAre expected revenues greater than the costs assigned to the period?
Cash runwayHow long could available cash cover planned outgoings if new receipts were delayed?

The forecast is not a promise or a financial statement. It is a decision tool. Use it to identify a possible shortfall, delay a purchase, follow up on an invoice, adjust a payment schedule, or test whether a proposed hire is affordable under different assumptions.

How to estimate

Start with the cash balance that will be available at the beginning of week one. Use the balance shown by your bank or accounting records, then reconcile any transactions that have not cleared. The basic weekly calculation is:

Closing cash = opening cash + expected cash in − expected cash out

The closing cash for one week becomes the opening cash for the next. A simple 13-week cash flow forecast template can therefore use these columns:

  1. Week or date range
  2. Opening cash
  3. Customer receipts
  4. Other cash receipts
  5. Total cash in
  6. Operating expenses
  7. Payroll or contractor payments
  8. Tax and statutory reserves
  9. Debt, equipment, or other one-off payments
  10. Total cash out
  11. Net cash flow
  12. Closing cash

For customer receipts, enter the week you expect the money to arrive, not necessarily the week you issue the invoice. If your customers commonly pay after a delay, shift the receipt to a later week. You can create separate lines for invoices that are confirmed, invoices that are likely, and sales that are only possible. This makes the forecast easier to interpret than one optimistic revenue total.

For expenses, enter the expected payment date. Include recurring costs such as subscriptions, rent, hosting, insurance, payroll, contractors, and loan payments. Add irregular items separately, including annual renewals, equipment, professional fees, tax payments, and planned purchases. If a cost is uncertain, record a reasonable estimate and label the assumption.

Inputs and assumptions

A useful small business cash flow calculator depends on disciplined inputs more than complicated formulas. Gather the following before completing the worksheet:

  • Opening cash: The cash actually available at the start of the forecast, adjusted for pending transactions.
  • Outstanding invoices: Invoice amount, customer, expected payment date, and confidence level.
  • Future sales: Expected receipts from work not yet invoiced, separated from committed work where possible.
  • Payment processing deductions: If a platform or processor withholds a fee, forecast the net amount that reaches your account.
  • Recurring expenses: The amount and expected date for each regular payment.
  • Variable expenses: Costs that rise with projects, customers, usage, or delivery volume.
  • Taxes and reserves: Amounts you intend to set aside or payments you expect to make. Apply the rules and timing relevant to your business rather than relying on a generic percentage.
  • Owner withdrawals or distributions: Include them if they reduce the cash available for business operations.
  • One-off decisions: Hiring, equipment, software changes, refunds, or purchases that could materially affect the balance.

Use three scenarios when a decision matters: a base case, a cautious case, and an upside case. The base case uses your most defensible assumptions. The cautious case delays uncertain receipts and includes likely extra costs. The upside case may include faster collections or additional sales, but it should not be used to justify spending that the base case cannot support.

For a cash runway calculation, define the monthly cash outflow you want to test. A simple estimate is:

Cash runway in months = available cash ÷ average monthly cash outflow

This is only a planning measure. It becomes less useful when expenses vary significantly, when major payments are seasonal, or when expected receipts are essential to continuing operations. The 13-week forecast gives the more useful near-term view because it preserves payment timing.

Worked examples

Assume a small technology consultancy begins week one with $18,000 in available cash. It expects a $7,500 client payment in week two and a $4,000 payment in week five. The first payment is supported by an approved invoice; the second depends on a project milestone. The business also expects weekly operating costs of $1,200, a contractor payment of $3,000 in week three, and a tax payment of $4,500 in week six.

In the base case, the worksheet records the $7,500 receipt in week two and the $4,000 receipt in week five. It records the contractor payment and tax payment in their expected weeks rather than spreading them across the forecast. This may show a low closing balance in week six even though total projected receipts exceed total projected expenses over the full 13 weeks.

In the cautious case, move the $4,000 receipt from week five to week seven and add a reasonable contingency for project-related costs. If the balance becomes negative in week six, the forecast has identified a timing problem. Possible responses include requesting an agreed milestone payment, delaying a nonessential purchase, confirming the contractor schedule, or arranging another appropriate source of funds. The forecast does not decide which response is best; it makes the decision visible early.

For a freelancer, the same method can be applied to several client invoices. A project fee may look sufficient when viewed as revenue, but the forecast should account for the date of delivery, invoice terms, payment-processing fees, taxes, and business expenses. When deciding how to price freelance projects, connect the expected payment schedule to the cash requirement rather than considering only the headline project value. The Freelancer Pricing Playbook can help structure that related pricing decision.

Keep the forecast separate from margin analysis. A profitable project may still create a short-term cash gap if you pay contractors or buy materials before collecting from the client. For pricing context, compare the forecast with the profit margin and markup calculator guide.

When to recalculate

Review the cash flow forecast at least weekly when cash is tight, invoices are irregular, or the business is making a major investment. A monthly review may be sufficient for a stable operation with predictable receipts and expenses, but retain the 13-week horizon so upcoming commitments remain visible.

Refresh the worksheet whenever an invoice is paid, delayed, disputed, or cancelled. Update it when pricing inputs change, recurring costs increase, payment-processing fees change, tax dates or estimates change, or a new contractor, employee, subscription, loan, or equipment purchase is added. Revisit the assumptions annually and whenever the business changes its billing terms, sales mix, or delivery model.

Make each review action-oriented. First, replace forecast amounts with actual cleared payments. Second, move unpaid invoices to the most realistic receipt week. Third, check the lowest projected closing balance. Fourth, list decisions needed before that week arrives. Finally, save the updated version with the review date so you can compare forecast accuracy over time.

A cash flow forecast template works best as a recurring workflow rather than a one-time spreadsheet. Pair it with a client onboarding process so billing details are captured consistently, and use a capacity plan before accepting work that may require additional delivery costs. The client onboarding checklist and team capacity planning calculator provide useful supporting structures.

Before approving a hire, purchase, or new commitment, run the forecast with and without that item. If the cautious case produces a shortfall, treat that as a prompt to improve collection timing, reduce the commitment, or delay the decision. Recalculating after each meaningful change keeps the forecast grounded in the cash the business is likely to have, not simply the revenue it hopes to earn.

Related Topics

#cash flow#small business finance#13-week forecast#cash runway#business calculators
P

Proficient Editorial Team

Productivity and Workflow Editor

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.