Manu's Panchayath Help Desk (Main Page): April 2020

List of Useful Softwares & Tools

which can be used for free

To Get tips for Project Preparation Project Preparation Tips

AFS Tools 2019-20

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

Video Tutorials by Panchayath Help Desk

To Watch the Video Tutorials by Panchayath Help Desk

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

Saankhya Sanchaya Data Comparison is a tool to Compare the data of Property Tax Demand and Collection. This will help to Record the Accrual Data. It also helps to find out if there is any difference between the collection details in Saankhya and Sanchaya

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.

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.

2. Individual Beneficiary List Sorting Helper 11-08-2020 Click Here

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

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.

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

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.

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.

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

Sulekha Micro Sector Codes Filter Dictionary
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

Bill Register Maker is tool which helps Accountants in Panchayaths of Kerala to handle various bills for payment and make bill register. It helps them to get data for Saankhya Payment Vouchers. It is very useful to keep the details of cheque issued and balance in hand. This tool will be very helpful for searching a particular payment throughout the year.

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

Queue Bill Manager 14-04-2020 Click Here

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

TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281) 07-04-2020 Click Here

This tool will be very helpful for remitting Income Tax Deducted at Source from Salaries or Work Bills. Normally the work bill deductions will be paid from treasury bill automatically. But in the case of Own Fund Works, we should submit IT Chalan Separately either in TR12 if we are remitting at treasury or in ITNS 281.

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

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

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

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 for Municipalities 06-03-2020 Click Here

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 Municipalities and Corporations in Kerala.

Project to Budget Mapping Helper 2020-21 (For Panchayaths) 06-03-2020 CLICK HERE

Collection Pending Report Maker for Panchayahs 21-02-2020 Click Here

Collection Pending Report Maker for Panchayahs helps us to make a list of arrears of property tax to be paid for each wards. This is done by using two reports from Sanchaya Data Base viz. Field Collection Report and Arrear Demand Notice. This tool will be very helpful to the Property Tax section clerks and field staff / collection staff of Panchayaths in Kerala.

ELECTION Process Simplifier 29-01-2020 Click Here

This tool is very helpful for the officers in charge of Election Process. During the work they have to receive application in Form 5 and consolidate it in Form 10. They have to give receipt and notice in Form 13 and Form 14. All these works are coordinated in this tool. This will be very useful for all the Panchayaths in Kerala.

Bill Details to Bank List Maker 21-01-2020 Click Here

This tool is very helpful for the Accountants in Grama Panchayath Offices in Kerala. They have to allot fund for many bills of various Implementing Officers. In the case of Own Fund Bills viz. Own Fund, Block Panchayath Contribution, District Panchayath Contribution, State Share, Central Share Bills they have to allot funds either to the corresponding Implementing Officers Accounts or to directly to the beneficiaries. Since there are treasury regulations at many occasions they have to transfer funds directly to the beneficiaries. For this transaction they have to prepare beneficiary account details in a treasury approved manner. This tool will be very helpful to coordinate the data from Saankhya Web Own Fund Payment Details to Bank Account List.

Licence & PT Manager 14-01-2020 Click Here

Licence & PT Manager is a powerful tool to deal with D&O Licence, Dog Licence and other Licences and the Professional Tax Details of Panchayaths in Keala. It provides space for data entry of applications and details of documents submitted with it. It gives Certificate, DCB Report and overall This tool provides you Data for Next Year
(Versions for 1,000 Entries and 2,000 Entries are avilable)

Project Manager 12-01-2020 Click Here

Project Manager is an easy tool to handle decentralized planning procedures in Panchayaths in Kerala. It co-ordinates various reports from Sulekha and Saankhya Web Online Softwares.

Now this is a trial version.

please contribute your ideas to make it a better tool to help you.

EMS Loan Interest Calculator 04-01-2020 Click Here

A tool allows you to calculate the interest and loan amount pending with respect to EMS Housing Scheme.

Formulation Planner 01-01-2020 Click Here

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.

E-Payment Bank Reconciliation Helper 26-12-2019 Click Here

E-Payment Bank Reconciliation Helper is an easy tool developed by Panchayath Help Desk for the calculation of Property Tax paid On Line. This tool is very helpful for Accountants and Property Tax Section Clerks of Panchayats in Kerala. This provides the amount to be receipted datewise or monthwise.

