Employee G.P.F Interest And Closing Balance Calculation Sheet

Dear Friends,

Please open the attachment to calculate PF and interest. Add data only in the colored cells. WELCOME YOUR FEEDBACK.

JITENDRA PATEL
GUJARAT

One employee is going into retirement. He subscribed for only 3 months, and as per the rule, we closed the subscription in the General Provident Fund (GPF) three months before his retirement. My question is, can he avail interest on the three months' subscription and how much?

Dear Sir,

My name is Rudra, and I work at A.B.C. Trading Co. Ltd as an Admin. I need the total for Professional Tax as the company has not provided any details for the FY 10-11 and FY 11-12. Could you please inform me of the interest amount and guide me on how to calculate the interest using the appropriate formulas? Your assistance in this matter would be greatly appreciated.

I kindly request your help in resolving these issues.

Thank you.

Dear All,

I am working with a partnership firm. We are paying interest to partner capital for the financial year 2013-14. I want to know, is it necessary to deduct TDS on interest?