pf calculation in excel


Application invited for 15th ICSI National awards for excellence in corporate governance

Applications are invited for the 15th ICSI National Awards For Excellence in Corporate Governance 2015 Please refer to the attached file for more details

Full Story

ICAI awards for excellence in financial reporting

ICAI AWARDS FOR EXCELLENCE IN FINANCIAL REPORTING Invitation to Participate in the Competition for the year 2014 15 Last date for receipt of entries 30th September 2015 Objective To recognise and enco

Full Story

IT dept receives PM award for excellence in public administration

Income Tax Department Awarded the Prime Ministers Award for Excellence in Public Administration for Easy Tax Compliance Through Quality Service The Income Tax Department has been awarded the Prime Min

Full Story

Govt decides to fix interest rate at 8.7% for GPF

Government Decides to Fix Interest Rates at 8 7 for General Provident Fund GPF and other Similar Funds Including Special Deposit Scheme 1975 SDS 1975 for Non Government Provident Superannuation and Gr

Full Story

New interest rates for PPF KVP and NSC announced

Government Announces Interest Rates for Various Small Savings Schemes Rates to Come Into Force with Effect from Tomorrow It was decided by the Government of India that interest rates on Small savings

Full Story

More News

Experts Opinions

Closing stock calculations for manufacturing co

Dear Sir We are Manufacturer and request you to tell us about Closing Stock Calculations Can We add all direct expenses to closing stock Kindly Reply sir

Read Expert Opinion

Interest on balance in pf - after retirement.

1 If an employee does not withdraw his PF on his retirement will he get interest on it 2 If so what will be the interest and how many years it will be credited to his account For E g if he retired on

Read Expert Opinion

Vat calculation

vat amount is calculate on assessable value or including basic excise duty with assessable value

Read Expert Opinion

Income tax liability calculation

Mr X is an employee of M s Y Ltd As per Form 16 A Y 2015 16 Total income is Rs 1133000 p a and TDS Deducted Rs 170000 At the same A Y M s Y ltd Issue Form 16A u s 194IA to Mr X of Rs 172350 and TDS de

Read Expert Opinion

Calculation of interest & penalty

Dear Sir Please solve my problem Total Excise Duty Payable 505000 for the month of Oct 2015 But We payment Only 205000 Balance amount Rs 300000 We will pay After 25 11 2015 Please calculate the Intere

Read Expert Opinion


Advanced excel

Hi i wanted to know whether we can bring Item Batch in Parellal Line to Item Name as shown in Excel Attached Format Present Sheet contains the default report derived from system Required Sheet contain

Read full discussion

Excel to Tally - Free Tally Data Migration Smart Tool

Excel to Tally Free Auto Tally Data Migration Smart Tool Download Free version of Excel to Tally Software Import unlimited Single debit and single creditvouchers entries master data in tally from Exce

Read full discussion

Epf esi procedure

What are the general compliance regarding epf esi from employers side Kerala Firstly ESI 1 We need to deduct provide for ESI conribution New joiners are added in ESI template which is available online

Read full discussion

Details about form 15g for pf withdrawal.

Hi I have big doubt whether to apply Form 15G for Pf withdrawal for my Dad His Pf will cross over Rs 1 00 000 He rendered service for 2 years and i know TDS is applicable The main thing i dont underst

Read full discussion

89(1) rebate calculation

bank employees got arrears this year for FY 2012 13 2013 14 2014 15 While disbursing arrears banksdeducted Some percentage of arrears as PF Example arrears 250000 PF 25000 This arrears 12 13 25 000 13

Read full discussion

More Messages

File Download

  • Form 11

    Form 11 epf


  • 86 Most Commonly Used Excel Functions

    This file contains a list of 86 most widely used Excel Functions and links to the MS office support website for their detailed descriptions with various examples There are over 500 functions in excel but knowing these are enough to help one do his her job with top efficiency Hope you like it


  • MVAT Annexure Generation Utility

    Generate Annexure J1 J2 J5 J6 Automatically from Tally erp or Tally7 2 or any Excel or ASCII file Veryfy TIN online with Mahavat gov in and extract the Name Status i e Active Cancell as per department record in a single click Auto verification of Non Filer Short Filer and composite Dealr List along with 704 Non filer dealr list updated by department time to time No need to sorting your data just export your data in excel or ASCII text formate and this utility will import your data automatically


  • Document Management addon for Tally

    Greetings fellow forum members Let me thank you for your valuable support advice and feedback on our first addon Continuing with the same we wish to present you with our new addon Document Management System Experience has taught accountants and buisnessmen to have ready access to documents related to all entries in an accounting system We have come up with an addon specifically to address such issues We present this Document Management addon a useful tool for people who wish to attach any bills invoices cerificates etc i e any file you wish to attach with any accounting entry as a supporting document or evidence Thus it helps for future reference for accountants and also for audit purposes for auditors This addon is a trial version which only works for contra entries as well as masters If you wish to attach any documentary evidence for withdrawal of cash from bank or vice versa you can attach scanned copy camera captured image of the deposit slip withdrawal slip For people who wish to attach supplier or vendor details say TDS certificates or VAT service tax certificates they can attach any such documents during creation or alteration of such masters This can be applied to many areas say assets where bills invoices may be attached or excel sheets having depreciation calculations can be attached The Paid version of this addon can be used for all voucher types We hope that this trial version will convince you of the full potential of this addon In case of any query or feedback please feel free to communicate Regards CA Deepak Agarwal Gyrotech info gyrotech in 7738286611


  • Service Tax Calculation

    Service Tax Calculation Sheet


More Files


TDS on withdrawal of EPF

TDS on withdrawal of EPF Employee Provident Fund U s 192A with effect form 01st June 2015 The Finance Act 2015 has Inserted a new section 192A regarding the TDS on payment of accumulated provident fun

Full Article

How to open PPF Account

PPF Procedures Step 1 Head over to your nearest State Bank of India branch or a branch of any of State Banks subsidiaries You can also open an account in select nationalized banks and the post office

Full Article

Pay reduced PF administrative charges

Reduction in Rate of Administrative Charges from 1 10 o to 0 85 o of the pay The Ministry of Labour and Employment Government of India has issued a notificationNo S O 323 E and S O 324 E both dated 02

Full Article

Vlookup's Advance Function (Advance Excel)

Lookups in Microsoft Excel most of us always preferred to go with VLOOKUP as it is regarded as a basic lookup function in Microsoft Excel and also essential for those who willing to work or already wo

Full Article

Excellence in Excel Series - Part IV Macros

Hey Friends I am back with another article on most easy and yet unpopular excel function macros Many of us as soons as hear the word Macros Only one thing comes into mind Difficult But friends believe

Full Article

More Articles

Updated on : 11/12/2015 4:23:10 PM

close x