Do you want to Learn Tally TDL?

Tour and Travels Management in Tally.ERP 9

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 :-

tours and Travels Management in Tally.ERP 9
image-3678

www.tallynine.com

The items are created as follows, we show the multi Item creation mode for faster creation as I->I->R

tours and Travels Management in Tally.ERP 9
image-3679

www.tallynine.com

Sales order voucher alteration as :-

How to alter voucher Type
image-3680

www.tallynine.com

The sales order numbering may be set as :-

 Auto Numbering in Tally.ERP 9
image-3681

www.tallynine.com

The Sales order is created as :-

tours and Travels Management in Tally.ERP 9
image-3682

www.tallynine.com

Now individually the details for each item is entered as:-

tours and Travels Management in Tally.ERP 9
image-3683

www.tallynine.com

Just in case you ( you want to know how a service ledger is created:-

Service Tax Ledger in Tally.ERP 9
image-3684

www.tallynine.com

Now we go to accounting vouchers and then Press F8:-

How to Pass Sales Entry in Tally.ERP 9
image-3685

www.tallynine.com

The sales order- is tagged with the sales voucher :- The breakup of this voucher is shown as :-

Item Allocations in Tally.ERP 9
image-3686

www.tallynine.com

The allocation for Hotel charges

Tour and Travels Management in Tally.ERP 9
image-3687

www.tallynien.com

As of now the service tax payable is shown as D–>O–>Service Tax Computation :-

Tour and Travels Management in Tally.ERP 9
image-3688

www.tallynine.com

 

Now a partial receipt is made as:-

Tour and Travels Management in Tally.ERP 9
image-3689

www.tallynine.com

The second receipt is made after 2 days :

Tour and Travels Management in Tally.ERP 9
image-3690

www.tallynine.com

Now the service tax payment is made to the Govt. using the autofill feature:-

Tour and Travels Management in Tally.ERP 9
image-3691

www.tallynine.com

 

Alternatively You may use the simpler method to make the payment as :-

Tour and Travels Management in Tally.ERP 9
image-3692

www.tallynine.com

Now we view the service tax computation after the payment is made and it shows:-

Tour and Travels Management in Tally.ERP 9
image-3693

www.tallynine.com

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.

Tour and Travels Management in Tally.ERP 9
image-3694

www.tallynine.com

 

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:-

Tour and Travels Management in Tally.ERP 9
image-3695

www.tallynine.com

 

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.

About the Author

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 :) )

Leave a Reply 3 comments

puttaswamy gowda - 4 years ago Reply

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

Pavithra.S.B - a few months ago Reply

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.

Mahendra Rana - a few months ago Reply

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

Leave a Reply:







Learn Tally for Free
sign up for our newsletters
Join our email list to get the free Tally Tutorials straight to your inbox
SUBSCRIBE
Give it a try, you can unsubscribe anytime.

TAKE 15%
OFF

on your first purchase
Get Coupon
error: Alert: Content is protected !!