Define our Fiscal Year / Quarters

We have a lot of very nice "This Quarter", "Last Quarter", "Next Quarter" filter functionality in HubSpot CRM....buuuuut, if your Company's Fiscal Year is not the same as the Calendar Year (as many are not), this "Quarter" filter functionality is not valid, and actually becomes misleading (or at best unneeded / unusable clutter in your filters).  You then must go to the "Custom Date Range" filtering functionality to obtain the correct date range.

 

It would be helpful and less misleading to have a Setting to define the organization's Fiscal Year.  Canned "Quarter" filters would fall inline correctly from there.

 

Thanks!

63 Replies
Regular Contributor

Would love this feature! It's a common option for CRMs.

New Contributor

Agreed! This would be a big improvement. For now, I've created a custom Deal property to capture the fiscal year but is limited. Having the "this year" and "this quarter" functionality would be much better!

New Contributor

Really need this. Seems so basic.

New Contributor

Absolutely needed!

New Member

My last three companies have all had financial years which don't align with the calendar year. This is the first time I've used Hubspot; I've been using Salesforce for over ten years. I've been trying to defend the use of Hubspot here as I think it's better-designed at a basic level, and I think is more intuitive. But this is a glaring omission. Hubspot has a reputation as too marketing-focused and not sales-focused, and this just reinforces that view. It makes the product virtually useless if I have to enter a custom date range for every query.

New Contributor

Agreed; this is an essential feature. When is it happening?

Regular Contributor

It's hard to believe that this is not standard. The omission of these types of features is what one of may reasons HubSpot continues to be tagged as a company that doesn't effectively deliver a feature set that suits the large-mid and large enterprise (not to suggest smaller companies wouldn't have this need either).  You can innovate faster than the rest, but as long as features like this are missing, larger enterprises will always need the likes of CRM's outside of HubSpot CRM for sales management and reporting. 

Regular Contributor

Yes, we absolutely need that!!!!

New Contributor | Gold Partner
New Contributor | Gold Partner

yes absolutley needed!

New Contributor

This is an absolute deal-breaker for us. When is this feature coming? What is the alternative in the interim? Our financial year starts on April 1st

New Contributor

This is critical functionality for a CRM. Why wasn't this built-in/standard from the very beginning? 

New Contributor

Agree with the above commenters.  I have never worked in a company where the fiscal year aligns with the calendar year.   Yes we can define reporting by date, but why should we have to? 

Regular Contributor

Completely agree with the above. It's throwing up some real issues for us with our reporting.

The quota stops reporting in December (instead of July which I set it to) and gives inaccurate forecasting.

For example, if we had one sales person with a monthly quota of £10,000, the revenue report should show £120,000 annual quota target, which it does if my date filters are set from 1st January to 31st December.

The problem is, our financial year runs from 1st August to 31st July, when I set the date filters to that, the annual quota target drops to £50,000 (because it's only actually reporting on 1st August to December 31st)!

It took a while to troubleshoot it and figure out the problem, if anyone has a solution I would be really grateful.

 

Thanks.

New Contributor

They need this feature ASAP! 

New Contributor

we also would like this functionality.

Regular Contributor

We also need this.  It makes so many of the reports difficult to manage, because you have to hard-set dates and update them in multiple reports across the platform every month/quarter, etc.

New Contributor

While we're awaiting this important feature, has anyone come up with a workaround for quarterly reporting? Our fiscal year runs from November 1 to October 31.

 

I've done the following, but it still requires manual spreadsheet manipulation to chunk the info into the proper quarters. I'm using reports to forecast revenue for the year and by the quarter, and these are centered on the Deal's Close Date. 

 

In reports:

Change the reporting period to our fiscal year.

Set the frequency to monthly

 

Export the report data into a spreadsheet template that is prebuilt, with 2 extra columns that 1) designate the quarter the deal is set to close in, and 2) provide a total $$ for the quarter. 

 

Anyone have any better suggestions?  

New Contributor

Love this idea!  You can't be a sales organization without needing to set goals and monitor performance against goals.   If Hubspot really wants to service the Sales community this is a must as not every company has a calendar year-end for reporting.  Hope this becomes a near future change.


Thanks for sharing. 


George Albert

Sales for Life

New Contributor

Would be so great if we could define the fiscal year in Account Settings.

 

Meanwhile, here's another solution/workaround:

 

  1. Created a Deal Property called "Close Quarter" - or something similar - and make it a Dropdown Select.
  2. Add selections, eg., 2019 Q1, 2019 Q2, for the next 2 or so years.
  3. Create a workflow that automatically assigns the Close Quarter based on the Deal Close Date.
  4. Create a Custom Deal Report that draws from this field and set the Date Range for your Fiscal Year.   

 

 

 

New Contributor

Agreed - this would be extremley helpful. We are able to define this in SFDC as our fiscal year doesn't even follow standard quarters .... (Feb 1 - Jan 31). It would make reporting a lot easier and require less manipulation when it comes time for QBRs!