Skip to the content

Reporting and finance 2 min read

The Friday report that built itself: automating your weekly figures

How to turn the weekly figures from a Friday afternoon job into a report that builds itself overnight, with one definition of every number and no spreadsheet.

Woman presenting a business strategy to colleagues
Photo by Vitaly Gariev on Unsplash

In one distribution business we worked with, three people spent every Friday afternoon pulling figures from the warehouse system, the accounts package and a spreadsheet into a management report. Eleven hours a week, most of it copying and pasting, and the figures were different every time because everyone defined "orders" slightly differently.

A month later the report was in the directors' inboxes at seven on Friday morning and nobody had touched a spreadsheet. Here is what that took.

Agree the numbers before touching anything

The biggest cause of reporting pain is not technology. It is that nobody has written down what each figure means. Does "orders this week" count cancelled ones? Is revenue net of returns? Which date counts, order or dispatch? An hour in a room with the people who use the report, writing a one-line definition for each number, removes most of the arguments and most of the manual fixing.

Get the figures from the source

Every system that holds a number you report on can give it up automatically: an API, a scheduled export, a database view. The report should pull from those directly, not from a file someone saved on a Thursday. This is the technical part and it is usually a few days' work per system.

Build it once, in one place

Whether that place is a reporting tool, a shared dashboard or a well-built spreadsheet that fills itself, the point is that the calculation lives in one place and runs on a schedule. Overnight on Thursday, for a Friday report. First thing on the first, for month-end.

Send it, do not ask people to fetch it

The report goes to the people who need it, by email or into Teams, with the headline numbers in the message so nobody has to open anything to know how the week went.

What changes

The eleven hours come back. The figures are the same every week because the definitions are the same. And the people who used to build it have Friday afternoons for the work that needs them. The same shape works for month-end, for board packs and for the daily numbers a floor manager needs.

If Friday afternoons in your business look like that first paragraph, book a free call. Reporting is one of the quickest wins we know.

More to read

All news

Start here

What is your team still doing by hand?

Book a free thirty-minute call. We will find the friction and tell you what we would fix first.

Book a free call Thirty minutes, no obligation