pf calculation in excel

News

SPMCIL contributed to the world's biggest exercise of demonetisation


Honble Union Minister of Finance Sh Arun Jaitley gives away awards for excellence at the 11th Foundation Day celebrations of Security Printing and Minting Corporation of India Ltd SPMCIL SPMCIL contributed to the worlds biggest exercise of demonetisation SPMCIL is among the few government companies

Material applicable for IPC and CA Final Course for May 2017


FINAL COURSE Eng Edition applicable for May 2017 Final Exams Financial Reporting Study Material January 2016 RTP May 2017 or January 2017 Practice Manual January 2016 Accounting Pronouncements January 2016 Strategic Financial Management Study Material January 2015 Practice Manual January 2015 Supple

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

More News



Experts Opinions

Esic Epfo


Dear all We are ND CONSULTANTS Plz contact us to provide an opportunity to serve you a quality HR services or to just discuss laws their applicability under Labour and employment act Regards NITISH KUMAR 7042521744

Epf


Any one please share how to file EPF return in EPF site and what are the steps and procedure for completing that return

Conveyance allowance calculation


Dear all Please guid me for the following conveyance allowance calculation Conveyance Allowance earning details April 832 May 864 Jun 832 Jul 832 Aug 8367 inclusive of arrears from april15 to jul 16 Sep 1664 Oct 1728 Nov 1664 Dec 1728 Jan 1664 Feb 1664 March 1664 Please guid me how to calculate conv

what is the entry of employer's contribution towards epf and pension fund???


is it necessary to do a single entry of employer s towards epf and pension fund contribution with salary due entry of salary due is basic pay dr hra dr conveyance dr and all allowances given by employer debited salary payable cr esi contri cr epf contri cr and all deduction made by employer credited

Ppf withdrawal limit of non contributing account


Hi I am a software professional currently self employed I started my PPF way back in 2000 for tax saving purposes with regular contributions to my PPF till 2015 However in 2013 I got a good long term job opportunity in US and moved there with my family In 2015 my PPF completed 15 years and as I was

Discussion

Cost of improvement for calculation of short term capital gains in respect of shares

In one of the provisos of S 48 STT has been specifically excluded for the purpose of calculation of capital gains However STT becomes a cost to the investor and S 55 does not make any specific exclusion Can S 55 override proviso to s 48 w r t STT

Excel to tally

Dear All If you have excel to tally import template then pls send on girishtax gmail com Thanks 9922338896

Calculation of pf arrear

Hi What is the calculation of PF arrear

Da calculation is different and no uniformity

Hi all of you I am doing a self study Last few attempt I had given but could not succeed While solving Study Mat Problem of Q3 and Q4 DA is calculation is different under Salary Head Kindly clarify me why it is different and explain in detail I have attached excel file including solution but not cle

Ppf withdrawal limit of non contributing account

Hi I am a software professional currently self employed I started my PPF way back in 2000 for tax saving purposes with regular contributions to my PPF till 2015 However in 2013 I got a good long term job opportunity in US and moved there with my family In 2015 my PPF completed 15 years and as I was

More Messages






File Download


More Files

Articles

Adding suffix in cells in MS Excel


Suppose you have a weight record of children and it looks like below You want to change the column as the After section You can add another column and write Kg and then concatenate these fields But again the same problem will be there and you not be able to calculate So how will you format cells in


Trick to add digits in a cell in Excel


Now I will tell you how to add prefix 00 for a check number For example you have the data like below before Now the point is how you will format cells in excel so that total digit should look like six digit code It is possible to add zeroes manually But the zeroes will go away until and unless you c


Tricks to Format cells in Excel: Currency Format (Prefix)


I have a large record set of the amount I want toadd prefix i e Rs in my records so that I can apply sum average min max function I can easily do it by typing it manually but then I will not be able to apply any function If I enter any amount in this column I will need to add Rs prefix manually If y


Tricks to Format cells in Excel: Trailing Dots


Here I will talk about how to format cells in excel with trailing dots For example you have a list of names of your clients I want to add dots so that it looks good and is also self adjusting Lets look at this example I have the list of client names and I want to add dots so that it looks good You m


Tricks to Format cells in Excel: Date Format


Lets take an example you have a long set of dates in cells like below And you want to change the date format as a dd mm yyyy format So that it can show the date format like 2 Apr 2014 which is easy to read Normally what we do is Select the entire range of cells Right click and then click on Format c


More Articles


Updated on : 2/26/2017 8:50:32 AM


CCI online Coaching


KPMG


MilesEducation



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