Yes—free cash flow forecast templates for Excel are available from Microsoft Create and other spreadsheet providers, although the available files and terms can change. You can also build a simple forecast directly in Excel: list expected cash coming in and going out by month, calculate the net change, and carry each month’s ending balance into the next month.
What a cash flow forecast shows
A cash flow forecast estimates when money will enter and leave a business or household account. It helps answer practical questions such as whether there will be enough cash to cover payroll, rent, supplier invoices, loan payments, or an upcoming large purchase. A forecast is about timing as well as totals: a business can expect to make a profit overall and still run short of cash if customers pay after bills are due.
This is different from a profit and loss statement. A profit and loss statement generally records income and expenses when they are earned or incurred, depending on the accounting method. A cash forecast records the expected timing of receipts and payments. For example, a $5,000 customer invoice issued in January but expected to be paid in March belongs in March’s cash-in forecast, not January’s, if the goal is to predict bank cash.
A template is a starting structure, not a guarantee that its assumptions are right. Forecast figures should be updated as payment dates, sales expectations, costs, and available cash change.
What to look for in a free Excel template
A useful workbook should make it easy to see opening cash, incoming cash, outgoing cash, net cash flow, and the ending balance for each period. Monthly columns are a reasonable starting point for a longer planning horizon; weekly columns can be more useful when cash is tight or payments are frequent. Look for clear labels and formulas that can be inspected rather than a polished dashboard that hides how totals are calculated.
Before using a downloaded file, check that it suits your situation. A small service business may need separate lines for customer receipts, contractor costs, payroll, rent, taxes, and equipment. A household might instead group cash inflows by pay date and outflows by bills and variable spending. A seasonal business may need more than 12 months or a weekly view during its busy period.
- Check whether the template records cash by the date it is expected to move.
- Confirm that the ending balance rolls forward into the next period.
- Make sure you can add or rename categories without breaking totals.
- Review the source, file type, and any stated license or usage restrictions before downloading.
Build a basic forecast in Excel
In Excel for Microsoft 365 on Windows, create a blank workbook and set up one column per month. Put the month names in B3:M3. Use column A for labels. The following layout is deliberately simple and can be expanded with more categories:
- Row 4: Opening cash balance.
- Rows 6–9: Cash inflows, such as cash sales, customer payments, financing received, and other receipts.
- Row 10: Total cash inflows.
- Rows 12–17: Cash outflows, such as supplier payments, payroll, rent, taxes, debt payments, and other costs.
- Row 18: Total cash outflows.
- Row 20: Net cash flow.
- Row 21: Ending cash balance.
Enter expected receipts and payments as positive numbers in their relevant rows. The totals and balances then show the direction of cash clearly without mixing positive and negative entries in every category. For the first month, type the actual opening bank cash in B4. In later months, link the opening balance to the previous month’s ending balance.
For the first month, with inflow entries in B6:B9 and the total in B10, enter =SUM(B6:B9) in B10. If the four inflow values are $8,000, $3,000, $0, and $500, the formula returns $11,500.
With outflow entries in B12:B17 and the total in B18, enter =SUM(B12:B17) in B18. If those six costs are $4,000, $3,000, $1,500, $500, $0, and $0, the result is $9,000. Check the arithmetic: 4,000 + 3,000 + 1,500 + 500 equals 9,000.
With total inflows in B10 and total outflows in B18, enter =B10-B18 in B20. Using the example values of $11,500 and $9,000, this returns net cash flow of $2,500.
With opening cash in B4 and net cash flow in B20, enter =B4+B20 in B21. If opening cash is $10,000, the ending balance is $12,500. In the next month, with the prior month’s ending balance in B21 and the next opening balance in C4, enter =B21 in C4. That carries $12,500 forward; copy the link across subsequent months as the forecast grows.
Make the forecast useful, not just tidy
Separate estimates from known amounts. For example, an invoice already issued with an agreed due date may be a more reliable forecast entry than sales that have not yet been booked. If estimates are uncertain, make that visible with a note or a separate optimistic and cautious scenario, rather than quietly treating a guess as certain.
Record cash in the period it is expected to arrive or leave. If a customer typically pays 30 days after invoicing, putting the sale in the invoice month can overstate cash available in that month. Likewise, record a bill when it is expected to be paid, not merely when the service was used. Keep a separate note of assumptions, such as a planned hiring date or a supplier’s payment terms, so you can revisit them later.
Compare forecasts with actual bank activity on a regular schedule. Replace outdated assumptions, investigate material differences, and extend the forecast forward. The point is not to make every prediction exact; it is to spot a possible shortfall early enough to examine the timing and available options.
Common template problems and how to avoid them
One frequent error is confusing revenue with cash collected. A sale made on credit is not cash in the bank until the customer pays. Another is forgetting less frequent payments, such as annual insurance, quarterly taxes, equipment purchases, or loan installments. These can create a misleadingly comfortable monthly picture if they are omitted.
- Double-counted receipts: Do not enter the same customer payment once as a sale and again as a bank deposit. Choose a consistent cash-based entry point.
- Unrealistic timing: Use expected payment dates, not only invoice dates or contract dates.
- Missing starting cash: The opening balance should match the relevant account or clearly defined group of accounts on the forecast start date.
- Broken carry-forward: Check that each month opens with the prior month’s ending balance, especially after inserting or deleting rows.
- Overly broad categories: A single “expenses” line can hide the reason for a cash dip. Split out major costs that affect decisions.
- Old assumptions: A forecast left untouched can look precise while no longer reflecting current payment patterns.
For a downloaded workbook, inspect formulas before relying on totals. Avoid enabling macros unless you understand why the file needs them and trust its source; a basic forecast usually does not need macro-enabled features. Keep an untouched copy of the original and save your working version with a clear date or name.
Choosing a template or making your own
Microsoft Create and other providers may offer downloadable Excel templates, but availability, sign-in requirements, and permitted uses can change. Search the provider’s current catalog for a cash flow forecast, then confirm that the download is an Excel workbook and that the layout fits your planning period. A free template can save setup time, but it may include categories or charts you do not need.
Choose a monthly template if your main question is whether cash is likely to cover regular bills over the next several months. Choose a weekly layout if payroll, collections, or supplier payments create short-term pressure that monthly totals could conceal. If a template is hard to adapt or relies on unexplained formulas, a small workbook built from the rows above may be easier to maintain.
For display, select the money cells and use the number-format options in Excel’s Home tab to apply a suitable currency or accounting format. Formatting changes how values appear, not the underlying calculations. A forecast should also distinguish actuals from estimates, for example with a note in the row label or separate actual and forecast columns.
Excel compared with other options
Excel is useful when you want a file you can customize, keep locally, or share with people who already work in spreadsheets. Google Sheets is an alternative for browser-based collaboration, and accounting or cash-management software may connect forecast planning to transaction records. Those tools can reduce manual entry, but they may involve account setup, subscription costs, or different data-handling considerations.
For a simple forecast, there is no need to buy software just to add inflows, outflows, and a rolling balance. As the number of accounts, currencies, scenarios, or contributors grows, a basic workbook can become harder to control. At that point, compare options based on how they handle access, transaction imports, audit history, and the ability to explain where forecast figures came from.
Frequently Asked Questions
Is there a free cash flow forecast template for Excel?
Yes. Microsoft Create and other providers may have free downloadable templates. Check the current listing for file type, sign-in requirements, and usage terms, since offerings can change. You can also make a basic workbook with monthly columns and formulas for totals and balances.
How many months should a cash flow forecast cover?
There is no single period that suits every reader. A monthly forecast for the coming year can help with medium-term planning, while a shorter weekly forecast can make near-term payment timing clearer. Choose a horizon that matches the decisions you need to make and update it regularly.
What is the difference between cash flow and profit?
Profit compares income and expenses under the applicable accounting method; cash flow tracks money received and paid. A business may report a profitable sale but have no cash from it yet if the customer has not paid. The forecast is designed to show that timing difference.
Should I enter expenses as negative numbers?
In the layout described here, enter outflows as positive numbers in their own section and subtract the total outflows from total inflows. This makes the categories easier to read. If you choose a different layout, make sure its formulas consistently handle the signs.
Can I use the same forecast for a household and a business?
The basic logic is the same, but the categories and assumptions differ. A household forecast may track paydays, housing, utilities, and savings transfers; a business forecast may need customer collection timing, payroll, taxes, and supplier terms. Use labels that reflect the actual cash decisions being planned.
Does a forecast tell me whether I can afford a loan or tax payment?
It can show how an estimated payment would affect projected cash, but it does not establish whether a borrowing or tax decision is suitable. Treat example figures as illustrative, check actual payment terms with the lender, and consult a qualified professional for financial, tax, or legal questions.
Related
- Brady Excel Import: Bring Spreadsheet Data to Labels
- Bottom Border in Excel: How to Apply and Customize
- Excel Borders: How to Add, Change, and Remove Cell Lines
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets QUERY ORDER BY: Sort Query ResultsIn Google Sheets, use the order by clause inside a QUERY formula to sort the rows it returns.…
- Embed a Video in PowerPoint: Steps, Formats & FixesTo embed a video in PowerPoint for Microsoft 365 on Windows, open the slide, choose Insert > Video…
- Export an Excel Table as a Picture: Step-by-StepTo export an Excel table as a picture in Microsoft Excel for Microsoft 365 on Windows, select the…
- What Number Column Is U in Excel?Column U is column number 21 in Excel. The count starts with A as 1, so U is…
- Excel Consolidation Using Power Query: A Practical GuideTo consolidate Excel data with Power Query, go to Data > Get Data, connect to the workbook, folder,…
- Ungroup in Excel: How to Bring Back the Ungroup CommandTo bring up Ungroup in Excel for Microsoft 365 on Windows, select the grouped rows or columns, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.