The weekly cash flow report: what it shows, and who prepares it

What the report contains

A weekly cash report is one table with one row per week and a short note underneath. The table runs thirteen weeks forward from today. Each row says what you expect to receive that week, what you expect to pay, and what will be in the bank when the week closes.

The receipts are named. Not "client income, week 4", but the invoices you expect to be paid that week, client by client, with the date you expect the money rather than the date printed on the invoice. The payments are named the same way: payroll, payroll taxes, rent, contractors, software, the supplier who wants paying on the fifteenth.

The note underneath is three lines long. Where the low point is, whether it moved since last week, and what you will do about it.

• Opening balance: what is in the bank today, across every account
• Receipts by week: named invoices on the date you expect the money
• Payments by week: payroll, taxes, rent, contractors and suppliers on their real dates
• Closing balance for each of the thirteen weeks
• The low point, the week it falls in, and the headroom above your bank minimum
• What changed since last week’s report, and why

Why weekly, and not monthly

A monthly report averages away the thing you need to see. Take a firm that pays salaries on the last working day of the month and invoices its clients on the first. Its balance is at its highest in the middle of the month, when the previous month’s invoices have been paid, and at its lowest the morning after payroll. A month-end figure shows the low. A mid-month figure shows the high. Neither shows how close the low comes to the line.

A monthly report also arrives late. It is built after the books close, which is days or weeks after the month it describes. By then the week that mattered is behind you.

The weekly rhythm matches the decisions an owner can still take: which invoice to chase today, whether a contractor payment can move by a week, whether to delay a start date. Those are weekly decisions, and they need a weekly view.

Thirteen weeks: the quarter ahead

Thirteen weeks is one quarter. It is far enough ahead to see a problem while there is still time to act on it, and near enough that most of the numbers are already known.

The first four to six weeks are built almost entirely from named items: invoices already issued, payroll already set, bills already received. The later weeks lean more on the pattern of the business: the billing you expect on running contracts, and the costs that repeat. That is why the report rolls. Every week the oldest week drops off, a new week is added at the far end, and the named items move forward to replace the estimates.

A forecast written once a quarter and left alone is a different thing. By week five it is describing a business that no longer exists.

The low point against the bank minimum

The single line that matters most in the report is the low point: the lowest closing balance in the thirteen weeks, and the week in which it falls.

It matters because of what it is measured against. Every company has a minimum it must keep in the bank, whether or not anyone has written it down: the next payroll, the payroll taxes that follow it, and a buffer for the bill nobody expected. Set that minimum deliberately, in money, and draw it on the report as a line. The question each week is then simple: how far above the line is the low point?

Headroom is the figure to track from week to week. A low point that sits comfortably above the minimum and stays there needs no action. A low point that drops closer every Monday is a trend, and a trend gives you weeks of warning where a single bad reading gives you days.

Receipts on the date clients actually pay

The most common error in a cash forecast is putting receipts on their due date. Invoices issued on thirty-day terms are not paid on day thirty. Some clients pay early, many pay late, and a few pay only after the third reminder.

The report is only as good as the dates in the receipts column, so build them from behaviour, not from terms. Look at how many days each regular client actually took over its last few invoices, and use that. A client that pays in fifty days on thirty-day terms goes into the report at fifty.

The gap between the two is what days sales outstanding measures, and it is often the single largest reason a profitable services company runs short of cash.

Who prepares it, and when

In a company of thirty to three hundred people without a finance director, the report is usually prepared by whoever runs the books: an in-house bookkeeper, an office or finance manager, or an outside accountant on a weekly retainer. It takes a fixed slot in their week, and it belongs after the collections run.

The order matters. Check what was received since the last report, update the receivables list, send the reminders that are due, and only then roll the forecast forward. Built in that order, the report reflects the money that arrived, the money that slipped, and the promises clients made this week. Built before the collections run, it repeats last week’s hopes.

The owner reads it. Ten minutes, at the same time every week, with three questions: where is the low point, did it move, and what is the one action this week.

What to do when the low point moves

When the low point drops, find out why before acting. There are only a few causes, and each has its own response.

A client paid later than expected: chase that invoice, and move that client’s expected payment dates in every future week, not just this one. A new cost appeared: decide whether its timing can move, since a payment moved by two weeks costs less than a payment cut. A project slipped and its invoice went with it: talk to the delivery lead about the date the work will be accepted, because that date sets the invoice date and the invoice date sets the cash.

If the low point falls below the minimum and none of these closes the gap, that is the week to talk to your accountant and your bank, with the report in front of you, not the week it happens.

Seeing your own thirteen weeks

CeoDash builds the rolling thirteen-week forecast from the files you already have: a P&L and balance sheet exported from your accounting system, plus bank statements. It uses the timing you actually collect and pay on, and it marks whether a gap closes on money you are already owed or only if new work is signed. The first figures show in minutes, file uploads are free and unlimited, and the two-week pilot checks the result against your own books.