Payslip | Salary Register | Salary Computation

These are some screenshots of an excel workbook that I have created which I believe will be very useful to all employees who wish to keep track of their own salary and the income-tax that will be applicable to them, maybe in order to plan their investments etc. In the first screen you see below, you will see what is clearly a #SalaryRegister. You just have to fill the details that are available to you and then enter the forecasted income for the rest of the months to work our the income tax, for example.

In the following three screens you will find the salary computation with the resulting income-tax thereon,  also arrived at by a formula that works whatever your income level may be. As yet, it tackles only the old tax regime, because I wanted to keep it simple for demonstration purposes. Obviously it would not be a great deal to take into consideration the new regime as well.

Finally in the screen below, on the far right there is a drop-down box in which you can select the month for which you wish to see the payslip (and print it if you want, for any reason). The values fed into the salary register get automatically picked up in the payslip, using only formula's - amazing, is it not?

Note: The pictures shown in this blog are not the actual pictures of the package that may be received by the person viewing them, they are "representational images".  

Cheers !

CA Vikram Shankar Mathur

14-Apr-2022 01:27 Hours IST