A 13-week cash flow forecast is a week-by-week projection of every dollar coming in and going out of your business over the next quarter. Banks request it when they spot risk signals like covenant breaches, declining performance, or new credit applications. It's built from actual cash movements (not your P&L), and this guide walks you through creating one step by step.
Take a breath. This is not a sign that your loan is being called. It's not a sign that your business is in trouble — at least, not necessarily. But it is a sign that your banking relationship just shifted from autopilot to active monitoring. How you respond in the next 7–10 days will define that relationship for years. According to QuickBooks research, 61% of small businesses struggle with cash flow, so you're far from alone in facing this conversation.
I've been on both sides of this conversation. As a CGMA-qualified finance professional with 24 years of experience, I've built 13-week cash flow forecasts for PE portfolio companies at Arle Capital Partners and Bancroft Group, for capital-intensive clean energy investments at Leaf Clean Energy, and for small businesses with SBA loans and lines of credit. I've also been the person requesting these forecasts from portfolio companies — so I know exactly what the bank is looking for, what format they expect, and what separates a forecast that builds confidence from one that raises more questions than it answers.
This guide will walk you through everything: what a 13-week cash flow forecast actually is, why your bank is asking for one, how to build it step by step, the mistakes that will make you look unprepared, and what happens if you don't deliver it.
1. What a 13-Week Cash Flow Forecast Actually Is
A 13-week cash flow forecast is a week-by-week projection of every dollar entering and leaving your business over the next quarter. Not revenue — cash receipts. Not expenses — cash disbursements. Not accruals — actual bank transactions.
Think of it as a 13-column spreadsheet where each column is one week, and each row tracks a specific source of cash coming in or going out. At the bottom of each column, you see your projected bank balance for that week. When that number approaches zero, or goes negative, you have a problem that needs solving before it arrives.
What it is NOT
This is where most business owners get confused, and where the confusion causes real problems:
- It is NOT your P&L projected forward. Your income statement records revenue when earned and expenses when incurred. A 13-week forecast tracks when cash actually moves. You can show $200K in revenue on your P&L and have $11K in the bank. (We wrote an entire guide on why this happens.)
- It is NOT a budget. A budget says "we plan to spend $240K on payroll this year." A 13-week forecast says "payroll of $19,200 hits the bank account on Friday of Week 1, Friday of Week 3, and Friday of Week 5, and Week 5 is a three-paycheck month, so it's actually $28,800."
- It is NOT a one-time document. Your bank expects this to be updated weekly, with actual results replacing prior-week projections and variance analysis showing where you were right and where you were wrong. A forecast that isn't updated weekly is a wish list, not a management tool.
A P&L tells you whether your business is profitable. A 13-week cash flow forecast tells you whether your business is solvent. Profitable businesses fail every day because they run out of cash. In fact, U.S. Bank research shows 82% of small business failures stem from poor cash flow management. Your bank knows this, which is exactly why they're asking for the forecast, not another income statement.
Why 13 weeks?
Thirteen weeks = one fiscal quarter. It's the sweet spot between two competing needs:
- Long enough to see problems coming. If a cash shortfall is eight weeks away, you have time to act: accelerate collections, negotiate payment terms, draw on a credit line. If you only see two weeks ahead, your options are limited to panic.
- Short enough to be accurate. Forecasting 6 or 12 months out is essentially guessing. But 13 weeks? You know your AR aging. You know your payroll calendar. You know your committed expenses. The inputs are concrete enough to produce reliable projections.
Banks didn't pick this timeframe arbitrarily. It's the industry standard for borrower monitoring, turnaround situations, covenant compliance reporting, and SBA lending packages. (See our complete SBA lending guide.)
2. Why Your Bank Is Asking for One
Banks don't request 13-week cash flow forecasts out of curiosity. There's always a reason, and understanding that reason changes how you should respond. Here are the four most common triggers:
Trigger 1: You've breached a loan covenant
If your loan agreement includes financial covenants (minimum debt service coverage ratio, maximum debt-to-equity ratio, minimum cash balance) and you've breached one, the bank's workout or credit monitoring team has been notified. A 13-week forecast is almost always the first thing they'll request. It tells them whether the breach was a one-time blip or a sign of systemic cash flow problems.
If you've breached a covenant, speed matters. The bank will judge your competence partly by how quickly and completely you respond to this request. A well-built 13-week forecast delivered within 5–7 business days signals "we have control of our finances." A delayed, incomplete, or sloppy forecast signals the opposite — and that's when banks start considering whether to increase oversight, raise rates, or accelerate the loan.
Trigger 2: You're applying for new credit
If you're requesting a new line of credit, an SBA loan, or an increase on your existing facility, the bank needs to verify that you can service the additional debt. The Federal Reserve Small Business Credit Survey found that 43% of SMBs applied for financing in 2023, with 27% receiving less than requested. A 13-week forecast — showing how the new credit fits into your cash cycle — demonstrates financial sophistication. It tells the lending officer: "This borrower understands their business at the cash level, not just the P&L level." That matters more than most business owners realize.
For SBA loans specifically, the 13-week cash flow projection is one of seven core documents every lender requires. (Here's the full list of what SBA lenders want to see.)
Trigger 3: Your financial performance has declined
If your revenue is trending down, margins are compressing, or your financial ratios are deteriorating, even if you haven't technically breached a covenant, your relationship manager may request a 13-week forecast as an early warning tool. This is actually a good sign in one respect: it means the bank is trying to work with you proactively rather than waiting for a formal default.
Trigger 4: You're requesting a covenant modification
If you need to renegotiate your loan terms (extend the maturity, modify a covenant threshold, restructure the payment schedule), a 13-week forecast is table stakes for that conversation. It shows the bank exactly how the modified terms will play out in real cash flows, week by week.
3. How to Build One (Step by Step)
Here's the practical process I use with every client who receives this request from their bank. You don't need special software. A well-structured Excel spreadsheet is the standard tool even at the enterprise level. What you need is accurate data, honest assumptions, and financial judgment.
-
Start with your actual bank balance — today.
Pull the current balance from every operating account. Not your QuickBooks balance, your actual bank balance, adjusted for any outstanding checks or deposits in transit you expect to clear this week. This is your Week 1 opening cash position. Every subsequent week's opening balance is automatically calculated as the prior week's closing balance, and this rolling mechanism is what makes the forecast a living tool.
-
Map your accounts receivable to collection weeks.
Export your AR aging report. For each open invoice, determine the realistic collection week, not the due date, but when the customer will actually pay based on their payment history. A $50,000 invoice on Net 30 terms from a customer who historically pays on day 42 goes in Week 6, not Week 4. This adjustment is where most forecasts break down, and it requires judgment that comes from knowing the business, not just knowing the books.
-
Map your accounts payable to payment weeks.
Same process in reverse. For each open payable, determine when you will or must pay it. Critical vendors who will shut off supply get paid on time. Vendors with flexibility get slotted based on your cash position strategy. This is an active management decision. You're not just recording when bills are due, you're deciding when to pay them based on the overall cash picture.
-
Add all fixed commitments to their exact weeks.
Payroll on exact pay dates (don't forget the three-paycheck months). Rent on the 1st. Insurance premiums on their due dates. Loan payments (principal and interest) on their scheduled dates. Equipment lease payments. These are the backbone of your disbursement forecast. They're the most predictable and usually the largest line items.
-
Add all tax payment dates.
Map these to exact dates: Form 941 federal payroll tax deposits, state withholding (varies by state; Texas has no state income tax, Florida has no personal income tax), estimated quarterly income tax payments (April 15, June 15, September 15, January 15), sales tax (monthly or quarterly depending on volume), and franchise/excise tax. These are non-negotiable dates. Miss them and penalties accrue immediately.
-
Add any known one-time or irregular payments.
Annual software renewals, quarterly contractor payments, insurance premium renewals, equipment deposits, legal retainers, annual audit fees. These are easy to forget and often large enough to blow up a week's cash position if they're not in the forecast.
-
Calculate net cash flow and closing balance for each week.
Simple arithmetic: Cash Receipts − Cash Disbursements = Net Cash Flow. Opening Balance + Net Cash Flow = Closing Cash Balance. When the closing balance approaches zero, or falls below your minimum cash target, you have a problem that needs solving before it arrives.
-
Set a minimum cash target and flag any weeks that breach it.
Work with your bank to establish an acceptable minimum cash balance, typically enough to cover 2–3 weeks of fixed operating expenses. Any week where your projected closing balance drops below this threshold gets flagged in red. This is the early warning system that the entire forecast is built to deliver.
Every week — Monday morning, before anything else — update the forecast: replace last week's projections with actual results, extend the forecast by one week to maintain the 13-week window, and perform variance analysis. What did you project? What actually happened? Was the variance timing (the payment came, just a week late) or magnitude (the payment was smaller than expected)? After 4–6 weeks of disciplined variance tracking, your forecasts will be accurate to within 5–10%. Banks notice this improvement, and it builds enormous credibility.
Need a 13-week cash flow forecast for your bank? See what one looks like.
View Our Sample 13-Week Forecast →4. Example: What a Real 13-Week Forecast Looks Like
Here's a simplified version of the forecast format I deliver to banks for clients. A real forecast includes all 13 weeks and more granular line items, but this gives you the structure:
┌──────────────────────┬──────────┬──────────┬──────────┬──────────┬──────────┬──────────┐
│ │ Week 1 │ Week 2 │ Week 3 │ Week 4 │ Week 5 │ Week 6 │
├──────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ Opening Cash Balance │ $142,000 │ $127,300 │ $103,500 │ $121,800 │ $108,600 │ $72,100 │
├──────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ CASH RECEIPTS │ │ │ │ │ │ │
│ Customer A (Net 30) │ $35,000 │ $0 │ $42,000 │ $0 │ $0 │ $38,000 │
│ Customer B (Net 15) │ $12,000 │ $12,000 │ $12,000 │ $12,000 │ $12,000 │ $12,000 │
│ Recurring / ACH │ $8,500 │ $8,500 │ $8,500 │ $8,500 │ $8,500 │ $8,500 │
│ Other receipts │ $1,200 │ $800 │ $2,300 │ $500 │ $1,000 │ $600 │
│ Total Receipts │ $56,700 │ $21,300 │ $64,800 │ $21,000 │ $21,500 │ $59,100 │
├──────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ CASH DISBURSEMENTS │ │ │ │ │ │ │
│ Payroll + taxes │($38,400) │ $0 │($38,400) │ $0 │($38,400) │ $0 │
│ Rent │ ($9,200) │ $0 │ $0 │ $0 │ $0 │ $0 │
│ Vendor payments │($16,500) │($21,800) │ ($8,100) │($18,200) │($12,300) │($15,800) │
│ Loan payment (P+I) │ $0 │ ($6,500) │ $0 │ $0 │ ($6,500) │ $0 │
│ Insurance │ $0 │ $0 │ $0 │($4,500) │ $0 │ $0 │
│ Tax payments │ ($7,300) │($16,800) │ $0 │($11,500) │ $0 │ $0 │
│ Total Disbursements │($71,400) │($45,100) │($46,500) │($34,200) │($57,200) │($15,800) │
├──────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ Net Cash Flow │($14,700) │($23,800) │ $18,300 │($13,200) │($35,700) │ $43,300 │
├──────────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
│ Closing Cash Balance │ $127,300 │ $103,500 │ $121,800 │ $108,600 │ $72,900 │ $115,400 │
│ Minimum Cash Target │ $60,000 │ $60,000 │ $60,000 │ $60,000 │ $60,000 │ $60,000 │
│ Surplus / (Deficit) │ $67,300 │ $43,500 │ $61,800 │ $48,600 │ $12,900 │ $55,400 │
└──────────────────────┴──────────┴──────────┴──────────┴──────────┴──────────┴──────────┘
Notice Week 5. The surplus above the $60,000 minimum drops to just $12,900. That's not a crisis yet — but it's a signal. If Customer A's payment slips by a week, or an unexpected expense hits, you breach the minimum. A forecast like this gives you five weeks of lead time to prevent that by accelerating a collection, delaying a vendor payment, or arranging a line-of-credit draw.
That's the point. The forecast doesn't prevent problems — it makes them visible before they become emergencies.
When a bank receives a forecast like this, they see three things immediately: (1) you understand your cash cycle at a granular level, (2) you have realistic collection assumptions based on actual customer behavior, and (3) you've identified the tight weeks and have a plan. That's exactly what builds confidence in a banking relationship. Compare that to the business owner who responds to the bank's request with, "Can you give me a few weeks?" — that response is the answer, and it's not a good one.
For a complete, bank-ready sample with all 13 weeks and supporting schedules, see our 13-Week Cash Flow Forecast sample and Bank Financing Package sample.
5. The 5 Mistakes That Make Banks Nervous
I've reviewed hundreds of 13-week forecasts, both as a PE fund manager evaluating portfolio companies and as a fractional controller preparing them for clients. These are the five mistakes I see most often, and every one of them damages credibility with your bank.
The most common, and most damaging, mistake. Revenue is what you've earned. Cash receipts are what you've actually collected. If you plug your revenue forecast into the receipts line, your forecast will be wildly optimistic because it ignores collection delays, bad debt, and timing mismatches. A bank will spot this immediately.
Quarterly estimated taxes, payroll tax deposits, sales tax, franchise tax — these are large, infrequent payments that business owners routinely forget to include. A $42,000 quarterly tax payment that doesn't appear in your forecast until it hits your bank account is exactly the kind of surprise that banks are trying to prevent.
Your 13-week forecast must be reconcilable to your balance sheet, your AR aging, your AP aging, and your bank statements. If the opening cash balance in Week 1 doesn't match your bank statement, the bank will question everything else in the forecast. If your AR receipts don't tie to your AR aging, the collection assumptions are unverifiable.
After the first week, your bank will want to see what you projected versus what actually happened. A forecast without variance tracking is static — it can't improve over time, and the bank can't assess the accuracy of your assumptions. The variance analysis is the feedback loop that turns a rough estimate into a precision instrument.
If your forecast shows every customer paying on time, your bank knows you're either dishonest or naïve, because no business collects 100% on time. The bank's credit officer has seen thousands of forecasts and knows what realistic collections look like. Aggressive assumptions don't build confidence. They destroy it.
Don't know where to start? Let's build your 13-week forecast together.
Book a Free Discovery Call →6. What Happens If You Don't Deliver It
Some business owners think they can ignore the bank's request, delay indefinitely, or submit something half-baked. Here's what actually happens in each scenario. The stakes are high: the SBA reports that roughly 20% of businesses fail in their first year, and about 50% don't survive past five years. Cash visibility is what separates the survivors.
If it's a covenant requirement
Failure to deliver a required 13-week forecast is itself a covenant violation. Not delivering the report is a separate default event, independent of whatever triggered the original request. Default provisions in loan agreements can include increased interest rates (penalty pricing), additional collateral requirements, restrictions on distributions to owners, and in the worst case, acceleration of the entire loan balance. That last one means the bank demands full repayment immediately.
If it's an informal request
Even if the 13-week forecast isn't technically required by your loan documents, ignoring an informal request from your relationship manager is a strategic mistake. Banks have institutional memory. Your RM will note in the file that the borrower was unresponsive or unable to produce basic financial reporting. That note will surface the next time you need a favor — a rate reduction, a covenant waiver, a credit increase, or a loan extension.
If you submit a poor-quality forecast
A forecast that doesn't tie to your financials, uses unrealistic assumptions, or lacks variance analysis can be worse than no forecast at all. It tells the bank one of two things: you don't understand your own business at the cash level, or you're deliberately presenting a misleading picture. Neither interpretation works in your favor. Banks escalate oversight for borrowers who demonstrate financial weakness, and a bad forecast is financial weakness on display.
The worst outcome isn't a single bad quarter. It's the permanent downgrade in your banking relationship. Once a bank classifies your loan as "watch list" or "special mention," every future interaction — refinancing, credit increases, covenant modifications, letters of credit — becomes harder, slower, and more expensive. The 13-week forecast is your opportunity to stay off that list. Don't waste it.
7. How a Fractional Controller Handles This
Most businesses between $2M and $15M in revenue don't have a full-time controller or CFO — and they don't need one. But they absolutely need controller-level capability when their bank asks for a 13-week cash flow forecast. This is exactly where a fractional controller earns their fee. Deloitte's CFO Signals survey shows 78% of CFOs plan to increase investment in financial planning technology, and a fractional controller brings that same discipline to smaller companies without the enterprise price tag.
Here's what the engagement typically looks like:
Week 1: Build the forecast
- Pull and reconcile all bank balances, AR aging, and AP aging
- Interview the business owner on customer payment patterns, vendor relationships, and known upcoming obligations
- Map every cash inflow and outflow to specific weeks with documented assumptions
- Build the 13-week model with supporting reconciliation schedules
- Review with the business owner, adjust assumptions, and finalize
- Deliver to the bank with a cover memo explaining the methodology
Weeks 2–13: Maintain and update weekly
- Every Monday: replace projections with actuals, roll forward one week
- Perform variance analysis and document explanations for material variances
- Flag any weeks where the cash position approaches the minimum threshold
- Recommend cash management actions: accelerate collections, defer discretionary spending, time credit line draws
- Prepare and submit weekly updates to the bank (if required)
Ongoing: Proactive cash management
- The 13-week forecast becomes a permanent management tool, not just a bank compliance exercise
- Monthly review meetings with the business owner to discuss cash position, upcoming challenges, and strategic decisions
- Quarterly review with the bank to demonstrate forecasting accuracy and discuss the business outlook
A full-time controller costs $95,000–$140,000/year plus benefits. A fractional controller who builds your 13-week forecast, maintains it weekly, manages the banking relationship, and provides strategic cash management recommendations costs a fraction of that, typically $3,000–$6,000/month for 15–25 hours of senior financial attention. For a $2M–$15M business, that's the right structure: controller-level competence without a six-figure salary commitment.
8. Frequently Asked Questions
What is a 13-week cash flow forecast that banks ask for?
A 13-week cash flow forecast is a week-by-week projection of every dollar entering and leaving your business over the next quarter. It shows your opening bank balance each week, all expected cash receipts (customer payments, recurring revenue, other inflows), all expected cash disbursements (payroll, rent, vendors, taxes, debt service), and your projected closing cash balance. Banks ask for it because it proves you understand your cash cycle and can service your debt obligations week by week, not just on a monthly or annual basis.
Why is my bank suddenly asking for a 13-week cash flow forecast?
Banks typically request a 13-week forecast in four situations: you've breached or are at risk of breaching a loan covenant, you're applying for new credit (including SBA loans), your financial performance has deteriorated and the bank wants closer monitoring, or you're requesting a covenant modification or loan restructuring. It's not necessarily a sign of trouble. Proactive banks often request it as a standard monitoring tool. But it does mean your banking relationship has shifted from passive to active, and how you respond matters.
Can my bookkeeper build a 13-week cash flow forecast for the bank?
Most bookkeepers are not equipped to build a bank-quality 13-week forecast. Bookkeeping records what already happened; a 13-week forecast requires forward-looking judgment — estimating when customers will actually pay, anticipating timing mismatches, modeling scenarios, and making strategic cash management recommendations. This is controller-level work. A fractional controller can build and maintain this forecast for your bank, working alongside your existing bookkeeper who provides the clean transactional data that the forecast relies on. (Learn more about what goes into a 13-week forecast.)
What happens if I don't provide the 13-week forecast my bank requested?
If it's a covenant requirement, non-delivery is itself a covenant violation — which can trigger default provisions including increased interest rates, additional collateral requirements, or acceleration of the entire loan balance. Even if it's an informal request, ignoring it damages your banking relationship and creates a negative file note that will surface in every future lending conversation. A poor-quality forecast can be even worse. It demonstrates financial weakness to the one party you most need to impress. Respond quickly, respond completely, and respond with a forecast that ties to your actual financials.