Powered By Blogger

Tuesday 3 April 2012

Tool for Calculation of Interest in V2SBCO - By Sri. S Sridhar, IP (Tech) Vizak

Dear All

Procedure for calculation of Interest in V2 SBCO is released by Sri. S Sridhar, IP (Tech) O/o PMG , Vishakapatnam.

SBCOICAL - V2 INTEREST CALCULATION TOOL

INTCLS - A tool to clear Previous Year SB Interest in V2SBCO


Dear All

Download the file from the link below and copy it to SBCO path.  Execute the file to clear previous year SB Interest in V2SBCO.  After this only use Bridge software to transfer Sanchay Interest to V2 SBCO.

Muralidhar Y.R.

INTCLS

Wednesday 28 March 2012

Total CBS Ver 1.0/01.03.2012 (Sanchay Version)

Total CBS  

(HO Sanchay & SO Sanchay Balance Comparition Tool)

 



1. This Software aims at Total Soultions for CBS Reconciliation Work

2. Through this software Discrepency list can be generated at Head Office itself by obtaining Last Balance Report file (DAT files) from SO through e-Mails. By this,  physical movement of CBS Team members can avoided to the extent posible.  This reduces finacial incurrence in form of TA/DA.
  
3. Head office can have a check on SO balance whenever desired.  HO can save lot of man power and time by concentrate only on discrepent a/c.  

4. This software compares the HO Sanchay Balance & SO Sanchay Balance

5. This software will not calculate any Closing Balance.  It uses the Last Balance Report of SOSB Sanchay & SO Online Sanchay Post.
  
6. This software will generate discrepency list as on a "Given Date"

   
7. Update all the patches in Sanchay software before generation of Last Balance Report.  Last Balance report file (SB.DAT/RD.DAT/MIS.DAT etc) will be usually stored at sub folder path "SP5\OT" if generated  through Online option, or  at "SP5\DE\RD" etc if generated using Data Entry Modules or at "SP5\SOSB" if generated using SOSB Module or at "SP5\SD\SB" ETC if generated using SOSB Data entry Module
   
8. This software treats "Non Listed Sanchay A/cs in Last Balance Report" as discrepency.  As such kindly give importance for "View Excluded A/cs" option in "Last Balance Report" and take corrective steps to include "Live A/cs" into the list.
   
9. At the end of the discrepency report a summary will be generated. The total number of a/cs in summary is "sum of HO Sanchay Live A/cs and Number of SO Sanchay A/cs in excess of HO Sanchay a/cs" as this software compares HO Sanchay Balance to SO Sanchay Balance and also SO Sanchay Balance to HO Sanchay Balance.
   
10. Excess of Sanchay a/c  Accounts are mainly because of
    a. non marking of Closed or Transfer remarks
    b. No entry in common index a/cs
    c. Non effecting of inward transfers either in HO or SO
    d. Listing of accounts having Zero Balance.
   
11. It is possible with this software to tally the Amount and also number of accounts at HO & SO.
  
12. At most care is taken before release of this software.  However if any drawbacks are found in the software please give your feed backs through any of the contact details provided in next window.

Note :  Download from the link below and extract the files to any location.  Create a shortcut for the Totalcbs.exe on the desktop
User guidence :

1. Generate last balance report for the required category for the range of account number and the date as on which you want discrepency report. A .dat file will be created.

2. Get the .DAT file from the sub office generating the last balance report for the same category and for the same account range and the date.

3. In the fetch data menu first show the path of HO Sanchay DAT file and then show the path of SO Sanchay DAT file

4. Process the file

5. Get the discrepency report.

Those who are already using CBSTOTAL Tool (V2 Version) can download and extract the file to any location and copy only Totalcbs.exe & Tothelp.hlp file to CBSTOTAL folder and create a short-cut for the Totalcbs.exe on the desktop.
   
 ********************************************************************************************
                                            A T T E N T I O N
*********************************************************************************************
   
    ALL THE USERS OF THIS SOFTWARE ARE REQUESTED TO REGISTER THEIR E-MAIL IDs WITH THIS SOFTWARE'S E-MAIL ID   cbstotal@gmail.com FURTHER QUERIES/ENHANCEMENTS/UPDATIONS WILL BE DIRECTLY DELIVERED ONLY TO REGISTERED E-MAIL IDs.  AS SUCH REGISTER YOUR E-MAIL IDs WITHOUT FAIL.
   
