Cash Flow Management for Small Business: The 13-Week Rolling Forecast
More businesses fail from cash flow problems than from a lack of profit. A company can be profitable on paper and still run out of cash if it collects slowly and pays quickly. The 13-week rolling cash flow forecast is the operational finance tool that solves this — it gives you a 90-day forward view of your cash position updated weekly.
READY TO TAKE ACTION?
Use the free LaunchAdvisor checklist to track every step in this guide.
The Quick Answer
Build a 13-week (90-day) rolling cash flow forecast. Update it every week by adding the new week 13 and dropping the completed week 1. The forecast shows your projected ending cash balance each week, which lets you see cash gaps before they happen and take action — collecting receivables faster, delaying payables, or drawing on a credit line — with enough time to matter.
Why 13 Weeks?
90 days is the right forecast horizon for operational cash management. It is short enough to forecast with reasonable accuracy (you know your receivable collection patterns and payable schedules), and long enough to see problems before they become crises. Annual forecasts are too long to be accurate. Monthly forecasts are too short to allow intervention.
The rolling structure means you always have a 90-day view, not one that gets shorter as the year progresses.
Building the Forecast: Cash In
Cash inflows fall into three categories: collections on accounts receivable (when do customers actually pay, not when do you invoice?), recurring revenue that hits on predictable dates, and one-time inflows (asset sales, loan proceeds, owner contributions).
For each week, forecast expected collections based on your actual collection patterns. If your customers pay 30 days after invoice, shift your invoice dates forward 30 days to get your collection dates. If you have a 20% late-payment rate, reflect that in your collection forecast.
Building the Forecast: Cash Out
Cash outflows fall into: payroll (predictable and non-negotiable), rent and fixed costs (predictable), vendor and supplier payments (when are they actually due, not when are they accrued?), loan payments, and variable expenses (credit card bills, software renewals).
Map every payment to the week it clears your bank account. The accrual date in your accounting software is not the same as the cash-out date — payroll accrued in one week clears the bank in another.
Reading the Forecast: What to Look For
The output is a weekly ending cash balance. Look for:
Negative weeks: Any week where cash goes below your minimum operating balance (typically 4-6 weeks of operating expenses) is a warning sign.
Trend direction: Is your ending balance trending up, flat, or down? A flat or declining trend with growing revenue usually signals a receivables problem — you are booking revenue but not collecting it.
Seasonal dips: Identify the predictable low points and have your credit line drawn before you need it.
Interventions: What to Do When You See a Gap
60+ days out: Accelerate collections (send invoices earlier, offer early-pay discounts, follow up on overdue accounts), delay discretionary spending, negotiate extended payment terms with suppliers.
30-60 days out: Draw on your existing credit line, negotiate a short-term payment plan with suppliers, defer non-critical hiring.
Under 30 days: Prioritize payroll, rent, and tax obligations above all else. Communicate proactively with suppliers before missing payment deadlines — most will work with you if you reach out first.
How to Get Started
Build the forecast in a spreadsheet. Week numbers across the top (Week 1 through Week 13). Rows: beginning cash, inflows by category, outflows by category, net cash flow, ending cash balance.
Populate week 1 with actual data. Use your bank statement to seed the beginning cash balance. Weeks 2-13 are forecasted based on your receivable aging report and payable schedule.
Update every Monday morning. It takes 15-20 minutes once the template is built. The discipline of weekly updates is where the value comes from.
RECOMMENDED TOOLS
QuickBooks Online
Cash flow reporting and AR aging built in
BlueVine
Business line of credit for cash flow gaps
Some links above are affiliate links. We may earn a commission if you sign up — at no extra cost to you.
FREQUENTLY ASKED QUESTIONS
What is a healthy cash reserve for a small business?
Most financial advisors recommend 3-6 months of operating expenses as a cash reserve. For businesses with predictable recurring revenue, 3 months is sufficient. For businesses with lumpy or seasonal revenue, 6 months provides a meaningful buffer.
How do I speed up accounts receivable collections?
Send invoices the day work is complete, not at month-end. Offer 2/10 net 30 terms (2% discount if paid within 10 days). Send payment reminders at 15 days past due, not 30. Accept ACH and credit card payments to remove friction. For chronic late payers, require deposits before starting work.
Should I use a cash flow forecast or a profit and loss statement to manage my business?
Both. The P&L tells you whether your business model is working. The cash flow forecast tells you whether you can pay your bills next month. Profitable businesses can and do run out of cash — especially during growth phases when you are investing ahead of revenue.