To create a Sales Voucher
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
In Voucher Type sub form select Excise – Sales as the voucher type.
Ensure that the Sales Voucher is in Item Invoice Mode.
Enter the Date as 14-4-2008.
Enter the Ref details as ABC/830.
In Excise Unit field Tally.ERP 9 displays ABC Company as selected during voucher type creation.
Excise Book Name field displays the name of the excise invoice book (ABC/Rule11/Book1/08-09) created for the Excise Unit.
Serial No. field displays the Rule 11 invoice Number e.g. ABC/1003/08-09.
In Party A/c Name field select Universal Distributors from the List of Ledger Accounts.
In Party Details sub form enter the details as shown.
In Nature of Removal field select the option Domestic from the list of Types of Removals.
In Sales Ledger field select the ledger Sales @ 12.5% from the List of Ledger Accounts.
VAT/Tax Class field automatically gets updated with the VAT/Tax class as selected in the sales ledger, which can be changed.
In Name of Item field select the Stock Item i.e. AquaKing - 20Ltr.
In Quantity field enter the quantity as 1,000.
In Rate field enter the rate as Rs. 70.
In Name of Item field select the Stock Item i.e. AquaEase - 20Ltr.
In Quantity field enter the quantity as 200 and Rate as Rs.100.
Select the expense ledger – Packing Charges and enter Rs. 6000 in Amount field.
Select Duty Ledger i.e. Basic Excise Duty @ 16%. Amount will be calculated and displayed automatically.
Select Education Cess @ 2% and Secondary Education Cess @ 1% ledgers. Amount will be calculated and displayed automatically.
Select Output VAT @ 4% as the VAT duty ledger. Amount will be displayed automatically.
Set the option Show Statutory Details to Yes to view the Statutory Details screen.
In Statutory Details screen press Alt + F1: Detailed to view details of duty calculation. The Statutory Details screen is displayed as shown.
Note: In statutory details user can view that the parking charges being apportioned to stock items to arrive at the assessable value to calculate the excise duty/VAT.
Packing charges is 6,000
Value of AquaKing – 20Ltr is 70,000
Value of AquaPure – 20Ltr is 20,000
Apportionment of Packing Charges to AquaKing–20Ltr: 6,000*70,000/90,000 = 4666.67
Apportionment of Packing Charges to AquaPure–20Ltr: 6,000*20,000/90,000 = 1,333.33
Assessable Value of AquaKing – 20Ltr (74,666.67) = Value of AquaKing–20Ltr (70,000) +Packing Charges (4666.67)
Assessable Value of AquaPure – 20Ltr (21,333.33) = Value of AquaPure–20Ltr (20,000) +Packing Charges (1,333.33)
In Bill-wise Details screen select Type of Ref as New Ref and in other fields retain the default details.
Enter the Narration, if required.
Press Enter to Accept and save.