Weekly Cash Flow Forecast: A Practical Four-Week Model

Profit does not answer the question: will there be enough cash this week?

A business can sell well and show a profit in its records yet run short of cash. Some sales are on credit, while rent, staff wages and supplier payments fall due before customers pay. A healthy bank balance today may also be committed to upcoming obligations. A weekly cash flow forecast puts these dates on a timeline: what is available at the start, what is expected to come in, what must be paid and what should remain at the end.

A forecast is neither a promise nor a profit and loss statement. It is the best estimate available when prepared, and it should change as new information arrives. Its main purpose is to reveal a potentially difficult week before it happens, giving the owner time to organize collections, negotiate payment timing or responsibly postpone an unnecessary purchase.

Define the scope before entering figures

Start with four to twelve weeks, depending on the pace of your business, and use more detail for the nearest weeks. In a four-week model, specify each week's start and end dates, the currencies and accounts included, and whether cash, bank and wallet balances will be combined or shown separately before being brought into a summary.

Keep currencies separate wherever possible. Money in one currency cannot automatically meet an obligation in another without a documented exchange, its cost and its timing. Also separate restricted or earmarked funds that you cannot freely spend. Write down your assumptions: when each customer will pay, when each supplier must be paid and the minimum cash reserve you want for emergencies.

The structure of a weekly model

Each week has five main lines:

1. Available cash at the start of the week.
2. Expected cash receipts during the week.
3. Total cash available after receipts.
4. Expected payments during the week.
5. Expected closing balance, which becomes the next week's opening balance.

Receipts can be divided into cash sales, customer collections, other confirmed income, and documented financing or transfers. Payments can be split into suppliers, wages, rent, operating costs, applicable taxes or fees, asset purchases and financing repayments. Do not enter a noncash transaction as cash flow. A transfer between two cash accounts inside the business must not become new income and a new expense in the consolidated total.

Start with an opening balance you can reconcile

Count physical cash and reconcile bank and wallet balances against dated statements or balance records. Deduct unavailable funds and account for pending transactions according to their timing. If you start with a guessed figure, that error carries into every week, making decisions look precise while resting on the wrong foundation.

Record the time at which you established the opening balance. A transfer made after that snapshot belongs among later movements; it must not appear in both the opening figure and the week's receipts. Investigate any difference rather than hiding it in an unsupported adjustment.

Estimate collections from the customer, not just the invoice

An invoice being due does not guarantee cash on that date. Review the customer's payment behavior, any payment promise, disputes or missing documents, and the outstanding amount. Classify collections as highly likely, probable or uncertain. Your base scenario can use probable receipts, with a cautious scenario excluding amounts that lack clear confirmation.

Do not put every outstanding customer balance into the first week simply because it is overdue. Assign each receipt to a realistic week, with a customer name or reference and someone responsible for following up. If payment is delayed, move it to the new week with a note instead of leaving it in the past and displaying cash that never arrived.

Estimate cash sales cautiously

Use average results from comparable periods, adjusted for seasonality, closing days and known orders. Do not base your forecast on the best trading day of the month. Separate new cash sales from collections of old debts: both bring in cash, but their meaning and what makes them repeatable are different.

If business is volatile, analyze a low, base and high range rather than relying on one figure. Use the low scenario to test whether critical obligations can be met. Do not use the high scenario to justify a purchase that could wait.

Group payments by due date and priority

Start with actual contracts, invoices and schedules rather than a general percentage of sales. Record each supplier, amount, currency and due date, then add wages, rent, utilities, transport, maintenance and recurring obligations. Keep a planned but unapproved order separate from an invoice already due. Both matter, but the room for changing them is different.

Classify payments as critical, negotiable, or discretionary and flexible in timing. This does not mean ignoring a supplier's rights or changing a date unilaterally. The aim is to know where early communication should begin if a shortfall appears, and to document any new agreement.

A worked four-week example

Suppose a shop starts with 600,000 in available cash. All figures below use one currency and exclude unconfirmed transfers.

Week one

• Opening balance: 600,000.
• Expected cash sales: 250,000.
• Probable customer collections: 180,000.
• Supplier payments: 420,000.
• Operating costs and part of the wages: 160,000.
• Closing balance: 450,000.

The calculation is 600,000 plus 430,000 of receipts minus 580,000 of payments. The resulting 450,000 becomes week two's opening balance.

Week two

• Opening balance: 450,000.
• Expected receipts: 390,000.
• Rent, supplier payments and operating costs: 620,000.
• Closing balance: 220,000.

Week three

• Opening balance: 220,000.
• Expected receipts: 310,000.
• Expected payments: 570,000.
• Closing balance: negative 40,000.

Week four

• The theoretical opening position is a 40,000 shortfall.
• Expected receipts: 500,000.
• Expected payments: 300,000.
• Closing balance: 160,000.

