Saturday 31 October 2015

CBS Business Continuity Plan(BCP) DOCUMENTS

CBSBusiness Continuity Plan(BCP) DOCUMENTS
Ø              
            What is BCP?

BCP is an alternative to accept some transactions from the customers when Finacle Application will not be accessible in all CBS Post Offices. 

Ø                 When BCP is to be invoked?

BCP will be invoked through an order issued by F.S. Division of Postal Directorate to CEPT Team to enable special BCP Menus.
Ø                  
               LIST OF transactions which can be accepted during BCP

    Following type of transactions can be accepted during BCP:-
    (1)   Deposits in Savings Account.
    (2)   Deposits in RD Account opened and operated directly (not through MPKBY Agents)
    (3)   Deposits in PPF Accounts.

Ø    Procedure for accepting transactions during BCP:-
¨      When mail is received from CEPT Team/Circle SPOC regarding use of BCP, deposit transactions by cash are to be accepted in Savings Accounts, RD Accounts (other than opened by MPKBY Agents) and PPF Accounts standing in the same post office (no Intersol transaction).
¨      On the Deposit Form (Pay-in-Slip), customer should be asked to write his/her mobile number or landline Number and last balance.
¨      While accepting cash, no entry should be made in Passbook but counterfoil of Deposit Form should be given to customer duly date stamped and signed by PA.
¨      Account number and amount deposited should be entered in Excel Format attached with this mail and also given in below.
¨      In the Excel sheet, scheme can be selected either as SB or Rd or PPF. After completion of data entry of transactions, print out of the excel file should be taken.
¨      When Finacle Access is restored or counter hours are over, click on “Generate File” in the excel format.
¨      It will create a .txt file showing scheme type i.e SB or RD or PPF, date in DDMMYY format and total amount of transactions in D/.  
¨      After this step, while browsing in the relevant menu, this file should be uploaded in the relevant menu as shown in the below screen shots.  It is to ensured that only that day's file is uploaded by confirming date and total amount from the file name.
¨      Supervisor has to verify these transactions by using menu HTV.
¨      After verification, these transactions would appear in relevant LOT and consolidation.
¨      Report of success and rejected records can be seen from reports in HPR. If any transaction is rejected during upload, Deposit Slip of that transaction should be kept separately and customer should be contacted over phone (phone number written on the deposit slip).
¨      Cash of these transactions should be kept out of account alongwith vouchers.
¨      As and when customer comes, corrections should be got done in the Deposit Slip and transaction along with cash should be accounted for in Finacle.

SB CASH - Bulk Transaction Upload

1.    SB Bulk UPLOAD PROCEDURES


Sl.no.
Procedure
Remarks
1
For uploading the account numbers and amount deposited, a .txt file is to be created. For this purpose, data has to be entered in a template of an excel file (sample given in the next column) for creating the txt file in required format.
In the Excel sheet, do the following as shown below ( screenshots included)
1.       Select the Type as “SB” from the list.
2.       Column1 is for account numbers, column 2 for Transaction Amount.
3.       After Clicking on Generate File, the generated file name will be SB<Generated_Date>_<Sum_of_TranAmount>.TXT

Template file :    
2
The Bulk data (.txt file) upload can be done through CSBTM menu. In CSBTM menu using browse button select the txt file made in the above step. Then click on Upload. The reports of success or failure will be shown in HPR menu.
Screenshot 1 : CSBTM menu details page



Screenshot 2 :Click on Browse and Select the text file from D/.
Screenshot 3 :Click on Upload
Screenshot 4 :CSBTM result page
Screenshot  5:HPR-success and failure reports generated

RD CASH - Bulk Transaction Upload

2.    RD Bulk UPLOAD PROCEDURES

Sl.no.
Procedure
Remarks
1
For uploading the account numbers and amount deposited, a .txt file is to be created. For this purpose, data has to be entered in a template of an excel file (sample given in the next column) for creating the txt file in required format.
In the Excel sheet, do the following as shown below ( screenshots included)
1.       Select the Type as “RD” from the list.
2.       Column1 is for account numbers, column 2 for Transaction Amount.
3.       After Clicking on Generate File, the generated file name will be RD<Generated_Date>_<Sum_of_TranAmount>.TXT

Template file :    
2
The Bulk cash upload can be done through CBTM menu. In CBTM menu using browse button select the txt file made in the step. Then click on Upload. The reports will be shown in HPR menu.
Screenshot 1, 2 :CBTM menu details page, clicked on browse button to select the TXT file to upload.
Screenshot 3: CBTM menu result page.
Screenshot 4 : HPR menu –  reports generated by CBTM upload.


PPF CASH - Bulk Transaction Upload

4.    PPF Bulk UPLOAD PROCEDURES


Sl.no.
Procedure
Remarks
1
For uploading the account numbers and amount deposited, a .txt file is to be created. For this purpose, data has to be entered in a template of an excel file (sample given in the next column) for creating the txt file in required format.
In the Excel sheet, do the following as shown below ( screenshots included)
5.       Select the Type as “PPF” from the list.
6.       Column1 is for account numbers, column 2 for Transaction Amount.
7.       After Clicking on Generate File, the generated file name will be PPF<Generated_Date>_<Sum_of_TranAmount>.TXT

Template file :    
2
The Bulk cash upload can be done through CPBTM menu. In CPBTM menu using browse button select the txt file made in the step. Then click on Upload. The reports will be shown in HPR menu.
Screenshot 1 : CPBTM menu details page
Screenshot 2 : CPBTM menu result page
Screenshot 3 : HPR menu –  reports generated by CPBTM upload.








CLICK HERE TO VIEW THE BCP DOCUMENT

(RD AGENT) MPBKY BCP NEW XLS FILE FOR SCHEDULE DEPOSIT IN CBS OFFICE DURING NON FUNCTION OF AGENT PORTAL

Step First:



Step Second:

Use XLS File For Download=>>        DOWNLOAD FILE

Step Third:

After that save the file whatever file is generated rename TXT as txt (Small caps) so that naming is done as "

Example Correct renaming: RD31102015_104360_00.txt

Detail Information of Procedure

Stepwise guide to Generate File:=>>>>  Download file
                                           
Click on RD in the dropdown list in A/C Numbers Type.

Write A/C numbers in the left column and amount to be deposited in the Right Column. Please ensure that the Account Type Selected is RD.
After making Entries of All Accounts and the amount to be deposited Click on the Generate File button.
           (Please Ensure that No RD A/C’s with default fee or Rebate are not entered in this Excel sheet.)

Click on Generate file. A text document will be generated on Desktop.
The generated file will be named in the following format. RD<Generated_Date>_<Sum_of_TranAmount>.TXT

Upload the File.






If the system shows the following error.
Cannot run the macro BCP Excelsheet RD.sheet1.book The macro may not be available in the workbook  or all macros may be disabled for this


Click on Options and Enable this content Button

    


How to Upload

The Bulk cash upload can be done through CBTM menu. In CBTM menu using browse button select the txt file made in the step. Then click on Upload. The reports will be shown in HPR menu.
Screenshot 1, 2 :CBTM menu details page, clicked on browse button to select the TXT file to upload.
Screenshot 3: CBTM menu result page.
Screenshot 4 : HPR menu –  reports generated by CBTM upload.


If there is any wrong account number added or account number having default fee or rebate is entered in Excel, these accounts will be listed in the Failure Report. User has to see success report first and tally with the excel. If all entries are tallied, there is no need to see Failure report. If there is difference, please see failure report and tell agent that these account cannot be accepted through Excel.