My Posts

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

ACCOUNTS TOOLS













There are many tools and notes to help the accountants in Panchayaths of Kerala. They are listed below





Depreciation Calculation Helper 2023-24 for GP (Saankhya & ILGMS Period)

 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. This tool contains two counter parts. One for Saankhya Periiod and another for ILGMS Period. You should calculate both period to get the correct calculation for Depreciation.








Depreciation Calculation Helper 2023-24 (FOR Panchayath Accounts) (Saankhya) (Block & District Panchayaths)

 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 Tools for Panchayaths 2024-25

Budget Tools for Saankhya Panchayaths 2024-25 contains various tools for the easy, correct and transparent preparation of Budget. These tools help Panchayaths in Kerala to Prepare the skeleton on Budget and improve it by revision.

These tools can be downloaded and used for free.

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

Main Contents
 Budget - Helping Note
Budget Models
Budget Preparation Helper (for Panchayaths) 2024-25
Budget Sheet Data Maker for Panchayaths 2024-25
ILGMS Heads to Saankhya Convertor
Project to Budget Mapping Helper  For Panchayaths 2024-25
Project Preparation to Budget Mapping Helper for Panchayaths 2024-25
Letter to Allied Institutions for Budget Prepartion





Gap Fund Proforma Simplifier 2023-24 (for ILGMS GP )

 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.





Gap Fund Proforma Simplifier for MC 2023-24

  This tool helps us to calculate the Probable gap fund that may be allotted to the Municipalities.. 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 Municipalities in Kerala.







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





Budget Sheet Data Maker for Panchayaths

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


ILGMS Heads to Saankhya Convertor

 This tool help us to convert ILGMS Heads to Saankhya Heads. We can copy paste financial reports like Balance Sheet and Income and Expenditure to this tool. It will convert the reports to Saankhya Heads.


Project to Budget Mapping Helper  2024-25 For Panchayaths

 Project to Budget Mapping Helper for Revision 2022-23 For  Panchayaths 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 to Budget Mapping Helper  2024-25 For Municipalities

 Project to Budget Mapping Helper for Revision 2023-24 For  Panchayaths 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 2024-25

 Project Preparation to Budget Mapping Helper for Panchayaths 2024-25  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 Municipalities 2024-25

 Project Preparation to Budget Mapping Helper For Municipalities 2024-25  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.




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


Budget Preparation Helper (for Panchayaths) 2024-25

 

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.



Budget Preparation Helper for Municipalities 2024-25

 

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.







ILGMS Ledger Verification Helper

  This tool helps us to verify Various Ledgers in ILGMS. Ledger Report pasted in to this tool will be matched by comparing debit and credit entries. Thus the unmatched entries will be filtered off. They can be corrected using appropriate journals.  This tool will be very helpful for the Accountants of Grama Panchaayaths in Kerala.

ILGMS Ledger Matching Helper

 This tool helps us to verify and Match entries in  Various Ledgers in ILGMS. Ledger Report pasted in to this tool will be matched by comparing debit and credit entries. Thus the unmatched entries will be filtered off. They can be corrected using appropriate Vouchers.  This tool will be very helpful for the Accountants of Grama Panchaayaths in Kerala.



Advance Register Manager

  Advance Register ManagerTool helps us to prepare detailed Advance Register  from Saankhya and ILGMS Ledger Reports. This tool will be very helpful for the Accountants of Panchayats and Municipalities






Deposit Register Manager

 \Deposit Register Manager Tool helps us to prepare detailed deposit register from Saankhya and ILGMS Ledger Reports. This tool will be very helpful for the Accountants of Panchayats and Municipalities





ILGMS Ledger Simplifier

  ILGMS Ledger Simplifier Tool helps us to modify ILGMS Ledger Reports in a simplified manner. 





Saankhya Bank Book Ledger Simplifier

 Saankhya Bank Book Ledger Simplifier Tool helps us to modify Saankhya Ledger Reports in a simplified manner. For this purpose we make use of Saankhya Bank Book Report of concerned heads. 



