Small Business Cash Flow Forecast Template: 13-Week Planning and Monthly Review Workflow
cash flowsmall business financeforecastingspreadsheetsplanning

Small Business Cash Flow Forecast Template: 13-Week Planning and Monthly Review Workflow

RRecurrent Editorial Team
2026-11-15
7 min read

Build a practical 13-week cash flow forecast with spreadsheet-ready inputs, confidence ratings, examples, and a weekly update workflow.

A reliable cash flow forecast turns uncertain timing into a manageable weekly plan. This guide shows how to build a spreadsheet-ready 13-week cash flow forecast for a small business or freelance practice, including opening cash, expected invoices, recurring expenses, payroll, taxes, one-time payments, confidence ratings, and variance tracking.

Overview

Profit and cash are not the same thing. A business can have profitable work on paper and still face a cash shortfall if clients pay late, payroll falls before collections, or a large annual bill arrives unexpectedly. A cash flow forecast focuses on when money is expected to enter and leave the bank account.

A 13-week cash flow forecast is useful because it is detailed enough to expose near-term pressure while still providing a planning horizon for hiring, purchasing equipment, scheduling tax payments, or negotiating payment terms. It is not a promise about the future. It is a working model that becomes more useful as estimates are replaced with actual results.

The basic calculation is:

Closing cash = opening cash + total cash inflows − total cash outflows

Each week should have its own opening balance, inflow total, outflow total, and closing balance. The following week starts with the previous week's closing balance. If the projected closing balance falls below your chosen minimum cash reserve, the forecast creates an early warning rather than a surprise.

A simple spreadsheet can be enough. Create columns for Week 1 through Week 13, then add rows for each cash category. Keep the forecast separate from an accrual-based profit and loss report: record cash when it is expected to reach or leave the bank account, not merely when an invoice is issued or a bill is received.

How to estimate

Start with the current bank balance that is genuinely available for operations. If some funds are reserved for taxes, payroll, client money, debt repayments, or another restricted purpose, list them separately rather than treating them as unrestricted cash.

Next, map expected inflows by likely receipt date. Useful rows include:

  • Customer invoices already issued
  • Recurring subscriptions or retainers
  • Expected deposits on new work
  • Card, marketplace, or payment-platform settlements
  • Owner contributions or financing proceeds
  • Other predictable receipts

Do not automatically place an invoice in the week it is due. Consider the customer's usual payment behavior, approval process, weekends, holidays, and payment-processing delays. For uncertain invoices, create a base case and a cautious case. The base case can use the expected receipt week; the cautious case can move the receipt later or reduce the amount if collection is uncertain.

Then list outflows by the date they are likely to clear. Typical rows include:

  • Payroll, contractor payments, and related employer costs
  • Rent, utilities, software, insurance, and other recurring overhead
  • Supplier and subcontractor invoices
  • Tax provisions or scheduled tax payments
  • Loan, lease, or credit-card payments
  • One-time purchases, repairs, or professional fees
  • Owner draws or distributions

For each week, calculate the total inflows and total outflows. Subtract outflows from inflows to find net cash movement, then add net movement to the opening balance. A spreadsheet formula can follow this pattern:

Net cash movement = total inflows − total outflows
Closing cash = opening cash + net cash movement
Next week's opening cash = prior week's closing cash

Add a variance section beneath the forecast once each week closes. For every major line, compare the forecast amount with the actual amount and record the difference. Also compare the expected date with the actual date. Timing variances often explain a cash squeeze even when the total amount eventually arrives.

Inputs and assumptions

Label assumptions clearly so another person can review the model. A practical input table might include the item, amount, expected week, confidence, and notes.

InputAmountExpected weekConfidenceNotes
Invoice A3,000Week 2HighCustomer confirmed payment date
Project deposit2,000Week 4MediumAgreement signed; work not yet started
Payroll4,800Every other FridayHighInclude applicable employment costs
Tax provision1,200Week 6MediumConfirm with the business's records or adviser

A confidence rating helps prevent false precision. Use High when the amount and date are supported by a confirmed transaction or established schedule. Use Medium when the amount is reasonably expected but timing could move. Use Low when the receipt depends on an unsigned proposal, uncertain collection, or an unapproved expense. Consider excluding low-confidence inflows from the minimum-cash decision until they become more certain.

