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

How to record transfer of excisable goods using Tally.ERP 9? 

Excisable goods when transferred from one godown to another attract excise duty. Manufacturers are liable to pay excise duty on movement of stock to another godown. You can record Excise Stock Transfer in Tally.ERP 9 using a user defined Voucher Type.

To record Excise Stock Transfer in Tally.ERP 9, the following prerequisites have to be set up:

·         Enable Job Order Processing in F11: Features > F2: Inventory Features

·         Create Excise Stock Transfer voucher type

·         Create a Godown/Branch Excise unit to which the goods are transferred

Note: The above listed masters/configurations are required to record transfer of excisable goods in Tally.ERP 9. Masters/configurations that are needed for other excise transactions in not explained here.

a. Enable Job Order Processing in F11: Features > F2: Inventory Features

Tally.Erp 9 : Excise for Manufacturers


b. Create Excise Stock Transfer voucher type

To create Excise Stock transfer voucher type, go to Gateway of Tally > Accounts Info. > Voucher Types > Create

1.     Enter the name for the voucher type as Excise Stock Transfer in the Name field


2.     In the Type of Voucher field, choose the option Material Out from the List of Voucher Types


3.     Enter an abbreviation form of voucher type name in the Abbr. field


4.     In the Method of Voucher Numbering field, choose the option Automatic and retain Use Advance Configuration settings


5.     Set the options Use EFFECTIVE Dates for Voucher?, Make Optional as default? and User for Job Work? as No


6.     Set the option User Common Narration as Yes

Two additional fields Default Excise Unit and Use for Stock/Branch Transfer? are enabled.

8.     In the Default Excise Unit field, choose the name of the godown where the goods are manufactured


9.     Set the option for Stock/Branch Transfer to Yes


10.     In the Excise Declaration field, enter the declaration to be printed in excise invoice


11.     Save the screen to create the new voucher type

c. Create a Godown/Branch Excise unit to which the goods are transferred

To create a godown/ excise unit, go to Gateway of Tally > Inventory Info. > Godowns / Excise Units > Create 

1.     Enter a name for the godown in the Name field


2.     In the Under field, select the option primary


3.     In the Excise Registration Type, select the option Not Applicable


4.     Under User for:, set the option Our Stock with Third Party as Yes

5.   Accept the screen to the save the new godown master.

7.     Set the option Use for Excise as Yes

Excise Stock Transfer and Booking the Duty Liability

Recording stock transfer of excisable goods involves one transfer transaction and an adjustment entry to book the liability.

To record the transfer of goods, go to Gateway of Tally > Inventory Voucher > Ctrl+J: Material Out > Excise Stock Transfer 

1.     Press F2 or click F2: Period button to change the date

The Excise Unit filed is prefilled with company name. The Excise Book Name and Serial No. fields are automatically filled based on the details provided in F11: Features.

2.     In the Party A/c field, select the recipient of the transferred goods

A Party Details sub screen will appear.

    • Enter the required details in the Party Details sub screen and accept to return to main screen

3.     In the Nature of Removal field, select the Domestic from the types of removal list

4.     In the Destination Godown field, select the excise unit/godown created to receive the goods

5.   Under Name of Item, select the item that is to be transferred.

An Item Allocation sub screen will appear.

·         In the Order Number field, select not applicable

·         Under Godown, select the Godown name from where the goods are transferred

·         Under Quantity, enter the number of units to be transferred

Rate and value will appear automatically.

  • Accept the details to return to main screen

6.     Similary, select other items to be transferred and furnish the quantity and source godown details in item allocation screen respectively.

7.   In the main voucher entry screen, select the duty ledgers Basic Excise Duty, Education Cess and Secondary Education Cess whichever is applicable.

In case these ledgers are not available you have to create these ledgers and continue with the transaction entry.

8.     Set the option Show Statutory Details? to Yes

A Statutory Details screen appears with a break up of Voucher value into assessable value and excise duty value.

·         Accept the details

9.     Save the transaction

Excise Computation

When excisable goods are transferred an excise liability is created but not booked. The details of excise duty not booked can be generated in computation report under Excise Duty Payable section - a separate line item Stock Transfer but Duty Liability not Booked under Stock Transfer of Excise Sales with Assessable Value and Duty Amount is displayed.

In case a part of liability is booked, the booked value is shown against Stock Transfer and Duty Liability Booked. The remaining unbook liability is shown in the line Balance Liability not Booked (a).

Tally.Erp 9 : Excise for Manufacturers


Booking the Liability

When an Excise Stock Transfer is recorded, to raise the liability for the Excise payable, you should record a Journal voucher entry using CENVAT Adjustment Voucher Class.

To book the Liability for Stock Transfer, Go to Gateway of Tally > Accounting Vouchers > Journal Voucher > CENVAT Adjustment class 

1.     In Used for field, select the option Excise Duty on Movement of Stocks from Excise Adjustments list.

2.   In Excise Unit field, select the name of the company or source godown form the excise units list.

Tally.Erp 9 : Excise for Manufacturers


3.     Click on L: Excise Helper or press Alt+L.

4.   In the Goods Transfer Helper screen, select Excise Payable ledger in the Expense Ledger field and select appropriate period.


Tally.Erp 9 : Excise for Manufacturers



5.   A notification dialog box will appear with a message - Proceed to Availing Debit Excise Duties on Movements of Stocks. Press Enter or click on Yes.


Tally.Erp 9 : Excise for Manufacturers


6.     Save the transaction.

Tally.Erp 9 : Excise for Manufacturers


Once the Duty liability is booked, the details of Excise Stock Transfer will be displayed in the Excise Computation report.

Tally.Erp 9 : Excise for Manufacturers


[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