Cash Flow Budget Template in Excel: Build One That Works

How-to basics · Updated November 21, 2026

Yes—a cash flow budget template in Excel can be a simple monthly worksheet with cash receipts, payments, and opening and ending balances. Put months in columns, list cash categories in rows, and use formulas such as =B9-B18 to calculate each month’s net cash flow; the layout and worked example below show how to build it in Microsoft Excel for Microsoft 365 on Windows.

What a cash flow budget shows

A cash flow budget estimates when money will enter and leave an account. It is a timing forecast, not simply a report of income minus expenses. A sale may count as revenue when made, for example, but it does not help pay this week’s bills if the customer will not pay for 30 days. The budget focuses on expected cash receipts and cash payments during a chosen period.

This makes it useful for anticipating a shortfall, deciding when a planned purchase is affordable, and identifying months when cash is likely to accumulate. It does not guarantee that the forecast will happen: customer payment dates, unexpected repairs, seasonal sales, and other changes can shift the result. Treat it as a planning document to update as assumptions change, not as a promise of future cash.

A cash flow budget also differs from a profit and loss statement. A profit and loss statement records income and expenses according to accounting rules; a cash budget tracks expected cash movement. Loan principal repayments, for instance, affect cash even though they are not generally recorded as an operating expense in the same way as interest. For a useful forecast, include the actual payment leaving the bank account.

Set up the Excel template

Create a blank worksheet in Excel and use column A for labels and columns B:M for January through December. Put the year in a heading above the grid, and use one currency throughout. A practical row structure is:

  • Row 2: opening cash balance.
  • Rows 4–8: cash receipts, such as customer payments, cash sales, other income, refunds, and owner contributions.
  • Row 9: total cash receipts.
  • Rows 11–17: cash payments, such as payroll, suppliers, rent, utilities, loan payments, taxes, and other costs.
  • Row 18: total cash payments.
  • Row 20: net cash flow.
  • Row 21: ending cash balance.
  • Row 22: minimum cash target, if you want to compare the forecast with a reserve goal.
  • Row 23: amount above or below that target.

Enter descriptive labels in column A, such as Customer payments in A4 and Rent in A13. Enter the starting bank cash in B2; it is an input, not a formula. For the first month, make that balance match the cash available at the beginning of January, using a consistent definition of which accounts are included. Enter forecast amounts in the relevant month columns. Use zero when a category has no expected activity, or leave it blank if your team understands that blank means no planned amount.

Keep receipts and payments separate rather than entering costs as negative receipts. This makes totals easier to inspect and reduces sign errors. If a category is not relevant, rename it or leave it unused. Avoid combining unrelated items into one row if you will need to explain a change later; a distinct equipment purchase row, for example, is easier to review than a large miscellaneous amount.

Add formulas and check the example

Assume January has an opening balance of $10,000. In B4:B8, enter customer payments of $18,000, cash sales of $1,200, other income of $600, refunds of $0, and owner contributions of $200. In B11:B17, enter payroll of $7,000, suppliers of $5,000, rent of $2,200, utilities of $500, loan payments of $800, taxes of $1,000, and other costs of $300.

With January receipts in B4:B8, enter this in B9 to total them: =SUM(B4:B8). It returns $20,000 because 18,000 + 1,200 + 600 + 0 + 200 equals 20,000.

With January payments in B11:B17, enter this in B18: =SUM(B11:B17). It returns $16,800: 7,000 + 5,000 + 2,200 + 500 + 800 + 1,000 + 300.

With total receipts in B9 and total payments in B18, enter this in B20: =B9-B18. January net cash flow is $3,200, since $20,000 minus $16,800 equals $3,200.

With opening cash in B2 and net cash flow in B20, enter this in B21: =B2+B20. The January ending balance is $13,200. With that ending balance in B21 and a minimum cash target of $8,000 entered in B22, enter this in B23: =B21-B22. The result is $5,200 above the target.

For February, put the January ending balance into C2 with =B21. Copy this formula to the right across the remaining months so each month starts with the previous month’s ending cash. Copy the total, net-flow, and ending-balance formulas from column B across the year as well. Excel adjusts the relative references as you copy, so the February total in C9 will sum C4:C8. Check the first month manually before filling formulas across the worksheet.

Make the forecast useful

Use expected payment and receipt dates, not just invoice dates or the month a sale is made. If a customer usually pays one month after purchase, place the receipt in the month payment is expected. Similarly, include a bill in the month the cash is expected to leave the account. When the date is uncertain, use a reasonable estimate and make the uncertainty visible in a note rather than treating the estimate as certain.

