mis report format excel

News

Condonation of delay in submission of Forms related to Chartered Accountants Regulations, 1988


The rules regarding Condonation of delay in submission of Forms related to various regulations of the Chartered Accountants Regulations 1988 Documents to be submitted in case of delay in submission of following Forms

Recent Decisions of Ethical Standards Board of ICAI


ESB DECISIONS 1 A chartered accountants in practice cannot become Financial Advisors and receive fees commission from Financial Institutions such as Mutual Funds Insurance Companies NBFCs etc 2 A chartered accountant cannot exercise lien over the client documents records for non payment of his fees

ICAI President's Message - January 2017


My dear professional colleagues Circa 2016 A year that will be remembered in the history of India as a path breaking decisive dramatic period that sought to reinitialise the country towards a digital economy The gradual transformation that commenced with the JAM stack Jan Dhan Aadhar and Mobile and

Report of the Watal Committee on Digital Payments


Comments suggestions invited from the members of public on the Report of the Committee on Digital Payments within 15 days of hosting the Report on the website After approval of the Cabinet the Guidelines for the promotion of payments through cards and digital means were issued on February 29 2016 Am

16th ICSI national award for Excellence in Corporate Governance presented


On the Dias From L to R CS Dinesh Arora Secretary The ICSI CS Dr Shyam Agrawal Vice President ICSI Smt Nirmala Sitharaman Honble Minister of State I C Commerce and Industry Government of India CS Vineet Chaudhary Council Member The ICSI and Chairman Corporate Governance Laws Committee and CS Mamta B

More News



Experts Opinions

Premises purchase


Dear Experts We bought office premises for rs 1 53 22 000 down payment paid 53 22 000 and balance payment by bank loan Please suggest how can i pass all necessary journal entries Thanks Regards

what is head of broker (commission on sales)


i want to know what is the head of broker commission on sales in accounting software thanks in advance

Ms excel formula


is there any formula in excel for stocks so that my portfolio return will get maximised and correct weights will be maintainted for each stock so as to minimise portfolio risk

Format for cash flow statement for a normal partnership firm


How to prepare CFS for a Partnership Firm As AS 3 Format is applicable for Companies What is the CFS Format for Normal Firm

Late vat audit report


There is an assessee who has not filed its VAT Audit report 704 for F Y 2014 15 till date Now we are preparing for its audit report for F Y 15 16 Can we file form 704 for F Y 2015 16 without filing 704 for F Y 2014 15 What will be the consequences of such filing Please guide its very urgent

Discussion

Disallowance of expenses in audit report due to non deduction of tds

Assessee liable under compulsory audit u s 44AB has paid job work expenses to one company But the TDS was not deducted Hence expense u s 40A will be disallowed My question is In which point disallowance should be made In Point 21 b ii or point 34 a or both in form 3cd

Membership as a credit information company(cic) for a nbfc

I want to know about the fees and other registration process in details for taking membership certificate as Credit Information company The membership is required for a NBFC company As per RBI notification no RBI 2014 15 458 DNBR PD CC No019 03 10 01 2014 15 dated 6th February 2015 all NBFC company

Format of cash flow statement for a firm

How to prepare CFS for a Partnership Firm As AS 3 Format is applicable for Companies What is the CFS Format for Normal Firm

I need a format for justification report of project report for bank loan

I need a format for justification report of project report for bank loan I have fully furnished plant and machinery have minimum 3 cr per month export order

C.a. final financial reporting may 2017

Can anyone please tell me about CA Final Financial Reporting which book is better out of M P Vijay Kumar and Praveen Sharma for better understanding

More Messages






File Download

  • How to file EPF ECR in new portal

    I have explained How to generate ECR and how to file returns in EPF new portal
  • Income tax (1st Amendment) Rules, 2017

    Furnishing of Permanent Account Number or Form 60 as the case may be on or before 28th February 2017 is made mandatory for persons having an account with banking company or a cooperative bank to which Banking Regulation Act 1949 applies 15th January 2017 is the due date for submitting Form 61 where the aggregate of cash deposits between 9th November 2016 to 30th December 2016 is more than two lakh fifty thousand Government has mandated the specified class of persons under Rule 114E to report cash deposits made during the period 01 04 2016 to 09 11 2016 aggregating to an amount exceeding the limits as specified in Sl No 12 of Rule 114E Please find the attached PDF file for details
  • Information technology notes for CA IPCC

    Best notes for IPCC
  • Fixed Assets Format

    Xls
  • ECR Maker New in Excel

    For EPF Challan make sure your excel macro is enabled

More Files

Articles

Converting invalid date formats to valid ones in excel


By default Excel accepts date input in MM DD YY format US format unless you change the control panel settings of your PC Example 22 10 2007 or 22 10 2007 date may be considered invalid Important Note Technically every valid date is a number to Excel Lets see how Text to Columns can help clean date f


Converting numbers with minus sign into negative numbers in Excel


There are series of numbers wherein some of the numbers are ending with minus sign Now if you want to apply sum min max or average functions it will not work correctly as Excel cannot read 3789 as a negative Although it is rare to see this kind of data set in todays world if youare working with old


Changing the data format of a column in excel


Lets see how to split the data into multiple columns This is also part of data cleaning Sometimes your data are in one single column and you need to divide it into multiple adjacent columns for applying Sort Filter or Pivot table All the information is in one single column but you need to separate i


This new year, make a promise!


This is going to be my last article for the year So let me start it with a thank you note Thank you so much to CAclubindia team for giving me such a huge platform where I could share my views with such lovely and kind peopleand all the respected members who were part of my writing this year Thanks a


Admissibility of Cenvat credit without Registration


When there is lack of clarity in any subject matter there is bound to be confusion This statement is more so applicable when one is dealing with a Tax Statute Across the time each law matures and litigation reduces However the litigation regarding availment of Cenvat credit of tax paid before regist


More Articles


Updated on : 1/14/2017 9:09:14 AM


EY


KPMG


Talentedge


wiley


CCI Jobs

× Online Coaching My Enrolled Courses
Articles Forum News Experts Exams Share Files Income Tax Accounts Career Corporate Law Service Tax Video Judgements Rewards Top Members Events Albums Find Friends Featured Feed Scorecard Bookmarks Mock Test Poll Notification Knowledge Finder Coaching Institutes Trainee Corner Jobs
close x
  SHARE THIS