Take a look at the screenshot given below of the Salary Register (in Microsoft Excel 2007/2013/2016/365 format). There are a number of columns for income heads under salary and a fewer number of columns for deduction heads under salary. Notice that you can change a particular head if it does not apply to you to something that does apply to you. For example, Dearness Allowance (DA) could be renamed to Flexible Allowance or Personal Allowance etc. Most of the deduction heads have been well thought off, still the same applies to them as well. Of course, you also have to remember that something like Labour Welfare Fund (LWF for short) comes just twice in the year in most concerns that I have seen, yet you will have to show it for 12 months!!
Below the salary register data for 12 months you will also find a place where you an keep a record of the investments that you have to make under Section 80C, whether it be Provident Fund, Life Insurance Premium, Public Provident Fund etc. The design was made by yours truly for a concern where I had been auditor for a good many years. This worksheet contains everything one would need to prepare the Computation of Salary Income for any particular employee, including yourself. Cheers !!
CA VIKRAM SHANKAR MATHUR
12-Apr-2022 17:34 Hours IST
You must be logged in to post a comment.