Entering indian stock LTCG into ITR2 form

I was filling the income tax form ITR2 and need to fill the LTCG (long term capital gain) details there. It was not clear where (which schedule(s)) and what to put there. After little bit of googling and flipping through the ITR2 schedules, I arrived at this procedure to fill the indian stock LTCG details there.

Before I go into procedure – some background. At the onset, Instruction manual and ITR2 forms are available for download here. Instruction manual is helpful at times if you are layman, or a salaried employee trying to efile your tax returns yourselves. What you may find intimidating — is the references to sections and sub-sections and if you try to read some of those sections — for example, section 111a or 112.  You may likely find them complex to parse and time consuming to digest. Title from schedule CG – Item B – LTCG

From asset in the case of others where proviso under section 112(1) is not applicable

For a layman, this is a straight bouncer. Income tax dept. is trying every year to make it easy to fill the form for citizens. Probably, they will give better text which non-CAs (chartered accountants) can parse and not feel intimidated. I attempted to read through section 112 when trying to fill this section; I soon realized, it is not going to be easy.

Instruction manual likely needs more of How to sections. For example – How to enter short term/long term gains from indian stocks? Sure a technical manual for the professionals (read chartered accountants) is also needed.

I found this link which gave me lead into this work. (Update: I found another link which re-enforced that LTCG from indian stocks needs to be only entered in schedule EI)

The procedure:

  1. LTCG from indian stocks needs to be entered into schedule EI, not schedule CG-OS.
  2. Dividend income from indian stocks also needs to be entered into schedule EI, not schedule CG-OS.
  3. Purchase price needs to be indexed before computing the profit or loss.
  4. You need purchase price of your stocks for the computation. [I assume here that purchase date is older than a year (since LTCG)].
  5. icicidirect helped for (4)  – since they provided out of the box – an excel with profit and loss computation for the transactions. Otherwise, you will need to build an excel that may look something like this.
Stock Symbol Qty Sale Date Sale Rate Sale Value Purchase Date Purchase Rate
> 1 Year   Profit/Loss (Sold after 1 year of Holding)
abc 30 12-Apr-12 234.95 6988.14 2-Dec-10 170.1
Purchase Value Indexed purchase value Profit/Loss(-) without indexing profit/loss(-) with indexing 2010-11 CII 2012-13 CII*
5145.9 6166.39 1842.24 821.75 711 852

*CII stands for cost inflation index. A table is available in the instruction manual for this.

Hope this helps. It took me couple of hours to get to this. If you are professional CA, and find something wrong with the procedure – do drop a comment. I tried to keep it accurate to the extent I could understand.

Update: I shared ITR-2 filing for FY2013-14 (aka AY2014-15) here.

Posted in income tax | Tagged , , | 2 Comments

Cancellation of spicejet ticket on makemytrip.com

I needed the information about what kind of charges will apply if I were to cancel spicejet ticket 24hrs vs 12 hrs vs 3 hrs prior to flight departure. I googled around and could not find the information. makemytrip.com seem to not have the right faq for the same. While railway rules are quite clear and public in this regards but I could not find the same documentation for the air tickets.

Finally called makemytrip customer support. I need to wait for ~20 minutes to get help of the support executive. He was quite helpful though and succinctly answered the query.

Here it goes*:

  1. You will be charged 1250/- (1000 airline charges + 250/- makemytrip service charges). This applies until 3 hrs prior to departure of the flight.
  2. then, you need to approach the airline directly to cancel the ticket. I did not enquire about the charges here.

* This do assume that your ticket is not purchased under special fares where cancellation is not possible, or not under general cancellation policy.

Posted in Travel | Tagged , , | Leave a comment

Disable notification checkboxes below comments form in wordpress blog

I need to disable these checkboxes below comments from in one other wordpress blog.

Notify me of follow-up comments by email.
Notify me of new posts by email.

I figured out that these are apart of Jetpack plugin here. but Jetpack has lot of features and its settings. These setting can be found under dashboard->Settings->discussion->Under Jetpack Subscriptions Settings – disable follow blog and follow comments settings.

