What's been sold, and when it will land. Month by month, out to 2030.

A London immersive art studio sells work that's paid over months or years, across art sales, tours, services and grants. Their HubSpot reports were only showing the full value of a deal on the day it closed. Now leadership can see what's been sold, by product and revenue type, and when the revenue will land.

To 2030expected revenue by month, quarter and year
By productcommercial activity by product, revenue type and billing model
Always currentrevenue recalculated automatically as deals change

Where they started

The studio earns from a mix of art sales, tours, services and grants, and much of it is paid over time. Leadership wanted to plan around when money would actually arrive. HubSpot's reports were only showing when a deal closed.

What we did

I worked with their leadership and management team to agree what they needed to see. Then we introduced a product library, and set up each line item the way the business actually sells and bills. That meant what's sold, the type of revenue, whether it recurs, when billing starts and for how long.

Their HubSpot plan didn't include custom code in workflows, so I used n8n to read each deal, calculate the revenue and write it back. It runs on its own and keeps the figures accurate as deals change.

Then I ran a workshop to put the team in control of their own reporting, so they can get the most out of their CRM day to day.

Where they are now

Leadership can see commercial activity by product and revenue type, and when the revenue will land, month by month out to 2030, with a weighted view of the pipeline on top. That's a view they can run the business and plan cash flow on.

If your reports show when deals close but your money arrives over months, the first call is where I'd tell you what your version looks like.

Where to next

Not sure where to start?

A short call is usually enough to work out the next step. I'll tell you straight whether you're fine on your plan and just need training, need some support, or have outgrown your tier.

Book a call