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
- Open the provided template and rename the sheet if desired.
- Enter your starting cash balance in the Opening Balance cell for January.
- Fill in expected Cash Inflows (sales, loans, etc.) and Cash Outflows (rent, payroll, supplies) for each month.
- The Net Flow column automatically calculates
=C2-D2(Inflows minus Outflows). - The Closing Balance column uses
=B2+E2to add Net Flow to the Opening Balance, then carries forward as the next monthās Opening Balance. - 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.