Small Business Cash Flow Forecast: A Weekly Worked Example

Published by MyBreakeven. Report a calculation or content issue to support@mybreakeven.com.

Published October 6, 2026 · Updated October 6, 2026

Build a weekly cash flow forecast from opening cash, receipts and payments. Test late invoices, find the deepest shortfall and compare operating profit.

Agency · Small Business Cash Flow Forecast

A small-business cash flow forecast puts expected receipts and payments on the dates they reach your bank. Starting cash plus incoming cash minus outgoing cash gives the next balance. A positive monthly profit figure cannot tell you whether Tuesday's payroll can be paid before Friday's customer receipt arrives.

Below, a studio finishes four weeks with $2,000 cash, yet a delayed customer payment creates a $2,700 shortfall in week three. The fictional USD schedule shows how to spot that problem early and keep payment timing separate from operating profitability.

Quick answer

Begin with reconciled available cash, list expected receipts by collection date and payments by due date, and calculate each week's closing balance. Carry that balance into the next week. Test a major receipt arriving late and identify the lowest balance. Use a separate contribution calculation to check whether the underlying sales model covers operating costs and owner pay.

Start with the cash you can actually use

Use the reconciled opening balance for the accounts included in your forecast. An unpaid invoice is not opening cash. Neither is an unapproved financing application or money you have deliberately excluded from operating use.

Write the forecast start date, currency and included accounts at the top. If several accounts are combined, a transfer between them is not new business income. If you forecast only one account, show transfers explicitly and label them so they do not look like customer sales.

Next, separate confirmed receipts from estimates. A signed booking, sent invoice and informal inquiry carry different collection uncertainty. For each material receipt, record the customer, expected collection date, amount and reason for that date. Use payment history when available instead of automatically assigning every invoice to its issue date.

Enter outgoings on their expected payment dates: suppliers, payroll, rent, software, equipment and owner withdrawals. Add any obligations applicable to your business with advice from the relevant professional where needed. This example excludes tax, lending and legal calculations; it is a basic operating-payment schedule.

The Australian government's cash flow statement guidance sets out the opening-plus-incoming-minus-outgoing balance method. Its template is useful for the mechanics; the examples here are independent hypothetical business figures, not country-specific compliance instructions.

Build a four-week forecast

The studio starts with $2,500 available cash. Its expected customer receipts total $6,000 and scheduled payments total $6,500. These are actual assumed cash movements for the four-week window, not an average month created from annual sales.

Week two closes at $700 + $4,000 − $1,600 = $3,100. The overall reconciliation is $2,500 + $6,000 − $6,500 = $2,000. The lowest week-end balance is $700, which occurs in week one.

A weekly closing balance can still hide an intraweek shortage. If the $4,000 receipt arrives on Friday while $1,600 is due on Monday, week two initially has only $700 available. Use dated daily rows around that low point rather than assuming the week-end balance resolves every payment.

Name the obligations behind any buffer you choose. A $1,000 minimum balance would be breached in week one even though no week closes below zero. That buffer is a chosen planning rule, not a universal safe-cash recommendation.

Move one receipt and check the low point

Suppose the $4,000 receipt expected in week two arrives in week four instead. Nothing else changes, and the other $2,000 receipt still arrives in week four.

The final cash balance is unchanged, but the forecast fails before the receipt arrives. A negative forecast value means a payment cannot be funded from the included cash under those dates. It is a warning to resolve, not permission to assume the bank will cover it.

In this schedule, cumulative payments before the week-four receipts reach $5,200. Starting with $5,200 instead of $2,500 would keep the week-end minimum at zero, an additional $2,700. An intentionally positive buffer would be added on top, and daily timing could change the amount.

Do not add the negative week-two and week-three balances together. They are successive balances that already carry earlier shortages forward. Summing them would count part of the same gap twice.

Possible operational responses include following up on the receipt, agreeing a staged payment before future work starts, or discussing payment timing with a supplier. Enter only changes that have actually been agreed into the confirmed forecast. Keep hoped-for changes in a separate scenario.

Compare that schedule with monthly profit

For a separate monthly operating model, suppose the studio sells three $2,000 client-months. Each needs $500 direct labor, $100 other variable expenses and a 3% payment fee. There is no acquisition cost in this illustrative existing-client scenario.

