Transcript - BANKER`S LEARNING HOUSE

Presentation on ISS RIT
preparation :
with special importance on avoiding file
bounce
ISS Reporting Management at Branch level
Awareness about ISS Related Circular
from BB and own Bank
 ISS Job List and Organogram
 Office Order to distribute ISS Job
 In-house Training
 Data Preservation
 Documentation
 Verification
 Fall back plan and person

***Don’t
send the Excel & CSV files to
[email protected] until instructed from ISM Cell
ISS Forms to report
The Rationalized input Template (RIT) is
standardized electronic data reporting
form.
Since ISS reporting is web based it needs
specialized RITs (Rationalized Input
Template).
These RITs are ISS form-01, 02, 03 and 04.
Where will you get the ISS Forms?
With circular no. DBI-2, 01/2014 and
Circular Letter no. ISMC, 01/2016
(for learning purpose only)
At Bangladesh Bank website: www.bb.org.bd
(for reporting purpose)
Attentive features of ISS Form-2
► Date Format
YYYYMMDD - 20160131
Without any date separator
► Bank code and Branch code Writing If Bank ID is 99 and Branch ID is 1234,then
Your Bank ID is 99 and Branch ID is
991234
Figure nature : 3 Types
- as on reporting date
- for the accounting year
►
- for the reporting month
► Reporting currency : only use BDT
Amount in absolute figure :
► - No conversion in Thousand/Lac/
Crore/Million/Billion
- Up-to Two Decimal point is allowed
Foreign currency in Hand : USD 100
Reporting amount will be BDT.
(=Exchange rate × 100)
Total Loan Outstanding is 120.08 Crore
Reporting amount will be
1200800000.00
Use of Comma(,) is strictly prohibited
Attentive features of ISS Form-4
► Date Format
► Bank code and Branch code Writing
►
YYYYMMDD - 20160131
Without any date separator
If Bank ID is 99 and Branch ID is 1234,then
Your Bank ID is 99 and Branch ID is 991234
Figure nature : - for the accounting year
► Reporting currency : only use BDT
Amount in absolute figure :
► - No conversion in
Thousand/Lac/Crore/Million/Billiion
- Up-to Two Decimal point is
allowed
Foreign currency in Hand : USD 100
Reporting amount will be BDT.
(=Exchange rate × 100)
Value of acceptance issued amount is 2.07
Crore
Reporting amount will be 20700000.00
Use of Comma(,) is strictly prohibited
► You have to input amount in corresponding bank’s row : ISS Form-4
► Inter branch/same branch transaction also required reporting consideration
ISS Reporting Steps:
Step‐1 :
Step‐2 :
Step‐3 :
Step‐4 :
• Log In to ISS through Web Portal of Bangladesh Bank Website
• Download the Forms(RITs) through Web Portal of Bangladesh
Bank Website
• Rename as per naming convention
• Fill up the Forms(RITs) & Save the file as CSV format
Step‐5 :
• Upload the CSV file through Web Portal of Bangladesh Bank
Website
Step‐6 :
• Remove the already uploaded CSV file (In case of change in the file
within the reporting deadline)
After removal of CSV file you can made necessary changes in the excel
file (original RIT) and then save the excel file as CSV format and then
upload again. In this case you can follow the Step‐3 & Step‐4.
 Remember, for any changes you must have to do this only in
excel file, not in CSV file.

Address of Web Portal for ISS Report
www.bb.org.bd
Or
webupload.bb.org.bd
Web Portal- home page
Web Portal- E-Services
Web Portal- Web Upload
Web Portal- Integrated Supervision System
Web Portal- Sign In
Web Portal- Input User ID and Password
Web Upload- Click on Sign In
Web portal- Contact us
Web portal- Change Password
Web portal- Download
Web portal- User Manual for ISS
ISS Manual
Familiarization with ISS Forms
ISS Forms for
Head Office
Branch Office
Monitor
ISS Form-1
ISS Form-2
Acceptance
ISS Form-3
ISS Form-4
Renaming the downloaded Excel file
Naming convention for ISS RIT must be
strictly followed to avoid bounce of file.
Be careful to
1) Input own Bank ID
2) Input own Branch ID
(it is not the “sign in ID” of web portal)
3) Input appropriate reporting date
-Date format:YYYYMMDD
-Use “month end day” according to
calendar; Do not think about holiday)
Naming Convention of ISS RITs
ISS
Form
No
Main Part
1
T_PS_M_FI_MONITOR_HO.
2
T_PS_M_FI_MONITOR_BR.
Bank ID
3
BANK_ID.
T_PS_M_FI_ACCEPTANCE_HO. 11.
4
T_PS_M_FI_ACCEPTANCE_BR.
Branch ID
Reporting
Date
BRANCH_ID. YYYYMMDD
110001.
20140930
Renaming Excel file
Renaming Excel file
Renaming Excel file
Renaming Excel file
File Naming Convention
For Head Office
Answer
For Head Office
Answer
File Naming Convention
For Branch Office
Answer
For Branch Office
Answer
Things: need utmost attention
Things: Strongly Prohibited
Report Preparation: Figures/amount nature





Values are numeric without comma(,)
Don’t use any character/symbols/texts
(#, $, %, *, -, /, \, etc)
Figures are absolute (not in thousand,
million…..………)
Figures are in BDT
For figures with %, input the full figure
(11.58) not in absolute number (0.1128)
& do not use “%” symbol
Report Preparation: Precautionary
measures to avoid file bounce
Check and ensure that file name and file
content have same and appropriate Bank
ID, Branch ID and Reporting date
 Excel files preferably updated
 Download ISS forms from Bangladesh Bank
website
 Final excel files should be verified by
officials other than the maker
 File converted into CSV should be checked
for missing cells and errors

Report Preparation: Input reporting date,
Own Bank ID and Own Branch ID
Report Preparation: Change Conventional-Islamic indicator
Report Preparation: Form 3 & 4
Input reporting date, Own Bank ID and Own Branch ID
CSV Conversion: Click on “Save As”
CSV Conversion: auto name appear
CSV Conversion:
Select CSV(Comma delimited)
CSV Conversion:
Select CSV(Comma delimited)(*.csv)
CSV Conversion: Click on “Save”
CSV Conversion: Click on “Yes”
CSV Conversion Completed
CSV Conversion Completed
Web portal- ISS File Upload
Web Portal- Select work area (HO or Br)
Web Portal- Select work area (HO or Br)
Web Upload- Input file description, browse
for your CSV copy and select that
Web Upload- Finally click on “Upload”
You will get successful file upload message
Web Upload- Finally click on “Upload”
You will get successful file upload message like this one
Check whether your file is shown on the portal as
follows :
Matters to concern
Common mistakes in the ISS reports
identified by ISM Cell
1.
2.
3.
4.
5.
File Name-naming convention
File name, bank code, branch code do
not match with the file name
Excel file renamed into csv file and
uploaded in the ISS
Reporting date-end of the month not
any other date
ISS Form-1,2,3 and 4 not most updated
Common mistakes in the ISS reports
identified by ISM Cell
6.
7.
8.
9.
10.
11.
Date format not as shown in the ISS
Manual or ISS Forms (2)
Value other than numeric
Missing cells in CSV files (2 3)
Wrong branch code
Month and year do not match with the
reporting month
Corrupted/Tempered excel file-format
error
Common mistakes in the ISS reports
identified by MIS & RBI Cell
12.
13.
14.
15.
16.
17.
18.
19.
Copied cells containing value other than
numeric
Value containing comma (‘,’)
Decimal places not more than two
Islamic-conventional indicator
File names do not contain BR or HO
ISS forms changed
Template modification
Double date entry
Common mistakes in the ISS reports
identified by MIS & RBI Cell
20.
21.
22.
23.
Less record
No COA ID
File name: Acceptance changed into
monitor
Password must be changed in
accordance with bank’s ICT policy
Thanks...