Keep tax and payroll assumptions distinct from ordinary operating expenses. The appropriate treatment depends on the business structure, location, payroll setup, filing schedule, and accounting method. Use the forecast to reserve cash, but verify payment dates and amounts against the business's records and qualified local advice where necessary. A payroll calculator for small business can help organize wage and employer-cost inputs, but it should not replace a review of the actual payroll process.

For recurring costs, use the amount expected to leave the bank rather than relying on an old average. Review software subscriptions, insurance, utilities, and payment fees for changes. The small business SaaS audit template can help identify recurring subscriptions that belong in the outflow schedule.

Set a minimum cash threshold before you begin. This might be a fixed operating reserve, a planned amount for payroll and essential bills, or a level agreed with the business owner. The threshold should be visible on every weekly column. A projected balance below it is a planning signal: investigate the cause, test alternatives, and decide before the shortfall becomes immediate.

Worked examples

Service business example

Suppose a service business begins Week 1 with 18,000 in available cash. It expects a 6,000 client payment in Week 2 and a 4,000 payment in Week 5. Weekly payroll is 3,500 in Weeks 1, 3, 5, 7, 9, 11, and 13. Recurring operating costs total 1,400 each week, while a 2,500 insurance payment is expected in Week 6.

In Week 1, the forecasted outflow is 4,900, producing a closing balance of 13,100 if there are no inflows. In Week 2, the 6,000 receipt and 1,400 operating cost produce net positive movement of 4,600, raising the projected closing balance to 17,700. In Week 6, the recurring cost and insurance payment create 3,900 of outflows before any other bills are considered. The forecast makes that week visible early enough to confirm the client payment schedule or delay a discretionary purchase.

The owner should then replace each estimate with the actual amount and clearing date. If the Week 2 client payment arrives in Week 3, the variance is not simply a missing sale; it is a one-week timing change that affects every subsequent balance.

Freelancer example

A freelancer starts with 7,500. A completed project invoice for 2,400 is expected in Week 1, a new-project deposit of 1,500 is possible in Week 3, and a second invoice for 3,000 is expected in Week 7. Regular outflows include 850 per week for living or business transfers, 120 for software and communications, and a 900 quarterly tax reserve in Week 8.

The 1,500 deposit should carry a Medium or Low confidence rating until the client accepts the proposal and confirms the payment step. The freelancer can model two cases: one with the deposit in Week 3 and one without it. If the cautious case approaches the minimum cash threshold, the action might be to request a deposit before starting, move a nonessential purchase, or revise the project schedule. The freelancer's project pricing framework can support better deposit and payment-term decisions, while a free invoice template guide can help keep invoice details and due dates consistent.

For a larger decision, compare the forecast against project capacity and profitability rather than cash alone. A new project may add revenue but still create a near-term cash gap if it requires subcontractors or unpaid preparation. The client profitability calculator is useful for reviewing margin and time alongside expected receipts.

When to recalculate

Update the forecast once a week on a consistent day, ideally after bank transactions have been matched and before new spending decisions are made. Use this repeatable procedure:

  1. Enter the actual closing bank balance.
  2. Replace the prior week's estimates with actual receipts and payments.
  3. Record the amount and date variance for important items.
  4. Review every invoice expected in the next four weeks and adjust for confirmed payment information.
  5. Check payroll, tax, loan, subscription, and supplier commitments.
  6. Add new one-time payments and remove items that have cleared.
  7. Recalculate the minimum cash threshold and test a cautious case.
  8. Assign an action to every projected shortfall, such as collecting an overdue invoice, rescheduling discretionary spending, or confirming financing options.

Recalculate immediately when pricing inputs change, a major client delays payment, a new hire is planned, a large purchase is considered, borrowing changes, or a recurring contract is cancelled. Review assumptions more broadly whenever payroll or tax arrangements change, banking or accounting software changes, or inflation affects important operating costs. Payment terms should also be refreshed when customer behavior changes.

Keep a dated copy or change log so you can see whether the business regularly overestimates collections or underestimates expenses. After several cycles, use the variance history to improve confidence ratings and timing assumptions. A forecast is most valuable when it becomes a weekly operating habit: update it, investigate the next cash constraint, take a specific action, and compare the result with the following week's actuals.

Before approving a hire, equipment purchase, marketing commitment, or other significant expense, extend the forecast far enough to show the cash impact and test a delayed-receipt scenario. This simple discipline helps separate an affordable decision from one that depends on every assumption going perfectly.

Related Topics

#cash flow#small business finance#forecasting#spreadsheets#planning
R

Recurrent Editorial Team

Business Tools and Finance 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.