Finance operations
Cash-Flow Forecasting: Build a 13-Week Liquidity View
A 13-week cash-flow workflow for timing receipts and payments, reconciling weekly balances, setting owner thresholds, and turning shortfalls into controlled actions.
9 min read
Short answer
A useful 13-week cash forecast starts with one reconciled opening cash balance, places receipts and payments in the week cash is reasonably expected to move, and carries every closing balance into the next week's opening balance. For each week, net movement equals inflows minus outflows, and closing cash equals opening cash plus net movement. Keep expected customer receipts separate from booked revenue, include tax reserves and other committed payments without inventing legal dates, and label assumptions by source, owner, confidence, and review date. Compare each weekly close with an owner-approved minimum-cash threshold. A breach opens an exception with an owner and action; it does not authorize the team to delay payroll, tax, debt, or supplier payments without a fact-specific review. Replace estimates with actual cash movement, explain variance, and reforecast the remaining horizon without rewriting the original trail.
Forecast cash timing, not accounting profit
| Question | Forecast treatment | Evidence | Do not assume |
|---|---|---|---|
| Customer invoice | Place cash only in the week collection is supported by the current promise, pattern, or conservative assumption. | Invoice status, customer commitment, ageing, dispute state, and collection owner. | Booked revenue will arrive on the invoice date. |
| Supplier or payroll cost | Place the expected cash payment in its controlled payment week. | Approved payment run, contract or payroll calendar, and owner confirmation. | An accounting expense is paid in the same period it is recognized. |
| Tax or compliance reserve | Use the amount and timing approved for the applicable entity and period, then keep it visibly reserved. | Dated computation or adviser instruction and separate approval status. | A generic internet date or last year's amount applies now. |
| Financing or capital item | Include only when timing and conditions are sufficiently supported; keep a conditional scenario otherwise. | Approved facility, drawdown conditions, purchase commitment, and decision owner. | A proposal, unsigned term sheet, or possible asset sale is available cash. |
Build one continuous 13-week sheet
- 01
Freeze the opening balance
Reconcile the forecast start to the controlled bank and cash close. State which accounts, restricted balances, and cut-off items are included. Assign the finance owner and start timestamp.
- 02
Create 13 dated weekly buckets
Use one consistent week boundary. Record the cash date, not the invoice, order, accounting, or hope date. Do not manufacture a legal payment or filing date from the weekly bucket.
- 03
Load receipts by confidence
Separate committed or strongly supported receipts from timing assumptions. Record the internal reference, owner, expected week, confidence, and next confirmation date without copying customer or bank data into a shared summary.
- 04
Load committed and planned payments
Include payroll, supplier runs, rent, debt service, approved capital spend, tax reserves, and other material cash uses. Keep discretionary plans distinguishable from obligations that need specialist review before change.
- 05
Calculate continuity in integer paise
For every row, net equals inflows minus outflows; closing equals opening plus net; and the next opening equals the prior closing. The final close must also equal initial opening plus total net movement.
- 06
Apply owner thresholds and scenarios
Compare each close with the approved minimum-cash threshold and any board, lender, payroll, reserve, or operational limits. Scenarios change named assumptions; they do not overwrite the base case.
- 07
Close actuals and roll forward
Replace completed weeks with actual cash movement, classify timing and amount variance, preserve the prior version, add the next week, and assign every open exception before publishing the refreshed view.
Use a reconciled weekly artifact
| Week | Opening | Inflows | Outflows | Net | Closing |
|---|---|---|---|---|---|
| 1 | Rs 10,000 | Rs 1,000 | Rs 800 | Rs 200 | Rs 10,200 |
| 2 | Rs 10,200 | Rs 1,000 | Rs 800 | Rs 200 | Rs 10,400 |
| 3 | Rs 10,400 | Rs 1,000 | Rs 800 | Rs 200 | Rs 10,600 |
| 4 | Rs 10,600 | Rs 1,000 | Rs 800 | Rs 200 | Rs 10,800 |
| 5 | Rs 10,800 | Rs 1,000 | Rs 800 | Rs 200 | Rs 11,000 |
| 6 | Rs 11,000 | Rs 1,000 | Rs 800 | Rs 200 | Rs 11,200 |
| 7 | Rs 11,200 | Rs 1,000 | Rs 800 | Rs 200 | Rs 11,400 |
| 8 | Rs 11,400 | Rs 1,000 | Rs 800 | Rs 200 | Rs 11,600 |
| 9 | Rs 11,600 | Rs 1,000 | Rs 800 | Rs 200 | Rs 11,800 |
| 10 | Rs 11,800 | Rs 1,000 | Rs 800 | Rs 200 | Rs 12,000 |
| 11 | Rs 12,000 | Rs 1,000 | Rs 800 | Rs 200 | Rs 12,200 |
| 12 | Rs 12,200 | Rs 1,000 | Rs 800 | Rs 200 | Rs 12,400 |
| 13 | Rs 12,400 | Rs 1,000 | Rs 800 | Rs 200 | Rs 12,600 |
| Total | Initial Rs 10,000 | Rs 13,000 | Rs 10,400 | Rs 2,600 | Rs 12,600 |
Turn threshold breaches into owned exceptions
| Trigger | Required classification | Owner action | Close evidence |
|---|---|---|---|
| Weekly close below the owner-approved minimum | Amount, first breach week, duration, base/scenario, and confidence-sensitive receipts. | Assign a decision owner to confirm collections, review discretionary timing, or escalate protected obligations. | Approved decision, revised assumption, and refreshed continuity check. |
| Material expected receipt moves or fails | Timing variance, amount variance, dispute, dependency, and customer follow-up state. | Update the receipt week and run the affected scenarios; do not silently retain the old date. | Dated owner confirmation or actual bank receipt reference. |
| Payment amount or timing changes | Obligation, discretionary plan, tax reserve, payroll, debt, supplier, or capital item. | Obtain the correct commercial, legal, tax, payroll, or lender review before changing a protected payment. | Approval reference and revised forecast version. |
| Opening or actual close does not reconcile | Bank cut-off, duplicate, omission, transfer, restricted balance, or unexplained difference. | Block publication of the refreshed forecast until the difference is resolved or visibly quarantined. | Reconciliation owner, resolution, and preserved variance trail. |
Review at a cadence that follows risk
| State | Suggested operating response | Owner question |
|---|---|---|
| Stable base case | Refresh on the approved weekly close and roll the horizon back to 13 weeks. | Did actual cash and every material assumption change as expected? |
| Threshold breach or narrow buffer | Review more frequently until the decision and funding path are controlled. | Which assumption creates the first breach, and who can resolve or escalate it? |
| Material transaction or operating event | Reforecast when a major customer, hire, contract, tax estimate, debt draw, capital purchase, or funding fact changes. | Does the event change cash timing, only accrual profit, or both? |
| Unreconciled actuals | Withhold the refreshed view or label it incomplete; do not solve the gap with an unexplained plug. | Which source and owner can close the difference? |
Sources and review
Published by ThynkBored. Published 16 July 2026. Content review completed 16 July 2026.
- Preparing for funding applications
Business.gov.uk, UK Government. Accessed 16 July 2026.
Supports: Institutional guidance to prepare a cash-flow forecast as part of funding readiness; Need to explain funding requirements and the business plan supporting them.
- Management accounts: good practice guide for colleges
Department for Education, UK Government. Accessed 16 July 2026.
Supports: Institutional example of cash-flow forecasting within a recurring management-information pack; Use of variance commentary, risks, actions, ownership, and forward-looking information.
- Manage your finances
U.S. Small Business Administration. Accessed 16 July 2026.
Supports: Small-business use of balance sheets and cash-flow projections for financial control; Separation of financial records, cash position, and planning decisions.
This article provides an educational operating model, not accounting, audit, tax, legal, insolvency, lending, investment, or treasury advice. The figures are synthetic and demonstrate integer-paise arithmetic after display rounding; they are not a forecast, benchmark, safe-cash recommendation, or promise of receipts, funding, profitability, or solvency. The cited UK and US institutional material supplies general management and funding context only; it does not establish Indian accounting treatment, law, tax, lender requirements, or a suitable threshold for this business. Actual cash availability depends on bank reconciliation, restrictions, settlement timing, customer and vendor facts, payroll, tax, debt, contracts, disputes, approvals, and events. The model does not determine whether a payment may lawfully be deferred, calculate a statutory or contractual amount, or supply a legal deadline. Confirm material obligations and decisions with the appropriate owner and qualified professional. Preserve actual records and approvals in a restricted system.
Name the first cash decision, not every transaction
Share only the entity category, forecast stage, whether opening cash reconciles, broad first-breach band, assumption-completeness status, exception category, owner status, and decision horizon. ThynkBored can help structure the forecast, controls, and escalation questions before a secure evidence review.
Use categories and status only. Do not send bank names or account numbers, statements, balances, transaction rows, customer or vendor identities, invoices, payroll, tax computations, debt documents, contracts, credentials, passwords, OTPs, files, or free-text financial evidence through the public form. Agree a secure handoff before any restricted record review.
Diagnose this issueQuestions owners ask
Why is cash-flow forecasting useful for small businesses?
A 13-week forecast makes cash timing visible before a decision becomes urgent. It separates expected receipts from available cash, reconciles every weekly opening and closing balance, and shows when an owner-approved minimum may be breached. Its value is the controlled decision trail, not a promise that assumptions will occur.
How often should a business review cash flow?
Use an approved weekly close for a rolling 13-week view, then review more frequently when the first breach is near, a material receipt or payment changes, actual cash does not reconcile, or a hiring, tax, debt, capital, customer, or funding event changes the assumptions. Cadence should follow risk rather than one universal calendar rule.
Useful context for this decision
Follow the records, definitions, comparisons, and next actions connected to this page.