Cash Flow Forecast Template
A practical cash flow forecast template with weekly and monthly projections, categorized inflows and outflows, opening/closing balances, and runway calculations — essential for staying cash-positive.
CASH FLOW FORECAST — [Period]
Opening Balance
$[current cash on hand]
Cash Inflows
Sales Revenue: $[amount]
Accounts Receivable: $[amount]
Other Income: $[amount]
Total Inflows: $[total]
Cash Outflows
Payroll: $[amount]
Rent & Utilities: $[amount]
Vendors & Suppliers: $[amount]
Marketing: $[amount]
Loan Payments: $[amount]
Total Outflows: $[total]
Summary
Net Cash Flow: $[inflows - outflows]
Closing Balance: $[opening + net]
Runway: [weeks/months at current burn]
How to Use This Template
Start with your opening balance
Enter your actual cash on hand right now. This is not revenue or assets — it is money available in your bank accounts today.
List all expected inflows
Include confirmed sales, expected receivable collections (use realistic timelines, not invoice dates), and any other income sources.
List all expected outflows
Include every expense: payroll, rent, vendors, subscriptions, taxes, loan payments. Do not forget quarterly or annual expenses.
Update weekly
Replace projections with actuals each week. This rolling approach keeps the forecast accurate and helps you spot trends early.
Customize in Dewx
Inside Dewx, tell Dew: "Show me my cash flow forecast for the next 13 weeks." Dew pulls your invoices, recurring expenses, and payment history to generate an accurate forecast. Get alerts when cash dips below your safety threshold.
Related Templates
Frequently Asked Questions
What is the difference between a cash flow forecast and a budget?
A budget plans how you want to spend money. A cash flow forecast predicts when money will actually move in and out. You can be profitable on paper but cash-poor in reality if clients pay late or expenses hit before revenue. Cash flow forecasting tracks timing, not just amounts.
How far ahead should I forecast cash flow?
Use a 13-week (rolling quarterly) forecast for operational decisions — it is detailed enough to catch problems early. Add a 12-month forecast for strategic planning and investor reporting. Update weekly for the short-term view and monthly for the long-term view.
What are the most common cash flow mistakes?
The top mistakes are: counting revenue when invoiced instead of when collected, ignoring seasonal patterns, underestimating tax payments, not accounting for late-paying clients (average B2B payment is 30-45 days late), and failing to build a cash reserve for emergencies.
How does Dewx help with cash flow forecasting?
Inside Dewx, the OPS Hub tracks all invoices, payments, and expenses in real time. Dew auto-generates cash flow forecasts based on your actual data, flags upcoming shortfalls, and alerts you when runway drops below thresholds. Tell Dew: "Show me my cash position for the next 13 weeks."
Cash Flow, Under Control
Simple, Transparent Pricing
Starting at $29/mo for solopreneurs. $79/mo for teams. All features included.
View pricingNever Run Out of Cash
Dew forecasts your cash flow from real data and alerts you before shortfalls happen — so you can act early, not scramble late.
Try Dewx FreeStop Flying Blind on Cash
Dewx forecasts your cash flow in real time, alerts you to shortfalls, and models scenarios so you always know where you stand financially.