| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | ||||||||
2 | * Inputs are required to be made in cells marked "yellow". **For educational and informational use. Consult a qualified tax expert. | |||||||
3 | Particulars | Employee's Non Taxable Portion of PF (till FY 2020-21 and contribution upto Rs 2.50 lacs plus interest thereon from FY 2021-22) | Employee's Taxable portion (w.e.f FY 2021-22) | |||||
4 | Opening Balance (on 1 Apr 2021) | 100,000.00 | - | |||||
5 | ||||||||
6 | ||||||||
7 | Rate of Interest on PF * (for FY 2021-22) | 8.10% | ||||||
8 | ||||||||
9 | Month | Employee's Contribution to PF (including VPF) | Employee's PF contribution for Taxable Interest calculation | Interest till end of year | Exempt Interest | Taxable Interest | ||
10 | April | 27,000.00 | 27,000.00 | 2,004.75 | 2,004.75 | - | ||
11 | Whether monthly contribution is same or different for each month | Different for different month | 92,000.00 | |||||
12 | May | 27,000.00 | 27,000.00 | 1,822.50 | 1,822.50 | - | ||
13 | June | 27,000.00 | 27,000.00 | 1,640.25 | 1,640.25 | - | ||
14 | July | 27,000.00 | 27,000.00 | 1,458.00 | 1,458.00 | - | ||
15 | August | 27,000.00 | 27,000.00 | 1,275.75 | 1,275.75 | - | ||
16 | September | 27,000.00 | 27,000.00 | 1,093.50 | 1,093.50 | - | ||
17 | October | 30,000.00 | 30,000.00 | 1,012.50 | 1,012.50 | - | ||
18 | November | 30,000.00 | 30,000.00 | 810.00 | 810.00 | - | ||
19 | December | 30,000.00 | 30,000.00 | 607.50 | 567.00 | 40.50 | ||
20 | January | 30,000.00 | 30,000.00 | 405.00 | - | 405.00 | ||
21 | February | 30,000.00 | 30,000.00 | 202.50 | - | 202.50 | ||
22 | March | 30,000.00 | 30,000.00 | - | - | - | ||
23 | Interest on current year contribution | 12,332.25 | 11,684.25 | 92,648.00 | ||||
24 | ||||||||
25 | Interest on Opening Balance till 31 Mar 2021 | 8,100.00 | 8,100.00 | - | ||||
26 | Total Interest for the Financial year | 20,432.25 | 19,784.25 | 92,648.00 | ||||
27 | ||||||||
28 | Particulars | Employee's Total PF balance | Employee's Non Taxable Portion of PF Balance | Employee's Taxable Portion of PF Balance | ||||
29 | Opening Balance at beginning of Financial Year(1 Apr) | 100,000.00 | 100,000.00 | - | ||||
30 | Fresh contributions by the employee during the year | 342,000.00 | 250,000.00 | 92,000.00 | ||||
31 | Interest on PF | 112,432.25 | 19,784.25 | 92,648.00 | ||||
32 | Closing Balance at end of Financial Year | 554,432.25 | 369,784.25 | 184,648.00 | ||||
33 | TDS @10% | 9,264.80 | ||||||
34 | ||||||||
35 | ||||||||
36 | Based on calculator by srikant.agarwal@gmail.com | |||||||
37 | ||||||||