Wednesday, March 12, 2014

Adding new VAT 5% & 14% in Tally 7.2 & 9

Adding new VAT 5% & 14% in Tally 7.2 & 9


1.             First of all take a backup of tally data and folder. Incase anything goes wrong.
2.             Open notepad and save it as input5.xml
3.             Open input5.xml with WordPad.
4.             Copy below contents to Input5.xml file for entering  Input VAT rate:

<ENVELOPE>
    <HEADER>
        <TALLYREQUEST>Import Data</TALLYREQUEST>
    </HEADER>
    <BODY>
        <IMPORTDATA>
            <REQUESTDESC>
                <REPORTNAME>All Masters</REPORTNAME>
                <STATICVARIABLES>
                    <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
                </STATICVARIABLES>
            </REQUESTDESC>
            <REQUESTDATA>
                <TALLYMESSAGE xmlns:UDF="TallyUDF">
                    <TAXCLASSIFICATION NAME="
Input VAT @ 5%">
                        <NAME.LIST TYPE="String">
                            <NAME>
Input VAT @ 5%</NAME>
                            <NAME>
Purchases @ 5%</NAME>
                        </NAME.LIST>
                        <TAXTYPE>VAT</TAXTYPE>
                        <SUBTAXTYPE />
                        <MARKFORDELETION>No</MARKFORDELETION>
                        <CLASSIFICATIONISSALES>No</CLASSIFICATIONISSALES>
                        <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
                        <RATEOFVAT>
5</RATEOFVAT>
                        <!-- Add your State here-->
                        <TAXCLASSIFICATIONSTATE.LIST>
                            <STATENAME>
Kerala</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>
20130401</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Input VAT @ 14% to Tally.

Open notepad and save it as input14.xml replace the value 5 with 14.

Add your state name and date from when the tax structure was applicable. Date format is year-month-day i.e 20110401 (Year- 2011 Month- 04 Day- 01). Input correct date or things wont work properly. Now Save the file.
 

  1. Open notepad and save it as output5.xml
  2. Copy below contents to output5.xml file for Output VAT rate.

<ENVELOPE>
    <HEADER>
        <TALLYREQUEST>Import Data</TALLYREQUEST>
    </HEADER>
    <BODY>
        <IMPORTDATA>
            <REQUESTDESC>
                <REPORTNAME>All Masters</REPORTNAME>
                <STATICVARIABLES>
                    <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
                </STATICVARIABLES>
            </REQUESTDESC>
            <REQUESTDATA>
                <TALLYMESSAGE xmlns:UDF="TallyUDF">
                    <TAXCLASSIFICATION NAME="
Output VAT @ 5%">
                        <NAME.LIST TYPE="String">
                            <NAME>
Output VAT @ 5%</NAME>
                            <NAME>
Sales @ 5%</NAME>
                        </NAME.LIST>
                        <TAXTYPE>VAT</TAXTYPE>
                        <SUBTAXTYPE />
                        <MARKFORDELETION>No</MARKFORDELETION>
                        <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
                        <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
                        <RATEOFVAT>
5</RATEOFVAT>
                        <!-- Add your State here-->
                        <TAXCLASSIFICATIONSTATE.LIST>
                            <STATENAME>
Kerala</STATENAME>
                            <TAXCLASSIFSTATEPERIOD.LIST>
                                <PERIODFROM>
20130401</PERIODFROM>
                            </TAXCLASSIFSTATEPERIOD.LIST>
                        </TAXCLASSIFICATIONSTATE.LIST>
                    </TAXCLASSIFICATION>
                </TALLYMESSAGE>
            </REQUESTDATA>
        </IMPORTDATA>
    </BODY>
</ENVELOPE>
Lets say you need to enter Output VAT @ 14% to Tally.

Open notepad and save it as output14.xml replace the value 5 with 14.

Add your state name and date from when the tax structure was applicable. Date format is year-month-day i.e 20110401 (Year- 2011 Month- 04 Day- 01). Input correct date or things wont work properly. Now Save the file.
 

Now the files are ready. Its time to put them into Tally.