Depreciation Calculation Helper 2022-23 for Municipal Accounts (Saankhya)

Depreciation Calculation Helper is a tool which helps accountants in Municipalities 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 2022-23 (FOR Panchayath Accounts) (Saankhya) (Block & District Panchayaths)

 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 tool is made for the use of Block Panchayaths and District Panchayaths only

  

AFS Registers List Maker 2022-23

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.




Budget Schedule BS13 Data Picker for Panchayaths

Budget Schedule BS13 Data Picker for Panchayaths  is an attempt to Collect Budget Shedule 13 Data for Budget Preparation from Saankhya  & ILGMS Reports. 









Budget Tools for Panchayaths 2023-24

 Budget Tools for Saankhya Panchayaths 2022-23 contains various tools for the easy, correct and transparent preparation of Budget. These tools help Panchayaths in Kerala to Prepare the skeleton on Budget and improve it by revision.

These tools can be downloaded and used for free.

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

Main Contents

 Budget - Helping Note
Budget Preparation Helper (for Panchayaths) 2023-24
Budget Sheet Data from Saankhya Reports 2022-23 (ForPanchayaths)
Budget Sheet Data from Saankhya Reports 2022-23 (without BS4 and BS7) for Panchayaths
Project to Budget Mapping Helper for Revision 2022-23 
Letter to Allied Institutions for Budget Prepartion



Budget Tools for Municipalities 2023-24

Budget Tools for Municipalities contains various tools for the easy, correct and transparent preparation of Budget. These tools help Municipalities and Corporations in Kerala to Prepare the skeleton on Budget and improve it by revision.








Budget Preparation Helper (for Panchayaths) 2023-24




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.




Budget Preparation Helper for Municipalities 2023-24


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.




Letter to Allied Institutions for Budget Prepartion 2023-24

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.



Project to Budget Mapping Helper for Revision 2022-23 For Panchayaths




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 to Budget Mapping Helper for Revision 2022-23 For Municipalities




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 Preparation to Budget Mapping Helper for Panchayaths 2023-24

  




Project Preparation to Budget Mapping Helper for Panchayaths 2023-24  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 Municipalities 2023-24

   



Project Preparation to Budget Mapping Helper For Municipalities 2023-24  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.



Budget Models

 It well be a great help for new accountants if they get a fully fledged model of Budget.  This is on a give and take policy.   All of you please contribute.  Please give your Budget Models, Budget Speech soft copy etc.










Gap Fund Proforma Simplifier for ILGMS Phase 3 GPs 2022-23

 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.


Gap Fund Proforma Simplifier 2022-23 (for ILGMS Phase 1 GPs)

 Will be Updated Later

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. This tool is very helpful for ILGMS Phase 1 GPs ie. Grama Panchayats which migrated to ILGMS Software during the period 2020-21. (Most probably 2020 September)


AFS Tools 2021-22 (Saankhya)

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

They may be shortlisted as 

Financial Key Ratios Analysis Helper, Ledger Register Comparison Manager, Licence & PT Manager , Staff PT Register Maker, Accounts Verification Helper, Property tax Provision Calculator, Depreciation Calculation Helper, E-Payment Bank Reconciliation Manager, Bank Reconciliation Helper,  AFS Registers List Maker, Accounting Registers List Maker, Grant Statement Maker, Advance Register from Saankhya Ledger with Headwise Report, Deposit Register from Saankhya Ledger with Headwise Report, Saankhya Bank Book Simplifier (Modified), Saankhya Year Beginning Process Helper, DCB Statement Maker, E Bill Vouchers Modifier, Bill Register Maker, Joint Venture Funds Verifier, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Ledger with Wardwise and Headwise Report to Register, Capital Works in Progress to Assets Calculation Helper, Capital Works Fund Distributor 



Property tax Provision Calculator 2021-22

 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. 







