The 13-week cash flow forecast (with template)

Free assessment

See if PILTA can help. A free 15-minute call with the PILTA Founder and CEO Ryan or one of our expert executives and strategists.

A 13-week cash flow forecast is a week-by-week projection of the cash a business will collect and pay out over the next quarter, ending in a cash balance for each week. It works from actual receipts and payments instead of profit, rolls forward every week, and gets checked against what really happened. Built well, it gives an owner several weeks’ notice of a shortfall, while there is still time to act.

Most small businesses run on a thin cushion. The JPMorganChase Institute’s analysis of 2.1 million small businesses with Chase business accounts found the median one held enough cash to cover 17.6 days of outflows in 2025. In the Federal Reserve Banks’ 2025 Small Business Credit Survey, 50 percent of employer firms named uneven cash flow as a financial challenge, and 54 percent named paying operating expenses.

This guide covers how the forecast works, how to build it step by step, which lines a product company needs, how to keep it accurate and what to do when it shows a gap. The Excel template on this page is a starting file for the steps below. PILTA’s other free templates are on the tools page.

Quick definitions

13-week cash flow forecast: A rolling weekly projection of cash receipts, cash payments and ending cash for the next 13 weeks, about one quarter.

Direct method: Forecasting cash from the actual receipts and payments expected each week, instead of starting from net income.

Variance analysis: Comparing each week’s actual receipts and payments with the forecast and explaining the differences.

Minimum cash balance: The lowest cash level the business plans never to go below, set high enough to cover payroll and other must-pay items.

What a 13-week cash flow forecast is

The forecast has 13 weekly columns, one for each week of the next quarter (13 weeks of 7 days is 91 days). Each column lists the cash expected in, the cash expected out and the ending balance, and each week’s ending balance becomes the next week’s opening balance. Finance teams also call it a 13-week cash flow model, or TWCF.

The format comes from restructuring. Wall Street Prep describes it as a near-term weekly forecast built with the direct method, and notes that lenders asked to fund a company through bankruptcy almost always expect a credible 13-week forecast. It has since spread well beyond distressed companies: the accounting body AICPA & CIMA recommends a rolling 13-week cash flow cycle to businesses managing their cash.

Weekly detail matters because payroll, rent, supplier payments, loan payments and taxes land on specific dates. A monthly forecast can show a positive month that hides a week when the account goes negative.

13-week cash forecastAnnual budgetMonthly profit forecast
MeasuresCash in and outPlanned revenue and spendingRevenue, cost and profit
Time unitWeeksMonthsMonths
HorizonNext 13 weeks, rollingFiscal yearRest of the year
MethodDirect: receipts and paymentsAccrualAccrual
UpdatedEvery weekOnce a yearMonthly
Main useLiquidity decisionsTargets and spending limitsPerformance tracking

Why profitable companies still run short of cash

Profit and cash move on different schedules. A product company pays for inventory weeks or months before it sells, waits on wholesale and retail customers who pay on terms, absorbs deductions from retailers, and pays quarterly taxes and loan installments in lumps. The income statement books a sale on the day it happens, and the cash can arrive 30, 60 or 90 days later.

Inventory makes the gap wider. A brand that pays a manufacturer a deposit at order and the balance before shipment, then sells the goods on terms, can have the cash for one production run out of its account for several months. Two overlapping runs during a growth spurt double the exposure.

A Harvard Business Review analysis of growth and cash makes the same point: a profitable company that grows too fast can run out of cash, because each new sale ties up cash in inventory and receivables before it pays back. The guide on how to scale operations covers that math, and the 13-week forecast shows the effect week by week.

At Tivic Health, I carried interim CFO duties through leadership changes and ran its cash-flow scenarios and board materials.

How to build a 13-week cash flow forecast