For Tally 7.2 users:
Open Tally –> Select company –> Gateway of Tally –> Import Masters –>
 

Enter the correct location to ‘input5.xml’ file. “Modify with New Data”, Tally (XML) Format
Repeat the procedure for entering the ‘input14.xml’,‘output5.xml’, ‘output14.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Masters –> VAT Classifications –>

For Tally 9 users:
Open Tally –> Select company –> Gateway of Tally –> Import of Data –> Masters –>

Enter the correct location to ‘input5.xml’ file. “Modify with New Data”
Click enter and Input VAT has been entered.
repeat the procedure for entering the  ‘input14.xml’,‘output5.xml’, ‘output14.xml’

Verify it. Go to –> Gateway of Tally –> Display –> Statutory Info. –> VAT Classifications –>
 

Tuesday, March 11, 2014

The Sinking of the Titanic, 1912

The Sinking of the Titanic, 1912

On April 10, 1912, the Titanic, largest ship afloat, left Southampton, England on her maiden voyage to New York City. The White Star Line had spared no expense in assuring her luxury. A legend even before she sailed, her passengers were a mixture of the world's wealthiest basking in the elegance of first class accommodations and immigrants packed into steerage.

She was touted as the safest ship ever built, so safe that she carried only 20 lifeboats - enough to provide accommodation for only half her 2,200 passengers and crew. This discrepancy rested on the belief that since the ship's construction made her 'unsinkable,' her lifeboats were necessary only to rescue survivors of other sinking ships. Additionally, lifeboats took up valuable deck space.

Four days into her journey, at 11:40 P.M. on the night of April 14, she struck an iceberg. Her fireman compared the sound of the impact to 'the tearing of calico, nothing more.' However, the collision was fatal and the icy water soon poured through the ship.

It became obvious that many would not find safety in a lifeboat. Each passenger was issued a life jacket but life expectancy would be short when exposed to water four degrees below freezing. As the forward portion of the ship sank deeper, passengers scrambled to the stern. John Thayer witnessed the sinking from a lifeboat. 'We could see groups of the almost fifteen hundred people still aboard, clinging in clusters or bunches, like swarming bees; only to fall in masses, pairs or singly, as the great after part of the ship, two hundred and fifty feet of it, rose into the sky, till it reached a sixty-five or seventy degree angle.' The great ship slowly slid beneath the waters two hours and forty minutes after the collision

The next morning, the liner Carpathia rescued 705 survivors. One thousand five hundred twenty-two passengers and crew were lost. Subsequent inquiries attributed the high loss of life to an insufficient number of lifeboats and inadequate training in their use.

End of a Splendid Journey

Elizabeth Shutes, aged 40, was governess to nineteen-year-old Margaret Graham who was traveling with her parents. As Shutes and her charge sit in their First Class cabin they feel a shudder travel through the ship. At first comforted by her belief in the safety of the ship, Elizabeth's composure is soon shattered by the realization of the imminent tragedy:

"Suddenly a queer quivering ran under me, apparently the whole length of the ship. Startled by the very strangeness of the shivering motion, I sprang to the floor. With too perfect a trust in that mighty vessel I again lay down. Some one knocked at my door, and the voice of a friend said: 'Come quickly to my cabin; an iceberg has just passed our window; I know we have just struck one.'

No confusion, no noise of any kind, one could believe no danger imminent. Our stewardess came and said she could learn nothing. Looking out into the companionway I saw heads appearing asking questions from half-closed doors. All sepulchrally still, no excitement. I sat down again. My friend was by this time dressed; still her daughter and I talked on, Margaret pretending to eat a sandwich. Her hand shook so that the bread kept parting company from the chicken. Then I saw she was frightened, and for the first time I was too, but why get dressed, as no one had given the slightest hint of any possible danger? An officer's cap passed the door. I asked: 'Is there an accident or danger of any kind? 'None, so far as I know', was his courteous answer, spoken quietly and most kindly. This same officer then entered a cabin a little distance down the companionway and, by this time distrustful of everything, I listened intently, and distinctly heard, 'We can keep the water out for a while.' Then, and not until then, did I realize the horror of an accident at sea. Now it was too late to dress; no time for a waist, but a coat and skirt were soon on; slippers were quicker than shoes; the stewardess put on our life-preservers, and we were just ready when Mr Roebling came to tell us he would take us to our friend's mother, who was waiting above ...

