My Posts

Tools and Notes Arranged Subject Wise   »«   Tools and Notes Arranged Subject Wise   »«   Tools and Notes Arranged Subject Wise   »«  

Sunday 9 November 2014

Project Helper

   
        A tool for dealing all tasks
             related to project works







Project Helper 2015-16


For Fully worked out Example
     Project Helper 2015-16 Parappukkara GP
                   Excel 2007
                   Excel 2003




IMPORTANT : THIS FILE BECOMES AROUND 6 MB WHEN SAVED AS 2007 WORKBOOK






To get your PANCHAYATH's name included in Project Helper

please Contribute little time to CoOrdinate


Creating Directory of Sulekha Codes for Assets in Purchase




Change of Head of Acconts


The head of acconts for various funds have been changed by the following Govt. Orders

GO(Rt) No 6882-2015-Fin  dated 25-07-2015 Change of Head of Accounts of Finance Commission Grant
Click Here

GO(Rt) No 4916-2015-Fin  dated 19-05-2015 Change of Head of Accounts of Development Funds
Click Here

GO(Rt) No 4091-2015-Fin  dated 20-04-2015 on Change of Head of Accounts of Maintenance Funds
Click Here


Important Notice : Govt has introduced a new common treasury bill form TR 59 C and some treasuries and insisting on it. So we have enhanced Project Helper with TR 59 C
To know About TR 59 C
                 Click Here

To get your old Project Helper Updated to  New Version
                   Click Here 

To prepare Annual Projects and correct Validation
                  Project List, Validation

To do with expenditures
                 Requisition, Authorisation, Proceedings, TR 59B, Allotment, Chalan, DD Slip
To get frequently asked Reports
                Project Report, Dev.Fund & MG Progress Report, Implementing Officer wise Report,
                Sectorwise Reprot, Mandatory Projects, Expenditure Report, Spill Over Report etc.
                and Project Register


Project Helper 2014-15




For Fully Worked out Example

Project Helper 2014-15 Parappukkara GP
        Excel 2007
        Excel 2003

Project Helper 2013-14 Parappukkara GP
        Excel 2007
        Excel 2003

Project Helper 2012-13 Narikkuni GP GP
        Excel 2007
        Excel 2003



Feel Free to Contact : 9446407279

-----------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------
Details of Last Update

03-04-2016
(1) Corrections added for getting reports after 31-03-2016
(2) Provisions for Copying Fund wise Report added
(3) Utilization Certificate added


  03-03-2016
(1) Provision for Contractor/Agency by 1 in Add Requisitions.
(2) Corrections for insufficient fund
  21-02-2016
(1) New Report Added - Fund wise Report - useful for Conference, Audit etc.
(2) VAT Challan Added
(3) Corrections added in Prepare Bill

  04-02-2016
(1) to include some more panchayaths

   22-01-2016
(1) Correction added for Change of Funds
(2) New Report for Fund Wise Totals added in IO Monthly Report
   09-01-2016
(1) Filters on Working Group and Standing Committee added in Project Report and Expenditure Report


     05-01-2016
(1) New Filters added for Project Report


     17-12-2015
(1) To Include Some More Panchayaths

     15-12-2015
(1) New Merged Head Option Added
(2) Implementing Officer Monthly Report Enhanced

    26-10-2015
(1) Option added for New and Old Head of Accounts for MG & CFC
(2) Chalan Sheet Modified with input Boxes


    28-09-2015
(1) Covering Letter to HandOver DD is added

     22-09-2015
(1) New Head of Accounts included
(2) New Report form added namely - Implementing Officer Monthly Statement
(3) ACR - Allotment Report modified

     21-09-2015
(1) File copy is included in Allotment

     31-08-2015
(1) Update to include some institutions.

     28-07-2015
(1) Minute Corrections in  Approver Details

       12-07-2015
(1) Provision Added for Appover Details
(2) New Filter Added based on Type of Projects


         05-05-2015
(1) New Useful Report added namely List of Allotments
           24-02-2015
(1) Date from Main sheet is Linked with ACR, Expenditure and Project List
(2) Prepare Bill is prevented from Bills without Funds


            20-11-2014
(1) Implementing Officer MO(CHC) is added with MO(PHC)
(2) Implementing Officer HM(GMLPS) is added with HM(GLPS)
(3) Implementing Officer HM is divided into two in Malyalam for Male and Female.
(4) A new Option is added for TR 59 to get the Allotments for the Implementing Officer or
                                                               the Allotments for the Panchayath

             10-11-2014
(1) TR 59 (C) Added.

               12-10-2014
(1) Added Work Calendar
(2) Provided provisions for Work Calendar in Project List.

                28-09-2014
(1) Implementing Officerwise Report Updated for Conference Tappals
(2) Special Grand Expenditure Details Corrected

               28-08-2014
(1) Freeze Pane Option extended to Columns Also.
(2) Certificate for Treasury Added.

               05-08-2014
(1) Freeze Pane Option Corrected in Project List, ACR and PrepareBill

               24-07-2014
(1) In Project List Own Fund is Renamed as Grama Panchayath (to suite with BP and DP)
(2) Allotment Received corrected for the entry of Special Grant
               23-07-2014
(1) Allotment Date added in Prepare Bill
(2) Added Column for DD Address in Prepare Bill
(3) Added Provisions to include Special Grant

               19-07-2014
(1) Corrected Expenditre Statements to Include District Panchayath Share

-----------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------

10 comments:

  1. Panchayath Help Desk is an attempt to reduce the burden of Local Self Government Institutions in Kerala, India.

    In this Blog Panchayath Help Desk you can see several Softwares, Sample Formats, Govt. Orders etc.
    You can watch, download, use and share these items free.
    Click on the Highlighted Letter << Click Here >>.
    Then you will reach the main post or the Box.com.
    Neglect the instructions such as Sign up, Login etc.
    Click the << Download >> button on the right top and save the file to your hard disk.

    ReplyDelete
  2. The tools or Softwares posted here are free softwares.
    You can use them without any obligations.

    ReplyDelete
  3. You can view and download all the posts in this blog.

    ReplyDelete
  4. It is our humble request to share and promote the use of free softwares.

    ReplyDelete
  5. Try to use Excel 2007 for all purpose. Excel 2003 is out of date and the files are larger in size with Excel 2003.
    There is another problem in Excel if two files bigger than 10 MB is opened and if we try to save a file the system will be hanged for 5-10 minutes. so use excel 2007, if possible.

    ReplyDelete
  6. Make your comments in English Only

    ReplyDelete
  7. Make your comments on the post itself.

    ReplyDelete
  8. In the second page of the contingent bill only the particular bill amount is shown and the balance in the project is shown as the difference between project amount and the current payment. Pls correct this.

    Also for the projects funded by GP own fund the estimate cost is shown when we add request and prepare bill.

    These are negligible things considering the effort you have done.Hats off ....

    ReplyDelete
  9. I hope the project helper for 2015-16 is ready by now.

    ReplyDelete