Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
273x Filetype XLSX File size 0.59 MB Source: taxguru.in
Sheet 1: Home
| 3 in1 Latest Form-16 Generator, Auto Income Tax Calculator & salary statement . . for . Financial year 2018- 19 . Assessment Year 2019-20 | ||||||||||
| IncomeTax & GST Practitioner B.P.Choudhary | ||||||||||
| Prepare Salary statement, Computation sheet & Form-16 (latest format) | ||||||||||
| with Ready reconer - For latest infromations & rules of the Taxation, Exemptions, deduction etc. | ||||||||||
| An easy excel sheet for Tax Calculation, Prepare salary statement & Form-16 for salaried person with standard deduction. Once enter the amount in blank cell in salary statement & tax calculator other cells will calculate tax & Generate form-16 automatically. Print Income tax computation sheet,Salary statement and Form-16 with other calculation sheet . | ||||||||||
| Introduction | Salary Statement | Auto Tax Calculator | Automated Form-16 | Annexure A to form-16 | Form 12BA | Income from House Property | Exempted Allowance & income from other source | Informations & Rules (Tax rates, exemptions/deductions) | ||
| Latest Modified Form -16 as per new format for Financial Year 2018-19, Assessment Year 2019-20 . | ||||||||||
| Now prepare the Salary statement,Income tax computation & Form-16 with fill of Salary statement & tax calaculator with less time & less efforts, also know all current applicable rules. | ||||||||||
| You can use calculator hyperlinks to clear and understand all related rules, Information with aspects. | ||||||||||
| Since last 19 Years I am rendering my services in field of Taxation & from year 2017 for GST also. Having a lots of satisfied clients all over the India. | ||||||||||
| Assosiated with India's well known company, Mycorporation consultant Pvt. Ltd. (Winner of Leaders Award 2015 to 2018 as "Startup Consulting Enterprise of the Year (Finance))". | ||||||||||
| Providing all taxation & GST related services in nominal charges | ||||||||||
| Services to Companies and officies | ||||||||||
| 1. Presentation/Seminar on any taxation matter. 2. Setup Help Desk | ||||||||||
| 3. Payroll Management with Taxation and CA services (in very nominal amount of ₹ 100 per empolyee Per month) | ||||||||||
| 4. Outsourcing of any CA services, Preparation of form-16 , Collection of declaration and final documents for caculate TDS and Tax Liabilities etc. | ||||||||||
| Return Filing Services for Individuals | ||||||||||
| Business (Company/Firm) Formation Services & compliances after frmation - Pvt Ltd co., One person co. , Public Ltd. Co., LLP, Partnership, Section 8 Co. | ||||||||||
| Tax and Management Services - Income Tax , TDS, GST etc. | ||||||||||
| Compliances - Returns, Audit & ROC, Annual Filling | ||||||||||
| Other allied Services | ||||||||||
| Apply for 1. GST Registration 2. Digital Signature 3. PAN 4. TAN 5. DIN | ||||||||||
| 6. ISO certification 7. Trade Mark and Copy right 8. Food Licence Registration 9. Import Export Code(IEC) | ||||||||||
| Customise Insurance solutions - General - Mediclaim , Overseas/Travel Insurance, Personal Accident Cover(Group/Individuals/family), other General Product | Back | |||||||||
| If you find any inconsistency, correction or amendments in Calculator, please let me know, I will try to fix it at the earliest. | ||||||||||
| Please send a detailed e-mail at taxationseva@gmail.com | ||||||||||
| Ph: 9811302497 | ||||||||||
| For our Services - Visit | https://www.mycorporation.in/ | Other Calculators and Taxation related matters- Visit | http://www.taxationseva.com/ | |||||||
| Instruction: Customise heads of salary and deduction according to your salary structure. Enter the infromation & monthwise salary data of employee in white cells. | ||||||||||||||||||||||||||||||||
| ABC PVT. LTD | Write Employer's Name | |||||||||||||||||||||||||||||||
| SALARY STATEMENT FOR FINANCIAL YEAR 2018-19 | ||||||||||||||||||||||||||||||||
| Name of the Employee | Designation | PAN | ABCDE1234F | Date of Birth | 00/00/0000 | White cells and next row are writable/editable | ||||||||||||||||||||||||||
| Employee Code | ||||||||||||||||||||||||||||||||
| SALARY | DEDUCTIONS | |||||||||||||||||||||||||||||||
| Customise the Salary & Deduction Heads according to salary srtucture of the Institution | ||||||||||||||||||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||||||||||||
| 1 | Apr-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | Fill exact Salary figure of the present & prior Month & estimated figures for rest balance months. As estimated Tax & TDS calculates on annual Income. For example If you are calculating Tax in the begining of the year. Fill same figure for rest of 12 Months as intital months i.e March/April . You will be able to calculate the estimated tax payable for the year & deduct the average TDS. In the last quarter of Jan to Mar. You have the exact figures of salary, Savings & deductions. So In last quarter you will be able to calculate exact computation. | |||||||
| 2 | May-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 3 | Jun-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 5 | Aug-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 6 | Sep-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 7 | Oct-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 8 | Nov-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 9 | Dec-18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 10 | Jan-19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | How to best use this sheet Calculation is interlinked with calculator. When you fill figures automatically total amount will be transfer in Auto tax calculator. So It is good pracice to make a master sheet with common data. Make seperate folders of all employee & paste a copy of master sheet Fill salary data of every individual employee. In further months open the employee sheet from his folder enter actuall salary & calculate exact statement & computation. | |||||||
| 11 | Feb-19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 12 | Mar-19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | ||||||||
| 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |||||||||
| 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |||||||||
| 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | |||||||||
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | |||||||||
| Salary for HRA exemption(Basic+DA) | 0 | |||||||||||||||||||||||||||||||
| 0 | ||||||||||
| Inputs the amount & select the transaction in Amount in are already transfered from salary statement/Annexures Other cells will calculate data & tax automatically. | ABC PVT. LTD | |||||||||
| CALCULATION OF INCOME TAX | D.O.B | 00/00/0000 | COMPUTATION OF INCOME TAX | D.O.B | 00/00/0000 | |||||
| Name and Address of Employee ↓ | ASSESSE | MALE | for the Financial Yr 2018-19, Assessment yr 2019-20 | ASSESSE | MALE | |||||
| 0 | PAN | ABCDE1234F | Name of Assessee : 0 | PAN | ABCDE1234F | |||||
|
|
PHONE : | ADDRESS : | PHONE : | |||||||
| 1. Gross Annual Salary (include all allowances & Perks) | 0 | 1. Gross Salary | 0 | |||||||
| a) Salary as per provision contained in Section 17(1) | 0 | 2. Allowances exempt - u/s 10 & 17 | 0 | |||||||
| b) Value of Perquisites under section 17(2) | 0 | 3. Total salary received from current employer | 0 | |||||||
| c) Profit in lieu of Salary under section 17(3) | 0 | 4. Salary received from other/last employers | 0 | |||||||
| 2. Other amount of salary received from other employer(s) reported by employee | 0 | 0 | 5. Deduction u/s 16 - Standard Deduction | 0 | 0 | |||||
| 3. Less: Allowances exempt u/s 10 &17 | Print Sheet | 0 | Professional Tax / Tax on Employement | 0 | ||||||
| Received | Exempted | Entertainment allowance | 0 | |||||||
| (a) LTA or travel assistance (u/s 10(5) with rule 2B) (See rule) | 0 | 0 | 6. Income under the head salaries | 0 | ||||||
| (b) Death-cum-retirement gratuity Eemption under section 10(10) | 0 | 0 | 7. Income from other sources | 0 | ||||||
| ( C) Commuted value of pension Exemption under section 10(10A) | 0 | 0 | 8. Income from house property | 0 | ||||||
| (d) Leave Encashment Exemption (on Retirement/resignation) 10(10AA) | 0 | 0 | 9. Gross Total Income | 0 | ||||||
| (e) Calculate H.R.A. Exemption(U/S 10(13A) (with Detail of Basic & HRA ) | 0 | 10. Deduction under chapter VI A | 0 | |||||||
| City of Residence (Select applicable City) | Metro | Deduction under Sec 80CCE (Max Rs.1,50,000/-) | 0 | |||||||
| Salary (Basic+DA+Commision) | 0 | 0 | 80C - GPF/PF inclding VPF Contribution | 0 | ||||||
| Rent Paid (Receipt submitted) |
|
0 | 80C - Home. Loan (Principal Repayment ) | 0 | ||||||
| H.R.A received | 0 | 0 | 80C -Tuition fees for 2 children | 0 | ||||||
| Children Education Allowance (u/s 10(14)) | 0 | 0 | 0 | 80C - FD (5 Years and above) | 0 | |||||
| No of Children studying in School (Non Hostel)(Max 2 Children) | 1 | 0 | 80C Sukanya Samridhi Account | 0 | ||||||
| No of Children studying in School (Hostel) | 1 | 0 | 0 | 80 CCC - Contribution to Pension fund | 0 | |||||
| ↓ Selected other exempted allowances from salary statement | 80CCD(1) - New Pension Secheme (Employee Contribution) | 0 | ||||||||
| Research or Training Allowance | 0 | 0 | 80CCD(2) -New Pension Scheme- Employer Contribution | 0 | ||||||
| Helper Allowance | 0 | 80CCD(1B)- Adnl contribution in NPS Account | 0 | |||||||
| Any other Exempted Allowance | 0 | 80D - Medical Insurance premiums+Health Check -Self | 0 | |||||||
|
|
|
80D - Medical Insurance / Expenditure - Parents | 0 | |||||||
| Total salary received from current employer | 0 | 80G - Donation to Govt. Fund (100%) | 0 | 0 | ||||||
| 4.. Deduction u/s 16 | 0 | 80G - Donation to NGO & Non Govt fund (50%) | 0 | 0 | ||||||
| (i) Standard Deduction (u/s 16 (ia)) | 0 | 80E Interest on loan for higher education | 0 | |||||||
| (ii) Professionsal Tax / tax on Employment (u/s 16(iii)) | 0 | Section 80DD Maintinance or treatment of a disable dependet | 0 | |||||||
| (ii) Entertainment Allowance ( for Govt Servent only) (u/s 16(ii)) | 0 | 0 | Section 80DDB Medical treatment of specified Disease | 0 | ||||||
| 4. Income under the head salaries | 0 | Section 80GGA Donation to Scientific Research or Rural development | 0 | |||||||
| 5. Other income reported by the employee (Select Souces from Drop Down List in white cells) | 0 | Section80GGC Donation to political party | 0 | |||||||
| Interst received from saving A/c (Bank/Post Office) | 0 | 0 | Section 80U Deduction to a disable assesse | 0 | ||||||
| Sr Citizen Savings scheme | 0 | Print Sheet | 80TTA/80TTB- Interest Income in saving accounts | 0 | ||||||
| Interest from - Recuring Deposit(RD) | 0 | of Income from | 80EE Relief on Housing Loan Interest | 0 | ||||||
| Interest on Saving Bonds | 0 | other Sources | Name of Assessee : 0 | AY - | 2019-20 | |||||
|
|
0 | 11. Total taxable income (Round off to nearest 10 rupees) | 0 | |||||||
| 6. Income or loss from house property reported by employee (Go to B91) | 0 | 12. Tax on total Income | 0 | |||||||
| 7. Gross Total Income | 0 | 13. Rebate U/S 87A | 0 | |||||||
| 8. Less: Deduction under chapter VI A | 0 | 14. Total tax after rebate | 0 | |||||||
| Select Applicable heads from drop down list in white cells | 15. Surcharge | 0 | ||||||||
| a 1. Deduction under Sec 80C,8CCC & 80CCD1) (Max Rs.1,50,000/-) | 0 | 16. Education & health cess @ 4% | 0 | |||||||
| ↓ ( Select Sources from Drop Down List ) | 17. Relief u/s 89,90 and 91 | 0 | ||||||||
| 80C - GPF/PF inclding VPF Contribution | 0 | 0 | 18. Tax Payable | 0 | ||||||
| 80C - Home. Loan (Principal Repayment ) | 0 | 19. TDS & Advance tax Paid | 0 | |||||||
| 80C -Tuition fees for 2 children | 0 | 20. Balance Tax | Refundable | 0 | ||||||
| 80C - FD (5 Years and above) | 0 | |||||||||
| 80C Sukanya Samridhi Account | 0 | 0 | ||||||||
| 80 CCC - Contribution to Pension fund | 0 | |||||||||
| 80CCD(1) - New Pension Scheme -Employee Contribution | 0 | |||||||||
| 80CCD(2) - New Pension Scheme- Employer Contribution | 0 | 0 | Signature | |||||||
| 80CCD(1B) - Adnl cont in NPS Account | 0 | 0 | 0 | |||||||
| 80D Medical Ins prems+Health Check up (for Self & family) | 0 | 0 | 0 | |||||||
| 80D - Medical Insurance+ health Check up(for Parents < 60Yrs) | 0 | 0 | 0 | |||||||
| 80D - Medical Insurance+ health Check up (for Sr Citizen Parents ) | 0 | 0 | ||||||||
| 80G Donation to Govt. fund ( Eligible for 100% ded) | 0 | 0 | 0 | 0 | ||||||
| 80G Donation to NGO and Non Govt. Institution (Eligible for 50% Ded) | 0 | 0 | 0 | 0 | ||||||
| 80E Interest on loan for higher education | 0 | 0 | ||||||||
| ↓ Select the applicable section from drop down & follow the exemption limit from Rule section | ||||||||||
| Section 80DD Maintinance or treatment of a disable dependet | 0 | |||||||||
| Section 80DDB Medical treatment of specified Disease | 0 | |||||||||
| Section 80GGA Donation to Scientific Research or Rural development | 0 | |||||||||
| Section80GGC Donation to political party | 0 | 0 | 0 | |||||||
| Section 80U Deduction to a disable assesse | 0 | 0 | ||||||||
| Section 80TTA/80TTB - Interest income in Account | 0 | |||||||||
| Section 80EE Relief on Housing Loan Interest | 0 | |||||||||
| 9. Total Income | 0 | 0 | ||||||||
| 10. Total Taxable Income (Round off to nearest 10 rupees) | 0 | 0 | 0 | |||||||
| 11. Tax on Total Income | 0 | 0 | ||||||||
| 12. Rebate U/S - 87A | 0 | |||||||||
| 13. Total Tax after rebate | 0 | |||||||||
| 14. Surcharge on Total Taxable Income | 0 | |||||||||
| 15. Total Tax+Surcharge | 0 | |||||||||
| 16. Marginal Relief | 0 | |||||||||
| 17. Net Surcharge after marginal relief | 0 | |||||||||
| 18. Add - Education & Health Cess @ 4% | 0 | |||||||||
| 19. Total Tax Payable | 0 | |||||||||
| 20. Relief u/s 89,90 and 91 | 0 | 0 | ||||||||
| 21. Tax Payable | 0 | |||||||||
| 22 Tax Deduction at Source | 0 | 0 | ||||||||
| 23. Advance Tax Paid | 0 | 0 | ||||||||
| 24. Balance Tax Payable / Refundable | Refundable | 0 | ||||||||
| Calculation of Income from house property | Print Sheet | |||||||||
| For self occupied or let out house | ||||||||||
| Accommodation Status - SELF OCCUPIED / LET OUT |
|
|||||||||
| Annual Letable value |
|
0 | ||||||||
| Unrealised Rent | 0 | 0 | ||||||||
| Less-Taxes Paid to Local Authority | 0 | 0 | ||||||||
| Net Annual Value | 0 | 0 | ||||||||
| Less-Repair & Collection Charges(30% of Net Annual Value) | 0 | 0 | ||||||||
| Less-Interest on Housing Loan |
|
0 | ||||||||
| Net Income / Loss from House Property | 0 | 0 | Back | |||||||
| (For 80EE Rebate on Loan taken after 1st April 2016 for first time home buyer for self occupy) | ||||||||||
| Housing loan sanction Date | 4/2/2016 | -1 | 4/1/2016 | |||||||
| Value of the Residential House Property | 0 | 1 | ||||||||
| Home Loan Amount sanctioned | 0 | -200000 | ||||||||
| 0 | 0 | |||||||||
| Relief u/s 80EE | 0 | 0 | ||||||||
| 0 | #VALUE! | |||||||||
| 50% 0F Basic Salary | 0 | M | 0 | |||||||
| 40% 0f Basic Salary | 0 | F | 0 | |||||||
