How to create excise duty ledger in tally.erp 9?

Posted on April 18, 2010 by Mahendra • 25 Comments

Sometimes back I have write aboutauto duty calculation voucher class creation to avoid any mistake while posting sales and purchase register. Auto duty calculation voucher class also help you for speedy entry and protect you to enter any wrong entry or select wrong accounting head.

To create an auto duty calculation voucher class, user is also required to create an item ledger with duty details otherwise the auto duty calculation voucher class will not work. Further user must create excise duty ledger correctly in tally.erp 9 otherwise no use of auto duty calculation voucher class

Many tally users are not aware with the right path for creating excise duty ledger in tally.erp 9. Some accountant create an excise duty ledger under purchase or sales group which is totally wrong treatment.

Creating excise duty in tally.erp 9 under duties and taxes is the correct path if are you serious about accounting and want to prepare your balance sheet perfectly.

Here I will explain you step by step procedure for creating excise duty ledger in tally.erp 9

Go main menu of tally, Ledger Create new account

Type excise duty @10% in the name field of ledger (It doesn’t matter sales or purchase excise )

in tally.erp 9 excise duty ledger will be captured in sales and purchase transactions and you don’t need to create separate duty ledgers but you must group excise duty ledger under Duty and Taxes.

There will be two types of duty tax for excise purpose.

One is CENVAT : it is used for set off of excise duty paid on purchase. for e.g. when you want to claim excise duty paid on purchases of items have to be set off, then you should select type of duty/tax as CENVAT and another is without CENVAT.

Without CENVAT : when you purchase some materials on which you pay excise duty and these duty is by its nature is not available for set off then you have to select type

Select type of duty as Cenvat

Ignore accounting code. you may refer tally solution’s site for correct accounting code however I do not consider it material.

Select the duty type as Basic Excise duty from the pop up window.

Select % of calculation as applicable e.g. 10% here

It will capture method of valuation as On Assessable Value automatically . You will not be able to change it or select your own in any case.

ITs all done ! in the same way, create duty ledger for Cess @2%, S.E.Cess 1%

ITs all done!

Mahendra (192 Posts)

Mahendra is founder and CEO of the I Vision Infotech, Authorised Tally Sales and Service Partner and helping Tally users to learn Tally and accounting free through this site

Anil

Dear Sir

can we removed Excise material (Goods) next day if we take completion (manufacture receipt ) today.

Anil Shekhawat

share flag

spam
offensive
disagree
off topic

Raunak

How can i use double Entry of Exice duty & Service Tax in Tally ERP 9

vivek

please guid me sir to making entries of fbt in tally erp in details

Mahendra

Vivek,
FBt is no longer exist in Inida ! why you want to pass entries for the same ?

How to create Sale & Purchase in excise format in Tally Erp 9.
Details Step of Excise Sale bill & Purchase bill in manufacturing company

Please Guide me

Vivek ,
A detailed and comprehensive guide on Excise is already available for Free on Tally Solution's site. please down load that study the same do the needful. if still you can't do that, then you should hire a professional to guide you!

Anjan Das

Bhavesh

How to create TDS Duty Ledger in tally erp
it is for the Print 16A In tally my self.
Please guide Me

PARVEEN KUMAR

how to send mail from using tally button M-email from tally pleas give me reply as soon as possible

manoj

kindly guide me in tally password remove for create company

shraddha kadam

hi,
i have query
i m selling a one product that name is spill kit. this contents a gloves, mask,absorbent mat. etc. this all product buy separately. but we sale as hole one product that name is spill kit. so the query is that how i make entry in tally in purchase & sale.& another thing is that the absorbent mat purchase this payment made.so please, help me

Prabhat

Creating a Sales Ledger

To Create a Sales Ledger

Go to Gateway of Tally > Accounts Info > Ledger > Create

Enter the Name of the sales ledger you wish to create.

Select the group under which you are creating the sales ledger.

Set the option Used in VAT Returns to Yes, if you want to select VAT classifications for this Ledger.

Once you set this to Yes, Tally.ERP 9 prompts with VAT/Tax Class screen.

Select the required classification from the drop down list under the field VAT/Tax Class. The drop down list consists of the Sales classifications pertaining to Delhi state. If you do not wish to select a classification at the Ledger level, select Not Applicable.

Press Enter to accept and save the ledger.

Creating a Tax Ledger

To create a Tax Ledger Master,

Enter the Name of the Tax ledger you wish to create.

Select the group Duties and Taxes from the list in the field Under.

On the selection of group Duties and Taxes, you will get the option to select Type of Duty/Tax. Select Others from the list.

Accept to save the changes.

Creating a Expense Ledger

To create an Expense ledger,

Enter the Name of the expense ledger you wish to create.

Select the group under which you are creating the party ledger.

Creating a Customer Ledger

To create a Party ledger,

Enter the Name of the party ledger you wish to create.

Enable Maintain balance bill-by-bill? to Yes, enter details in the Default Credit Period if applicable. By default the Inventory Values are affected? field is set to No.

Enter the Mailing Details and Tax Information

Rakesh Kumar

i am new for excise

Kindly guide me how to learn excise eg. billing , filing of monthly returns,maintaining excise registers

Please Suggets me how i can learn about it

Rakesh,
For tds, please refer www.simpletaxindia.org.
One of the best source to get all about Income tax matter

Md Mobarak Hussain

i am facing so many problem while i am going to sale finished goods in tally 9.0, exmaple

we are manufacturing rod, & ingots so we are purchasing raw material of Iron Ore,
after purchased we are transfering to charging to oven godown, after progressing it make finished goods like rod or ingots, while i am selling the finished goods at that time finished item do not shows in sales voucher, here is shows only raw material item in place of finished goods item
pls reply me soon

Md Mobarak,
You need to pass inventory vouchers for transfer of materials to one go down to other and also for manufacturing of product.

SWATI

EXCISE MANUFACTURING IN TALLY ERP9 TO ER1 FORM

Swati,
Please quote your tally serial number.

RUPESH

PLEASE GIVE GUIDELINE OF SETTING OF CHEQUE PRINTING. PLEAGE GIVE DETAIL WITH BRIEF SO I CAN SET ANY TYPE OF BANKING CHEQUE. THANKS & REGARDS

Dear Rupesh,
Every bank has different different cheque size and dimensions and no one in this world can use same dimensions which help you to print cheque of any bank ! You have to set dimensions of each bank separately

MUSTAFA

i get a party bill and he is charging me multiple taxes but i cant do that in tally example

nett bill 20,000
less 10% -2,000
Add Cenvet 10% +2,000

EduCess 2% 40
HS Cess 1% 20

But in tally HS gets calculated as Rs. 0.40 tht means its calculates on the figure above and not on cenvet how do i correct this ?

Dear Mustafa,
I will encourage all tallynine readers to post their support forum for a quick response. Many times I remains much busy. If you post it on a forum then you may get a quick solutions to your problem.Alternatively You may contact me on Gtalk at mkr2005