Do you want to Learn Tally TDL?

Learn Tally TDL online.


India's first online Training portal teaching complete Tally TDL online.

Learn it with  a guarantee. Join now and access a host of benefits.

 

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

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

www.tallynine.com

Sales order voucher alteration as :-

How to alter voucher Type

www.tallynine.com

The sales order numbering may be set as :-

 Auto Numbering in Tally.ERP 9

www.tallynine.com

The Sales order is created as :-

tours and Travels Management in Tally.ERP 9

www.tallynine.com

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

tours and Travels Management in Tally.ERP 9

www.tallynine.com

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

Service Tax Ledger in Tally.ERP 9

www.tallynine.com

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

How to Pass Sales Entry in Tally.ERP 9

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

www.tallynine.com

The allocation for Hotel charges

Tour and Travels Management in Tally.ERP 9

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

www.tallynine.com

 

Now a partial receipt is made as:-

Tour and Travels Management in Tally.ERP 9

www.tallynine.com

The second receipt is made after 2 days :

Tour and Travels Management in Tally.ERP 9

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

www.tallynine.com

 

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

Tour and Travels Management in Tally.ERP 9

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

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

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

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.

I LOVE TALLY

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

Click Here to Leave a Comment Below
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 - 7 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 - 7 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 Comment:

error: Alert: Content is protected !!