www.TallyERP9Help.Com

Accounting Excise Duty Opening Balance [Excise for Manufacturer] in Tally.ERP 9

Support to account Excise Duty Opening Balance in Tally.ERP 9 has been provided through Excise Opening Balance Journal voucher in Release 3.0 (onwards). The Excise Duty opening balance entry can be recorded on any day of the Financial Year.

To account Excise Opening Balance

Go to Gateway of Tally > Inventory Info. > Update Excise Info. > Excise Opening Balance


[Img-81]

Accounting Excise Duty Opening Balance

You can track the Excise Duty Opening Balance by entering the sales details in the Excise Duty Opening Balance entry.

Example: ABC Company has opening Excise Duty of Rs. 56,856 (Total) on the sale of Finished goods under different sales bills.

 

1. Bill - ABC /965. Sale of 25000L AquaEase- 20Ltr to Shubh Distributors

 

* BED- 20,000 (on assessable value of Rs. 2,50,000 @ 8%)

* EC - 400

* SEC - 200

 

2. Bill - ABC/1025. Sale of 35,000L AquaEase- 20Ltr to Universal Distributors

 

* BED- 22,400 (on Assessable Value of Rs.2,80,000 @ 8%)

* EC - 448

* SEC - 224

 

Sale of 20,000L AquaPure - 1Ltr

 

* BED- 12,800 (on Assessable Value of Rs. 1,60,000 @ 8%)

* EC - 256

* SEC - 128

Go to Gateway of Tally > Inventory Info > Update Excise Info. > Excise Opening Balance

  1. In Excise Unit  field select the Excise Unit for which the Excise Opening balance entry is recorded. e.g. ABC Company

Note: As Tally.ERP 9 allows to maintain accounts of Multiple Excise Units in a Single Company, in Excise Duty Opening Balance Journal Voucher Excise Unit field has been provided to select the appropriate Excise Unit.

  1. In Nature of Removal field select the sales Nature (whether sale was a Domestic/ Captive Consumption/Removal as such / Special Rate etc.) for which the Excise Duty is payable. E.g. Domestic


[Img-82]

Note: In case a company has Excise Duty opening balance against sales of different Nature of Removal - Domestic/ Captive Consumption/Removal as such / Special Rate etc. then separate Excise Opening Balance entry for different Nature of Removal has to be recorded.

  1. To account opening balance of Basic Excise Duty, under Particulars select Basic Excise Duty @ 8% and view Excise Duty Allocation screen


[Img-83]

Note: While accounting Excise Opening Balance, in List of Ledger's only the Excise Type of ledgers will be displayed for selection.

  1. In Excise Duty Allocation screen

  2. Invoice No./Bill of Entry No. & Date: In this field enter the invoice number and date of sale of finished good on which excise duty has been charged

  3. Party Name: In this field select the supplier to whom the sale was made.

  4. Name of Item: Select the Stock item against which duty is payable and accounted as opening balance

  5. Quantity: Specify the Quantity on which Duty is payable

  6. Assessable Value: Enter the Assessable values of the stock item on which the excise duty to be calculated.

  7. Rate: In this field rate of duty defined in the item master will be defaulted, which can be changed if rate of duty is different.

  8. Amount: Excise duty Amount will be calculated and displayed automatically.


[Img-84]

Note: Supports to account Excise opening Balance of multiple bills of different customers of same Nature of Removal with different Finished goods and Different Rate of Duty.

  • Press Enter to save Excise Duty Allocation screen

  1. To account opening balance of Education Cess, under Particulars select Education Cess @ 2% and view Excise Duty Allocation screen

  2. In Excise Duty Allocation screen

  3. Set the option Copy Details from Previous Duty Ledger (s) to Yes and press enter.


[Img-85]

The details like - Invoice Number/Bill of Entry No.& Date, Party Name, Name of Item, Quantity & Assessable Value (to calculate the Education Cess) &Cess Amount will be calculated and displayed automatically.

Note: If you do not want to copy the details of previous duty ledger retain No to the option Copy Details from Previous Duty Ledger(s) & manually enter the Excise Duty details for the ledger selected.

The completed Duty Details for Education Cess @ 2% will be displayed as shown


[Img-86]

  1. To account opening balance of Secondary Education Cess, under Particulars select Secondary Education Cess @ 1% and view Excise Duty Allocationscreen

  1. In Excise Duty Allocation screen

  2. Set the option Copy Details from Previous Duty Ledger (s) to Yes and press enter.

The details like - Invoice Number/Bill of Entry No.& Date, Party Name, Name of Item, Quantity & Assessable Value (to calculate the Secondary Education Cess) & Cess Amount will be calculated and displayed automatically.

Note: If you do not want to copy the details of previous duty ledger retain No to the option Copy Details from Previous Duty Ledger(s) & manually enter the Excise Duty details for the ledger selected.

The completed Duty Details for Secondary Education Cess @ 1% will be displayed as shown


[Img-87]

The completed Excise Opening Balance Journal Voucher is displayed as shown


[Img-88]

The above Excise Opening Balance entry will be displayed in

  • Excise Computation report under Excise Duty Payable against Regular Rate


[Img-89]

  • PLA Register

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications