My Posts

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

Friday 25 November 2022

Gap Fund Proforma Simplifier for MC 2022-23

  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.


To Download the Tool Gap Fund Proforma Simplifier for MC 2022-23 Click Here






See Also


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.



Friday 28 October 2022

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.


To Download the Tool Gap Fund Proforma Simplifier for ILGMS Phase 3 GPs 2022-23 Click Here






See Also


Gap Fund Proforma Simplifier for MC 2022-23

  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.




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)



ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker

Thursday 9 June 2022

ILGMS - Depreciation Calculation Helper

 


Depreciation Calculation Helper - Video Tutorial

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

This is very useful for Accountants in Panchayaths in Kerala. 










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.


























List of Balance Sheets Data Required
Sheet (Required Value)                                         Pasted Value
30-09-2011           :  30-September-2011 - 
31-03-2012           :  31-March-2012 - Mattathur Grama Panchayat
30-09-2012           :  30-September-2012 - Mattathur Grama Panchayat
31-03-2013           :  31-March-2013 - Mattathur Grama Panchayat
30-09-2013           :  30-September-2013 - Mattathur Grama Panchayat
31-03-2014           :  31-March-2014 - Mattathur Grama Panchayat
30-09-2014           :  30-September-2014 - Mattathur Grama Panchayat
31-03-2015           :  31-March-2015 - Mattathur Grama Panchayat
30-09-2015           :  30-September-2015 - Mattathur Grama Panchayat
31-03-2016           :  31-March-2016 - Mattathur Grama Panchayat
30-09-2016           :  30-September-2016 - Mattathur Grama Panchayat
31-03-2017           :  31-March-2017 - Mattathur Grama Panchayat
30-09-2017           :  30-September-2017 - Mattathur Grama Panchayat
31-03-2018           :  31-March-2018 - Mattathur Grama Panchayat
30-09-2018           :  30-September-2018 - Mattathur Grama Panchayat
31-03-2019           :  31-March-2019 - Mattathur Grama Panchayat
30-09-2019           :  30-September-2019 - Mattathur Grama Panchayat
31-03-2020           :  31-March-2020 - Mattathur Grama Panchayat
30-09-2020           :  30-September-2020 - Mattathur Grama Panchayat
31-03-2021           :  31-March-2021 - Mattathur Grama Panchayat



To Get Latest Tools Visit Panchayath Help Desk


To Download File  ILGMS - Depreciation Calculation Helper  for Excel 2007 Click Here








See Also



ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker


ILGMS Financial Reports to Excel Convertor

 ILGMS Financial Reports to Excel Convertor helps us to convert ILGMS Financial reports to handy excel formats. These are very useful for comparative studies, presenting before Finance Standing Committee, Preparation of Budget, AFS etc.






To Download ILGMS Financial Reports to Excel Convertor Click Here













See Also


ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker


Monday 30 May 2022

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. 









To Download Property tax Provision Calculator 2021-22 Click Here













See Also

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


ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker



Tuesday 24 May 2022

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.






To Download the Tool Click Here

Ledger Register Comparison Manager



See Also


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


Licence & PT Manager 2021-22

 Licence & PT Manager 2021-22  is a powerful tool to deal with 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. This tool in combination with Staff PT Register Maker will be very Beneficial.

Thursday 19 May 2022

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.





To Download the Tool Click Here

E-Payment Bank Reconciliation Manager 


Wednesday 11 May 2022

Depreciation Calculation Helper 2021-22 for Municipal Accounts

 

Depreciation Calculation Helper - Video Tutorial

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

This is very useful for Accountants in Municipalities and Corporations in Kerala. 










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



























To Get Latest Tools Visit Panchayath Help Desk


To Download File for Excel 2007 Click Here





Tuesday 26 April 2022

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. In ILGMS we should use the correct file type or minor function for a file received to complete the  payment process. Each minor function can generate payments from the concerned heads only. This is so arranged as to avoid future problems of payments done in wrong head. So this tool helps us to find out the correct minor function with correct payment head for each tappal. 




To Download File  ILGMS Payment Heads Ready Reckoner  for Excel 2007 Click Here





Thursday 21 April 2022

AFS Registers List Maker 2021-22

 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.




To Download the Tool Click Here




See Also

AFS Tools 2020-21

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


ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker


Accounting Registers List Maker 2021-22

 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. 





