In sales invoice, the excise duty amount gets doubled and displays incorrect VAT/CST amount when the excise duty ledger grouped under Duties & Taxes is created with the following settings:
● Type of Duty/Tax is set to Others.
● Include in assessable value calculation for is set to VAT.
● Method of Calculation is set to Based on Value.
To correct the settings of excise duty ledger
1. Go to Gateway of Tally > Accounts Info. > Ledger > Alter.
2. Select the excise duty ledger.
3. Select the Type of Duty/Tax as CENVAT.
4. Select the Duty Head as Basic Excise Duty.
5. Enter the Percentage of Calculation (eg 5) as 12.5%.
6. Press Ctrl+A to accept.
To view the excise sales invoice
1. Go to Gateway of Tally > Display > Day Book.
2. Select the transaction and press Enter.