How can I track opportunity gross margin value?

Gross margin is the difference between revenue and cost before accounting for certain other costs. Generally, it is calculated as the selling price of an item, less the cost of goods sold (production or acquisition costs, essentially). Source: Gross margin Pipeliner enables you to track your gross margin value of your sales opportunities in your sales pipeline. Please follow the steps below to start tracking your gross margin.

Tasks:

  • Create a Custom Field
  • Add "Gross Margin" custom field into the Opportunity Form
  • Enter the Gross Margin Opportunity Value into one Opportunity
  • Configure Sales Target to see the results

Creating a Custom Field

You can create a custom field for the gross margin in "Administration".

  1. Click on the “User” and select “Administration” from drop down menu.
  2. Click on "Custom fields and forms".
  3. Click on the corresponding Pipeliner form: Opportunity.
  4. Click on "Create" button to create a new custom field.
  5. Name your field "Margin Value".
  6. Select from the "Field Type" dropdown the option "CURRENCY".
  7. Configure additional field settings according to your preferences and click "Save" button. 

Adding Gross Margin Field into the Opportunity Form

Once, you create your custom gross margin field, you will need to add it into the opportunity form.You can add a custom gross margin field into the opportunity form in "Administration".

  1. Click on the “User” and select “Administration” from drop down menu.
  2. Click on "Custom fields and forms".
  3. Click on the corresponding Pipeliner form: Opportunity.
  4. Click on the "Edit" (pencil icon) within the "Actions" column for the corresponding form.

Entering the Opportunity Gross Margin Value

You can enter the margin value of your opportunity in "Sales Pipeline".

  1. Run Pipeliner and click the "Pipeline" icon.
  2. Double-click to open and view particular opportunity.
  3. Enter the margin value for selected opportunity and click "Save"

Tracking the Gross Margin

You can track your gross margin goal using Pipeliner "Sales Target".

  1. Run Pipeliner and click the "Pipeline" icon.
  2. In the upper right-hand corner of the application screen click on "Options" (a big-wheel icon).
  3. Within the "Options" settings click on "Target Settings".
  4. Click on the drop down menu "Target Value Calculation" and select your custom "Margin Value" field. Pipeliner will automatically calculate your sales target according to opportunity "Margin Value" contribution.

Tip: If you would like to save this setting just click on the "Save" button on the top of "Options" window.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request