That is it. These two checkboxes will clear from the comments form.

Posted in Hosting Website | Tagged , | Leave a comment

Getting pfx file for nodejs https server from godaddy SSL certificate

Once the purchase of SSL certificate is made, go daddy goes through a process to generate the certificate.

Key thing that I did not realize earlier is that my web server (nodejs) requires the keys and certificates in a particular file format. I have decided to keep it simple and use the pfx file format. With this file format, all the keys are certificates are in one file. There are no multiple files to be managed.

The process to generate pfx file will be little different than I did in first go. Also, it is different if your development environment is not windows. In my case, it is a windows based laptop used as development environment.

Lets come to godaddy process to generate the certificate now. First, your identity needs to be verified by email being sent to the whois listing for your domain. This takes order of minute – its all automated – no human intervention. After that, it asks you for a CSR (Certificate signing request). If you are doing this first time – this is little tricky. There are multiple tools for doing this. In case of windows, it is best to use IIS7 admin console on your dev box. in my case, it is IIS7. This godaddy support link is quite helpful to do this.

At this stage, you have the CSR and paste it in your godaddy wizard. It asks few more questions. They are quite straight forward and also have help links which are helpful. Your certificate is generated and you can go to cpanel to download it. Need to select the web server as IIS7 even though in my case, it is nodejs web server. It is not in the list.

At this stage, you have the zip file containing a .crt file and .p7b file and you wonder how to get a pfx file out of it. You may be a geek but do not want to understand at the moment file format like .cer, .crt, .pem, .p7b, .pfx, know which file contains private key, which file contains public key, which contains both, certificate chains, intermediate certificates, certificate stores,  try various tools, read all the information on the net about tools including command line tools, and get on trial and error path to get a pfx file out of the files given by godaddy to you. I do want to get to all details but at the moment, I just wanted to get the web server https endpoint up at the moment. Again, IIS7 admin console and godaddy help link came to rescue.

After following the steps at the above mentioned help link, go to IIS7 admin console–> double click server certificates–> right click your domain certificate-> export -> provide pfx file name, and password to protect it. you get a pfx file.

come to your nodejs web server. pass it the pfx file name and the password as below.  start the node server. it works!

var config = require('config'),
    fs = require('fs'),
    https = require('https')

var options = {
    pfx: fs.readFileSync(config.certificate.pfxFileName),
    passphrase: config.certificate.passphrase,
};

https.createServer(options, function (req, res)
{
    ....
}).listen(443);

Note: this example does not dive into safe guarding your pfx and its password configurations on web server. To test, you can hardcode the values in config nodejs module. That will be another post some other day.

ps/ On a sidenote – I generate the CSR using bluehost (my web host) cpanel in first go and gave that to godaddy. I realized later there was no tool at bluehost to take the go daddy .crt, .p7b files and give me a .pfx file. Neither it let me export the private key created using bluehost cpanel to a file. it just showed the private key likely base64 encoded in a text box. I did not want to go through set of tools and understand various file formats. hence, I went back to IIS7 admin console route as mentioned above. Used the re-key command in go daddy cpanel and re-generated the certificate with CSR provided by local IIS7 web server.

Did it help you? Did you find a more smarter way to generate the pfx file from certificate files given by go daddy? Do you a different process flow when you used another certificate authority other than go daddy? Do share your findings through a link/comment.

Posted in Web Services/APIs | Tagged , , , | Leave a comment

Buying SSL certificate for the web server apis

Recently I need to look around for purchasing a SSL certificate for my web server APIs. since I have not done this in past. I started looking around.

What I found

  1. There is quite a few certificate authorities and quite a few reseller who offer good discounts over and above the CA price.
  2. There is a choice needs to be made between kind of SSL certificate – 1) EV  certificate 2) Standard certificate 3) Wildcard SSL. In layman terms, EV is considered more secure; shows green bar in the browser; other certificate only show a lock Wildcard certificate can be used for many subdomains; example: api.example.com, anothersubdomain.example.com etc; also cost more than standard; standard can be used only for a subdomain; root and www domain both can be protected by one standard certificate.
  3. Bare min Standard SSL Certificate costing as much as typical year worth of shared hosting; sort of starts at USD 49.
  4. Cost variance from multiple CA is significant. Range goes from USD 49-1000.
  5. Reseller discounts also have good range. Cost price from resellers range from USD 13-500.

