Child pages
  • [in-commerce] VAT Calculation and Invoicing
Skip to end of metadata
Go to start of metadata

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/60b03403de998323#

Hi guys,

Actually, the VAT in In-Portal is calculated in addition to the total price, stating that all prices are shown excluding VAT. This way to do is perfect for a B2B business, because they retrieve the added VAT in their accounting, but for individuals, at least in Europe, prices need to appears including VAT.

Until now, the workaround is to set all prices with VAT, and removing the field "VAT amount" from cart TPL, acknowledging that everything on the website includes VAT. Doing so, In-Commerce wasn't able to edit a correct Invoice, because of missing VAT amount.

Related Tasks

MINC-75 - Getting issue details... STATUS

12 Comments

  1. Hi Phil,

    Thanks for your request.

    Can you provide a few samples with the live data so it's more clear on
    the difference here.

    DA

  2. Hi Dmitry,

    here are 2 examples:

    - when prices are displayed without VAT, and user want to have a real
    invoice, we configure VAT (19.6% in my example, actual french rate),
    the result is like this:

    Sub-total : 100 $ exc.vat
    Shipping :   10 $ exc. vat

    VAT 19.6% :  21,56  $  ## if vat apply to shipping, otherwise VAT
    would be 19,60 $

    Grand Total : 131,56 $ inc.vat

    - when prices are displayed with VAT, and user want to have a real
    invoice :

    Sub-total : 100 $ inc.vat
    Shipping :   10 $ inc. vat

    VAT 19.6% :  18,03  $  ## Deducted From total price 110 $ if vat apply
    to shipping -- otherwise VAT is deducted from 100 $ only, VAT total
    would be 16.38 $

    Grand Total : 110,00 $ inc.vat

    I hope this is more clear.

    Phil.

     On Aug 2, 12:23

  3. Phil has a point (no matter, that discussion is 1.5 year old and was
    abandoned for unknown reason). And especially in some countries (like
    Latvia) VAT is changed every year (18% -> 21% -> 22%), then keeping VAT used
    inside the order item record will make sense too.

    Dmitry, what's your opinion on that?

  4. Yes, I agree that we should add this option for In-Commerce.

    *My thoughts about where to keep the VAT numbers:*

    *1.* I see no reason so have VAT stored in OrderItems table since it's the
    same number of all products in the Order, and we already storing it in the
    Order.

    *2.* Perhaps we should add new *VATIncluded* field that will be applied to
    the Orders table in addition to currently existing - VAT (amount) and
    VATPercent fields. New field will store the setting for that Order when VAT
    was Included or Excluded based on described by Phil options.

    What do you think?

    DA

  5. Yes, I agree with your proposal.

  6. 1- for some businesses, like grocery store for example, VAT have a different
    rate for different type of products.

    2- the inclusion/exclusion should apply for products AND shipping types.
    Many other merchant software even allow to choose from any vat rate
    previously setup for each product, leaving all possibilities open for
    merchants.

    2011/3/14 Alexander Obuhovich <aik.b...@gmail.com>

  7. Hi Phil,

    I like your ideas, but think we should stick in this discussion to the
    original idea (described by you) and may be talk about additional
    improvements to VAT in separate discussion so there is NO mix up.

    You are welcome to start a new discussion and include your ideas for
    improvement. By the way, your original post here was VERY informative and
    well defined!

    Thanks.

    DA

  8. ok for a new post, and thank you for your appreciation !

    2011/3/14 Dmitry A. <dandre...@gmail.com>

  9. Are we ready for a task here?

    We all agreed on?

    Adding a new *VATIncluded* field that will be applied to the Orders table in
    addition to currently existing - VAT (amount) and VATPercent fields. New
    field will store the setting for that Order when VAT was Included or
    Excluded based on described by Phil options.

    *Phil's example how this will be applied:*
    =============
    - when prices are displayed without VAT, and user want to have a real
    invoice, we configure VAT (19.6% in my example, actual french rate),
    the result is like this:

    Sub-total : 100 $ exc.vat
    Shipping :   10 $ exc. vat

    VAT 19.6% :  21,56  $  ## if vat apply to shipping, otherwise VAT
    would be 19,60 $

    Grand Total : 131,56 $ inc.vat

    - when prices are displayed with VAT, and user want to have a real
    invoice :

    Sub-total : 100 $ inc.vat
    Shipping :   10 $ inc. vat

    VAT 19.6% :  18,03  $  ## Deducted From total price 110 $ if vat apply
    to shipping -- otherwise VAT is deducted from 100 $ only, VAT total
    would be 16.38 $

    Grand Total : 110,00 $ inc.vat
    =============

    DA

  10. where will appear this new field?

    At best, in each produit detail in admin, we should be able to choose one of
    the pre-defined VAT rates, and this vat field should be included in
    import/export available fields, using corresponding VAT id

    Does "VAT hard stored for each orders" belong to another task?

    2011/3/31 Dmitry A. <dandre...@gmail.com>

  11. Hi Phil,

    Thanks for your reply!

    We'll have a new In-Commerce Configuration Setting which will tell if VAT is
    included or excluded when the order is placed (please see task I have
    created below). Current task only covers your initial request which I have
    summarized.

    This is a task for this discussion:

    *1033: VAT Calculation and Invoicing*

    MINC-75 - Getting issue details... STATUS


    Let's have other improvements related to the VAT (Product specific VAT,
    Include / Exclude Shipping) in a separate tasks so there is confusion here.
    You are welcome to start another discussion and properly describe your ideas
    there if it's okay with you Phil.

    Cheers!

    DA

  12. Hi Dmitry,

    while I don't have any needs actually about VAT, I'm really happy that we
    can move on about this subject, which seems to me very important to make
    inportal the right solution for any sized projects.

    I still don't have access to in-commerce tasks, but I bet you've well
    copy/pasted our discussion :)

    I'll create separate subjects for products and shipping related to vat.

    Thanks
    Phil.

    2011/4/4 Dmitry A. <dandre...@gmail.com>