For an owner asking how to forecast cash flow, this method is a practical place to start. It needs the bank balance, the list of open customer invoices, the unpaid bills and open purchase orders, and the payroll and tax calendar.

  1. Set up the grid. Create 13 weekly columns, pick a week-ending day such as Friday, and add one column for last week’s actual results.
  2. Start from real cash. The opening balance is cash in the bank today, less checks written that have not cleared. A forecast tied to an actual balance can be checked every week.
  3. Forecast receipts by collection week. Place each open invoice from the AR (accounts receivable) aging in the week the customer is likely to pay, based on that customer’s payment history. Add new sales in the week the cash should arrive, by channel: website payouts, Amazon payouts, wholesale and retail invoices, and other inflows such as loan draws.
  4. List every payment by week. Include payroll and payroll taxes, supplier and contract manufacturer payments from AP (accounts payable) and open purchase orders, freight and duties, 3PL (third-party logistics provider) fees, rent, software, insurance, sales tax, estimated income tax, loan payments, credit card balances, equipment purchases and owner distributions. Wall Street Prep notes that wages and benefits are usually the largest disbursement in a distressed company.
  5. Calculate ending cash and set a floor. Opening cash plus receipts minus payments equals ending cash, which carries into the next week. Add a row for the minimum cash balance and a row for unused credit, so any week that drops below the floor stands out.
  6. Compare actuals with the forecast each week. Enter what really came in and went out, calculate the difference line by line, and label each gap as timing, which will reverse, or a real change, which needs a new assumption.
  7. Roll it forward. Drop the week that just ended, add a new week 13, update the assumptions and start the cycle again.

In a small company, the owner or the bookkeeper often builds the first version, and a controller or CFO takes it over as the company grows. Whoever owns it updates the forecast every week and brings it to the same meeting.

The lines a product company needs

Product companies have extra cash timing to model: inventory deposits, freight and duties, channel payouts and retailer deductions. A first version needs 10 to 15 lines. The table shows where each number comes from.

LineWhere the number comes fromTiming to watch
Website and Amazon payoutsPayout reports from the store platform and AmazonPayouts arrive days after the sale
Wholesale and retail collectionsAR aging and each customer’s payment historyDeductions and chargebacks reduce what arrives
Inventory and manufacturer paymentsOpen purchase orders and supplier termsDeposits at order, balances at shipment or on terms
Freight, duties and tariffsFreight quotes and customs broker invoicesDue around the time goods land
3PL and fulfillment fees3PL invoicesMonthly, rising with volume
Payroll and payroll taxesPayroll calendarFixed dates that must be met
Operating expensesAP aging and recurring billsMostly monthly
Taxes and debt serviceTax calendar and loan schedulesLarge, irregular amounts

How to keep the forecast accurate

Accuracy comes from the weekly comparison. In a turnaround column for the American Bankruptcy Institute’s ABI Journal, John Dischner of AlixPartners notes that weekly cash models lose accuracy over time, with the first several weeks far more reliable than the last. Weeks 1 to 4 should be close, weeks 10 to 13 will be rough, and each week gets tightened as it moves closer.

Four habits keep the forecast honest:

  • One owner per line. Each line belongs to the person who controls it, such as sales for collections and operations for purchasing. Dischner makes the same point: when cash gets short, accountability has to sit with specific managers.
  • Conservative receipts. Use each customer’s real payment timing, and leave out sales that are not yet won.
  • No quiet pushes. Moving a hard payment into a later week needs a note explaining why and, when it affects a supplier, a call to that supplier.
  • A fixed weekly slot. Update the forecast at the same time each week from fresh bank, receivables and payables data, and review it in a 30-minute meeting.

Add a downside case for the biggest swings, such as a large customer paying a month late, a delayed container or a sales month below plan. The gap between the base case and the downside case shows how much room the business has.

Forecasting discipline pays off across operations. At Yondr, a PILTA engagement, forecasting reached near-100 percent accuracy with 12+ months of visibility.

What to do when the forecast shows a gap

A gap several weeks out leaves room to act. The main levers, roughly from fastest to slowest:

  • Collect faster. Invoice on shipment, follow up on every past-due invoice, ask for deposits on large or custom orders, and resolve retailer deductions.
  • Time payments. Talk to suppliers before a payment is late, ask for split or extended terms, and move spending that can wait out of the gap weeks.
  • Buy less inventory. Cut or delay purchase orders for slow sellers, order closer to need, and clear excess stock.
  • Use credit early. Draw on a line of credit before the low week, and bring the forecast to the bank when asking for more.
  • Change the plan. Delay hires or equipment purchases, cut discretionary spending, or raise prices.

