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.

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

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.

Sixth Finance Commission Report Part 1 (Questions Only)

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.

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.

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.

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.

Selected Tax Collection Report Maker

 This tool will help us to list the tax remitted for each buildings in a list. for a range of years. This will be very useful when we want to list out tax collection of Central Government Institutions or likewise. This tool will be very useful for accountants and property tax section clerks in Panchayaths in Kerala.

Dummy Editor for Beneficiary Lists 2020-21

 This tool is very useful for usually every  panchayaths in Kerala.

Since The Individual Beneficiary List Sorting Helper for Excel is a Heavy tool,

it takes more time to edit data in that file.

So we can use this tool for entering data 

and correcting.

To get the Final Output we should copy the data to 

Individual Beneficiary List Sorting Helper

Notice : Please use Paste Special - Values to copy paste data

To get the File Click on the link 

Click Here to Get Dummy Editor for Beneficiary Lists 

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 New Order will handle details of 7,000 Beneficiaries and 50 Projects

To Get file for Excel 2007 7M   Click Here

The version 11 M New Order will Handle details of  11,000 Nos.and 50 Projects

To Get File for Excel 2007 11 M Click Here

The version 7 M will Handle details of  7,000 Nos. and 100 Projects in Old Order

To Get File for Excel 2007 7 M 100 Projects Click Here

To Get a Fully Solved Example  Click Here

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



SEE ALSO

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

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.

Own Fund Statement from Balance Sheet and Budget Data

 This tool helps us to make Own Fund Statement for DPC and other purposes. Own Fund Statement is to be produced before District Planning Committee for each revision. Own Fund position is required for allotting new posts in Panchayaths This tool will be very helpful for the Plan Clerks, Establishment Clerks and Accountants of panchayaths and municipalities in Kerala.

To Download the Tool DPC Own Fund Statement Maker 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 Download the Tool Click Here

Project Revision Manager 2020-21

Project Revision Manager 2021-22

 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.

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 Download the Tool   Click Here 

To   calculate the amount utilized for the various sectors like OldAge, Child, Differently Abled, Women, Sanitation, Housing etc. in Decentralized Planning Process of Panchayaths. 

Click Here to go the Donload Page of  Project Sector Mapper

See Detailed Note on Project Revision by Deepu & Manoj

Click Here to Download the FAQ

Click Here to Download the Appendix of FAQ

To See List of  Micro Sector Codes Suitable for CFC Tide Fund Click Here

See Detailed Note on Project Revision by Deepu & Manoj

Click Here to Download the FAQ

Click Here to Download the Appendix of FAQ

To See List of  Micro Sector Codes Suitable for CFC Tide Fund 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 Download the tool 

Sulekha Micro Sector Codes Filter  with CFC Tied Heads 

Click Here

To See the Instructions on What and How we Did Click Here

Creating Directory of Sulekha Codes  for Assets in Purchase

Click Here

See Also

Directory of Sulekha Codes for Assets in Purchase

This is an attempt to Co-ordinate the Making of Directory of Sulekha Codes for Assets in Purchase 

Directory of Sulekha Codes for Assets in Construction

This is an attempt to Co-ordinate the Making of Directory of Sulekha Codes for Assets in Construction

Shelf of Projects

It is an attempt to collect the details of possible projects that can be implemented by various Local Self Governments, mainly GramaPanchayaths in Kerala, India.

Each person who knows the essence of Plan contributes to this great work either by contributing new successful project data or by adding corrections or attributes for list of projects already in the shelf. 

The plan formulation process in Panchayaths will be get accelerated
with this tool.

To See the Malayalam Details of this Post Click Here

The work is now completed as it is.
Please wait for the next chance to cotribute....

Click Here to Download  Sulekha Micro Sector Codes Filter for Excel 2007

Click Here to Download  Sulekha Micro Sector Codes Filter for Excel 2003







So now please contribute to the making of this tool.
you download this tool and plan a number say 25 or 50 or even 100
microsector codes to add to this tool.

please comment under this post
from what number to what number you are planning to contribute.

To See the Malayalam Details of this Post Click Here




Please make your comments in English only


To see the list of micro sector codes in Plan Formulation

and to Download the pdf files of List of Sulekha Micro Sector Codes

Click here to reach the Main Page of Sulekha Micro Sector Codes





To See the Instructions on What and How to Do Click Here

To See the Main Page of Panchayath Help Desk
Click Here

Depreciation Calculation Helper - Video Tutorial

This video is about the Depreciation of assets of Local Self Government in Kerala. It describes how to calculate the depreciation using Depreciation Calculation Helper tool designed by Panchayath Help Desk.

This is very useful for Accountants in Panchayaths in Kerala. 

The YouTube Videos will not be playing on restricted connections. So use BroadBand connections for better video Performance.

To go to the download page of the tool Click Here

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 Download the File Click Here

