What it means
The structure is always the same: opening balance, receipts, payments, closing balance, with the closing balance of one period becoming the opening balance of the next. That rolling link is what makes the schedule useful, because it shows not just whether a period is positive but where the cumulative low point falls.
Its business value comes from the specificity. A schedule forces someone to decide which customers will actually pay in week three and which supplier invoices will actually be settled, which is a very different exercise from assuming an average month.
Receipts are usually built from the sales ledger by applying expected payment behaviour to each invoice, while payments come from the purchase ledger, payroll calendar, tax due dates and any planned capital spending. Recurring items such as rent and loan instalments are entered on their exact dates rather than spread evenly.
The professional standard for short term work is the rolling thirteen week schedule, which is rebuilt every week so that the horizon stays constant. Each rebuild compares last week's forecast with what actually happened, and those variances are usually more instructive than the forecast itself.
One nuance is that a schedule is not a budget. The budget answers what the business should earn and spend, while the schedule answers when the money physically moves, and the same transaction can appear in very different periods in the two documents.
In practice
Real-world examples.
Example
A civil engineering firm builds a schedule by project milestone rather than by month. It shows a $700,000 dip in week seven when two subcontractor payments land before a client certification, so the firm asks for the certification to be brought forward.
Example
A veterinary group schedules its cash by clinic and finds that one site consistently pays suppliers a week before its own card receipts clear. Changing the payment run day for that site alone removes a recurring mid month squeeze.
Example
A clothing brand adds its seasonal stock purchases to a twelve month schedule and sees the balance turning negative in September for the first time. The schedule gives it six months to arrange a facility rather than six days.
Think of it
“Cash flow schedule is your detailed calendar of cash movements-when money comes in and goes out.
Formula
Calculation
Closing cash balance = opening cash balance + total receipts - total payments
A commercial florist prepares a two week schedule. Week one opens with $150,000 in the bank, expects receipts of $320,000 from event clients and faces payments of $410,000 covering payroll, a quarterly tax bill and flower purchases.
Week one closing balance = $150,000 + $320,000 - $410,000 = $60,000. Week two opens with that $60,000, expects $380,000 of receipts and $300,000 of payments, giving a closing balance of $60,000 + $380,000 - $300,000 = $140,000, so the low point of the fortnight is the $60,000 at the end of week one.Case study
Seen in the real world.
This is an illustrative and fictional example. Kestrel Event Florists, an invented business supplying corporate events, had never built a cash schedule and relied on the owner checking the bank app each morning. Payroll had been paid late twice in a year, both times because a large tax payment landed in the same week as a supplier settlement run.
The fictional bookkeeper introduced a simple two week rolling schedule. It showed a fortnight opening at $150,000, dipping to $60,000 after week one's $320,000 of receipts and $410,000 of payments, and recovering to $140,000 by the end of week two once a further $380,000 came in.
Seeing the low point in advance let Kestrel move a $90,000 flower purchase from a Thursday to the following Monday, which cost nothing and lifted the trough comfortably clear of the payroll run. In this illustrative case the schedule was never sophisticated, but building it every Friday morning changed the business from reactive to planned.
Watch out
Common mistakes.
- Spreading lumpy items such as tax, insurance and bonuses evenly across the year instead of putting them on the dates they are actually paid.
- Using invoice dates for receipts, which quietly assumes every customer pays on time and typically overstates near term cash by weeks.
- Building the schedule once and never comparing it to actual cash, which removes the feedback that would make the next version more accurate.
Questions
People also ask.
How detailed should a cash flow schedule be?
Detailed enough that the largest ten or so receipts and payments in each period are named individually, with everything else grouped.
Weekly or monthly?
Weekly for the next quarter, because payroll and tax dates within a month are exactly what causes trouble, and monthly beyond that.
Who should own the schedule?
One named person in finance should build it, but the sales and buying teams must supply the expected dates, otherwise it becomes a guess dressed up as a plan.
From the founder's library
Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%