# Forecasting projected revenue

**URL:** <https://community.hubspot.com/t/forecasting-projected-revenue/95829>\
**Category:** Dashboards & Reporting\
**Tags:** reports, analytics-tools, enterprise, dashboards\
**Created:** [December 11, 2023, 10:55pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829 "2023-12-11T22:55:37Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![wsblack](https://avatars.discourse-cdn.com/v4/letter/w/858c86/32.png) [@wsblack](https://community.hubspot.com/u/wsblack)\
**Post date:** [December 11, 2023, 10:55pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829/1 "2023-12-11T22:55:37Z")

</div>

I am running in to an issue getting Hubspot reporting to work the way it should.

When I generate a forecast, an amount will show up on a close date based in the future, which is fine. The challenge is, even if the line item ends in 3 months, the chart doesn’t reflect the revenue stopping. The revenue amount just keeps increasing as new deals land on the report.

---

<div class="post-metadata">

**Author:** ![trevordjones](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/trevordjones/32/35637_2.png) [@trevordjones](https://community.hubspot.com/u/trevordjones)\
**Post date:** [December 12, 2023, 2:54pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829/2 "2023-12-12T14:54:16Z")

</div>

Hi @wsblack

Recurring revenue is generally assumed to continue after the expiration of a contract in most CRM’s. If you have line items that terminate in three months, I would treat them as non-recurring, or one-time revenue, paid in installments.

I’m not an accountant, but unless your books are cash basis from a bookkeeping perspective I think you would accrue the full amount up-front in such cases anyway, so your revenue forecast should be accurate with this recorded as a lump sum.

I hope this is helpful.

---

<div class="post-metadata">

**Author:** ![wsblack](https://avatars.discourse-cdn.com/v4/letter/w/858c86/32.png) [@wsblack](https://community.hubspot.com/u/wsblack)\
**Post date:** [December 13, 2023, 3:50pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829/3 "2023-12-13T15:50:33Z")

</div>

Thank you. That is indeed helpful. What we are attempting to do is accurately reflect a month to month revenue projection to senior management. We have projects that are ongoing and some that go for several months. reporting all of that in a single number would not work on a monthly report.

---

<div class="post-metadata">

**Author:** ![DaveParry](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/daveparry/32/60933_2.png) [@DaveParry](https://community.hubspot.com/u/DaveParry)\
**Post date:** [October 22, 2024, 9:13pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829/4 "2024-10-22T21:13:05Z")

</div>

We have developed a solution which helps forecast turnover rather than orders received. HubSpot does a not bad job of this if you’re using line items but this can sometimes get complicated.

This used to need custom objects to be able to create monthly billing amounts automatically and then report on them. However, with the event of the new template library you can rep purpose the services object to do the same thing with just a professional license rather than needing enterprise for custom objects.

You can read about it here: [Revenue Forecasting using HubSpot CRM](https://www.wellmeadow.co.uk/case-study-revenue-forecasting-using-hubspot)

It does need an API triggered by a workflow web hook, but it is all doable.

If you’d like to discuss further, then please message me.

Dave

---

<div class="post-metadata">

**Author:** ![Twigsmore](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/twigsmore/32/9763_2.png) [@Twigsmore](https://community.hubspot.com/u/Twigsmore)\
**Post date:** [March 18, 2025, 3:32pm UTC](https://community.hubspot.com/t/forecasting-projected-revenue/95829/5 "2025-03-18T15:32:21Z")

</div>

Hi @wsblack we solved for this using some custom properties and an easy API to generate these reports in Google Sheets and then push them back to HS. [Creating Resource Forecasting Reports in HubSpot](https://www.cronyxdigital.com/blog/creating-resource-forecasting-reports-in-hubspot)