Utilization of Funds towards implementation of RMSA 17 -18

EDUCATION FEE REIMBURSEMENT SOFTWARE(AP&TS)


*OLD EDUCATION FEE REIMBURSEMENT SOFTWARE(AP&TS)

This software can be useful for high schools as well as mandal level.it can be use  for up to 220 employees.

HOW TO INSERT PHOTOS IN EXCEL SHEET

 FOLLOW BELOW STEPS TO INSERT IMAGE IN IDENTIFICATION REGISTER OF NOMINAL   ROLE SSC  SOFTWARE 
A)IN COMPUTER
CREATE FOLDER>>>NAME IT >>>> OPEN FOLDER>>>PASTE ALL PHOTOS OF SSC STUDENT IN FOLDER>>>>GIVE ONLY NUMBERS LIKE 1,2,3,4, TO EACH PHOTO AS IN ORDER OF NR ALPHABETICAL ORDER SHEET
B)IN N.R SOFTWARE EXCEL SHEET
Open excel sheet---->go to developer tab ----> click on visual basic --->select module under insert tab on popup window  ----> paste below code in module >>>>then save the code --->return to identification register.
C)PASTE  FOLDER FULL PATH IN YELLOW COLOUR CELL

You can hold Shift key while you right-click any file or folder, and the right-click menu will show  "Copy as Path" option.  After you copy-as-path, then go to identification sheet of NR SOFTWARE  >>> click  on yellow colour cell on sheet >>>> paste it in yellow colour cell  with removing punctuation mark on both side 



Function ShowPicD(PicFile As String) As Boolean
'Same as ShowPic except deletes previous picture when picfile changes
Dim AC As Range
Static P As Shape
On Error GoTo Done
Set AC = Application.Caller
If PicExists(P) Then
P.Delete
Else
'look for a picture already over cell
For Each P In ActiveSheet.Shapes
If P.Type = msoLinkedPicture Then
If P.Left >= AC.Left And P.Left < AC.Left + AC.Width Then
If P.Top >= AC.Top And P.Top < AC.Top + AC.Height Then
P.Delete
Exit For
End If
End If
End If
Next P
End If
Set P = ActiveSheet.Shapes.AddPicture(PicFile, True, True, AC.Left, AC.Top, 120, 110)
ShowPicD = True
Exit Function
Done:
ShowPicD = False
End Function

Function PicExists(P As Shape) As Boolean
'Return true if P references an existing shape
Dim ShapeName As String
On Error GoTo NoPic
If P Is Nothing Then GoTo NoPic
ShapeName = P.Name
PicExists = True
NoPic:
PicExists = False
End Function

ETDS FORM 24Q-Q4 SOFTWARE FOR FY 2017-18

*HOW CAN DDO'S/HEADMASTERS  FILE TDS RETURN FY 2017-18 24Q -Q4 WITH FREE  COST WITHOUT GOING ANYWHERE 

*E TDS -24Q-Q4 SOFTWARE FOR FY 2017-18
It is helpful to file tds form 24 q  for all quarters for the FY 2017-2018
Note:it is mandatory to file TDS for 24Q-Q4 ending of  i.e 31.05.2018  for those DDO'S are deducting income tax from the staff salaries during  the month of March-2017 salary paid in April-2017 to Feb -2018 salary paid in March-2018) if not file TDS ending of the 31.05.2018, As per section 234E-a sum of Rs. 200 for every day during which the failure continues. The amount of late fees shall not exceed the amount of TDS.

*TS NEW DA 24.104% GO MS No 135 Dt.22.09.2017 w.e.f 01.01.2017(DA-22.008% to 24.104%)

*TS NEW DA 24.104% GO MS No 135 Dt. 22.09.2017 w.e.f 01.01.2017(DA-22.008% to 24.104%)
Central Government has been sanctioned January 2017 DA 2% those who are drawing pay as per 7th CPC and 4% to those who are drawing pay as per 7th CPC accordingly state Government has sanctioned 2.096% (6th CPC DA 4% X 0.524 =2.096%).

AUTO UPDATED PAY BILL AND EARNED LEAVE (EL) SURRENDER BILL SOFTWARE

AUTO UPDATED PAY BILL ,EL SURRENDER BILL SOFTWARE & SUPPLEMENTARY ARREARS BILL FOR TRANSFERS EMPLOYEES

DDO DATA SHEET-enter DDO particulars along with employee details
PAY DATA SHEET: enter pay particulars
In this software once enter loan deduction particulars in DDO DATA sheet they will be automatically updated month wise with  no need to enter instalments every month .after completion of instalments there will be shown zero amount in DIFFERENT STATEMENT automatically.

FOR SHOWN I.R  delete ' 0'  SYMBOL MENTIONED GREEN CELL IN PAY DATA SHEET

PRIMARY SCHOOL MID DAY MEALS SOFTWARE

*PRIMARY SCHOOL  MID DAY  MEALS SOFTWARE AS PER NEW FORMAT

*HIGH SCHOOL MIDDAY MEALS SOFTWARE 


This software is prepared as per latest guidliness such as cast wise for I st to V th class   with   applicable to akshaya patra midday meal serving schools.

MID DAY MEALS SOFTWARE WITH ALL 12 MONTHS FROM MEDAKBADI



       This software is prepared as per latest guidelines such as cast wise for 6 th to 8 th & 9 th to10th with   applicable to Akshaya patra midday meal serving schools.


CCE GRADING SOFTWARE

CCE GRADING SOFTWARE AS PER NEW FORMAT(CLASS WISE,TOOL WISE) 30.01.2020