Observations:

  1. Since the money involved mattered to me, the decision mattered. Time will tell whether the decision made is right one. I will write again about it.
  2. A certificate is a certificate whether it comes from CA1 or CA2. I need to just avoid bottom of the list of CAs. Save cost.
  3. Green bar in browser does not matter when making a choice for web server apis. I just need a certificate. Ruled out purchasing EV at higher cost.
  4. Sometimes securing different subdomains with different certificate is required since they need different level of security. for example – it is good to keep certificate for signup apis and other apis separate.
  5. It is good to start with spending less. Put more money as needed.
  6. Based on 4 and 5 – I ruled out wild card SSL.
  7. sslshopper in my case gave good deal for standard ssl from godaddy.
  8. Decided to go with standard ssl from go daddy. sslshopper link redirected to godaddy. interesting thing is only after adding to cart the discounted price shows up. Prior to that, go daddy standard price shows up.
  9. go daddy worked better since it charged in local INR currency. I probably got the best price. INR 338 after discount.

It took over 1.5 days to get to understand what is required, and making the purchase.

Did you need to go through similar requirements? What worked best for you? Share your comments.

Update after a year: auto renewal from godaddy for the SSL charged USD 69.99 on my card. There are two issues: 1. payment mode changed to USD from INR 2. renewal value is 10+ times the original purchase amount. I have to call support and cancel the certificate since they could not address both the issues. It is good to keep auto-renewal off and manually find a good deal for renewal. I have to yet figure out – another purchase of the SSL.

Posted in Web Services/APIs | Tagged , | Leave a comment

Trick to redirect website root page

I needed to do two things –

  1. redirect all access to my website without www prefix(example example.com) to url with prefix www (www.example.com).
  2. redirect root page of the website to a page under some subdirectory. That is example.com should redirect to www.example.com/pages/about/about.html

Website is hosted on bluehost. I later learnt the website is using apache server. It is simple stuff for someone who is hosting or building websites for long. I need to search and try couple of tricks on the cpanel before I could get it to work.

Here is how it works:

  1. There is .htaccess file in the public_html (root folder). File is hidden and file manager cpanel needs to be launched with checkbox (hidden) ticked.
  2. Edit this file.
  3. This file is processed by apache web server, and url rewrite rules can be written in this file.
  4. script snippet below saved in the .htaccess file, worked for me to achieve this.
  5. you can refer the documentation of redirects here.
RewriteEngine on

RewriteCond %{HTTP_HOST} !^www.example.com$ [NC]
RewriteRule ^(.*)$ http://www.example.com/$1 [R=301]

RewriteCond %{HTTP_HOST} ^www.example.com$
RewriteRule ^$ http://www.example.com/pages/about/about.html [L,R=301]
Posted in Hosting Website | Tagged | Leave a comment

A trip to Matheran

I have traveled recently to Matheran, a hill destination close to Mumbai. We have planned this as part of the travel to Mumbai since it is a place very close to Mumbai and still away from city rumblings.

During onward travel, we decided to take local train of Mumbai. All of us coming from various destinations, got down at Dadar. Next, we took local train to Narel from here. It took nearly 1.25 hrs. Next leg of travel is from Narel to Matheran. We were looking for taking the Toy train. 3 of us have taken a local train to Narel before the rest of the gang.

The toy train has limited capacity and travels roughly per hour. It cost INR 65/- per adult and INR 40/- per child. Rush picks up after 9AM. It is likely the best to catch the first train in the morning. Its timings are also not hard bound. It waits for it to fill up. for example – we reached around 8am and saw the 7-30am first scheduled train depart. ticket man was calling for last 3 vacant seats. one family got those seats and then, the train departed. only 4 tickets are given to a person – we were 12 adults + 2 children. so, it did work out for us. but the ticket man did not co-operate to give us sitting place for the kids. We just got the tickets for them without seat number. The toy train actually has quite cramped leg room and two people above 5-9″ will find it hard to sit next to each other. Especially people who are above 6″ need to help themselves next to the gate.

