CAclubindia Articles

How to make VLookup Foolproof

Posted by Ramkrishna Mokashi 12 September 2014 41935 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 42256 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

Interview with tax audit report petitioners

Posted by CA Sudhir Halakhandi 11 September 2014 13541 Views

The Mid-year introduction of New formats of Tax audit reports and further extension of date of Tax audit report without extendin

Excel function VLOOKUP

Posted by @VaibhavJ 11 September 2014 50204 Views

1st Question now a days which comes while soft skill interview is.......Do you know VLOOKUP & if you dont respond immediately there grows eyebrows of interviewer up with that grinny smile on his/her face; lets bettle it out & be the master of

Cenvat credit available prior to service tax registration

Posted by Bimal Jain 11 September 2014 12696 Views

Dear Professional Colleague,Service provider is eligible to avail Cenvat credit on inputs/ input services prior to Service tax registrationWe are sharing with you an important judgment of the Honble CESTAT of New Delhi in the case of Actis Adv

Start Up's beware: Every year start-ups lose more than US $3 billion

Posted by Paras mehra 10 September 2014 12922 Views

Raghav Raj Raman, IT software engineer, with his friend started a business of providing designer, developer consultancies to various clients in India and abroad. They are skillful enough but still they are not able to earn much. Therefore, they decid

Reimbursement expenses arent includible in assessable value of services

Posted by Bimal Jain 10 September 2014 17992 Views

SERVICE TAX RECENT CASE LAWS Cenvat credit on inputs/ input services received by an output service provider prior to obtaining Service tax registration is admissible Actis Advisers Pvt. Ltd. Vs. CST. -Delhi-IV [(2014) 9 TMI 182 - CESTAT New Delhi]

Professional Courses to be pursued after or along with CA

Posted by Ankur Garg 09 September 2014 337298 Views

CA Dear Students, Many times in expert and forum section I have come across a question or career doubts what are the study options available along with Chartered Accountancy course or Company Sec

Important Company Law Procedures at one place Part-2

Posted by Ankur Garg 09 September 2014 21458 Views

Dear Professional Colleague In last few days I have written and uploaded different corporate law procedures under Companies Act, 2013 for fellow professionals. In this article you may find some of them at one place in to the point and crisp language.

Completing ITax Return without Completing Tax Audit Report

Posted by Mera Consultant 09 September 2014 24659 Views

The extension of date for obtaining and submitting the Tax Audit Report till 30th November 2014 for the Assessment Year 2014-15 without extending the due date to file the Return of Income has created many concerns in the minds of Chartered Accountant