gopi_ramiah

Excel based Income Tax Calculator for FY 2019-20 – AY 2020-21. This excel-based Income tax calculator can be used for computing income tax on income from salary, pension, gifts, fixed deposit and bank interest, house rent and capital gains (short and long term gains). Note: With the Live Update facility, the software shall be automatically updated. However, in case of any problem, you can download update patch and update software as follows. Steps to Update Software. Webtel Presents. An ERP for professional firms that helps you and your team in managing day-to-day statutory and other. We know that Due date for TDS is 7th of next monthHowever for March,TDS Due date is 30 AprilIf deposited late,we have to pay interest @ 1.5%If TDS is deposited lateInterest is payable fromDate of Deduction (and not Last Date of Challan)toActual Date of Deposit@ 1.5%Changes in Interest Rate due to l.

“work” to include purchase of raw material from 1 2 20 TDS is to be deducted at the rate of 2.0% if the payee is an AOP or BOI. TDS is not applicable on payment to Contractor engaged in plying, hiring or leasing of goods carriages, where such contractor owns 10 or less goods carriages during the.

Dear All Can any one please send me the Tax worksheet / Tax Calculator asper the new TDS rate. Thanks in Advance Gopi
From India, Mumbai

anthonypaul

Hi Gopi, Find the TDS .xl sheet attached. Just give the Taxable Income ............. just check this.
From United States, Palo Alto
Attached Files (Download Requires Membership)

Income Tax Calci (2).xls (28.0 KB, 218 views)

Tds Return Working Sheet In Excel

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Salary slip format in Excel is given to the employees by the organization or a company in against confirmation of payment being paid. It is necessary for small as well as large organizations. In addition, excel format makes every month’s procedure of salary easier for the HR department.

What is a salary slip?

Tds Working Sheet In Excel Template

At the end of every month, every company issues a piece of document to their employee which is known as a salary slip. Commonly, this slip is issued when salary is credited into the employee’s account. This document also serves as proof that the employer has paid and the employee has received the salary for the specified month.

Hence, it is an important document for both employer and employee. Also, the employee needs it to prove his earnings. On the other hand, an employer needs it to prove that he has made all the dues. You may also like Rent Payment Tracker Spreadsheet.

Important elements of salary slip format in Excel:

The important elements that should be included in every salary slip are;

Employee’s information

Write down the name of the employee, his department name, and bank account number.

Basic salary:

It is the minimum payment that an employee receives each month. After deductions and commission additions, write down the payment received by the particular employee.

Allowances:

Allowances are the amount that the company gives for free to the employee. Some different types of allowances are house rent allowance, conveyance allowance, dearness allowance, medical allowance, etc.

Professional tax:

An employer can deduct the professional tax from the salary.

Employee Provident Fund (EPF):

It is a mandatory government scheme. Moreover, it prevents the employees’ interest in certain situations like unemployment, illness, marriage, etc. Both employer and employee equally contribute to this scheme.

TDS:

Tds Working Sheet In Excel Format

To pay tax to the government, the employer deducts a certain income tax from the employee’s salary.

Tds Calculation Sheet In Excel Format 2021-22

Importance of salary slip format in MS Excel:

The salary slip format in excel enables assists the organization to manage the financial record of each employee. The organization used it to determine the designation of an employee. For future legal considerations, this slip can be used against an employer. Furthermore, the employer has no time to manage and manually calculate salaries of the each employee. Thus, by using Excel salary slips, it becomes easy for them to manage the payslips of each employee.

It also helps to calculate the days of the employee in a month. The slips also contain information for how many days employees took leaves and what type of leaves they took. To increase the employee morale and motivation, it provides an efficient record of the employee. Additionally, if you want to take a loan from the bank then to prove your ability to repay back, the bank can demand a payslip. You should also check Template Of Sales Invoice.

Tds Working Sheet In Excel Example

Conclusion:

Tds Calculation Sheet In Excel Format

In conclusion, a salary slip format in excel helps the organization to make employee management processes easier and efficient. The excel format should be according to the organization and their parameters or working. The document not just includes the details of salary transfer but also contains the other parameters like service hours, extra hours, etc.