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!

HubSpot updates
37 Replies
CJErin
New Contributor

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

Sbrennan
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? 

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

ztembi
New Contributor

They need this feature ASAP! 

Bas87
New Contributor

we also would like this functionality.

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

PJ_McD
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?  

Geo67
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

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

 

 

 

t-dub
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!