Cash Flow Forecast Template: Track Monthly Inflows, Outflows, and Runway

Overview

A cash flow forecast is a forward-looking schedule of cash receipts and payments. Unlike an income statement, which records revenue and expenses according to accounting rules, a cash flow forecast focuses on the timing of money entering and leaving the bank account. That timing is critical when customers pay after invoices are issued, suppliers require deposits, payroll falls on a fixed date, or tax and financing payments arrive in uneven cycles.

A useful cash flow forecast template should be simple enough to update regularly and detailed enough to support decisions. A monthly model is a practical starting point for many small businesses and operating teams. Use columns for the current month and each future month, then organize rows into these categories:

• Opening cash balance
• Expected customer receipts and other inflows
• Payroll and contractor payments
• Operating expenses, including rent, software, supplies, and marketing
• Taxes, fees, and other statutory or regulatory payments
• Equipment purchases and other capital spending
• Loan proceeds, repayments, owner contributions, or distributions
• Net cash movement, closing balance, and estimated runway

Keep operating, investing, and financing movements separate. This makes it easier to identify whether a cash shortfall comes from normal operations, a planned purchase, or a financing event.

How to estimate

Begin with the cash balance shown by the bank or accounting system on the forecast start date. Do not use an unreconciled accounting balance if outstanding transfers, uncleared payments, or deposits could materially affect the result.

Next, estimate receipts by expected collection month rather than by invoice date. For each open invoice, record the customer, invoice amount, expected payment date, and confidence level. If payment timing is uncertain, place the amount in a conservative month or create separate probable and possible receipt rows. Include recurring sales, deposits, refunds received, grants, financing, and owner contributions only when they are reasonably expected.

Estimate outflows using the date cash is likely to leave the account. Separate committed payments from discretionary spending. Committed items may include payroll, rent, scheduled debt payments, supplier invoices, and known taxes. Discretionary items may include hiring, travel, marketing campaigns, or equipment purchases that can be delayed if liquidity tightens.

Use these core spreadsheet formulas:

• Net cash movement = total inflows - total outflows
• Closing cash balance = opening cash balance + net cash movement
• Next month opening balance = prior month closing balance
• Cash runway in months = available cash divided by average monthly net cash burn

Runway needs careful interpretation. If net cash movement is positive, the simple runway formula is not meaningful because the business is not currently burning cash. If cash use varies substantially by month, use an average based on a clearly defined period and show the underlying monthly values beside the estimate.

Inputs and assumptions

A reliable cash flow spreadsheet makes assumptions visible instead of hiding them in formulas. Add an assumptions tab or a clearly labeled block at the top of the model. Record the forecast start date, currency, reporting period, opening cash balance, collection timing, payment timing, payroll schedule, tax treatment, and financing terms used in the estimate.

Useful input fields include:

• Expected sales by month and the portion collected immediately
• Outstanding invoices grouped by expected collection date
• Supplier bills and their planned payment dates
• Gross payroll, contractor costs, benefits, and payroll-related deductions
• Recurring operating expenses and their billing frequency
• One-time purchases, deposits, refunds, and settlement payments
• Loan drawdowns, principal repayments, interest, and owner transactions
• Minimum cash buffer required for normal operations

Build at least three scenarios: base, downside, and upside. The base case should use the most defensible assumptions, not the most optimistic ones. The downside case might delay selected receipts, reduce sales, increase supplier costs, or bring forward a planned payment. The upside case can reflect stronger collections or sales, but should still use realistic operating capacity.

Protect formula cells and use consistent signs. One practical convention is to show inflows as positive numbers and outflows as negative numbers. Apply data validation where useful, label hard-coded inputs, and add notes for unusual assumptions. A clean cash flow projection in Excel or Google Sheets is easier to review when another person can distinguish inputs from calculations immediately.

Worked examples

Suppose a business starts April with an opening cash balance of 24,000 in its reporting currency. Its April forecast includes 18,000 in customer receipts and 3,000 in other inflows. Planned outflows are 11,000 for payroll, 5,500 for operating expenses, 2,000 for taxes, and 1,500 for financing payments.

The calculation is:

• Total inflows: 18,000 + 3,000 = 21,000
• Total outflows: 11,000 + 5,500 + 2,000 + 1,500 = 20,000
• Net cash movement: 21,000 - 20,000 = 1,000
• Closing cash balance: 24,000 + 1,000 = 25,000

If the downside scenario delays 6,000 of receipts into May, April inflows fall to 15,000. Net cash movement becomes negative 5,000 and the closing balance becomes 19,000. That comparison does not predict what will happen; it shows the effect of one explicit assumption and gives the team time to consider collection actions, spending delays, or financing options.

For a cash runway calculation, suppose the business has 30,000 of available cash and an average monthly net burn of 7,500 over the selected forecast period. The simple estimate is 30,000 divided by 7,500, or four months. If a large annual payment is due in the next month, the four-month figure may overstate practical runway. Review both the average and the month-by-month closing balance before making a decision.

When to recalculate

Update the forecast at least monthly, preferably as part of the month-end close. First enter actual receipts and payments, then compare them with the prior forecast. Add a variance column for each major category and record the reason for material differences, such as a delayed customer payment, an unplanned repair, or a changed hiring date.

Recalculate sooner when a major invoice is issued or collected, a customer changes payment terms, payroll changes, a tax or financing payment is scheduled, or a planned purchase is approved. Refresh the model when pricing inputs, supplier costs, staffing levels, payment terms, or interest assumptions change. Review tax categories and spreadsheet formulas annually, and whenever accounting practices or reporting requirements change.

Use the closing cash balance from one period as the next period's opening balance only after reconciling it to the bank and accounting records. Keep a dated copy of each forecast so you can see whether accuracy is improving. Finally, share a short decision summary with the relevant owners: expected low point, main sources of uncertainty, actions required, and the date of the next review. A cash flow spreadsheet becomes useful not through complexity, but through disciplined updates tied to operating decisions.