Cash-flow forecast: build a 13-week business plan

A cash-flow forecast estimates when money reaches the business's usable accounts and when committed payments leave them. It is different from a profit forecast. A company can record a sale before the customer pays, and an equipment purchase can use cash long before its cost is recognized in the income statement. The forecast makes those timing differences visible instead of hiding them behind a revenue target.

Start with the decision the model must support. It might be a loan payment, a supplier deposit, an additional hire or a new location. Define the period and the minimum cash cushion you want to protect. A thirteen-week view is often a useful short-term planning window, but it is not a universal lender requirement. Choose the detail that makes the actual decision reviewable.

Use a reconciled balance from the accounts the business can actually use. Record the date and separate restricted funds, customer money held for another purpose and accounts that are not part of operating liquidity. A large bank balance may not be entirely available for payroll. Keeping those distinctions explicit prevents the forecast from financing a project with cash already committed elsewhere.

Check uncleared payments, pending card settlements and expected bank charges before finalizing the opening balance. Decide consistently whether those items belong in the starting balance or the first forecast week. They should appear once, not twice. Keep a reconciliation note with the model so another team member can understand how the number was derived from the bank records.

Build expected customer receipts from open invoices, payment history and verified collection information. A contractual due date can be a starting point, but it is not a guarantee of payment. Separate confirmed payment commitments from assumptions about normal behaviour. Include deposits and cash sales according to when funds become usable, after considering settlement timing and relevant deductions.

Future sales require additional assumptions about delivery, billing and collection. Do not move an unsigned opportunity directly into the same confidence category as an accepted invoice. A clear forecast distinguishes existing receivables, contracted future work and speculative demand. The distinction helps explain why two businesses with similar booked revenue may have different amounts of cash available for debt service.

List payroll, supplier obligations, rent, taxes, insurance, existing debt, owner payments and other expected cash outflows. Use the payment date rather than the accounting period wherever possible. A quarterly insurance premium or a large tax payment can create a low point that disappears in a simple monthly average. Record the obligation even if the business hopes to negotiate a later date.

Separate committed and discretionary spending. A signed purchase order may be difficult to cancel, while a planned upgrade can sometimes be staged. Do not label an expense discretionary without checking the contract and its operational consequences. The forecast should identify realistic actions the business can take if collections arrive later, not assume every payment can be postponed without a cost.

For each week, closing cash equals opening cash plus usable receipts minus cash payments. The next week begins with the preceding week's closing cash. Keep the calculation simple enough to audit. If additional lines are needed for transfers, financing or restricted accounts, label them clearly and preserve the same principle: a receipt or payment should appear once in the usable-cash calculation.

For a hypothetical example, opening cash of $30,000 plus $18,000 collected and $22,000 paid produces $26,000 of closing cash. If the next week collects $12,000 and pays $20,000, its closing balance is $18,000. The business can be profitable over a longer period while approaching a short-term reserve limit. These numbers are an educational example, not a forecast of any company.

When modeling a proposed loan, enter actual net proceeds on the expected funding date. List fees, payoffs and closing charges consistently. If charges are deducted before the money reaches the account, use the net amount and avoid deducting them again. If the business pays a charge separately, show the payment on its own date. A headline loan amount is not always the usable cash received.

Add every required debt payment on the correct schedule. Monthly, weekly and daily repayments create different low points. Include an expected balloon balance or a known rate reset where applicable. A fixed-rate calculator can support a payment assumption, but it cannot determine every contractual charge or future change. Use the provider's actual schedule for the final comparison.

A new machine may require a deposit, delivery payment, installation, training and a cash reserve. A new location may begin paying rent before it opens. Put those items on the calendar according to the actual commitments. Financing the purchase price without modeling the time until productive use can create a cash gap immediately after closing.

Keep the existing business in the forecast while the project is being implemented. It still needs payroll, inventory and customer service. If staff move to the new project, identify any effect on existing collections or production. The project should be tested as a change to the whole business, not as a separate optimistic plan that assumes ordinary operations continue without additional costs.

A cash cushion should reflect the company's payment commitments and uncertainty, not a rounded number that looks comfortable. Record the reason for the chosen floor. It might protect a payroll cycle, a major supplier payment or the operating period required to respond to a delayed collection. The appropriate amount depends on the business and should be discussed with its financial advisers.

Show both the lowest projected balance and the date it occurs. An ending balance above the reserve floor does not prove every earlier week is safe. If the model falls below the floor, identify which assumption produces the breach. A reserve warning is more useful when it leads to a concrete decision about project timing, financing structure or collections.

