Category Archives: Quick Post From Mobile

Userform to enter Tax Details

This is a userform that has been adapted from one of my pet projects called “Saral0506” wherein the form was used to feed the details of the Advance Taxes, Interest and Self-Assessment Taxes into the respective places in the control worksheet. Take a look at the userform itself before I explain the usage of the same.

Figure 1 : Userform to enter taxes

In the userform shown above, there is a provision for entering the data for the four due dates of Advance Taxes, namely on the 15th of September, 15th of December, 15th of March and on 31st of March of the financial year. So, you have the date tax was paid, the BSRCode & Challan No (trfVchNo) mentioned on the challan and the amount paid on that date. Based on that information, if the checkbox for calculating the interest has been checked, the interest under the three sections of 234A/234B/234C is calculated. Obviously two other inputs are required for this to be done accurately and those are the amount of tax that is due for the year and the tax deducted at source. There is another userform before this one that takes that input, and since we are not talking about that form yet, let us continue how this form operates, assuming that those two figures have been already provided in the Computation of Total Income Worksheet already discussed elsewhere. Then comes the upto four Self-Assessment Challans that can be fed into the system based on the Computation of Total Income that we have discussed elsewhere. Once you click the button called “Post It!”, the said information gets posted into the Computation of Total Income and that’s all there is to it, folks!!

Cheers!

CA Vikram Shankar Mathur

29/Apr/2022 | 20:50 Hours IST

VSM Calendar

Indeed, getting the Microsoft Calendar control on a userform has tended to become more and more of a difficult proposition, that has prompted me to create a userform that acts like a calendar and I have decided to call it “VSMCalendar”. Just take a look at the image below, then I will explain it’s operation to you.

VSM Calendar
VSMCalendar

Just by looking at the above userform, you will be struck with the familiar similarity of the look of the Microsoft Calendar Control (for those of you who have been used to the control, like me). I was inspired by a similar userform that came with basic coding, to which I added my own colors and coding to use it in my projects. So you must have a worksheet called VSMCalendar to which this control adds the date in two formats, one is the long date format of “DD MMMM YYYY” and the other is the standard date format of “dd/mm/yyyy”. You can change the date by using the combobox for the month and the year and by clicking on the day you want from the command buttons provided, then click on the “OK” button to set the date. The command button programming is largely courtesy the original developer of the userform, but the rest of it is my doing. This userform was also developed in the year 2014-2015, so it is also around eight years old. But it is so easy to operate that it is not funny!!

Cheers!
CA VIkram Shankar Mathur
27-Apr-2022 | 10:50 Hours IST

Computation of Total Income

Three screens depicted above are actually one worksheet, starting with the first screen showing some statutory details of the assessee (in our case the same employee whose salary register gives the details that are required in the second screen). This computation basically would work for only the salary income portion, even though those of you with sharper eyes would detect that income from house property, business income, capital gains and income from other sources can also be fed into these sheets. However, then the Income Tax Return ITR1 would not apply, rather some other appropriate ITR would have to be prepared. We are not going into which ITR for which set of circumstances, suffice to say that this computation is versatile enough to serve any purpose. In the workbook that I ultimately set up in combination would technically allow no entry except in the fixed details section that is Part A.

Recall that the Salary Register has a space where some investments can be declared by the assessee/employee? Those details would automatically get added to the second screen that is the beginning of Part B of the computation. Finally the third screen does the actual computation of the income with inputs about Advance Tax, Self-Assessment tax and interest and other taxes, including Tax Deducted at Source details (other then the Section 192 details which come from the salary register itself). The final purpose being the estimation of the appropriate Tax Deducted at source under section 192 of the Income-Tax Act, for the balance period for which the payslips are yet to be prepared. Once the entire 12 months are entered, one would get an idea about the tax liability of the employee for that particular financial year.

Cheers !

CA Vikram Shankar Mathur
15-Apr-2022 | 06:26 Hours IST