My Posts

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

Monday, 8 February 2021

Formulation Planner 2021-22

 This tool helps  us to accelerate the plan formulation process. It is helpful to avoid missing and mistakes in the  wast procedures of decentralization. This tool will be useful to the Panchayaths in Kerala.


Formulation Planner 2022-23

 This tool helps  us to accelerate the plan formulation process. It is helpful to avoid missing and mistakes in the  wast procedures of decentralization. This tool will be useful to the Panchayaths in Kerala.








To Download the tool Formulation Planner 2021-22 Click Here














Tuesday, 2 February 2021

Project to Budget Mapping Helper 2020-21 Revision (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.


To get the Tool
Project to Budget Mapping Helper
CLICK HERE










































This tool will tell you whether the funds mapped from Project Data to Budget Data is correct or not.






















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


Wednesday, 20 January 2021

Budget Preparation Helper (for Panchayaths) 2021-22

 




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.



https://manushelpdesk.files.wordpress.com/2021/01/cover-page-layouts-copy.jpg













To Download


Budget Preparation Helper for Panchayaths 2021-22

CLICK HERE
















































To be Finalized

See Also



Letter to Allied Institutions for Budget Prepartion


This is a model letter to Allied Institutions for the Non Plan Proposal for Budget Preparation. The letter should be send along with A1, A2 sheets of Budget Preparation Helper.


Use PDF Merger to Merge Different Documents (Like Cover Pages, Budget Speech, Gender Budget, Performance Budget, Budget Statement, Budget Schedules and Back Cover) to Form a Single File  and Give Page Number

To Download the Tool PDF Merger Click Here





See Also




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






Budget Preparation Helper 2019-20 (for Municipalities)


Friday, 18 September 2020

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.








Wednesday, 12 August 2020

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 


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




To get the File Click on the link 



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





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






Thursday, 6 August 2020

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