# Cash Flow Forecast Template for Excel and Google Sheets: How to Choose One

Source: https://cashflowforecast.openfollowup.com/guides/cash-flow-forecast-template-excel
Updated: September 25, 2026

> A good cash flow forecast template for Excel or Google Sheets has an opening balance that rolls forward, editable cash in and cash out lines, weekly and monthly views, a minimum cash buffer warning and an actual vs forecast tracker. Free templates cover the basics; industry templates add pre-built lines, scenarios and a dashboard.

Most small businesses forecast cash in a spreadsheet, and for good reason: Excel and Google Sheets are flexible, cheap and familiar, and a well-built template does the heavy lifting. But templates vary enormously. Some are little more than a blank grid; others quietly contain formula errors that make every closing balance wrong. This guide explains what a good cash flow forecast template for Excel or Google Sheets should include, how free and paid templates differ, and how to choose one that fits your business.

## What every template needs

- **A rolling balance.** The closing balance of each period must feed the next period’s opening balance automatically. If you have to type opening balances by hand, errors creep in.
- **Timing, not profit.** Lines should represent when cash moves, not when sales are booked or costs are incurred.
- **Editable lines.** You should be able to rename and add lines, and totals should include new rows automatically.
- **A buffer warning.** Any week or month below your minimum balance should stand out, usually in red.
- **An actuals column or tab.** You need somewhere to record what really happened, so you can compare and improve.
- **A clear input colour.** Cells you type into should look different from formula cells, so you don’t overwrite a formula by accident.
- **No macros or external links.** They break in Google Sheets and often trigger security warnings.

## Free vs premium templates

| Feature | Free template | Industry template |
|---|---|---|
| 12-month monthly view | Yes | Yes |
| 13-week weekly view | Separate file | Linked in the same file |
| Industry cash lines | Generic | Pre-built |
| Industry calculation tabs | No | Yes, such as collections, stock or subscriptions |
| Best / worst case scenarios | No | Yes, one switch |
| Actual vs forecast tracking | Basic | With variance highlights |
| Dashboard and charts | Balance chart | Full dashboard |
| 3-year outlook | No | Yes |

A free template is enough if your business is simple, you’re new to forecasting or you mainly need to see the next few months. An industry template saves time when your cash timing is complicated: construction retainage, restaurant food costs, ecommerce stock bought months ahead or SaaS subscribers and churn.

## Excel or Google Sheets?

Use **Excel** if you work offline, your accountant uses Excel, or you want the widest choice of charting and formatting. Use **Google Sheets** if several people update the forecast, you want it in the browser or on your phone, or your business already runs on Google Workspace.

A well-built template works in both. Watch for templates that rely on newer Excel-only functions, macros or complex charts, which may not survive the move to Google Sheets. Our templates use only functions that work in both.

## Weekly, monthly or both?

A **13-week weekly view** is for managing the next quarter: payroll weeks, supplier runs and chasing invoices. A **12-month monthly view** is for planning: hiring, purchases, seasonality and funding. Many businesses need both, ideally in the same file so the numbers agree. The [13-week cash flow forecast guide](/guides/13-week-cash-flow-forecast) explains when weekly detail matters.

## Pick by industry

Cash flow looks very different across industries:

- **Restaurants** need food and drink costs tied to sales, weekly payroll and delivery app payouts.
- **Construction** needs progress billing, client payment delays and retainage.
- **Ecommerce and retail** need stock purchases pulled forward by supplier lead times.
- **SaaS, gyms and daycares** need recurring revenue built from customers and churn.
- **Landlords** need a rent roll with vacancies and annual tax bills.
- **Agencies, law firms and medical practices** need invoices converted into collections using each client’s or insurer’s real payment delay.
- **Nonprofits and churches** need grant installments and seasonal giving scheduled month by month, with restricted funds kept separate.
- **Startups** need burn, runway and a funding schedule kept apart from operating cash.

Starting with the right lines and calculations saves hours and avoids forgotten costs. See [all industry templates](/cash-flow-forecast-template).

## How to check a template before you rely on it

Before trusting any template, spend five minutes testing it:

1. Change the opening balance by $1,000 and check every closing balance moves by exactly $1,000.
2. Add a new line inside a section and check the totals include it.
3. Put a large payment in one month and check the following months’ opening balances fall by that amount.
4. Check the buffer warning turns red when a balance falls below your minimum.
5. Open it in Google Sheets if you plan to use Sheets, and check nothing shows an error.

If a template fails any of these, fix it or choose another.

## Setting up your template

1. Save a clean copy before you start, so you can always go back.
2. Replace the example figures with yours, starting with the settings: start date, opening balance and buffer.
3. Rename lines to match your business, and delete lines you don’t need.
4. Enter receipts and payments in the period they actually move.
5. Review the lowest balance and plan for it.
6. Book a weekly or monthly slot to update it with actual figures.

Step-by-step detail is in [how to make a cash flow forecast](/guides/how-to-make-a-cash-flow-forecast).

## The formulas behind a good template

You don’t need to write formulas to use a template, but knowing what they do helps you trust it and fix it:

- **Closing balance** = opening balance + total cash in − total cash out, for each period.
- **Opening balance** for every period after the first = the previous period’s closing balance. Only the very first opening balance is typed in.
- **Totals** use SUM over the full range of lines in each section, so a row inserted inside the section is included automatically.
- **Buffer warning** uses conditional formatting: if a closing balance is below the minimum buffer cell, colour it red.
- **Weeks or months below buffer** = COUNTIF of the closing balance row, less than the buffer.
- **Lowest balance and when** = MIN of the closing balance row, and MATCH to find which period it falls in.

These are all functions that have existed in Excel for many years and work identically in Google Sheets, which is why a template built only on them opens anywhere. Named cells for settings such as the start date and buffer make the formulas easier to read and harder to break.

## Mistakes people make with spreadsheet forecasts

- **Hard-typed numbers inside formula rows.** Someone overwrites a total with a figure to “fix” it, and the sheet stops adding up. Keep inputs and formulas visibly different.
- **Copy-and-paste errors.** A formula copied across one column too many, or one row too few, silently misses a line. Test totals after every structural change.
- **Several versions.** “Forecast final v3 (2).xlsx” in someone’s inbox is not the forecast. Keep one shared file.
- **No actuals.** Without actual figures alongside, you can’t tell whether the forecast is any good.
- **Too clever.** Dozens of tabs, macros and lookups make a template fragile and slow to update. Simple and current beats sophisticated and stale.

## When to move to software

Spreadsheets serve most small businesses well. Consider dedicated forecasting software when you need live bank feeds, forecasts for several companies or currencies, many people editing daily, or integration with accounting software for automatic actuals. Until then, a good template is faster to set up and easier to understand.

## Free and premium options

### Does Excel have a built-in cash flow forecast template?
Excel includes some basic templates, but most lack weekly views, scenarios, buffer warnings and actual vs forecast tracking.

### Can I use an Excel cash flow template in Google Sheets?
Yes, if it avoids macros and newer Excel-only functions. Upload the .xlsx file to Google Drive and open it with Google Sheets.

### Should I use a spreadsheet or cash flow software?
Spreadsheets are cheaper, flexible and work for most small businesses. Software helps when you need live bank feeds, many entities or several people editing daily.

### What is the best cash flow forecast template for a small business?
One that matches your industry’s cash lines and timing, has weekly and monthly views, and is simple enough that you will update it every week.

### How do I import bank data into a template?
Export transactions from your bank as CSV, then paste them into an actuals tab grouped by category, or total them by category and type the totals in.