I know whether my business is on track in ninety seconds, before my first coffee, without opening a single spreadsheet

Jun 14 • AI

That was not true a couple of years ago. Back then, working out whether the business was healthy meant opening one spreadsheet, then another, then cross-referencing a PDF from the accountant with a CSV from the billing platform. An hour gone, and I still did not trust the number.

Most talk about AI in small business gets stuck on the wrong use case: writing emails, drafting posts, making images. Fine, but surface level. The real prize is this. AI lets you build a dashboard out of the messy, half-broken data you already have, without a developer, without a BI consultant, and without a six-figure platform. The inputs are whatever you can export from the tools you already pay for. The output answers one question cleanly: am I on track, yes or no, and if not, where do I look.

Start at the plumbing. If you resell subscriptions, there is almost always a gap between what you pay a supplier and what you bill the client. A seat gets cancelled but stays on the invoice. A supplier raises a price and your pricing does not move. Each gap is tiny. Across hundreds of clients it is real money leaking every month, and you cannot see it in your accounting file, because that only shows what you invoiced, not what you failed to invoice.

I built a reconciliation dashboard for exactly this. I drop a CSV from each supplier portal and the billing platform into a folder, and the AI rebuilds the dashboard in place: licence count against billed quantity, cost against revenue, margin, and a flag on every row that does not line up. The first time I ran it, it paid for the entire month of AI fees fifteen times over. A job that used to be a dreaded quarterly half-day is now a twenty-minute monthly review.

That is the AI pillar: not a content toy, an operating intelligence layer.

What is the one number about your business you wish you could see every week without building it by hand? Post it in the AI room.

0 comments

I know whether my business is on track in ninety seconds, before my first coffee, without opening a single spreadsheet