My Posts

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

Thursday, 13 November 2014

MP MLA Relief Work Bill Maker

MP MLA Relief Work Bill Maker is a tool to deal with many type of works


MPLADS
MLA SDF
NCRFRW
DRAUGHT
DMD
DRWHM

This tool contains
Covering Letter for Final Bill
Completion Report
Memorandum of Payment
Receipt for Allotment
Bills for Final Payment
Requisition
Authorisation
Proceedings
TR 59A
Allotment

DD Chalan
IT Chalan

Contingent Bill

----------------------------------------------------------------------------------------------------
To have more details about the works contained in this software
Visit MP MLA Relief Works

----------------------------------------------------------------------------------------------------
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.


To get this tool










Make your comments on the post itself.
---------------------------------------------------------------------------------------------------



Sunday, 9 November 2014

Individual Beneficiary List Sorting Helper

Individual Beneficiary List Sorting Helper is a tool to Record the Beneficiary List approved by the
Grama Sabha and to sort it in a meaningful manner and to publish.

To Get file for Excel 2007    Click Here

To Get File For Excel 2003 Click Here

To Get a thorough knowledge on this tool

Click Here



Here You can enter Beneficiary List as approved from Grama Sabha

It can be sorted in many meaningful Orders.




If you feel the file size is heavy and the data entry is slow

use Dummy Editor for Data entry purpose.

This is a tool designed for data entry only


Dummy Editor for Beneficiary Lists










TO DOWNLOAD NEW UPDATES :VISIT PanchayathHelpDesk (Main Page)





Details of Last Corrections

   24-11-2016
(1) Correction for inComplete Data Entry

   15-11-2016
(1) Correction for Year 2016-17

   28-09-2015
(1) Covering Letter to Hand Over Beneficiary List is added

    22-07-2015
(1) Corrected Drop-Down Lists
(2) Included Dummy Editor for Data Entry

     22-06-2015
(1) Provision for the Year 2015-16 is made


     01-01-2015
(1) Provision for Certificate added in Sorted List
(2) Provision for Draft and Final added in Sorted List

      21-10-2014
(1) Correction Tool for Duplicate Entries Added.
(2) List from GramaSabha and Sorted List are upgraded to 7,000 Entries

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

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

Saturday, 1 November 2014

EMS Loan Interest Calculator



EMS Loan Interest Calculator allows you to calculate the interest and loan amount pending with respect to EMS Housing Scheme.



























This tool will handle 500 Records of SingleLoan

To Get File for EMS Loan Interest Calculator (Single Loan) Click Here














This Tool will handle 100 Records of 5 Types of  Loans
To Get File for EMS Loan Interest Calculator (Multiple Loans)  Click Here


Friday, 31 October 2014

Allotment and Bill Maker (General, Public Works, B Funds)

Allotment and Bill Maker helps us to generate all items that are needed for bill to be produced before Treasury.


It Contains







Requisition
Authorisation
Proceedings
TR59B
Allotment
DD Chalan



It is classified in three types




Allotment and Bill Maker for Public Works   12-03-2017 Click Here

     This tool is very helpful in the preparation of treasury bills in connection with Decentralized Plan. It is highly recommended to use for Projects Dealing with Public works. This software includes Requisition, Authorisation, Proceedings, TR 59, Allotment, DD Chalan, IT Chalan, Fine-Retention Chalan and contingent bill.


Allotment and Bill Maker for General 18-03-2016 Click Here


     This tool is very helpful in the preparation of treasury bills in connection with Decentralized Plan.  This software includes Requisition, Authorisation, Proceedings, TR 59, Allotment, DD Chalan, IT Chalan,  and contingent bill.




Allotment and Bill Maker for B Fund  15-03-2015 Click Here
       This tool is very helpful in the preparation of treasury bills in connection with B-Fund Allotments. They include various Social Welfare Pensions, Expenses in connection with Election, Allotments to Ayurvedic Dispensary etc.



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




You can Also Use

