Build a 13-Week Cash Flow, Line by Line

Most early founders know roughly how much money they have. They check the bank account a few times a week. They have a vague sense of what’s coming in and going out. And for a while, that works.

The problem is “roughly” stops working the moment something unexpected happens — a client pays late, a vendor invoice lands early, or payroll hits in the same week as a large software renewal. Suddenly the bank balance you checked on Monday looks very different by Friday, and you’re scrambling to cover something that, if you’d seen it two weeks earlier, would have been completely manageable.

That’s the gap a 13-week cash flow forecast closes. Not by adding complexity, but by replacing guesswork with a clear picture of where your cash goes — week by week, for the next quarter.

Why 13 weeks — and not quarterly, not monthly

The most common alternative to a 13-week forecast is a quarterly view: you look at the business three months at a time. The problem is a quarterly view hides weekly reality. You can look fine for Q3 and still run short on cash in Week 7 because two large client invoices landed in Week 11 instead.

A monthly view is better but still too coarse. It tells you February looks fine. It doesn’t tell you that payroll clears February 15th and your biggest AR payment won’t land until February 22nd — and that gap matters when you’re running lean.

Thirteen weeks is the right horizon because accuracy degrades as forecast range increases. The 13-week model targets 90–95% accuracy in weeks 1–4, tapering to 70–85% accuracy in weeks 9–13 — long enough to act on, close enough to be reliable. Beyond 13 weeks, you’re projecting more than you’re forecasting.

It also aligns with how most external stakeholders think. Banks, investors, and advisors think in quarters. A 13-week forecast covers a full quarter with weekly precision underneath it — so when someone asks for a view of your cash position, you’re not cobbling one together from memory.

What a 13-week cash flow actually is

A 13-week cash flow forecast is not a P&L. Your P&L shows revenue and expenses on an accrual basis: when they’re earned or incurred, not when cash actually moves. A P&L that shows $60k in November revenue doesn’t tell you when those payments clear your account.

A 13-week forecast tracks real cash movement — what physically hits or leaves your bank account, in which week. This is called the direct method, and it’s the only method that matters for short-term decision-making. You can’t pay payroll with accounts receivable. You pay it with cash.

The model is also simpler than it sounds. At its core, it’s one formula repeated 13 times:

Opening Cash + Cash In − Cash Out = Closing Cash

Closing cash in Week 1 becomes opening cash in Week 2. And so on. What changes week to week are the inputs — and there are only four of them.

Building the forecast step by step

Set up rows and columns

Create a spreadsheet with weeks across the top (columns) and cash categories down the side (rows). The model needs three core sections: Cash Inflows, Cash Outflows, and the Weekly Summary.

Section	Example line items	Notes
Cash Inflows	Customer collections (by aging bucket), cash sales, customer deposits, loan proceeds, tax refunds	List in order of certainty; separate high-confidence receivables from speculative inflows
Cash Outflows	Payroll (including employer taxes), rent, vendor invoices, debt service, insurance, estimated taxes, owner distributions	Fixed outflows: exact amounts and dates. Variable outflows: conservative estimates
Weekly Summary	Beginning Cash, Net Cash Flow, Ending Cash	Ending Cash rolls forward to next week’s Beginning Cash; highlight weeks below your minimum threshold

The summary row is the number you are managing. It tells you whether you have enough cash to cover obligations or whether a gap is forming that needs attention.

Start with what’s actually in the bank

Begin with the actual cash balance in all operating accounts as of the start of Week 1. This is not the accounting balance. It is confirmed, available cash: what is in the bank today, minus outstanding checks not yet cleared.

If your business has a revolving line of credit, note the available balance separately. Drawing on it has a cost and should be modeled as a distinct decision.

When will the money actually arrive?

This is the most technically demanding part of the model, and where most early forecasts fail by being too optimistic.

For each inflow category, project the week cash is expected to actually clear the bank, not the week the sale is recorded or the invoice is sent.

For accounts receivable, pull your current AR aging report and apply your actual collection history. If your business consistently collects 70% of receivables within 30 days and the remaining 30% between 31 and 60 days, apply those percentages to your outstanding invoices by aging bucket. Resist the impulse to assume overdue invoices will catch up faster than they historically have.

For recurring revenue or contract retainers, schedule with precision. For project-based businesses, tie inflow timing to milestone completion and client approval cycles, not contract start dates.

According to CFO Hub’s guidance on 13-week forecasting, inflows should always be listed in order of certainty. When in doubt, push timing one week further out than you expect.

Put every payment on the week it actually leaves

For outflows, the goal is precision. Pull your vendor payment terms and identify the exact date each invoice will be paid. Map payroll to its exact draft dates, including employer payroll taxes. Schedule all known fixed payments: rent, loan payments, equipment leases, insurance premiums, and subscriptions.

Then add every annual or quarterly obligation that falls within the 13-week window. These are the items that catch businesses off guard when they plan only month to month.

Variable outflows, such as inventory purchases, should be driven by your sales forecast and restocking cycle. Engage your operations team to validate assumptions. The model is only as accurate as the inputs that feed it.

Find the weeks where cash falls short

Once the model is populated, review the ending cash balance for each of the 13 weeks. Any week where the projected balance falls below your minimum operating threshold is a gap that needs a response. The earlier you identify it, the more options you have:

• Accelerate collections on high-balance outstanding invoices
• Negotiate extended terms with a key vendor
• Draw on a line of credit during a low-use period
• Defer a discretionary expense to a later week
• Adjust the timing of owner distributions

None of these requires a crisis. They require only enough lead time to execute. If the model reveals a gap that none of those levers can close, the business has a structural issue requiring a deeper conversation about working capital, pricing, or financing. Discovering that problem eight weeks in advance is recoverable. Discovering it on payroll day is not.

What maintaining it weekly looks like

A forecast you build once and never touch is a document. A forecast you update every week is a tool. The maintenance is straightforward. Each Monday:

• Enter the prior week’s actual inflows and outflows
• Replace forecast amounts with actuals
• Roll the model forward by adding Week 14
• Compare actuals to projections — where they differed, understand why

Note where you were wrong and why. If you forecast $12,000 in AR and only $8,000 cleared, flag it. Did a client pay late? Was an invoice disputed? These patterns tell you how to sharpen your AR assumptions. Graphite Financial’s benchmarks suggest targeting 90–95% accuracy in the first four weeks — and the variance log is how you get there.

Assign clear ownership of this process. Forecasts without ownership get abandoned during busy periods, which is precisely when they are most needed. For businesses without an internal finance function, consulting support from an outside team is often the most practical path.

What good looks like

After four to six weeks of maintaining the model, the shift becomes tangible. You can answer “where do we stand in 12 weeks?” in under two minutes — with a specific number, not a range, not a feeling. You can see a cash constraint forming six weeks before it becomes a crisis, which means you have time to accelerate an AR collection, push an AP payment by a week, or have a financing conversation when you’re not desperate.

The model doesn’t just report your cash position. It gives you decision time. Once it’s running, four numbers inside it — and across your business — tell you more about your survival odds than anything else. That’s what the next part of this guide walks through.