pf calculation in excel


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

CBT recommends 8.65% interest on EPF for the year 2016-17

Shri Bandaru Dattatreya chaired the 215th meeting of the Central Board of Trustees EPF CBT recommends 8 65 interest on EPF to its subscribers for the year 2016 17 The Minister of State for Labour and Employment Independent Charge Shri Bandaru Dattatreya chaired the 215thmeeting of the Central Board

ICAI submits Pre-Budget Memoranda-2017

ICAI submits Pre Budget Memoranda 2017 PFA the file to know in details

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

More News

Experts Opinions

is law scanner helpful? for ca final

for law ca final questions practice I want to purchase scanner of suchitha publication is it helpful

Mpbf calculation

Hi Can anyone guide me on MPBF calculation in case of work contractor Thanks in advance

80 c ppf

Can a Grandmother get deduction u s 80 C towards contribution in PPF a c of Grandchild the PPF a c being in the name of minor Grandchild

Calculation of perquisite rule 3(7)(i)

Dear Experts We had granted the interest free loan of 1 Lakh to one of our employee to meet the cost of disease specified under rule 3A however as per this rule the loan was exempt but employee has also received the medical insurence of Rs 60000 as on 16 1 2017 pls clarify weather this will be taxab

Cpf received to nominee



Pf contribution of previous years

Hi Some employees were not included in epf in previous year Is there any way to pay their contribution of previous year Please share your knowledge about this aspect Thanking you in advance friends

Regarding mention of balances of ppf, mutual fund and bank fd in balance sheet of itr-4

Plz clarify me where to mention balances as mentioned above in ITR 4

Pf ecr new dec 16-uploading error

PF new ECR so many uploaded but it show same error like Error EPS Contribution Remitted Max equal to rounded 8 33 of EPS Wages added with rounded 1 16 of the EPS Wages above 15000 found on line numbers 2 112 114 117 128 131 132 137 141 144 146 147 154 158 159 187 194 203 204 213 218 235 256 259 276

Epfo new potal

Pay EPF BY this new link https unifiedportal emp epfindia gov in epfo

Ppf account

PPF Account can be extended for another 5 years beyond normal 15 years Does a person make deposit in the PPF Account during the extended period and should that amount qualify for deduction u s 80C

More Messages

File Download

More Files


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

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

More Articles

Updated on : 1/21/2017 9:05:18 AM

CCI online Coaching




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