Cash Flow Forecast Template for 13-Week Business Planning

Overview

This article gives you a reusable structure for a 13 week cash flow forecast template that can live in Excel or Google Sheets. The goal is not to create a perfect long-range financial model. The goal is to create a weekly operating view that is simple enough to maintain and detailed enough to support decisions.

A weekly cash forecast works because most cash pressure shows up in the near term. Payroll runs on fixed dates. Rent, debt service, software subscriptions, and vendor bills usually follow known schedules. Customer collections may be less predictable, but they can still be estimated by invoice date, payment terms, and recent collection patterns. When these items are organized week by week, leadership can see whether cash is likely to tighten, stabilize, or improve.

For many teams, this becomes a standing management document. It is reviewed in the same meeting each week, updated with actual collections and disbursements, and adjusted as new information comes in. That repeatable habit is often more valuable than the spreadsheet itself.

A solid cash flow forecast spreadsheet usually helps with five practical questions:

• How much cash do we expect to have at the end of each week?
• Which weeks are likely to be tight?
• Which receipts are most important to collect on time?
• Which payments are fixed, flexible, or negotiable?
• How many weeks of runway do we have under current assumptions?

If you are already using planning tools across operations, this forecast fits naturally alongside a decision log, ownership matrix, and KPI reviews. For example, a forecast assumption that depends on a vendor switch or project launch should be documented in a decision log template for leadership teams and project managers. If multiple functions contribute inputs, ownership can be clarified with a RACI matrix template for cross-functional project planning.

Template structure

Here is the simplest structure for a weekly cash flow template that remains useful over time. You can build it on one tab for small teams or split it into inputs and summary tabs for more control.

1. Header and control fields

At the top of the sheet, include a small control area:

• Business name
• Forecast owner
• Version date
• Week 1 start date
• Currency
• Scenario selector if you use base, conservative, and upside cases

These fields seem minor, but they make the file easier to govern. A cash forecast loses value when people are unsure which version is current.

2. Weekly columns

Create 13 columns, one for each week. Label each column with the week start date or a week-ending Friday date. Consistent date labels matter because collections and payments often shift by only a few days, and those shifts can change the risk profile of a week.

A typical layout looks like this:

• Week 1
• Week 2
• Week 3
• ...
• Week 13

You may also want a final total column for the 13-week period, but the weekly view should remain the main focus.

3. Beginning cash row

The first critical line is Beginning Cash Balance. Week 1 should tie to your latest bank position or your most recent reconciled cash number. Each following week should reference the prior week’s ending balance.

Basic logic:

• Week 1 beginning cash = current available cash
• Week 2 beginning cash = Week 1 ending cash
• Week 3 beginning cash = Week 2 ending cash

Keep this formula protected if possible. It is the backbone of the forecast.

4. Cash receipts section

Under the opening balance, list all expected sources of incoming cash. Keep categories detailed enough to be actionable but not so detailed that maintenance becomes a burden.

Common receipt lines include:

• Customer collections from existing invoices
• Cash sales or point-of-sale receipts
• Subscription renewals
• New customer deposits
• Loan proceeds
• Owner contributions
• Tax refunds
• Other one-time receipts

Separate recurring operating receipts from one-off items. That distinction helps readers avoid mistaking a temporary inflow for ongoing improvement.

5. Cash disbursements section

Next, list outgoing cash by category. The best category structure usually follows how you actually manage payments.

Common disbursement lines include:

• Payroll
• Payroll taxes and benefits
• Rent or facility costs
• Loan principal and interest
• Accounts payable to vendors
• Inventory purchases
• Software and subscriptions
• Marketing spend
• Contractor payments
• Insurance
• Sales tax or income tax payments
• Equipment purchases
• Owner draws or distributions
• Other one-time payments

For some teams, it helps to split disbursements into three groups:

• Fixed: payroll, rent, debt service
• Variable: inventory, commissions, ad spend
• Discretionary or deferrable: projects, nonessential purchases, timing-flexible vendor payments

That grouping makes the forecast more useful in a pressure scenario because it highlights which outflows can realistically move.

6. Net cash movement and ending cash

After receipts and disbursements, add summary rows:

• Total cash receipts
• Total cash disbursements
• Net cash movement
• Ending cash balance

Core formulas:

• Net cash movement = total receipts - total disbursements
• Ending cash = beginning cash + net cash movement

This is the minimum needed for an effective business cash planning tool.

7. Optional risk and runway rows

If you want a more decision-ready template, add:

• Minimum target cash balance
• Variance to target cash
• Weeks with projected negative cash
• Estimated runway under current assumptions

This turns the file into a lightweight cash runway template. For example, if your policy is to keep four weeks of payroll in cash, a variance row can show when you are expected to drop below that threshold.

8. Assumptions and notes section

Every forecast should include a small notes area. This is where you document assumptions such as:

• Top five expected customer payments and their collection dates
• Timing of tax payments
• Planned inventory purchase timing
• Large one-time legal or equipment costs
• Whether a financing event is assumed or not

Without notes, a cash forecast can become a black box. With notes, it becomes a management tool.

How to customize

The best template is the one your team will actually update each week. That usually means tailoring the line items and review process to match your operating model.

Adjust categories to fit your business

A service business may need detailed payroll, contractor, and receivables sections. A product business may need more focus on inventory buys, freight, and supplier terms. A subscription business may track renewals and failed payments by cohort or billing week. Keep categories tied to real cash drivers, not generic chart-of-accounts clutter.

If you need help pressure-testing your cost structure, it can also help to compare your overhead profile with broader operating patterns using resources like operating expense benchmarks for SaaS and service businesses or revenue per employee benchmarks by company size and industry.

Choose a realistic collections method

