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

How to Account Shortage/Loss/Wastage of Excise Stock?


Is it possible in Tally.ERP 9 to account the loss or wastage or theft of Excise Stock Item on which CENVAT Credit is not passed on?


Normal loss of goods occurs because of some inherent, natural or unavoidable reasons. Loss of goods occurs either during the course of shipping from damage or theft etc.

Examples: Loss are of coal in loading and unloading, Loss of spirit or petrol due to evaporation, Loss of timber in cutting into pieces and so on.

In Tally.ERP 9 you can account the Loss, theft, shortage or wastage of Excisable Stock Items.

Example: On 15-10-2010 ABC company purchased 20,000 Kgs  of Hot Rolled Coils @ 100 per kg from Sterling Steel Industries. Against this purchase ABC company sold 19,950Kgs of Hot Rolled Coils to the goods to 2 customers in installments of 4,000kgs per load. 50 Kgs were lost during cutting the Roll.

On 21-10-2010 ABC Company wants to account the Loss of 50KGs of Hot Rolled Coils on which the CENVAT Credit is not passed on.

To account the loss of Excise Stock Item follow the given Procedure

Step 1: Record the Excise Purchase

Record the purchases as shown below in Excise - Purchases Voucher

Tally.Erp 9 : Excise for Dealers


Step 2: Record the Excise Sales

Record the sales as shown below in Excise - Sales Voucher

1. Goods Sold to Customer - Decora Equipments

Tally.Erp 9 : Excise for Dealers


Similarly, on 18-10-2010 4000 Kgs of Hot Rolled Coils were sold @ 600 per Kg

2. Goods Sold to Customer - Sundar Steel Traders

Tally.Erp 9 : Excise for Dealers


Similarly, on 18-10-2010 4000 Kgs of Hot Rolled Coils  & on 19-10-2010 3950 Kgs were sold @ 750 per Kg

Step 3: Create Direct Expenses Ledger (to account loss of Excise Stock)

To account the loss of Stock create a ledger under Direct Expenses as shown below

  Tally.Erp 9 : Excise for Dealers


Step 4: Create Voucher Class in Journal Voucher

Loss/Wastage/Shortage/Theft of Excise Stocks can be accounted in Journal Voucher by creating a voucher class.  

To create the Voucher Class in Journal voucher type

Go to Gateway of Tally > Accounts Info.> Voucher Types > Alter > Journal

·         In Voucher Type Alteration screen, tab down to Name of Class field and specify the class name as Loss/Wastage Adjustment and press enter to view Voucher Type Class screen

·         In Voucher Type Class screen

o    Set the option Use Class for Dealer Excise Adjustments to Yes

Tally.Erp 9 : Excise for Dealers


  • Press Enter to save.

Step 5: Record the transaction in Journal Voucher

Go to Gateway of Tally > Accounting Vouchers > F7: Journal

  • In Change Voucher Type screen select Loss/Wastage Adjustment in Class field

  Tally.Erp 9 : Excise for Dealers


  • To identify the type of voucher recorded in Used for field Shortage/Damage/Loss of Excise Stock will be displayed automatically and cursor will not move to Used for field.
  • In Excise Unit field select the appropriate excise unit for which the loss/wastage/theft is accounted. Select ABC Company

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

  • In Debit field select direct expenses ledger - Loss of Goods
  • In Debit Amount field enter Rs. 5,000 (50*100)
  • In Credit field select the Purchase Ledger - Purchases @ 5% (selected while accounting the purchase of stock items which are lost) to reverse the purchase cost. Press Enter to view Inventory Allocations screen
  • In Inventory Allocations screen
    • In Name of Item field select the Stock Item which is lost or wasted e.g. Hot Rolled Coils

Tally.Erp 9 : Excise for Dealers


  • After selection of stock item press Enter to view Supplier Details screen
  • In Supplier Details screen
    • In Supplier Invoice Number/Date field select the Purchase bill against which the goods are lost or wasted. In this case ABC Company has lost goods against the Purchase Bill -SS/7584/10-11 dated 15-10-2010
    • On selection of Bill, Supplier Name/Nature of Purchase and Shortage Quantity will be displayed.
    • In this case the Quantity Available for the bill - SS/7584/10-11 is 50 and the Shortage Quantity is also 50. Hence accept the same.

Tally.Erp 9 : Excise for Dealers


Note: In Shortage Quantity field the Quantity Available under the selected bill will be defaulted. if the goods lost/wasted/shortage is different than the goods available quantity then specify the same in Shortage Quantity field. Example: For Bill-00125 the Available Quantity is 200 but the goods lost is only 80 then in Shortage Quantity field specify 80.

  • Press Enter to accept the Supplier Details screen and to view Stock Items Allocations screen
  • In Stock Item Allocations screen
  • In Quantity field specify the quantity of goods lost/wasted/short i.e. 50 kg
  • In Rate field mention the Rate at which the goods was purchased i.e. Rs. 100 per kg
  • Amount will be calculated and displayed automatically.

Tally.Erp 9 : Excise for Dealers


  • Press Enter to accept Stock Item Allocations and Inventory Allocations screen

The completed Excise - Journal voucher is displayed as shown

Tally.Erp 9 : Excise for Dealers

  • Press Enter to save.

The above Refund/Reversal entry will affect the following Excise Reports:

Excise Stock Register

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