Ledger Register Comparison Manager

 Ledger Register Comparison Manager helps us to compare receipt details in Saankhya and Licene & PT Manager or other register making tools. It will be a great help to prepare registers in connection wth Annual Finance Statement.  It also helps us to prepare necessary register for Audit purpose.  This tool compares the key fields of accounting viz. Date, Voucher Number and Amount of Receipt. It gives us the List of Matching Receipts, Discrepancy  Report and List of UnMapped Receipts. It provides an easy way to synchronize both data.





E-Payment Bank Reconciliation Manager

E-Payment Bank Reconciliation Manager  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.  This tools maps various reports on web payment viz. ePayment Receipts Headvise Report, Receipt Report, IKM PG - Transaction Details IKM PG - Disbursement Details etc. It provides an easy way to find out the bank realization of each transaction.




ILGMS Payment Heads Ready Reckoner

 

ILGMS Payment Heads Ready Reckoner is an easy tool which helps us to find out the minor functions in which a desired payment head can be used.  This will be very  helpful for the accountants of Panchayaths in Kerala where they use Integrated Local Governance Management System for their administrative actions. 



Accounting Registers List Maker

This tool is used to find out the total amount of each heads of accounts in Saankhya. This tool uses Balance Sheet, Income and Expenditure & Receipt and Payment Schedules from Saankhya. This helps Accountants and sections clerks to make registers of each head. This tool is used in combination with Saankhya Ledger with Wardwise and Headwise Report to Register which is used to make registers of      each head using saankhya ledger and other reports. This tool will be very helpful for the accountants and section clerks of Panchayaths and Municipalities in Kerala. 






Depreciation Calculation Helper 2021-22 (FOR Panchayath Accounts) (Saankhya)


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 Tools 2022-23

 


Budget Tools 2022-23    contains various tools for the easy, correct and transparent preparation of Budget. These tools help Panchayaths and Municipalities in Kerala to Prepare the skeleton on Budget and improve it by revision.




NavaJalakam a Guide to Panchayaths by Kollam DDP

 A guide to day to day Panchayath Affairs prepared by Kollam Panchayath Deputy Directorate Office. It includes details in connection with all sections like Establishment, Decentralized Plan, Mahathma Gandhi National Rural Employment Guarantee Scheme, Kudumbasree, Building Permit, Licence, Social Security Pensions, Right to Information, Right to Service, Audit, Accounts... It will be very helpful for the staff of Panchayaths in Kerala.


State Budget Allocation Simplifier

 

 This tool will be very helpful to the Accountants, Plan Clerks, Secretaries and other Officials and Peoples Representatives who are deeply interested in Planning and Budget Allocation.




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

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.

Budget Sheet Data from Saankhya Reports 2021-22 (without BS4 and BS7) for Panchayaths

 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.






Bank Reconciliation Helper

 Bank Reconciliation Helper  is a tool which helps Accountants in Panchayaths and Municipalities to prepare reconciliation of data from Bank and entries made in Saankhya Software.  This tool helps us to coordinate the data from Bank and Saankhya. 












Grant Statement Maker

 Grant Statement Maker helps us to formulate the Grant Statement in an easy way.   Grant Statement is required to be submitted with Annual Financial Statement for each year. It can be easily formulated from Saankhya Reports. We need to copy Balance Sheets, Receipt and Payment and Income and Expenditure Schedules to this tool to get the data for  Grant Statement .



Advance Register from Saankhya Ledger with Headwise Report

Advance Register from Saankhya Ledger with Headwise Report 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 Festival Advance, Advance to Others, Advance to Implementing Officers etc. can easily be converted into Registers



Report on Tax Remissions for Finance Standing Committee Minutes

 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.




Deposit Register from Saankhya Ledger with Headwise Report

Deposit Register from Saankhya Ledger with Headwise Report 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 EMD, Security Deposit etc. can easily be converted into Registers




ILGMS - Depreciation Calculation Helper


ILGMS 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. This will be helpful for panchayaths using ILGMS software.



 Bill Register Maker

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.
It Also provides an easy way for Reconciliation the Treasury and Bank Accounts



