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.

A tool for migrating ILGMS data from Grama Panchayats to K-Smart and performing verification—the "ILGMS Heads to KSmart Convertor with Verification Helper"—is also available on the blog.

These tools can be downloaded for free from the Panchayat Help Desk blog. Please feel free to share any queries or suggestions regarding the tools.

9446407279

Manoj Mukundan

To Download

ILGMS Heads to KSmart Convertor with Verification Helper 

CLICK HERE

See Also

Urban Saankhya Heads to KSmart Convertor with Verification Helper

Saankhya Heads to KSmart Convertor with Verification Helper

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.

Depreciation Calculation Helper 2025-26 for KSmart

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

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.

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.

A tool for migrating ILGMS data from Grama Panchayats to K-Smart and performing verification—the "ILGMS Heads to KSmart Convertor with Verification Helper"—is also available on the blog.

These tools can be downloaded for free from the Panchayat Help Desk blog. Please feel free to share any queries or suggestions regarding the tools.

9446407279

Manoj Mukundan

To Download

Saankhya Heads to KSmart Convertor with Verification Helper 

CLICK HERE

See Also

Urban Saankhya Heads to KSmart Convertor with Verification Helper

Saankhya Heads to KSmart Convertor with Verification Helper

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.

Depreciation Calculation Helper 2025-26 for KSmart

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

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.

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.

A tool for migrating ILGMS data from Grama Panchayats to K-Smart and performing verification—the "ILGMS Heads to KSmart Convertor with Verification Helper"—is also available on the blog.

These tools can be downloaded for free from the Panchayat Help Desk blog. Please feel free to share any queries or suggestions regarding the tools.

9446407279

Manoj Mukundan

To Download

Urban Saankhya Heads to KSmart Convertor with Verification Helper 

CLICK HERE

See Also

Urban Saankhya Heads to KSmart Convertor with Verification Helper

Saankhya Heads to KSmart Convertor with Verification Helper

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.

Depreciation Calculation Helper 2025-26 for KSmart

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

Cash Book to Bank Book Format Converter

 This tool will convert Cash Book in KSmart to Bank Book Format 

To Download

Cash Book to Bank Book Format Converter

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 Download

3504101 Advance Collection of Revenues Sorting Helper

CLICK HERE

To Download

Tool with Dummy Data for Verification Purpose Only

CLICK HERE

To Download

Cash Book to Bank Book Format Converter

CLICK HERE

Depreciation Calculation Helper 2025-26 for KSmart

  

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 tool is made for the use of Block Panchayaths and District Panchayaths only

This is very useful for Accountants in Panchayaths in Kerala. 

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

To Download

Depreciation Calculation Helper 2025-26 for KSmart 

CLICK HERE

To Download

Tool with Dummy Data only for fault finding 

CLICK HERE

See Also

Urban Saankhya Heads to KSmart Convertor with Verification Helper

Saankhya Heads to KSmart Convertor with Verification Helper

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.

Depreciation Calculation Helper 2025-26 for KSmart

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

ILGMS Heads to KSmart Convertor

 

This tool help us to convert ILGMS Heads to KSmart Heads. We can copy paste financial reports like Balance Sheet and Income and Expenditure to this tool. It will convert the reports to KSmart Heads.

This ia a Trial Tool

To Download

ILGMS Heads to KSmart Convertor  

CLICK HERE

See Also

Depreciation Calculation Helper 2025-26 for KSmart

Depreciation Calculation Helper is a tool which helps accountants in Local Self  Government Institutions of Kerala to Calculate depreciation values of Assets. It incorporates Balance sheet of previous years to calculate the depreciation of each assets. This tool will be very helpful for Grama Panchayaths, Block Panchayaths, District Panchayaths, Municipalities and Corporations.

Saankhya Heads to KSmart Convertor

 This tool help us to convert Saankhya Heads to KSmart Heads. We can copy paste financial reports like Balance Sheet and Income and Expenditure to this tool. It will convert the reports to KSmart Heads.

ILGMS Heads to KSmart Convertor

 This tool help us to convert ILGMS Heads to KSmart Heads. We can copy paste financial reports like Balance Sheet and Income and Expenditure to this tool. It will convert the reports to KSmart Heads.

KSmart Heads to Saankhya Convertor

 This tool help us to convert KSmart Heads to Saankhya Heads. We can copy paste financial reports like Balance Sheet and Income and Expenditure to this tool. It will convert the reports to Saankhya Heads.

Depreciation Calculation Helper 2025-26 

(FOR Panchayath Accounts) 

(Saankhya) 

(Block & District Panchayaths)

 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