Speed of the train is pretty slow and fun. TT for the train was quite a funny man. We saw him jump from one boggy, run and catch the next boggy. Half hour during the travel, a kid in the group dropped a lady purse out of the window. Our fun-loving TT saw, smiled, got of the running toy train, ran, picked the purse and boarded the train. We all cheered for him when he was back. Some views from the toy train were pretty good.

WP_001296

though we were talking among us and likely missed few of the good snaps.

WP_001295

Taxi walas at Narel did warn to us that Toy train takes longer. Expected time as per railways schedule is 2 hrs. They claimed to take us to an intermediate stop in straight 30-40 minutes. We had decided instead to take the joy ride of toy train. Unfortunately, the train broke down after a halt at watertank station where it takes 10 min stop. The train driver took multiple repeated tries to get the train up the hill slope but the engine simply gave up and could not pull train beyond 100m from the watertank station. This kind of adventure was unique. I have not seen train in reverse gear coming back to station, speed up to climb a steep slope! Some of us whine – we should have taken the taxi route recommended by part of the gang.

While some of us did like the one hour travel in the toy train, but we found that taxi walas were kind of right. We called for two taxi from below. They charged us INR 70 per person – that comes to INR 350 per taxi. They came to the stop in nearly 20minutes from down and took another roughly 10 minutes to get us to the taxi park area. This is the last place where any motored vehicle can be driven, including your own car. From here, there is choice of travelling on foot, on horse, or take a shuttle train to Matheran market place; carry your luggage self or hire a porter with yourself. From taxi area to the shuttle train stop, it is 5-10 minutes walk. Having bitten by the Toy Train and already lost time, group was in not a mood to try the train route again.

The horse walas are quite pricy if you are in a 10+ group. They started the bargain at INR 400 per person. Eventually, they came down to 250-300INR. Some of us were in love with horse ride and just joined the horse. one of our teenager got scared as the horse moved his front leg up once. so, she joined the trail walker group. Part of us who decided to give trail walking a shot, hired porter service for the luggage. Porter took INR 200 up to the hotel instead of matheran marketplace though I think there service is easily worth higher for walking a hr with luggage. They seem to not win in the bargain much.

I was part of the trail walking group. My phone battery gave up by then unfortunately. Trail was covered with long tall old trees. For nature lover like me, who has not traveled in recent days, it was really nice. I enjoyed it. After few minutes, porters informed us that rest of the trail is going to be shaded by trees. We pretty much travel along the shuttle train tracks as suggested by the porters. Horse riders took a different route.

We took roughly 1 hr+ plus walking at slow pace to reach Matheran market place and another 10 minutes to our Hotel – Usha Ascot. None of us lost breath or anything. The walk is mostly flat and does not require lot of stamina as such. My kids 4+, 5+ who did not opt to take horse ride, need to also walk for 1 hr. At matheran marketplace, we hired a hand pulled rickshaw for INR 150 for the two children and their mom, up to the hotel. By the time, we reached hotel it was 1:30pm and horse riding group has already sitting in the hotel restaurant. We also decided to straight go for the buffet lunch (part of the hotel package) after quick wash and hold going to rooms yet. The food was very nice – mango juice (aam raas served in Gujarat), fried snacks (gurarati farsan), dokla, tasty two vegetables, rice, daal etc. Everything in the menu was quite tasty. Everyone mostly over-eat and did not count calories; just got the refill.

After the walk and lunch, it was time to relax a bit, each family got a room. we got into our room. ladies decided to go for a massage at the hotel. It was good, and not good for some – priced INR 350/- per half hour. I took kids to bath, and then – they stick to the TV until all of them decided to go for a swim. My children also developed recent like to swim with the tube. we had carried the tubes for both of them. I blew it with mouth and they went for swim. I joined them for swim later though I don’t know and hence, not like it as much. I decided to stay in the shallower side of the pool to give company to the children.