Many cash forecast errors come from optimistic collections assumptions. A practical approach is to forecast incoming cash using three layers:

1. Invoices already issued, adjusted for likely payment timing
2. Committed sales not yet invoiced
3. Expected new business only if your process supports a reliable estimate

If you are uncertain, start conservative. It is usually safer to underestimate receipts and tighten later than to overestimate and be surprised.

Separate actuals from forecast

One of the most useful upgrades in a cash flow forecast spreadsheet is to show actual cash once a week closes. You can do this by using separate rows for:

• Forecast receipts
• Actual receipts
• Forecast disbursements
• Actual disbursements
• Weekly variance

This makes the file self-correcting. Over time, you can see where your assumptions tend to drift and improve the model.

Build in simple scenarios

If the business is exposed to timing risk, add three scenarios:

• Base case: current expectations
• Conservative case: slower collections, stable expenses
• Upside case: stronger receipts or delayed spend

You do not need a complex dashboard. Even a few side-by-side rows showing ending cash under each scenario can improve weekly decisions.

Assign owners for key inputs

A useful forecast depends on timely updates from different functions. Typical ownership might look like this:

• Finance: bank balance, debt, taxes, payroll timing
• Sales or account management: expected customer collections
• Operations: vendor payments, inventory purchases, project costs
• Leadership: hiring, distributions, financing decisions

If there is any ambiguity about who updates what, define roles clearly. That is where a RACI can help. If a vendor switch affects cost timing, a vendor comparison matrix template for business software evaluation can also support a more disciplined assumption set.

Keep the file decision-oriented

A forecast should not just report cash. It should help you act. Add a short action box at the top or bottom of the sheet with fields such as:

• Biggest risk this week
• Largest expected receipt
• Largest expected payment
• Decision needed before next review
• Owner and due date

This small addition often turns the spreadsheet from a finance artifact into a management routine.

Examples

These examples show how the same template can be adapted across different operating contexts.

Example 1: Small service business

A consulting firm with 18 employees reviews its 13-week forecast every Monday. Most receipts come from invoices due on net-30 terms, and the biggest outflows are payroll, contractor support, rent, and software.

In this version of the template:

• Receipts are grouped by major client and invoice month
• Disbursements include payroll by pay date, benefits, tax deposits, and contractor invoices
• A note flags two large receivables that may slip into the following week
• The action box includes client follow-up owners for overdue invoices

The forecast reveals that Week 6 is tight because payroll and quarterly taxes land before a large client payment is expected. That gives the firm time to accelerate collections or move a discretionary software purchase.

Example 2: Product business with inventory swings

A wholesale business has uneven cash needs because inventory purchases are lumpy. Revenue may look healthy on paper, but cash pressure rises when stock has to be ordered before customer payments arrive.

In this template:

• Receipts are divided into retail cash sales, wholesale collections, and customer deposits
• Disbursements separate inventory purchases from regular vendor payables
• The assumptions tab tracks lead times and planned ordering windows
• A minimum cash threshold is set to avoid stockouts while protecting payroll

The weekly forecast helps management decide whether to stagger purchase orders or negotiate supplier terms. It also shows that one aggressive buying week would reduce cash below the target threshold.

Example 3: Subscription software company

A SaaS business uses a cash forecast to complement its KPI reviews. The company already tracks metrics like CAC, churn, and gross margin, but the short-term cash view is needed for hiring and marketing timing.

In this version:

• Receipts include recurring subscriptions, annual prepayments, and implementation fees
• Disbursements focus on payroll, cloud infrastructure, contractor spend, and paid acquisition
• Management compares planned marketing spend with expected cash headroom
• The notes section flags assumptions around renewal timing and annual contract billings

This forecast becomes more useful when used alongside broader KPI context such as SaaS KPI benchmarks: CAC, LTV, churn, NRR, and gross margin and a customer acquisition cost calculator with payback period benchmarks.

Example 4: Owner-managed business preparing for a lender conversation

An owner needs a clear weekly picture before discussing a line of credit renewal. The business does not need a complex board model. It needs a credible, current file.

The forecast includes:

• Starting cash tied to bank statements
• Named major receipts with expected dates
• Debt service shown separately from operations
• One-off items clearly marked
• A conservative scenario with slower collections

This makes the discussion more grounded. The owner can explain not just current cash, but expected timing risk and the actions already planned to manage it.

When to update

A 13-week forecast only works if it is updated regularly. This is not a file to build once and forget. It is meant to be revisited whenever actual cash, assumptions, or payment timing changes.

At minimum, update the forecast weekly. A simple operating rhythm looks like this:

1. Pull the latest cash balance and prior week actuals.
2. Replace forecasted Week 1 numbers with actual receipts and disbursements.
3. Roll the model forward by adding a new Week 13.
4. Review the next three to six weeks for pressure points.
5. Assign follow-ups for collections, payment timing, and spending decisions.

You should also update the file immediately when any of the following happens:

• A major customer payment is delayed
• Payroll changes because of hiring, bonuses, or reductions
• A tax or debt payment date changes
• A large vendor invoice is approved
• You commit to new software, equipment, or lease costs
• You plan a financing event, owner draw, or capital injection

As your workflow matures, document recurring assumptions and meeting outputs so the process is easier to maintain. Some teams use AI tools to summarize weekly finance reviews and action items. If that is useful in your operating cadence, see AI prompt templates for executive summaries, board updates, and team briefs and best AI tools for summarizing meeting notes and action items.

For your next step, create the first version of the template with only the categories you can confidently maintain. Start with beginning cash, customer collections, payroll, taxes, major vendor payments, debt service, and ending cash. Run the review at the same time each week. Then improve the file as patterns become clear. A good 13 week cash flow forecast template is not the most detailed one. It is the one your team trusts enough to use before decisions become urgent.