PF CALCULATION.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	AB
1				INTEREST CALCULATION OF P.F ACCOUNT							Interest
2	Name-	xxxxxxx			Year	1998	1999		Designation-		A/T
3	Month	Op.balance	Dep. Amnt	T.C no	dep.amnt.	T.C NO	w. amnt	Cheq.no	lowest bal.	interest	C.Balance	Interest Rate	Remarks
4	1	2	Bef.15th(3)	3(1)	Aft.15th(4)	4(1)	5	5(1)	6=(2+3-5)	7	8=(4+6)	9
5	April	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
6	May	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
7	June	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
8	July	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
9	August	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
10	September	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
11	October	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
12	November	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
13	December	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
14	January	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
15	February	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
16	March	5000.00	0.00						5000.00	29.58	5000.00	7.1		7.1
17	TOTAL		0.00		0.00		0.00			354.96	5355.00
18
19	1)	OPENING	BALANCE	Rs.	5000.00		4)	TOTAL	(1+2+3)	Rs.	5355.00
20	2)	TOTAL	DEPOSITS	Rs.	0.00		5)	WITHDR	WALS	Rs.	0.00
21	3)	TOTAL	INTEREST	Rs.	354.96		6)	CLOSSI	BALANCE	on 31/3 Rs	5355.00
22			TOTAL	Rs.	5354.96
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100