Automatic deal spreading

Here's how to automatically spread deals over multiple months based on inputs in your CRM system - this will allow your team to spread deals in QuarterOne straight from your CRM.

How it works

  • Create a "number of months" deal field in your CRM.
  • QuarterOne will then spread deals automatically from their close date based on this field.
  • Manual override adjustments can still be made to deals using the Pipeline Grid page in QuarterOne.

    How to do it

    Step 1 - Create a custom field in your CRM

    Note this is only necessary if no equivalent field already exists in your CRM.

    HubSpot - Creating a custom field in HubSpot CRM

    1. Login to HubSpot and go to Settings -> Properties -> Deal Properties -> Create Property
    2. Set property type to a "Number" field.
    3. Set other property fields (name, description) as you wish. You can give the field whatever name and description you wish. Many customers use the names "Duration (months)" or "Length in months" for example.

    HubSpot Custom Field

     

    Custom field

    Pipedrive - Creating a custom field in Pipedrive

    1. Login to Pipedrive and go to Settings -> Customize fields -> Add deal field
    2. Set field type to a "Numerical" field.
    3. Set field name to whatever you wish. Many customers use the names "Duration (months)" or "Length in months" for example.

    Step 2 - Map this new custom field to QuarterOne

    Once you have created a custom number field in your CRM, it must be mapped to QuarterOne's Duration field.

    1. Log in to QuarterOne and go to Settings -> Data and CRM -> CRM Fields
    2. Apply the field created in Step 1 (above) to the Optional "Duration" field - see image below.
    3. Click "Update" to apply.

    Setting duration in QuarterOne

    Step 3 - Turn on spreading automation

    Once you have mapped the custom CRM number field to QuarterOne's Duration field, you can configure the automatic spreading automation workflows as follows:

    1. Go to the automation settings page at Settings -> Automation
    2. Set New Opportunities dropdown to "Spread opportunity value over duration from month of close date" (see image below)
    3. Set Duration changes dropdown to "Spread opportunity value over duration from month of close date" (see image below). This is an optional setting you can apply if you'd like to override the monthly spread with a revised spread every time the duration value changes.

    Deal spreading automation settings-1

    Step 4 - Re-Import data

    To apply the Duration spreading to your existing deals, you will need to clear and re-import your pipeline data. To do this, click "Re-import data" option at the bottom of the CRM setting page. If you don't carry out this step the automatic duration spreading will only apply to new deals added or those where the duration value has been changed.