Saankhya Bank Book Simplifier (Modified)

 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.       We can copy payment voucher details to Bill Register Maker Tools. The tool includes a Vouchers List. It can be used for the reconciliation process. This will be very helpful if prior period vouchers are found not realized in Banks after a long period.  This tool will be very helpful for the accountants of Panchayats in Kerala.












AFS Tools 2020-21

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




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. 







ILGMS Bank Reconciliation Helper

 ILGMS Bank Reconciliation Helper is an easy tool to complete the reconciliation of Bank Transactions recorded in ILGMS.

Entries in Bank Book should be tallied with entries in bank statement. This tools helps us to make them tally. This will be very helpful for panchayaths using ILGMS.

Integrated Local Governance Management System is a new invention in Office Procedures of Local Self Government Institutions in Kerala. The software is joint venture of Global Master Team consisting of representatives of Panchayath Employees and Development Team from Information Kerala Mission.


 Saankhya Year Beginning Process Helper


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.


During the Year Beginning Process We Should convert current receivables values to arrears, advances to current and main thing is to create the Accruals which are the essentials for an Accrual Based Double Entry Accounting System such as Saankhya.
hope, this tool will be very easy to use. and any difficulties or suggestions for advancement are invited.









DCB Statement Maker

 This tool helps us to formulate the Demand Collection Balance Statement for the Given Period. The DCB Statement is often asked to submit before Audit team or Higher Authorities. This tool uses Reports from Saankhya such as Balance Sheet and Income & Expenditure Statement. This will be very helpful for the Panchayats in Kerala.



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.





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.







Bill Details to Bank List Maker


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.





Arrears on Ratio Promotion to Cash Bill Maker

This tool will help us to distribute the Arrears on Ratio Promotion.. It will give the schedule, list and  Cash Bill for the purpose. It will be very useful to all the Panchayaths in Kerala.



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.



EMS Loan Interest Calculator

EMS Loan Interest Calculator allows you to calculate the interest and loan amount pending with respect to EMS Housing Scheme.





Financial Key Ratios Analysis Helper is a tool to evaluate the ratios of important heads of account used in Panchayaths in Kerala.



TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281)

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.



CFC Fund Utilization Calculator

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


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.




Joint Venture Funds Verifier

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.




Report from Clerks to Finance Standing Committee on Tax Exemption

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.




E-Payment Bank Reconciliation Helper




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.



BIMS Receipt Simplifier

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

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 Sanchaya Data Comparison and Mapping Tools

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 Bank Book Simplifier

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.



E-Payment Bank Statement Maker

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

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

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 


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

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.









Saankhya Headwise Report to Register

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


 


Accounts Verification Helper

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


This should be studied and kept for reference.

To Go to the Download Page of the Helping Note CLICK HERE


Saankhya Sahayi - Helping Note

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

This should be studied and kept for reference.


 










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.








Receipt and Payment to Minutes Helper


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.





Proceedings with Treasury Cheques

A useful mode of Proceedings with Treasury  Cheques





Important Formats for Panchayaths

There are many useful formats tobe used in Panchayats of Kerala.
They are
(1) Formats for Applications
(2) Formats for Certificates
(3) Formats for Reports. Like Own Fund Statement for DPC 
(4) Formats for Agreements
 (5) Formats for Plan Like Project Data Entry Form  Miniature





Saankhya Details to FFC Data Maker  

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 Account List Maker

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.



 Saankhya Payment Helper 

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





Bank Book for Reconciliation Helper

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.


 Bill Report to Bank List Maker


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.





Contingent Bill Maker 


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




Saankhya Ledger to Register Maker 

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.








 Capital Works Fund Distributor 


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.



Provision Calculator 

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.





Panchayath Day Celebration 2019 - Accounts Manager


This tool is created for recording and handling the Financial Transactions in connection with Panchayath Day Celebration - 2019 Held at Thrissur

No comments:

Post a Comment