Honorarium & Allowances of President and Members (2020 December Only)

 Honorarium & Allowances of President and Members

It is a tool very helpful to Panchayaths

for calculating and disbursing

Honorarium and Sitting Fee of

President and Members


(2020 December Only)

To Go to the  Download Page of the Tool Click Here

Election 2020 EVM setting Ballet Unit Key Combinations, Mock Poll Trial Sheet and Booth Codes List

 These formats will be very helpful for setting Electronic Voting Machines to be used for General Elections. This Contains EVM Setting Ballet Unit Key Combinations which is to be placed on ballet unit. Mock Poll Trial list is also included for checking purposes. 

To Go to the  Download Page of the Tool Click Here

Token Generator

 This tool will help us to Generate TOKEN when there is a huge queue for various purposes like election.

This  will be very helpful for the Panchayaths in Kerala.

 To Go to the  Download Page of the Tool Click Here

Election Nomination Process Simplifier

  This tool will help us to record the details of nominations submitted before the Panchayaths for the General Election 2020. This tool will give the various formats which are essential for the conduction of election.

To Go to the  Download Page of the Tool Click Here

Gap Fund Proforma Simplifier 2020-21

 This tool helps us to calculate the Probable gap fund that may be allotted to the Grama Panchayath.. This tool coordinates data from Local Saankhya. We have to copy paste Income & Expenditure and Balance Sheet Data to this tool.  This will be very helpful for Accountants and Accountants of Panchayaths in Kerala.

To Go to the  Download Page of the Tool Click Here

DCB Statement Maker

 This tool helps us to formulate the Demand Collection Balance Statement for the Given Period. This tool uses Reports from Saankhya such as Balance Sheet and Income & Expenditure Statement. This will be very helpful for the Panchayats in Kerala.

To Go to the  Download Page of the Tool Click Here

Order for Treasury Account to Implementing Officers Allowing payment to beneficiaries/vendors by way of treasury chequesClarification issued.

 This orders says that

. If the Implementing Officer is not having

any treasury account, a non interest bearing special TSB account is

permitted for this purpose. No separate order for opening such

accounts is necessary for this purpose. The DDO/Implementing Officer

can issue treasury cheques for subsequent payments from this

account subject to the general guidelines on withdrawals from TSB

accounts. 

To Go to the Download Page of the Circular Click Here

Sixth Finance Commission Report Part 1 with Data

  Here we have consolidated some of the best answers for  Sixth State Finance Commission Report Part 1. We request each staff in Panchayaths to contribute their ideas further. Please send us your responses to our mail address noted in this file. 

This data file is presenting in three formats viz. PDF, Word, LibreOffice

Font Used : Meera

To Go to the download page of the file Click Here

Sixth Finance Commission Report Part 1 with Data Invitation for Discussions

  Here we have an pdf format of  Sixth State Finance Commission Report Part 1. The answers best suitable for the given situations is under discussion. This file includes some of the best answers evolved during discussions. We request each staff in Panchayaths to contribute their ideas for each questions. Please send us your responses to our mail address noted in this file. 

After few days we will consolidate all answers available and send this file in editable format to prepare Panchayath Resolutios.

To Go to the download page of the file Click Here

Pension Not Mustered List Maker

  This tool will help to find out the list of beneficiaries of social security pension schemes pending mustering. This will take list of active pensioners from Welfare Pension website as input. It then gives us the list of not mustered peoples. This will be very helpful for the pension section at Panchayaths and Municipalities in Kerala.

This is very heavy file. (If it is converted to Excel 2007or even later version, the size will decrease and will be very easy to use. So save as to your version after opening the file)

The file is attached as zipped file. So please extract or unzip the file and then save to your destination folder. Only then start your works.

Try to avoid operating other excel files while you are working with this tool.

To Go to the download page of  the Tool Pension Not Mustered List Maker Click Here

Election Annexures Maker

 

This tool is very helpful for the officers in charge of Election Process. During the election process they have to fix the reserved seats for Women, SC, ST etc. The combinations of reservation will be recorded in Annexures 1 & 3.  This will be very useful for all the Panchayaths in Kerala.

To Go to the Download page of  Election Annexures Maker  Click Here

Sixth Finance Commission Report Part 1

 Here we have an editable version of  Sixth Finance Commission Report Part 1 which  works with  Open Office and  LibreOffice Writer. The answers best suitable for the given situations is under discussion and it will be consolidated shortly.

To Go to the Download page of  the PDF Format and editable version  of Sixth Finance Commission Report Part 1  Click Here

Sanchaya Residential and Commercial Filter (Heavy)

 

This tool will help us to calculate the details of buildings in Panchayath. It will filter the details of residential and commercial buildings. It will also give the details of exemptions given to each type of buildings.

Caution:

