How a 13-Week Cash Flow Forecast Pulled a $1.8M Business Out of a Cash Crisis

13-week-cash-flow-forecast-dashboard-small-business

Profitable businesses run out of cash all the time.

You can post revenue, book work months ahead, and still stare at a payroll run you are not sure you can cover. The gap is almost never profit. It is timing you pay before you get paid.

A 13-week cash flow forecast closes that gap. It shows you, week by week, exactly when cash gets tight, so you can act three weeks early instead of three days late.

This post walks through a real engagement. A language services company with roughly $1.8M in revenue was $95,099 short against near-term obligations, with zero available credit and debt priced at 39–49% APR. One quarter later, it was profitable with no new capital raised.

You will learn:

• What a 13-week cash flow forecast is and why 13 weeks

• The five moves that turned this company around

• How to build your own forecast, step by step

• The warning signs that mean you need one now

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a rolling projection of every dollar entering and leaving your bank account over the next 13 weeks, updated weekly. It starts with your current cash balance, adds expected collections, subtracts payroll, vendors, debt service, and taxes, and shows your ending cash position for each individual week.

Three things make it different from a standard financial report:

• It is forward-looking. A P&L tells you what happened. This tells you what is about to happen.

• It is weekly, not monthly. A month can look fine on paper and still contain a week where you cannot make payroll.

• It rolls. Every week you drop the week that just closed and add a new week 13. The horizon never shrinks.

  
  

Why 13 weeks?

Thirteen weeks is one fiscal quarter. It is long enough to see a problem coming and short enough that your estimates are still grounded in real invoices, real contracts, and real due dates. Push past a quarter and you are guessing. Stay inside a month and you are reacting.

The Situation: Profitable on Paper, Strangled by Timing

This client details anonymized for confidentiality. Figures drawn from the client's financial statements.

This company had been a fractional CFO client since 2023. Revenue was steady near $1.8M. The business was not failing it was suffocating.

Here is what the numbers showed:

• A $95,099 cash shortfall against near-term obligations, with no cash reserve

• Zero available credit on both lines of credit

• Debt carrying 39–49% APR, with interest consuming essentially all operating income

• A structural timing squeeze: contracts billed net 30, while school, insurance, and nonprofit clients paid in 45–60 days

Read that last point again, because it is the whole problem. The company paid vendors and payroll before it collected. Every month. That is not a profit problem. That is a working capital problem, and no amount of new sales fixes it more revenue actually makes it worse.

Meanwhile, the books gave leadership no forward view of cash. Decisions were made month to month, reactively, with no way to see a shortfall coming.

How to Build a 13-Week Cash Flow Forecast (Step by Step)

This is the sequence we used. You can run it in a spreadsheet. You do not need new software.

1. Set your starting cash. Pull today's actual bank balance across all operating accounts. Not book balance bank balance.

2. Lay out 13 columns, one per week. Use a consistent week-ending day, usually Friday.

3. Forecast collections by invoice. Do not use an average. Take each open invoice, apply the payment behavior that customer actually shows, and place it in the week you expect the cash. A client who has paid in 55 days for two years pays in 55 days.

4. Forecast outflows by due date. Payroll, payroll taxes, rent, vendors, debt service, sales tax, insurance. Fixed items are easy. Variable items go in at your recent run rate.

5. Calculate ending cash for each week. Starting cash + collections − outflows = ending cash, which becomes next week's starting cash.

6. Mark every week that goes below your minimum. Set a floor one payroll cycle is a reasonable starting point. Any week under it gets flagged now, not later.

7. Update it every week and roll it forward. Replace forecast with actuals, note the variance, add a new week 13. The variance is where the learning lives.

   
   

The most common mistake

Owners forecast the revenue they hope to book instead of the cash they can prove is coming. Your 13-week cash flow forecast should be built from signed contracts and issued invoices. Keep the pipeline in a separate scenario line so you never confuse hope with cash.

What We Did Five Moves

1. Built a rolling 13-week cash flow forecast, updated weekly. This replaced reactive month-end reporting with a forward view that flagged tight weeks before they arrived. Every other decision below depended on this one existing first.

2. Restructured the debt-paydown strategy. The highest-APR facilities (39–49%) were sequenced to be retired first. That is the arithmetic answer, not a preference the most expensive dollar of debt is the first dollar you kill. Interest was eating essentially all operating income.

