Illustrative management view
13-Week Cash Outlook
Decision window: A large insurance payment and slower expected collections create pressure in weeks 7–8. Review payment timing, collections and discretionary spending now.
Action identifiedA healthy bank balance today does not guarantee comfortable cash next month. The real question is whether the business can see what is coming early enough to make a good decision.
For mortgage companies, real-estate firms and property-management businesses, cash rarely moves in a perfectly even rhythm. Commissions arrive after closings. Management fees follow collection cycles. Insurance, licensing, payroll, vendor payments and debt service arrive on their own schedules.
A 13-week cash-flow forecast brings those timing differences into one practical view. It does not attempt to predict the distant future with false precision. It helps leadership understand the next quarter well enough to protect cash, plan spending and act before a shortfall becomes urgent.
What is a 13-week cash-flow forecast?
A 13-week cash-flow forecast is a rolling weekly projection of money expected to enter and leave the business over approximately one quarter. It begins with available cash, adds expected receipts, subtracts expected payments and calculates the projected ending balance for every week.
Its value comes from timing. A monthly forecast might suggest that July is financially comfortable. A weekly forecast can reveal that payroll is due five days before a large customer payment is expected. The month may end well while the middle of the month still requires attention.
The U.S. Small Business Administration emphasizes that forecasting cash flow helps businesses look beyond the current bank balance and consider the sales, expenses, debt payments and asset purchases behind future cash movement. That is exactly the purpose of a short-term rolling forecast: turning known activity into an earlier decision.
Why 13 weeks?
Thirteen weeks is long enough to expose patterns but short enough to forecast with useful detail. It normally captures several payroll cycles, monthly debt payments, rent or occupancy costs, major vendor cycles and at least one quarter-end.
Near enough to know
Many customer receipts, payroll dates, debt payments and contractual expenses are already visible.
Far enough to respond
Leadership has time to accelerate collections, adjust timing, postpone discretionary spending or arrange financing.
Short enough to maintain
A weekly rolling model stays practical and can be updated without rebuilding a full annual budget.
The four-part forecasting process
Use actual available operating cash—not an unreconciled ledger balance or restricted funds.
Forecast when cash is reasonably expected, not simply when revenue appears on the Profit & Loss.
Include payroll, vendors, debt, taxes, licenses, insurance and known one-time payments.
Compare forecast with actual results, explain differences and add a new week every week.
1. Begin with cash that is actually available
Start with reconciled bank balances as of a clear date. Remove restricted, escrow, trust, security-deposit or client funds that cannot be used for ordinary operations. Mixing available cash with funds held for someone else can make liquidity appear stronger than it is.
If several entities or branches are included, decide whether the forecast should be consolidated, entity-specific or both. A consolidated balance can hide an entity-level shortage when cash cannot move freely between accounts.
2. Forecast receipts based on timing—not optimism
Begin with specific expected receipts: open invoices, scheduled management fees, approved reimbursements, contracted payments and other amounts supported by current information.
Do not automatically place every invoice into the week it becomes due. Use actual collection history and known customer behavior. If a client regularly pays 15 days after the due date, the base forecast should reflect that reality.
- Separate committed receipts from possible receipts
- Use conservative timing for disputed or older receivables
- Avoid treating pipeline activity as collected cash
- Document large assumptions so they can be reviewed
3. Build the payment schedule from real obligations
List recurring and one-time cash outflows in the week they are expected to clear. Start with the obligations that keep the business operating and compliant.
- Payroll, benefits and payroll-related payments
- Rent, technology, utilities and recurring operating costs
- Vendor payments and contractor obligations
- Debt service and financing fees
- Insurance, licensing and annual renewals
- Planned equipment, hiring, marketing or expansion spending
- Owner distributions that have been approved or are being considered
Separate committed expenses from discretionary spending. That distinction gives management a clear lever if the forecast identifies pressure.
4. Calculate weekly ending cash and the lowest point
For each week, calculate:
Opening cash + expected receipts − expected payments = projected ending cash
The lowest projected balance often matters more than the balance at the end of week 13. It identifies the point at which the business has the least flexibility and helps leadership decide how much operating cushion is appropriate.
5. Compare the forecast with what actually happened
A forecast becomes more useful through repetition. Each week, replace the forecasted week with actual cash activity, investigate important differences and add one new week to the end.
Forecast variance is not automatically a failure. It is information. A customer payment that arrived later than expected may reveal a collection pattern. A recurring expense that was consistently underestimated may expose incomplete assumptions. The objective is to make the next forecast more dependable.
What should the forecast help you decide?
| What the forecast shows | Question to ask | Possible response |
|---|---|---|
| A temporary timing gap | Will expected receipts arrive after required payments? | Accelerate collections, adjust vendor timing or use an established credit facility appropriately. |
| A recurring cash decline | Is the underlying operation consuming more cash than it creates? | Review margin, overhead, pricing, staffing and recurring commitments. |
| Excess operating cash | How much must remain available before cash is redeployed? | Establish a reserve target before considering distributions or investment. |
| Dependence on one receipt | What happens if the payment is delayed? | Create a conservative scenario and protect essential payments. |
| Pressure from optional spending | Does the timing support the planned investment? | Phase, postpone or resize the expenditure. |
Cash-flow forecasting by industry
Mortgage companies
Separate closed and funded activity from pipeline expectations. Consider commission timing, branch costs, warehouse or lending-related obligations, licensing renewals and cash that may be restricted.
Real-estate firms
Model commission receipts using expected closing dates while recognizing that closings can move. Include agent payments, marketing commitments, office costs and seasonal production patterns.
Property-management firms
Keep operating cash separate from trust and owner funds. Model management-fee timing, owner receivables, payroll, vendor obligations and major technology, insurance or licensing payments.
Five mistakes that make cash forecasts unreliable
1. Starting with unreconciled books
If the opening cash position is wrong, every projected balance is wrong. Reconciliation is the first forecasting control.
2. Confusing revenue with cash receipts
Revenue recognition and customer payment timing are not always the same. Forecast when the money is expected to arrive.
3. Including restricted funds as available cash
Trust, escrow, security-deposit and other client funds may be visible in bank accounts but unavailable for operating expenses.
4. Building only an optimistic scenario
A base forecast should reflect the most supportable expectation. A conservative scenario shows what the business would do if an important receipt moves or costs increase.
5. Creating the forecast once and never updating it
A static spreadsheet becomes outdated quickly. A 13-week forecast should roll forward and improve as actual information becomes available.
Your accounting reports explain what happened. Your cash forecast should help you decide what happens next.
Greenkey’s Growth and Vision services can add cash-flow analysis, forecasting and decision-ready reporting to a dependable monthly bookkeeping process.
Explore Growth reporting support →
Explore Vision advisory support →
13-week cash-flow forecast FAQs
How often should a 13-week cash-flow forecast be updated?
Update it weekly. Replace the completed week with actual results, explain meaningful differences and add one new week to the end so the forecast always covers the next 13 weeks.
What is the difference between a cash-flow forecast and a budget?
A budget establishes financial expectations, typically across a year. A 13-week cash-flow forecast focuses on the timing of actual money entering and leaving the business over the near term. They support different but related decisions.
Can a profitable business have a cash-flow problem?
Yes. A profitable business can experience cash pressure when customers pay after expenses are due, debt payments are significant, working capital grows or cash is used for equipment, distributions or other Balance Sheet activity.
Should restricted or trust funds be included?
They should not be treated as available operating cash. Track restricted funds separately and follow all applicable agreements, legal requirements and industry rules.
Do I need special software to build the forecast?
No. A well-structured spreadsheet can work, and some accounting or forecasting platforms provide cash-planning tools. The quality of the opening data, assumptions and review process matters more than the software alone.
See the decision before it becomes urgent
A useful cash-flow forecast does not promise certainty. It creates visibility. It shows where the business may have room to invest, where timing could create pressure and which assumptions deserve attention now.
When the forecast is built from clean books and reviewed consistently, cash management becomes less reactive. Leadership can discuss options while there are still options available.
Want a clearer view of the next 13 weeks?
Schedule a discovery call →
Explore dashboard and report-card options →
Greenkey Accounting Services provides bookkeeping and reporting support. We do not prepare tax returns or provide legal, tax, lending or investment advice. Cash requirements and regulatory obligations vary by business.