Pension Home Mustering Filter Helper 13-12-2019 Click Here

Pension Home Mustering Filter Helper is an easy tool to help the Pension Section in Grama Panchayats to accelerate the Mustering of People. This tool will help to sort the Active Pensioners List Not Mustered after removing list of pensioners opted Home Mustering

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.

Receipt and Payment to Minutes Helper 01-12-2019

Receipt and Payment to Minutes Helper is useful tool for preparing Data Required for Finance Standing Committe Minutes.

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

Project Manager is an easy tool to handle decentralized planning procedures in Panchayaths in Kerala. It co-ordinates various reports from Sulekha and Saankhya Web Online Softwares.

Trial Version

Joint Venture Funds Verifier 17-11-2019 Click Here

Joint Venture Funds Verifier is a simple tool to help organizing receipts and expenditures in connection with Joint Venture Projects of Panchayths. Usually Grama Panchayats will get funds from Block Panchayats and District Panchayats. These funds are incorporated with their own funds and plan funds. So this tool will be very helpful to Accountants and Plan Clerks of Panchayats in Kerala.

Profession Tax and Room Rent Arrears and PI Calculator 18-10-2019 Click Here

Profession Tax and Room Rent Arrears and PI Calculator is an easy tool to help Panchayaths in Kerala to calculate the arrears and Penal Interest of Room Rent which they get from their Shopping Complexes and Profession Tax of Traders and Employees

CFC Fund Utilization Calculator Click Here 17-09-2019

CFC Fund Utilization Calculator in combination with CFC Proforma Simplifier helps us to file the Finance Commission Grant Proforma.

Type of Payment Vouchers and List of Enclosures 25-08-2019 Click Here

Type of Payment Vouchers and List of Enclosures is a matter of discussion for Panchayaths in Kerala. Each Office has its own style and each officer has his on style. So it is an attempt from Panchayath Help Desk to Coordinate the various ideas in this area to provide a tension free Office Administration.

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

Report from Clerks to Finance Standing Committee on Tax Exemption 15-08-2019 Click Here

This Tool helps us to coordinate reports from Clerks to Finance Standing Committee on Tax Exemption like Vacancy Remission, Exemption for ExService Men,.... This is very useful for Clerks, Property Tax Sections and Accountants of Grama Panchayaths in Kerala.

CMDRF Recovery and Remittance Reconciliation Helper 28-06-2019 Click Here

This simple tool helps us to verify the correctness of deduction and remittance of Hon. Chief Ministers' Distress Relief Fund contribution. We should ensure that the full amount that is offered should be deducted from the salary (or from GPF Loan, E/L Surrender). It is also important to check whether all the deducted amounts are remitted to the proper head.

This tool comes in two platforms viz. MS Excel and LibreOffice Calc.

Record Manager 21-06-2019 Click Here

Record Manager is a Tool Developed by KILA

and Designed by Panchayath Help Desk

This tool helps us to manage various records in our Office , arrange them in Record Room, and Search for a record with certain criteria.

BIMS Receipt Simplifier 15-06-2019 Click Here

BIMS Receipt Simplifier is simple tool to help in printing BIMS Receipt of Cheques and Proceedings. It is very useful for Accountants in Panchayaths in Kerala.

BIMS Bank Pass Book Simplifier 21-05-2019 Click Here

BIMS Bank Pass Book Simplifier is a tool which helps us to modify BIMS Bank Pass Book in a user friendly manner. Bill Information Management System is a good approach to deal with the treasury bank transactions of Panchayaths in Kerala. This tool helps us for printing bank books. It is very helpful for Bank Reconciliation Process.

Saankhya Bank Book Simplifier 20-05-2019 Click Here

Saankhya Bank Book Simplifier is a simple tool to convert Saankhya Bank Book in a user friendly version. It can be easily taken print out. And we can search items using Auto Filter. This tool will be very helpful for the accountants of Panchayats in Kerala.

DA Arrears to Cash Bill Maker 14-05-2019 Click Here

This tool helps us to calculate and Distribute the DA Arrears

of our Office Staff.

Saankhya Sanchaya Data Comparison and Mapping Tools 07-05-2019 Click Here

