Hi,
I am trying to understand how the calculation of the line items works, I searched for documentation on the formulas and did not find anything. I updated it based on my knowledge and I wanted to understand if any of you have some documentation to send to the customer, and if you can check and see if my formulas are correct:
The formulas I defined in the DD:
Thanks for any help! 
Hello, @OBetzalel thank you for posting in our Community!
To calculate line items in HubSpot, you can use the built-in tools such as the Deals or Quotes feature. For calculating line items within a deal, you can add individual products or services as line items and assign quantities, prices, and discounts as needed. HubSpot will automatically calculate the total amount based on the line items you’ve added. Similarly, if you’re using the Quotes feature in HubSpot, you can add line items for each product or service, specify quantities, prices, and discounts. The tool will then calculate the subtotal, taxes, and total amount for you. These features provide convenient ways to calculate line items in your HubSpot deals or quotes, ensuring accurate and easy tracking of sales and revenue.
I want to share some resources that may help:
And invite our top experts @NicoleSengers @HubDoPete @Bryantworks any recommendations to @OBetzalel?
Thank you,
Pam
Hi Omer
Each Line Items has 18 calculated properties producing many of the numbers you see in the UI including some you mention ARR, MRR, ACV, TCV plus also Margin and ARR Margin, MRR Margin etc. these are complex formulas which take the line item price and the recurring duration into account such as monthly quarterly, six monthly, annual, 2yrs and 3yrs and line item discount in too.
Reverse engineering them is tricky as it is trial and error.
You can read some formulas via the API and you can create some basic ones via the API too (on Line Items but not products).
Have you named all the ones you need?
best
Pete
For example here is the calculation property for HubSpot MRR
I used line breaks to make it a bit more readable.
round_nearest(
if is_present(string(recurringbillingfrequency))
then (
amount
/
if string(recurringbillingfrequency) equals ‘monthly’
then 1\n
elseif string(recurringbillingfrequency) equals ‘annually’
then 12\n
elseif string(recurringbillingfrequency) equals ‘per_three_years’
then 36\n
elseif string(recurringbillingfrequency) equals ‘per_two_years’
then 24\n
elseif string(recurringbillingfrequency) equals ‘per_six_months’
then 6\n
elseif string(recurringbillingfrequency) equals ‘quarterly’
then 3
endif
)
else 0
,
if is_present(string(hs_line_item_currency_code))
then
if is_present(currency_decimal_places(string(hs_line_item_currency_code)))
then currency_decimal_places(string(hs_line_item_currency_code))
else 3
else 3
)
So:
MRR is the line item amount divided by the number of months.
ARR is MRR x months (being 12, or fewer if term < 1 year).
ACV is ARR if recurring, otherwise, it is the line item amount (Price x Qty)
TCV is MRR x total months if recurring, otherwise it is ACV.
best
Pete
Thank you very much for your help @HubDoPete @PamCotton
Pam, It is real honor that you are replying to my post I think the community here is great, thank you very much! 
Hi HubDoPete, how do you calculate monthly quarterly, six monthly, annual, 2yrs and 3yrs
Thank you for this insight!
I’m trying to figure out if there’s a way to do something similar! I’d like to sum up the amounts of all line items that partially match a certain SKU. We use a specific SKU for passthrough costs, and I’d like to have that end up being in a Deal field so I can do some math with that field. The SKU’s all begin with PASS. Is this possible?
