# Help with sales total

**URL:** <https://community.hubspot.com/t/help-with-sales-total/103769>\
**Category:** Tips, Tricks & Best Practices\
**Tags:** object\
**Created:** [March 29, 2024, 8:09pm UTC](https://community.hubspot.com/t/help-with-sales-total/103769 "2024-03-29T20:09:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![CSimpson19](https://avatars.discourse-cdn.com/v4/letter/c/919ad9/32.png) [@CSimpson19](https://community.hubspot.com/u/CSimpson19)\
**Post date:** [March 29, 2024, 8:09pm UTC](https://community.hubspot.com/t/help-with-sales-total/103769/1 "2024-03-29T20:09:13Z")

</div>

Hi! New to HubSpot so sorry if this is obvious.

I want to add properties that we have on our e-commerce site like VAT (Tax), Shipping Costs etc and deduct that from the “real” total. I then want the real total displayed in reports.

I’ve added these as properties, is there a way to get a new total to deduct these other currency figures somewhere in the pipeline?

---

<div class="post-metadata">

**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\
**Post date:** [April 1, 2024, 11:57am UTC](https://community.hubspot.com/t/help-with-sales-total/103769/2 "2024-04-01T11:57:29Z")

</div>

Hi @CSimpson19,

Thanks for reaching out to the Community!

How are the VAT (Tax), Shipping Costs, and other additional costs currently being recorded in HubSpot? Are you using an integration? Could you please share all the details you have regarding this topic so I can review and see if it’s possible to achieve your goal?

Thanks,

Diana

---

<div class="post-metadata">

**Author:** ![CSimpson19](https://avatars.discourse-cdn.com/v4/letter/c/919ad9/32.png) [@CSimpson19](https://community.hubspot.com/u/CSimpson19)\
**Post date:** [April 3, 2024, 9:15pm UTC](https://community.hubspot.com/t/help-with-sales-total/103769/3 "2024-04-03T21:15:37Z")

</div>

Hi Diana,

we currently have them as custom properties.

---

<div class="post-metadata">

**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\
**Post date:** [April 4, 2024, 8:51am UTC](https://community.hubspot.com/t/help-with-sales-total/103769/4 "2024-04-04T08:51:14Z")

</div>

Hi @CSimpson19,

Great, thanks! So, is it already capturing and saving the information in HubSpot, right?

Let’s invite some of our experts to see if they have any suggestions to help you achieve your goal.

Hi @Lucila-Andimol, @Jnix284, @danmoyle - Do you have any insights for @CSimpson19 ?

Thanks and happy Thursday! 🙂

Diana

---

<div class="post-metadata">

**Author:** ![jnix284](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jnix284/32/29_2.png) [@jnix284](https://community.hubspot.com/u/jnix284)\
**Post date:** [April 4, 2024, 11:56am UTC](https://community.hubspot.com/t/help-with-sales-total/103769/5 "2024-04-04T11:56:21Z")

</div>

@DianaGomez happy to help @CSimpson19,

While you can’t incorporate your custom properties into the default “Deal Amount” value, you can create a [custom calculated property](https://knowledge.hubspot.com/properties/create-calculation-properties) that provides you with the accurate amount you’re looking for.

Once you have that custom amount, you can edit your reports to leverage this property instead of the default amount property.

---

<div class="post-metadata">

**Author:** ![Lucila-Andimol](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/lucila-andimol/32/69276_2.png) [@Lucila-Andimol](https://community.hubspot.com/u/Lucila-Andimol)\
**Post date:** [April 4, 2024, 9:14am UTC](https://community.hubspot.com/t/help-with-sales-total/103769/6 "2024-04-04T09:14:55Z")

</div>

Hey @CSimpson19

if you have already imported or sync the information you need into deal properties

the step you need is to create a new custom calculated property

that calculates the math you need, for example= deal amount - VAT - shipping cost

[Here is an article on how to create them](https://knowledge.hubspot.com/properties/create-calculation-properties)

Then you can create a report about this property.

Hope this helps
