Skip to Content

Excise on basic & VAT on total in one code

Hi,

My requirement is

One tax code is needed for excise & VAT

Excise will be on base amount and VAT will be levied on base + excise amount

I have created one tax code for Excise with VS1, VS2 and VS3

Basic Amount Level 100

VS1 on basic amount Level 200

VS2 on VS1` Level 202

VS3 on VS1 Level 204

@VAT: VAT should be on the total of basic + VS1 + VS2 + VS3

How should i define for VAT?

Could you please help me in defining?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Apr 12, 2012 at 08:49 AM

    Hi,

    VAT calculated as following:
    (Base value + BED + Ed Cess + HEd Cess)

    Eaxmple:
    Base value of material:Rs. 1000.00
    BED @12%:Rs.120.00
    Ed Cess @2 @ on BED:2.400
    HEd Cess @1 @ on BED:1.200
    -----------------
    Total=1123.60

    VAT @ 5%=56.18

    -------------
    GRAND TOTAL=1179.78


    You need to use routine 4 in column "CalTy" for step ( Base + Excise +VAT ) in tax procedure

    More check link:

    http://scn.sap.com/thread/1972299

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2012 at 08:24 AM

    Hi,

    Create step 210 with desciption Subtotal 1 (w/o condition type) from 100 to 204

    Create VS4 at step number 215 for defining VAT . To calculate this on subtotal1 put from 210 to 210.

    Regds

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 12, 2012 at 09:41 AM

    HI,

    In OBYZ t-code for tax procedure you have to define From TO of Vat condition in sutch way that it will include base + excise amount,you create subtotal for same and then calculate it vat on that subtotal

    Kailas Ugale

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 12, 2012 at 08:57 AM

    Along with the Excise conditions you can use standard condition available for VAT in the Tax code itself,

    JVRD for Deductible or JVRN for Non-deductible, Assign GL for JVRD in OB40

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2012 at 05:42 AM

    Hi,

    Excise code is working fine now!!

    But i have problem in service tax calculation - when i give service tax code, it calculates excise also with service tax.

    Conditions VS1, VS2, VS3 which i used for excise were also used for service tax.

    So i have created new condtions for excise.

    Still i don't know why it calculates service tax and excise together.

    I have different tax codes for service tax and excise

    Please help me

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.