# Cash Flow Forecast Template Excel (12 Months)

> A free 12-month Excel cash flow forecast: list what you expect to receive and pay each month, see closing cash, get a minimum-cash warning and test what-ifs.

Source: https://softwiro.com/templates/cash-flow-forecast-template
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Cash Flow Forecast Template for Excel (12 Months)

A free Excel cash flow forecast for a small business. You type what you expect to receive and to pay in each of the next 12 months. The sheet carries the cash forward month by month, shows the balance you will have at every month end, and turns the month yellow or red when it falls under the minimum you set or below zero. Two what-if boxes let you cut sales or raise costs in one move, and an Actual row lets you compare the forecast with the real bank balance as each month closes. It works in Excel, LibreOffice and Google Sheets, in any currency.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-cash-flow-forecast-template.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-cash-flow-forecast-template-blank.xlsx)

Excel file (.xlsx) · 22 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| Forecast starts | 46327 | Everything here is calculated from the Forecast sheet. Change the settings on the Settings sheet. |  |  |  |
| --- | --- | --- | --- | --- | --- |
|  |  |  |  |  |  |
| Opening cash | 10,000.00 | Closing cash, month 12 |  | 56,030.00 |  |
| Cash in (12 months) | 374,500.00 | Lowest closing cash |  | 4,920.00 |  |
| Cash out (12 months) | 328,470.00 | Month of lowest cash |  | Jan 2027 |  |
| Net cash flow (12 months) | 46,030.00 | Months below minimum cash |  | 2 |  |
| Average net cash flow per month | 3,835.83 | First month below minimum |  | Jan 2027 |  |
| Month | Cash in | Cash out | Net | Closing cash | Minimum cash |
| Nov 2026 | 28,500 | 25,260 | 3,240 | 13,240 | 8,000 |
| Dec 2026 | 36,500 | 27,270 | 9,230 | 22,470 | 8,000 |
| Jan 2027 | 24,300 | 41,850 | -17,550 | 4,920 | 8,000 |
| Feb 2027 | 25,300 | 24,080 | 1,220 | 6,140 | 8,000 |
| Mar 2027 | 38,500 | 23,710 | 14,790 | 20,930 | 8,000 |
| Apr 2027 | 30,200 | 27,470 | 2,730 | 23,660 | 8,000 |
| May 2027 | 32,000 | 26,240 | 5,760 | 29,420 | 8,000 |
| Jun 2027 | 32,500 | 25,170 | 7,330 | 36,750 | 8,000 |
| Jul 2027 | 30,700 | 27,830 | 2,870 | 39,620 | 8,000 |
| Aug 2027 | 30,000 | 25,760 | 4,240 | 43,860 | 8,000 |
| Sep 2027 | 31,700 | 24,920 | 6,780 | 50,640 | 8,000 |
| Oct 2027 | 34,300 | 28,910 | 5,390 | 56,030 | 8,000 |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Opening cash, 12-month cash in, cash out and net flow, closing cash, the lowest point and the month it happens, how many months fall below your minimum and the first one, with three charts: cash in against cash out, closing cash against your minimum, and cash out by item.
- Forecast: The 12-month grid. Five cash in lines and twelve cash out lines you can rename, then cash in and out after the what-if, opening cash, net cash flow, closing cash, headroom above the minimum, a status for each month, and an Actual row with the difference from the forecast.
- Settings: Business name, currency symbol, the first month, opening cash, the minimum cash to keep, and the two what-if percentages for cash in and cash out.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

Most free forecasts stop at a grid of months. This one tells you which month your cash gets tight, how far under your minimum it goes and when it recovers, then lets you test a weaker sales year without retyping a number. The sample is a small bakery that buys a new oven in January 2027, so you can see a real dip and the warning it triggers before you replace the figures with your own.

## How do I build a 12-month cash flow forecast in Excel?

Start with the cash you really hold today: bank balances plus the till. Type it on Settings as opening cash, and pick the first month. Then fill in each cash in line (sales receipts, other income, loans) and each cash out line (stock, wages, rent, tax, loan repayments, equipment) for every month. The closing cash of one month becomes the opening cash of the next, so you never type a balance yourself.

Forecast the month the money moves, not the month of the invoice. A sale invoiced in November and paid in December belongs in December, and a quarterly insurance bill belongs in the month it leaves the account.

## What should a cash flow forecast include?

Cash in: customer receipts, other income, and money you borrow or invest. Cash out: suppliers, wages, rent and utilities, marketing, loan repayments, tax payments, equipment purchases and anything you take out as an owner. Leave out items that do not move cash, such as depreciation.

In the sample, 12 months of cash in total 374,500 and cash out totals 328,470, a net inflow of 46,030. The totals hide the problem: buying a 16,000 oven in January 2027 drops closing cash to 4,920, which is under the 8,000 minimum, and February is still under at 6,140. The 10,000 loan in March brings it back to 20,930.

