Sometimes back I have write about auto duty calculation voucher class creation to avoid any mistake while posting sales and purchase register. The 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, The 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 the right path for creating excise duty ledger in Tally.erp 9. Some accountant creates 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 to the 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 the 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 the 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 duties 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 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
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
PLEASE GIVE GUIDELINE OF SETTING OF CHEQUE PRINTING. PLEAGE GIVE DETAIL WITH BRIEF SO I CAN SET ANY TYPE OF BANKING CHEQUE. THANKS & REGARDS
RUPESH
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
EXCISE MANUFACTURING IN TALLY ERP9 TO ER1 FORM
Swati,
Please quote your tally serial number.
Creating a Customer Ledger
To create a Party ledger,
Go to Gateway of Tally > Accounts Info > Ledger > Create
Enter the Name of the party ledger you wish to create.
Select the group under which you are creating the party ledger.
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
Press Enter to accept and save the ledger.
Creating a Expense Ledger
To create an Expense ledger,
Go to Gateway of Tally > Accounts Info > Ledger > Create
Enter the Name of the expense ledger you wish to create.
Select the group under which you are creating the party ledger.
Press Enter to accept and save the ledger.
Creating a Tax Ledger
To create a Tax Ledger Master,
Go to Gateway of Tally > Accounts Info > Ledger > Create
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 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.
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.
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 http://www.simpletaxindia.org.
One of the best source to get all about Income tax matter
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
kindly guide me in tally password remove for create company
how to send mail from using tally button M-email from tally pleas give me reply as soon as possible
How to create TDS Duty Ledger in tally erp
it is for the Print 16A In tally my self.
Please guide Me
Bhavesh
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
Anjan Das
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!
please guid me sir to making entries of fbt in tally erp in details
Vivek,
FBt is no longer exist in Inida ! why you want to pass entries for the same ?
How can i use double Entry of Exice duty & Service Tax in Tally ERP 9
Dear Sir
can we removed Excise material (Goods) next day if we take completion (manufacture receipt ) today.
Anil Shekhawat
Dear Sir
I have one product type Purchase (Raw Material) of excise Bill but different type of duty suppose 12.1631%, 12.9323%, 13.3486%. How will manager in tally erp 9
Bhupender
sir,how to creat excise duty ledger? In Nepal here is separate rull for excise duty.if any company purchase exciseable items company should paid per kg one rs,before vat.so plz give me guidelines
regards,
prakash chaudhary
nepal
dear,sir
How to create a exices sale tax plz tell me in detais
regards
devendranath
Dear Sir,
how to create a sale & Purchase excise
how to create a excise duty
so plz tell me in details
regards
devendranath
raipur
HOW CAN CREAT EXICE BILL IN TALLY PLEASE SUGGESE ME AS SOON AS POSSIBLE
Dear Sir,
I have a query in excise purchase duty payment entry. when I have a payment enrty for excise it shows that there is a negative tax payment. Kindly help me how I have to do for excise payment.
sir, i want to learn the accounting work. Can you explain me the procedure. How did i learn the account work
plz sir tally 9 .ERP Uttlltles how to use and what use.