CAclubindia Articles

In Pitru Paksha memorizing ancestors & their property taxation

Posted by CA Umesh Sharma 15 September 2014 8889 Views

Karniti Part 54:In Pitru Paksha memorizing ancestors & their property taxation.Arjuna (Fictional Character): Krishna, the fortnight starting from 9th September to 23rd September is called as pitrupaksha or shrad

Do's & Don'ts for dealing in a commodity market

Posted by rohit natani 15 September 2014 6581 Views

DOS AND DONTS FOR DEALING IN COMMODITY FUTURES Do`s Don`ts 1. Read the FMC/ Exchange guidelines and circulars available on the websites of the Exchanges

Banker's Legal Guide to dealing with Phishing scams in India

Posted by Guest 13 September 2014 7739 Views

Online banking revolutionized banking transactions, whereby money could be transferred at a single click. It has been a time saver and has been an extremely convenient method to undertake commercial transactions. However, it has lead to a slew of lit

Why do you need a professional advisor?

Posted by CA DHIRAJ SATNALIKA 13 September 2014 6356 Views

If you do your own business or if you are a tax payer, have you ever wondered whether you should turn things over to a professional advisor? This article attempts to shed some light on this topic and provide you with some things to think about so you

CA, CA and CMAs wait for the right job opportunity

Posted by Ankur Garg 13 September 2014 30815 Views

Dear Students, The problem of scarcity of job is not a new problem in the life of professionals like CA, CS or CMA. Many qualified professionals are waiting for right job opportunity. Some time back, in CCI, I have come across various threads regardi

Procedure for commencement of Business under CA 2013

Posted by Ankur Garg 13 September 2014 16180 Views

Under Companies Act 2013, the date of incorporation of a company cannot be the date of commencement of business. From the point of commencement of Business companies may be divided into 2 categories: Public and Private Companies not having Share Cap

Order u/s 147 without disposing objections to be quashed

Posted by CA Paras Dawar 12 September 2014 18654 Views

Reassessment order u/s 147 without first disposing off the preliminary objections raised by the assessee can not be sustained and is this liable to be quashedSupreme Court in GKN Driveshafts (India) Ltd. vs. ITO & Ors. (2003) 259 ITR 19 had dev

How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 42021 Views

In your day job, you have an excel workbook which is setup to get you the values you need, in the format you need. Probably using basic formulas, including VLookup.Nothing is more annoying and depressing to get your carefully set VLookup formulas get

Indirect Foreign Investment or Downstream Investment in India

Posted by Ankur Garg 12 September 2014 42330 Views

Guidelines for calculation of total foreign investment i.e. direct and indirect foreign investment in Indian companies is primarily governed by Press Note No 2 (2009 Series) issued by Ministry of Commerce & Industry, Department of Industrial Poli

Reverse/Backward VLOOKUP - Advance Excel function

Posted by @VaibhavJ 15 September 2014 108147 Views

Reverse or Backward Vlookup or lookup. For understanding reverse or backward VLOOKUP lets get clear about forward / direct VLOOKUP function her : http://www.caclubindia.com/articles/excel-function-vlookup-21678.asp So I assume you are clear ab