Guide

13-week cash flow forecast: how to build one and what lenders look for

By the Vanward team · Last updated

A 13-week cash flow forecast shows when cash will enter and leave the business over the next quarter, one week at a time. Start with available bank cash, add expected customer collections and other receipts, subtract payments by their expected payment dates, and carry each ending balance into the following week. Update it weekly with actual receipts and payments, then add a new final week. Lenders look for credible collection assumptions, complete obligations, the lowest cash balance, and a realistic response if liquidity tightens. The forecast should explain timing and uncertainty clearly enough that a reviewer can trace a large receipt or payment to its source.

Build the weekly cash bridge

Fix a start date and consistent week-ending dates. Reconcile the opening bank balance and identify restricted cash separately. Use customer-level receivables and collection dates for receipts. Schedule payroll, taxes, rent, suppliers, debt service, and capital purchases by expected payment date. Include annual renewals and other irregular obligations.

For each week, opening cash plus receipts less payments equals ending cash. The next week begins with that ending balance. Keep financing receipts separate from operating collections and do not count an expected funding round as committed cash. Record the owner and source for material assumptions so a reviewer can follow up.

A worked example: a collection slips one week

A fictional company begins with $120,000 of available cash. Its first three weeks of a 13-week forecast are below; the same calculation continues through week 13. Payments include payroll, suppliers, and scheduled debt service.

WeekOpening cashReceiptsPaymentsEnding cash
1$120,000$50,000$70,000$100,000
2$100,000$40,000$85,000$55,000
3$55,000$80,000$60,000$75,000

If $30,000 of week 2 collections arrives in week 3, week 2 ends at $25,000 and week 3 still ends at $75,000. A management cash floor of $40,000 would be missed by $15,000 in week 2 even though the week 3 balance recovers. That floor is an example, not a lender covenant. The action is to confirm the collection date and arrange a feasible response before the shortfall, rather than assuming the customer pays early.

What lenders look for

Present the minimum weekly cash balance, any borrowing needed, and the assumptions behind the largest collections. Show whether debt service, taxes, and overdue suppliers are fully included. Explain differences between last week's forecast and actual results. A repeated collection miss matters even when the ending balance remains positive.

Include a downside case with delayed receipts or lower sales, plus actions with an owner and decision date. Separate discretionary spending changes from payments you are obligated to make. Follow the credit agreement and the lender's requested format for delivery; a forecast does not replace a required compliance certificate.

What this looks like in Vanward

FinReadi Close provides a cash reconciliation step with ledger and supporting balances, attached evidence, and preparer and reviewer assignments. Keep the weekly forecast in your planning workbook and use the reconciled cash and supporting records from the close to establish its starting point.

For a broader cash horizon, try the free startup runway calculator. It estimates runway from cash and burn; weekly payment timing still belongs in the 13-week forecast.

Questions controllers ask

Why use 13 weeks?
Thirteen weeks covers roughly a quarter while keeping payroll, collections, and payment dates visible. It is a practical planning horizon, not a universal lender requirement. Follow the reporting period and format your lender requests.
Is this the same as a cash flow statement?
No. A cash flow statement reports historical activity. A weekly forecast estimates future receipts and payments. Reconcile completed forecast weeks to actual cash activity before projecting the remaining weeks.
Should revenue go in the receipts row?
Only when it is expected to be collected. An invoice issued this week may not produce cash until next month. Use payment terms, aging, collection history, and specific customer commitments to estimate the collection week.
Can I include an undrawn credit line as cash?
Show available borrowing separately from bank cash. Include a draw only when the forecast states its timing and the facility permits it. Limits, borrowing conditions, and lender approval can restrict access.
How often should I update the forecast?
Weekly is a useful baseline. Replace the completed week with actual activity, explain meaningful differences, refresh collection and payment assumptions, and extend the forecast by one week. Tight liquidity may require more frequent monitoring.

How ready is your close?

Eight yes-or-no questions, two minutes, no account. You get a score out of 100 and the three gaps most likely to come up in an audit or a diligence request.

Take the free close check

Related

Build the forecast on a supported close.

FinReadi Close keeps supporting evidence and review with the period. Starter is $400 a month or $4,000 a year for one entity.

See FinReadi Close