Enter Dates for Estimated Revenue Allocation

The Estimated Revenue tab includes Allocation Method fields that allow you to specify the dates and time periods on which you expect to receive revenue. You can also specify an allocation template to apply as the basis when review the estimated revenue data on an Opportunity Forecast report. This provides an efficient method for analyzing the potential revenue stream for the opportunity.

This option is available if your firm purchased the CRM Plus application and the Enable Service Estimate option is selected on the Service Estimate tab in Settings > Opportunity Settings.

To enter dates for estimated revenue:

  1. In the Navigation pane, go to the Hubs section and select Opportunities.
  2. Click the Opportunity toggle button.
  3. Click the Estimated Revenue tab.
  4. Specify the Allocation Method to determine how estimated revenue is allocated for the opportunity:
    • Specific Date — Select this option to allocate the estimated revenue amount to specific dates for each opportunity. This activates the Estimated Revenue Allocation grid. Use this grid to identify the dates on which revenue is expected to be received. This feature is useful for companies who receive revenue for a project at irregular intervals, rather than monthly or quarterly. For example, a company can submit a fee schedule with a proposal that specifies that an inspection is to occur on a specific date and, upon completion, a payment will be due.
    • Spread Evenly Across Timescale — Select this option to spread revenue in even amounts across the dates between the estimated start date and the estimated completion date. After you select this option, use the Timescale option to specify the timescale for the revenue. This option is selected by default.
    • Allocate All Revenue to Estimated Start Date — Select this option to allocate the estimated revenue amount to the opportunity's start date.
    • Allocate All Revenue to Close Date — Select this option to allocate the estimated revenue amount to the opportunity's date closed.
  5. If the Allocation Method is Spread Evenly Across Timescale, select the time scale used to calculate the revenue for the revenue period.
  6. If you want to use a template as the basis for revenue allocation, click Refresh/Use Template to open the Allocation Template dialog box and select an existing template. You can use these templates to calculate your company's desired revenue date, amount, and percentage.
  7. If the Allocation Method is set to Specific Date, click + Add Allocation to add an allocation method to the Estimated Revenue Allocation Method grid. Use this grid to identify the dates when you expect to receive revenue. This is useful for companies who receive revenue for a project at irregular intervals, rather than monthly or quarterly.
  8. Enter a description for the revenue milestone. If you use a template, this field populates with the description from the template.
  9. Enter or select the date on which the revenue will be received. If you use a template, this field populates based on calculations from the Time Frame and Time from Start Date fields on the Allocation Template dialog box.
  10. Enter the amount of revenue that you expect to receive. If you use a template, this field populates with the revenue from the template.

    If you enter a value in the Percent of Total Revenue field, the amount in this field calculates based on the amount entered in the Revenue Amount field on the Summary Pane in the Opportunities Hub. For example, an opportunity has $100,000 revenue and a row in this grid has 20% of total revenue. The revenue amount for the milestone is $20,000.

    If an opportunity's revenue amount changes, the amounts on this grid update automatically.

    The amount in the Revenue Amount column is totaled at the bottom of the grid.

  11. Enter a percentage of the total revenue that you expect to receive. You cannot enter a value that is less than 0 or greater than 100. If you use a template, this field may populate with the percentage entered on the template.

    The total Percent of Total Revenue must equal 100% when you save the record.

    The amounts in the Revenue Amount and Percent of Total Revenue columns are totaled at the bottom of the grid.

  12. Save your changes.
Parent Topic: How to...