This software is prepared as per latest guidelines for the academic year 2018-19 for telangana state .
it comprises subject wise grading register,class wise grading register,central marks register ,QMT,SHALASIDDI data along with blank proforma s  from  6 st class to 10 th class in one single excel file.
CCE GRADING SOFTWARE(OLD)

Link your Aadhar number with PAN Number


AFTER CLICK ON ABOVE LINK  ENTER ALL DETAILS AS SHOWN IN BELOW SCREEN SHOT TO COMPLETE PROCESS.
Aadhaar-PAN linking is mandatory from 1 July,2017 to submit IT return


PRC ARREARS SOFTWARE

*PRC ARREARS  SOFTWARE (UP TO 210 EMPLOYEES) (as per Online bill)

*PRC ARREARS  SOFTWARE (UP TO 80 EMPLOYEES) (as per Online bill)
Instructions1.After enter all Particulars IN DATA SHEET, then take out 2 prints month wise - one for submit to STO & one copy for office record along with soft copy.
2.check total amount of arrears in Appendix-II& HRMS(DDO request ) should be same. if any variation noticed  concern to DTO.

*PRC ARREARS PROFORMA SOFTWARE (old)

Online e-Filing Income Tax Return (ITR1) fy 2016-17 for salaried employees

*Online e-Filing Income Tax Return (ITR1) fy 2016-17 for salaried employees

This video helpful to submit income tax return online through https://incometaxindiaefiling.gov.in/
website.

KNOW YOUR COMPLETE NAME WITH PAN NUMBER

KNOW YOUR  COMPLETE NAME WITH PAN NUMBER


If you know the PAN, go  to the www.tin-nsdl.com, in that go for e payment of tax, fill the mandatory fields there (you can enter dummy), select the any bank name there & proceed. Then Data base will show the Complete name as per PAN Data Base.   Normally the 5th character of the PAN bill be based on the 1st alphabet of the Surname.

FILING OF ETDS FORM 24Q FY 2017-2018

*FILING OF ETDS FORM 24Q  FY 2017-2018
it can be useful  for Q1 to  Q4 for the FY 2017-18 .enter advance tax ,other  particulars in salary data sheet .then use  copy & past option in nsdl preparation utility for generation of form Q1 to Q4 

INCOME TAX SOFTWARE FY-2017-18

*INCOME TAX SOFTWARE FY -2017-18 FOR TELANGANA

*INCOME TAX CALCULATOR FY 2017-18(AY-2018-19) FOR AP
( it is mandatory  to file Form 10E  online (Login to https://incometaxindiaefiling.gov.in/ ) if you want to claim relief under section 89(1) or else you have received a notice from the income tax department if submitted online ITR(IT return) for FY 2017-18

*Brief description video on 80ccd (1) 80ccd(1b)&80ccd(2) in telugu 


*Registration of Taxpayer on e-Filing website for IT return



*GUIDE TO SUBMIT INVESTMENT PROOFS TO YOUR DDOS 


It is helpful to calculate income tax by giving particulars in IT data sheet and useful for both states TS &AP

New provision for filing E-TDS returns online

New provision for filing E-TDS returns online:
Earlier this month, the Income Tax Department of India created a new provision for filing E-TDS online without the need of a Facilitation Centre.
               CLICK HERE TO DOWNLOAD FILE
Mentioned below is the procedure for doing the same:

Step 1: Registration on Traces Website
  1.Go to the website - https://www.tdscpc.gov.in/app/login.xhtml
  2.Click on ‘Register as New User’ and select ‘Deductor’ and ‘Proceed’ by filling the required fields and get registered.

Note: Use a challan which has multiple PAN in deductee records. Please don’t repeat PAN in deductee details.

Step 2: Login to Traces Website and register under “Register at E-Filing Site”

Step 3: Login to Income Tax Portal    (http://www.incometaxindiaefiling.gov.in/)
 1.Register the Digital Signature Certificate (DSC) of Deductor’s authorized    person (Partner, Director etc). 

2.At the instance this is not done, you have    to verify the return via a    Demate Account or Online Banking or Aadhar      OTP respectively.

3.With the help of TDS returns preparations software or utility generated FVU file, create ZIP folder of the FVU file.

Upload the file in TDS option within the Income Tax E-Filing portal (presently last option in TAB) and ‘save’ the acknowledgement receipt.

FILING OF ETDS FORM 24Q -Q4 FY 2016-2017

*FILING OF ETDS FORM 24Q -Q4 FY 2016-2017

DDOs can do themselves ETDS FORM 24Q -Q4 with the help of this video using excel software which you can download from www.medakbadi.in

BIN VIEW ONLINE

*BIN VIEW ONLINE
YOU UNDERSTAND AFTER VIEWING THIS VIDEO -DDO CAN VIEW BIN NUMBER WITHOUT CONSULT TREASURY OFFICE 

How To Check DDO Registration Number Telangana

How To Check DDO Registration Number Telangana : 
Open http://Treasury.telangana.gov.in  - TS TG Telangana Treasury Website
after opening the page , Select services in Menu >>>> CLICK ON LIST OF DDO>>>CHECK YOU DDO REGISTRATION NUMBER ON OPENING PAGE.












Search for the CPS and then Select " CPS Pran "
Select the District and
Enter STO Code
Click On Submit o check

*ETDS FORM 24Q SOFTWARE FY 2016-2017

*ETDS FORM 24Q SOFTWARE FY 2016-2017

*Click here for youtube video how to use above software

enter all particulars on the base of  income tax calculation sheet or form 16 in excel file.after furnishing data in DEDUCTER SHEET,SALARY DATA,you may take column wise copy and paste it nsdl rpu utility software.

MEDAKBADI.IN