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.
1 comments:
very nice post but some post office not accept xls file so what to do...
Post a Comment