Today, we will study the case study of how to maintain Tour and Travels Management in Tally.ERP 9 along with practical examples. This is a pure service industry and there is no inventory as such, they have specific billing requirements and have a rebate of 60% to 75% even this is changeable.
We will take a case where a booking is done by a customer for traveling, food and other expense.
We will charge all of that and in addition to that charge a service tax. Now there is a rebate of 60% in this department. If you have a greater rebate, you can mention that with the SL/Notification number and can avail that abatement.
We have taken the customer by the name of Traveller.
Now when the customer comes to us, we do the booking of this – this is a sales order for us.
We create the ledgers as :-
The items are created as follows, we show the multi Item creation mode for faster creation as I->I->R
Sales order voucher alteration as :-
The sales order numbering may be set as :-
The Sales order is created as :-
Now individually the details for each item is entered as:-
Just in case you ( you want to know how a service ledger is created:-
Now we go to accounting vouchers and then Press F8:-
The sales order- is tagged with the sales voucher :- The breakup of this voucher is shown as :-
The allocation for Hotel charges
As of now the service tax payable is shown as D–>O–>Service Tax Computation :-
Now a partial receipt is made as:-
The second receipt is made after 2 days :
Now the service tax payment is made to the Govt. using the autofill feature:-
Alternatively You may use the simpler method to make the payment as :-
Now we view the service tax computation after the payment is made and it shows:-
Here notice that Balance service tax payable is nil now 🙂
Now let us analyze the balance sheet as on 4th of the month where the payment was not made to the Govt.
The amount Rs. 17165 was pending to be received from the debtor, however, the Profit would remain the same.
After the receipt of the pending due and making the tax payment,
finally, the balance sheet as on 30th April gives us the report as:-
PS* Please note all articles on the site are based on imaginary scenarios & are for educational purpose only.The author holds no responsibility in any form whatsoever.
Hi Just like you, I am one of the souls on EARTH who has a desire to be able to maintain my accounts accurately and be most efficient in using the powerful features of Tally. Currently I work as an accountant at a firm in Durgapur. I am a Tally lover and would be happy to solve your queries related to Tally, however I may not be able to reply to all the queries instantly but will surely try to solve them and give u a solution( provided I get free time from my daily work 🙂 )
it is very good for new learner i request you kindly sent Export sale entry and import purchase entry in tally erp9 and forex loss/gain how to adjust in tally and forgin curency conversion to indin currency in tally these are very important handling import and export procedure and also concept of bill of entry and shipping bill in tally erp9 therse are using custom duty.other wise you suggest tally book above portion should include i would like purchase.
Regards
puttaswamy gowda
good evening sir, I am pavithra working in a travel agency as an accountant. Now we are using excel for accounts.I have worked as a tally teacher in tally academy for 3 years so I knew tally and I love tally. Now where I am working that is travelling agency here we have attached vehicles.The billing is different from the normal company, We have so many types of vehicles and different rates also, we should calculate hours and kilometer also. So I would like to know that can we use Tally for this agency.Please guide me in this matter.
Yes, you can use Tally.ERP 9 but you may need some customization to meet your requirements if you want the desired reports directly generated within the Software
Hello…..
I am a travel agent, And I want to maintain passenger’s travel details like, PNR, Travel date, Number of passengers ect. With accounting option. Is this possible in Tally?
Yes its possible for tally, if interested contact me
Car Rental Hyderabad Telangana India, If required any car rental service from hyderabad please contact us
hyderabad Car Rental
Thanks Alot Sir. This had help me to sort a starting entry of Travel & Tour Agency… I am also a tally lover and loved to used tally…since 10 years till now…
Akoade-Make Free Ready Made Web&App
Good Information
Cheap Web Hosting Start at Rs.39/Month
Hi, we are a start up travel agent based in mumbai. we are looking for tally based invoice for all the service, like hotel booking, cab service , visa , packages and etc. kindly help us with the tdl and platform for the same.
Hello Kunal,
It doesn’t work that way.
you will have to share the format of the invoices you want only then people can help you.
Yes its possible for tally, if interested contact me