Saankhya Sanchaya Data Comparison & Mapping Helper Tools are designed to Compare the data of Property Tax Demand and Collection. This will help to Record the Accrual Data. It also helps to find out if there is any difference between the collection details in Saankhya and Sanchaya. And the Final Result is the two Softwares Saankhya and Sanchaya may have identical datas, or we can eliminate the differences.

Saankhya Sanchaya Data Comparison

Saankhya Sanchaya Receiptwise Comparison Helper

Saankhya Sanchaya Receiptwise Mapper

To Download the Instructions Manual Click Here

E-Payment Bank Statement Maker 15-04-2019 Click Here

E-Payment Bank Statement Maker is an easy tool developed by Panchayath Help Desk for the calculation of Property Tax paid On Line. This tool is very helpful for Accountants and Property Tax Section Clerks of Panchayats in Kerala.

Plan Expenditure Verifier 11-042019 Click Here

Plan Expenditure Verifier is a simple tool which is very useful for the Accountants and Plan Clerks of Panchayats in Kerala.

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 with Wardwise and Headwise Report to Register is an easy tool to convert Ledger Reports of any Head powered with Headwise Reports. This process is very useful for section clerks and accountants in Panchyaths of Kerala. Heads like Licence, Profession Tax etc. can easily be converted into Registers

Saankhya Ledger and Headwise Report to Register 08-04-2019 Click Here

Saankhya Ledger and Headwise Report to Register is an easy tool to convert Ledger Reports of any Head powered with Headwise Reports. This process is very useful for section clerks and accountants in Panchyaths of Kerala. Heads like Licence, Profession Tax etc. can easily be converted into Registers

Capital Works in Progress to Assets Calculation Helper 07-04-2019 Click Here

This tool will help us to convert Capital Works in Progress to Various Assets. This will be very helpful for the Accountants in various Panchayats in Kerala. Every Year Panchayats are creating several types of assets viz. Roads, Buildings, ...... But when the bill is prepared, if we are allotting the part bill only, then the expenditure will be recorded as Capital Work in Progress. This should be converted into respective assets on the completion of works. However, we issue the final bills as the Correct asset expenditure. But still the part bill voucher remains as Capital Work in Progress.

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.

Property tax Provision Calculator 05-04-2019 Click Here

Property tax Provision Calculator is a simple tool to Calculate the value of Provision for Doubtful Receivables of Property Tax. It helps to calculate the amount to be written off from the arrears of Property Tax. The Amount for Provision is derived from the Arrears Demand Register exported from Sanchaya Web Site.

Provision Calculator 05-04-2019 Click Here

Provision Calculator is a simple tool to Calculate the value of Provision for Doubtful Receivables. It helps to calculate the amount to be written off from the arrears of Taxes and Fees.

AFS Registers List Maker 04-04-2019 Click Here

AFS Registers List Maker is a simple tool to make a list of registers to be prepared before submitting Annual Financial Statement. This list can be subdivided to each sections.

Saankhya Headwise Report to Register 02-04-2019 Click Here

Saankhya Headwise Report to Register is an easy tool to convert Headwise Reports of any Head into Registers. This process is very useful for section clerks and accountants in Panchyaths of Kerala. Heads like Licence, Profession Tax etc. can easily be converted into Registers. It's very useful to prepare registers and check the correctness when we are busy to prepare AFS

To Go to the Download Page of the tool

Saankhya Headwise Report to Register

Click 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

Saankhya Year Beginning Process Helper is a very good tool for Accountants of Panchayaths in Kerala. It will help to calculate and co-ordinate various Journals in Connectin with Saankhya Year Beginning Process.

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

Budget Preparation Helper (for Panchayaths) is a tool by KILA Designed by Panchayath Help Desk. This tool help Panchayaths in Kerala to Prepare the skeleton on Budget and improve it by revision.

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)

16-02-2019 Click Here

Budget Preparation Helper (for Municipalities) is a tool Co-Developed by KILA & Designed by Panchayath Help Desk. This tool help Municipalities & Corporations in Kerala to Prepare the skeleton on Budget and improve it by revision.

This tool can be downloaded and used for free.

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

Pay Revision Arrears to Cash Bill Maker 25-12-18 Click Here

This tool helps us to calculate and Distribute the Pay Revision Arrears

of our Office Staff.

Saankhya Details to FFC Data Maker 15-12-2018 Click Here

