Wednesday, 9 May 2012

Easy steps to file your IT returns Free of cost

File your IT Return in simple steps.Please follow the
steps mentioned below.Here we are discussing on filing
 "Income from Salary" .
1. Click on the link 
       https://incometaxindiaefiling.gov.in/portal/login.do.
2. Select the link "e-Filing A.Y.2011 -12",click on the
   link "Individual ,HUF".
3. Go to the section "Download Return Preparation
   Software".
4. From the tabular structure choose ITR -1 ,Click on the
   Excel Utility.
5. Download the Zip file and extract the ITR-1 excel
   file ,"2011_ITR1_r4.xls".
6. Fill out the 3 tabs -Income Details,TDS and Taxes Paid
   and Verification(Refer your Form-16 for accurately
   filling all the information)
7. After fillng all the mandatory information ,click on
   "Validate" button,provided top right of each page and
   ensure the validation is successful.
8. If validation results for all pages are successful,
   click on "Generate" xml button to provided top right,
   this  will generate an xml file and lands on another
   page with "Save " button.
 9. Save your xml file in any physical location.
10. Login to the site ,Under the "Submit Return" section
    Click on "Select Assessment Year",Click" AY 11-12",
    you will land in "Upload your Return Page".
11. Select Form Name as "ITR -1" and choose the options
    "No" for digitally signing.
12. Upload the xml file which you stored earlier,on
    successful upload.You will be getting the ITR-V in
    PDF  format,your credentials to open the PDF file
    is your pan no+plus dateofbirth in  small case
    (ie; if your pan  is abcd and dateofbirth is
    20-02-1979 your password is abcd20021979).

Saturday, 31 March 2012

Where to Send Income tax File Returns/Efiling Form 16 ITRV

Once the ITR -V Form has generated,you need to sent/submit
the same to the Income Tax department within 120 days.

