13-Week Cash Flow Template: A Weekly Operating Model

A 13-week cash flow forecast answers one question, weekly: will there be enough cash in the bank to cover what must be paid? Thirteen weeks is one quarter, long enough for payroll cycles, quarterly tax payments, and slow collections to collide on the page, and short enough that the assumptions stay grounded in real invoices and real due dates rather than annual averages.

Fill it out in a fixed order. Opening cash comes from this morning's bank balance, not the accounting file's book balance. Customer collections come from your accounts receivable aging report and signed contracts, placed in the week the cash will actually arrive. Payroll comes from the payroll calendar at full cash cost. Vendors come from the AP list and known recurring charges. Debt from the loan schedules, taxes from your CPA's estimate schedule, and owner payments as an explicit line rather than a surprise.

Then run the weekly loop: same day every week, copy last week's forecast, enter actuals, write one sentence per major variance, and roll the model forward a week. The variance sentences are where the forecast gets smarter; after a month you will know which customers really pay in 45 days and which vendor debits land early. The forecast protects the quarter, while your annual operating budget plans the year; the two should agree about the big commitments.

Take the default assumptions in the model above: an illustrative firm with $100,000 of opening cash, $50,000 of weekly collections, $22,000 of weekly payroll, $18,000 of weekly vendor and operating payments, a $3,000 monthly debt payment, $2,000 of weekly owner draws, and a $15,000 estimated tax payment scheduled in week 11.

On a monthly view, this business looks comfortable: roughly $200,000 of monthly collections against about $175,000 of monthly outflows. The weekly view tells a sharper story. Most weeks net about $8,000 positive, but week 11 absorbs the tax payment and nets negative, and if one large customer slides two weeks, the collections row drops by $50,000 exactly when the tax bill lands. Rerun the model with week 10 and 11 collections cut in half and watch the ending-cash row: the cushion that looked like $100,000 spends most of the quarter under $40,000.

That is the entire value of the tool: it converts "we should be fine" into a specific floor, a specific tight week, and a specific deadline for action. The owner in this example has until week 10 to accelerate two invoices or trim discretionary spending, and knows it in week 1.

Forecasting revenue instead of cash. An invoice sent is not cash received. Every receipts cell should hold the week the money hits the bank, which for many businesses is 30 to 60 days after the work.

Using book balance as opening cash. Outstanding checks and pending debits make the accounting balance differ from the bank. Start from the bank, reconcile to the books monthly.

Leaving out taxes and annual renewals. Estimated taxes, insurance renewals, and annual software contracts are the classic week-wreckers. Schedule them explicitly.

Building it once and abandoning it. A 13-week model updated weekly is an early-warning system; updated never, it is a souvenir of one optimistic afternoon. Put the 30-minute update on the calendar before you build the file.

Hiding owner draws. Owner payments are real cash leaving the business. Model them as their own line so the protective options in a tight week are visible and honest.

If you want the model owned, updated, and reviewed for you, that weekly rhythm is the core of an outsourced CFO engagement, with clean books underneath from outsourced bookkeeping.