Saankhya Details to FFC Data Maker is a simple tool by Panchayath Help Desk to help the Accountants of Panchayaths in Kerala.

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

Bill Report to Bank List Maker is a simple tool helpful for panchayaths in Kerala.

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

Bank Account List Maker is a tool to help the Distribution of amounts to various persons through Bank Accounts. It helps us to store details of most of our beneficiary accounts and to prepare a list of them whenever a distribution is to be made. Only those persons, that an amount is attached to the data sheet will be displayed on the list to Distribute money. This tool will be very helpful for the Panchayaths in Kerala.

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

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.

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

Contingent Bill Maker 28-07-2018 Click Here

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

Petty works Contingent Bill Maker

each contain

Authorisation,

Note sheet,

Proceedings,

Fully Vouched Contingent Bill

TR 59 C

UnEmployment Allowance Manager 16-07-2018 Click Here

UnEmployment Allowance Manager is a tool developed by Panchayath Help Desk to enable distribution of UnEmployment Allowance.

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

Capital Works Fund Distributor is a tool to calculate the Amount Spend for Development Capital Works in Decentralized Plan of Panchayaths in Kerala. This Calculation is very important in submitting Annual Financial Statements. The calculation uses Ledgers of All Heads that is included in RP-7, RP-40 and RP-47 Schedules of Receipt and Payment Report of Panchayaths. This tool helps us to calculate how much amount is spend for capital works from each funds Dev-Gen, Dev-SCP, MG-NR etc.

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

Residential and Ownership Certificate Maker 15-02-2018 Click Here

This tool help us to prepare Residential and Ownership Certificates and Office Note. Even though some certificates are available online some offices like KSEB insists on hard copy with Office Seal. So this tool will be helpful to All the Panchayaths in Kerala.

Beneficiary List Index Maker 14-01-2018 Click Here

Beneficiary List Index Maker is a tool from www.PanchayathHelpDesk.BlogSpot.Com to Help us in recording and searching Details of individuals who have got benefits from Peoples' Plan through Panchayaths of Kerala.

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

Saankhya Payment Helper is an attempt to CoOrdinate the Saankhya Payment Order details used in various Panchayaths in Kerala. This tool will be very helpful for those who are new in the post of Accountant in Grama Panchayaths.

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

This tool will help us to coordinate the distribution of Salaries and Recoveries of the staff of Panchayaths in Kerala. This includes PEN Number also. The recoveries like GIS, SLI, LIC, KPEPF, GPF, Profession Tax, Festival Advance, Contributory Pension etc. are dealt with in this tool.

TA Bill Preparation Helper for Performance Audit Unit 22-10-2017 Click Here

This tool will help the staff of Performance Audit Units in Panchayath Department of Kerala to prepare quarterly Travelling Allowance Bill with detailed TA Note. This is a simple and light Excel Tool. It works best on Windows 7 (or Latest) and Micro Soft Office 2007 (or Latest). However the tool can be used in other platforms also.

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

This is a tool to Help us in our daily tasks at Front Office. It mainly gives us the sum of many receipts issued to a single person.. It further gives us the amount of balance to be returned. Finally it tallies the denomination for daily collection.

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

Instructions on how to Map Sankhya with Sanchaya 2015-16

It will be very use for the Panchayaths of Kerala for dealing with Property Tax Data.

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

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

My Pages

My Pages

My Pages

My Pages

Pages

Thursday, 16 April 2020

Monday, 6 April 2020

Sunday, 5 April 2020

Saturday, 4 April 2020

List of Useful Softwares & Tools

which can be used for free

Video Tutorials by Panchayath Help Desk

1.Wages Calculation of Daily Contract Vehicle 20-08-2020 Click Here

3. E Bill Vouchers Modifier 10-08-2020 Click Here

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

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 revisionviz.. Validation Report, Tabulation, Resolutions of committee.This tool will be very useful for the Decentralized Plan Section ofPanchayaths 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

10. Bill Register Maker 28-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

Budget Preparation Helper (for Panchayaths) 2020-21 18-03-2020

Receipt and Payment to Minutes Helper 01-12-2019

Saankhya Sanchaya Data Comparison

Saankhya Sanchaya Receiptwise Comparison Helper

Saankhya Sanchaya Receiptwise Mapper

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.