How to Build a 13-Week Cash Flow Forecast That Actually Works for Your Business
- Aureus Advisory Partners
- Nov 13, 2025
- 5 min read
If you have ever looked at your business bank account and wondered, “Where did all the money go?” . . . you are not alone.
Most business owners focus on profit, but profit does not always equal cash. Cash is what keeps your team paid, your vendors happy, and your growth plan alive. That is where a 13-week cash flow forecast becomes your most important financial tool.
In this guide, we will break down what it is, why it matters, and how to build one that actually works in the real world — not just in a spreadsheet.
1. What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling, week-by-week projection of your business’s cash position for the next quarter.
Unlike annual budgets, which are often static, this forecast helps you see short-term liquidity, plan spending, and make smarter decisions about timing payments, collections, and investments.
It answers three critical questions:
How much cash do we have right now?
How much cash is coming in?
How much cash is going out in the next 13 weeks?
💡 Aureus Tip: Think of it as a financial GPS. It does not just show you where you are, it tells you what is coming up so you can plan the right turns ahead.
2. Why 13 Weeks?
Thirteen weeks (roughly one quarter) strikes the perfect balance between visibility and control.
It is long enough to identify trends.
It is short enough to adjust quickly when things change.
It gives you a rolling 90-day window to make operational decisions without getting lost in annual projections.
For businesses with tight cash cycles, like construction, fitness studios, and professional services, this level of insight can be the difference between running lean and running scared.
3. What You Need Before You Start
Before you build your forecast, gather the following:
Current bank balances for all accounts.
Accounts receivable (what is owed to you).
Accounts payable (what you owe).
Recurring expenses (rent, payroll, subscriptions, debt payments).
Sales or revenue pipeline projections.
💡 Aureus Tip: You do not need to overcomplicate it. Start simple and add detail as you go.
4. The Structure of a 13-Week Cash Flow Forecast
A strong forecast includes three main sections:
a. Beginning Cash Balance
Start each week with your expected beginning balance. This number comes directly from your bank account.
b. Cash Inflows
List all expected sources of cash for the week, such as:
Customer payments (AR collections)
New sales or deposits
Loan proceeds or funding
Tax refunds or reimbursements
c. Cash Outflows
List all planned spending, including:
Payroll and contractor payments
Rent and utilities
Vendor payments and subscriptions
Loan payments
Owner draws and tax payments
Subtract total outflows from inflows to find your Net Cash Change, then update your ending cash balance for the week.
💡 Aureus Tip: Always plan for timing, not just amounts. If your customer usually pays 10 days late, build that into your model.
5. How to Build It in Excel or QuickBooks
You can easily build your 13-week forecast in Excel or Google Sheets, or by exporting reports from QuickBooks Online.
Start with columns for each week and rows for every major cash category (inflow and outflow).
A simple layout looks like this:
Week | Beginning Cash | Cash Inflows | Cash Outflows | Net Cash Flow | Ending Cash |
Week 1 | $25,000 | $12,000 | $9,000 | $3,000 | $28,000 |
Week 2 | $28,000 | $15,000 | $18,000 | -$3,000 | $25,000 |
💡 Aureus Tip: Use conditional formatting to highlight negative balances in red. If you see a cash dip coming, you can fix it before it happens.
6. Rolling Your Forecast Forward
The 13-week forecast should roll forward each week.
When one week ends, drop it off the left side of your spreadsheet and add a new week at the end. This keeps you constantly looking 90 days ahead.
💡 Aureus Tip: Set aside 15 minutes every Friday to update your forecast. This habit alone can transform your financial awareness.
7. How to Use Your Forecast for Decision-Making
Your 13-week cash forecast is not just a reporting tool, it’s a decision tool.
Here are a few ways smart business owners use it:
Hiring: Can you afford that new employee next month?
Owner draws: Is there room for a distribution without draining cash?
Debt payoff: When is the best time to make an extra payment?
Marketing spend: How much budget can you safely allocate to growth?
When you can see your cash runway clearly, you make confident decisions without guessing.
8. Common Mistakes to Avoid
Overestimating collections: Be realistic about when clients actually pay.
Forgetting tax payments: Include estimated taxes and payroll deposits in your cash outflows.
Ignoring seasonality: If you have slow months, plan for them now.
Not updating regularly: A forecast is only as good as the data behind it.
💡 Aureus Tip: Your forecast should evolve with your business. Review and refine it as new data and opportunities come in.
9. The Link Between Cash Flow and Tax Strategy
Cash forecasting and tax planning go hand in hand.
When you know what cash is coming, you can:
Time major purchases to maximize deductions.
Schedule estimated tax payments accurately.
Avoid underpayment penalties.
Plan owner distributions without creating liquidity issues.
💡 Aureus Tip: At Aureus, we use the 13-week forecast as the foundation for both cash management and tax strategy. It keeps you compliant and in control at the same time.
10. When to Bring in a CFO Advisory Partner
If your business has unpredictable revenue cycles, complex vendor relationships, or multiple locations, it may be time to outsource your forecasting and CFO functions.
An advisory partner helps you:
Automate reporting and integrate QuickBooks or Gusto data.
Identify trends and bottlenecks early.
Build proactive strategies around cash flow, payroll, and taxes.
Translate numbers into decisions that actually grow the business.
💡 Aureus Tip: You do not need a full-time CFO to think like one. You just need better visibility and smarter systems, both of which we can help you build.
Final Takeaway
A 13-week cash flow forecast is not a finance exercise, it is a control system for your business. It gives you confidence, clarity, and foresight so you can lead with numbers, not emotions.
The best time to start is now. Even if your forecast is rough at first, you will learn more about your business in one quarter of tracking cash than in a year of looking at profit.
Ready to Take Action?
If you want to build a 13-week forecast that actually helps you lead, not just report, schedule a CFO Advisory consultation at aureusadv.com or visit our Resources page for our 13-week cashflow template.