Loading
Feature degradation | Gmail Email delivery failureRead More
Manage Your Billing Processes with Salesforce Billing
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Proration Multipliers for Standalone Order Products

          Proration Multipliers for Standalone Order Products

          An order product’s prorate multiplier tells us how many pricing periods are in the order product’s term. Salesforce Billing uses a prorate multiplier and other billing fields to calculate the order product’s billable unit price. By default, Salesforce CPQ calculates a prorate multiplier for a quote line and passes it to the resulting order product. Because you’re creating an order product without CPQ, you must calculate your order product’s prorate multiplier on your own. (Salesforce Billing Managed Package)

          Required Editions

          Available in: Salesforce Billing Winter ’21 and later

          Before starting, note the length of your order product terms, and whether they’re in days or months. For our examples, we use a monthly order product with a term of 5/23/19 through 09/30/19.

          First, let’s review the types of proration precisions that CPQ supports and how each option calculates prorate multipliers for the order product. You can then use the formulas to calculate a prorate multiplier on your own.

          Proration Precision Type Calculation Example
          Day
          Daily Subscriptions
          (Number of days in order product’s term ÷ Number of days in order product’s default subscription term)
          Monthly Subscriptions
          (Number of days in order product’s term ÷ Number of days in one full subscription term from the order product’s start date)

          If the full subscription term includes a leap day, use 366 in proration multiplier calculation, even if the quote’s term doesn’t contain the leap day.

          Term Units = Day
          05/23/19 through 09/30/19 totals 131 days. Our prorate multiplier is (131 ÷ 365) = 0.3589. Our prorated list price is $12000 * (131 ÷ 365) = $4306.85.
          Term Units = Months
          The default subscription term of 12 months from our start date of 05/23/19 puts the default end date at 05/22/20. Because 2020 is a leap year, we use 366 days when calculating the prorate multiplier. (131 ÷ 366) gives us a prorate multiplier of 0.3579 and a prorated list price of $12000 * (131 ÷ 366) = $4295.08.
          If the full subscription term includes a leap day, Salesforce CPQ uses 366 in proration multiplier calculation, even if the quote’s term doesn’t contain the leap day.
          Day with Calendar Month Weighted

          This value works similarly to Day. The only difference occurs when your org uses monthly subscription term units and calculates one full subscription term. If your quote’s term doesn’t contain a leap day, Salesforce CPQ doesn’t add an extra day to the full subscription term length.

          Only use 366 days if the effective subscription term actually includes a leap day.

          Term Unit = Month
          The default subscription term of 12 months from our start date of 05/23/19 puts the default end date at 05/22/20.
          However, because our effective subscription end date is 09/30/19, we don't include the leap day (2/29/20) in our calculations, giving us a prorate multiplier of 0.3589, or (131 ÷ 365). Our prorated list price is $12000 * (131 ÷ 365) = $4306.85.
          Month

          Use this formula only if your subscription terms are in months.

          Divide your order product’s subscription term in whole months by the product’s subscription term. If your term contains a partial month, round the number of months up to the nearest whole number.

          (Order product’s subscription term ÷ product’s subscription term)

          Term Unit = Month
          05/23/2019 through 09/22/2019 totals 4 whole months. Due to the remaining 8 days, Salesforce CPQ rounds the month total to 5.
          Prorate multiplier = (5 ÷ 12) = 0.4167
          Prorated list price = $12000 * (5 ÷ 12) = $5000
          Monthly + Daily

          Use this formula only if your subscription terms are in months.

          Calculate the subscription term’s length as its number of whole months plus a decimal for any partial month at the end of the term, then divide this value by your subscription term. The partial month equals the number of days in the month divided by (365 ÷ 12).

          We recommend using this formula if you sell and price products by month or year but don’t regularly quote for specific periods of time.

          (Term length in whole months) + ((Remaining Days) ÷ (365/12))

          Term Unit = Month
          05/23/19 through 09/22/19 = 4 months
          09/23/19 through 09/30/19 = 8 days, so we use (8 ÷ (365 ÷ 12)) to calculate the partial month value in our prorate multiplier.
          Prorate multiplier = (4 + (8 / (365 / 12))) / 12 = 0.3553
          Prorated list price = $12,000 * ((4 + (8 ÷ (365 ÷ 12))) / 12) = $4263.01.
          Calendar Monthly + Daily

          Use this formula only if your subscription terms are in months.

          • If the first month is a partial month, divide the number of term days in the month by the total number of days in that month.
          • If the last month is a partial month, divide the number of term days in the month by the total number of days in that month.
          • Add those values to the number of whole months in your term.
          • Divide the result by 12.
          Term Unit = Month
          05/23/19 through 05/31/19 = (9 ÷ 31) days
          06/01/19 through 08/31/19 = 3 months
          09/01/19 through 09/30/19 = (30 ÷ 30) days
          Prorate multiplier = (3 + (9 ÷ 31 + 30 ÷ 30)) ÷ 12 = 0.3575
          Prorated list price = $4,290.32

          You can use this table to figure out the formula needed to provide a prorate multiplier that aligns with your proration needs.

          Salesforce Billing always invoices the customer for the order product’s complete balance. However, recurring order products can split that balance differently over their invoice lines based on how you calculated your order product’s proration multiplier and Salesforce Billing proration package settings. To learn how you can align your proration settings, review Aligning Proration Between CPQ and Billing.

           
          Loading
          Salesforce Help | Article