pf calculation in excel

News

Interest rate cut in PPF and KVP by 0.10 percent in this quarter


Interest rate cut for long term saving schemes The interest rates of Public Provident Fund PPF Kisan Vikas Patra KVP Senior Citizens Savings Scheme 2004 and Sukanya Samriddhi Account the Girl Child Scheme were reduced by 0 10 percentage point for the quarter 01 10 2016 to 31 12 2016 and not 0 10 per

ICSI requests MCA to extend last date for filing company annual return


THE INSTITUTE OF Company Secretaries of India IN PURSUIT OF PROFESSIONAL EXCELLENCE Statutory body under an Act of Parliament CS Mamta Binani PRESIDENT MCA 2016 Shri Tapan Ray Secretary tothe Government of India Ministry of Corporate Affairs A Wing Shastri Bhawan New Delhi 110 001 October 13 2016 Re

Presentation by CBEC on GST


PRESENTATION PLAN Why GST perceived benefits Existing indirect tax structure Features of constitution amendment bill Features of proposed GST model Features of draft GST law GSTN Role of CBEC Way forward PFA the enclosed attachment to view the presentation

GST draft Rules and Formats released


GST draft Rules and Formats released Changes in the Model GST Law are being carried out separately PFA the enclosed file for more details

Authorization of Practising CS for conducting Third Party Certification Audits


THE INSTITUTE OF CompanySecretariesof India IN PURSUIT OF PROFESSIONAL EXCELLENCE Statutorybodyunder an Act of Parliament PDPPS LL 2016 37 Dated September 09 2016 Dear Professional Colleagues Sub Authorization of Practising Company Secretaries for Conducting Third Party Certification Audits As you a

More News



Experts Opinions

Cst calculation on vat exempted silver anklets in tamilnadu


Dear Experts I m an Individual from TamilNadu I would like to know a few clarifications over following 1 Currently there is VAT exemption for SILVER ANKLETS in TN I wish to do an Inter State sale of this particular exempted good from TN to ANDRA PRADESH where current VAT for SILVER PRODUCTS is 1 So

Ppf account


Whether ppf a c can be apply online instead of visiting banks If yes SBI and union bank of india provide such amenties or nt Guide Do reply

Pf


There are 20 employees in our book binding house is it necessary to take registration under pf act

For sale bill calculation


SIR I HAD STARTED A BUSINESS OF CEMENT SALE BUT HOW I CAN CREATE A SALE BILL SO PLEASE HELP THERE WAS A DETAIL PURCHASE 2300 BAG 293 673900 VAT 14 94346 773646 IS TOTAL NOW SALE MY LABOUR TRANSPORT COST IS RS 20 PER BAG SO 2300 20 46000 AND RS 5 IS MY PROFIT SO THAT SALE AMOUNT IS 293 20 5 318 SALE

For sale bill calculation


SIR I HAD STARTED A BUSINESS OF CEMENT SALE BUT HOW I CAN CREATE A SALE BILL SO PLEASE HELP THERE WAS A DETAIL PURCHASE 2300 BAG 293 673900 VAT 14 94346 773646 IS TOTAL NOW SALE MY LABOUR TRANSPORT COST IS RS 20 PER BAG SO 2300 20 46000 AND RS 5 IS MY PROFIT SO THAT SALE AMOUNT IS 293 20 5 318 SALE

Discussion

Joint venture of a subsidiary calculation required- equity method

If a company X has a subsidiary Y 67 shareholding and the company Y has joint venture with company Z 50 Now what should company X account for JV 67 50 33 or 50 Pl provide the relevant IFRS example

Gap between pf accounts and contribution

The total number of Employees Provident Fund EPF member accounts as on 31 03 2016 as per Annual Report for 2015 16 is 17 14 crore On an average contributions have been received in respect of 3 76 crore members during the year 2015 16 Reasons for this gap are as under i The members after switching ov

Pension account amount in epf under in 80c

Hi there For a salarised person the EPF contributionthat comes from employer is divided into two parts one part goes to EPF and other 12 goes into pension account My previous employer never contributed his part of EPF and all EPF came from my side so never faced the below question Under 80C I can sh

Esi & pf

Dear Experts what is the applicability of ESI PF in case of contractor employed labor more than 15

Excel formula for converting amount from figure to words

Try this formula Firstly you need to add in through Addins Option in Excel and then you can use it

More Messages






File Download


More Files

Articles

What differentiates Excellence from Perfection?


What differentiates Excellence from Perfection was the inquisitive question posed by our senior one day As we floundered for words she remarked jovially In excellence you are perfect In perfection you arent excellent We chuckled at the witty paradox but as I pondered over later the remark seemed to


How to get latest stock price in Microsoft Excel


Have you ever wanted to have livestock updates in Microsoft Excel You might interested to watch Share Market to know the current value of your portfolio or your clients or else just for knowledge In this post we will learn about how to get stock quotes for specified all symbols using simple Excel Tr


SUMIFS - Advance Excel


This article is inspired by my recent conversion with interviewer where he had asked after detailed technical round Do you know Microsoft Excel and SUMIFS function As usual I said yes I know And then I thought is SUMIFS so important function in Microsoft Excel And if it is then I should write a deta


Two way lookup in Microsoft Excel - Advance Excel


If you are regular user of Microsoft Excel you might aware that there are different functions in Microsoft Excel which are used for lookups viz VLOOKUP HLOOKUP INDEX MATCH etc In this article Ill try to explain something exceptional in lookup functions which is easily understandable for anyone wheth


Extracting data in Microsoft Excel - Advance Filter


Before starting this article I thank to all members of CAclubindia for appreciating my articles on Advance Excel This article is in continuation with my Advance Excel tips and inspired by one of my friend facing problems in extracting relevant data in Microsoft Excel from Huge Raw Data dumped from E


More Articles


Updated on : 12/7/2016 5:56:10 AM


EY


× 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