CAclubindia Articles

How to make VLookup Foolproof

Ramkrishna Mokashi 12 September 2014 at 10:44

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

Ankur Garg 12 September 2014 at 10:44

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

CA Sudhir Halakhandi 11 September 2014 at 10:36

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

@VaibhavJ 11 September 2014 at 10:36

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

Bimal Jain 11 September 2014 at 10:29

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

Paras mehra 10 September 2014 at 14:53

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

Bimal Jain 10 September 2014 at 11:03

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

Ankur Garg 09 September 2014 at 10:22

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

Ankur Garg 09 September 2014 at 10:21

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

Mera Consultant 09 September 2014 at 10:21

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