Last time I have written about how to create a voucher class for auto duty calculation. Voucher class in tally.erp 9 help to prevent error in accounting vouchers and calculate duty automatically. Also it will protect you selecting a wrong accounting head for your entry.Creating a voucher class is not the final or single step. For using voucher class for auto duty calculation, one need to do some basic set up in the accounting data. Today, we will see how to create an item ledger account with excise and vat details. You should also read creating a payment voucher class for better understanding to know how voucher class in tally works out.
Creating an item ledger with excise and vat is very necessary to utilise tally.erp 9’s full feature and to get perfect reporting for Cenvat, ER1 or 3, PLA vat etc.
First of all, you can’t use auto duty calculation for purchase/sales if you haven’t enable accounts with inventory while creating a new company. If your books of accounts are for accounts only then go to alteration of company by selecting F3 from the main menu and alter your company
and enable accounts with inventory as shown in the below screen.
After this select F11 from the main menu of tally and select F2 or inventory features and set yes as highlighted by the pen in the below screen.
and accept the screen
Now from main men press Inventory info and then stock item
Now, create a new stock item by selecting create button
You will find below default screen. type the name of the item. e..g you use to purchase chemicals as raw material then in our example I am creating an item ledger for chemicals
Now select the unit of measurement from the list given say kg, or nos or tons and you haven’t crated any unit then press ALT+C
upon pressing ALT +C you will find below screen to create a new unit for the item
just in the symbol field type kg or other unit as applicable for your actual purchase
Accept the screen
now you will find below screen for tariff classification of item. if you haven’t create any tariff classifications then press ALT+C to create a new tariff classification. you may find your tariff classification from your excise purchase or excise sales bill.
Type name of your tariff classification and set used for both
once you select your tariff classification you will find a sub menu as shown below asksing you to set/alter excise details set it to yes
You will find below screen set kg or other units applicable to your item and press enter
Now it will ask you to set/alter duty ledger, select yes
You will find below default screen. select as valuation type as ad valorem. however if your excise duty is calculated on the base of quantity or MRP then select appropriate valuation type
set the details as shown in the below screen and accept the screen
now select principal inputs for item which belongs to raw material , sales item to finished goods or appropriate item types from the below option
now it will ask you vat details
select commodity as chemicals (for our example )
enter rate of applicable duty say 4% or 5% of 15% whatever applicable.
set addl. tax exempted to no if addl tax is not applicable
accept the screen and 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
Tally is powerful package but the guidance for tally cannot be acess easily>
Dear Satvir,
In fact, tally is the most simple and easy to manage software. I know too many people who become expert in tally without undergoing any professional courses. All it requires some basic rules/understanding of accounting principles and some self efforts to learn. Otherwise tally’s reference manual is a complete help file in itself.
Also, there is lot of site helping free to users on tally.
i want to know more about tda, erp & payroll in tally 9
Hi To All I am New and I have a problem.
When i am generating a sales Invoice I am not able to seperate 14.50 % VAT Items anf 4.00 Vat Items.
(I mean that i am invoicing a 4.00 % VAT Declared Item as 14.50 % VAT) and vice versa.
Is there any solution where i should not be able to invoice a 4.00 VAT item as 14.50% AT.
Please Help.
Regards,
Ananth
Dear Ananth,
Check your duty ledger (go to Accounts info, ledger alter, input vat 4% and input vat 14.5% one by one. after selecting type of duty as vat, check vat class. i guess you have taken vat class as 14.5% for the vat duty 4% and vice versa.
Also check your purchase ledger account in the same way.
Your must have mistake in these account.
Of still facing problem, then please revert back
I have created a forum where you can post this kind of problems and can get a quick solutions also.
I am unable to entry in Tax class 14.5% in Tally 7.2, in Tata Ex NGN 1.0 I am unable to Sale&Print, Print, Printpreview
Krishna Mohan,
Okay, please do let me know your Tally 7.2 Serial number. Looks like you have lost your Tally license.
HI ANANTH.
I wanna know that Under which account head the VAT comes in Tally ?
Regars,
Ronak
please help me sir how to create vat class in tally9
How can I create Vat 14.5% VAt/Class i e: Ledger creation>vat 14.5%>under duties & taxes >vat > how create New 14.5% vat/class
Siva,
It depends upon the version of tally software you are using and from which state you belongs to ?
Dear Mahender Ji,
Firstly I’d like to appreciate your valuable contribution. Second I hv a querry, I dont use Excise details, but hv problem in VAT.
The problem is in Items Invoice after every entry, tally asks for allocation of sales ledger( Eg- Sales@4.5%/Sales@13.5%/etc). I wish tally coud automatically recall ledgers set as default during creation of stock items. It does calculate correct Vat but if a wrong sales classification is selected that can lead to wrong results.
Thanks in advance.
Dear Sam,
Thanks for your inputs and welcome to Free learning tally 9 accountancy community.
There is already an option in tally.erp 9 for your solution.
When you make a purchase/sales entry just Press F12 and then under Purchase/Sales invoice configuration there is option to use common ledger for item allocation and default for bill allocation. set it to yes and it will definately work. to avoid wrong selection of vat clasfication again in the configuration (F12 ) as just explained under other option set “calculation of tax on current sub total ” to yes and set “allow selection of vat/tax class during voucher entry ” to No
I am sure it will definitely work.
If still face any problem then please do not hesitate to revert me.
best regards
i just want to know about tally9. i want to learn tally 9. i want writed help full of tally9.from start(double click start)to check account details please give me help please
thankyou
How to Creat Service Items (i.e. Reparing charges) in Tally? thsoe item should not efect my stock.
dear Mahendara..my question is same as asked above by goutam…i am strongly facing problems in that particular matter.Service items are affect my stock I.E shows with the negative sign and reduce the value of closing stock.Please help me out in this regard
thanks
Shahid fayyaz
Shahid and Guatam,
I do not understand whether you are speaking of service charge income or expenses. better please give me an example exactly what you wanted to do and what problem you are facing.Also if possible , please do explain me the nature of your business too
hi mahendra,
good 2 see u helping others. nice effort by u.
i m unsing tally 9.0 in uttrakhand. i m not able to make new vat class for 13.5% and 4.5%
could u pls help me.
thanks
vaishnav goel
very good
dear sir,
how to learn in profesinal exise duty?
hai i have one problem in tally i entered purchase with 4 % vat and entered as with vat amount but i take printout without vat amount send reply
sir, i want know about excise returns means how to calculate how to creat excise returns Please sir i really need to this
dear sir how to create in 14% vat ledger. i mean new vat number in main ledger .last year i will prepared 13.5% vat invoice but now 14% ledger how create i dont no kindly send the salution .
how to make a debit entry after cenvat credit taken in tally erp9 for excise purchase invoice which materials send for labour job?
We are using Tally 9 Version. Now in Tamilnadu the % of Vat from 4% has increased to 5% i want to create Vat @ 5% output tax in my ledger account. In that Vat Class the Vat 5% has not created how can i create that. please help me.
Sir,
I work with tally9. Since 5 days what had happened I don,t konow my stock summary shows the value as same as I entered but rate is reduced and item quantity is showing increasing. Pls help me. Expecting reply by my mail id also
Meanwhile 14.5% is not showing evenafter did the steps you’ve given.
Pushpa,
You need to you the latest Tally.erp 9 to enable 14.5%
I work with tally9. In puchase ledger whenever I enter puchase voucher shows error message and closes. then came to know that 12.5% ledger is not available or corrupter. how to recover it. pls help me.
Sir,
My queries are not answered. pls help me the following problems.
1.Iam working with Tally 9 Version. Now in Tamilnadu the % of Vat from 4% has increased to 5% i want to create Vat @ 5% output tax in my ledger account. In that Vat Class the Vat 5% has not created how can i create that. please help me.
2.I work with tally9. In puchase ledger whenever I enter puchase voucher shows error message and closes. then came to know that 12.5% ledger is not available or corrupter. how to recover it. pls help me.
Pushpa,
Which Tallly version you are using?
You need to upgrade your software.that It’s only solution to your question.
Sir
How we get automatic the final rate & percentage of vat when we make sale voucher
Hi Sir,
Pls let me know the procedure to create the VAT Class for 5% (sales and purchases) in Tally 9.
Thank you
Dear Sir,
I am using Tally ERP9 3.2 Latest release & series A . VAT in Karanatak has been changed from 14% to 14.5% and 5% to 5.5% , pls. help me to include this new VAT Rate. Tally entries are been kept pending as I am unable to enter with the above changes. Pls. assist me immediately.
Bhanumathi,
Plz download latest Stat release 177
your TNS must be active before your download it
Hi
Sir good afternoon
sir mujhe vat return nikal ne hai . kaise
i use tally 7.2, able to put vat at 4% and 12.5%…am from tamilnadu.. now the vat is changed to 5 and 14.5%… how can i get 5 %and 14.5%… in tally 7.2
How can I create Vat 14.5% VAt/Class i e: Ledger creation>vat 14.5%>under duties & taxes >vat > how create New 14.5% vat/class
How can I create Vat 14.5% VAt/Class i e:vat class 12.50% to change (alter) 14.50% tax rate
You can’t create class. If you are using a Licensed software then update your software to the latest release
And it will reflected in your Software
I have items with vat inclusive rate. How can I make tax invoice with tally calculating vat amount and basic rate automatically. While making tax invoice I have to type vat rate for every item every time I make tax invoice. Can I fix vat rate for item permanently.
Sir,
How to create 14.50% in tally, in vat form