# Cash flow forecast sheet (free Excel template)

> A 13-week and 12-month cash forecast from opening cash, customer and supplier due dates, with actual vs forecast and a below-minimum alert.

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

---

Free Excel template

# Cash flow forecast sheet

A free Excel cash flow forecast. You enter your opening balance, customer and supplier invoices with their due dates, and items such as salaries, rent, loan installments and taxes. The sheet builds a 13-week and a 12-month forecast showing the closing balance for each period, and alerts you to the first week and first month in which cash falls below the minimum you set. After each week ends you record what actually happened, so you can see the variance from the forecast.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

| الأسبوع | المقبوضات | المدفوعات | الصافي | الرصيد الختامي | الحالة |
| --- | --- | --- | --- | --- | --- |
| أسبوع 1 | 25,000.00 | 61,500.00 | -36,500.00 | 73,500.00 |  |
| أسبوع 2 | 57,000.00 | 12,700.00 | 44,300.00 | 117,800.00 |  |
| أسبوع 3 | 30,000.00 | 0.00 | 30,000.00 | 147,800.00 |  |
| أسبوع 4 | 52,000.00 | 103,000.00 | -51,000.00 | 96,800.00 |  |
| أسبوع 5 | 33,500.00 | 20,200.00 | 13,300.00 | 110,100.00 |  |
| أسبوع 6 | 15,000.00 | 27,800.00 | -12,800.00 | 97,300.00 |  |
| أسبوع 7 | 81,000.00 | 79,800.00 | 1,200.00 | 98,500.00 |  |
| أسبوع 8 | 10,000.00 | 74,500.00 | -64,500.00 | 34,000.00 | تحت الحد |
| أسبوع 9 | 37,000.00 | 32,300.00 | 4,700.00 | 38,700.00 | تحت الحد |
| أسبوع 10 | 60,000.00 | 56,500.00 | 3,500.00 | 42,200.00 | تحت الحد |
| أسبوع 11 | 54,000.00 | 3,000.00 | 51,000.00 | 93,200.00 |  |
| أسبوع 12 | 36,000.00 | 11,200.00 | 24,800.00 | 118,000.00 |  |
| أسبوع 13 | 0.00 | 65,000.00 | -65,000.00 | 53,000.00 | تحت الحد |

Example from the “ملخص التدفق” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "ملخص التدفق" (Cash Flow Summary): The lowest forecast balance and its week, the first week and first month below the minimum and when they start, the shortfall at the lowest point, what is still to collect from customers and still to pay to suppliers and how much of each is overdue, with a weekly table, a monthly table and four charts.
- "توقع 13 أسبوع" (13-Week Forecast): For each week: opening balance, receipts (customer collections, cash sales and other income), payments (suppliers, salaries, rent, installments, taxes and expenses), net cash flow, closing balance and a "تحت الحد" (Below minimum) alert, then the actual and variance for weeks that have ended.
- "توقع 12 شهر" (12-Month Forecast): The same layout over 12 months from the forecast start date, reading from the same sheets.
- "مستحقات العملاء" (Customer Receivables): One invoice per line with its due date, amount and amount collected. The sheet calculates the remaining balance and the expected collection date after adding the delay days, and a status of overdue ("متأخر"), upcoming ("قادم") or collected ("محصّل"). It holds 200 invoices.
- "مستحقات الموردين" (Supplier Payables): Supplier invoices handled the same way, so the remaining balance goes into payments on its due date. It holds 200 invoices.
- "بنود أخرى متوقعة" (Other Expected Items): Whatever does not come from invoices: cash sales, other income, salaries, rent, loan installments, taxes and expenses, each with a date, amount and a category from a list. It holds 300 items.
- "الفعلي" (Actuals): A log of what you actually received and paid, with date and category. The sheet compares it with the forecast for weeks and months that have ended. It holds 500 transactions.
- "الإعدادات" (Settings): Opening balance, forecast start date, minimum cash, collection delay days, today's date, the number of weeks and months that have ended, and the list of cash flow categories, whose names you can edit.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

