Calculating Your Real Annual Revenue in HubSpot, Beyond MRR and ARR

How to build an accurate annual revenue report in HubSpot

Once your data structure is in a good place, you can create the report that leadership actually cares about.

Building the core annual revenue report

1. Go to Reports > Reports and click Create report.
2. Choose Single object and select Deals.
3. Add the following properties to the report:
   • Amount
   • Close date
   • Deal stage
   • Any segmentation properties you care about (pipeline, revenue type, owner, region).
4. Filter:
   • Deal stage = Closed Won
   • Close date is within your chosen year (or between your year start and year end).
5. In the visualisation:
   • Group by: Close date, and set grouping to Year (or Month or Quarter if you want more detail).
   • Summarise: Sum of Amount.

This gives you your total revenue figure for the selected period. There is one adjustment to make before you call it annual revenue.

Take the GST out before you call it revenue

Deal amounts usually get entered the way they appear on the quote, which in Australia is generally GST inclusive. Revenue on a P&L, and the revenue figure that goes to the ATO, is ex GST. So a report that sums Amount and calls the total annual revenue is overstating it, and it will not tie back to the ledger.

The arithmetic is simple. One eleventh of a GST inclusive amount is GST, so a deal entered as $55,000 is $50,000 of revenue and $5,000 of GST. Across a year of deals that gap is the difference between a number your CFO recognises and one they have to correct in front of the board.

There are two ways to handle it:

• Agree that Amount is always entered ex GST and let your invoicing system add the tax. This is the cleaner option, and the one we set up where the sales team will wear it.
• Keep amounts as quoted and build a calculated deal property, Amount ex GST, set to Amount divided by 1.1. Use that property as the measure in every revenue report and leave Amount alone for quoting.

One caveat. If part of what you sell is GST free, a flat divide by 1.1 is wrong for those deals, so split by revenue type or add a GST applicable property before you apply the adjustment. Whichever route you take, write it down, so anyone reading the number knows which side of the tax line it sits on.

Segmenting the report for real insight

The real value of doing this in HubSpot is seeing how the total breaks down, as well as the total itself.

Useful segmentations include:

• By product or service: Group by Line Item or Product to see which offerings are driving revenue.
• By customer or company: Group by Company to see top customers and concentration risk.
• By revenue type: Split subscription vs one-time vs services. Helpful for valuation and stability discussions.
• By sales team or owner: Group by HubSpot Owner to assess performance and capacity.

You can either build multiple separate reports, or use the same report and change the “Group by” property depending on the audience.

Creating an annual revenue dashboard

Dashboards make this usable day to day.

Create a Revenue or Executive dashboard containing:

• A card for total annual revenue (this year vs last year).
• A chart for revenue by month for the current year.
• A chart for Revenue by product or service.
• A chart for revenue by customer (top 10 or top 20).
• A card or chart for recurring vs non-recurring revenue.

Now leadership and RevOps can see what is going on without needing to manually rebuild reports each time. If you are weighing up whether HubSpot's paid revenue tooling adds anything here, we have written up what Revenue Hub is and who actually needs it.

Validating HubSpot revenue against your finance system

Even if HubSpot is beautifully configured, you still need sanity checks. Finance is the system of record for recognised revenue. HubSpot is the system of record for commercial activity.

To keep the two in step:

1. Pick a closed financial period, for example, last financial year.
2. Run your total annual revenue report in HubSpot for that exact date range.
3. Export the result if needed.
4. Compare it with the revenue reported in your accounting system for the same period.

You will almost always find some differences. Common reasons:

• GST still sitting inside deal amounts on one side and not the other.
• Deals closed in HubSpot that were later cancelled or adjusted in finance.
• Timing differences (for example, finance spreads revenue over time while HubSpot counts all at close date).
• Missing or incorrect deal amounts.
• Revenue that is invoiced outside HubSpot with no matching deal.

Where you see patterns, you have three options:

• Tighten HubSpot processes (for example, better rules for closing deals).
• Adjust HubSpot reports (for example, exclude certain deal types).
• Accept a known, documented gap where finance and CRM numbers are designed to differ slightly due to revenue recognition rules.

The key is having a clear, agreed-upon explanation, not a “we are not sure why it is different” shrug.

Using HubSpot annual revenue data to drive strategy

Once you trust the number, it becomes far more than a report you send to finance.

Better forecasting and planning

With clean historic annual revenue by product, region, segment and revenue type, you can:

• Forecast next year with more confidence.
• Model impact of price changes or new products.
• Decide where to focus marketing and sales effort.

HubSpot’s forecasting tools can then sit on top of that foundation for more real-time insight.

Performance analysis and the decisions that follow

When you know which:

• Customers
• Industries
• Products
• Channels

Actually drive revenue, you can make clearer calls about:

• Where to double down
• What to retire
• Which experiments are worth funding

Customer lifetime value, retention analysis and expansion strategies all become more meaningful when they are built on accurate revenue data instead of rough guesses. A revenue number you trust is also what makes the RevOps KPIs Australian companies should already be tracking worth putting on a dashboard.

Wrapping Up

Accurate annual revenue in HubSpot turns the system your teams live in every day into a financially credible view of how the business grows.

When you:

• Standardise deal data,
• Use Line Items properly,
• Adjust for GST,
• Build clear revenue reports, and
• Regularly validate against finance,

HubSpot stops being “just a CRM” and becomes a revenue picture your CFO and your sales team both trust. It is one piece of a bigger job, and the full guide to revenue operations covers the rest of it.

If you want a HubSpot revenue dashboard that finance and sales both believe in, have a look at our RevOps and HubSpot work, or message us and we will help you build it properly from the ground up.

Follow us on Facebook to stay in the loop with the latest HubSpot updates.

Subscribe to our YouTube channel for deep-dives and HubSpot "how-to" guides that actually make sense.

Happy optimising.