My Posts

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

Wednesday, 26 December 2018

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.

To Download the Tool 

CLICK HERE

See Also

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.

Tuesday, 18 December 2018

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.

To Download the Helping Note

CLICK HERE

Wednesday, 12 December 2018

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.


To Download the Tool for Excel 2007


CLICK HERE







x



Sunday, 18 November 2018

Tools and Notes Arranged Subject Wise



Advance Register Manager, AFS Registers List Maker, Bank Book Reconciliation Helper, Bill Register Maker, BIMS Receipt Simplifier and Payment Message Creater,  Budget Models, Budget Preparation Helper, Budget Tools, Contingent Bills,  Deposit Register Manager, Depreciation Calculation Helper, DPC Own Fund Statement, Gap Fund Proforma Simplifier, ILGMS Heads to Saankhya Convertor, ILGMS Ledger Verification Helper, Project to Budget Mapping Helper, Saankhya Bank Book Ledger Simplifier   etc.


Delimitation Forms Maker, Election Annexures Maker, Election Nomination Process Simplifier, ELECTION Process Simplifier, Token Generator



Arrears on Ratio Promotion to Cash Bill Maker, CMDRF Recovery and Remittance Reconciliation Helper, Contingent Bill Maker, DA Arrears to NPS and PF with Cash Bill Maker, Deferred Salary Refund Helper, Honorarium & Allowances of Elected Representatives, Keralotsavam Manager, MPKBY Card Issue Manager, Pay Fixation Proceedings Maker, Pay DA Arrears to NPS and PF with Cash Bill Maker,  Pay Fixation Proceedings Maker (for Promotion), PF Tools, TA Bill for PAU, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281), Wages Calculation of Daily Contract Vehicle etc.



ILGMS Financial Reports to Excel Convertor, ILGMS Local Settings format, ILGMS Payment Heads Ready Reckoner



 Citizen Survey Results Maker, Record Manager etc. 


ILGMS Local Settings format, ILGMS Payment Heads Ready Reckoner, Malayalam Inscript KeyBoard Installer, Malayalam Key Board Lay Out etc.



Accounting Registers List Maker, Collection Pending Report Maker for Panchayahs, DCB Statement Maker, Dogs Pigs Licence Helper,  E-Payment Bank Statement Maker, Licence & PT Manager , Profession Tax and Room Rent Arrears and PI Calculator, Report from Clerks to Finance Standing Committee on Tax Exemption, Report on Tax Remissions for Finance Standing Committee Minutes, Residential and Ownership Certificate Maker, Saankhya Sanchaya Data Comparison, Staff PT Register Maker etc.



Pension Home Mustering Filter Helper, Pension Not Mustered List Maker, UnEmployment Allowance Manager etc.



Budget Preparation Helper, Budget Tools, Calculations for Road Details, CFC Fund Utilization Calculator, DPC Own Fund Statement , Dummy Editor for Beneficiary Lists , E Bill Vouchers Modifier, EMS Loan Interest Calculator, Formats and Tools for Sixth State Finance Commission Proposals, Formulation Planner, Gap Fund Proforma Simplifier, Individual Beneficiary List Sorting Helper, Joint Venture Funds Verifier, Keralotsavam  Manager,  Plan Fund Manager, Project Helper, Project Manager,  Project Preparation Helper, Project Preparation to Budget Mapping Helper, Project Revision Manager, Project Revision Verifier, Project Sector Mapper, Queue Bill Manager, Status Report Maker, Sulekha Micro Sector Codes Filter with CFC Tied Heads, TDS IT CHALAN for Salary Remittance or Work Bill Deduction (ITNS 281), Wages Calculation of Daily Contract Vehicle 

Plan Guidelines, Plan Subsidy Guidelines,  Shelf of Projects, Sulekha Micro Sector Codes Filter etc.




NSD AWS APS Posting HelperNSD AWS APS Posting Helper, NSD Report Manager, NSS MPKBY Claim Form Maker FOR First Month, NSS MPKBY Claim Form Manager etc.




Wednesday, 14 November 2018

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.

They can export the Saankhya Bank Book Report to Excel (Data Only)

and Paste the data to this tool.

To Get the File

Tool for Excel 2007 Click Here

Tool for Excel 2003 Click Here

Monday, 12 November 2018

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.

To Download the Tool CLICK HERE




See Also


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.



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.

Monday, 10 September 2018

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.

To Download the Tool CLICK HERE





Tuesday, 26 June 2018

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


To Download the File Click Here




































See Also



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.





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

Property tax Provision Calculator

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

Provision Calculator

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.



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

Friday, 22 June 2018

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.



To Download the Tool Click Here


See Also


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.


Property tax Provision Calculator

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

Provision Calculator

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.





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




Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers.

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.

To Download the File 

Click Here


See Also


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.


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

Provision Calculator

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.





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




Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers.

Thursday, 21 June 2018

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.

This tool is very helpful in some other aspects also. There are some heads like Festival Advance, EMD, Pension Contribution etc. These heads contains Receipts as well as Payments. So here we have to calculate the amount we collected and should return or the amount which we distributed and should be demanded. To calculate the default amount we can use the Include Option in the Register.


Downloads



To Download the Tool Saankhya Ledger to Register Maker    Click Here

To Download an Example
     320800101 beneficiary contributions  Click Here

To Download another Example
      460500501 advance to implementing officers Click Here



See Also


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.


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.


Property tax Provision Calculator

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

Provision Calculator

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.





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




Wednesday, 20 June 2018

Property tax Provision Calculator

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 the File Click Here


See Also



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.


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.




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



Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers.

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.

To Download the File Click Here



See Also


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.


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.


Property tax Provision Calculator

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


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


Saankhya Ledger to Register Maker


Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers.

Wednesday, 18 April 2018

Depreciation Calculation Helper




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

To Get Latest Tools Visit Panchayath Help Desk


To Download File for Excel 2007 Click Here

To Download File for Excel 2003 Click Here




See Also



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


Provision Calculator

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.

Saankhya Ledger to Register Maker is an easy tool to convert Complicated Ledgers in Saankhya to Simpler Registers.



See Also

Bank Account List Maker


Thursday, 12 April 2018

Bill Register Maker













See New Update


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 for Excel 2007 Click Here