Dual Taxation error

Alain Guy
Alain Guy
Offline
0
Need a fix on percentage level as if example first tax was 5% for GST and had an extra tax as QST for Quebec Canada that is 9.5% added from first plus tax then plus second tax it will not be the right summe seen in the total pricing invoice

good example is if price was 149.90 before tax first GST 5% that equal + 7.50 = total of 157.40 ... this part is good ... then if you add the second tax of 9.5% it should be 157.40 plus second tax of 9.5% = 14.95 added to this summe making it as 157.40 + 14.95 to the grand total of 172.35$ after both taxes included on billing

can this % be fixed I believe it is cause of binary digits instread of fraction percentage values

on your values the total would be seen as the the QST (9.5%) as shown will put value to 9.50 then would show QST 14.24$ instead of 14.95$ and this is wrong imagine and on each costumers I would be out of business soon and would still need to pay that goverment for that lost asked of me to pay from this error created on your taxation values

need to find a way to fix when a decimal is placed on such as 9.5% and not lead it into binary value
how can this be fix please
Responses (7)
  • Accepted Answer

    Wednesday, January 02 2013, 09:50 AM - #Permalink
    0
    good morning,

    the taxes, in our system, are always calculated based on the subtotal base..

    in our system, if you have a bill of 100$, and 2 taxes, one of 5% and the other of 10%, the values will be: 100 + 5 + 10 = 115$
    the "second" tax is applied to 100, not 105 which would make a total of 115,5$

    taxes do not have an "order" if you know what I mean...

    is that the problem you're having?
    The reply is currently minimized Show
  • Accepted Answer

    Alain Guy
    Alain Guy
    Offline
    Wednesday, January 02 2013, 01:50 PM - #Permalink
    0
    good morning,

    the taxes, in our system, are always calculated based on the subtotal base..

    in our system, if you have a bill of 100$, and 2 taxes, one of 5% and the other of 10%, the values will be: 100 + 5 + 10 = 115$
    the "second" tax is applied to 100, not 105 which would make a total of 115,5$

    taxes do not have an "order" if you know what I mean...

    is that the problem you're having?


    In Canada we do have taxation order meaning amount first tax called GST that has nothing to do with the next comming up then is the second called QST this one is full amount paid with first tax then comes a second Tax that is on that total meaning ( sub total )+ GST then total here is again being taxed as taxover taxed so you do take that first amount and tax it again of 9.5% over it ... is the rule of taxation here and applies in Canada so called it what ever but remains your system doesnt seem to match the taxation requirement of Canadians out here where 2 Taxation are requiered

    All am asking is how can I fix this issue now and can it be fixed in your taxation part of your invoice section
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, January 02 2013, 05:49 PM - #Permalink
    0
    ok I see... no, our system is not canadian-tax aware.
    so, all taxations are based on the "previous" amount? or just the second (and following) use that way?

    "easy way": if you need to first tax to be applied "normally", and then all the rest applied on the "subtotal + first tax" basis, then the easiest way is to actually include the first tax (GST) as an invoice item. it's the only way I can thing that does not require code changes.

    "the other way": is to actually build this tax-calculation system, changing the way the taxes are applied. we would manually "separate" the tax called GST and calculate the other based on subtotal + GST (instead of just subtotal). but this requires code customization.. is not doable out of the box because in our system all taxes are treated as equals...
    The reply is currently minimized Show
  • Accepted Answer

    Alain Guy
    Alain Guy
    Offline
    Wednesday, January 02 2013, 07:22 PM - #Permalink
    0
    good morning,

    the taxes, in our system, are always calculated based on the subtotal base..

    in our system, if you have a bill of 100$, and 2 taxes, one of 5% and the other of 10%, the values will be: 100 + 5 + 10 = 115$
    the "second" tax is applied to 100, not 105 which would make a total of 115,5$

    taxes do not have an "order" if you know what I mean...

    is that the problem you're having?


    In Canada we do have taxation order meaning amount first tax called GST that has nothing to do with the next comming up then is the second called QST this one is full amount paid with first tax then comes a second Tax that is on that total meaning ( sub total )+ GST then total here is again being taxed as taxover taxed so you do take that first amount and tax it again of 9.5% over it ... is the rule of taxation here and applies in Canada so called it what ever but remains your system doesnt seem to match the taxation requirement of Canadians out here where 2 Taxation are requiered

    All am asking is how can I fix this issue now and can it be fixed in your taxation part of your invoice section

    yes as it be good and very profitable for both if you can fix it and having a good idea on international taxation and here is a good link you can do your test and see if or as while you do this modification is http://www.la-calculatrice.com/calcul-tps-tvq.html that will give you a true value on our taxation you can also verified with pricing and placing cent ( 100 ) to a dollar as in witch 9.5 would be something as or again this is an english well describe link http://www.revenuquebec.ca/en/entreprise/taxes/tvq_tps/calcul-taxes.aspx I will wait till you get this update fixed thanks
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 03 2013, 09:47 PM - #Permalink
    0
    no, no, you missunderstood :) this is not something we plan on adding on the official release (at least not for now) but if you want we can try to add this modification to your particular installation.
    The reply is currently minimized Show
  • Accepted Answer

    Alain Guy
    Alain Guy
    Offline
    Saturday, January 05 2013, 12:40 AM - #Permalink
    0
    no, no, you missunderstood :) this is not something we plan on adding on the official release (at least not for now) but if you want we can try to add this modification to your particular installation.


    hmm I did fixed mine and be glad to share it with you in needs of other that needs such a modification in there Canadian and USA invoice billing system

    just that had to do few modification to work with a direct billing and invoice system after few test it seems nice now but working over a finishing look now and testing it for errors if it will hold on tight smiles

    regards
    GYSMO
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, January 05 2013, 10:30 AM - #Permalink
    0
    oh! ok, so you could make the modification yourself? that's cool! :)
    how did you manage it?
    The reply is currently minimized Show
Your Reply