To Download Accounting Registers  List Maker  2020-21 Click Here













See Also

AFS Tools 2020-21

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


ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker


Tuesday 19 April 2022

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

  

Depreciation Calculation Helper - Video Tutorial

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

This is very useful for Accountants in Panchayaths in Kerala. 










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

























List of Balance Sheets Data Required
Sheet (Required Value)                                         Pasted Value
30-09-2011           :  30-September-2011 - 
31-03-2012           :  31-March-2012 - Narikunni Grama Panchayat
30-09-2012           :  30-September-2012 - Narikunni Grama Panchayat
31-03-2013           :  31-March-2013 - Narikunni Grama Panchayat
30-09-2013           :  30-September-2013 - Narikunni Grama Panchayat
31-03-2014           :  31-March-2014 - Narikunni Grama Panchayat
30-09-2014           :  30-September-2014 - Narikunni Grama Panchayat
31-03-2015           :  31-March-2015 - Narikunni Grama Panchayat
30-09-2015           :  30-September-2015 - Narikunni Grama Panchayat
31-03-2016           :  31-March-2016 - Narikunni Grama Panchayat
30-09-2016           :  30-September-2016 - Narikunni Grama Panchayat
31-03-2017           :  31-March-2017 - Narikunni Grama Panchayat
30-09-2017           :  30-September-2017 - Narikunni Grama Panchayat
31-03-2018           :  31-March-2018 - Narikunni Grama Panchayat
30-09-2018           :  30-September-2018 - Narikunni Grama Panchayat
31-03-2019           :  31-March-2019 - Narikunni Grama Panchayat
30-09-2019           :  30-September-2019 - Narikunni Grama Panchayat
31-03-2020           :  31-March-2020 - Narikunni Grama Panchayat
30-09-2020           :  30-September-2020 - Narikunni Grama Panchayat
31-03-2021           :  31-March-2021 - Narikunni Grama Panchayat
30-09-2021           :  30-September-2021 - Narikunni Grama Panchayat
31-03-2022           :  31-March-2022 - Narikunni Grama Panchayat




To Get Latest Tools Visit Panchayath Help Desk


To Download File for Excel 2007 Click Here








See Also

AFS Tools 2020-21

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


ACCOUNTS TOOLS


There are many tools and notes to help the accountants in Panchayaths of Kerala. These tool will be very useful for Accountants and other Section Clerks of Panchayaths and Municipalities of Kerala.

There are various tool to help accounting process viz..

 Accounting Registers List Maker, Property tax Provision Calculator, AFS Tools,  Depreciation Calculation Helper,  Saankhya Year Beginning Process Helper, Budget Preparation Helper, DCB Statement Maker, E Bill Vouchers Modifier, DPC Own Fund Statement Maker, Arrears on Ratio Promotion to Cash Bill Maker, Financial Key Ratios Analysis Helper, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281),  Joint Venture Funds Verifier, E-Payment Bank Reconciliation Helper, BIMS Receipt Simplifier, BIMS Bank Pass Book Simplifier, Saankhya Sanchaya Data Comparison and Mapping Tools, Saankhya Bank Book Simplifier, Capital Works in Progress to Assets Calculation Helper, Accounts Verification Helper and Bill Register Maker



Tuesday 15 March 2022

Budget Tools 2022-23 for Municipalities

 


Budget Preparation Helper 2022-23

 (for Municipalities)


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.




Project to Budget Mapping Helper 2021-22 Revision  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.



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.




To Download the Tool 

State Budget Allocation Simplifier

 Click Here



Monday 31 January 2022

Budget Tools for Saankhya Panchayaths 2022-23

  

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) 2022-23
Budget Sheet Data from Saankhya Reports 2021-22 (ForPanchayaths)
Budget Sheet Data from Saankhya Reports 2021-22 (without BS4 and BS7) for Panchayaths
Project to Budget Mapping Helper for Revision 2021-22 For Saankhya Panchayaths
Letter to Allied Institutions for Budget Prepartion




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





Budget - Helping Note

Budget- Helping Note

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

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

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



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






Budget Preparation Helper (for Panchayaths) 2022-23

 


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

This tool can be downloaded and used for free.

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






Budget Sheet Data from Saankhya Reports 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.



Project to Budget Mapping Helper for Revision 2021-22 For Saankhya 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 Preparation to Budget Mapping Helper for Saankhya Panchayaths 2022-23




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.



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.