thanks. Its easier me to generate Form 16a. Please send me this format for F.Y: 2009-10 also.
Regards K.Raaghavan Accounts Manager Chettinad Builders Pvt Ltd. Chennai. --- On Tue, 8/4/09, Visvanathan Sivaraman <[email protected]> wrote: > From: Visvanathan Sivaraman <[email protected]> > Subject: Re: Form 16 A format in Excel > To: [email protected] > Date: Tuesday, August 4, 2009, 9:54 PM > Dear Friend > > Attached form-16a generating file from e-tds.rpu given by > tin-nsdl site. > > > step-1 > from etds-rpu file select challan details all the cells > copy and past in "cln details" sheet . > Similary select deducteee details and Past in > "deductee" sheet. > > > Do as under to copy from > fvu file opened with RPU program given free by > NSDL: > > you select the first cell > say in 'cln details" top left corner white cell. > > Holding the shift key pressed use the cursor arrow key to > bottom till end and then to right till end. > While doing this you should continue to keep the shift key > pressed down. > you will find every thing selected. > > > now press ctrl+c. > Then in the excel sheet press "ctrl+home" key to > go home and then press enter. > you will find every thing copied. > > similarly for each quarter select the cells from rpu, copy > and paste at the first blank row below the data already > pasted. > > repeat for all quarters before going to step-3. > > step-2 > > select F16A sheet and fill the coloured cells. > > step-3 press Alt+Shift+C > > step-4 > go F16A and in cell K2 type "1" > you will get the Form-16A for the first party, print this > and also the annex. > > In annex sheet see print area selection instruction. > > For next certificate in F16A cell K2 type "2". > and do as per step 4. > > In cell L2 you will see total number of certificates. > > Incase you used any other program to generate your fvu, > then use etds-RPU to open the Fvu file by selecting the > "correction" option. This will require receipt of > number of original return filed. > > > U can do this for all the four quarters in one file of the > attached sheet to create one F16A for the whole year. > No need to make 4 files. > Only limitation is 2000 transactions only has been catered > for. > If you find that this is not sufficient for your needs > > revert to me with your requirements. > > sivaraman > > > On 7/20/09, Hanumantha Rao <[email protected]> > wrote: > Hi, > Could > anyone please send me format of Form 16 A for A.Y. 2009-10 > in excel format > -- > > With Regards > Hanumantharao > Swan Suites and Services Private Limited > Contact No.+ 91 90001 86868 > Mail id. [email protected] > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Skorydov MyTaxAssistant Member Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/SkorydovMyTaxAssistant?hl=en -~----------~----~----~----~------~----~------~--~---
