A busy week can still leave a restaurant short of cash. Sales may settle later, supplier invoices may fall due together, and an equipment payment can arrive before the next collection. The useful question is whether usable money will be available when each obligation must be paid.
Build a short rolling forecast from the actual bank, till, settlement and payment records. The four-week example below is an original teaching model in INR. It is not a demand forecast, a recommended cash reserve or an assumption that credit will be available.
Start with a reconciled cash position
Choose one review date and a clear boundary: which business bank accounts and cash holdings are included? Reconcile the opening figure to those records, allowing for recorded payments and pending movements so you do not spend the same balance twice. Distinguish funds you can use from restricted or otherwise committed amounts.
A transfer between two included business accounts is not a new receipt or an operating payment for the combined forecast. Likewise, depositing till cash into an included bank account moves money inside the same pool. Count the customer receipt once, when it enters the business's forecast boundary.
Keep the cash forecast separate from the profit report. A credit sale may create revenue before cash arrives. Buying equipment uses cash even when its accounting expense is recognised over time. Loan proceeds increase cash without being sales, while principal repayments use cash without being an operating expense. Have accounts confirm classifications; this worksheet is a management forecast, not statutory reporting.
Put receipts in the week they are expected to clear
List cash and digital collections by expected availability, using current settlement evidence and agreed customer payment dates. For an event or institutional invoice, track the invoice reference, amount due, expected receipt date, evidence and owner. An optimistic promise is less reliable than a confirmed settlement record.
Choose a consistent way to handle channel deductions. If the forecast uses the net amount expected to reach the bank, do not subtract the same fee again as an outflow. If it uses gross receipts and separate charges, make both entries reconcile to settlement. Record refunds, withheld amounts and disputed settlements explicitly.
Separate confirmed receipts from assumptions and show doubtful timing as a scenario. Do not quietly include an unapproved loan or owner injection to make the balance positive. The workbook provides a separate committed-funding line; any such entry needs an identified source, amount, availability date and approval.
Build payments from commitments, not averages
Use actual due dates for suppliers, payroll, rent, utilities, applicable taxes and other obligations. Include equipment deposits, instalments, debt repayments and owner withdrawals separately. Ask the responsible adviser or accounts team for the correct tax amounts and deadlines rather than inventing them in a general template.
A monthly average can hide a payment cluster. Split a large obligation into its real scheduled dates if the agreement permits that structure. Do not assume a supplier will accept a late payment simply because the forecast has a gap. Any changed term needs a recorded agreement.
Enter zero when a category has no payment in a week, and mark an unknown amount or date as unresolved. A blank cell must not make a real obligation disappear. Keep supporting invoice or agreement references in a payment register so the forecast can be checked quickly.
Read the four-week picture
In this invented example, usable opening cash is INR 60,000 and there is no financing or owner injection. The table groups the operating payments for readability. Week one includes a rent payment; week two includes an illustrative tax payment whose amount and timing are invented. Week three includes a separate INR 60,000 equipment payment.
Closing cash equals opening cash plus receipts less payments. Each week's closing figure becomes the next week's opening. The baseline ends week three at zero, even though the four weeks together finish with INR 20,000. Looking only at the final balance would miss the tighter point.
The owner has chosen an illustrative review floor of INR 20,000 for this exercise. It is a planning threshold, not a universal reserve requirement. Week three is INR 20,000 below that floor. A zero closing balance also provides no room for an unplanned payment, so the timing needs attention before that week begins.
| Illustrative INR | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening usable cash | 60,000 | 40,000 | 40,000 | 0 |
| Operating receipts | 90,000 | 85,000 | 100,000 | 95,000 |
| Operating and tax payments | 110,000 | 85,000 | 80,000 | 75,000 |
| Equipment payment | 0 | 0 | 60,000 | 0 |
| Closing cash | 40,000 | 40,000 | 0 | 20,000 |
Test timing without changing the total
Suppose INR 20,000 of the week-three receipts arrives in week four instead. Week-three receipts become INR 80,000 and week-four receipts become INR 115,000. The projected week-three closing position falls to minus INR 20,000, while the final week still closes at INR 20,000. The same total receipts create a different funding problem because their timing changed.
A negative forecast balance represents a gap to resolve. It does not mean the bank will provide an overdraft or that payments can proceed without available funds. Investigate the expected receipt, the payment dates and the operational consequences with the relevant owner.
Separately, consider what happens if the equipment supplier expressly agrees to move the INR 60,000 payment from week three to week four. Under the original receipt timing, week three closes at INR 60,000 and week four still closes at INR 20,000. This is a scenario to discuss, not permission to delay the payment. Preserve the original baseline and record any approved change before using it in the live plan.
Check inside the week when cash is tight
A positive Friday balance does not prove that Tuesday's payroll can be paid. If a large receipt arrives after the payment it is meant to fund, break that week into daily cash movements. Use actual availability dates and include the relevant bank or settlement timing. Do not net two movements merely because they happen in the same week.
Consider actions within the business's control: verify overdue receipts, correct settlement errors, phase a discretionary purchase through an agreed arrangement, or adjust unnecessary buying while preserving service and food controls. Evaluate the consequence of each action. Do not treat withholding wages, ignoring obligations or using restricted funds as a default solution.
If funding is required, record only an approved and available facility in the committed plan, including its cash costs and repayment dates. The forecast can identify the amount and timing of a gap; it does not determine which financing arrangement is suitable.
Roll the forecast forward and learn from the difference
At each weekly review, replace the completed week's forecast with reconciled actual receipts and payments, investigate differences, and add the next week. Keep the previous forecast version so a timing change can be distinguished from a missing expense, weaker sales or a recording error.
Assign each material uncertainty to a person and a review date. A useful action record states the amount, original date, revised expectation, evidence and next step. Record whether a change has been proposed, agreed or actually received or paid.
Open Weekly Cash Flow to build the four-week bridge, define a review floor and record receipt and payment evidence. The linked opening balances expose how one missing input or timing change affects later weeks. Expand the horizon when commitments extend beyond four weeks, and use a daily view for any period where the order of movements matters.
Put it into practice
Your action checklist
Your progress saves in this browser. No sign-up needed.
0 of 8 complete
From reading to doing
Weekly cash flow and action register
Open Weekly Cash Flow. Reconcile opening usable cash, enter explicit receipt and payment amounts by week, define the review floor and record the evidence behind uncertain dates. Test the delayed receipt and agreed-payment scenarios separately before restoring your baseline.
Open the Weekly Cash Flow tab in the launch workbook. Keep a copy for your own business.
Download the free workbook See what’s inside the toolkit →Sources & further reading
- US Small Business Administration: Manage your finances ↗
Retrieved 7 November 2026. General context on bookkeeping, cash availability, receivables, payables and the difference between a sale and its receipt. US accounting and tax rules are not applied here. The four-week forecast, review floor and timing scenarios are original illustrations.
Published by Keystonne Grow. Product links connect to the Keystonne ecosystem; check the linked product or service for its current scope.
