How to Calculate Discounted Unit Price on HubSpot Line Items

Step 3: Build the correct discounted unit price formula

Create a custom calculation property on the Line Item object.

In the formula editor, use:

unit_price * (1 - (discount_percentage / 100))

What this does:

• discount_percentage / 100 converts 10 into 0.10
• 1 - 0.10 gives you the factor to apply to the price (0.90)

So for a $100 line item with a 10% discount:

• discount_percentage = 10
• 10 / 100 = 0.10
• 1 - 0.10 = 0.90
• 100 * 0.90 = 90

The Test button in the property editor should show exactly that.

If it does:

• Your formula is correct.
• HubSpot is handling the percentage as expected.
• You are safe to move on.

Deal level maths follows the same pattern if you need the number there too, and we have walked through calculating custom deal amounts the same way.

Is your unit price GST inclusive or GST exclusive?

The thing that catches people the first time is not in the formula at all. It is which figure the formula is running on.

A flat percentage is proportional, so on its own the order does not change the answer. Ten per cent off $1,000 excluding GST and ten per cent off $1,100 including GST both come to $990 including GST. What breaks a quote is mixing the two bases in the one calculation.

Take a $1,100 line item that is GST inclusive, so $1,000 plus $100 GST, with a 10% discount:

• Discount the GST exclusive figure: $1,000 x 0.90 = $900, GST $90, the customer pays $990.
• Discount the GST inclusive figure and then let the quote add 10% GST on top: $1,100 x 0.90 = $990, plus $99 GST, the customer pays $1,089.

Same formula, and the customer is $99 out of pocket. Across a page of line items that is the difference between a quote you can invoice and one you have to reissue.

So before you trust the column, check what unit_price actually holds in your portal: the pre tax figure, with GST added by your quote's tax settings, or a GST inclusive number someone typed in by hand. Keep your discounted unit price on the same basis as unit_price, and let GST be applied once.

It shows up on the document as well. Australian tax invoices show the GST amount separately, which is what the ATO's tax invoice rules ask for, so the discounted line amount and the GST amount have to agree with each other. A discounted unit price sitting on the wrong basis is usually where they stop agreeing.

If you quote in more than one currency, that is its own job again: here is handling multiple currencies in the same quote.

Step 4: Add the calculated property to the line item editor

Next, make the property visible where your team actually works with line items.

1. Open a deal, quote, or estimate where you have a line item editor.
2. In the line items table, click Edit columns (top right of the table).
3. Find your discounted unit price calculated property in the list.
4. Tick the checkbox to add it, then click Apply.
5. Optionally drag it to sit next to:
   • Unit price
   • Discount/Discount% so it reads like a pricing story across the table.

Now, when users enter a discount_percentage on a line item:

• HubSpot will re-run the calculation.
• Your discounted unit price column will update.
• Everyone sees the right net price on the row.

At this point:

• The calculation works.
• It is visible in the line item editor and the estimate construction table.
• You are using the fields the way HubSpot expects.

Step 5: Why it does not just appear in the estimate or quote template

Here is where things get a bit unintuitive.

There are two contexts:

1. Line item editor/estimate construction table
   • Shows almost any line item property you choose via Edit columns.
   • Includes custom and calculated line item properties.
   • Ideal for internal use and internal clarity.
2. Estimate/quote template
   • Uses a specific line item table module in the template.
   • Only shows fields that the template or module is configured to support.
   • Does not automatically show every custom line item property.

So even though:

• Your property exists.
• The calculation is correct.
• It is used on the line item editor table.

It may still not be available as a field to drop into the quote or estimate template.

That is a template and module limitation, not a bug in your calculation.

Step 6: Your options for showing it on estimates or quotes

What you can do here depends heavily on your access and setup.

Option A: Customise the line item table in the template

If you have template editing access (for example, via Design Manager or a custom quote/estimate builder):

1. Edit the estimate/quote template you are using.
2. Find the line item table module that renders products and prices.
3. Either:
   • Clone it and modify, or
   • Replace it with a custom line item table module that allows you to configure columns.
4. In that module's settings, add your discounted unit price property as:
   • A new column, or
   • A replacement for an existing field you do not need.
5. Save and re-publish the template.
6. Test with a fresh estimate/quote so you are sure the new field appears.

This is the cleanest way to display custom line item properties, but it does rely on:

• Access to the right template tools.
• A module that supports configuration of line item fields.

Option B: Use it purely as a calculation helper

If you cannot touch templates, you still get value:

• Use the discounted unit price:
  • In the line item editor.
  • For internal QA and approval.
  • As a field in line item reports.
  • In workflows (for example, margin checks, approvals, alerts).

In this case:

• You let HubSpot's own totals render on the quote.
• You use your calculation in the background to keep things accurate and auditable.

Option C: Map into a supported visible field (last resort)

If you absolutely must see the value on the final document and cannot customise templates:

• Use a workflow or automation to write the calculated value into a line item field that is supported by your template.

You need to be careful here, so you do not confuse your team or overwrite important values, but it is a workable compromise if your template options are locked down.

Wrapping Up

You are not going mad: if your discounted unit price formula works in the test tool and in the line item editor, your maths is fine. The awkward bit is the gap between what the line item editor can show and what your estimate or quote template is allowed to render.

By:

• Using a proper percentage field (discount_percentage).
• Writing a clear formula (unit_price * (1 - (discount_percentage / 100))).
• Checking whether unit_price is GST inclusive or GST exclusive before you trust the output.
• Adding it to the line item editor via Edit columns and understanding the template limits.

You get a reusable way to show discounted unit price where your team actually works, and a clear path if you later want to wire it into templates.

Discounting is one step in a longer chain, so if you are building the whole thing, start with the full quote to cash flow this sits inside.

If you want help unpacking:

• Which discount fields you should be using.
• Whether your current templates can actually show this property.
• Or how to design a pricing and discount model that works neatly across quotes, deals, and reporting.

Pricing and discount models are part of our RevOps and HubSpot work. Get in touch and we can map this out for your specific HubSpot setup.

Want more HubSpot hacks? Follow us on Facebook and YouTube. We regularly share walkthroughs, hacks and tutorials so you can get more out of HubSpot without breaking your brain or your data.

Happy HubSpotting.