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
You must be logged in to post a comment.