Tuesday, March 10, 2009


A  very user friendly Excel tool  for preparing the Annual Budget of Panchayats . You just enter the corresponding amounts in the concerned cells. It is not necessary to add or subtract any figures. It will be automatically displayed. You can see the percentage of Closing balance while entering the figures and so you can adjust the same by adjusting the Receipts and Expenditure side .
                            While opening the excel file you can see eight sheets namely Home ,Receipts , Expenditure Receipt Abstract,Exp.Abstract,Facing sheet 1,Fac.sheet 2,and Fac.sheet 3. In Home sheet You will get a clear idea about this programme.  You should enter the Name of Panchayat and the corresponding year in the appropriate Coloumn using ISM. Click the Receipts Sheet The columns are self explanatory and enter the figures with care. After completing Receipts sheet proceeds to the Expenditure Sheet.Enter the figures. Then open Receipts Abstract. Enter the Opening balance in the corresponding column.After completing check the % of CB at the right side of  Exp.Abstract sheet. If it is below 5% adjust the figures in Receipts and Expenditure.In the facing sheets You need not enter anything .It will be automatically generated.
 Maximum care has been taken for the accuracy of calculations  Any how the user should satisfy himself for the accuracy of calculation .If any discrepancy is noticed mail immediately  to pradeepenthulika@gmail.com and so we can correct the same in the next version.  If all are OK, take the print and bind the volume.

For downloading the programme please CLICK HERE

If you have experience any problem or have any valuable suggessions please mail to pradeepenthulika@gmail.com  or dial to 9446242014  and leave your comments to the comment box below so that others can view your opinions

Created by Pradeepen Thulika

Office Phone 0474 2593254

1 comment: