From spreadsheets to self-updating dashboards
Sofia Iversen
Customer Stories, Klaru
Brightwave is a 14-person creative studio that, like a lot of small businesses, ran on a single heroic spreadsheet. It tracked revenue, project margins, and pipeline, and it was maintained almost entirely by one operations manager named Lena every Monday morning. The spreadsheet worked — right up until it didn't scale, and then it became the most fragile thing in the company.
The Monday ritual
Every week, Lena exported invoices from their billing tool, pulled deal stages from their CRM, and copied hours from their time tracker into the master sheet. Three exports, a dozen formulas, and roughly two hours of careful copy-paste. If she was out sick, the company effectively went blind for a week. If she fat-fingered a cell, a wrong number could sit in the founders' weekly review undetected.
I was the single point of failure for the company knowing how it was doing. That's a lot of pressure to put on a Monday and a spreadsheet.
Lena, Operations Manager at Brightwave
The switch
Lena connected their billing tool and CRM to Klaru in an afternoon — no engineer, no warehouse. The same three sources she'd been exporting by hand now flowed in automatically and joined on the client. The formulas she'd maintained for two years became live tiles. The master spreadsheet became, for the first time, optional.
- Two hours of weekly copy-paste dropped to zero.
- The Monday report now sends itself to Slack before the team is online.
- Anyone can click a tile and see live data — no more single point of failure.
- A failed-invoice alert caught a billing gap that had been quietly recurring.
What changed in the room
The founders noticed it first. Their Monday meeting used to open with ten minutes of 'is this number right?' Now it opens with the number being right, on a screen, refreshed that morning. The conversation moved from validating the past to deciding the future. Lena, freed from the ritual, took on forecasting — the kind of work the spreadsheet had never left her time to do.
There's a version of this story at almost every small company we talk to. Someone heroically maintains a spreadsheet until the day they realize the heroism was never the point. The point was the decisions on the other side of the numbers — and those get faster, calmer, and more confident the moment the dashboard starts updating itself.
Written by
Sofia Iversen
Customer Stories, Klaru
Sofia interviews the operators behind Klaru's customers and turns their before-and-after into playbooks anyone can copy.
