Yes—you can make a free cash flow template in Excel by setting up monthly columns for opening cash, receipts, payments, and closing cash, then adding a few formulas. You can also look for a cash flow workbook through Excel’s File > New template gallery, although available templates can change; the layout below works as a simple do-it-yourself alternative.
What a cash flow template shows
A cash flow template records when money is expected to enter or leave an account. It helps answer practical questions such as whether cash on hand is likely to cover next month’s payroll or whether a large customer payment is expected after a bill comes due. A forecast is an estimate based on expected dates and amounts; it is not a guarantee that the money will arrive as planned.
Cash flow is not the same as profit. A business can record a sale as revenue before the customer pays, while a cash forecast counts the money when payment is expected to be received. Similarly, buying equipment may use cash immediately even though its accounting cost is recognized over time. A cash flow spreadsheet is useful for planning liquidity, but it does not replace accounting records, a profit-and-loss statement, or a formal statement of cash flows.
The template below is a basic monthly forecast. It can be adapted for a household, sole trader, or small business, but the categories and level of detail should fit the user. For example, a household might track wages and rent, while a business may need separate rows for customer receipts, suppliers, payroll, taxes, and debt payments.
Build a simple monthly template
In a new workbook, use row 1 for headings. Put the category names in column A, the first month in column B, and the next months in columns C through M. Use column N for annual totals where summing makes sense. A practical starting layout is:
- Row 2: Opening cash
- Rows 3–4: Cash receipts, such as customer payments and other income
- Row 5: Total cash inflows
- Rows 6–11: Cash payments, such as suppliers, payroll, rent, taxes, debt payments, and other expenses
- Row 12: Total cash outflows
- Row 13: Net cash flow
- Row 14: Closing cash
- Row 15: Minimum cash target, if one applies
- Row 16: Amount above or below that target
Enter the starting bank balance in B2 and forecast amounts in the relevant receipt and payment rows. Use positive numbers for both incoming and outgoing amounts; the net cash formula subtracts total outflows from total inflows. This convention makes the entries easier to read and reduces the chance of accidentally subtracting an expense twice.
Add formulas and check the arithmetic
With month headings in B1:M1, total the receipt rows for each month. With total inflows in row 5 and receipt detail in rows 3–4, enter this in B5 and copy it across to M5:
=SUM(B3:B4)
With payment detail in rows 6–11 and the total outflow in row 12, enter this in B12 and copy it across:
=SUM(B6:B11)
With total inflows in B5 and total outflows in B12, enter this in B13 and copy it across. A positive result means forecast receipts exceed payments for that month; a negative result means payments exceed receipts:
=B5-B12
With opening cash in B2 and net cash flow in B13, calculate closing cash in B14. For the next month, carry the prior month’s closing cash forward as its opening cash. Enter the first formula in B14 and the next-month formula in C2, then copy each across as appropriate:
=B2+B13
=B14
For example, suppose opening cash is $10,000, receipts are $24,000, and payments total $27,500. Net cash flow is $24,000 minus $27,500, or negative $3,500; closing cash is $10,000 minus $3,500, or $6,500. If the minimum cash target is $8,000, the forecast is $1,500 below the target. The target is a planning reference, not a guarantee that cash will be available.
Use a sensible forecast time frame
A monthly view is easy to maintain and useful for seeing broad patterns, but it can hide timing problems. If a business pays suppliers on the first of the month and receives a major customer payment near the end, a month-end balance may look adequate even though cash gets tight in between. A weekly or daily forecast can make more sense when payment timing is uncertain or balances are small relative to regular bills.
Choose a horizon that supports a real decision. A household may plan upcoming bills for several months; a business may forecast a rolling period such as the next 13 weeks, updating it as actual transactions occur. There is no universal best period. More frequent detail takes more work, so use it when the extra visibility is valuable rather than adding complexity by default.
Make the workbook easier to read and maintain
Keep inputs and calculations visually distinct. For example, use one fill color for amounts entered by hand and another for formula cells, and add a short note explaining the color scheme. Format the cash cells as currency, keep month headings consistent, and avoid merging cells in the data area because merged cells can make copying formulas and sorting harder.
In Excel for Microsoft 365 on Windows, select the month headings and use Home > Number to choose an appropriate date or number format. To keep headings visible while scrolling, select the cell below and to the right of the rows and columns to freeze, then use View > Freeze Panes > Freeze Panes. On Mac, the Freeze Panes command is also on the View tab, though the ribbon appearance can differ. Excel for the web has its own ribbon layout, and some controls may be arranged differently.
Make it clear which figures are estimates and which are actual results. A notes column or a separate assumptions area can record expected payment dates, the source of an estimate, and any one-off events. Save a clean starting copy before replacing forecast amounts with actuals, or add separate actual columns if comparing plan to result is important.
Choose the right template for your needs
A template is useful only if it matches the question you are trying to answer. A household budget often organizes expected income and spending by category. A business cash forecast focuses on the timing of receipts and payments. A cash flow statement, by contrast, is generally prepared from accounting records and groups activity into operating, investing, and financing categories. These tools overlap, but they are not interchangeable.
- For personal planning: Use categories such as pay, benefits, housing, utilities, food, transport, and savings transfers. Decide whether you are tracking one account or total household cash.
- For a small business: Separate customer receipts from other inflows and distinguish recurring operating payments from occasional purchases or financing flows.
- For a project: Include the expected timing of deposits, milestone payments, and costs that occur before reimbursement.
- For reporting: Use the accounting system and reporting requirements that apply; do not assume a basic forecast workbook is a compliant financial statement.
If starting from Excel’s gallery, search for terms such as “cash flow” or “cash flow forecast” under File > New. Review the workbook before entering sensitive or important figures: inspect its formulas, categories, time periods, and any assumptions. A polished design does not prove that a template’s calculations fit your situation.
Free options, costs, and privacy
A basic template can be made with ordinary worksheet cells and formulas, so there is no need to buy a specialized spreadsheet add-in just to total receipts and payments. Excel’s template choices and access to Excel itself can depend on the account, license, and platform. Excel for the web may be an option for people with a Microsoft account, but check current access and feature details rather than assuming every desktop feature or template is available without charge.
When downloading a workbook from an unfamiliar website, consider what information it requests and whether the file contains macros. A simple cash flow workbook should not need your online banking password. Do not enable macros simply because a downloaded template prompts you to do so. Keep private financial data in a location you trust, restrict sharing permissions, and avoid uploading sensitive records to services without understanding their terms and security arrangements.
Common errors and how to avoid them
The most frequent forecasting error is recording a transaction in the wrong month. Use the expected date cash will clear, not automatically the date an invoice is issued. Another common mistake is counting the same receipt twice—for example, once when a customer is invoiced and again when the payment arrives. Decide on a consistent cash-basis rule for the forecast and apply it throughout.
- Mixing cash and profit: A profitable month can still have a cash shortfall if receipts arrive late or a large bill is due.
- Leaving out irregular payments: Include annual insurance, tax installments, equipment, or other less frequent costs in the month they are expected.
- Forgetting the opening balance: The first month’s closing cash depends on the starting balance, not just that month’s net movement.
- Overwriting formulas: Use a distinct format for formula cells and check a copied formula before filling the entire forecast.
- Treating estimates as certain: Revisit uncertain amounts and dates as new information arrives; a forecast should be updated, not treated as a promise.
It can also help to compare a base case with a cautious case. For instance, a business might test what happens if a customer pays one month later than expected or if a planned cost is higher. Keep such scenarios separate from the main forecast so that a hypothetical change is not mistaken for the current expectation.
Frequently Asked Questions
Where can I download a free cash flow template for Excel?
Check Excel’s File > New template gallery and search for “cash flow.” Availability can vary. You can also build the basic monthly layout above in a blank workbook without downloading a file.
Is a cash flow template the same as a budget?
Not exactly. A budget typically plans income and spending by category, while a cash flow forecast emphasizes when money is expected to be received or paid. A budget can inform a forecast, but payment timing may differ from the month an expense is budgeted.
Can I use this template for personal finances?
Yes. Replace the example business categories with household income and expenses, and decide whether to forecast a single bank account or all household cash. Avoid counting transfers between your own accounts as new income if you are consolidating them into one household view.
Should cash outflows be entered as negative numbers?
In the layout described here, enter both inflows and outflows as positive amounts; the net cash formula subtracts the outflow total. You can design a different sign convention, but the formulas and labels must match it consistently.
How often should I update a cash flow forecast?
Update it whenever material assumptions change and compare forecasts with actual receipts and payments on a regular schedule. A weekly review may suit a business with tight cash timing; a stable household forecast may need less frequent revisions.
Related
- Calculate Percentile in Excel for Each Value in a List
- Loan Amortization in Excel: Calculate Payments and Schedule
- Business Loan Amortization Calculator in Excel: Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Open a CSV File Too Large for Excel SafelyTo open a CSV that is too large for an Excel worksheet, import it with Power Query instead…
- Excel Calendar Template with Notes? How to Make OneYes, you can create an Excel calendar template with a notes section by combining a standard monthly grid…
- Excel Power Query Append Queries: Combine Tables EasilyIn Excel for Microsoft 365 on Windows, Power Query append queries combine tables by stacking their rows into…
- Disable Strikethrough in Excel: Quick Steps and FixesTo disable strikethrough in Excel for Microsoft 365 on Windows, select the affected cell or range and press…
- How to Center a Table on a Page in Excel for PrintingTo center a table on a printed page in Excel, open Page Layout, launch the Page Setup dialog,…
- Excel Dropdown Based on a List: Setup and TroubleshootingYes. In Excel for Microsoft 365 on Windows, select the cell or cells, choose Data > Data Validation,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.