Saturday 31 October 2015

SO ACCOUNT THROUGH EXCEL

PLI EA PREMIUM TABLE

HP LASERJET DRIVERS

laser-printer-drivers-all-in-one

all-in-one-driver-solution

all-in-one-drivers-installer-cd-iso

/hp-laserjet-p1000-p1500-basic-drivers

TIME & WORK STUDY MATERIALS 2

time & work study materials

guides-for-direct-pasa-through-staff

books

study materials

Friday 30 October 2015

vb-data-entry-to-mde-converter-tool


CBSBusiness 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.








salute to SAs ,they are taking the Indiapost to the goal for touching the general public.