Like this the first day passed, all of us joined the evening tea time. Tea was really the best I have had outside home with good shot of ginger – what was truly a masala tea. Could not resist and took another refill – typically 1/2 cup is enough for me.   We order a plate of pakoras that were also delight to eat.

Evening dinner highlight for some of us was the live ghazal singer Mr khan at the hotel. He was delight to the ears. We ate, some of us decided to move to room – some of us stayed until the live Ghazal show’s last ghazal. First day he sang many from Jagjit singh. It was kind of awesome for me amidst the natural surroundings. Like this the first day came to an end – we took the sleepy/already-slept kids to room and crashed.

Oh – one interesting thing happened before this in the evening. Matheran and monkeys are made for each other. They reign here and are not afraid of humans. We met our man in the hotel room in the evening. hotel room had a backyard and door was open. One monkey came straight into the room. I tried to shout at him but he simply walked across the room; imagine all of us on the bed with monkey taking a round in the room checking our belongings. we called hotel reception. They were quite quick and opened the main door to help our friend out of the room and we caught our breadth. We came to know then that they (Monkeys) are only afraid of stone thrown by humans, or usage of  what is called indian ‘gulailal’ – we put a stone on the rubber band, pull it back and shoot. Anyway – we made a point to close the doors and I always carried a pair of stones in pockets thereafter. My daughter kept remembering Monkey, woke up couple of times and with reassurance she fell asleep that night.

We saw each day lots and lots of monkey on trees, on hotel windows, balconies and hotel staff with gulailal to whisk them away. They are not harmful. just need to make sure not to carry plastic bags in hand; they come to snatch those bags to find eatables. one of the child lost his pepsi bottle to a Monkey. so, if you are not carrying eatables or bags – they are not interested in you and stay away. They gave lot of pass time to the group – for things like chase them away – run behind them with a stick – who is afraid of monkeys – boolying if someone is found afraid etc.

We did enjoy the hand at the game of badminton outdoor court at the hotel, first day. It was nice. Shake the legs in the hotel disco also for few minutes. Likely more activity than normal on first day – got to me next day. My legs did gave signals next day, and I relaxed in hotel room next day more than the first day.

Next day same activities were there. Also me and one of us, had taken morning walk outside the hotel to nearby trail. Around 30 minutes walk. Ladies went for marketplace during the day. There is likely more to explorer in Matheran outside than we did. Certainly, I think there is more trails to walk. We enjoyed the Ghazals next day as well. Food was nice next days also. Next day we relaxed more. There were also other bigger groups at hotel.

Third day, we wanted to pack early and get back to Mumbai. We had the group chit chat, and breakfast together in the central courtyard of the hotel in the open. Hotel staff is always around to keep Monkeys away. so, it is not an issue as such. They do not come to the table.

Way down – we walked to Matheran market plance, and boarded the shuttle train from Matheran market place to the taxi area (intermediate stop). We hired Taxis straight to the borivali area that costed roughly INR 2.4k per taxi. We feared the morning rush in the local trains in Mumbai. Taxi ride was not pleasant at all but was part of the journey. You never know if the local train journey could have been worse because of the rush or simply ok as local trains in Mumbai are the fastest and reliable way to commute. This ride is roughly 70-90km. It took around 2-3 hrs to reach Borivali area to our residence.

Matheran trip was really memorable one. Especially keeping Matheran motor vehicle free is great step by some real nature lover. It is keeping the sanctity of the place even if it is quite close to the big metro like Mumbai and likely faces good rush of tourists. It was pleasure to watch the town’s children walking to their school in the morning; some of them riding with their father/brother on horse on their way to school. In Matheran, one can walk, take a hand pulled ricksaw, hire a horse; but there are no vehicles, we hardly saw even a bicycle; truly green indeed.

I have to travel out of Mumbai same day night. Though it was a compressed trip, it has some pleasant memories to back on.  That’s all for now.

Any highlights of your trip to Matheran that may be needed by some else looking for a trip. Drop a comment.

 

 

Posted in Travel | Leave a comment