Home What we do The Ecosystem Automation Our work About
A grid of monthly reporting tasks done by hand
← All articles
Automation

The monthly pack is costing you more than you think

Somewhere in your business, once a month, a capable person spends days assembling a report from exports. The hours are the part you can see. The rest of the bill arrives in other forms.

Glen SultanaSeptember 20266 min read

Five steps, every month

The pack is built the same way in most companies we meet. Someone exports from each system: the accounts, the CRM, the operations platform, the advertising accounts. They paste the files together. They reconcile the totals that disagree, which they always do, by adjusting until they match. They rebuild the charts. Then they email it, usually a week or more after the month closed.

It is skilled work, done by someone you hired for something else, and it is repeated in full every month because nothing in it is saved except the final file.

The cost you can count

Start with the hours, because they are the easy part. If five people each spend thirty minutes a working day touching a report by hand, that is fifty hours a month, or six working days, or six hundred hours a year. That is not an estimate of your business; it is arithmetic, and you can put your own numbers into it on our Automation page. Most managers who do are surprised, because the time is spread across so many people that nobody sees the total.

The costs you cannot

Errors. A pack built by hand carries the mistakes of the hand that built it. A pasted column that is one row out, a filter left on from last month, a formula that stopped at row 400 when the export grew to 450. These do not announce themselves. They get discovered when a decision made on the wrong figure goes wrong, or they are never discovered at all.

Arguments. When the pack disagrees with a department's own report, the meeting spends its time on which figure is right. That conversation happens because the definitions were never agreed once and written into a system, so every month they are re-agreed by hand.

Lateness. The pack describes a month that ended ten days ago. Anything it reveals, a margin slipping, a channel that stopped converting, a client who quietly stopped ordering, has been happening for six weeks by the time anyone acts. The cost of that delay does not appear anywhere, and it is usually the largest of the four.

Dependence. One person knows how it is built. When they are on leave the pack is late; when they resign, it stops. The business has a single point of failure in the one document its leadership uses to steer.

What the alternative looks like

Every system loads into one warehouse overnight, on its own. The definitions were agreed once, so there is nothing to reconcile. The dashboard is current to yesterday when the managing director opens it at eight, and the pack, if you still want one, prints itself from the same figures. Flags are raised by rules rather than by someone noticing: a project too long in one stage, a KPI marked behind, a customer with no order for sixty days.

The person who used to build the pack gets their days back for the analysis you hired them to do, which is the part of the job a machine cannot do and the part that was being crowded out.

What we do not automate

Decisions. The system tells you which client to call and which project to chase. It does not decide whether to. Anything that needs judgement stays with the people paid to exercise it; anything that does not, stops costing them their mornings.

Work out what the hours cost you, with your own numbers. The calculator is on the Automation page →

Glen SultanaFounder · 110 Analytics

Want to talk this through on your own numbers?

Thirty minutes with Glen, and a straight answer on whether 110 Analytics is the right fit.

Thirty minutesFreeNo pitch deck
01Where your data is fragmented, and what it is costing you in decisions and reporting hours.
02The one report or view that would change how the business runs, and whether the data for it already exists.
03A straight answer on whether 110 Analytics is the right fit.