Manu's Panchayath Help Desk (Main Page)
An Attempt to Help Day to Day Tasks of Panchayats
Search This Blog
My Posts
Saturday, 26 September 2026
Tools and Notes Arranged Subject Wise
Friday, 25 September 2026
ILGMS Cash Book Simplifier
This is a tool that helps convert the Cash Book Summary Report from the ILGMS software into a simple, easy-to-check format.
The 'Detailed' sheet displays the specific transactions for each day along with their respective line numbers, making it easy to review them.
The 'Abstract' sheet shows the daily totals.
If there is a discrepancy between a day's closing balance and the next day's opening balance, the specific amount of that difference is highlighted.
The cumulative total of these differences accounts for the variance observed in the closing balance on the final day.
ILGMS Cash Book Simplifier
Monday, 14 September 2026
Bank Reconciliation Helper
This tool facilitates bank reconciliation tasks within K-Smart.
It also helps maintain a record showing the specific vouchers matched with corresponding bank entries. Should it become necessary to revisit reconciliations from previous months, this tool makes the process of re-reconciliation very easy.
If data from K-Smart and the bank are reconciled to identify and resolve discrepancies before the month ends, the final reconciliation process becomes much easier. Treasury account passbooks can be simplified using the 'BiMS Bank PassBook Simplifier' tool and then imported into this tool using the 'Paste Special Values' function.
Bank Reconciliation Helper
BiMS Bank PassBook Simplifier
The BiMS Bank PassBook Simplifier is a tool designed to convert the Treasury bank passbook from BiMS software into a simplified format. It allows for the addition of necessary details such as remarks, receipt numbers, and account heads. Furthermore, this tool facilitates uploading the data to K-Smart for bank reconciliation and allows the passbook data to be pasted directly into the Bank Reconciliation Helper tool.

