To get a Microsoft Excel cash flow template, open Excel for Microsoft 365 on Windows, choose File > New, and search for cash flow; available templates can vary. If none fits, a simple monthly workbook can track opening cash, receipts, payments, and closing cash, with formulas that calculate each month’s balance.
What a cash flow template shows
A cash flow template organizes when money is expected to enter and leave an account. A basic version summarizes each month’s opening balance, cash inflows, cash outflows, net cash flow, and ending balance. More detailed templates may also group receipts and payments by category, compare forecast figures with actual transactions, or track several bank accounts.
Cash flow is not the same as profit. Profit is generally based on revenue earned and expenses incurred under the applicable accounting method; cash flow focuses on money received and paid. For example, a business might record a sale in March but not receive the customer’s payment until April. A cash forecast should show the expected receipt in April, when the cash is due to arrive, rather than treating the March sale as money already in the bank.
A cash flow workbook can support planning, but it does not determine whether a business is profitable, financially healthy, or meeting its reporting obligations. Its usefulness depends on complete records, sensible assumptions, and regular updates.
Find or download a template in Excel
In Excel for Microsoft 365 on Windows, select File > New and use the template search box to look for “cash flow.” Preview the results before opening one: some results may be cash budgets, personal spending plans, or broader business-planning workbooks rather than a formal cash flow statement. The names and availability of templates can change, and not every installation will show the same choices.
You can also look for spreadsheet templates from Microsoft’s template offerings or start with a blank workbook. A template is a starting point, not a guarantee that its categories, accounting assumptions, or formulas suit your situation. Before relying on a downloaded file, check its date ranges, formulas, instructions, and any assumptions about taxes or payment timing.
For a quick check, select a formula cell and inspect the formula bar. Confirm that totals cover the intended rows and that monthly columns do not omit a period. If the workbook contains macros, it may use an Excel Macro-Enabled Workbook (.xlsm) file; do not enable macros from an unfamiliar source just to view a cash flow forecast.
Choose a layout that fits the job
Decide first whether the workbook is for personal planning, a small-business forecast, or a historical report. Those uses overlap, but they need different levels of detail. A household may need pay dates, bills, savings, and a minimum balance. A business forecast may need customer receipts, payroll, rent, inventory, taxes, loan payments, and one-off purchases. A historical cash flow statement has different reporting requirements from a simple planning sheet.
- Monthly summary: A good choice for a first forecast or a longer-term view. It is compact, but can hide a cash shortage that lasts only a few days.
- Weekly or daily forecast: More useful when payment timing is tight or cash changes quickly. It takes more effort to maintain and depends on more detailed due-date information.
- Summary plus transaction log: A practical middle ground. Record individual expected or actual transactions on one sheet and summarize them by month on another.
Use consistent categories and make clear whether each entry is forecast, actual, or both. If you enter both forecast and actual values, separate them into different columns or use an explicit status field; otherwise, it is easy to count a receipt twice.
Build a simple monthly workbook
For a basic forecast, create two worksheets named Summary and Transactions. On Summary, put actual first-of-month dates in cells B2:M2. Use rows 3–7 for Beginning cash, Cash inflows, Cash outflows, Net cash flow, and Ending cash. On Transactions, use columns A–E for Date, Description, Category, Type, and Amount. Enter amounts as positive numbers and use exactly “Inflow” or “Outflow” in the Type column.
Put the opening cash balance for the first month in Summary!B3. For each transaction, enter the expected or actual date, a useful description, a category, the Type, and a positive amount. For example, a customer payment is an Inflow; rent is an Outflow. Use real Excel dates rather than text that only looks like a date, so date-based summaries can include transactions reliably.
Keep forecast assumptions visible. If a customer normally pays 30 days after an invoice, enter the anticipated receipt date rather than the invoice date. If a bill is irregular, use its expected due date and label the estimate. This makes it easier to see which figures are confirmed and which depend on an assumption.
Use formulas to summarize cash by month
With month-start dates in Summary!B2:M2 and transaction dates in Transactions!A2:A200, types in D2:D200, and positive amounts in E2:E200, enter this in Summary!B4 to total that month’s inflows. Copy it across the monthly columns:
=SUMIFS(Transactions!$E$2:$E$200,Transactions!$D$2:$D$200,"Inflow",Transactions!$A$2:$A$200,">="&B$2,Transactions!$A$2:$A$200,"<"&EDATE(B$2,1))
The HTML-escaped comparison operators above represent the Excel formula’s ordinary greater-than-or-equal and less-than symbols. Enter the formula in Excel with those symbols, not the HTML entity text. The criteria include dates on or after the month’s first day and exclude the first day of the next month, which also handles transactions with times attached.
With the same layout and positive amounts in Transactions!E2:E200, put this formula in Summary!B5 and copy across to total outflows for each month:
=SUMIFS(Transactions!$E$2:$E$200,Transactions!$D$2:$D$200,"Outflow",Transactions!$A$2:$A$200,">="&B$2,Transactions!$A$2:$A$200,"<"&EDATE(B$2,1))
Again, the formula as typed in Excel uses the comparison symbols shown by the escaped text in this HTML. In the layout above, if January transactions total $8,000 of inflows and $6,200 of outflows, Summary!B4 returns 8,000 and Summary!B5 returns 6,200.
With inflows in Summary!B4 and outflows in B5, enter this in B6 to calculate January net cash flow:
=B4-B5
For the example, the result is $1,800 ($8,000 minus $6,200). With opening cash in B3 and net cash flow in B6, enter this in B7 to calculate January ending cash:
=B3+B6
If B3 is $12,000, B7 returns $13,800. With the previous month’s ending cash in B7 and the next month’s beginning cash in C3, enter this formula in C3 and copy it across as needed:
=B7
That link carries the balance forward. Do not type a fresh opening balance into every month unless you have a deliberate reason; linking it makes breaks in the forecast easier to spot.
Make the sheet easier to read and maintain
Format the month headings as dates, and format cash values consistently as currency. In Excel for Windows, select the relevant cells and use the number-format controls on the Home tab. Keep input cells visually distinct from formula cells, and add a short note explaining whether amounts are forecast or actual.
For the transaction log, select its headers and data and use Insert > Table, or press Ctrl+T on Windows and confirm that the table has headers. A table makes records easier to filter and can extend its formatting when you add rows. If you use the formula ranges above, however, remember that rows beyond 200 will not be included until you expand the ranges or adjust the workbook design.
For a wide monthly sheet, select the cell below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Conditional formatting can help flag negative ending balances: select the ending-cash cells and choose Home > Conditional Formatting > Highlight Cells Rules. Review any rule thresholds before treating a color as a warning; formatting does not fix a formula or confirm that an estimate is correct.
On Excel for Mac, the same basic worksheets and formulas are available, though ribbon layout and shortcuts can differ. The Windows Ctrl+T shortcut for creating a table is generally Command+T on Mac. Excel for the web also supports many common workbook tasks, but some commands and options may appear in different places or be more limited than in the desktop app.
Common errors and how to check them
- Mixing positive and negative conventions: If outflows are entered as negative amounts but the summary subtracts them, the result will be wrong. Choose one convention and use it throughout. The example here records both types as positive and subtracts outflows.
- Using the wrong date: A sale date, invoice date, and expected payment date may be different. A cash forecast needs the expected cash date. Check that dates are valid Excel dates and fall within the intended month.
- Omitting future rows: A fixed range ending at row 200 will ignore records below row 200. Check the formula range after adding data, or use an Excel table-based design that expands with new entries.
- Counting transfers as income or spending: Moving money between two accounts you track together is usually not an external inflow or outflow for the combined total. Decide whether the workbook tracks one account or a group of accounts, and treat transfers consistently.
- Confusing cash movement with profit: Loan principal payments, equipment purchases, unpaid invoices, and depreciation can affect cash and profit differently. A simple forecast may track cash paid without providing the classifications needed for formal accounting reports.
Check the workbook with a small manual test: enter one known inflow and one known outflow in a single month, verify their summary totals, and calculate the ending balance independently. Also compare the opening balance with the relevant bank or cash record when tracking actuals. A template is only as dependable as its inputs and checks.
Template, custom workbook, or accounting software?
An existing Excel template is convenient when its time periods and categories are close to what you need. A custom workbook is more flexible and can avoid irrelevant sections, but you are responsible for building and checking its formulas. Accounting or cash-management software may reduce manual entry through features such as transaction imports, but functionality, data access, and cost depend on the product and plan.
Excel itself is not a separate cash-flow service: whether you can use the desktop app depends on your Microsoft 365 or Office license and setup. Template files may be available without an extra template fee, but that does not mean Excel or any connected service is free. Compare the effort of maintaining a spreadsheet with the features and costs of alternatives before choosing one.
For sensitive financial information, store the workbook in a location with appropriate access controls, and avoid sharing account numbers or personal identifiers unnecessarily. Download files from sources you trust, inspect formulas before relying on them, and be cautious about enabling macros. Do not treat a spreadsheet forecast as tax, legal, accounting, lending, or investment advice.
Frequently Asked Questions
Does Excel have a built-in cash flow template?
Excel for Microsoft 365 on Windows has a template gallery under File > New, where you can search for cash flow. What appears can vary. If the results do not match your needs, you can adapt a suitable workbook or make a basic one with monthly inflows, outflows, and balances.
How do I make a cash flow spreadsheet in Excel?
Create a monthly summary and, if useful, a separate transaction log. Record the expected date, type, and positive amount for each cash movement. Sum inflows and outflows by month, subtract outflows from inflows, then add net cash flow to opening cash to find the ending balance.
Is a cash flow statement the same as a cash flow forecast?
No. A forecast estimates future cash receipts and payments using assumptions. A statement reports cash flows for a past period under applicable reporting rules. A basic Excel planning template is not automatically a formal financial statement.
Can a cash flow template show a negative balance?
Yes. If projected payments exceed available cash, the ending balance can fall below zero. That is a useful signal to review timing and assumptions, but it is not by itself a complete assessment of financing options or financial condition.
Can I use the same template for personal and business cash flow?
You can adapt the structure, but categories and reporting needs differ. Personal planning might track pay and household bills; a business forecast may need customer payment timing, payroll, taxes, inventory, and financing. Keep the purpose clear and avoid treating a simple planning sheet as formal accounting.
Related
- Key Schedule Template Excel: Build One That Works
- Keep Cell Formatting in Excel When Concatenating
- Job Task List Template in Excel: How to Build and Use It
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 Create Email Rules in Outlook 365To create an email rule in Outlook 365, open Settings, go to Mail > Rules, choose Add new…
- Google Sheets 2D Conditional Formatting: A Practical GuideGoogle Sheets can apply conditional formatting across a two-dimensional range: select the cells, open Format > Conditional formatting,…
- Excel Shortcut to Insert Cells Down: Keyboard StepsIn Excel for Microsoft 365 on Windows, select the cell or range where you want space, then press…
- Excel Table: How to Switch Rows and Columns EasilyTo switch an Excel table’s rows and columns, transpose its cell range: in Excel for Microsoft 365 on…
- How to Add in Excel Across Different SheetsTo add values from the same cell on several worksheets, use =SUM(Jan!B2,Feb!B2,Mar!B2). This example assumes the values are…
- Command for Page Break in Word: Shortcut and StepsIn Microsoft Word for Windows, press Ctrl+Enter to insert a page break at the cursor. You can also…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.