How to Build a 13-Week Cash Flow Forecast Without a CFO

When a private equity firm acquires a business, one of the first things they do is build a 13-week cash flow forecast. Not a budget. Not a P&L projection. A week-by-week view of exactly what cash is coming in, what cash is going out, and what the bank balance looks like at the end of each week for the next quarter.

It is one of the most useful financial tools in existence and almost no small business owner uses it. Most have never even heard of it.

The good news is you do not need a CFO or a finance team to run one. You need a spreadsheet, a couple hours to set it up, and a commitment to updating it each week. Here is how to do it.

Why 13 weeks

The 13-week window is not arbitrary. It is long enough to give you a meaningful forward view, short enough that the numbers are actually reliable. Beyond 13 weeks, your forecast is really just a guess dressed up as a projection. Within 13 weeks, you have enough visibility into your receivables, your payables, and your fixed costs to build something you can actually act on.

The goal is not precision. The goal is awareness. A 13-week forecast tells you whether you are going to have a cash problem in week 7 before week 7 arrives. That lead time is what lets you do something about it.

What goes into it

The model has three components: cash in, cash out, and ending balance. That is it.

Cash in is everything you expect to collect each week. Start with your open AR aging report. Look at what is due and when. Factor in your typical collection patterns. If you have Net 30 terms but clients usually pay in 45 days, build that reality into the model, not the ideal. Add any other expected inflows: deposits, loan proceeds, tax refunds, whatever is actually coming.

Cash out is every payment leaving your account. Fixed costs are easy: payroll, rent, debt service, subscriptions. They happen on a schedule and you know the amounts. Variable costs take more thought. Pull your last few months of bank statements and look for patterns. Vendor payments, contractor invoices, supplies, anything that recurs but varies in timing or amount. Map those out week by week as best you can.

Ending balance is just your starting cash plus cash in minus cash out. Run that calculation forward 13 weeks and you have your forecast.

The part most people skip

Building the model is the easy part. The hard part is maintaining it.

A 13-week forecast that gets built once and never updated is not a forecast. It is a spreadsheet. The value comes from running it as a rolling model: every week, you add a new week at the end, drop the week that just closed, and update your assumptions based on what actually happened.

When a client pays late, you move that cash inflow forward. When a vendor invoice comes in earlier than expected, you update the outflow. When a new contract closes, you add the expected payments. The model stays current, and so does your picture of the next three months.

This weekly discipline is also where the insight lives. When you close out each week and compare what actually happened to what you projected, you start learning where your assumptions are off. Over time, your forecast gets more accurate because you are calibrating it against reality.

What to do with it

A 13-week forecast is most useful when it shows you a problem before the problem arrives. If week 9 shows a negative balance, you have eight weeks to do something about it. That might mean accelerating collections on a few overdue invoices, pushing out a discretionary expense, drawing on your line of credit, or having a conversation with a vendor about timing.

None of those options are available to you if you find out about the cash shortfall in week 9. The forecast buys you time, and time is the most valuable thing you have when cash gets tight.

It is also useful for the opposite problem. If the forecast shows strong cash for the next 12 weeks, that is useful information too. It tells you when you can make a hire, invest in equipment, or take a distribution without putting the business at risk.

The bottom line

Most small businesses manage cash reactively. They check the bank account, cover what needs to be covered, and deal with problems as they come up. The 13-week forecast flips that dynamic. It turns cash management from a reactive exercise into a proactive one.

You do not need a finance team to run it. You need about an hour a week and a willingness to look at the numbers honestly. The businesses that do this consistently almost never get blindsided by a cash crunch. The ones that do not are the ones that end up scrambling.

If you want the forecast without the spreadsheet work, Arclite builds and maintains it automatically using your live QuickBooks data. The model updates itself every week so you always have a current 13-week view without anyone having to touch it.

Arclite is a cash flow management platform built for small and mid-sized businesses. It integrates directly with QuickBooks Online to automate AR collections, AP processing, and cash forecasting so you always know where you stand.