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

How To Account Purchases From Manufacturer Depot?


Manufacturer Deport is a supplier who is registered excise dealer and for all the sales made depot issues the rule 11 invoice

Tally.ERP 9 allows recording the excise purchases made from a manufacturer depot and pass on the CENVAT Credit on Sale of Goods.

Example: On 22-4-2010 ABC Company purchased 5000 kgs of Hot Rolled Coils @ 375 from Sterling Steel - Depot. The Manufacturer is Sterling Steel Industries and the Assessable value on the goods sold is 14,00,000.

Step 1: Create a Manufacturer Depot Ledger

Go to Gateway of Tally > Accounts Info. > Ledger

1.         Enter the Name of the Supplier in the Name field e.g Sterling Steel - Depot and group it under Sundry Creditors.

2.         Enable Set/Alter Excise Details to Yes to display the Excise Details screen.

3.         In Excise Details screen enter the details as shown below

Tally.Erp 9 : Excise for Dealers


4.         Press Enter to accept and save

NoteManufacturer Depot may be registered excise dealer or not. In this case Sterling Steel - Depot is a Excise Registered Dealer so the excise registration details are provided.

Step 2: Record the Transaction in Excise Purchase Voucher

Go to Gateway of Tally > Accounting Vouchers > F9: Purchase

1.         Select the Excise - Purchase as the Voucher Type from the list of types. Select Alt + I: Item Invoice if it is in Acct Invoice mode

2.         Enter the Supplier Invoice No.  as SD/9635 and Date as  22-4-2010

3.         Select the Party’s A/c Name from the list of Ledger Accounts e.g. Sterling Steel - Depot

4.         The Supplier’s Details sub-form will appear. Supplier’s Details will include the supplier contact details, Sales Tax number and the Excise registration details. The details will appear automatically if they are provided during the Supplier Ledger Creation. If the supplier of the goods is not the manufacturer, specify the details of the manufacturer of the goods in the Manufacturer / Importer details section.

For this purchase Indus traders are not the manufacturer. Manufacturer is Sterling Steel industries. Specify the details of the manufacturer

Tally.Erp 9 : Excise for Dealers


5.         By default the Nature of Purchase will be displayed as Manufacturer Depot as defined in the party ledger. This field defines the Supplier’s role in selling the product.

Tally.Erp 9 : Excise for Dealers


6.         In Name of Item field select Hot Rolled Coils form List of Excise Stock Items.

Specify Quantity as 5,000 and Rate as 375. Amount will be calculated and displayed.

7.         In Excise Details screen

  • Enter RG 23D Entry No. Supplier Invoice Number will be captured form the Supplier Invoice No. field if entered. Other wise enter the supplier Invoice number
  • By default the voucher date is displayed as the Supplier Invoice Date
  • In PLA/ RG 23D Entry no. field enter the PLA number where the reference of duty paid on the goods sold are entered.
  • Enter the Assessable Value (it is the amount on which the Excise Duty is calculated by the manufacturer) on which the Excise Duty is calculated. Enter Rs. 14,00,000
  • Duty Amount will be calculated and displayed automatically.

  Tally.Erp 9 : Excise for Dealers


The completed purchase voucher is displayed as shown

Tally.Erp 9 : Excise for Dealers


8.         Press enter to accept

Step 3: Sale of Goods purchased from - Manufacturer Depot

On selling the goods purchased form Manufacturer Depot in Rule 11 invoice the print title will be First Stage Dealer

1.         In Excise - Sales Invoice select the party as Decora Equipments

2.         Select the sales ledger

3.         In Name of Item field select Hot Rolled Coils and in Supplier Details screen select the purchase bill of purchases made from Manufacturer Depot and Quantity field enter the quantity sold. Here 3000 Kg is sold.

Tally.Erp 9 : Excise for Dealers


Completed Sales Voucher appears as shown

Tally.Erp 9 : Excise for Dealers


On Accepting the voucher the Rule 11 invoice generated appears as shown

Tally.Erp 9 : Excise for Dealers


[FAQ] : Tally.ERP 9

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

Delivered by FeedBurner


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.

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      
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