Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...
 
FAQ-5 ( Excise for Dealers):

How To Record Import (Self Import) Of Excisable Goods In Tally.ERP9?

Let us consider the below an example for entering the purchase details in Tally.ERP 9

 

Total quantity of Material                               : 1000 nos @ Rs. 100 = 1,00,000

 

Assessable Value of the goods imported         : 100000   

Customs duty @ 30% (on assessable value)    :   30000

 

CVD @ 10% (is calculated on Assessable value + Customs Duty)  : 13000.00

Edu Cess on CVD @ 2% (calculated on CVD)                              :     260.00

Sec Edu Cess on CVD @ 1% (calculated on CVD)                       :     130.00

 

Edu Cess on Customs Duty @ 2% (calculated on Customs Duty + CVD + Edu Cess on CVD + Sec Edu Cess on CVD) : 867.80 (F)

 

Sec Edu Cess on Customs Duty @ 1% (calculated on Customs Duty + CVD + Edu Cess on CVD + Sec Edu Cess on CVD) : 433.90 (G)

 

Addl Duty on Imports @ 4%  (Calculated on  Assessable Value + Customs Duty + CVD + Edu Cess on CVD + Sed Edu Cess on CVD + Edu Cess on Customs Duty + Sec Edu Cess on Customs Duty)  :    5787.67

 

Note: The Customs Duty, Education Cess on Customs duty and Sec Edu Cess on Customs duty marked in Red are not passed on, they will be apportioned to the item cost.

CVD, Edu Cess on CVD, Sec Cess on CVD and Addl Duty on Imports are pass on duties.

 

Procedure to record the Imports in Tally.ERP 9.

 

1.         Ensure in F11: Features > Statutory & Taxation, the option Enable Excise and Set/Alter Excise Details are activated with Excise Details of the Dealer Unit (your Company).

Tally.Erp 9 : Excise for Dealers

[6-30]

2.         Create a voucher type for Excise Purchase and Excise Sales.

 

From Gateway of Tally > Accounts Info > Voucher Type > Create. Set Yes to Use for Excise and select Default Excise Unit from List of Excise Units.

Tally.Erp 9 : Excise for Dealers

[6-31]

Similarly create Excise Sales voucher type

 

3.         Create Stock Item

Tally.Erp 9 : Excise for Dealers

[6-32]

Press Alt + C to create a Tariff Classification Master or choose from List of Tariff Classifications

 

Tally.Erp 9 : Excise for Dealers

[6-33]

 

Set Yes to Set/Alter Excise Details. In the Excise Details screen, set Yes to Set/Alter Duty Details

 

Tally.Erp 9 : Excise for Dealers

[6-34]

 

Specify the Duty Details as shown

 

Tally.Erp 9 : Excise for Dealers

[6-35]

Note: Additional Duty of Imports is also known as Special Additional Duty. Special Additional Duty has been renamed as Special AED of CVD in Tally.ERP 9. We suggest you to select Special AED of CVD from the list of Excise Duty in Stock Item Master in Tally.ERP 9. You need to specify the values manually for Special AED of CVD during Excise Purchase Entry since Special AED of CVD is calculated on Assessable Value, all Duties of CVD and all Customs Duties.

 

4.         Record a Purchase Invoice

 

Gateway of Tally > Accounting Vouchers > Press F9: Purchase.

 

Select Excise-Purchase from the list of voucher types

Tally.Erp 9 : Excise for Dealers

[6-36]

Tally.Erp 9 : Excise for Dealers

[6-37]

Create a ledger and specify your excise details in the ledger master since you can declare as Self Importer which is equivalent to Manufacturer. You need to select the same ledger in Manufacturer/Importer Details in Supplementary Details screen.

 

Note: To select Party Ledger press Alt + M keys or click on M: Manual button to view the party list for selection.

 

Select the stock item. Specify Quantity, Rate and Amount. Press enter.

Tally.Erp 9 : Excise for Dealers

[6-38]

In Excise Details screen specify your RG 23 D entry number, the same will get reflected in RG 23 D No. field of Excise Sales Invoice.

 

In Assessable Value field specify Rs.1,30,000 (Purchase Cost + Customs Duty). Assessable value to be calculated manually.

 

Calculate manually the Special AED of CVD amount on Purchase Cost + CVD Duties + Customs Duties as per example given above.

Tally.Erp 9 : Excise for Dealers

[6-39]

Save the Purchase Voucher.

 5.        Record a Sales Invoice

 Gateway of Tally > Accounting Vouchers > Press F8: Sales.

 Select Excise-Sales from the list of voucher types

Tally.Erp 9 : Excise for Dealers

[6-40]

Tally.Erp 9 : Excise for Dealers

[6-41]

Tally.Erp 9 : Excise for Dealers

[6-42]

Select the Stock item. In the Supplier Details screen select the Supplier Invoice Number and specify the Quantity you are selling.

Tally.Erp 9 : Excise for Dealers

[6-43]

Tally.Erp 9 : Excise for Dealers

[6-44]

6.         Press Alt+P to print the Sales Invoice

 

In Voucher Printing Screen press F12: Configure and set the option Print Trader Importer Declaration to Yes.

Tally.Erp 9 : Excise for Dealers

[6-45]

7.         Zoom view of Print Preview of Sales Invoice is displayed as shown.

Tally.Erp 9 : Excise for Dealers

[6-46]

 
 
 
 
[FAQ] : Tally.ERP 9
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
 

Enter your email address:
[ Get Tally.ERP 9 Questions & Knowledge Base Feed delivered by eMail ]

Delivered by FeedBurner

 
 
Disclaimer

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

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. This Website is not associated with any product or vendor mentioned in this Website.

GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com