Need assitance in Table Structure

[gots]

Hi Friends,

I am stuck in a situation of Taxation due to complication in Indian Tax structure. Can anyone please help me out in figuring the right table structure for below,

Primary two (Rather Five) types of Taxes
1. VAT - Local Tax applicable to the sale inside the State
2. CST (Central Sales Tax) - Applicable to interstate (Outside State) Sales
3. Exports - Tax Free
4. Service Tax - Applicable on services rendered.
5. Excise Duty - Central Excise Duty


1. VAT
1a. VAT @ 4%
1b. VAT @ 4%
1bi. Additional VAT @ 1% on the subtotal and NOT ON 4%
1c. VAT @ 12.5%
1ci. Additional VAT @ 2.5% on the subtotal and NOT ON 12.5%

VAT tax is also dependent on the products
for Eg.,
1. Electronics items like resistors, capacitors attract VAT @ 4% + Addi. VAT. @ 1%
2. Metal sheets, pipes purchase from TRADER attract VAT @ 4%
3. Electrical items like switches, relays attract VAT 12.5% + Addi. VAT @ 2.5%

2. CST
2a. CST @ 3% with From "C" (Concessional Rate if Form "C" supplied)
2b. CST @ 10% without Form "C" (IF no C Form Supplied)
2c. CST @ 1% with Form "I" (Concessional Rate if Form "I" supplied Applicable to EOU units in SEZ)
2d. CST @ 0% with Form "I" (Concessional Rate if Form "I" supplied Applicable to EOU units OUTSIDE the SEZ)

3. Exports
3a. Direct Exports (No Form, No Tax)
3b. Indirect Exports ( Form H required and No Tax)

4. Service Tax
4a. Service Tax @ 12%
4ai. Education Cess on Service Tax @ 2%
4ia. Secondary Higher Education Cess on Service Tax @ 1%

5. Excise Duty
5a. ED @ 14%
5ai. Education Cess on ED @ 2%
4ia. Secondary Higher Education Cess on ED @ 1%


There can also be double taxing as below,

on Purchase invoice

1. ED 14+2+1
1a. CST 4 on ED 14+2+1

2. ED 14+2+1
2a. CST 10 on ED 14+2+1

ON sales invoice ED is not yet applicable but if applicable it can be the same and other CST 0% and CST 1% also applicable.

I am building a simple database with flow of data as below for entering the details of requisitions, purchase challans, inward inspection, purchase invoice
sales challan, sales invoice.

 

[Fifty2One]

You might be best to calculate the taxes on the fly and only retain the values as tax1 tax2 tax3 tax4 tax5 etc in a table as accounting records.

 

[gots]

Dear Fifty2One,

Thank you for your reply, But I need to retain the taxing amount for taxation reporting and the tax structure can change any time in india (bullish governemnt policy ) and we need to select tax structure while entering the data of the customer so as all his billings will be done in the same tax structure.
As well for purchase it depends if the vendor turnover is below 1.5 crore Rs. then only CST or VAT applicable and if more then that in the same fiscal year then Excise duty is also applicable with CST or VAT.

What happens in double taxation. Can you please elaborate your reply further.

Any suggestion, please.

regards,

Gautam

 

[gots]

Please help in tax tables

Hello, Can any one please help me in figuring out the right table structure, relationship and forms for the tax structure to be used in my purchase order processing database.

I tried many time but failed. Any help please.

regards,

Gautam