13-week cash-flow forecast template and how to use it

A 13 week cash flow forecast template is a weekly spreadsheet that starts with opening cash, adds expected receipts, subtracts planned disbursements and shows closing cash for each of the next 13 weeks. It exists to answer one question: will there be enough cash to pay payroll, rent and vendors on the day each falls due.

Why is the forecast 13 weeks long?

Thirteen weeks is one quarter. That is long enough to see a payroll cycle, a rent cycle and at least one sales-tax, VAT or GST remittance, and short enough that the receipts side can be built from real invoices rather than guesses.

The weekly grain matters more than the horizon. The median US small business holds only 27 cash buffer days, and businesses in restaurants and retail hold about 19 (JPMorgan Chase Institute, 2016). A monthly report cannot show that cash dips below zero on the Thursday payroll runs in week 6 and recovers by the following Tuesday.

Cash pressure is common rather than rare. In the Federal Reserve’s 2025 survey of employer firms, 51% cited uneven cash flows and 56% cited paying operating expenses as financial challenges (Federal Reserve Banks, 2025). A weekly forecast is the cheapest tool for turning that pressure into a plan.

What goes in the template?

The template below is the whole thing. Copy it into a spreadsheet, one column per week, with the closing cash of each week linked to the opening cash of the next. The figures shown are illustrative for a service business with fortnightly payroll and monthly rent; replace them with your own.

Three rows do the work. Opening cash is the reconciled bank balance for week 1 and the prior closing figure after that. Total receipts and total disbursements are sums of the detail lines above them. Closing cash is opening plus receipts minus disbursements, and the low point across the 13 columns is the number to watch.

In the example, the low point is 34,800 in week 1. If the business has set a floor of 40,000 to cover one payroll plus rent, week 1 is already below it and the owner knows on Monday morning, not at month-end. Add as many detail lines as you need, but keep the four structural rows in the same place so the sheet stays readable.

How do you fill in receipts?

Start with the AR aging report, not the invoice due dates. Customers pay on their own patterns, and the pattern is in your history. If a customer averages 45 days on 30-day terms, place their open invoices in the week 45 days after the invoice date.

Then add sales that have not been invoiced yet. For a service business that is the pipeline of work in progress that will bill this month. For retail or e-commerce it is the daily takings or marketplace payouts, which arrive on a known settlement cycle. Put card-processor payouts on the settlement date, net of fees, because that is what hits the bank.

Leave a receipts line for everything else: tax refunds, loan drawdowns, asset sales, owner contributions. Do not include a receipt until it has a date and a reason. Optimism on the receipts row is the most common way a 13-week forecast fails.

How do you fill in disbursements?

Disbursements are easier because most are scheduled. Payroll dates come from the payroll calendar, including the employer taxes and pension or superannuation that settle a few days later. Rent, loan payments, insurance and subscriptions recur on known dates. The AP aging gives vendor bills with due dates, and your own payment run dates decide which week they leave.

The tax calendar is the line most often missed. Sales tax, VAT and GST are collected in receipts and then leave in one lump on the remittance date, which is why week 8 in the example shows a 9,800 outflow. Add income-tax installments, payroll-tax deposits and any annual items such as workers’ compensation premiums that fall inside the window.

Owner draws deserve their own line. They are the most controllable outflow, and a forecast that shows draws explicitly makes the trade-off visible: draw 2,000 in week 5 or keep the floor. Distributions that are planned but not committed belong in a separate scenario, not in the base case.

How do you update it each week?

Pick a day and keep it. The morning after the weekly bank reconciliation is ideal because the opening balance is then a reconciled figure rather than an online-banking screenshot. The update has three steps and takes under an hour once the sheet is built.

First, overwrite last week’s forecast column with the actual receipts and disbursements from the bank, and note the variance on each detail line. Second, delete the completed week from the left and add a new week 13 on the right, so the window always rolls forward. Third, re-time any receipts that slipped, and check whether the low point moved.

The variance notes are where the value is. If customer collections came in 4,000 under forecast for three weeks running, the problem is the assumption, not the customers, and the receipts timing needs to move out. If vendor payments ran over, the AP run is bigger than the aging suggested and someone is paying bills outside the process.

What do you do when the closing cash goes negative?

A negative closing figure in any column is a decision, not a surprise, and the forecast gives you weeks to make it. The options come in a fixed order: bring receipts forward, push disbursements back, then add financing. Each has a cost and the forecast shows which is cheapest for that week.

Bringing receipts forward means collections. A focused call cycle on the 30-plus bucket of the aging, a deposit request on new work, and a card-payment link on every invoice typically move more cash than any other lever. Our accounts receivable service runs that cycle, and the cash-flow forecasting service updates the forecast as promises to pay are logged.

Pushing disbursements back means asking vendors for terms, rescheduling non-critical purchases, and holding owner draws until the low point passes. Financing, whether a line of credit, invoice financing or an owner loan, is last because it costs the most and takes the longest.

How does this differ from a budget or a cash-flow statement?

A budget is annual, monthly and accrual-based; it answers whether the business is profitable and where spending should go. A cash-flow statement is historical and reports last period’s operating, investing and financing cash flows. The 13-week forecast is forward, weekly and cash-based; it answers whether the bank balance stays above the floor. All three come from the same ledger and should agree.

Both major ledgers now include a built-in short-term view: Xero shows a 30, 60 or 180-day forecast depending on plan, and QuickBooks Online includes cash-flow forecasting on Advanced (vendor plan pages, Sep 2026). These are useful for a quick read, but they forecast from due dates rather than payment behavior, so most businesses still keep the weekly sheet. Pricing depends on volume and scope, so we send a custom quote within 1 business day.

Sources

• JPMorgan Chase Institute, Cash is King: Flows, Balances, and Buffer Days: jpmorganchase.com
• Federal Reserve Banks, 2025 Report on Employer Firms: fedsmallbusiness.org
• US Small Business Administration, Manage your finances: sba.gov
• Xero, US pricing plans: xero.com
• Intuit, QuickBooks Online plans and pricing: quickbooks.intuit.com