The forecast also points to the right lever. Late receipts point to collections. Payment spikes around each inventory buy point to purchasing and supplier terms.

When to bring in finance help

Outside help makes sense when the forecast shows a shortfall inside the 13 weeks, when a lender or investor asks for one, when the books close too late to trust the opening numbers, or when no one on the team has time to own the weekly update. A fractional CFO or controller can build the model, clean up the books behind it and run the weekly review. The guide to fractional and full-time CFOs covers what each one does and costs, and Finance & Accounting covers the work itself.

Download the 13-week cash flow template (Excel). Free, no sign-up.

How PILTA helps

PILTA helps owners, founders and executive teams clear bottlenecks and production constraints and unlock commercial expansion, then puts proven strategies in place to grow sales, increase margin and scale operations. Through Finance & Accounting, senior operators build the 13-week forecast with the team, clean up the books behind it, run the weekly review and tie it to the decisions that move cash, such as collections, inventory buys, supplier terms and pricing, across operations, supply chain, sales channels, marketing, finance and systems. Every engagement follows the 4D Method: Diagnose, Design, Develop, Deploy.

Frequently asked questions

How can I forecast the cash flow of my business?

Use the direct method on a weekly grid. Start with today’s cash, list expected collections by week from open invoices and new sales, list every payment by week from payroll, bills, purchase orders, taxes and loans, and calculate the ending cash for each week. Cover the next 13 weeks, compare actual results with the forecast every week, and roll it forward one week at a time.

How do you create a cash flow forecast?

Gather the inputs, then build it week by week. The inputs are the current bank balance, the list of open customer invoices, unpaid bills and open purchase orders, the payroll calendar, and the dates of tax, rent and loan payments. Place each receipt and payment in the week the cash actually moves, total each week, and carry the ending cash into the next week.

Struggling with cash flow forecasting – how do you all actually do it?

Keep it small and weekly. A first version needs 10 to 15 lines: two or three for receipts by channel, the rest for payroll, inventory, freight, rent, software, taxes and debt. Update it at the same time every week from the bank balance and the receivables and payables lists, note why last week was off, and fix the assumption behind the miss.

How do you realistically forecast cash flow when customers pay on net 60 90?

Forecast each customer’s real payment pattern instead of the stated terms. Pull six to twelve months of invoices, measure how many days each major customer actually takes to pay, and schedule open invoices by that lag. Subtract expected deductions. New sales on net 60 or 90 terms land two to three months out, so the near-term weeks depend almost entirely on invoices already sent.

29yo COO of $16M family business: profitable on paper but cash-flow negative and now behind on rent. What would you do?

Build a 13-week cash forecast first to see how large the gap is and when it peaks. Then work the levers in order: collect overdue receivables, agree payment plans with the landlord and key suppliers before more bills go late, stop inventory buys that won’t sell inside the window, cut discretionary spending, and take the forecast to the bank. Profit on paper with negative cash usually means cash is tied up in inventory or receivables.

Sources

Thoughtful experts, building with you, when you need it. Book a free 15-minute call with PILTA, or reach the team at ContactUS@pilta.com.

See if PILTA can help. Get on a call with the PILTA Founder and CEO Ryan or one of our expert executives and strategists. No cost, no obligation, just 15 minutes of your time.

Free assessment

See if PILTA can help.

Get on a call with the PILTA Founder and CEO Ryan or one of our expert executives and strategists. No cost, no obligation, just 15 minutes of your time.

About the author

Ryan Sabia, Founder and CEO of PILTA

Ryan has spent 22+ years from Fortune 500’s like Mars Inc, Toyota and J.P. Morgan to 7+ founder-CEO startups, with 4 public companies, a NASDAQ IPO and 5 M&A deals. At PILTA he helps owners, founders and executive teams clear bottlenecks and production constraints and unlock commercial expansion. LinkedIn