Details of Roads for Disaster Management

This is an easy tool to get the details of roads in our Local Body from Sachithra Asset Register. This tool will be very helpful for Plan Clerks of Panchayaths in Kerala

To download the tool Details of Roads  for Disaster Management Click Here

See Also

Calculations for Road Details

Calculations for Road Details is a tool to help calculating Details of roads from Sachithra Asset Register Data Base and to find out the expenditures for road works from Sulekha Data Base.

Budget Sheet Data from Saankhya Reports 2020-21

Budget Sheet Data from Saankhya Reports is an attempt to Collect all the Data for Budget Preparation from Saankhya Reports. for Correctness the data of projects should be collected from Project to Budget Mapping Helper.

Use New Tools

Budget Sheet Data from Saankhya Reports 2021-22 (ForPanchayaths)

TRIAL RUNNING COPY


To Download the Tool Click Here

See Also

Budget Preparation Helper (for Panchayaths) 2020-21

Budget Preparation Helper (for Panchayaths) is a tool  by KILA Designed Panchayath Help Desk. This tool help Panchayaths in Kerala to Prepare the skeleton on Budget and improve it by revision.
The tool is enhanced with the printing option with single sheet. and further we can print only the relevant area using Print Short Budget.

This tool can be downloaded and used for free.

Comment on any mistake in this tool and you can get it repaired and updated.

Project to Budget Mapping Helper 2020-21 (ForPanchayaths)

Project to Budget Mapping Helper is a Tool to Map Project Allotment  from Project Preparation Helper and Budget Detailed Head of Budget Preparation Helper. This will help the Budget formulation of Panchayaths in Kerala.

Project Preparation to Budget Mapping Helper for Panchayaths 2020-21

Project Preparation to Budget Mapping Helper is a Tool to Map Project Allotment  from Project Preparation Helper and Budget Detailed Head of Budget Preparation Helper. This will help the Budget formulation of Panchayaths in Kerala.

Project Preparation Helper 2020-21

Project Preparation Helper is a tool to help the Project Preparation Process
in Connection with Decentralized peoples planning
through Panchayaths in Kerala.


Here we can add projects
correct validation
print project reports
check wardwise allocation
check sectorwise allocation
print various committe resolutions etc.

The Project List can be easily copied to PROJECT HELPER

Budget - Helping Note

Budget- Helping Note

by Sri. T.K.Sunil Kumar &
     Sri. Jomon Mathew

It is a very useful book for Accountants in Panchayaths of Kerala.
In this tutorial we can find each and every procedures, steps, dos, and don'ts.

It tells us how to form a budget and how to modify it or revise it.

Project Preparation to Budget Mapping Helper for Panchayaths 2020-21

Project Preparation to Budget Mapping Helper is a Tool to Map Project Allotment  from Project Preparation Helper and Budget Detailed Head of Budget Preparation Helper. This will help the Budget formulation of Panchayaths in Kerala.

Project Preparation to Budget Mapping Helper for Panchayaths 2021-22

To Download the  Tool
Project Preparation  to Budget Mapping Helper for Panchayaths 2020-21
CLICK HERE

See Also

Budget Preparation Helper (for Panchayaths) 2020-21

Budget Preparation Helper (for Panchayaths) is a tool  by KILA Designed Panchayath Help Desk. This tool help Panchayaths in Kerala to Prepare the skeleton on Budget and improve it by revision.
The tool is enhanced with the printing option with single sheet. and further we can print only the relevant area using Print Short Budget.

This tool can be downloaded and used for free.

Comment on any mistake in this tool and you can get it repaired and updated.

Budget Sheet Data from Saankhya Reports 2020-21

Budget Sheet Data from Saankhya Reports is an attempt to Collect all the Data for Budget Preparation from Saankhya Reports. for Correctness the data of projects should be collected from Project to Budget Mapping Helper.

Project to Budget Mapping Helper 2020-21 (ForPanchayaths)

Project to Budget Mapping Helper is a Tool to Map Project Allotment  from Project Preparation Helper and Budget Detailed Head of Budget Preparation Helper. This will help the Budget formulation of Panchayaths in Kerala.

Project Preparation Helper 2020-21

Project Preparation Helper is a tool to help the Project Preparation Process
in Connection with Decentralized peoples planning
through Panchayaths in Kerala.


Here we can add projects
correct validation
print project reports
check wardwise allocation
check sectorwise allocation
print various committe resolutions etc.

The Project List can be easily copied to PROJECT HELPER

Budget - Helping Note

Budget- Helping Note

by Sri. T.K.Sunil Kumar &
     Sri. Jomon Mathew

It is a very useful book for Accountants in Panchayaths of Kerala.
In this tutorial we can find each and every procedures, steps, dos, and don'ts.

It tells us how to form a budget and how to modify it or revise it.