My Posts

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

Monday, 27 December 2021

Gap Fund Proforma Simplifier 2021-22

 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 2021-22 Click Here






See Also


Gap Fund Proforma Simplifier 2021-22 (for ILGMS Phase 1 GPs)

 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

Monday, 25 October 2021

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 .




To Download the Tool 

Grant Statement Maker

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


Sunday, 3 October 2021

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

















To Download the Tool 

Advance Register from Saankhya Ledger with Headwise Report 

Click Here




See Also


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





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, 30 September 2021

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. 



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






Monday, 9 August 2021

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

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


Sunday, 18 July 2021

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












To Download the Tool 

 Deposit Register from Saankhya Ledger with Headwise Report 

Click Here




See Also


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







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, 22 June 2021

Depreciation Calculation Helper 2020-21 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





Saturday, 29 May 2021

Bill Register Maker 2021-22

 













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


To Download File Bill Register Maker 2021-22  Click Here






To Download File     Fully Worked out Sample   Bill Register Maker 2020-21  Click Here









To Download         Sample  Bill Register  Mattathur GP 2020-21 PDF File  Click Here

Sample





























































To Download File Bill Register Maker 2021-22  Click Here





To Download File     Fully Worked out Sample   Bill Register Maker 2020-21  Click Here









To Download         Sample  Bill Register  Mattathur GP 2020-21 PDF File  Click Here

Sample









To Download          Bill Register Maker Mattathur GP 2019-20 PDF File  Click Here

Sample










See Also

Monday, 17 May 2021

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.









To Download Saankhya Bank Book Simplifier (Modified) Click Here









Sunday, 9 May 2021

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. 





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



Monday, 26 April 2021

Property tax Provision Calculator 2020-21

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



Sunday, 18 April 2021

Depreciation Calculation Helper 2020-21 (FOR Panchayath 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 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 - 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 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



Wednesday, 14 April 2021

AFS Registers List Maker 2020-21

 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



Sunday, 4 April 2021

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.







To Download the Tool Click Here