No laughing throng, but on either side [of the staircases] stand quietly, bravely, the stewards, all equipped with the white, ghostly life-preservers. Always the thing one tries not to see even crossing a ferry. Now only pale faces, each form strapped about with those white bars. So gruesome a scene. We passed on. The awful good-byes. The quiet look of hope in the brave men's eyes as the wives were put into the lifeboats. Nothing escaped one at this fearful moment. We left from the sun deck, seventy-five feet above the water. Mr Case and Mr Roebling, brave American men, saw us to the lifeboat, made no effort to save themselves, but stepped back on deck. Later they went to an honoured grave.

Our lifeboat, with thirty-six in it, began lowering to the sea. This was done amid the greatest confusion. Rough seamen all giving different orders. No officer aboard. As only one side of the ropes worked, the lifeboat at one time was in such a position that it seemed we must capsize in mid-air. At last the ropes worked together, and we drew nearer and nearer the black, oily water. The first touch of our lifeboat on that black sea came to me as a last good-bye to life, and so we put off - a tiny boat on a great sea - rowed away from what had been a safe home for five days.

The first wish on the part of all was to stay near the Titanic. We all felt so much safer near the ship. Surely such a vessel could not sink. I thought the danger must be exaggerated, and we could all be taken aboard again. But surely the outline of that great, good ship was growing less. The bow of the boat was getting black. Light after light was disappearing, and now those rough seamen put to their oars and we were told to hunt under seats, any place, anywhere, for a lantern, a light of any kind. Every place was empty. There was no water - no stimulant of any kind. Not a biscuit - nothing to keep us alive had we drifted long...

Sitting by me in the lifeboat were a mother and daughter. The mother had left a husband on the Titanic, and the daughter a father and husband, and while we were near the other boats those two stricken women would call out a name and ask, 'Are you there?' 'No,'would come back the awful answer, but these brave women never lost courage, forgot their own sorrow, telling me to sit close to them to keep warm... The life-preservers helped to keep us warm, but the night was bitter cold, and it grew colder and colder, and just before dawn, the coldest, darkest hour of all, no help seemed possible...

...The stars slowly disappeared, and in their place came the faint pink glow of another day. Then I heard, 'A light, a ship.' I could not, would not, look while there was a bit of doubt, but kept my eyes away. All night long I had heard, 'A light!' Each time it proved to be one of our other lifeboats, someone lighting a piece of paper, anything they could find to burn, and now I could not believe. Someone found a newspaper; it was lighted and held up. Then I looked and saw a ship. A ship bright with lights; strong and steady she waited, and we were to be saved. A straw hat was offered it would burn longer. That same ship that had come to save us might run us down. But no; she is still. The two, the ship and the dawn, came together, a living painting."

References: 
   Elizabeth Shutes' account first appeared in: Gracie, Archibold, The Truth About the Titanic (1913), reprinted in: Foster, John Wilson (editor), The Titanic Reader (1999); Lord, Walter, A Night to Remember (1955); Davie, Michael, Titanic: The Death and Life of a Legend (1986).


Do and dont's for stock market investments

Do and dont's for stock market investments

What you must NOT do

1. Don't panic
The market is volatile. Accept that. It will keep fluctuating. Don't panic.
If the prices of your shares have plummeted, there is no reason to want to get rid of them in a hurry. Stay invested if nothing fundamental about your company has changed.
Ditto with your mutual fund. Does the Net Asset Value deep dipping and then rising slightly? Hold on. Don't sell unnecessarily.

