Short answer
A 13-week cash flow forecast is a rolling projection of your cash inflows and outflows over the next 13 weeks. It is a critical tool for managing short-term liquidity, especially during uncertainty. The forecast helps you see cash shortages weeks in advance, so you can arrange financing, delay spending, or accelerate collections before problems hit. This template breaks down the steps to build one, even if your business lacks sophisticated financial systems.
Build the template across five core sections: beginning cash, cash inflows, cash outflows, net cash flow, and ending cash. Weekly buckets let you track timing precisely. The result is a living document you update or adjust each week, not a static plan. Start with data you already have, like bank statements and upcoming invoices, and refine as you learn.
The 13-week horizon covers a full quarter and is longer than a typical monthly view, giving you early warning for seasonal dips or payment cycles. It is also short enough to remain realistic and often required by lenders during turnaround situations. You do not need special software; a spreadsheet is enough. Keep formulas simple: ending cash this week becomes the beginning cash next week.
Define Your Starting Point and Timeline
Before entering each transaction, set the starting cash balance for week one. That amount is the actual cash available today, including bank accounts and cash on hand, but excluding credit lines you might draw. Clearly state the date the first week begins and confirm the forecast covers exactly 13 weeks. Use a rolling approach: at the end of each week, remove the oldest week and add a new one. That keeps the forecast always 13 weeks ahead, which is a common practice for short-term liquidity management.
Decide the granularity of entries. If your business has daily unpredictability, weekly totals may be enough for a forecast. If you operate with tight margins or have cyclical peaks, you may need daily lines for some accounts. The template should be explicit about whether each column represents a single week or a group of days. Regardless, keep the total period exactly 13 weeks so you can compare periods consistently and respond to seasonal patterns.
- Include actual cash, not expected sales on credit.
- Specify the start date and ensure the horizon is exactly 13 weeks.
- Plan to update the forecast at least weekly.
- Decide whether to track weekly or daily cash flows.
List All Realistic Cash Inflows
Cash inflows include collections from customers, cash sales, loan proceeds, asset sales, and any other source where money actually arrives. For each week, estimate how much cash you expect to receive. For existing receivables, review aging reports and consider each account's payment behavior; for future sales, use conservative estimates based on history or confirmed orders, not just projected revenue. The World Bank's B-READY methodology highlights that combining de jure data (like laws) and de facto data (like firm surveys) gives a better view of the actual business environment. Similarly, your forecast should rely on real cash movement data, not just what is ideal or expected.
On a weekly basis, map expected payments to specific weeks. For example, if you issue an invoice on the first of the month with 30-day terms, you may expect payment in week five. Discounts for early payment, if offered, could bring cash earlier. Recognize that not all customers pay on time, so build in a historical collection rate. This avoids overstating inflows. Your sales ledger or cash receipt records can show the average delay between invoice date and payment date; use those figures to assign inflows to the correct week.
- Include customer collections, cash sales, and other cash receipts.
- Match each invoice to a probable payment week based on history.
- Use conservative estimates for future sales.
- Track actual inflows weekly versus forecast to identify variances.
Identify All Cash Outflows by Week
On the outflows side, list every cash payment you expect to make during the next 13 weeks. Common categories include supplier invoices, payroll, taxes, rent, loan payments, and operating expenses. Fixed payments like rent have a set due date, while variable ones like raw materials depend on your ordering and payment terms. Go through your outstanding purchase orders and contracts to assign specific payment weeks. For recurring obligations such as debt service, check the amortization schedule to match exact cash flows.
Do not overlook less frequent items, such as insurance premiums due quarterly or annual bonuses. Add a separate line for each significant outflow, and aggregate small discretionary expenses into a single line. The sum of your fixed and variable outflows for the week shows the total cash required. This detailed approach helps you spot weeks where cash runs negative, so you can delay non-critical spending or negotiate longer credit terms with suppliers. Many small business owners find that listing outflows takes the most effort, but it produces the most valuable insight.
- Break down outflows into categories such as payroll, rent, taxes, and supplier payments.
- Review purchase orders and contracts for payment due dates.
- Account for irregular payments like insurance premiums or annual fees.
- Distinguish fixed and variable expenses to adjust quickly.
Compute Net Cash Flow and Ending Balance
For each week, subtract total outflows from total inflows to get net cash flow. Then add this net amount to the beginning cash balance to get the ending cash balance for that week. That ending balance becomes the starting point for the next week. Track this calculation in a spreadsheet across all 13 weeks. If the ending cash balance ever falls below your minimum required level, you have a signal to act. The minimum may be a cushion you choose, for example, enough to cover two weeks of payroll.
When you spot a potential shortfall, the forecast becomes a planning tool. You can decide to delay hiring, push customer collections, or arrange a credit line in advance. The goal is to ensure you always have enough cash to operate and to build credibility with lenders or investors. The U.S. Department of Energy's audit guidance emphasizes that audits can inform infrastructure planning and resilience; similarly, a cash flow forecast informs your strategic spending and helps you respond to operational disruptions early.
- Add a row for net cash flow under each week.
- Carry forward the ending balance as the next week's beginning balance.
- Set a minimum cash threshold and compare weekly balances against it.
- If the balance dips below the threshold, revise your inflow or outflow plan.
Review, Revise, and Communicate
A forecast is useful only if it reflects current reality. At the end of each week, update actual inflows and outflows for that week, then adjust your estimates for the remaining weeks based on new information. For instance, if a customer pays later than expected, shift that inflow to a later week and extend the forecast by one week. Regular revision also helps you identify patterns: a certain month may consistently have higher expenses, or a supplier may always pay a discount early. Over time, the forecast becomes more accurate.
Share the headlines with your team or advisors, especially if the forecast reveals a cash shortage. Let department heads know how their spending plans affect cash so they can make informed decisions. If you seek external financing, a 13-week forecast can demonstrate to banks that you understand your cash position and have a plan to manage it. That can improve your chances during tough times. But remember, no forecast is perfect; you must check your actual performance and adjust assumptions constantly. Building this discipline may be the most valuable outcome for your business.
- Compare weekly forecast versus actual cash flows and note variances.
- Adjust remaining weeks for any significant changes.
- Share high-level cash needs with stakeholders to align decisions.
- Use the forecast as a basis for loan requests or credit planning.
What to verify
- The forecast relies on estimates; actual cash flows will differ.
- You must check your specific tax and legal obligations with a local advisor.
- The sources provided do not mention specific cash flow forecasting formulas, so this article gives general guidance based on common practice.
- Do not treat this template as a guarantee of liquidity; external factors not foreseeable can affect your results.
Questions and answers
How often should I update my 13-week cash flow forecast?
You should update it at least weekly, but daily checks may be necessary if your cash balance is tight or volatile. Each week, replace the oldest week with a new one and revise estimates based on actual numbers. Frequent updates help you spot issues early and make the forecast more reliable.
What is the difference between a 13-week cash flow forecast and a budget?
A budget typically shows expected revenues and expenses over a year, not cash timing. A 13-week forecast focuses purely on cash movements week by week, showing when money actually comes in and goes out. It reveals timing gaps that a budget might hide, such as a month with many supplier payments but slow customer collections.
Can I use this template if my business is not in the U.S.?
Yes, the principles are universal. Just adjust for local payment practices, tax schedules, and banking conventions. For example, in some countries, customers may take months to pay, so your collection estimates must reflect what happens in your market. Always base the forecast on your actual cash flow patterns rather than assumptions.
Sources and verification date
- Official source: energy.govenergy.gov · Checked
- Official source: worldbank.orgworldbank.org · Checked
- Official source: ces.techces.tech · Checked