Cash Flow Forecast Calculator
Project your cash position week by week for the next 13 weeks. Spot shortfalls early, plan ahead, and keep your business solvent.
Starting Cash Balance
Monthly Recurring Income
Distributed evenly across 4.33 weeks per month.
Monthly Recurring Expenses
One-Time Income Items
One-Time Expense Items
Lowest Balance
--
--
Average Weekly Cash Flow
--
End Balance (Week 13)
--
| Week | Cash In | Cash Out | Net | Running Balance |
|---|
Get your results + bookkeeping tips
Join the waitlist for AI-powered bookkeeping. We'll keep you updated.
How to Use a 13-Week Cash Flow Forecast
A 13-week cash flow forecast is the single most important financial tool for small businesses operating on tight margins. Unlike a profit-and-loss statement that looks backward, a cash flow forecast looks forward, telling you exactly when money will enter and leave your bank account over the next quarter.
The 13-week window is the industry standard because it covers a full fiscal quarter, giving you enough visibility to act on problems before they become crises. Banks and investors often request this exact report when evaluating creditworthiness or considering a line of credit.
Why Weekly Granularity Matters
Monthly forecasts hide the danger zones. If your rent, payroll, and a quarterly insurance premium all land in the same week, a monthly view shows adequate cash while reality shows an overdraft. Weekly breakdowns expose these collision points so you can shift payment timing, draw on a credit line, or accelerate an invoice.
Building an Accurate Forecast
Start with your actual bank balance today, not your accounting balance. Add recurring income distributed across weeks, then layer in recurring expenses. Finally, plot any known one-time items such as equipment purchases, tax payments, or client project payments in the specific weeks they will clear. Update weekly by replacing projections with actuals and extending the window one week forward.
What to Do When Cash Runs Tight
The forecast is only valuable if you act on it. When you see a low or negative balance approaching, you have several levers: invoice clients earlier, offer early-payment discounts, renegotiate vendor payment terms from net-30 to net-45, defer non-critical expenses, or arrange short-term financing. The earlier you spot the shortfall, the more options you have and the cheaper those options tend to be.
Rolling Forecasts vs. Static Forecasts
A static forecast is built once and becomes stale. A rolling forecast is updated weekly so the projection always looks 13 weeks ahead from today. Rolling forecasts are dramatically more accurate because they incorporate real data as it arrives, and they train you to think about cash flow as a continuous process rather than a one-time exercise.
Frequently Asked Questions
What is a 13-week cash flow forecast?
A 13-week cash flow forecast projects your business cash position week by week for the next quarter. It is the standard timeframe used by CFOs and lenders because it covers a full fiscal quarter while remaining granular enough to spot short-term liquidity risks before they become emergencies.
How often should I update my cash flow forecast?
Best practice is to update your forecast weekly using a rolling 13-week window. Each week, remove the past week, add actuals, and extend the projection by one week. This keeps the forecast accurate and gives you the earliest possible warning of cash shortfalls.
What is the difference between profit and cash flow?
Profit is an accounting measure that includes non-cash items like depreciation and accrued revenue. Cash flow tracks actual money entering and leaving your bank account. A business can be profitable on paper but still run out of cash if receivables are slow or large expenses hit at once.
What should I do if the forecast shows a negative balance?
A negative balance week is a warning, not a verdict. You can act early by accelerating receivables, negotiating longer payment terms with suppliers, arranging a line of credit, deferring non-essential spending, or timing one-time expenses around higher-income weeks.
Can I use this calculator for personal finances?
Yes. Replace business categories with personal ones — payroll becomes your salary, subscriptions become streaming services, and so on. The 13-week rolling method works just as well for household budgeting and spotting months where you might overdraft.
Related Calculators
Ready for AI-powered bookkeeping?
BookkeepingFlow automates your books so you can focus on your business.
No credit card required. We'll notify you when we launch.