Understanding Subscription Term Basis and Proration

if you are operating a subscription based business, you probably heard about "prorations" again and again subscription term basis and prorations are critical aspects of subscription quoting and billing that businesses need to comprehend for effective revenue management however, it doesn't have to be hard in this knowledge base article, we will delve into the concepts surrounding subscription term basis, explaining how it relates to your subscription start date, and explore prorations – the financial adjustments that occur when a subscription doesn't align perfectly with your billing cycle understanding these concepts is essential for businesses aiming to streamline their subscription billing processes and provide clarity to their customers subscription term basis in nue, the subscription term basis plays a crucial role in calculating the duration of a subscription based on the start date and end date this configuration is used throughout the revenue lifecycle, from quoting, ordering to billing therefore, it is important to understand its implications and ensure alignment of the subscription term basis across sales, revenue operations, and finance teams nue provides the following 5 different options of subscription term basis, which are aligned with the 5 options of the yearfrac function in excel calculation method description formula example result (years) result (months) us (nasd) 30/360 calculates based on a 30 day month and 360 day year, following the us nasd standard =yearfrac(startdate, enddate+1, 0) start date january 1st, 2023end date august 15th, 2025 2 62500 31 50000 actual/actual calculates based on the actual number of days in the time period and the actual number of days in the years =yearfrac(startdate, enddate+1, 1) start date january 1st, 2023end date august 15th, 2025 2 62192 31 46301 actual/360 calculates based on the actual number of days in the time period and a 360 day year =yearfrac(startdate, enddate+1, 2) start date january 1st, 2023end date august 15th, 2025 2 66111 31 93333 actual/365 calculates based on the actual number of days in the time period and a 365 day year =yearfrac(startdate, enddate+1, 3) start date january 1st, 2023end date august 15th, 2025 2 62466 31 49589 european 30/360 calculates based on a 30 day month and 360 day year, following the european method =yearfrac(startdate, enddate+1, 4) start date january 1st, 2023end date august 15th, 2025 2 62500 31 50000 note excel's yearfrac function is widely adopted to calculate the fraction of a year between two dates it's particularly useful for financial and business applications where you need to determine the length of time between two dates in years in excel's yearfrac function, the end date is exclusive of the date in the calculation for example, days between 01/01/2023 and 01/02/2023 are 1 in nue, the end date is inclusive of the date in the calculation for a better user experience for example, if the subscription start and end date are 01/01/2023 and 01/02/2023, the days calculated for this subscription is 2 therefore, in the table above, the yearfrac formula uses enddate+1 as the end date parameter value in the function in nue, the subscription term is calculated and stored in the database as 5 decimal points though on the line editor and other relevant pages it is displayed as 2 decimal points for a clean user experience the most commonly used subscription term basis are us (nasd) 30/360 and actual/actual the choice of method often depends on the specific industry standards, regulatory requirements, and the nature of the financial instruments or contracts involved it's essential to use the method that aligns with the rules and conventions relevant to your particular financial or business application the subscription term basis calculation method is used by both pricing engine and billing engine to determine the subscription terms, billing cycle days, calculate the co term prorations, and billing prorations setting it up after understanding how subscription term basis's calculation method, you can configure the subscription term used by your organization by following these steps login to nue app https //app nue io and click 'settings' icon in the header in the search box, search for 'subscription term basis' and select the search result to open the configuration page in the subscription term basis option, select the term basis of your choice after setting it up, you can see it in action in the line editor if you have changed to a new subscription term basis, you may need to refresh your browser to remove the cache in the following example, we are using us (nasd) 30/360 navigate to salesforce, and select nue on salesforce create a quote from an opportunity in the line editor, set the start date and end date of the quote for example, 01/01/2023, and 08/15/2023 the subscription term on the quote header is calculated as 31 5 months add a couple of products to the quote one has month as the uom term dimension, and the other one has year as the uom term dimension you can see from the image below, the subscription term is calculated properly according to the respective uom term dimension proration nue calculates proration in cases of subscription co terming, and subscription billing subscription co term in the context of subscription co terming, proration refers to the process of aligning multiple subscriptions with different start and end dates so that they all expire or renew on the same date this typically involves adjusting the subscription terms and billing cycles of individual subscriptions to ensure they coincide, allowing for streamlined management and billing of multiple subscriptions within the same billing cycle proration helps simplify the administration of co terming subscriptions and ensures that they are in sync for more efficient billing and renewal processes scenario customer sharp revenue has subscribed to 100 user licenses of vroom enterprise bundle product for a year, starting 10/01/2023, ending 09/30/2024 on 10/18/2023, sharp revenue wants to add 10 licenses of social media streaming, co termed with vroom enterprise bundle in this scenario, when the sales rep creates a quote for sharp revenue, and adds social media streaming co termed with vroom enterprise bundle, she can see that the line item is prorated for the period between 10/18/2023 and 09/30/2024, which comes to 11 43333 months this is using the subscription term basis us (nasd) 30/360 the total amount is prorated according to the calculated subscription term, which comes to 11 43333 100 $4 = $4573 33 subscription billing in the context of subscription billing, proration refers to the adjustment of subscription fees to account for partial periods when a customer subscribes or unsubscribes from a service in the middle of a billing cycle, proration ensures that they are charged or refunded only for the portion of the service they actually used during that period proration is a fair way to align billing with the actual duration of service and is crucial for accurate and transparent subscription billing let's continue with the scenario above scenario customer sharp revenue has subscribed to 100 user licenses of vroom enterprise bundle product for a year, starting 10/01/2023, ending 09/30/2024 sharp revenue is on quarterly billing on 10/01/2023, when the initial order is created that generates subscription for voom enterprise bundle, the the first invoice is already generated and activated on 10/18/2023, sharp revenue wants to add 10 licenses of social media streaming, co termed with vroom enterprise bundle sales rep creates a quote, which converts an order when the upsell opportunity is closed won when the order is activated, an invoice is created for the new subscription social media streaming given that there are the following billing parameters the subscription starts on 10/18/2023; sharp revenue is billed quarterly (billing period = quarterly); sharp revenue's billing cycle start date is 10/01/2023 since it is configured to align with the first subscription vroom enterprise; billing proration is enabled at the organization level, which means that the first partial period will be prorated and invoiced, instead of being rolled into the next billing period nue billing accelerator determines that we need to generate the first invoice of social media streaming subscription in the following period 10/18/2023 12/31/2023 this comes to 2 43333 months so the total amount of the invoice item generated for this subscription is 2 43333 $4 100 = $973 33 putting it altogether this article discusses the concepts of subscription term basis and prorations in the context of subscription based businesses subscription term basis this is a critical factor in calculating the duration of a subscription based on the start and end dates it's used in various stages of the revenue lifecycle, from quoting to billing there are five different options for subscription term basis in nue, each aligned with excel's yearfrac function these options include methods like us (nasd) 30/360, actual/actual, actual/360, actual/365, and european 30/360 the choice of method depends on industry standards and regulatory requirements setting it up you can configure the subscription term basis for your organization by accessing the settings in the nue app once configured, it affects calculations in the line editor, helping you calculate subscription terms accurately proration proration is used in two scenarios – subscription co term and subscription billing subscription co term proration aligns multiple subscriptions with different start and end dates to expire or renew on the same date this simplifies management and billing of multiple subscriptions within the same billing cycle subscription billing proration is used to adjust subscription fees when a customer subscribes or unsubscribes in the middle of a billing cycle this ensures that they are charged or refunded only for the portion of the service they used during that period