Posts

Rent receipt format for full year in pdf and excel

Rent Receipt for claiming House Rent Allowance Exemption in Income Tax Your employer needs a proof of rent payment to allow exemption on HRA. The employer is required to collect proofs from you before allowing any exemptions & deductions. This is your employer’s responsibility as per the income tax act. It has been observed that most of employee dosen't provide rent receipt for the entire financial year, or provide quartly receipt but details mention for a particular month. which is wrong. Hence for the ease of employee I have designed rent receipt format which cover 12 months (April to March) in a single page. this will help employee and employer in clear understanding and serve as a complete proof of rent receipt. download in pdf format download in excel format search key: rent receipt in excel format, rent receipt as per Income Tax,  rent receipt as per Indian Income Tax, rent receipt, rent receipt in pdf format

Income tax calculator in excel for financial year 2018-19

Income tax calculator in excel for financial year 2018-19 with the help of this excel file you can compute your income tax liability for the financial year 2018-19 click here to download the excel file Income tax calculator for FY 2018-19

Guide to Tax Saving Through National Pension System (NPS)

Image
Guide to Tax Saving Through National Pension System (NPS) [with illustration on tax saving for corporate employees] Tax Savings through NPS  One of the key advantages of retirement planning through NPS is that while saving for your future, you get to enjoy tax benefits today, as NPS comes with a unique mix of Tax advantages. We are presenting an illustration, which will provide you with a brief idea as to the amount of tax you can save under NPS. The illustration has been prepared with the following assumptions that: Assuming standard deduction NPS is your only Tax Saving component tax rate as per financial year 2018-19 Under the present tax regime, if your annual salary (basic +DA) is Rs. 4 or 10 Lakh; your contribution is Rs. 0.40/1.00 Lakh, you can claim the complete amount as tax deduction u/s 80 CCD(1) within the overall ceiling of Rs. 1.50 Lakh. But if your annual salary is Rs.20.00 Lakh and your NPS contribution is Rs.2.00 Lakh, ...
Image
Tax proposals 2019-2020 at a glance for Individuals Keywords: Budget2019#, IncomeTax#,Tax# Saved# After# Budget# 2019# >Income Tax slabs will remain the same for FY 2019-20. >Standard Deduction for the salaried class increased from Rs 40,000 to Rs 50,000. >Tax Rebate Limit under 87A increased from Rs. 3.5 lakhs to Rs. 5 lakhs for taxpayers. The maximum limit of the tax rebate increased to Rs.12,500 from the present limit of Rs. 2,500. >No tax on notional rent of second Self-occupied House under “Income from House Property” (up to two self-occupied house properties) to be considered for exemption. >TDS limit hiked from Rs 10,000 to Rs 40,000 on Post Office Savings and Bank Deposits. >Section 54 exemption now available on the second house property, provided the capital gains is less than or equal to Rs. 2 crores – to be availed only once in a lifetime.

Excel to ECR export

Dear All, Many of us generate text file from Excel file to upload on EPF portal by following very tedious process: 1.compiling details in excel file 2.saving excel file in CSV format 3.open file in text file and replacing character to #~#, remove unwanted rows 4.save to text format 5.upload text file on EPF portal 6.if errors found then make necessary corrections in the excel file and again follow above steps. Which is tedious and very time consuming process. To ease the process I have created excel file which save lot of time. Also rectification can be done easily on particular line item having errors. This file can be used for generating monthly ECR text file, bulk KYC upload such as aadhar/ Date of Joining/ Date of exit/ bank/ PAN etc.  Kindly download the file from below link, replace dummy data with your data. copy data from mentioned cell and paste it to new notepad file and then upload on epfo portal.  https://drive.google.com/file/d/1lpVBSK900JiQ2IZE3uha9iuz2_FO...