Use actual dates, not just monthly totals
Start with the opening bank balance. Then list expected customer collections by the week you realistically expect to receive them, not the week you issue the invoice. List payroll, rent, supplier payments, tax payments, loan instalments and owner drawings by their expected payment dates.
Keep the sheet small and updated
For each of 13 weeks, show opening cash, inflows, outflows and closing cash. Add a short note beside uncertain receipts. Update it weekly using the latest bank balance and receivables information. The objective is decision support, not a complicated finance model.
Turn a warning into an action
When a projected closing balance falls below your cushion, identify the levers: follow up on a due invoice, stagger a discretionary purchase, negotiate a supplier date, reduce an offer, or discuss finance before an emergency. Do not silently move expected collections earlier merely to make the sheet look comfortable.
Link cash flow to break-even
Break-even tells you the sales level that covers selected fixed costs. The cash forecast shows the timing of money moving through the bank. Use both together: improve economics with pricing and cost decisions, then protect the near-term payment schedule.
Sources and further reading
General business-planning information only; use professional advice for funding and financial decisions.