A weekly forecast can show when cash may get tight before payroll, taxes, suppliers, or financing payments come due. Here is a practical way to build one and keep it current.
The short answer: A 13-week cash flow forecast estimates when money will enter and leave your business over the next three months. Start with cash available today, then list expected receipts and payments by the week they are likely to clear. Update it weekly with actual bank activity. It can surface a possible timing gap; it does not predict whether a lender or funding provider will approve financing.
A monthly profit-and-loss statement can show whether a business earned more than it spent, but not whether cash will be in the account on the day payroll, rent, taxes, suppliers, or financing payments are due. A weekly forecast focuses on that timing.
Use current records and the best information available. Gather bank balances and restrictions, open invoices and collection dates, payroll and operating bills, taxes, inventory purchases, and every scheduled loan, lease, or merchant cash advance debit. Include one-time expenses and known seasonal changes. A spreadsheet is sufficient for a first version; keep business and personal transactions separate.
Create a column for each of the next 13 weeks and one row for each major source of cash or payment category. For each week:
Ending cash = opening cash + expected cash received − expected cash paid. Keep line items visible so you can see which assumptions drive a projected shortfall.
Build a base case using your best current estimate and a downside case that allows for slower collections, lower sales, or an unexpected expense. Label assumptions clearly. Scenarios help you plan for uncertainty; they are not predictions or promises about future cash.
If a shortfall appears, note when it occurs and what is driving it. Check whether a receipt is uncertain, whether a bill can be rescheduled by agreement, or whether a recurring cost needs review. Before taking on financing or changing a payment arrangement, read the relevant agreement and consult qualified legal, tax, or accounting professionals for those questions.
At week’s end, replace estimates with actual cleared transactions, compare actual results with the forecast, and revise the remaining weeks. Record why important differences occurred. Those notes can improve assumptions about customer payment timing, seasonality, and recurring expenses.
Show each business financing debit separately and use the amount and schedule reflected in the agreement and bank records. For variable or revenue-linked payments, use the contract terms and actual receipts to make a reasonable estimate; do not assume a payment automatically falls when revenue falls. A cash flow model is a planning aid, not a contract interpretation or prediction of negotiated terms.
Renaissance Capital Advisors provides business consulting and administrative coordination. Legal advice or representation is provided by an attorney retained directly under a separate agreement. Explore Rencap’s business debt and cash flow insights or use the MCA calculator to review payment math.
What is a 13-week cash flow forecast?
A weekly estimate of a business’s expected receipts and payments over the next 13 weeks, starting with cash currently available.
How often should I update it?
Update it weekly by replacing estimates with actual cleared transactions and revising the remaining weeks.
Should I include MCA payments?
If the business is making merchant cash advance payments, list each scheduled debit using the agreement and recent bank activity. The forecast shows timing; it does not determine whether a contract allows an adjustment.
Does a forecast show whether I qualify for financing?
No. It organizes cash timing and assumptions. A lender or funding provider applies its own criteria, and the forecast does not guarantee approval or terms.
For other practical guidance, browse all Rencap insights.