The issue is not whether the month ends positive. In week three, the shop cannot make every payment on time. Discovering this two weeks ahead creates time to review a specific collection, split a new purchase or negotiate a payment date in advance. Do not simply move a receipt from week four to week three in the spreadsheet unless a realistic action changes when the money will arrive.

Test three scenarios

Use the most likely dates in your base scenario. In the cautious scenario, delay uncertain collections and reduce cash sales while retaining critical obligations. In the optimistic scenario, include only opportunities with a concrete basis, such as a confirmed order; never use it as the sole basis for committing payments.

Compare the lowest balance in each scenario, not just the ending balance. If the cautious case falls below zero or your safety reserve, record an action, a deadline and a responsible person. Responses might include sending statements promptly, confirming partial payments, controlling inventory purchases and reviewing expenses whose timing can change. Borrowing is a separate decision with costs, risks and terms that require appropriate evaluation; it is not an automatic balancing line.

Connect the forecast to collections and purchasing

Every collection should trace back to a customer statement, a transaction and a promise or follow-up date. Every supplier payment should relate to an invoice or agreement. The team can then move from a figure to an action: who will contact the customer, which document is missing, whether goods are needed before payment, and whether an approved return or discount applies.

Review purchase orders against the weeks showing a shortfall. A purchase might be essential stock that sells quickly and generates cash, or it might simply fill a shelf. Do not cancel it on the forecast alone. Consider lead time, current quantity, demand, margin and payment date. The forecast explains timing; inventory decisions involve additional factors.

Replace estimates with actuals each week

At the end of the week, record actual receipts and payments and calculate the differences. Keep the original forecast so you can identify which assumption was wrong. If you expected to collect 180,000 but received 100,000, identify the customers or causes and update subsequent weeks. If sales were higher, understand why before automatically increasing every future week.

Use three columns for each line: forecast, actual and variance, with a short note. After several cycles, you will recognize items that frequently differ from expectations, such as collections from a customer group or delivery costs. Improve those estimates instead of adding an arbitrary cushion to everything.

Warning signs worth noticing early

• Balances fall below the safety reserve in more than one scenario.
• A week depends on one customer or an unconfirmed transaction.
• A supplier payment repeatedly moves into the following week without agreement.
• Inventory buying increases while collections slow.
• Credit sales grow faster than incoming cash.
• The closing balance looks positive because recurring payments were omitted.
• Different currencies are treated as immediately interchangeable.

A twenty-minute weekly cash meeting

Start by reconciling the balance and reviewing the previous week's variance. Then examine the three largest expected receipts and payments, and the week with the lowest forecast balance. Make specific decisions: contact a customer, confirm a supplier date, review a purchase order or approve an expense. Finish by updating the person responsible and the deadline.

Set up your first model

1. Define four weeks, their dates, the currencies and the accounts included.
2. Reconcile available cash and exclude restricted funds.
3. Enter customer collections with realistic dates and confidence levels.
4. Estimate cash sales using comparable periods.
5. Place every known obligation in the week it falls due.
6. Separate critical, negotiable and planned payments.
7. Calculate each closing balance and carry it into the next week.
8. Create a cautious scenario and identify its lowest balance.
9. Assign actions for any shortfall before it occurs.
10. Update actuals and variances at a fixed time every week.

Common mistakes

• Treating issued invoices as incoming cash.
• Putting every overdue debt into the first week's collections.
• Forgetting a quarterly payment or seasonal expense.
• Counting an internal transfer as new income and a new expense.
• Combining currencies without a workable exchange plan.
• Editing the original forecast to match actuals and losing the opportunity to learn.
• Focusing on month-end while ignoring a midmonth shortfall.
• Using the best scenario to approve fixed commitments.

Frequently asked questions

Is a cash forecast the same as a budget?

No. It is a timeline of expected money coming in and going out. Budgets and financial reports serve other purposes and use different definitions. These tools can complement one another, but they are not interchangeable.

How many weeks do I need?

Four weeks is a practical starting point for a small business. You can later extend it to twelve or thirteen weeks. Keep near-term detail precise and longer-term estimates easy to revise.

What should I do with an uncertain collection?

Put it in a separate scenario or delay it in the cautious forecast, and attach a follow-up action. Do not make a critical commitment depend on that receipt alone.

Should I include an inventory purchase I have not approved?

Show it separately as a planned item so you can see its effect. Do not mix it with invoices already payable. This keeps the decision open until approval.

Why does the forecast keep differing from reality?

It is an estimate, but the differences should improve the model. Investigate causes and update assumptions instead of expecting perfect agreement or abandoning the forecast at the first variance.

Bring timing into your decisions

A weekly cash flow forecast connects decisions to dates. Begin with a reconciled balance, estimate collections realistically, put payments in their due weeks and compare the lowest balance across base and cautious scenarios. Update forecasts with actuals, retain the differences and link every amount to a person and an action. This habit gives a business time to communicate and adjust purchases and payments before a cash deadline is missed.