Instruction to create the uploadable file
Sr. No.
1
2
3
4
Sl. No.
6
7
10
11
12
13
14
15
16
17
18
Instruction to create the uploadable file
Instructions
This file helps in creating the uploadable file for transaction through bulk upload in CIB.
All data should be entered into light gold colour shaded cells only. (i.e E1,E2, G1 and A4 to E5004).
Cell E1: In this cell, account number should be entered, amount to be reversed in case of failure of tra
this is same as debit account).
Cell G1: In this cell, remarks at file level can be entered which will be displayed to checker and during
Cell A5 to A5004: In these cells, transaction type should be filled. Only 4 values can be entered into th
upon transaction mode. i.e. For fund transfer within bank "WIB", for NEFT "NFT", for RTGS "RTG" and f
Field ID
FILEHR
TRACE_BRANCHID
TRACE_ACID
CURRENCY
TOTAL_AMOUNT
TOTAL_NO_OF_RECORDS
TRANSACTION_DATE
EXTERNAL_FILE_REFERENCE
BENEFICIARY_REFERENCE_PRB
NETWORK_ID_PRB
AMOUNT_PRB
TXN_CURRENCY_PRB
BNF_ID_PRB
DEBIT_ACCOUNT_ID_PRB
DEBIT_BRANCH_ID_PRB
OWN_REFERENCE_PRB
NOTIFICATION_REQUIRED_PRB
PRBNF
Sequence Field WidthSkip Character
JustificationPad Character
Data Type MandatoryRecord
Indicator
Type ID
Right
1 6 0 String Yes FHR
justified
Right
2 9 0 String Yes FHR
justified
Right
3 34 0 String Yes FHR
justified
Right
4 3 0 String No FHR
justified
Right
5 18 0 Number No FHR
justified
Right
6 5 0 Number Yes FHR
justified
Right
7 10 0 String Yes FHR
justified
Right
8 10 0 String Yes FHR
justified
Right
1 80 0 String No PRB
justified
Right
2 10 0 String Yes PRB
justified
Right
3 18 0 Number Yes PRB
justified
Right
4 3 0 String Yes PRB
justified
Right
5 10 0 Number No PRB
justified
Right
6 34 0 String Yes PRB
justified
Right
7 9 0 String Yes PRB
justified
Right
8 255 0 String Yes PRB
justified
Right
9 1 0 String No PRB
justified
Right
10 6 0 String Yes PRB
justified
Trace Account →
(Where amount to be reversed in case of transaction failure)
Date of Transaction (Current Date or Future date for scheduled
transaction)
Transaction Debit Account IFSC (Always 11 Beneficiary Account
type no character No (Max length for
(Within Bank Should be alphanumeric and other bank 34
(WIB)/ exactly 12 digit 5th character character
NEFT (NFT)/ always 0 (zero)) alphanumeric and for
RTGS (RTG)/ (For ICICI bank ICICI Bank 12 digit
IMPS (IFC)) accounts keep it number )
blank)
NFT 024105501377 PUNB0215700 2157000100048107
024105501377
File Reference →
ADHOC
Maximum 10 character
January 24, 2025
Beneficiary Name (Max Amount (₹) Remarks for Client
length 32 Character) (No (Should not be more than 15 (should not be more
Special Character is digit including decimals and than 21 characters)
allowed but Space is paise)
allowed)
DINESH KUMAR 500,000.00 DINESH MEHNDIRATA
ADHOC
Remarks for Beneficiary
(should not be more than
30 characters)
BHOLENAtH TRADERS
OutPut (from J4 to last line having data) to be copied and pasted into notepad and save as .txt file.
FHR|0011|024105501377|INR|500000|1|01/24/2025|ADHOC^
APO|NFT|500000|INR|024105501377|0011|PUNB0215700|2157000100048107|0011|DINESH KUMAR|D
KUMAR|DINESH MEHNDIRATA|BHOLENAtH TRADERS^
