My Posts

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

Monday, 30 May 2022

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


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.





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





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.



 Licence & PT Manager 







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)


Staff PT Register Maker

Staff PT Register Maker is an easy tool to make the register of Profession Tax Demand and Remitted at Grama Panchayaths of Kerala.




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.






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. 



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






Depreciation Calculation Helper 2021-22 for Municial Accounts


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






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.


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. 





  AFS Registers List Maker 

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.


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. 







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



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



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.



 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.




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





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.



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





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.







 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.





*************************************************************




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





Each tool will be updated under this post Periodically........

Thursday, 10 March 2022

Project to Budget Mapping Helper for Municipalities 2021-22 - Revision

 



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.


To get the Tool
Project to Budget Mapping Helper
CLICK HERE


































This tool will tell you whether the funds mapped from Project Data to Budget Data is correct or not.



Monday, 7 March 2022

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.



TO DOWNLOAD THE Formats  CLICK HERE







See Also



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

Thursday, 10 February 2022

Project Preparation Helper 2022-23 (for Panchayaths)

 















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 tools

See our new tool

Project Preparation Helper NEW 2022-23 (for Panchayaths)

 



Pls inform us on any corrections or upgradation
through 9446 407 279

TO DOWNLOAD THE TOOL Project Preparation Helper   CLICK HERE


Tuesday, 1 February 2022

Project Preparation to Budget Mapping Helper for Saankhya Panchayaths 2022-23

  




Project Preparation to Budget Mapping Helper for Saankhya Panchayaths 2022-23 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.


To Download the  Tool
Project Preparation to Budget Mapping Helper for Saankhya Panchayaths 2022-23
CLICK HERE





See Also


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.




Project to Budget Mapping Helper for Revision 2021-22 For Saankhya Panchayaths

 



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


Please use the Latest Tool

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.




To get the Tool
Project to Budget Mapping Helper for Revision 2021-22 For Saankhya Panchayaths
CLICK HERE










































This tool will tell you whether the funds mapped from Project Data to Budget Data is correct or not.






















See Also


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.



Sunday, 30 January 2022

Project Revision Manager (After Spill Over Inclusion) with G.O.Validation 2021-22

 It is a tool to help us in the revision process of our projects. This tool is to be used after first revision in a financial year. In first revision we have included spill over projects for Current year budget and vice versa. After this process this tool is very useful for revision calculation processes.



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.

to Download the Tool 
Project Revision Manager (After Spill Over Inclusion) with G.O.Validation 2021-22
   Click Here 




Project Revision Manager



To   calculate the amount utilized for the various sectors like OldAge, Child, Differently Abled, Women, Sanitation, Housing etc. in Decentralized Planning Process of Panchayaths. 
Click Here to go the Donload Page of  Project Sector Mapper


See Detailed Note on Project Revision by Deepu & Manoj
Click Here to Download the FAQ

Click Here to Download the Appendix of FAQ


To See List of  Micro Sector Codes Suitable for CFC Tide Fund Click Here




Download






Project Revision Verifier

 This tool helps us to compare the proposed data for Revision of Projects with the Actual Data after Data Entry in  Sulekha.
 
 




See Detailed Note on Project Revision by Deepu & Manoj
Click Here to Download the FAQ

Click Here to Download the Appendix of FAQ


To See List of  Micro Sector Codes Suitable for CFC Tide Fund Click Here