2. Don't make huge investments
When the market dips, go ahead and buy some stocks. But don't invest huge amounts. Pick up the shares in stages.
Keep some money aside and zero in on a few companies you believe in.
When the market dips --buy them. When the market dips again, , you can pick up some more. Keep buying the shares periodically.
Everyone knows that they should buy when the market has reached its lowest and sell the shares when the market peaks. But the fact remains, no one can time the market.
It is impossible for an individual to state when the share price has reached rock bottom. Instead, buy shares over a period of time; this way, you will average your costs.
Pick a few stocks and invest in them gradually.
Ditto with a mutual fund. Invest small amounts gradually via a Systematic Investment Plan. Here, you invest a fixed amount every month into your fund and you get units allocated to you.

3. Don't chase performance
A stock does not become a good buy simply because its price has been rising phenomenally. Once investors start selling, the price will drop drastically.
Ditto with a mutual fund. Every fund will show a great return in the current bull run. That does not make it a good fund. Track the performance of the fund over a bull and bear market; only then make your choice. 

4. Don't ignore expenses
When you buy and sell shares, you will have to pay a brokerage fee and a Securities Transaction Tax. This could nip into your profits specially if you are selling for small gains (where the price of stock has risen by a few rupees).
With mutual funds, if you have already paid an entry load, then you most probably won't have to pay an exit load. Entry loads and exit loads are fees levied on the Net Asset Value (price of a unit of a fund). Entry load is levied when you buy units and an exit load when you sell them.
If you sell your shares of equity funds within a year of buying, you end up paying a short-term capital gains tax of 10% on your profit. If you sell after a year, you pay no tax (long-term capital gains tax is nil).

What you MUST do

1. Get rid of the junk
Any shares you bought but no longer want to keep? If they are showing a profit, you could consider selling them. Even if they are not going to give you a substantial profit, it is time to dump them and utilise the money elsewhere if you no longer believe in them.
Similarly with a dud fund; sell the units and deploy the money in a more fruitful investment.

2. Diversify
Don't just buy stocks in one sector. Make sure you are invested in stocks of various sectors.
Also, when you look at your total equity investments, don't just look at stocks. Look at equity funds as well.
To balance your equity investments, put a portion of your investments in fixed income instruments like the Public Provident Fund, post office deposits, bonds and National Savings Certificates.
If you have none of these or very little investment in these, consider a balanced fund or a debt fund.

3. Believe in your investment
Don't invest in shares based on a tip, no matter who gives it to you.
Tread cautiously. Invest in stocks you truly believe in. Look at the fundamentals. Analyse the company and ask yourself if you want to be part of it.
Are you happy with the way a particular fund manager manages his fund and the objective of the fund? If yes, consider investing in it.

4. Stick to your strategy
If you decided you only want 60% of all your investments in equity, don't over-exceed that limit because the stock market has been delivering great returns.
Stick to your allocation.


Add Custom Robots.txt file in Blogger

What is Robots.txt?

Robots.txt is a text file which contains few lines of simple code. It is saved on the website or blog’s server which instruct the web crawlers to how to index and crawl your blog in the search results. That means you can restrict any web page on your blog from web crawlers so that it can’t get indexed in search engines like your blog labels page, your demo page or any other pages that are not as important to get indexed. Always remember that search crawlers scan the robots.txt file before crawling any web page.
Each blog hosted on blogger have its default robots.txt file which is something look like this:
User-agent: Mediapartners-Google
Disallow:
User-agent: *
Disallow: /search
Allow: /
Sitemap: http://example.blogspot.com/feeds/posts/default?orderby=UPDATED

Explanation