Project Helper for Complete Assistance in dealing with Decentralisation Works
It is not just a bill maker
It helps Project Formulation, Bill Preparation, Report Generation and many other things
To See More Click Here


MP MLA Relief Work Bill Maker
for making bill Under MP MLA NCFRW Works Draught etc.
To see more Click Here

Go to Main Page of  Panchayath Help Desk to get various Govt. Orders, Formats, Tools and Softwares to handle the day-to-day tasks for Panchayaths easily.
Click Here





Friday, 19 September 2014

Individual Beneficiary List Sorting Helper OLD Comments

Individual Beneficiary List Sorting Helper is a tool to Record the Beneficiary List approved by the Grama Sabha and to sort it in a meaningful manner and to publish.

To Get the Download Link Click Here

Here You can enter Beneficiary List as approved from Grama Sabha

It can be sorted in many meaningful Orders.


for more details see comments under this post



Monday, 25 August 2014

MP MLA Relief Work Bill Maker - OLD Comments

MP MLA Relief Work Bill Maker is a tool to deal with many type of works
To get the Download Link Click Here



MPLADS
MLA SDF
NCRFRW
DRAUGHT
DMD
DRWHM

This tool contains
Covering Letter for Final Bill
Completion Report
Memorandum of Payment
Receipt for Allotment
Bills for Final Payment
Requisition
Authorisation
Proceedings
TR 59A
Allotment

DD Chalan
IT Chalan

Contingent Bill

----------------------------------------------------------------------------------------------------
To have more details about the works contained in this software
Visit MP MLA Relief Works

----------------------------------------------------------------------------------------------------
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.

Make your comments on the post itself.
---------------------------------------------------------------------------------------------------




Thursday, 7 August 2014

Tender Advertisement

View a sample Tender Document Uploaded to Net Click Here

View Letter to News Paper to Publish Tender Advt Click Here

Wednesday, 6 August 2014

EMD, SD, Cost of Tender Form Calculator

EMD, SD, Cost of Tender Form Calculator
Click Here

 A tool for calculating Rates of Earnest Money Deposit, Security Deposit and Cost of Tender Form. Also there are relevant Govt. Orders in connection with Tenders and other Procurement methods adopted by Local Self Government Institutions.

See Also

Store Purchase Manual Revised G.O.P.No.03-2013-SPD  dated 21-06-2013

Guidlines for Procurement of Goods and Services G.O.P.259-2010-LSGD dated 08.11.2010

Tender Advertisement Should be Published in LSGD Web Site www.lsgkerala.gov.in
and the window advt should be pubished in two leading news papers (one malayalam and one in english)
to see a trial advt click here

Thursday, 20 February 2014

Project Data Entry Form - Miniature

We are doing our tasks in a trial and error (sometimes succeed) manner.
we directly enter our projects in sulekha. and correct validation there. delete some projects etc.
Why can't we use Project Helper or Project Preparation Helper for correcting Validation.
It also gives us the Verification Report in A4 in a readable manner which we can export to pdf
and use in Padhathi Rekha.

Why can't we write the Projects in Project Forms.
Accordingly, it is assumed that   we are writing Projects in Forms and digitizing with Sulekha.
Here a Miniature Sketch of Project Form. which enable us to prepare for projects
Instruct each implementing officer to write it and keep this with you

To get the Project Data Entry Form - Miniature Click Here

Monday, 17 February 2014

Saturday, 1 February 2014

Project Preparation Helper

A simple tool for Preparing Project Validation
We can adjust the project costs to tally with the  Validation
and see the Project Reports, Verification Statement etc.


Now You can copy the project List to
Project Helper and use.




To Get PROJECT PREPARATION HELPER FOR 2016-17 CLICK HERE

Now Included Asst. Secretary, and Ward wise Details
to get the File for Excel 2003 Click Here

to get the file for Exel 2007  Click Here

For a Fully Solved Example See Parappukkara GP

To Get PROJECT PREPARATION HELPER FOR 2016-17 CLICK HERE