Take a printout of ITR-V Form. You can also download the same
from the link(https://incometaxindiaefiling.gov.in/portal/index.do)
go to My account > My Returns.

Make sure the Form is unfolded, fair enough to read the
barcode printed in the Form.Use an A4 Envelope and send to
the below mentioned Address:

Income Tax Department – CPC, Post Box No – 1,
Electronic City Post Office,
Bengaluru – 560100, Karnataka.

For people in Bangalore,they can use the 5/- Rs Envelope(Stamp logo outside),which is available in all Post Office(No Additional stamps required in this case).You are done !!!

Verify the status on the below link.

My Account’ -> ‘E-filing Process Status’

You can see the Reciept/Acknowledgement related details -> Acknwoledgement Details

How to view/check status of uploaded documents for LPG gas connection

Once the document is uploaded for LPG gas cylinder connection,immediately you will be provided with an acknowledgement number ,you can verify the status of the uploaded documents any point of time with this acknowledgement number.

Please find the steps below to verify the status of uploaded documents,

1. Upon clicking the link -> I have removed the link,since its not
   working now,i will post the link if i got some update on this
   you will be redirected to acknowledgement page.

2. You can enter the acknowledgement number in the textbox.
   provided and click the "Go" Button.

3. You will be provided with a message which says the current status
   of your documents.

4. Normally after uploading,within 5 to 10 working days, the
   information provided by you will be verified and updated by the
   concerned officials.In ideal case we can see a message like
   "Details uploaded with this Ackowledgement Number has been
   accepted by the Concerned Officials of the Department" ,then you
   are done !!!

Check current status of LPG gas cylinder connection and upload necessary documents


Explains step by step procedure for checking the status of your lpg gas connection and to upload the necessary/required documents online to avoid discontinuity.
1.  You can verify your LPG gas cylinder connection status by
    clicking on the  link  -> http://ahara.kar.nic.in/
2.  You will be redirected to the govt of karnataka site where you
    can see a link.
3.  Upon clicking the link "Click here to verify your LPG/Ration
    Card status and to update RR No. etc" you will be redirected to
    a page.The page contains several options.
4.  Upon clicking on the option button "Verification status of LPG
    Connection"you will be redirected to a page where you can select
    the respectieve Company,District,Distributor,and the Consumer
    Number and once you click the 'Go' button you can find the
    current status of your Gas Connection.
1.  To Upload the required documents online
    click the link  ->  I have removed the link,since its not
    working now,i will post the link if i got some update on this.
2.  You will be navigated to the Document Upload page where you can
    fill all the required information.
3.  There is another section "Scanned Copies" where you can upload
    the scanned copies of the below documents.
     Mandatory -> LPG Card or Bill,Electricity Bill.
     Optional - > Ration Card.
4.  Once you are done with this,click the Submit Button.
5.  You will be provided with an acknowledgement number. You are
    done !!!
You can also verify how to check status of the uploaded documents
Status of Uploaded Documents

Insert/Embedd zip file to Microsoft Word Document

Open a Word document,Go to  Insert ,Click the Object drop down and select Object option,this will open a dialog box,from there select Package and check the display as icon check box
    Word Object Drop down option
Click the change icon button if you want to change the default icon,you can change the file name also .After clicking 'ok' a new object Packager window will open up
Click on File->Import,Browse to your file after that
close the Object Packager window,an update confirmationdialog box will pop up,click yes button.You are done

Word Object Packager Option
Now if you want to change the icon or name,right click the Object
Go to Package Object ->Convert,then change the name or icon

how to get rid of the background noise if you are hosting a call - Office Communicator

Its common in office atmosphere that people will attend simultaneous call for project discussions etc,sometimes theyprefer to put their calls in speakers also.

Lets assume if you are hosting a call in such situation,its really annoying to all the paticipants in the call if there is any background noise coming because some/any of the participant forgot to put mute option while the call is going.

Generally the host/leader cant do anything much here other than requesting the paticipant to mute the call multiple times.

There is a beautiful option in OC,so that you can mute all the participants in one go,highlight the 'first patricipant',use 'shift' and 'down arrow key' to select all other participants,'right click' mute, done !!!!,

if any of them want to speak they can unmute also.

Increase the display response time of your machine - Windows XP tips

You can turn off some of the windows XP's background process,eg: window-dressing,with this option enabled.

Right click on My Computer,choose Properties.
On the 'Advanced tab', click the 'Performance Settings' button and then choose the 'Visual Effects' tab. 
Choose the 'Best performance radio button'.Click buttons 'Apply' and 'Ok'.Done !!!

I felt some improvement in the display response time.

At any time you can revert the  selections by selecting the radio button 'Let Windows choose what is best for my computer' on the Visual Effects tab.Click buttons 'Apply' and 'Ok'.

Tip to open Excel workbook saved in any versions


How to  open the Excel work book saved in Excel 2007
from earlier versions of Excel.

There is an easy option available in Excel Work book
to achieve this.With this option not only you can open the Excel files saved in any higher version but  can  do other things like modify,save or send the same work book which can be opened from any versions of the Excel.

Follow the below steps :

save your file as an Excel Binary format (.xlsb), available in the Save-As menu scroll bar or  click the  Save As menu option which will open a dialog box choose the Save as type : as  Excel Binary format (.xlsb), as shown below
Save as dialog box with xslb option

Save in this format not only alllows you to open in any version of Excel work sheets but also reduces the size of the file.

how to create a personal directory in Excel

Do you have a lot of information and is it  scattered everywhere?excel provide you a centralised way to access all your required information with a single click.

Open an excel workbook, type 'Ctrl+K', this will open
an 'insert hyperlink box'.Navigate to files/folders on
your hard drive either through 'Look in: drop down' or
by directly giving the path in  'Address: drop down' as
given below. You can give any meaningful name in the
'Test to display' box.


Insert hyperlink options in Excel


You can give any  path in 'Address: drop down' ,
which includes website address also(eg:http://picasa.google.com/).

Save this workbook somewhere in your hard disk.

Now you can access all the information stored in this workbook
with a single click !!!

How to make excel document with only one worksheet - Excel Delete unused worksheets

Since you know if you open any Excel worksheet,3 sheets are default,
sometime we may not require the other two worksheets but we end up
in saving the complete workbook.There is an easy solution for this.

Click the 'Office button', click Excel options button and change the
number listed in the 'Include this many sheets' to 1.

In Excel 2003, just go to Tools>Options>General and
change Sheets in new workbooks to 1
This way next time when you open an Excel worksheet,
you can make sure you have only one worksheet!!!!

I prefer this way ,because whenever you want an additional worksheet
right click sheet1 ,in the pop up click 'insert' then 'worksheet',you can add upto 'n' number of sheets

print preview mode in windows menu to edit the document on the fly

We all know how to take a printout of a document,say for eg: Microsoft Word 2007 document.But at times the  printout
taken might not come in the way we desired,there will be some minor issues which makes your printouts looks ugly like,
for eg :page break or a new line or may be missed to add content.

In some other cases,after viewing in the  Print Preview mode,
we generally go back to the document to do our modifications,according to me this is a time consuming
process,but do you know there is an easy solution for
all the above which not only gives your document a decent look but saves time also .

Once you have finished with your document or about  to
take a print out,go to the Windows menu ->Print ->Print
Preview or Ctrl+Alt+I ,this will open your document in
print preview mode,click the Zoom icon from the top to
zoom  to your desired size,now uncheck the box next to
Magnifier,now you can edit the document  on the fly which
will automatically save for printing !!.

outlook 2007 registry key settings to empty deleted items folder

Navigate to the below path in your Registry.
HKEY_USERS\Software\Microsoft\Office\12.0\Outlook\Preferences 
,or go to  Edit->Find,enter the name 'EmptyTrash’

You are certain to find the entry/Name ‘EmptyTrash’

Modified the value from 0 to 1,like shown below.
This will  Empty the Deleted Items Folder upon close/exit of your mailbox.kool !!!  isn't it ?
Registry Entry for Empty Trash

Similiarly for composing a mail in outlook you can configure the
Registry to hide/display the options 'From,BCC'  etc,
by  modifying the values for ‘ShowBcc,ShowFrom’ from 0 to 1.

you may also like the Outlook configuration to 'Empty deleted items folder'

Bescom online bill payment - Pay Water Bill Online

Click the link->https://www.bangaloreone.gov.in/login.aspx
If you are a new user,you need to register(click the link "Sign in for New Users"), once done,then login to the site with the  credentials (Login Name and Password ) provided at the time of registration.You will be shown a page where you can pay  bills for different Services online.

Electricity Bill

Click the link "BESCOM - Payment of Electricity Bills"

Fill up the mandatory information like Sub Division
(Location Code) and RR Number, click the button 'Details',
This will retrieve all the Information regarding your current bill
payment, including the amount to pay(Total demand),

Enter the amount in  the 'Amount Payable' box,select the
'Card Type' and click Submit.You will be shown a confirmation screen,Click the Confirm button, Enter the credit card details and click Submit.Done !!!

Water Bill

Since the process is all the same except there is a change of the required mandatory information you need to fill,i am assuming you can follow if you read the above.

Fraud at Indian Oil Petrol Pump

I want to tell you some of my personal experiences while filling petrol at the petrol pumps in Bangalore.

This incident happened in Indian Oil Petrol bunk :
I went to a petrol pump and asked to fill petrol in my
car for Rs 2000/-. One guy started filling petrol meanwhile
another guy came to me and started talking to me
about the loyalty card which Indian oil provides. I gave him the card which I had, in the mean time the other person stopped filling petrol when it was for Rs 500/- and told me its done.
I reminded him that I want to putpetrol for Rs 2000/- so he continued putting petrol and the other guy was talking to me all the time saying that we have another card blah blah... The guy filling petrol again stopped at Rs 1500/-

saying that they have filled petrol  for Rs 500/-[500+1500]. Infact they had only put petrol for Rs 1500/- and was trying to make me believe that they have filled petrol for Rs 2000/-.

Even though i tried to argue with them its of no use,i believe
all the employees in IOC pump are aware and part of this fraud,they are cheating people.

This  happened to me in Indian Oil Petrol Pump in
Bannergatta road
[Near to Sagar Apollo Hospita]


Please dont fill from this Petrol Pump at any cost.

Please share this message with everybody....

Also see the Fraud at Advaith Hyundai  Service Center.

How to Empty the Deleted Items folder upon exiting Outlook

There were several tips/steps we can follow to reduce the size of our mail box,which is definitely a broader subject,but here i would like to discuss one easy tip that requires a minimal configuration change and have to be done once.
Having said that,i want to brought up a common fact about  deleting the messages,we generally delete the messages which is not required anymore,but will not take that extra pain,either,to remove it from 'Deleted Items' folder or use shift+delete,which will permanantly delete the messages from the mail box,there by
reducing the size considerably.

There is an easy work around for this, go to Tools->Options->Other->
Then click the checkbox 'Empty the Deleted Items folder upon exiting'.

Outlook option to empty deleted items folder
Next time when you close/exit your outlook a pop up appears
'Are you sure you want to permanently delete all the items and subfolders in the 'Deleted Items' folder ? with 'Yes' and 'No' buttons,
either you can hit the enter button or click 'Yes' for permanently deleting the messages from the mail box.
you may also like  how can we achieve the same through Registry Editor
->Config Regisry to Delete items on Exit

outlook 2007 registry key settings to empty deleted items folder

Navigate to the below path in your Registry.
HKEY_USERS\Software\Microsoft\Office\12.0\Outlook\Preferences 
,or go to  Edit->Find,enter the name 'EmptyTrash’

You are certain to find the entry/Name ‘EmptyTrash’

Modified the value from 0 to 1,like shown below.
This will  Empty the Deleted Items Folder upon close/exit of your mailbox.kool !!!  isn't it ?
Registry Entry for Empty Trash

Similiarly for composing a mail in outlook you can configure the
Registry to hide/display the options 'From,BCC'  etc,
by  modifying the values for ‘ShowBcc,ShowFrom’ from 0 to 1.

you may also like the Outlook configuration to 'Empty deleted items folder'