This code is divided into three sections. Let’s first study each of them after that we will learn how to add custom robots.txt file in blogspot blogs.
1.      User-agent: Mediapartners-Google
This code is for Google Adsense robots which help them to serve better ads on your blog. Either you are using Google Adsense on your blog or not simply leave it as it is.
·         User-agent: *
This is for all robots marked with asterisk (*). In default settings our blog’s labels links are restricted to indexed by search crawlers that means the web crawlers will not index our labels page links because of below code.
Disallow: /search
That means the links having keyword search just after the domain name will be ignored. See below example which is a link of label page named SEO.
http://www.bloggertipstricks.com/search/label/SEO
And if we remove Disallow: /search from the above code then crawlers will access our entire blog to index and crawl all of its content and web pages.
Here Allow: / refers to the Homepage that means web crawlers can crawl and index our blog’s homepage.
Disallow Particular Post
Now suppose if we want to exclude a particular post from indexing then we can add below lines in the code.
Disallow: /yyyy/mm/post-url.html
Here yyyy and mm refers to the publishing year and month of the post respectively. For example if we have published a post in year 2013 in month of March then we have to use below format.
Disallow: /2013/03/post-url.html
To make this task easy, you can simply copy the post URL and remove the blog name from the beginning.
Disallow Particular Page
If we need to disallow a particular page then we can use the same method as above. Simply copy the page URL and remove blog address from it which will something look like this:
Disallow: /p/page-url.html
·         Sitemap: http://example.blogspot.com/feeds/posts/default?orderby=UPDATED
This code refers to the sitemap of our blog. By adding sitemap link here we are simply optimizing our blog’s crawling rate. Means whenever the web crawlers scan our robots.txt file they will find a path to our sitemap where all the links of our published posts present. Web crawlers will find it easy to crawl all of our posts. Hence, there are better chances that web crawlers crawl all of our blog posts without ignoring a single one.
Note: This sitemap will only tell the web crawlers about the recent 25 posts. If you want to increase the number of link in your sitemap then replace default sitemap with below one. It will work for first 500 recent posts
Sitemap: http://example.blogspot.com/atom.xml?redirect=false&start-index=1&max-results=500
If you have more than 500 published posts in your blog then you can use two sitemaps like below:
Sitemap: http://example.blogspot.com/atom.xml?redirect=false&start-index=1&max-results=500
Sitemap: http://example.blogspot.com/atom.xml?redirect=false&start-index=500&max-results=1000

Adding Custom Robots.Txt to Blogger

Now the main part of this tutorial is how to add custom robots.txt in blogger. So below are steps to add it.
1.      Go to your blogger blog.
2.      Navigate to Settings >> Search Preferences ›› Crawlers and indexing ››Custom robots.txt ›› Edit ›› Yes
3.      Now paste your robots.txt file code in the box.
4.      Click on Save Changes button.
5.      You are done!

How to Check Your Robots.txt File?

You can check this file on your blog by adding /robots.txt at last to your blog URL in the browser.


Kerala Honeymoon Package

Honeymoon Package -  (03N/04D)
Routing: Cochin > Munnar > Houseboat > Cochin

Day 1: Cochin - Munnar ______________________________________________

Your journey into the deep south behind with your arrival in Cochin, where you will be met for a transfer to Munnar. Famous for its tea estates, this picturesque hill station is the biggest tea producer in south India. Located 1,600 m above the sea level, it was once the summer resort of the erstwhile British government in the region. The sprawling tea plantations, quaint towns, winding lanes and holiday facilities make this a popular resort destination. After you check in, you have the rest of the day to spend at your leisure. Overnight at the hotel.

Day 2: Munnar ______________________________________________________

After a hearty breakfast, begin your day with a spot of sightseeing. On the agenda are the Eravikulam National Park, the natural habitat of the Nilgiri Tahr, a kind of ibex; the Mattupetty Dam; Echo Point and the wonderful sights of the town itself. Then you head back to the hotel for a hot dinner! This is the second and last night at Munnar, after which you proceed to the next destination.

Day 3: Munnar - Alleppey _____________________________________________

Now it’s on to the backwaters hub of Alleppey once you get done with breakfast. On arrival, head to a houseboat for an overnight cruise through the scenic backwaters of Alleppey that involve a cruise through palm-fringed canals and a priceless, insider’s glimpse of the village folk, perhaps at work in the paddy fields, even as the sussurrant sound of breeze wafting through the palms relaxes and rejuvenates you! This mysterious strip of emerald green land has endless miles of placid backwaters. Cruise till 5.30-6 pm in the evening by which time, you halt in the lake itself for an overnight stay within the comforts of the a/c deluxe houseboat.

Day 4: Alleppey - Cochin ____________________________________________

Disembark Houseboat and on time transfer to Cochin Airport to connect your onward flight.