pf calculation in excel

News

Highlights of Major Changes in CGST / IGST Bill


Highlights of Major Changes in CGST IGST Bill PFA the file to know more in details

Govt announces revised rates of interest on Small Savings leaves PPF untouched


The Union Government has announced revised rates of interest on Small Savings Schemes for the First Quarter of 2017 18 to bring them somewhat closer to market rates Small Savings schemes will continue to be attractive as some of them enjoy income tax benefits and additional interest rate spreads Rev

EPF members can withdraw upto 90 percent fund for purchase of house


Government to Amend EPF Scheme 1952 to Enable EPF Members to Withdraw upto 90 Percent Fund for Purchase of House The Government has taken a decision for modification in the Employees Provident Funds EPF Scheme 1952 to add a new paragraph 68 BD under which a member of Employees Provident Fund EPF bei

ICSI achieves landmark of 50000 CS members


ICSI achieves landmark in its Pursuit of Professional Excellence reaches 50 000th CS Membership Mark Shri Arun Jaitley Honble Union Minister for Finance and Corporate Affairs awarding CS Membership certificate to the 50000th CS Member CS Ashutosh Shukla in the presence of CS Dr Shyam Agrawal Preside

Transfer from Recognized Provident and Superannuation Fund to National Pension Scheme


Clarification by Pension Fund Regulatory and Development Authority PFRDA on transfer of amount from Recognized Provident Fund Superannuation Fund to National Pension Scheme NPS In the budget of 2016 17 the Government had announced that the subscribers from recognised Provident Funds and Superannuati

More News



Experts Opinions

Pf refund


i have work for organisation more than a year and have absconded from the organisation can i claim my pf from employer plz let me know

Excel VBA


Hello everyone I am a CA final student and i want to know what are the benefits of Excel VBA for a Chartered Accountant Thankyou

Articleship working hour calculation


I would like to know whether travelling out of town for official purpose at unofficial time i e Audit Purpose is counted in Working hour For example office time is 10 00 AM and if article assistant has to go out of town in 07 00 AM then will this 3 Hours be counted in Working Hours

PF AND ESI UNDER SUPPLY OF LABOUR


Hello I am a sub contractor of xyz co MNC I provide labour to that company Co will dedcut PF and ESI of my labour from my ac So i want some solution how can i save the PF and Esi amount of my employee or my labour

Epf


If an employee was absent 2 days during the months then how to calculate EPF Lets take an example If his monthly salary is Rs 12 000 P M Basic DA and his absent will be deducted from salary Whether PF will be deducted on Rs 12 000 or Rs 11 200 after deducting 2 days salary Pls help

Discussion

Is epf act applicable?

one of my client have 30 employee and each has salary greater than 26000 is EPF act applicable to company

Calculation

A works contractor an indivudual raised bills of Rs 48 lakhs and received payment of Rs 40 lakhs in the first year of his business How the theshold exemption and service tax will e calculated

Bonus act - calculation of allocable surplus

As per schedule III of the act the company needs to deduct 8 5 of the paid up share capital from the gross profit calculation But what if company having 4 different units and different location and having its own profit and loss account And there is only one balance sheet Consolidated which consists

Gst invoice format in excel

hi Friends This Invoice formate is use full for GST Invoices

Regarding epf contribution

Dear Sir If a company gives a contract on piece meal rate then is there any liability of company for epf

More Messages






File Download

  • March End Stock Exchange Compliance

    Excel
  • Excel Shortcuts

    List of excel shortcuts
  • IPCC Account G-1 Expected Paper for May 17

    IPCC ACCOUNT G 1 EXPECTED QUESTION PAPER FOR MAY 2017 PLEASE NOTE IT S NOT MAIN PAPER QUESTIONS WILL NOT BE ASKED FROM HERE IF YOU ATTEMPT THIS SAMPLE PAPER SUCCESSFULLY I CAN SAY YOU WILL SCORE EXCELLENT MARKS IN UPCOMING EXAM IN MAY 2017 SO ARE YOU READY FOR THIS HIGH LEVEL TYPICAL TEST
  • IPCC Account G-1 Expected Paper for May 17

    IPCC ACCOUNT G 1 EXPECTED QUESTION PAPER FOR MAY 2017 IT S NOT MEAN PAPER WILL ASK FROM HERE IF YOU ATTEMPT THIS SAMPLE PAPER SUCCESSFULLY I CAN SAY YOU WILL SCORE EXCELLENT MARKS IN UPCOMING EXAM IN MAY 2017 SO ARE YOU READY FOR THIS HIGH LEVEL TYPICAL TEST
  • IT calculation FY 2017-18 salaries

    I m pleased to share the attached IT calc FY 2017 18 on salaries it includes NSC vii issue interest calc rent receipt form and computation sheet The file compatible with ms excel 2003 ver it will also work with other versions The controls assigned at cell levels as per IT rules provisions The HRA rent hence if you get arrears of previous months you can get it distributed monthly basis to compute the tax correctly The tax calculate with the formula of marginal relief i e in case levy of surcharge on Income tax for the taxable salary above 50lakh and 1crore I shall appreciate and welcome your suggestions Best regards Vijay

More Files

Articles

17 Useful Ribbon Shortcuts Used by Excel Experts


Today lets learn how we can work faster on Excel using Ribbon Shortcuts Ribbon shortcuts for those of you who dont know are the shortcuts formed by a chain of keys pressed in a particular sequence after pressing the Alt key to help perform tasks by using the different options given in the excel ribb


Guide to Data Cleaning in Excel


Data cleaning is one of the necessary excel skills that you are expected to possess today A data set might be having certain inconsistencies and to make it morepresentable and to helpproper understanding of the data it is necessary to make the data look better and error free Below I mention11 best t


Convertible Bonds Calculations - Equity & Liability portion - Ind AS/ IFRS


Many of our readers requested to share actual calculation and the process to bifurcate any convertible bonds between Equity Liability and its related Journal Entry Let s refer some relevant guidance reference related to these kind of convertible bonds and its related calculation as mentioned in acco


ESI Registration process and Registers and Records to be maintained under ESIC & PF


Employees State Insurance Act 1948 was formulated so as to protect interests of workers and employees working in India The act being based upon social insurance scheme grants funds to employees in case of injury sickness maternity any temporary and permanent Disablement and death caused due to emplo


Learn how to compare two columns in Excel


Like a two dimensional database Excel is capable of storing many different types of data from small business contacts to personal income tax records In both of these examples accuracy is essential to make sure you have the information you need when you need it In any data entry situation people ofte


More Articles


Updated on : 4/27/2017 9:03:15 AM


CCI online Coaching


KPMG



GSTSUTRA


CCI Jobs

×
close x
Download GST App    |    x