Travelling Allowance Bill Maker (TA Helper)

 

TA Bill Preparation Helper for Staff helps us to prepare Travelling Allowance Bills of Government Staff of Kerala. This tool will be very helpful to the staff of Panchayaths and Municipalities of Kerala. 

To Go to the  Main Page of the  Tool  

 Travelling Allowance Bill Maker (TA Helper)

 CLICK HERE

DPC Own Fund Statement from KSmart 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 and Municipalites. This tool will be very helpful for the Plan Clerks, Establishment Clerks and Accountants of panchayaths and municipalities in Kerala. Here we need Balance Sheet Summary and Budget Form 1 from KSmart and  some figures from Project Expenditure Only to prepare the Own Fund Statement

To Go to the  Main Page of the  Tool  

 

DPC Own Fund Statement from KSmart Balance Sheet and Budget Data

 CLICK HERE

Project Revision Manager (with Spill Over Inclusion) with G.O.Validation 2026-27

 

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 Go to the  Main Page of the  Tool  

Project Revision Manager (with Spill Over Inclusion) with G.O.Validation 2026-27

 CLICK HERE

Tools and Notes Arranged Subject Wise

ACCOUNTS TOOLS

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.

Election TOOLS

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

ESTABLISHMENT TOOLS

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 Tools

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

ISO TOOLS

 Citizen Survey Results Maker, Record Manager etc. 

IT @ Panchayath

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

LICENCE & TAX Tools

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 TOOLS

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

PLAN TOOLS

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.

Tools for National Savings Scheme

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.

ILGMS Heads to KSmart Convertor with Verification Helper

 

 Calculating depreciation is a highly complex aspect of submitting annual financial statements for local self-government institutions. To avoid this complexity, some attempt to finalize the figures using data from only the previous year. However, in accordance with Government Order No. G.O.(Ms) 212/2012/LSGD dated 06-08-2012, depreciation must be calculated based on an examination of records spanning up to 50 years.

We only have access to data from the 'Local Sankhya' software dating back to 2011. Errors may occur when migrating reports from Sankhya and ILGMS into K-Smart; therefore, it is necessary to verify the accuracy of the reports obtained after conversion.

For this purpose, Block and District Panchayats must export the balance sheets from Sankhya and K-SMART as of 31-03-2025 to Excel, while Urban Local Bodies must do so as of 31-03-2024. If these reports are pasted into the 'Saankhya Heads to KSmart Converter with Verification Helper' tool, a detailed report is generated. This report categorizes items into: those successfully converted with a match, those converted but without a match, heads that were not mapped for conversion, and heads visible in KSmart that were not converted from Saankhya. The mapping in the tool's mapper sheet must be adjusted to reflect the discrepancy between the closing balance in Sankhya and the opening balance in K-SMART for each local self-government institution.

To Go to the  Main Page of the  Tool  

ILGMS Heads to KSmart Convertor with Verification Helper

 CLICK HERE

Saankhya Heads to KSmart Convertor with Verification Helper

  

Calculating depreciation is a highly complex aspect of submitting annual financial statements for local self-government institutions. To avoid this complexity, some attempt to finalize the figures using data from only the previous year. However, in accordance with Government Order No. G.O.(Ms) 212/2012/LSGD dated 06-08-2012, depreciation must be calculated based on an examination of records spanning up to 50 years.

We only have access to data from the 'Local Sankhya' software dating back to 2011. Errors may occur when migrating reports from Sankhya and ILGMS into K-Smart; therefore, it is necessary to verify the accuracy of the reports obtained after conversion.

To Go to the  Main Page of the  Tool  

Saankhya Heads to KSmart Convertor with Verification Helper

 CLICK HERE

Urban Saankhya Heads to KSmart Convertor with Verification Helper

 

Urban Saankhya Heads to KSmart Convertor with Verification Helper

 Calculating depreciation is a highly complex aspect of submitting annual financial statements for local self-government institutions. To avoid this complexity, some attempt to finalize the figures using data from only the previous year. However, in accordance with Government Order No. G.O.(Ms) 212/2012/LSGD dated 06-08-2012, depreciation must be calculated based on an examination of records spanning up to 50 years.

We only have access to data from the 'Local Sankhya' software dating back to 2011. Errors may occur when migrating reports from Sankhya and ILGMS into K-Smart; therefore, it is necessary to verify the accuracy of the reports obtained after conversion.

To Go to the  Main Page of the  Tool  

Urban Saankhya Heads to KSmart Convertor with Verification Helper

 CLICK HERE

3504101 Advance Collection of Revenues Sorting Helper

 

The 'Advance' head in KSmart comprises various types of advances. Therefore, examining the ledger for this head alone makes it difficult to identify which specific advance a particular receipt relates to; this can only be understood by also reviewing the sub-ledger for this head. If you provide the ledger for the 'Advance Collection' head, along with the bank books and cash book, this tool will list and categorize the receipts from the advance head into various other heads, such as licenses and property tax.

To Go to the  Main Page of the  Tool  

3504101 Advance Collection of Revenues Sorting Helper

 CLICK HERE