Friday, July 15, 2011

ACCOUNTS MANAGER Ver.1

ACCOUNTS MANAGER  Ver.1
  Accounts Manager is a package of Excel tools for preparing the Cheque issue Register , Treasury Account Register, Reconciliation Statement, Monthly closing balance and monthly wise investment balance register as per GO(P) No.319/2003/Fin  dtd.12-06-2003 in connection with the prevailing Panchayat accounting system. After downloading the programme unzip the file. For this click right button on the file and press extract here.
When you open the file you can see eighteen sheets namely Home, VPFA I, VPFA II,VPFA III, BANK I - BANK VIII,POST OFFICE, RECONCILIATION, Monthly CB,Investment Balance Register, Facing sheet 1,and Facing Sheet 2. In Home sheet You will get a clear idea about this programme .Open the next sheet VPFA I. This is the Cheque Register in Form No.5  for VPFA I accounts. Enter the name of Your Panchayat by editing  with ISM. Enter the Bank Name, and Account No. in the respective columns. Enter the Opening balance of the year at the top right corner and the Receipts and expenditure details in the corresponding coloumns.Continue the process in the next months below the sheet. you can see an abstract of each month at the end of the sheet
 Open the next sheet VPFA II. This is the Treasury Account  Register in Form No.5  for VPFA II accounts. Enter the relevant details in the respective columns as described above. continue the process in all the accounts Bank I,II,etc. Click on Monthly CB. Enter the Cash in hand, Investment details etc. at here. All the columns are self explanatory . If all are OK, take the print in A4 size paper and bound the volume at the end of the Financial Year
Maximum care has been taken for the accuracy of statements.  Any how the user should satisfy himself for the accuracy .If any discrepancy is noticed mail immediately  to pradeepenthulika@gmail.com and so we can correct the same in the next version
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

Phone Office 0474 2593254

No comments:

Post a Comment