*********************************************************************************************
                                             T H A N K   Y O U
*********************************************************************************

TOTALCBS Download Link

Total CBS Ver 1.0/01.03.2012 (Sanchay Version)

Wednesday 17 August 2011

CBS TOTAL SOFTWARE - BY MURALIDHAR Y.R.

This Software aims at Total Solutions for CBS Reconciliation Work

Through this software Discrepancy list can be generated at Head Office itself by obtaining Last Balance Report file (DAT files) from SO through e-Mails. By this physical movement of CBS Team members can avoided to the extent posible.  This reduces financial incurrence in form of TA/DA.

 Head office can have a check on SO balance whenever desired.  HO can save lot of man power and time by concentrate only on discrepant a/c.

This software compares the CBs of V2 SBCO & Sanchay Software

This software will not calculate any Closing Balance.  It uses the Closing Balance of V2 and Last Balance Report of Sanchay Post.

This software will not generate discrepancy list as on a "Given Date"

This software compares Closing Balance of V2 (i.e. upto which V2 Data is updated).  As such Last Balance report in Sanchay should be generated by giving "As On Date" as SO date upto which V2 Data updated

Specification of V2 SBCO and Sanchay installation path is a must. While entering the path do not type "\" at the end of the path. You can just provide the Path as C:\SBCO  OR D:\SBCO

Use index services, and update balance option in V2 SBCO before using this software.

If you would like to use the utility services in this software, please ensure a proper back-up of V2 files.

Update all the patches in Sanchay software before generation of Last Balance Report.  Last Balance report file (SB.DAT/RD.DAT/MIS.DAT etc) will be usually stored at sub folder path "SP5\OT" if generated through Online option, or  at "SP5\DE\RD" etc if generated using Data Entry Modules.

This software treats "Non Listed Sanchay A/cs in Last Balance Report" as discrepancy.  As such kindly give importance for "View Excluded A/cs" option in "Last Balance Report" and take corrective steps to include "Live A/cs" into the list.

At the end of the discrepancy report a summary will be generated. The total number of a/cs in summary is "sum of V2 Live accounts and Number of Sanchay A/cs in excess of V2 a/cs" as this software compares V2 Balance to Sanchay and also Sanchay to V2.

Excess of Sanchay a/c over V2 Accounts are mainly because of
a.       non marking of Closed or Transfer remarks
b.      No entry in common index a/cs
c.       Non effecting of inward transfers in V2
d.      Listing of accounts having Zero Balance.

It is possible with this software to tally the Amount and also number of accounts in V2 and Sanchay.

Check of the Closing Balance as per V2 and Sanchay at the end of the report.  If there is any discrepancy in V2 Closing Balance with that of Control Register Figure, use options under "UTILITIES" option in this software. In case of any discrepancy in Sanchay Balance kindly regenerate the Last Balance report either through Online or through Data entry Module.  After this re try generation of Discrepancy List.

 Under Utility option,
a.       Missing OB will be added to ACC file with Name "ADDED ACCOUNT"
b.      Duplicate account will only be listed. Corrective action has to taken by the user, by noting down the account number.
c.       Re-arrange of binder number will be as per Ledger Chart.  If any account range is missing in the ledger chart, then the account will be brought under "UP" binder.
d.      Account wise balance will report CB of From a/c to To a/c
e.       Miseleneous option excess a/cs in OB files will be removed and also corrective action i.r.o missing Office Code in Transaction file can be taken

At most care is taken before release of this software.  However if any drawbacks are found in the software please give your feed backs through any of the contact details provided in next window.
    
**********************************************************************************
ATTENTION
**********************************************************************************                      
   
ALL THE USERS OF THIS SOFTWARE ARE REQUESTED TO REGISTER THEIR E-MAIL IDs WITH THIS SOFTWARE'S E-MAIL ID   cbstotal@gmail.com FURTHER QUERIES/ENHANCEMENTS/UPDATIONS WILL BE DIRECTLY DELIVERED ONLY TO REGISTERED E-MAIL IDs.  AS SUCH REGISTER YOUR E-MAIL IDs    WITHOUT FAIL.           
 *********************************************************************************
 T H A N K   Y O U
 **********************************************************************************
 

CBS TOTAL SOLUTION SOFTWARE - DOWNLOAD LINK