Revenue Forecasting Advice

Does anyone out there have experience using revenue forecasting reports within Pipedrive Insights?  Looking to use "Payment Schedule" to report revenue but only seeing option for filter by "Expected Close Date".  As a contractor, we don't get paid immediately upon signing a contract.  Jobs can take months to start and only then do we receive monthly progress payments.  Doesn't appear I can show this through Pipedrive revenue forecasting reports... am I wrong?

0
0 votes

· Last Updated -

Comments

  • Brad Krause_13404
    Brad Krause_13404 Posts: 518
    edited February 25 #2

    Without any input about when you expect to receive payment pipedrive isn't going to know when you would be getting paid.  You would need to create a date field and enter an expected payment date I would suspect. 

  • Charles Davis
    Charles Davis Posts: 5
    edited July 2021 #3

    Without any input about when you expect to receive payment pipedrive isn't going to know when you would be getting paid.  You would need to create a date field and enter an expected payment date I would suspect. 

    Payment dates have been entered.  But there's no "payment schedule" field when attempting to create a filter within forecasting reports.  The only filter option appears to be "Expected Close Date" which dumps the entire deal value into that month. 

    image

     

  • Stuart Major
    Stuart Major Posts: 3
    Second Anniversary First Comment
    edited January 13 #4

    We work in the construction sector, and created a field Expected Completion Date as the date for final payment.

    We kept Expected Close Date to keep the sales team happy and extend our sales pipeline out beyond Contract Signing through another couple of stages to Deal Complete. 

  • Tom Howard_18151
    Tom Howard_18151 Posts: 4
    edited January 13 #5

    I have used the subscription tools in PipeDrive to predict monthly rental rates (we rent pumps, etc...).  Same could be used for monthly progress payments.  You can set when payments were to start and end along with other one time payment needs.  See attached picture.  

    image
  • Rebecca Wallace
    Rebecca Wallace Posts: 20
    Photogenic First Anniversary
    edited January 13 #6

    I am also in the construction world- Following

  • Brad Krause_13404
    Brad Krause_13404 Posts: 518
    edited July 2021 #7

    Without any input about when you expect to receive payment pipedrive isn't going to know when you would be getting paid.  You would need to create a date field and enter an expected payment date I would suspect. 

    Ah, I see, we dont use the revenue feature. 

  • Motii Team
    Motii Team Posts: 8
    Second Anniversary First Comment Photogenic Elite Solution Provider
    edited February 25 #8

    Hi Charles

    Not sure if you still need a reply on this but I think I can help. If I've understood what you are trying to achieve, I think the issue is in the report you are selecting. You need to select the 'Subscription revenue' option when creating the report. I'm guessing you are selecting the 'Revenue forecast' option. That option only points at Deal Value, expected Close Date and Won Time as the key metrics. 

    By selecting 'Subscription revenue' it allows you to pick up on either 'Recurring' or 'Payment Schedule' or 'One-Time' options in the report. Assuming you're using the Sidebar 'Revenue' feature as described from within Deal then you will be able to create a report that shows you booked income in the months ahead. This option means you can achieve what you want without the need for additional fields or stages in your pipeline. 

    Let me know if you want more detail and I can make a video for you of how to do this. 

    Regards

    Ben 

  • Charles Davis
    Charles Davis Posts: 5
    edited July 2021 #9

    Hi Charles

    Not sure if you still need a reply on this but I think I can help. If I've understood what you are trying to achieve, I think the issue is in the report you are selecting. You need to select the 'Subscription revenue' option when creating the report. I'm guessing you are selecting the 'Revenue forecast' option. That option only points at Deal Value, expected Close Date and Won Time as the key metrics. 

    By selecting 'Subscription revenue' it allows you to pick up on either 'Recurring' or 'Payment Schedule' or 'One-Time' options in the report. Assuming you're using the Sidebar 'Revenue' feature as described from within Deal then you will be able to create a report that shows you booked income in the months ahead. This option means you can achieve what you want without the need for additional fields or stages in your pipeline. 

    Let me know if you want more detail and I can make a video for you of how to do this. 

    Regards

    Ben 

    Ben, thanks a million!  This appears to be the answer to my revenue forecasting question.  I can't believe I hadn't at least tried the 'subscription revenue' report earlier.  Really appreciate your help on this one!

  • Motii Team
    Motii Team Posts: 8
    Second Anniversary First Comment Photogenic Elite Solution Provider
    edited July 2021 #10

    Hi Charles

    Not sure if you still need a reply on this but I think I can help. If I've understood what you are trying to achieve, I think the issue is in the report you are selecting. You need to select the 'Subscription revenue' option when creating the report. I'm guessing you are selecting the 'Revenue forecast' option. That option only points at Deal Value, expected Close Date and Won Time as the key metrics. 

    By selecting 'Subscription revenue' it allows you to pick up on either 'Recurring' or 'Payment Schedule' or 'One-Time' options in the report. Assuming you're using the Sidebar 'Revenue' feature as described from within Deal then you will be able to create a report that shows you booked income in the months ahead. This option means you can achieve what you want without the need for additional fields or stages in your pipeline. 

    Let me know if you want more detail and I can make a video for you of how to do this. 

    Regards

    Ben 

    Happy to help. If you've got any other questions let me know. We are Pipedrive experts and work a lot with businesses in the building, construction and manufacturing industries. 

    Ben