List of Useful Softwares & Tools
which can be used for free
To Get tips for Project Preparation Project Preparation TipsAFS Tools 2019-20
Video Tutorials by Panchayath Help Desk
To Watch the Video Tutorials by Panchayath Help DeskClick Here
Tools and Notes Arranged
Subject Wise
CLICK HERE
This Post contains Tools and Notes Published in www.PanchayathHelpDesk.BlogSpot.In Arranged Subject Wise. This will help the readers of this blog to get immediate reach of the correct subject tools and notes. This will be very helpful to the Employees of Panchayaths in Kerala.
ISO (Record Manager, Citizen Survey Results Maker etc.) ACCOUNTS (Bill Register Maker, Bank Book Reconciliation Helper, Contingent Bills etc.) PLAN (Project Helper, Individual Beneficiary List Sorer, Project Preparation Helper, Project Revision Helper etc.)
Model Minutes for Finance Standing Committee
This is useful for new Accountants in Panchayath Offices in Kerala for Preparing Minutes for Finance Standing Committee. There are certain items those should be included in each minutes and those items are briefed in this models.
Saankhya Sanchaya Data Comparison
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.
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.
1.Wages Calculation of Daily Contract Vehicle 20-08-2020 Click Here
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.
It is a tool to Record
the Beneficiary List
approved by the Grama Sabha
and to sort it
in a meaningful manner and to publish.
It includes sorting in accordance with new subsidy guidelines
A Dummy Editor for editing with speed
is provided
3. E Bill Vouchers Modifier 10-08-2020 Click Here
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.
4. DPC Own Fund Statement Maker 05-08-2020 Click Here
5. Depreciation Calculation Helper 2019-20 for Municial Accounts 26-07-2020 Click Here
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
6. Project Sector Mapper 15-07-2020 Click Here
7. Project Revision Manager 2020-21 09-07-2020 Click Here
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.
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.
8 Sulekha Micro Sector Codes Filter with CFC Tied Heads 06-07-2020 Click Here
It was an attempt to co-ordinate the making of
It will be very useful to all of us.
9. Honorarium & Allowances of President and Members 31-05-2020 Click Here
It is a tool very helpful to Panchayaths
for calculating and disbursing
Honorarium and Sitting Fee of
President and Members
10. Bill Register Maker 28-05-2020 Click Here
Depreciation Calculation Helper 17-05-2020 Click Here
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
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
Queue Bill Manager 14-04-2020 Click Here
TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281) 07-04-2020 Click Here
In this tool there are only few lines to edit. The rest of the portion will be filled in automatically.
Project Preparation Helper 2020-21 18-03-2020 Click Here
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 Preparation Helper (for Panchayaths) 2020-21 18-03-2020
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.
Details of Roads for Disaster Management 13-03-2020 Click Here
Project Preparation to Budget Mapping Helper for Panchayaths 2020-21 10-03-2020 Click Here
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.
Budget Sheet Data from Saankhya Reports 07-03-2020 Click Here
Project to Budget Mapping Helper 2020-21 for Municipalities 06-03-2020 Click Here
Collection Pending Report Maker for Panchayahs 21-02-2020 Click Here
ELECTION Process Simplifier 29-01-2020 Click Here
Bill Details to Bank List Maker 21-01-2020 Click Here
Licence & PT Manager 14-01-2020 Click Here
(Versions for 1,000 Entries and 2,000 Entries are avilable)
Project Manager 12-01-2020 Click Here
Now this is a trial version.
please contribute your ideas to make it a better tool to help you.
Formulation Planner 01-01-2020 Click Here
Pension Home Mustering Filter Helper 13-12-2019 Click Here
Calculations for Road Details
Receipt and Payment to Minutes Helper 01-12-2019
This will be a good practice to produce this printout before the Finance Standing Committe.
You have to copy down the data of Saankhya Receipts and Payments exported to Excel.
Project Manager 22-11-2019 Click Here
Joint Venture Funds Verifier 17-11-2019 Click Here
Profession Tax and Room Rent Arrears and PI Calculator 18-10-2019 Click Here
CFC Fund Utilization Calculator Click Here 17-09-2019
Type of Payment Vouchers and List of Enclosures 25-08-2019 Click Here
MP MLA Relief Work Bill Maker 17-18-2019 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
CMDRF Recovery and Remittance Reconciliation Helper 28-06-2019 Click Here
This tool comes in two platforms viz. MS Excel and LibreOffice Calc.
Record Manager 21-06-2019 Click Here
BIMS Receipt Simplifier 15-06-2019 Click Here
BIMS Bank Pass Book Simplifier 21-05-2019 Click Here
Saankhya Bank Book Simplifier 20-05-2019 Click Here
DA Arrears to Cash Bill Maker 14-05-2019 Click Here
Saankhya Sanchaya Data Comparison and Mapping Tools 07-05-2019 Click Here
Saankhya Sanchaya Data Comparison
Saankhya Sanchaya Receiptwise Comparison Helper
E-Payment Bank Statement Maker 15-04-2019 Click Here
Plan Expenditure Verifier 11-042019 Click Here
By the help of this tool they can easily find out the differences in Plan Fund expenditure in the soft wares like Local Saankhya, Web Saankya and Sulekha.
This tool is very helpful while preparing Annual Financial Statements.
Saankhya Ledger with Wardwise and Headwise Report to Register 08-04-2019 Click Here
Saankhya Ledger and Headwise Report to Register 08-04-2019 Click Here
Capital Works in Progress to Assets Calculation Helper 07-04-2019 Click Here
In this circumstances at the year ending we should check the ledger of Capital Work in Progress and find whether the work is done in complete or not.
If the work is completed in the current year itself we should change the payment voucher through adjustment journal. By this journals, we can see in future that the voucher itself adjusted to the corresponding asset heads.
But if the works are completed after the bill year then we can do only a rectification journal and in that case we take the total amounts of each assets to convert from Capital Work in Progress.
Provision Calculator 05-04-2019 Click Here
AFS Registers List Maker 04-04-2019 Click Here
Saankhya Headwise Report to Register 02-04-2019 Click Here
To Go to the Download Page of the tool
Saankhya Headwise Report to RegisterClick Here
Plan Fund Manager 21-03-2019 Click Here
Plan Fund Manager is an effort for coordinating various reports from Sulekha and Web Saankhya to form some useful calculations on plan fund. It will be very useful for Panchayats in Kerala.
Saankhya Year Beginning Process Helper 15-03-2019 Click Here
Accounts Verification Helper 14-03-2019 Click Here
Accounts Verification Helper is an attempt to make a verification report using Saankhya Reports. This tool will help the acctountants of Panchayaths in Kerala to make their accounts purified.
Budget Preparation Helper (for Panchayaths) 2019-20) 10-02-2019 Click Here
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 Preparation Helper 2019-20 (for Municipalities)
Pay Revision Arrears to Cash Bill Maker 25-12-18 Click Here
of our Office Staff.
Saankhya Details to FFC Data Maker 15-12-2018 Click Here
This tool help us to Prepare Financial Assessment Data for Fifteenth Finance Commission Report and others.
This tool make use of Saankhya Receipt & Payment and Income & Expenditure Reports of 7 Years.
You have to Export them to Excel form and just copy paste it for preparing the Reports.
Bank Book for Reconciliation Helper 14-11-2018 Click Here
Bank Book for Reconciliation Helper is a tool for making Bank Reconciliation Statement from the Saankhya Bank Book.
This is helpful for Accountants in Panchayaths of Kerala.
They can export the Saankhya Bank Book Report to Excel (Data Only)
and Paste the data to this tool.
Bill Report to Bank List Maker 12-11-2018 Click Here
This can be used when we want to convert Web Saankhya Bill Report PDF List to Excel Beneficiary Account Details.
This tool is very useful when combined with Bank Account List Maker
The prepared list can be used for the fund transfer to Beneficiary Accounts especially in case of Own Fund Bills.
Bank Account List Maker 28-10-2018 Click Here
Citizen Survey Results Maker 28-10-2018 Click Here
Citizen Survey Results Maker is a tool developed by KILA and Designed by Panchayath Help Desk to help panchayaths in Kerala to make the data entry of citizen survey easier.
Letter to Allied Institutions for Budget Prepartion
Honorarium & Allowances of Elected Representatives for Municipalities & Corporations 30-07-2018 CLICK HERE
It is a tool very helpful to Municipalities & Corporations in Kerala
for calculating and disbursing
Honorarium and Sitting Fee of
Mayors/Chairpersons and Members
This tool helps us to make contingent bill to accord any type of expenses in our Offices.
Here we can have three types of contingent bill makers.
Consolidated Contingent Bill Maker
Compounded Contingent Bill Maker
each contain
Authorisation,
Note sheet,
Proceedings,
Fully Vouched Contingent Bill
TR 59 C
UnEmployment Allowance Manager 16-07-2018 Click Here
This tool helps us to make a list of Beneficiaries, Mark Distributions, List pending distributions, Create Reports, Calculate the Period for Last Payment, Prepare Notice for Press / Media, Create Utilization Certificate and further it helps us to create a list for next distribution automatically
Capital Works Fund Distributor 19-06-2018 Click Here
Saankhya Ledger to Register Maker 19-06-2018 Click Here
Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers. For Example the Ledger for 460500501 advance to implementing officers contains many simple registers like Honorarium to MGNRGES Staff, Keralotsavam Expenses, Pain and Palliative, Sanitation etc. Considering another Example. The Ledger for 320800101 beneficiary contributions contains the receipts and payments of all projects that contain Beneficiary Contribution as a source of fund. This ledger can easily be dissolved into smaller registers using this tool. These two examples are deliberately given with this post. You can download the Latest tool and watch the two examples.
This tool is very helpful in some other aspects also. There are some heads like Festival Advance, EMD, Pension Contribution etc. These heads contains Receipts as well as Payments. So here we have to calculate the amount we collected and should return or the amount which we distributed and should be demanded. To calculate the default amount we can use the Include Option in the Register.
Project Preparation Helper 2018-19
04-03-2018 Click Here
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
GOTO THE DOWNLOAD PAGE OF
PROJECT PREPARATION HELPER
CLICK HERE
Residential and Ownership Certificate Maker 15-02-2018 Click Here
Beneficiary List Index Maker 14-01-2018 Click Here
The Panchayaths have been distributing individual benefits for the last two decades. But there is no practice of recording their details in a way that anybody can check it.
This tool helps.
Saankhya Payment Helper 29-12-2017 Click Here
Those who are interested to contribute to the making of this tool simply download it, enter your data in the page named "List" and fill in their Address in the page named "Courtesy" and send the file to manurappal@gmail.com
Those who want to use this file can simply download this file from www.PanchayathHelpDesk.BlogSpot.Com without any Payment
Project Revision Helper 03-12-2017 Click Here
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.. Sorted Report, Tabulation, Report, Resolutions of Various committes.
Salary & Recoveries Distribution Helper 23-10-2017 Click Here
TA Bill Preparation Helper for Performance Audit Unit 22-10-2017 Click Here
Budget Sheet Data Picker 08-03-2018 Click Here
This tool Helps us to Get a comparison of data available for Budget Preparation with the help of Income & Expenditure, Receipt & Payment and Balance Sheet. This data may not be copied, but some idea of Budgeting will be available in this tool. This will be a helpful tool to Accountants in Panchayaths in Kerala.
Front Office Assistant 28-07-2017 Click Here
To go to the download page Click Here
GPRMS Revenue from Receipt and Payments of Saankhya
23-07-2017 Click Here
This is a tool to obtain data for Tax Revenue Fields in the Grama Panchayat Monthly Progress Reporting and Monitoring System which should be furnished monthly by all the Grama Panchayaths in Kerala.
They have to just copy paste the excel exported data from Saankhya Receipts & Payments and the report can be pasted to the website or take print out.
To go to the download page Click Here
Project Helper 01-06-2018 click here
A tool for Project Formulation,
Implementation and Reporting.
It contains
Project List, Validation, Expenditure Report, Project Report, Implementing Officerwise Report, Mandatory Projects, Sectorwise Report, Plan Fund Report, MG Fund Report, Project Summary, Bill Maker, TR 59, Requisition, Authorisation, Proceedings, DD Chalan, Allotment, Contingent Bill, Project Register, Completion Report, ACR, Joint Venture Projects Shares, etc.
Welfare Standing Committee Resolution Maker 28-03-2017 Click Here
This Tool helps Grama Panchayaths in Kerala to handle various applications in connection with Allotting, Cancelling Pensions.
In this tool, you can add your applications for various pensions and get the resolution for Welfare Standing Committee Meeting.
We can print letters to applicants intimating allotting of pensions,or correcting any errors,or demanding any missing documents.
We get a consolidation sheet of each standing committee meeting.
Budget Preparation Helper 20-03-2017 Click Here
Budget Preparation Helper is a tool Co-Developed by KILA & Panchayath Help Desk. This tool help Panchayaths, Municipalities & Corporations in Kerala to Prepare the skeleton on Budget and improve it by revision.
Allotment and Bill Maker 12-03-2017 Click Here
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, TR 59C
Allotment
DD Chalan
D&O Licence with PT Register 25-11-2016 Click Here
Here you can enter the D&O Collection, Adv.Collection and Get Traders List
PT, Traders PT
and Finally Get the DCB of All
Sankhya Sanchaya Mapping Helper 26-10-2016 Click Here
It is a tool to co-ordinate Building Details from Sanchaya
and Receipt Details from Sankhya.
It helps mapping each receipt to correspoding building number
Project Preparation Helper 20-09-2016 Click Here
THE TOOL FOR 2017-18 WILL BE RELEASED BY 19-04-2017
A Simple tool for Project Preparation for 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
Click Here
. Creating Directory of Sulekha Codes forAssets in Purchase 20-08-2016 Click Here
It is an attempt to co-ordinate
the making of
Directory of Sulekha Codes
for Assets in Purchase
It will be very useful to all of us.
The plan formulation
Panchayaths will be get accelerated
with this tool.
Creating Directory of Sulekha Codes forAssets in Construction 17-12-2015 Click Here
It is an attempt to co-ordinate
the making of
Directory of Sulekha Codes
for Assets in Construction
It will be very useful to all of us.
The plan formulation
Arrear DA Calculation 25-11-2015 Click Here
This tool helps us to calculate and remit the DA Arrears
of our Office Staff.
Sanchaya to Assessment and Demand Register 05-08-2015 Click Here
This tool helps to convert Data from Sanchaya to to form of Assessment and Demand Register which is very useful for panchayaths in Kerala.
EMD, SD, Cost of Tender Form Calculator 05-11-2014 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.
. Click Here
SoftWare Upgradation Click Here
This link Help You to shift from one version of Software to newer one.
pls mail your software.
you will get it refreshed
Sankhya Wadwise Report Modifier 20-04-2015 Click Here
This tool helps to produce a sorted list of receipts from Sankhya arranged building number wise. This is very helpful for the posting of Collection for the Panchayat Offices in Kerala.
and It links you to Sankhya Sanchaya Mapping Helper
. Pension M.O. Return Treasury Remittance 04/04/2014 Click Here
. Application form for Scholarship for Differently Abled Students 19/03/2014 CLICK HERE
. Form of Agreement Simple 20/02/2014 Click Here
. LSGD Budget for 2014-15 Released Click Here
Project Revision Helper 31/12/2013 Click Here
KPBR NOC Issue Register 27/12/2013 CLICK HERE
KPBR NOC ISSUE REGISTER 30/10/2013 CLICK HERE
Petty Work Bill Maker 28/10/2013 CLICK HERE
Penal Interest Table for Building Tax 28/10/2013 CLICK HERE
Appropriation Control Register 31/08/2013
Panchayath Sahayi
ReplyDelete