Contribution per client-month is $2,000 × 0.97 − $600 = $1,340. Three contribute $4,020. Monthly overhead is $1,500 and owner pay is $2,500, leaving $20 after owner pay.

The four-week cash schedule assumes those same $6,000 customer collections and $5,980 operating outgoings, plus a one-off $520 equipment payment, totaling $6,500. That equipment cash event is kept outside this simplified operating-profit comparison. An accountant may treat equipment expenses differently in formal financial statements.

The monthly calculator uses 52 ÷ 12 weeks for capacity; the four-week forecast is a specific dated window. Do not pretend those periods are identical. Use them for their different questions: operating unit economics and actual payment dates.

The existing cash-flow and profit break-even guide explains the conceptual distinction. This article supplies a practical rolling schedule and delayed-receipt test instead of repeating that comparison.

Test lower receipts and a new purchase

If one $2,000 receipt moves beyond the four-week horizon, total receipts fall to $4,000 within the forecast. With unchanged payments, closing cash becomes $2,500 + $4,000 − $6,500 = $0. Its placement within the weeks determines whether an earlier shortage occurs.

If customer receipts stay at $6,000 but you buy another $1,000 of equipment in week three, the base schedule's week-three close falls from $1,300 to $300. Week four finishes at $1,000. The purchase does not become affordable simply because the sales forecast looks healthy.

For each scenario, record the changed assumption, first affected date, lowest balance and proposed action. Keep the base schedule unchanged so you can see what the scenario actually changed. A sales forecast, payment schedule and expense budget should remain reconcilable.

How to run your own numbers

Use the agency break-even calculator for the separate operating example: price $2,000, materials $0, labor $500, other variable costs $100, acquisition $0 and fees 3%. Enter overhead $1,500, owner pay $2,500 and no additional profit goal. The result needs three whole client-months to cover that requirement.

For a capacity illustration, enter one worker, 35 weekly hours, 70% utilization and 25 delivery hours per client-month; four whole client-months fit. This is not a bank-balance forecast. Keep the weekly schedule separately, and use the target-profit guide and fixed versus variable costs guide to check its operating assumptions. Other currencies are supported.

Review the forecast against actuals

At the end of each week, replace estimates with actual receipts and payments. Reconcile the resulting balance to the included accounts, then add another week to the horizon. Keep a note of large differences rather than silently rewriting history.

If a customer repeatedly pays later than planned, move their future expected collection date based on that record. If a payment amount changes, keep its original estimate available for comparison. The forecast becomes more useful as those assumptions improve.

Common mistakes

• Putting invoice issue dates in the receipt column.
• Treating transfers between included accounts as customer income.
• Adding successive negative balances instead of finding the lowest one.
• Ignoring payment order inside a low-cash week.
• Omitting owner withdrawals because they are outside a formal expense category.
• Using a profitable monthly total as proof that every payment date is funded.

FAQs

Is a forecast the same as a record of past cash flow?

No, a forecast uses expected future receipts and payments. Replace those estimates with actuals as dates pass. Keep a clear boundary between observed transactions and assumptions.

Should I forecast weekly or monthly?

Weekly rows reveal timing problems that monthly totals can hide. Use daily rows around payroll, supplier payments or a large uncertain receipt. Choose a horizon that covers the commitments you need to manage.

Does a negative balance mean the business is unprofitable?

It means the scheduled payments are not funded from the included cash at that point. Delayed collections can cause it even with positive operating profit. Check contribution and timing separately.

Why is the extra reserve $2,700 rather than $3,600?

The week-three balance already includes the week-two shortage. The additional amount needed is the deepest cumulative shortfall, $2,700. Adding both negative balances counts part of the same shortage twice.

Can I use MyBreakeven to forecast my bank account?

The calculator models monthly contribution, sales requirements and delivery capacity. It does not place invoices and payments on calendar dates. Use a dated cash schedule alongside it.

How much cash buffer should I keep?

Choose it from your obligations, payment uncertainty and acceptable risk, rather than a generic figure. Test late receipts and named unexpected payments. Professional advice can help when financing or other consequential commitments are involved.

Takeaways

• Forecast collection dates and payment dates separately.
• Reconcile opening cash and carry each closing balance forward.
• Find the deepest shortage instead of summing negative balances.
• Check operating profitability with a separate monthly model.

Browse the small-business planning library for related explanations.