Download a Free 12-Month Cash Flow Excel Template

Choose a format:

• Download the Excel file
• Copy the Google Sheets template

Before editing, save an untouched copy. The recorded spreadsheet execution covers the Google Sheets baseline and the checks described below.

Independent execution evidence for the downloaded Excel file wasn’t supplied, so Excel users should complete the January control in Step 4.

Open the Cash Flow sheet. Columns B:M cover January through December.

Main statement area showing the synthetic monthly example and rolling cash position.

The main ranges are:

The calculation logic is straightforward:

• Monthly inflows equal customer receipts plus other cash income.
• Monthly outflows equal the 5 payment categories.
• Net cash flow equals inflows minus outflows.
• January closing cash equals starting cash plus January net cash flow.
• Each later closing balance equals the prior closing balance plus the current month’s net cash flow.

Enter opening cash only in B4. Don’t repeat it as income in later months.

Update the template in this order:

1. Enter the forecast year in Cash Flow!B2.
2. Enter beginning cash in Cash Flow!B4.
3. Replace Cash Flow!B7:M8 with monthly cash receipts.
4. Replace Cash Flow!B12:M16 with monthly payments.
5. Enter payment amounts as positive numbers; the workbook subtracts them when calculating net cash flow.
6. Format B4:M19 and B22:B26 as currency. Format B27 as a whole number.

Record cash in the month when you expect to receive or pay it, not when it’s recognized for accounting purposes. For example, a customer receipt belongs in the month you expect to collect it, which may differ from the invoice or revenue-recognition month.

If a category has no activity, enter 0. Blank, text, and malformed imported values weren’t covered by the supplied execution evidence. Test those inputs in a disposable copy before relying on how the workbook handles them.

Don’t overwrite these formula ranges:

Before replacing the illustrative data, confirm the January control. All values below are synthetic and use an unspecified but consistent currency.

Calculate the expected results independently:

• Total inflows: 12,000 + 500 = 12,500
• Total outflows: 4,500 + 3,500 + 1,500 + 400 + 900 = 10,800
• Net cash flow: 12,500 - 10,800 = 1,700
• Closing cash: 10,000 + 1,700 = 11,700

The workbook should show:

These values match the recorded baseline execution. For a rolling-balance check, February net cash flow is 2,180, so C19 should equal 11,700 + 2,180 = 13,880.

If your Excel file produces different results, confirm that calculation is enabled. Then compare the affected ranges with the untouched workbook.

The summary in Cash Flow!A21:B27 reports annual activity and the projected cash position.

Compact annual summary for assessing liquidity and potential cash shortfalls.

The illustrative baseline contains these monthly results:

The recorded baseline produces:

Two reconciliations confirm the annual result:

• 183,200 - 141,690 = 41,510 annual net cash flow.
• 10,000 starting cash + 41,510 annual net cash flow = 51,510 year-end cash.

Review B19:M19 alongside B26:B27. A negative closing balance indicates a projected shortfall under the assumptions entered.

If you find one, examine collection timing, permitted payment timing, discretionary spending, and credible funding options. Don’t rely only on the summary count.

For a longer forecast horizon, see Forecast Cash Runway in Excel or Google Sheets.

You can rename an existing label in column A without changing the row structure. For example, replace “Other cash income” with another receipt category relevant to your business.

Adding or deleting rows requires an independent formula review because the supplied evidence doesn’t establish automatic expansion. If you change the structure:

1. Work in a separate copy.
2. Check each affected monthly total.
3. Repeat the January reconciliation.
4. Confirm that annual net cash flow equals annual inflows minus annual outflows.
5. Confirm that year-end cash equals opening cash plus annual net cash flow.

Finally, verify that the schedule still covers exactly January through December for the year in B2.

Change one input, then confirm that its effect rolls forward correctly.

Starting from the untouched baseline, increase June customer receipts in G7 from 14,500 to 19,500. Recorded execution produced:

• G18: 8,700 June net cash flow
• G19: 30,360 June closing cash
• M19: 56,510 December closing cash
• B24: 46,510 annual net cash flow
• B25: 56,510 year-end cash

Because the receipt increased by 5,000 and no other input changed, June and every later closing balance should increase by 5,000. Annual outflows should remain 141,690.

In a separate recorded check, beginning cash and every January input were set to zero. January inflows, outflows, net cash flow, and closing cash all returned zero without formula errors. This result doesn’t establish how blanks or text inputs behave.

ModelMonkey can inspect spreadsheet context and help with formulas, analysis, organization, formatting, and spreadsheet changes in Google Sheets and Excel. When the workflow presents a preview, review the proposed changes before proceeding.

For this template, use this range-specific request:

Check Cash Flow!B9:M9, B17:M19, and B22:B27 against the input ranges. Recalculate the January control and flag negative values in B19:M19.

Compare the response with the January and annual reconciliations above. Spreadsheet assistance doesn’t guarantee that every formula, forecast assumption, or proposed change is correct.