A healthy month-end balance can hide a difficult Friday
A customer payment on the last day of the month does not fund payroll two weeks earlier. Monthly totals can hide that gap. A weekly forecast makes the sequence visible: starting cash, expected receipts, planned payments, and the balance left at the end of each week.
Thirteen weeks covers roughly a quarter without pretending that every distant receipt can be predicted precisely. It is a planning horizon, not a guarantee or a substitute for daily monitoring when cash is tight. BDC offers a 13-week cash-flow template alongside a longer-term planning template. The shorter horizon supports timing decisions; the longer view addresses broader seasonality and strategy.
Start with cash movement, not projected revenue
Use the direct method for this practical planning worksheet: list the cash expected to enter and leave the business. A sale belongs in the receipt week when payment is reasonably expected, not automatically in the week the sale is booked. A purchase financed over time should reflect the actual deposit and payment schedule, not an assumed full cash purchase.
Beginning cash + cash receipts − cash payments = ending cash. The next week's beginning cash equals the previous week's ending cash. Add a separate line for the minimum cash reserve chosen for your business; do not confuse that target with spendable cash or add it to the bank balance.
Where payroll or a major settlement falls midweek, review the daily low point too. A weekly ending balance can still miss a shortfall inside the week.
A useful first worksheet needs only a few categories
The first version should be understandable enough to maintain. Add detail where it changes decisions, rather than building hundreds of lines nobody owns.
- Starting cash: confirmed balances, adjusted for known outstanding items without counting the same payment twice.
- Customer receipts: major invoices individually, and smaller recurring receipts grouped using supported assumptions.
- Payroll and related payments: actual payment dates and known obligations, coordinated with the relevant providers.
- Vendor payments: due dates, approved schedules, and separately identified discretionary purchases.
- Other commitments: rent, taxes, debt service, insurance, capital spending, and approved owner distributions.
- Funding: only supported, available sources in the base case; show unapproved borrowing separately as a scenario.
- Ending cash, reserve target, headroom or shortfall, and a note explaining each important assumption.
An example: a delayed receipt changes the decision
Hypothetical example—not a Kaxpe client result. Starting cash is $46,000. In week one, expected receipts are $30,000 and payments are $38,000, leaving $38,000. Week two has $18,000 coming in and $42,000 going out, leaving $14,000. Week three has $44,000 coming in and $28,000 going out, leaving $30,000.
If the owner has selected a $20,000 reserve target for this example, week two falls $6,000 below it despite a healthier week-three ending balance. That is a management warning, not a statement that the company is already unable to pay its bills.
Now move a $12,000 customer receipt from week two into week four. Week-two cash falls to $2,000. The issue is no longer an abstract forecast variance. It is a specific receipt whose timing can affect the payment plan. The reserve amount here is illustrative, not a recommended benchmark for every business.
Kaxpe · The example, at a glance
One late receipt changes the low point.
Compare the first three weeks of the example. Moving a $12,000 receipt from week two to week four leaves only $2,000 at the end of week two.
Ending cash · Common scale: $0–$50,000
Starting cash
Week 1
Week 2
Week 3
Test the uncomfortable scenario before committing
Keep a base case using the best-supported assumptions. Then create a downside case that changes the few items most capable of affecting cash: a major receipt arrives late, demand softens, a repair becomes necessary, or planned hiring costs begin before added revenue.
Do not treat an upside case as permission to spend. Ask which commitments remain supportable if the downside occurs. Some decisions may be staged; others may require additional evidence or a different timetable. Any changes to customer or supplier terms require agreement, not just a revised spreadsheet.
A useful scenario ends with a decision trigger: for example, revisit a discretionary purchase if a specified customer receipt is not confirmed before the approval date. The trigger should be visible before the commitment becomes difficult to reverse.
The weekly update is where the value is created
BDC recommends refreshing a rolling 13-week view at the beginning of each week in its cash-planning guidance. A practical meeting can stay focused on changes and decisions rather than reading every row aloud.
- Replace the completed week's estimates with actual cash movement.
- Explain the largest receipt and payment differences; identify timing changes versus permanent changes.
- Roll the forecast forward by adding one new week.
- Confirm major expected collections and upcoming commitments with their owners.
- Review the lowest projected cash point, the reserve gap, and concentration in a few uncertain receipts.
- Assign actions, deadlines, and the decision that follows if an assumption fails.
Five mistakes that make a forecast look safer than it is
The biggest forecasting risk is not an untidy spreadsheet. It is unsupported confidence in the inputs.
- Counting the same receipt in both an invoice list and a general sales assumption.
- Treating an invoice due date as a confirmed payment date.
- Including a hoped-for credit facility as if it were already approved and available.
- Leaving out irregular commitments such as annual insurance, tax payments, or equipment deposits.
- Repeatedly pushing overdue receipts forward without investigating the reason for delay.
Make the forecast a decision tool, not another owner chore
Start with a supported cash balance, the largest receipts, and the next few unavoidable commitments. Let the worksheet become more detailed as the business learns which assumptions matter most. Keep limitations explicit; an uncertain forecast with named risks is better than a precise-looking one built from guesses.
Kaxpe's Finance Strategy service can prepare and explain cash scenarios, while the Growth Management System connects cash visibility with the wider growth roadmap and execution priorities. Collection work and other operational support follow the scope agreed for the engagement.
Next, read why profit and cash diverge or how to turn monthly reports into decisions. The takeaway: the forecast matters because it gives you time to act—not because it claims to predict the future perfectly.
Educational information for business management, not individualized tax, legal, or investment advice or an assurance engagement. Examples labeled hypothetical are illustrations, not client results, industry benchmarks, or guarantees. Decisions should reflect your records, circumstances, and professional advice.