CAclubindia Articles

Identify duplicate names in data base using vlookup in excel

Posted by CA ROSHAN TIWARI 24 February 2014 37019 Views

SAMPLE DATA IS GIVEN BELOW :WRITE THE NAME YOU WANT TO CHECK FOR DUPLICATE ENTRY IN CELL C4 AS SHOWN BELOW :WRITE THE FORMULA IN CELL D7 & COPY IT FOR CELL ADDRESS AS SHOWN BELOW :WRITE THE FORMULA OF VLOOKUP IN CELL D4 AS SHOWN BELOW :IF THE N

Section 234E Cracked

Posted by Dingu 24 February 2014 47122 Views

Of late this month we must have received lot of demand from CPC seeking demand for non remittance of 234E FEES (not Tax). Well here is something to crunch on 234E will not apply to cases where TDS payment is made beyond the time limit prescribed for

Resolutions under the Companies Act, 2013

Posted by Vandana J Doshi 24 February 2014 392638 Views

Before going further, first of all let us understand what a Resolution is. A Company being an artificial person, any decision taken by it shall be in the form of a Resolution. Accordingly, a resolution may be

Highlight and Some question of Company ACT 2013

Posted by Binod 24 February 2014 52184 Views

Concept of independent director under new company act vs Co act 1956 Ans. 1. directors: Under Section 149 of the 2013 Act, there is a specific obligation on every listed public company that at least one-third of the board of directors should c

Beware !! Another Fraud in the Air !!

Posted by Prof. Bajaj 24 February 2014 18245 Views

Mr. Rajeev Kumar, a Chartered Accountant, working with a leading Automobile company was worried about his insurance policy. He had bought an insurance-cum-investment plan from a company (say K) 3 years back with an annual premium of Rs

Taxability of Foreign companies in recent times

Posted by CA. Kunal Lakhotia 24 February 2014 14522 Views

Controversy on taxability of Engineering Procurement & Construction (EPC) company EPC companies are those which design the installation, procure the necessary materials and build the project, either directly or by subcontracting par

One to one interaction of ICAI President with CAclubindia

Posted by Guest 20 February 2014 31252 Views

CAclubindia welcomes you all. We are here with our New ICAI President CA. K. Raghu. A worthy combination of youth, dynamism, experience and excellence, CA. K Raghu has taken over as the supreme torch-bearer of Indian accountancy profession as the Pre

Proposed DTC is anti-reform

Posted by CA Anil Garg 20 February 2014 12537 Views

Income Tax law must have suffered the most volatility and changes since enactment in 1961. Government has been twisting it at will in order to extract more and more revenue. This must have the dubious distinction of being subject matter of highest li

So, how do we solve our problems in India

Posted by CA Anil Garg 20 February 2014 12863 Views

Every 6th person in the world is an Indian. We are blessed with ancient civilization. History tells us that we have never been expansionists and have never attacked other countries. We have been happy to live within our borders and yet, we are afflic

Application of AS-22 in AS-19

Posted by ESHA AGRAWAL 20 February 2014 30050 Views

Hello everyone thanks for the appreciation for my last article why AS 22 is applied, coming with another article application of AS-22 in AS -19 leases. I am writing this article to discuss with