An operational description of a weekly cash routine: which four numbers, where each comes from, and what to do when one moves - with no financial advice.
Key takeaways
- The problem is not missing data but data arriving late.
- Four numbers are enough; more than that will not be collected weekly.
- The most important number is what is due in, not what came in.
- The routine is worth something only when somebody reads it at a fixed time.
An operational description, not advice. What is financially right for your business is settled with your accountant or a financial adviser. What follows is the routine only: which numbers to collect each week, from where, and who looks at them - so that nothing is discovered late.
Most small businesses see the cash picture once a month, when the report arrives. Four numbers collected in ten minutes a week bring that picture forward by three weeks.
The four numbers
| The number | Where from | What it tells you |
|---|---|---|
| Bank balance today | The bank | The starting point |
| What is due in by month end | Open invoices | The forecast, and what depends on collection |
| What is due out by month end | Suppliers, payroll, fixed costs | The obligations |
| Debt over 30 days | Bookkeeping | The risk inside the forecast |
The fourth row is what makes the forecast realistic: an invoice open for 45 days is not money arriving this month, and flagging it separately prevents planning on an amount that will not come.
Why weekly rather than monthly
Because a month is too late to correct. Discovering at month end that collections slipped leaves no time to act; seeing it in the second week means you can send reminders, defer a purchase, or talk to a supplier.
What matters is that this is not extra work but reading: the numbers already exist in your systems, and all that is required is copying four of them into a standing spreadsheet. Ten minutes a week, at the same time, produces a picture available no other way.
Who collects and who reads
Ideally two different people, where possible. Whoever collects has system access; whoever reads can decide. When it is the same person - and in most small businesses it is - at least set separate times for collecting and reading, because otherwise collecting becomes a mechanical act nobody draws a conclusion from.
What helps is keeping the four numbers in one spreadsheet with a row per week. The value is not in any single week but in the trend: a balance falling four weeks in a row says something no single week says.
What to do when something moves
Not every fluctuation needs action. What does need it is three situations: debt over 30 days growing two weeks running; the expected inflow falling meaningfully below what is due out; and a balance declining steadily with no one-off event behind it.
In all three the first action is operational rather than financial: check what happened in collections, check which invoices did not go out on time, and check whether something in the process is stuck. The full collections routine is in a collections routine that works.
What does not belong in this routine
- Profitability - measured monthly, not weekly.
- Cost analysis - a different discussion.
- Long-range forecasts - this routine looks to month end.
- Financing decisions - those are discussed with your accountant, not in a weekly sheet.
That separation is what keeps the routine short. The moment it becomes a full financial discussion it gets postponed - and then you are back to seeing the picture once a month.
What it looks like after two months
Eight rows in a spreadsheet, and patterns are already visible: which week of the month most money arrives, when outflows concentrate, and how long genuinely passes between invoice and receipt. Those three patterns change operational decisions - when to order from a supplier, when to send reminders, and when not to commit to a large expense.
That is also what makes the routine worthwhile: it is not there to produce a report but to bring knowledge forward. In many businesses, the gap between knowing in week two and knowing at month end is exactly the gap between a decision and a reaction.
How do you start when you have never done this?
Not with perfect collection. In week one record whatever is easy to obtain - usually the bank balance and the list of open invoices - and add one number each week. After a month all four are collected in ten minutes, and by then it is a habit.
What usually defeats it is not the time but the location: a spreadsheet saved somewhere you have to go looking for does not get opened. Put it where you already look every morning, and fix a day and time - usually Monday or Tuesday morning, once the weekend's receipts have been recorded.
There is value in the recording itself: many businesses discover in the first fortnight that some invoices they assumed had gone out had not. That is an operational discovery rather than a financial one, and it alone justifies the routine.
What this routine reveals that you did not know
Usually three things. How long genuinely passes from invoice to payment - that number is nearly always longer than the estimate, and it changes planning. Which customers consistently pay late - recorded across three months, that becomes a fact rather than an impression. And when the large outflows occur - seen in one row, it turns out they concentrate in a particular week of the month.
The third changes operational decisions immediately: you can move purchase dates, ask a supplier to change a billing date, or simply know which week not to commit. None of those three changes requires anything but knowing - which is exactly what the routine provides, at the cost of ten minutes a week.
After a quarter there are thirteen rows, and one more pattern becomes visible: whether the gap between what was forecast and what actually arrived stays constant. When it does, adjust the forecast rather than being surprised monthly - a correction of an assumption rather than a financial change, and it is what makes the second number usable for planning.
Sources
Frequently asked questions
Do we need a system for this?
No. A spreadsheet with four columns and a row per week is entirely sufficient, and often better - it is easy to update and you can see a whole year on one screen. A system is justified when the data is scattered across several places and copying takes real time.
What if a number is unavailable?
Record what you have and flag what is missing. A routine waiting for perfect data does not happen, and three correct numbers out of four beat nothing. What matters is keeping the same method every week, so the comparison holds.
Does this replace an accountant?
No, and it is not meant to. This is an operational routine showing what is happening now; financial reporting and analysis are entirely separate work, and questions of tax, financing and profitability belong there rather than in a weekly sheet.
Who should see these numbers?
Whoever makes decisions affected by them - usually the owner, and sometimes whoever is responsible for purchasing or collections. What to avoid is wide distribution: cash figures circulating without context produce worry rather than action.
Keep reading
Related service
MVP Development
Turn an idea into a validated product in weeks, not months.
About the author
Yehonatan Saadia
Freelance automation, web & MVP developer
I'm Yehonatan Saadia, a senior developer who builds business automation, custom websites, and MVPs for small and mid-sized companies across the US, Europe, and Israel. These guides come from real client work, not theory.
Work with meHave a project like this?
Tell me what you're trying to automate or build and I'll tell you the fastest reliable way to ship it.