Case study · AI finance reporting

From disconnected numbers to a finance system that updates itself.

Accounting, pipeline and Google Workspace joined into one finance director grade dashboard, built with Claude and delivered to Slack every month with no manual work.

1 day → 0
monthly reporting effort
3
systems joined
1
session to build and deploy
A report open on a laptop, from above
Client
Anonymised
Engagement
Custom AI build
Systems
Accounting, HubSpot, Google Workspace
Access
Read-only, on their own infrastructure
The situation

Good revenue, healthy margins, and still no fast answers.

The founders had their data in three disconnected systems: an accounting platform for the finances, HubSpot for sales and pipeline, and Google Workspace for email and files. Nothing talked to anything else.

Monthly financial analysis meant a full day of manual spreadsheet work, so it rarely happened. Decisions ran on gut feel and outdated figures. The basic questions (true profit, client concentration, what the pipeline was actually worth) took too long to answer to be useful.

The numbers existed. Getting to them cost a day nobody had.

What we did

A finance engine that does the finance director's monthly analysis.

Claude on live data, every month, without anyone opening a spreadsheet.

01
Live data pulls

From accounting and pipeline, with transaction validation, so the numbers can be trusted.

02
A finance director grade dashboard

True profit and real margin in one place, alongside the business metrics.

03
A working sales forecast

Built from pipeline that couldn't previously be forecast, plus concentration risk on the top clients as a share of revenue.

04
A self-updating valuation

A monthly business valuation tracked month over month, delivered to Slack with zero manual intervention.

The results.

0

days of manual reporting a month, down from a full day.

3

systems joined: accounting, HubSpot and Google Workspace.

First

time true profit and real margin were visible in one place.

Minutes

to surface client concentration risk, with a working forecast.

Before
Three systems that didn't talk to each other.
A full day of manual spreadsheet work for one monthly view.
Reporting that rarely got done, so decisions ran on gut feel.
True profit, concentration and pipeline value all unanswered.
After
One connected dashboard across accounting, HubSpot and Workspace.
Manual reporting effort down from a full day to zero.
True profit and real margin visible for the first time.
Concentration risk surfaced in minutes, with a working forecast.
Why this study is anonymised

Finance data is the most sensitive there is.

This is a live finance system running read-only on the client's own infrastructure. Because it handles profit, margin and client concentration, we don't publish the client's name or a named quote. The numbers and the build are real, the identity stays private. That's the standard we'd hold for your finances too.

Numbers in three systems, and the monthly report never gets done?

Talk to Rikki about a self-updating finance system built on your own infrastructure. We'll tell you what it would take.

Rikki Lear
Rikki LearCommercial Director