| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | BS | BT | BU | BV | BW | BX | BY | BZ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Annual Salary Calculator | 2020 | -21 | (ASSESSMENT YEAR 2021-22) | (Read carefully and fill properly....) | |||||||||||||||||||||||||||
2 | if you see "Unprotect Sheet" Dialogue just cancel it and go to DATA ENTRY CELL(pink or blue cell) | |||||||||||||||||||||||||||||||
3 | Colour Indicators--> | --> DATA ENTRY CELL | --> Drop Down boxes | MONTH CODES: JAN=1, FEB=2..MAR =3, ......DEC=12. | ||||||||||||||||||||||||||||
4 | SALARY PARTICULARS | ** | ** | updated on 27/12/2020 | ||||||||||||||||||||||||||||
5 | PAY PARTICULARS | Please read every row carefully. Then fill-up the data in pink or blue cells. | Click here to watch video on YouTube | |||||||||||||||||||||||||||||
6 | CLICK HERE TO ENTER YOUR DETAILS | Click here to go to 'Editing Sheet' | ||||||||||||||||||||||||||||||
7 | 1) | If u Select AUTOMATIC (It Enters ur salary every Month),YEAR (It calculates for Whole Year) | YEAR | |||||||||||||||||||||||||||||
8 | 2) | Select Employee Group:(A,B,C,D A(NPS),B(NPS),C(NPS),D(NPS), A(AIDED),C(AIDED),,,, | C | C | ||||||||||||||||||||||||||||
9 | 3) | Enter Basic Pay as in March-2020 | 0 | 7 | ||||||||||||||||||||||||||||
10 | DAY/DA% | Month | 0 | Click here to go Form No.16 | ||||||||||||||||||||||||||||
11 | 4) | ENTER ANNUAL INCREMENT TAKEN DATE/MONTH(DD/MM) | 0 | 7 | 0 | |||||||||||||||||||||||||||
12 | 5) | ENTER TIME BOND TAKEN DATE/MONTH(DD/MM) | 1 | 0 | 0 | |||||||||||||||||||||||||||
13 | 6) | Enter lncreased DA% of January; then Enter Month Code | 11.25% | 0.00% | 0 | 0 | ಆದಾಯ ತೆರಿಗೆ: ಫಾರ್ಮ್ ನಂ.16 | |||||||||||||||||||||||||
14 | 7) | Enter lncreased DA%, of July; then Enter Month Code | 0.00% | 0 | Enter | 4 | ||||||||||||||||||||||||||
15 | 8) | Select Surrender Taken Month Code (Ex:-Jan=1, Mar=3 NO=0, ..) | 0 | Amount | 0 | |||||||||||||||||||||||||||
16 | 9) | Select Your City for CITY ALLOWANCES or Others | OTHERS | 0 | C | |||||||||||||||||||||||||||
17 | 10) | USE THIS COLOUMN AS OTHERS then Enter Amount | NO | OTHERS | 0 | Click here to add any other income details | ||||||||||||||||||||||||||
18 | 11) | Select PH/OTHERS/Special Pay | OTHERS | 0 | ||||||||||||||||||||||||||||
19 | 12) | Select YES for Auto Calculatuon of Pay Arrears , Otherwise NO | NO | 0 | 0 | |||||||||||||||||||||||||||
20 | 13) | IF you are Not getting HRA Allowance Select NoHRA otherwise Select HRA | HRA | www.freegksms.blogspot.in | ||||||||||||||||||||||||||||
21 | DEDUCTIONS | DEDUCTIONS IN SALARY | Enter | |||||||||||||||||||||||||||||
22 | Amount | REVISED PAY SCALES (6th PAY) INCREMENT RATE | ||||||||||||||||||||||||||||||
23 | 14) | Taxes Paid in Advance/ Others... then Enter Amount | TAX PAID | 0 | 17000-400-18600-450-20400-500-22400-550-24600-600-27000-650-29600-750-32600-850-36000-950-39800-1100-46400-1250-53900-1450-62600-1650-72500-1900-83900-2200-97100-2500-112100-2800-128900-3100-150600 | |||||||||||||||||||||||||||
24 | 15) | Select LIC then Enter Amount | LIC | 0 | ||||||||||||||||||||||||||||
25 | 16) | Select KGID.. then Enter Amount | 0 | KGID | 0 | |||||||||||||||||||||||||||
26 | 17) | Select FA, ROP, NPSArrs or OTHERS.. then Enter Amount | 0 | FALSE | ||||||||||||||||||||||||||||
27 | 18) | 0 | FALSE | 0 | GPF | |||||||||||||||||||||||||||
28 | 19) | SELECT SEX:- | MALE | ANNUAL SALARY STATEMENT FOR THE FINANCIAL YEAR 2020-21 | ||||||||||||||||||||||||||||
29 | Standard Deduction | YES | NAME OF EMPLOYEE:- SOMASHEKHAR M BELLUBBI | KGID NO:- gg | PAN NO:- KJH765Jyyy | BANK A/C NO.:- 000066700000 | ||||||||||||||||||||||||||
30 | EDITING | FINANCIAL YEAR | SCHOOL/OFFICE:- GHPS BANAHATTI TOTA | TQ;- RABAKAVI-BANAHTTI | DIST:- BAGALAKOTE | IFSC CODE:- Dd67ghh | ||||||||||||||||||||||||||
31 | 4/1/2020 | <---> | 3/31/2021 | MONTHS | PAY PARTICULARS | GROSS SALARY | DEDUCTIONS | DEDUCTIONS | NET SALARY | 0 | ||||||||||||||||||||||
32 | 20) | Editable Month Wise DA% | YOU CAN EDIT YOUR BASIC PAY HERE | EDITABLE HRA % (MONTH) | BASIC PAY | DA | HRA | MA | OTHERS | OTHERS | OTHERS | TAX PAID | FALSE | P.TAX | LIC | KGID | FALSE | 3 | ||||||||||||||
33 | 3 | 0.00% | 0 | 0% | Mar-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | ||||||||||
34 | 4 | 0.00% | 0 | 0% | Apr-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | ||||||||||
35 | 5 | 0.00% | 0 | 0% | May-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | ||||||||||
36 | 6 | 0.00% | 0 | 0% | Jun-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | ||||||||||
37 | 7 | 0.00% | 0 | 0% | Jul-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | ||||||||||
38 | 8 | 0.00% | 0 | 0% | Aug-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | ||||||||||
39 | 9 | 0.00% | 0 | 0% | Sep-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | ||||||||||
40 | 10 | 0.00% | 0 | 0% | Oct-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | ||||||||||
41 | 11 | 0.00% | 0 | 0% | Nov-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | ||||||||||
42 | 12 | 0.00% | 0 | 0% | Dec-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||||||||||
43 | 1 | 0.00% | 0 | 0% | Jan-21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | ||||||||||
44 | 2 | 0.00% | 0 | 0% | Feb-21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | ||||||||||
45 | HRA | 21) | HRA EXEMPTION u/s 10(13A) | DA Arrs¹ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
46 | a) | Actual HouseRent paid -Rs. | 0 | DA Arrs² | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
47 | Select Metro/NonMetro(If RENT paid)..Otherwise select HRA Deductible/Not Deductible | HRA Not Deductible | SURRENDER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
48 | b) | Pay Arrs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FALSE | 0 | 0 | ||||||||||||||||||||
49 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
50 | 0 | Pls go to Sl.No.22 | 0 | 0 | 0 | 0 | 0 | 0 | http://freegksms.blospot.in | Mobile:8951926000 | ||||||||||||||||||||||
51 | ||||||||||||||||||||||||||||||||
52 | 22) | Click on DROP-DOWN then select | DATE:- | 30/12/2023. 18:40 | 0 | 0 | SIGNATURE OF THE EMPLOYEE | |||||||||||||||||||||||||
53 | DEDUCTIONS | SERIAL NUMBER | DEDUCTIONS U/s 80C | AMOUNT | Max Amt | 0 | DEDUCTIONS UNDER OTHER SECTIONS | Max Amount | Ded Amount | DRAWING AND DISBURSING OFFICER | ||||||||||||||||||||||
54 | 1) | Postal Life Insurance(PLI) | 0 | Maximum Deductible Amount u/s 80c is -->Rs. 1,50,000 | 10) | Covid-19 Relief Fund Donation(80G) | NoLimit | 0 | DDO:- | BLOCK EDUCATION OFFICER | ||||||||||||||||||||||
55 | 2) | Tuition Fees paid (Max 2 Children) | 0 | 11) | Medical Expenses on PH Dependents(40%)(80DD) | 75000 | 0 | DDO NAME:- | Sri C M NYAMAGOUDA | |||||||||||||||||||||||
56 | 3) | Postal Life Insurance(PLI) | 0 | 12) | Medical Insurance Premium(80D) | 25000 | 0 | FATHER NAME | MALLAPPA | |||||||||||||||||||||||
57 | 4) | National Savings Scheme(NSC) | 0 | 13) | Interest Paid on Home Loan(U/s 24) | 200000 | 0 | PAN NO:- | 0 | |||||||||||||||||||||||
58 | 5) | Tuition Fees paid (Max 2 Children) | 0 | 14) | Interest Paid on Edn Loan(80E) | NoLimit | 0 | TAN NO:- | BLRB06790A | |||||||||||||||||||||||
59 | 6) | Paid Principal Amt of Home Loan | 0 | 15) | Deduction for Treatment of Specified Disease(80DDB) | 40000 | 0 | PLACE:- | JAMAKHANDI | |||||||||||||||||||||||
60 | 7) | Other Authorised LICs | 0 | 16) | Interest earned from SB A/c(u/s 80TTA) | 10000 | 0 | TALUK:- | Jamakhandi | |||||||||||||||||||||||
61 | 8) | National Savings Scheme(NSC) | 0 | 17) | Less: relief under section 89(attach details) | 0 | DISTRICT:- | Bagalkot | ||||||||||||||||||||||||
62 | 9) | Pension Plans of LIC & OTHERS(Sec80CCC) | 0 | 18) | Tax deducted at source u/s 192(1) | 0 | PIN CODE:- | 587301 | ||||||||||||||||||||||||
63 | 19) | Self Contribution to NPS (U/s 80CCD(1B) | 50000 | 0 | created by-somashekhar | |||||||||||||||||||||||||||
64 | TAX | SOMASHEKHAR M BELLUBBI. YOUR PAYABLE TAX(OLD REGIME) IS Rs. | 0 | Zero Rupees | ||||||||||||||||||||||||||||
65 | SOMASHEKHAR M BELLUBBI. YOUR PAYABLE TAX(NEW REGIME) IS Rs. | 0 | Zero Rupees | |||||||||||||||||||||||||||||
66 | YOUR PAYABLE TAX(OLD REGIME) IS Rs. | |||||||||||||||||||||||||||||||
67 | ಮನೆ ಬಾಡಿಗೆ ಭತ್ಯೆ ತೆರಿಗೆಗೆ ವಿನಾಯಿತಿ ಪಡೆಯುವ ಮುನ್ನ ಈ ಕೆಳಗಿನ ಅಂಶಗಳನ್ನು ಗಮನಿಸಿ. | YOUR PAYABLE TAX(NEW REGIME) IS Rs. | ||||||||||||||||||||||||||||||
68 | ENTER EMPLOYEE DETAILS HERE | |||||||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||||||||
70 | ** | House Rent Allowance (HRA) is an allowance paid by the employer to its employees for covering their house rent. | NAME OF EMPLOYEE:- | SOMASHEKHAR M BELLUBBI | ||||||||||||||||||||||||||||
71 | A deduction from such HRA is allowed under section 10(13A), which is least of the following: – | SCHOOL/OFFICE:- | GHPS BANAHATTI TOTA | |||||||||||||||||||||||||||||
72 | 1) | HRA received | TQ;- | RABAKAVI-BANAHTTI | ||||||||||||||||||||||||||||
73 | 2) | 40% of salary (50% of the salary if the rented property is in Metro City i.e. Mumbai, Delhi, Chennai or Kolkata) | DIST:- | BAGALAKOTE | ||||||||||||||||||||||||||||
74 | 3) | Actual rent paid less 10% of salary | KGID NO:- | gg | ||||||||||||||||||||||||||||
75 | You can use this HRA calculator to calculate deduction allowed for HRA under section 10(13A) and Rule 2A of the Income Tax Act. | PAN NO:- | KJH765Jyyy | |||||||||||||||||||||||||||||
76 | CLICK HERE TO CALCULATE ONLINE | BANK A/C NO.:- | 000066700000 | |||||||||||||||||||||||||||||
77 | Meaning of salary for HRA exemption calculation | IFSC CODE:- | Dd67ghh | |||||||||||||||||||||||||||||
78 | BANK NAME /BRANCH | SBI BANAHATTI | ||||||||||||||||||||||||||||||
79 | ** | Salary includes basic salary, dearness allowance (if it enters into retirement benefits) | ||||||||||||||||||||||||||||||
80 | and fixed percentage commission on turnover achieved by the employee. | CLICK HERE TO RETURN | ||||||||||||||||||||||||||||||
81 | ** | Salary is taken on the due basis for HRA calculation. | ||||||||||||||||||||||||||||||
82 | ** | Salary is taken only for the period for which House Rent Allowance is received. | ||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||||
84 | NOTE:- In Sl. No. 21(B) don't Select "HRA Deductible" if you are not paying any HOUSE RENT.(It's your 'OWN RESPONSIBILITY) | |||||||||||||||||||||||||||||||
85 | 0 | |||||||||||||||||||||||||||||||
86 | FOR LATEST UPDATES CLICK HERE or WhatsApp # +91 8951926000 (after 5 p.m.) | |||||||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||||||||
88 | LIST OF All CIT(TDS) addresses for Form No.16 | |||||||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||||||||
90 | some important sections | Deductions (NEW REGIME) | ||||||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||||||||
92 | Sections | What is it about? | Limits | SL No | Particularls | AMOUNT | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||
94 | Section 80C | Income Tax Deduction for investing into very common and popular investment options like LIC, PPF, Sukanya Samriddhi Account, Mutual Funds, FD etc | Upto Rs 1,50,000 | |||||||||||||||||||||||||||||
95 | d popular investment options like LIC, PPF, Sukanya Samriddhi Account, Mutual Funds, FD etc | 1 | Any compensation received to meet the | |||||||||||||||||||||||||||||
96 | Section 80CCC | Income tax deduction for the investment in Pension Funds`` | cost of travel on tour or transfer | |||||||||||||||||||||||||||||
97 | Section 80CCD (1) | Income Tax Deduction for APY & NPS Contribution | ||||||||||||||||||||||||||||||
98 | Section 80CCD(1B) | Income Tax Deduction for APY & NPS Contribution | Upto Rs. 50,000 (Outside the 80C Limits) | 2 | Transport allowances in case of a | |||||||||||||||||||||||||||
99 | Section 80CCD(2) | Income Tax Deduction for NPS Contribution by Employer | Amount Contributed | specially-abled person. | ||||||||||||||||||||||||||||
100 | or | |||||||||||||||||||||||||||||||