The SaralNew Spreadsheet (Applicable to AY 2003-2004) (Part-I)

Well, today I am going to share for the first time the application that I had built using a mixture of Excel functionality and Visual Basic For Applications (VBA) way back in AY 2003-2004 (FY 2002-2003) for a friend who used it quite extensively to file Income-Tax Returns of more than 100 clients spread over the period of little less than five years.

What I am going to display here in the following paragraphs is the finalized product, which, to my knowledge, still lacked in some ways, but was quite satisfactory to the clients and the Income-Tax Department of that time. The first is the opening screen that you would get as soon as you opened the “Saral New Excel Spreadsheet“.

SplashScreen_Form

Figure 1: The Splash Screen

When you clicked the “Close” button visible above, the following screen would appear.

Main_Application_Screen

Fig 2: The Main Application Screen (Main Menu)

Form here began the actual journey into the software, which was essentially broken down into the steps as defined in the main menu above. The actual data entry was done by clicking the first button “Enter General Information”, clicking which there would be a series of forms that would appear, which I will show one by one henceforth.

The forms themselves and the controls (named in the same way as the labels that appear) are in plain english, so they need no explanations. I am NOT covering the coding that went behind them, because this is a conceptual posting.

Personal_Details_Assessee

Personal_Details2_Assessee

Form16_Details

Form16_Details_Other

Form16A_Details1

Form16A_Details

HouseProperty_Income

OtherIncome

CapGains_BusiIncome

Rebates_Deductions

Rebates_Deductions_Dropdown1

Rebates_Deductions_Dropdown

AdvanceTax_SelfAssessment

Details_Total_Income

Total_Taxes

Miscellaneous_Details

This completed the data entry portion of the Spreadsheet. In my next post (Part-2), I will share the data storage onto the main Control Sheet as I called it then. Of course there were a good 10,000+ lines of coding that went into the working of the program, which may not be possible for me to share, since in any case this is more like a case study and a ‘conceptual’ posting that only wants to demonstrate my programming prowess to you. Cheers till next time.

CA Vikram Shankar Mathur
(aka Deadly-VBA.Programmer)
31-May-2017 | 01:17 Hours IST | #CAVSM

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s