This tool become heavy with large data of buildings in Panchayath.

So please call all other excel files before opening this tool.

To Go to the  Download Page of  the tool Click Here

UA Collection Calculator (Heavy)

 This tool helps us to calculate the Collection details from UnAuthorized Buildings. There may be many buildings in any ward which has given UA Numbers. They should be Instructed to demolish as per order. but till then we should collect the taxes. 

The details of  taxes collected from such buildings will be calculated from Local Saankhya and Sanchaya Data. 

This tool will be very helpful for the accountants and property tax section clerks of Panchayaths in Kerala.

To Go to the  Download Page of  the tool Click Here

Formats and Tools for Sixth State Finance Commission Proposals

  These are tools and formats designed for fetching data for Sixth State Finance Commission Proposals

They include IT GST WF LC Tabulation Helper, Sixth Finance Commission Report Format , UA Collection etc.

To go to the Page Formats and Tools for Sixth State Finance Commission Proposals Click Here

IT GST WF LC Tabulation Helper

 This tool helps us to calculate the collection and remittance of Income Tax, GST, Construction Workers Welfare Fund, Library Cess. This tool coordinates data from Local Saankhya and Web Saankhya. This will be very helpful for Accountants and Plan Clerks of Panchayaths in Kerala.

To Go to the  Download Page of  the Tool Click Here

Wages Calculation of Daily Contract Vehicle

  This tool will be very helpful to calculate the wages of daily contract vehicle. Most Grama Panchayaths in Kerala have hired contract vehicles for LGSD Assistant Engineers. By using this tool they can easily calculate the wages.

To Go to the Download Page of  the tool Click Here

Individual Beneficiary List Sorting Helper 2020-21

  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.

The Version 7M will handle details of 7,000 Beneficiaries

The version 11 M will Handle details of  11,000 Nos.

Click Here to Go to the download page of the tool

Here You can enter Beneficiary List as approved from Grama Sabha

It can be sorted in many meaningful Orders.

It includes sorting in accordance with new subsidy guidelines

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

E Bill Vouchers Modifier

 This tool helps us to get a list of E-Bill Vouchers from Local Saankhya. We can sort,  print, copy paste the report. This will be very helpful for plan clerks and accountants of Panchayaths in Kerala.

To go to the download page of the tool click here

DPC Own Fund Statement Maker

This tool helps us to make Own Fund Statement for DPC. Own Fund Statement is to be produced before District Planning Committee for each revision. This tool will be very helpful for the plan clerks and accountants of panchayaths and municipalities in Kerala.

To goto the  Download Page of the Tool Click Here

Depreciation Calculation Helper 2019-20 for Municial Accounts

Depreciation Calculation Helper is a tool which helps accountants in Panchayath Department of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets

To Go to Download Page of the  File for Excel 2007 Click Here

Project Sector Mapper

This tool helps us to calculate the amount utilized for the various sectors like OldAge, Child, Differently Abled, Women, Sanitation, Housing etc. in Decentralized Planning Process of Panchayaths. This will be very useful for plan clerks in Panchayaths in Kerala.

To go to the Download Page of the Tool Click Here

Project Revision Manager 2020-21

It is a tool to help us in the revision process of our projects.

This tool gives us varius reports in connection with revision

viz.. Validation Report, Tabulation, Resolutions of  committee.

This tool will be very useful for the Decentralized Plan Section of

Panchayaths in Kerala.

to Go to the Download Page of the Tool   Click Here 

Sulekha Micro Sector Codes Filter with CFC Tied Heads

It was an attempt to co-ordinate the making of

Sulekha Micro Sector Codes Filter Dictionary
It will be very useful to all of us.

To Go to the Download Page of the tool 

Sulekha Micro Sector Codes Filter  with CFC Tied Heads 

Click Here

Malayalam Inscript KeyBoard Installer

This tool helps us to manage our malayalam typing. we always have troubles with typing CHILLAKSHARAMS. This problem can be avoided by installing the inscript fonts. And now we have to type a combinations of Control key + Alt Key and 1 Key to get the CHILLAKSHARAMS. 

To goto the Download Page of  the Software Click Here

Useful Tools

Tools and Notes Arranged Subject Wise

AFS Tools 2019-20

These tools are useful Panchayaths in Kerala for their works in connection with preparing AFS (Annual Finance Statements).

Queue Bill Manager

This tool helps us to calculate the details of  queue bills in relation with Decentralisation Plan activities of various panchayaths in Kerala.


To Go To the Download Page of the Tool Click Here

Depreciation Calculation Helper 2019-20

Depreciation Calculation Helper is a tool which helps accountants in Panchayath Department of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets

To Get Latest Tools Visit Panchayath Help Desk


To go the  Download Page of the File for Excel 2007 Click Here