+ Reply to Thread
Results 1 to 4 of 4

Calculate VAT off Selling Price and Show in HTML Email

  1. #1
    Registered User
    Join Date
    07-04-2018
    Location
    uk
    MS-Off Ver
    office 365
    Posts
    4

    Calculate VAT off Selling Price and Show in HTML Email

    Calculate VAT off Selling Price and Show in HTML Email

    Im looking for a way to show the breakdown of VAT within an email I send -

    Total Price - I HAVE THIS
    VAT 20%
    Net Price

    Currently, my system allows me to use "drop-in" codes for address, date, invoice etc but I don't have a drop-in code for the vat (or net vat). I have one for the "total paid"

    Help gratefully received.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Calculate VAT off Selling Price and Show in HTML Email

    Good afternoon somerset-uk

    With UK VAT at 20% :
    • To calculate net from the selling price, multiply the selling price by 0.83333 (1 / 1.2 = 0.83333)
    • To calculate VAT from the selling price, multiply the selling price by 0.16666 (0.2 / 1.2 = 0.16666)
    By and large, the two resultant figures should add up to the selling price.
    Occasionally, they may be out by 0.01 due to roundings, so you will need to build in a check for this.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    07-04-2018
    Location
    uk
    MS-Off Ver
    office 365
    Posts
    4

    Re: Calculate VAT off Selling Price and Show in HTML Email

    TY but its a formula for calculating that WITHIN HTML that Im after.

    I have the excel code but is there a way of using that within html coding? - if JS is needed can it be contained within the HTML

  4. #4
    Registered User
    Join Date
    07-18-2018
    Location
    Bangkok
    MS-Off Ver
    2016
    Posts
    67

    Re: Calculate VAT off Selling Price and Show in HTML Email


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate selling price with the cost and margin%
    By carnagelan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2018, 04:00 PM
  2. Expressing Selling Price as a percentage of List Price
    By Antman452 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-02-2016, 08:21 AM
  3. [SOLVED] Setting a selling price based on cost price and order quantity
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 08:07 AM
  4. Replies: 2
    Last Post: 04-13-2012, 08:22 AM
  5. Replies: 5
    Last Post: 02-06-2012, 06:21 AM
  6. [SOLVED] Trying to calculate tax and grat involved in set selling price.
    By loweyj in forum Excel General
    Replies: 4
    Last Post: 02-05-2012, 09:06 PM
  7. looking for latest selling price..
    By Lawrence in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2005, 12:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1