Due dates build the forecast: each customer or supplier invoice lands in the week and month when you expect to receive or pay it, and overdue unpaid invoices move to the first period that has not ended. So you see weeks ahead that your balance will fall below the minimum, not on the day the cash runs out.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter the opening balance, the forecast start date (preferably the first day of a month), the minimum cash, today's date, and the number of weeks and months that have actually ended.
2. In "مستحقات العملاء" (Customer Receivables), enter each invoice not fully collected with its due date, amount and amount collected. In "مستحقات الموردين" (Supplier Payables), enter supplier invoices the same way.
3. In "بنود أخرى متوقعة" (Other Expected Items), enter expected cash sales, other income, salaries, rent, installments, taxes and expenses, each with its date.
4. Open "توقع 13 أسبوع" (13-Week Forecast) and "توقع 12 شهر" (12-Month Forecast) to see receipts, payments and the closing balance for each period, and the "تحت الحد" (Below minimum) alert when the balance falls under the minimum.
5. Each week, record what actually happened in the "الفعلي" (Actuals) sheet and increase the weeks ended in Settings, and the variance from the forecast appears. Open "ملخص التدفق" (Cash Flow Summary) to see the lowest balance and the first period with a shortfall.

**Before you start:**

- Customer receivables: the "collection delay days" from Settings are added to the due date to get the expected collection date. Overdue unpaid invoices move to the first period that has not ended.
- Periods that have ended take the full invoice amount as it was forecast, and upcoming periods take only the remaining balance, so the variance between forecast and actual is correct. Delete invoices that were paid before the forecast start date.
- Closing balance = opening balance + receipts - payments. "تحت الحد" (Below minimum) appears when the balance is lower than the minimum cash in Settings.
- Other items are chosen from the category list in Settings (you can edit the names). The "تحصيلات العملاء" (Customer collections) and "سداد الموردين" (Supplier payments) categories come only from the two receivables and payables sheets.
- The sheet holds 200 customer invoices, 200 supplier invoices, 300 expected items and 500 actual transactions. Actual vs forecast appears only for weeks and months that have ended.
- Figures and names are made-up examples, and the tax items include only a general line: apply the rules of your local law.

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

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

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

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

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: cash flow forecast (1/3)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-1.jpg)[![Cheat sheet: cash flow forecast (2/3)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-2.jpg)[![Cheat sheet: cash flow forecast (3/3)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/cash-flow-forecast/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet needs someone to copy every invoice and payment into it. In Accountwiro an invoice and a payment are recorded the moment they happen, and the customer's balance shows in a single statement of account.

| In this sheet | In Accountwiro |
| --- | --- |
| You copy every invoice and payment into the sheet by hand. | It shows the customer's invoices, payments and outstanding balance in a single statement of account. |
| Invoices are typed or copied by hand. | It creates an invoice by scanning a barcode or searching by product name, calculates discounts and taxes, and sends it to the customer over WhatsApp. |
| Stock shortages are discovered late. | It updates quantities after every sale and alerts you when a product drops below the required level. |
| Anyone who opens the sheet sees every number. | Permissions per user: the sales employee issues invoices, and the warehouse employee manages stock without access to financial data. |

[See Accountwiro](https://softwiro.com/systems/budoor.html) · [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 |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

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

## Frequently asked questions

### What is the difference between a 13-week and a 12-month forecast?

The weekly forecast is precise and short-term. It suits tracking liquidity each week and deciding which day to postpone a payment or speed up a collection. The monthly forecast is broader and suits planning salaries, rent, taxes and loans over the year. The sheet shows both from the same data.

### How does the sheet know when I will collect from a customer?

You enter the invoice due date, and the sheet adds the "collection delay days" you set in Settings to calculate the expected collection date. An overdue invoice that has not been collected goes into the first week or month that has not ended.

### What does "below minimum" mean?

It appears when the forecast closing balance for a week or month is lower than the "minimum cash" you enter in Settings. That is a figure you estimate yourself, such as one month of expenses or payroll. The cash flow summary shows the first week and first month below the minimum and the size of the shortfall.

### How do I compare actual with forecast?

Record what you received and paid in the "الفعلي" (Actuals) sheet, then increase "weeks ended" and "months ended" in Settings. For those periods the sheet shows actual receipts, actual payments and actual balance, and their difference from the forecast.

### 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

- Journal entries, trial balance and financial statements sheet
- Business expenses and monthly budget sheet
- Annual budget by department: plan vs actual
- Fixed assets register and depreciation sheet
- Accounting rules and equations summary sheet: double entry, statements and financial ratios
- Project budget vs actual sheet
- Simple daily expense sheet (phone-first)
- Multi-warehouse and branch inventory sheet with transfers
- Periodic stock count and count-difference reconciliation sheet
- Restaurant and cafe inventory and waste sheet
- Spare parts inventory sheet
- Barcode, batch and expiry inventory sheet
- Padel and 5-a-side court booking sheet (hourly)

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