From Disconnected Numbers to a Self-Updating Finance System
How Imagine Growth connected a lean B2B services business’s accounting, pipeline and workspace into one read-only finance engine that builds a Finance Director grade dashboard and refreshes itself every month.
|
At a glance Client: A lean B2B services business run by two founders, with good revenue and healthy margins. Stack: FreeAgent, HubSpot, Google Workspace, Claude, Slack. Headline result: A self-updating finance and revenue dashboard that surfaced true profit for the first time, exposed a client concentration risk in minutes, and now refreshes every month with no manual work. |
The client is a B2B services business with good revenue, healthy margins and two founders running it lean.
The numbers existed. They just lived in three places that never spoke to each other. Accounting sat in FreeAgent. Sales and pipeline sat in HubSpot. Email, files and calendars sat in Google Workspace.
So the founders made decisions on gut feel and month-old figures. Pulling a real picture meant a full day of manual spreadsheet work, and nobody had the time for that.
Imagine Growth partnered with the business to connect those systems and turn scattered numbers into one finance engine that keeps itself up to date.
The challenge
The founders could not answer basic questions about their own business quickly. Questions like:
• What is our true profit and margin this year?
• Which clients carry the business, and how exposed are we if one leaves?
• What is the sales pipeline actually worth?
• Are we on track for the financial goals we set ourselves?
The frustrating part was that the data to answer all of this already existed. It was just trapped in disconnected tools.
The strategic problem
This was not a data problem. It was a connection problem.
FreeAgent held the accounting truth. HubSpot held the pipeline. Google Workspace held the context around both. But because none of them were joined up, getting a single honest picture meant a day of manual spreadsheet work.
So it rarely happened. And when decisions get made on gut feel and month-old figures, you are flying on instruments that are always behind.
The goal was to connect the systems, apply AI with discipline, and produce a finance picture that is accurate, trusted and never out of date, without adding manual work.
The solution
Imagine Growth connected the systems and pointed AI at them, all in a single working session.
The result is a finance and revenue engine that pulls live data from FreeAgent and HubSpot, checks it, and produces a Finance Director grade dashboard. It refreshes itself every month and posts a summary to Slack. After setup, no manual work is required.
The build, step by step
1. Connected the accounting. A read-only link to FreeAgent pulls invoices, expenses, bank transactions and categories. Read-only by design, so the system can never change the books.
2. Found the real numbers. From the raw bank data, we built true profit, gross margin and cost structure. The headline profit had never been visible to the founders before, and it was higher than they thought.
3. Checked the data before trusting it. Before any analysis, we ran a categorisation review across every bank transaction to confirm costs were booked correctly. Clean inputs, honest outputs.
4. Turned the pipeline into a forecast. We connected HubSpot, separated the services pipeline from licence commissions, and built a stage-weighted forecast using the client’s own deal stages and probabilities. Multi-currency deals convert to home currency automatically.
5. Built a dashboard in the client’s brand. Two views in one. The business engine on top: profit, margin, pipeline and cash. Personal wealth below: net worth, pensions, and a business valuation that recalculates every month as profit moves.
6. Replaced vanity targets with real ones. The client had been chasing a round revenue number. We showed it was the wrong goal, then rebuilt the targets around profit and the founders’ actual lifestyle and long-term plans.
7. Automated everything. The full cycle runs once a month on a schedule, then drops a summary into a private Slack channel.
How it works (the stack)
Everything is read-only and runs on the client’s own machine. No financial data is handed to a third party.
|
Tool |
Role in the system |
|
HubSpot |
Pipeline, deal data and forecasting inputs. |
|
FreeAgent |
Live accounting truth: invoices, expenses and bank data. |
|
Google Workspace |
The surrounding email, files and receipts. |
|
Claude |
The analyst that connects, cleans, models and writes. |
|
Slack |
The monthly heads-up where the summary lands. |
The results
What used to take a day of manual work, and usually did not happen at all, now happens every month without anyone touching it.
|
1 session to connect the systems and build the engine |
Day → zero manual reporting effort each month |
Top 3 clients concentration risk surfaced in minutes |
Monthly dashboard that refreshes itself, hands-off |
• True profit, visible for the first time. A clear view of real profit and margin, built from clean bank data rather than gut feel.
• A client concentration risk surfaced in minutes. The top three clients made up most of the revenue. The founders had felt it; now they could see it and act on it.
• A working sales forecast. Built from a pipeline that, a week earlier, could not be forecast at all.
• A self-updating business valuation. The owners can now watch the company’s worth track with profit, month to month.
• A monthly rhythm that runs itself. The picture is never out of date again.
Why this matters
Most businesses do not have a data problem. They have a connection problem.
The numbers are already there, sitting in tools that were never joined up. FreeAgent knows the accounting. HubSpot knows the pipeline. The gap is the space between them.
When you connect the systems and apply AI with discipline, you get the kind of clarity that used to need a part-time finance director, without the cost or the delay.
This is what HubSpot-native, AI-leveraged finance looks like in practice: accurate, trusted, and always up to date.
The takeaway
The data was never the problem. The disconnection was.
FreeAgent held the accounting truth. HubSpot held the pipeline. Google Workspace held the context. Claude connected them, checked them, and turned them into one finance picture the founders can trust.
It runs read-only, on the client’s own machine, and refreshes itself every month. The day of manual spreadsheet work is gone. The clarity stays.