Separate recurring amounts from one-off events. Regular rent may be predictable, while an annual insurance payment, equipment purchase, tax payment, or seasonal sales swing can change a month substantially. A short notes column or a separate assumptions area can record the source of a number, such as a signed order, last year’s pattern, or a rough estimate. Update those inputs when better information arrives.

For a business, list cash receipts by realistic source and consider when customers actually pay. For a household, categories might include take-home pay, benefits, housing, groceries, transport, debt payments, and savings transfers. The structure is similar, but use categories that reflect your own cash decisions. Do not count a transfer between two accounts you include in the same budget as new income; doing so would inflate both receipts and available cash.

Format and review the worksheet

Format the entry cells as currency and use the same decimal setting throughout. In Excel for Microsoft 365 on Windows, select the cells and use Home > Number to choose an appropriate number format. Make headings and calculated totals visually distinct with bold text or borders. Freeze the label column or top heading if the sheet becomes difficult to follow while scrolling; use View > Freeze Panes to choose the relevant option.

For a quick visual warning, select the ending-balance cells and use Home > Conditional Formatting > Highlight Cells Rules to flag amounts below zero. If you also want to flag balances below the reserve target, compare row 21 with row 22; the cushion in row 23 makes that comparison easy. Conditional formatting highlights a result but does not explain why it is low, so review the underlying receipt dates and payment assumptions.

Review the budget at a regular interval and compare forecast figures with actual cash movement. You can add actuals in separate rows or maintain a separate actuals sheet; keep forecast and actual figures clearly labeled. When a month differs, record the cause, such as a late customer payment or an unplanned repair. That record helps improve future estimates instead of merely changing a number to make the forecast look better.

Common mistakes to avoid

  • Starting each month from the same opening amount: Later months should carry forward the prior month’s ending cash. Otherwise the budget fails to show the effect of earlier surpluses or shortfalls.
  • Mixing income earned with cash received: Put money in the month it is expected to arrive, not automatically the month a sale or invoice is recorded.
  • Forgetting irregular payments: Annual fees, taxes, insurance, repairs, and seasonal expenses can make a monthly average misleading. Put them in the period they are expected to be paid.
  • Double-counting transfers: A transfer between included accounts is not new cash for the combined budget. Decide which accounts the sheet covers and apply that boundary consistently.
  • Overwriting formulas with typed totals: Keep input cells separate from calculation cells. If a total looks wrong, check its formula and the amounts included rather than replacing it with a hard-coded number.

A negative ending balance is a forecast warning, not proof that the account will actually be overdrawn. It may mean a receipt date is uncertain, a planned payment needs attention, or the assumptions require revision. Verify balances and obligations against current bank information and real agreements.

Choose the right level of detail

A 12-month monthly sheet is a good starting point when the main question is whether cash is adequate over the year. A weekly forecast can be more useful when bills and receipts arrive frequently or a tight period is approaching. For a weekly version, use weeks as columns and carry each week’s ending balance into the next week. More columns and detailed categories are not automatically better: choose a level of detail you can keep current.

A downloaded workbook can save setup time, but inspect its formulas, categories, and assumptions before relying on it. A template may be designed for a household, a retailer, or a project, and those uses do not necessarily share the same categories. A custom worksheet gives you control over the layout, while accounting or budgeting software may be more convenient when you need bank feeds, shared access, or reports. Excel is most useful when someone will maintain the inputs and review the results.

Frequently Asked Questions

Is a cash flow budget template in Excel free?
Excel includes blank worksheets you can use to build one, and Microsoft and other providers may offer downloadable templates. Availability and features can vary. Check that a downloaded workbook has the categories and formulas you need, and review formulas before entering sensitive or important figures.

What is the difference between a cash flow budget and a cash flow statement?
A cash flow budget is a forward-looking estimate of receipts and payments. A cash flow statement reports cash movement over a past period using accounting records. The budget helps plan; the statement helps explain what happened.

Should I include loan payments in the template?
Include the cash payment expected to leave the account. If you need to distinguish principal from interest for accounting or reporting, show them separately and use the lender’s current payment schedule. Confirm actual terms with the lender or a qualified professional; this worksheet is not financial, tax, or legal advice.

How often should I update a cash flow budget?
Update it whenever a material assumption changes, such as a delayed customer payment, a new bill, or a revised project date. Many users also review it on a regular weekly or monthly schedule. The right frequency depends on how quickly your cash position changes.

Can I use the same template for a household and a business?
The basic structure works for either, but the categories and timing assumptions should match the situation. A business may need customer payment terms, payroll, supplier bills, and tax dates; a household may track paydays, housing, food, and personal debt. Keep the workbook’s purpose and account boundaries clear.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.