How to: Generate a payslip in Excel

The above is an actual payslip on my computer, which has two additional worksheets, namely Salary Register and Computation of Salary Income. All the information that Is required to be shown in this form comes from one of these two worksheets. If you take a look at vbacoder1962 blogger April 2022 post, you will find that I have already talked about the Salary Register in quite some detail. However, the picture shared in that post has changed somewhat, to get rid of data redundancy (unnecessary duplication of similar details).

To generate the Payslip, however, for the larger part, only the Salary Register would be required. Once the details for all 12 months and the required investment details of the employee are fed into the salary sheet, the Computation of Salary Income comes into the picture in a bigger way.

Notice, however, that on the top right hand side there is actually a drop down box that allows you to select the month for which you want to view the Payslip. However, the 12 months of data for payslips are not the only things required to prepare the computation of Salary Income. If you are wanting to ask why that is so, then this post will not be explaining that, as it would be the subject matter of another post of mine.

Cheers !!

CA Vikram Shankar Mathur

14-Apr-2022 | 02:36 Hour IST