Begin with a slower-collection case. Move a specified customer receipt later while retaining committed payments. Then test a cost increase, an opening delay or a lower sales outcome independently. Changing one assumption at a time makes it easier to explain which risk matters. Keep the original case so the team can compare the changes without rebuilding the model from memory.

After understanding individual risks, test a combined downside case that is plausible for the business. A delayed opening and delayed collections may occur together. Do not describe an arbitrary extreme scenario as a forecast. Record why the assumptions were selected and what evidence would cause the business to update them. The purpose is to prepare, not to create a falsely precise prediction.

An unused credit limit is not cash in the bank. Show an assumed draw only when it is expected to be available under the agreement. Then record the resulting repayment obligations and any effect on remaining availability. A limit subject to receivables eligibility can shrink when customer payments deteriorate, so the downside model should not automatically assume the maximum draw remains accessible.

For invoice financing, distinguish the customer receivable from the advance and any reserve release. Count the usable cash flows according to the settlement process. Including the full invoice as a customer receipt and the full advance as an additional independent receipt would overstate cash. Reconcile the financing account so fees and settlement adjustments do not disappear between the ledger and the forecast.

When the forecast identifies a cash shortage, list actions with dates and owners. Possibilities may include collecting a verified overdue invoice, staging an uncommitted purchase, renegotiating a supplier date or reducing a project scope. Confirm that the action is permitted and realistic. A future refinancing or unapproved line of credit should not be treated as committed cash.

Compare the consequence of each action. Delaying inventory can affect delivery; reducing staff hours can affect service; postponing maintenance can create downtime. A forecast helps the business see those tradeoffs, but it does not choose the correct action automatically. Preserve the operating decision alongside the revised cash case so the model reflects what the team actually plans to do.

At a regular interval, replace completed weeks with actual receipts and payments. Compare the result with the original expectation. Separate timing differences from permanent changes in amount. An invoice paid a week later is different from an invoice partly credited or never collected. That distinction improves future assumptions and prevents the forecast from rolling the same unsupported receipt forward indefinitely.

Keep a short explanation of material differences. The goal is to learn which customers, costs or project steps require better evidence. Repeatedly missing the same assumption is a signal to change the model, not merely the date. A useful forecast becomes more credible as actual outcomes improve the next version's collection and payment assumptions.

Give each version a date and record who updated it. Preserve the source invoices, bank activity, debt schedule and project budget behind major assumptions. Another person should be able to identify the reason for a large receipt or payment without asking the model's creator to reconstruct the decision. This is especially helpful when accounting, operations and ownership share responsibility.

Limit access to private records and use the provider's verified submission route if the forecast is shared for a financing request. A public calculator can help organize an example, but personal or customer account details do not belong in an unverified form. The journal's cash-flow planner runs the entered assumptions in the browser and offers a CSV for your own review.

Model each proposed financing structure against the same operating case. A term loan may produce a predictable payment while a revolving facility may fit repeated short gaps. A larger advance can reduce the immediate low point but create a less comfortable repayment schedule later. Compare the whole timeline rather than selecting the option with the highest initial deposit.

Ask the provider for clarification when the agreement and the model use different terms or dates. Keep the question unresolved until the relevant obligation is understood. A forecast that depends on an assumed grace period or fee exemption should not be treated as complete without written support. The most useful output is a clear decision record, not an impressive spreadsheet alone.

Use the forecast before committing to a project, then maintain it after funding. Compare spending with the original purpose and adjust for actual implementation progress. Keep the initial version so the business can see whether financing solved the intended cash problem. If a temporary gap becomes permanent, revisit margins, customer terms and fixed obligations instead of automatically expanding borrowing.

This guide supplies a planning method and hypothetical arithmetic. It does not establish lender eligibility, replace accounting advice or predict future collections. Use the linked financing checklist, working-capital guide and calculator to document the assumptions. A forecast is strongest when its numbers can be traced to the company's own evidence and revised before a payment problem becomes urgent.

When actual cash falls below the forecast, identify the cause before changing every later week. Separate a customer delay, an omitted payment, a sales shortfall, and an assumption that was wrong from the start. A delayed collection may move to a later week; a lost sale should not automatically reappear as a future receipt.

Keep a short variance log with the original amount, actual amount, explanation, and revised expectation. This helps the next reviewer distinguish a correction from a new business assumption. Update the forecast from the bank balance and known obligations so an old error does not carry forward unnoticed.

Review the minimum cash cushion after the correction. If the change creates a shortfall, record the decision needed, who owns it, and when it must be resolved. Do not enter prospective financing as received cash until its availability and timing are supported. The forecast should expose an unresolved gap rather than hide it behind an optimistic balancing entry.