Tour and Travels Management in Tally

This is a purely 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 travelling, 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 :-

1 traveller ledger 255x214

www.tallynine.com

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

2 item masters 560x180

www.tallynine.com

Sales order voucher alteration as :-

3 SO alteration

www.tallynine.com

The sales order numbering may be set as :-

4 SO auto 560x115

www.tallynine.com

The Sales order is created as :-

5 SO creation 560x243

www.tallynine.com

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

6 Service details 560x170

www.tallynine.com

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

7 service tax

www.tallynine.com

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

8 sales voucher 560x252

www.tallynine.com

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

9 sales order allocation 560x122

www.tallynine.com

The allocation for Hotel charges

10 sales allocation 560x226

www.tallynien.com

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

12 1 service tax payable 560x225

www.tallynine.com

 

Now a partial receipt is made as:-

11 PARTIAL RECEIPT 560x194

www.tallynine.com

The second receipt is made after 2 days :

12 second receipt

www.tallynine.com

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

13 payment voucher 560x128

www.tallynine.com

 

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

14 ALTERNATIVE payment simpler 560x128

www.tallynine.com

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

15 service tax paid 560x238

www.tallynine.com

Here notice that Balance service tax payable is nil now icon smile
Now let us analyse the balance sheet as on 4th of the month where the payment was not made to the Govt.
The amount of Rs. 17165 was pending to be received from the debtor, however the Profit would remain the same.

16 balance sheet on4th 560x99

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

17 balance sheet 30th 560x99

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 of  any form whatsoever.

Latest Comments
  1. puttaswamy gowda November 27, 2012

Leave a Reply

Your email address will not be published. Required fields are marked *

Optimization WordPress Plugins & Solutions by W3 EDGE