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.
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.
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.
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.
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.