G.p.f. Calculation For West Bengal Govt Employees 33581j

Auto G.P.F. Calculation and Slip for W.B.Govt Employees only. Email- Gmail :- [email protected], Mobile:-8906279547, 9474316768 DATA INPUT SHEET .PUT THE DATA IN YELLOW COLUR CELL ONLY Name of the Office/Establishment

Sub Divisional Office

Designaton of the Employer

D.D.O.

Name,Address of the Office/Establish.

Lalbagh, Murshidabad

For the Year Ended

2009-2010

Name of the treasury

Lalbagh, Murshidabad 8.0%

Rate of Interest %

Pranab Banerjee,U.D.C.

NAME OF THE EMPLOYEE WITH DESIG. GPF A/C NO. Month April 09 May 09 June 09 July 09 August 09 Sept 09 Oct 09 Nov 09 Dec 09 Janu 10 Feb 10 March 10 Opening Balance 09

T.V.No.& Date 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

15486

www.pranab.jiaganj.com

N/WB/44662 Subscription 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000

Refund

Withdrawal

Type of Withdrawal

11000

16000

11000

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.

Prepared by Pranab Banerjee, Kalisthanpara,Jiaganj,Murshidabad,West Bengal. For Contuct by mail.

Gmail:- [email protected], Mobile No. 8906279547, 9474316768

G.P.F. FOR W.B. GOVT. EMPLOYEE NAME OF THE EMPLOYEE WITH DESIG.

Pranab Banerjee,U.D.C.

Rate of Interest %

GPF A/C NO. N/WB/44662 Month&Yr

T.V.No&Date Subscription

8.0%

Refund

TOTAL

Withdrawal

Balance

April 09

5, 3/4/09

3000

0

3000

11000

7486

May 09

7, 31/4/09

3000

0

3000

0

10486

June 09

9, 30/5/09

3000

0

3000

0

13486

July 09

10, 30/6/09

3000

0

3000

0

16486

August 09

6, 30/7/09

3000

0

3000

0

19486

Sept 09

5, 30/8/09

3000

0

3000

16000

6486

Oct 09

4, 30/9/09

3000

0

3000

0

9486

Nov 09

6, 30/10/09

3000

0

3000

0

12486

Dec 09

8, 30/11/09

3000

0

3000

11000

4486

Janu 10

10, 31/12/09

3000

0

3000

0

7486

Feb 10

12, 31/1/10

3000

0

3000

0

10486

March 10

2, 28/2/10

3000

0

3000

0

13486

TOTAL

36000

0

36000

38000

131832

Opening Balance Deposit & Refund

15486 Rs.

36000

2009-2010

Rs.

879

TOTAL

Rs.

52365

Deduction

Withdral

Rs.

38000

Closing Balance

as on 31/3/2010

Rs.

14365

Interest

Only Edit Yellow Cell

www.pranab.jiaganj.com

2/3

GOVT.OF WEST BENGAL Sub Divisional Office Lalbagh, Murshidabad Statement of G. P.F.A/c for the year ended 2009-2010 Treasury Lalbagh, Murshidabad Rate of Int. 8.0% NAME OF THE EMPLOYEE WITH DESIG. Pranab Banerjee,U.D.C.

GPF A/C NO. N/WB/44662 Month & Year April 09 May 09 June 09 July 09 August 09 Sept 09 Oct 09 Nov 09 Dec 09 Janu 10 Feb 10 March 10

TOTAL

Subscrp

Refund

Withdrawal

3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 3000 36000

0 0 0 0 0 0 0 0 0 0 0 0 0

11000 0 0 0 0 16000 0 0 11000 0 0 0 38000

Opening Balance Deposit & Refund Withdrawal Interest Closing Balance

Type of Remarks Withdrawal -

SUMMARY Rs. Rs. Rs. Rs.

15486 36000 38000 879 14365

D.D.O. Sub Divisional Office Lalbagh, Murshidabad

www.pranab.jiaganj.com