Spreadsheet Templates • Published on Nov 20, 2026 • By SheetVault Editorial Team • Free .XLSX

Free Small Business Cash Flow Projection Template for Excel & Google Sheets (Download)

=C2-D2

What Is a Cash Flow Projection?

A cash flow projection estimates the amount of cash entering and leaving your business over a future period. It lets you see if you’ll have enough cash to cover expenses, invest in growth, or need financing.

Benefits for Small Businesses

  • Identify cash shortages before they happen.
  • Plan for seasonal fluctuations.
  • Make informed decisions on hiring, inventory, and capital expenditures.
  • Improve communication with lenders and investors.

Step‑by‑Step Setup in Excel or Google Sheets

  1. Open the provided template and rename the sheet if desired.
  2. Enter your starting cash balance in the Opening Balance cell for January.
  3. Fill in expected Cash Inflows (sales, loans, etc.) and Cash Outflows (rent, payroll, supplies) for each month.
  4. The Net Flow column automatically calculates =C2-D2 (Inflows minus Outflows).
  5. The Closing Balance column uses =B2+E2 to add Net Flow to the Opening Balance, then carries forward as the next month’s Opening Balance.
  6. At the bottom, the TOTAL row sums all inflows, outflows, and net cash for the period.

Pro Tips

  • Use realistic assumptions for seasonal sales and one‑time expenses.
  • Update the model monthly with actual numbers to improve accuracy.
  • Link the Closing Balance to other financial models (budget, profit‑and‑loss) for a unified view.

Download Ready-to-Use Spreadsheet

Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.

Download Template (.xlsx)

Frequently Asked Questions

How often should I update the cash flow projection?

Update it monthly with actual figures and adjust future assumptions to keep the forecast accurate.

Can I use this template in Google Sheets?

Yes, the formulas are compatible with both Excel and Google Sheets; just open the .xlsx file in Google Sheets.

What if I have irregular cash inflows?

Add a separate row for one‑time items or use the IF function to model conditional inflows based on scenarios.