2025-May-10 — All Past Posts
Tag Archives: Vikram
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.
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
Calendar View
I got sick and tired of the failure of the Microsoft Calendar from being made a part of my VBA Projects that I created a new kind of Data Entry Form for a Date entry. You can call it anything you want, but I decided to call it “frmCalendarDate” or “MonthView Form”. It looks like this image below:
Basically, the operation of the above is very simple and obvious, and has been inspired by a similar post I saw elsewhere around 15 years ago, but basically requires you to manually feed the year, month and day using the up-down coltrols provided, or you can enter them manually and the data appears in “The Selected Date” textbox, after which you can click the “Date is OK” button and get the date in a designated cell named as “frmCalendarDate” on any worksheet of your choice anywhere in the workbook. That is all there is to it, folks!! Like it? Follow my blog if you do, I am putting up numerous posts and will continue in the near future to do so. Cheers !!
CA Vikram Shankar Mathur
24-Apr-2022 | 10:52 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
My First Blog Post
There comes a time when we all resort to coding the VBA, just to get some odd task completed, right?
Be yourself; Everyone else is already taken.
— Oscar Wilde.
This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.
Virtual Visiting Card
Virtual Visiting Card for the use of online presentation of one’s credentials being the latest craze to hit the techno-savvy professionals like myself!! Cheers!!
Demonization of Currency
For now, this year, the tax season is over. How ever, the latest buzz is about the demonitization of 1000 and 500 currency notes. It is a master-stroke and though it has caused anguish and anxiety to scores of people, this was the best and perhaps the only way – India is a vast country with varied languages and types of population. Rooting out Black Money is not an easy task. At the same time, the spread between 2000 and 100 denominations was too vast to not cause problems. In days to come, I am sure things will develop in more interesting ways. Let’s wait and watch. Cheers!!
13-Nov-2016 | 02:50 Hours IST | #CAVSM |
FAFP – Forensic Accounting & Fraud Prevention
Forensic Accounting & Fraud Prevention (FAFP)
On January 23rd, 2016 it was announced that the 48th batch of FAFP shall commence in the city of Ahmedabad, Gujarat and my joy knew no bounds, because I am not ashamed to say that I had set my heart on achieving this certification at any cost – mind you, by the only means that I would allow myself – fair means, that is.
Training sessions were announced to be held at the Hotel Regenta, Ashram Road and were to go on till February 22nd, 2016. All this was okay, except for my apprehension that the last examination I had ever appeared for had been in March’2006 for the Diploma in Information Systems Audit (DISA) also conducted by the Institute of Chartered Accountants of India (ICAI). Ten years later, I was pitting myself against 32 other, most of them much younger and perhaps more technologically advanced and certainly more capable than myself – and as I discovered later, a couple of them or more were even CISA qualified. Let me tell you, friends, these are not odds that work out in your favor under any circumstances. My initial and greatest fear, and I have no qualms of sharing this with you, was that if I was unsuccessful in achieving this landmark (for me, personally) certification, how silly I would look. To complicate matters further, I discovered to my horror that I was one of the senior-most in this particular batch of aspirants!!
Up till the time that the examination on the ultimate day of the training was announced, the quality of the training being imparted at the training sessions and the incisive technical knowledge possessed by the faculties who had been appointed to train us were beyond the ultimate limits that one could ever set for these eminent faculties. Most of them were, frankly, brilliant in their explanations and the way they communicated with the participants, for me, was another dimension itself. Fortunately for me, I had no problems whatsoever in understanding their teachings and was enlightened in many ways you cannot even imagine. To say that these training sessions stimulated me, is an understatement.
Though, at this point, I will honestly admit that I was no stranger to this field, having worked for almost a year with a reputed Insurance Surveyor in the city of Ahmedabad, way back in 2002, post the Godhra Riots and the burning down of God knows how many industrial and commercial establishments, resulting in perhaps crores of rupees of losses across the length and breadth of Ahmedabad and the state of Gujarat.
Again, since January 2015, when I had been added to a WhatsApp group being run by a highly reputed CA from Mumbai and then came into contact with perhaps a hundred or more other CA’s who were at different stages of being highly experienced and also coming from different states of our country, which was another eye-opener for my humble self. Their interactions were only being read by me on the social media like WhatsApp, Facebook and on LinkedIn since the one year prior to my joining this certification course, but my understanding and comprehension about the importance of this field for all CA’s had been growing by leaps and bounds, perhaps my other participants were not even aware of these developments that I had been following quite ardently.
To say that I was delighted to see the paper given to us on the ultimate day of the training completion, is an understatement. So greatly relieved and overjoyed was I on completing the paper literally 15 minutes before the scheduled time of completion, which gave me some time to review the entire paper at least once completely. Of course, it was too early for me to say conclusively that I had passed the examination, but yes, I was reasonably certain that I would not be unsuccessful in clearing it.
After completing the submission of the required research paper, the connected presentation and the two dummy forensic reports to the institute, I was reasonably sure that I would clear this asssessment, because by then I was quite certain that my understanding of the training sessions was as much as any other candidate in those sessions.
On 6th April, 2016 the email announcing that I had successfully completed the requirements necessary for the award of the certification came, I was informed by my colleague and good friend about it, since I had been busy with work that evening.
In celebration of this event, I have even created a Facebook Page to commemorate it here.
Our Services Infographic
You must be logged in to post a comment.