General Provident Fund Calculation for W.B.Govt employees

GPF AC SLIP GPF AC REGIST.& AC SLIP OF Data input Sheet Month Refund Withdrawal Balance TOTAL Rs. Interest Deduction T.V.No&Date Subscription Deposit & Refund Interest Withdral GPF A/C NO. T.V.No.& Date April 09 May 09 June 09 July 09 August 09 Sept 09 Oct 09 Nov 09 Dec 09 Janu 10 Feb 10 ADMN/WB/44662 NAME OF THE EMPLOYEE WITH DESIG. Pranab Banerjee,U.D.C. 5, 3/4/09 7, 31/4/09 9, 30/5/09 10, 30/6/09 6, 30/7/09 5, 30/8/09 4, 30/9/09 6, 30/10/09 8, 30/11/09 10, 31/12/09 12, 31/1/10 2, 28/2/10 Closing Balance as on 31/3/2010 Prepared by Pranab Banerjee, Kalisthanpara,Jiaganj,Murshidabad,West Bengal. 2009-2010 Opening Balance Name of the Office/Establishment For the Year Ended Rate of Interest % Name of the treasury Insert Withdrawal Amount. Which Month You withdrawn Put the Amount in the same month.It is possible to frequently withdrawn, as example I have withdrawn in the month of June 09 Rs.5000/- and again withdrawn Rs 5000/- in the month of November 09.If you have no withdrawal so you leave blank the Withdrawal Column. GOVT.OF WEST BENGAL Treasury Rate of Int. Month & Year Subscrp Type of Withdrawal SUMMARY Closing Balance Lalbagh, Murshidabad Statement of G. P.F.A/c for the year ended DATA INPUT SHEET .PUT THE DATA IN YELLOW COLUR CELL ONLY Name,Address of the Office/Establish. Sub Divisional Office Designaton of the Employer D.D.O. Remarks G.P.F. REGISTER FOR W.B. GOVT. EMPLOYEE March 10 Opening Balance 09 Month&Yr Auto G.P.F. Calculation Register and Account Slip for W.B.Govt Employees only. Email- Gmail :- pranab.banerjee83@gmail.com, Mobile:-8906279547, 9474316768 Only Edit Yellow Cell For Contuct by mail. Gmail:- pranab.banerjee83@gmail.com, Mobile No. 8906279547, 9474316768 www.pranab.jiaganj.com www.pranab.jiaganj.com www.pranab.jiaganj.com Sub Divisional Office Lalbagh, Murshidabad 2009-2010 Lalbagh, Murshidabad 0.00 NAME OF THE EMPLOYEE WITH DESIG. Pranab Banerjee,U.D.C. GPF A/C NO. ADMN/WB/44662 April 09 0000.00 0.00 00000.00 $0.00 May 09 0000.00 0.00 0.00 $0.00 June 09 0000.00 0.00 0.00 $0.00 July 09 0000.00 0.00 0.00 $0.00 August 09 0000.00 0.00 0.00 $0.00 Sept 09 0000.00 0.00 00000.00 $0.00 Oct 09 0000.00 0.00 0.00 $0.00 Nov 09 0000.00 0.00 0.00 $0.00 Dec 09 0000.00 0.00 00000.00 $0.00 Janu 10 0000.00 0.00 0.00 $0.00 Feb 10 0000.00 0.00 0.00 $0.00 March 10 0000.00 0.00 0.00 $0.00 00000.00 0.00 00000.00 Opening Balance 00000.00 00000.00 00000.00 000.00 00000.00 D.D.O. Sub Divisional Office Lalbagh, Murshidabad www.pranab.jiaganj.com / www.pranab.jiaganj.com / www.pranab.jiaganj.com / NAME OF THE EMPLOYEE WITH DESIG. Pranab Banerjee,U.D.C. GPF A/C NO. ADMN/WB/44662 Rate of Interest % 0.00 April 09 5, 3/4/09 0000.00 0.00 0000.00 00000.00 0000.00 0000.00 May 09 7, 31/4/09 0000.00 0.00 0000.00 0.00 00000.00 00000.00 June 09 9, 30/5/09 0000.00 0.00 0000.00 0.00 00000.00 00000.00 July 09 10, 30/6/09 0000.00 0.00 0000.00 0.00 00000.00 00000.00 August 09 6, 30/7/09 0000.00 0.00 0000.00 0.00 00000.00 00000.00 Sept 09 5, 30/8/09 0000.00 0.00 0000.00 00000.00 0000.00 0000.00 Oct 09 4, 30/9/09 0000.00 0.00 0000.00 0.00 0000.00 0000.00 Nov 09 6, 30/10/09 0000.00 0.00 0000.00 0.00 00000.00 00000.00 Dec 09 8, 30/11/09 0000.00 0.00 0000.00 00000.00 0000.00 0000.00 Janu 10 10, 31/12/09 0000.00 0.00 0000.00 0.00 0000.00 0000.00 Feb 10 12, 31/1/10 0000.00 0.00 0000.00 0.00 00000.00 00000.00 March 10 2, 28/2/10 0000.00 0.00 0000.00 0.00 00000.00 00000.00 00000.00 0.00 00000.00 00000.00 000000.00 000000.00 00000.00 00000.00 000.00 000.00 00.00 0.00 00000.00 00000.00 00000.00 www.pranab.jiaganj.com www.pranab.jiaganj.com www.pranab.jiaganj.com 0.00 0000.00 00000.00 0000.00 0000.00 0000.00 0000.00 0000.00 00000.00 0000.00 0000.00 0000.00 00000.00 0000.00 0000.00 0000.00 00000.00 Put the amount as opening balance,which comes from previous year's Closing Balance. Put only March Subscription.Another Month Subscription not need to put any month. If has no gpf loan recovery,so leve blank the refund cell.