## How do I test what happens if sales fall?

Type -10% in the what-if box for cash in on Settings and every cash in line drops by a tenth in all 12 months. Closing cash, the status row and the Dashboard update at once. Put it back to 0% for your base case. Use the other box for a cost increase.

Compare the result with a break-even view of your business using the [break-even calculator](https://softwiro.com/tools/break-even), and plan day-to-day spending with the [business expenses budget](https://softwiro.com/templates/small-business-budget-tracker). To record the cash itself as it happens, use the [cash book template](https://softwiro.com/templates/cash-book-template).

## How to use it

1. On the Settings sheet type your business name, currency symbol, the first month of the forecast, the cash in the bank today (opening cash) and the minimum cash you want to keep at every month end.
2. On the Forecast sheet rename the cash in and cash out lines to fit your business. The sample lines are only a starting point.
3. Type the amount you expect to receive or pay in each month, in the month the cash actually moves, not the month of the invoice.
4. Read the closing cash row. It turns yellow when it is under your minimum and red when it is below zero.
5. Change the two what-if percentages on Settings (for example -10% on cash in) to see how a weaker sales month would change the picture.
6. As each month ends, type the real closing bank balance in the Actual row and read the difference from the forecast. Open Dashboard for totals, the lowest point and charts.

**Before you start:**

- Capacity: 12 months, 5 cash in lines and 12 cash out lines. Rename any line; empty lines are ignored.
- Forecast cash, not profit: leave out depreciation and other items that do not move money, and include loan repayments, tax payments and equipment purchases when you actually pay them.
- The what-if percentages apply to every cash in line or every cash out line. Leave them at 0% for your base case.
- The Dashboard shows the 12 months of the Forecast sheet. To roll forward, change the first month and update the opening cash to the real balance.
- Use one currency in one workbook. The currency symbol on Settings is only a label.
- This is a planning tool. Tax and loan terms differ by country, so check your local rules and your lender's schedule for the amounts and dates.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-cash-flow-forecast-template.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-cash-flow-forecast-template-blank.xlsx)

Excel file (.xlsx) · 22 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Still running this on Excel?

This sheet needs you to open it and type in every expense. In MyAccBot you send a photo of the receipt or a voice message on Telegram, and it handles the rest.

| In this sheet | In MyAccBot |
| --- | --- |
| You open the sheet and type in every expense by hand. | You send a photo of the receipt, a line of text or a voice message on Telegram, and the data is extracted and classified as income or expense. |
| You find out about a budget overrun at the end of the month. | You set a monthly spending limit and get an alert at 80% and at 100%. |
| Summing up the month takes hours. | An Arabic PDF report on the first of every month, plus a formatted XLSX file you hand to your accountant. |
| You dig through old receipts looking for an amount. | You ask the bot for the total of a month, between two dates, or for a particular supplier, and it answers from your data. |

[See MyAccBot](https://softwiro.com/product/myaccbot) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| You type every expected amount | Amounts arrive from invoices, bills, payroll and the bank |
| One forecast for the whole business | A forecast per branch or project with a combined owner view |
| What-if is two percentages | Named scenarios compared on one screen |
| You check the Actual row at month end | Daily comparison of the bank balance with the forecast |
| A file you email around | A live dashboard for the owner and the accountant |

### Extra features in the app

- Receipts and payments pulled in from your invoices and bank feed instead of typed in
- Customers and suppliers with due dates, so the forecast fills itself from what is owed
- An alert on your phone before a month goes under your minimum
- Several scenarios saved side by side, such as base, best and worst case
- Forecast against actual reports sent to you and your accountant automatically
- Different people entering their own part of the budget, each with their own permissions

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Is this cash flow forecast template free?

Yes. Download it, use it for your business and change anything you like. There is nothing to sign up for to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses only ordinary formulas (SUM, IF, MIN, COUNT, INDEX, MATCH), so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### How do I roll the forecast forward each month?

When a month ends, type the real bank balance in the Actual row to see how far you were off. To start the next 12 months, change the first month on Settings and put today's real balance in opening cash, then update the amounts.

### Is there a 13-week version?

This file forecasts by month, which suits planning a year ahead. For short-term control of a tight period, check the cash weekly against the bank and use the Actual row to keep the monthly forecast honest.

### Can I add more cash in or cash out lines?

There are 5 cash in lines and 12 cash out lines, and any of them can be renamed. Empty lines are ignored. Combine small items under Other costs if you need more room.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Accounting

## More free templates

- Fixed Asset Depreciation Schedule for Excel
- General Journal and Trial Balance Template for Excel
- Small Business Budget Template for Excel (Monthly)
- Annual Department Budget Template for Excel (Budget vs Actual)
- Customer Statement Template with Aging (Excel)
- Gym Membership Tracker for Excel
- Freelance Project and Invoice Tracker for Excel
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