3. Ran a cost review. Operating expenses were identified and reduced across software, bank charges, travel, and discretionary categories. Not a hiring freeze. Not a slash-and-burn. A line-by-line review of what the business was actually buying.

4. Established AR collection discipline and priority. Past-due accounts dragging cash were targeted directly, and a dependable weekly collection rhythm was created. Collections stopped being a task someone did when they remembered, and became a scheduled operation.

5. Funded the turnaround entirely through freed cash. No new capital. No outside financing. The money to fix the business was already inside the business it was trapped in AR, in high-interest payments, and in spend nobody was reviewing.

The Results Q1 2025 vs. Q1 2026

Metric	Change
Net income	+$84.6K swing (−$16.7K → +$68K)
Net operating income	+424%
Interest expense	−48%
Operating costs	−9.5%
Monthly debt service	~$28,000 → ~$3,400
New capital raised	$0

The company swung from a quarterly net loss to solid profitability in a single quarter.

Within the first four months of 2026, net operating income reached $120,526 more than the entire prior full year of $90,300.

"Katherine saved my business from bankruptcy." Company owner and CEO.

Do You Need a 13-Week Cash Flow Forecast?

You probably do if any of these are true:

• You check your bank balance before you approve a purchase order

• You have been surprised by a payroll or tax payment in the last six months

• Your customers pay slower than your vendors require

• You are carrying merchant advances, revenue-based financing, or any facility priced above 20% APR

• Your line of credit is fully drawn and stays that way

• You cannot answer "what will my cash balance be six weeks from now" within a dollar range you trust

One of those is a signal. Three or more is a cash crisis that has not announced itself yet.

What this does not fix

A 13-week cash flow forecast is a visibility tool, not a magic one. It will not create demand, and it will not save a business whose unit economics do not work. What it does is buy you time and remove surprise and in this engagement, that was enough, because the underlying business was sound. Yours may need a pricing or margin fix alongside it. An honest forecast will tell you which situation you are in.

Conclusion

Cash problems feel like emergencies because they arrive without warning. Remove the surprise and most of them become manageable problems with a schedule attached.

That is what happened here. Same revenue. Same clients. Same team. What changed was that leadership could see three months ahead, and could act on the most expensive debt, the slowest receivables, and the softest spend in a deliberate order.

$95,099 short to profitable in one quarter. No new capital.

Get a clear view of your next 13 weeks.

If you cannot say what your cash balance will be six weeks from now, that is the problem worth solving first. Book a free 30-minute cash flow review with Finanzeal Solutions. We will look at your current position, your AR aging, and your debt structure, and tell you plainly whether a rolling forecast would change your decisions.

FAQ

What is a 13-week cash flow forecast? It is a rolling week-by-week projection of cash in and cash out over the next quarter, updated every week. It shows your ending cash balance for each of the next 13 weeks so you can spot a shortfall before it becomes an emergency.

Why 13 weeks and not 12 months? Thirteen weeks equals one quarter long enough to act, short enough that your inputs are real invoices and real due dates rather than assumptions. An annual budget answers a different question and does not help you make a payroll decision.

How often should I update it? Weekly. A 13-week cash flow forecast that is updated monthly is just a slower report. The weekly rhythm is what makes it useful, and comparing forecast to actual each week is how the forecast gets more accurate over time.

Can I build a 13-week cash flow forecast in a spreadsheet? Yes. Most start there, and a spreadsheet is fine as long as someone owns it and updates it on schedule. The discipline matters more than the tool.

Should I pay down debt or build a cash reserve first? It depends on the rate and your runway. Debt priced at 39–49% APR is destroying operating income every month it stays outstanding, so retiring the highest-cost facilities first is usually the strongest use of freed cash. Your own answer depends on your rates, your covenants, and how thin your weeks look the forecast is what makes that decision visible instead of theoretical.

How fast can a cash flow turnaround happen? It varies. In the engagement described here, the swing to profitability took one quarter, but that business had sound revenue and a timing problem, not a demand problem. A company with margin or pricing issues has more to fix, and the forecast will surface that early.

What does a fractional CFO actually do? A fractional CFO gives you senior financial leadership part-time: forecasting, debt and capital structure, margin analysis, KPI reporting, and the decisions that sit above bookkeeping. You get the expertise without a full-time executive salary.