{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Welcome","Payment","Bank Code","Help","sysparam"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,0,4,5],[5,0,5,5]]}
[]
["To Begin, Click Options to Enable Macro"]
[" at the above security warning. Please choose Enable this content for both Macro & Data Connection"]
["Note: The tool will not work unless Macro is enabled. Consult your \nIT administrator to enable it if the above option is not available.",null,null,null,null,null,null,null,null,{"$f":"\"Payment File Generator - v\" & ver","v":"Payment File Generator - v1.0b"}]
[null,null,null,null,null,null,null,null,null,"cashmanagement@bankrakyat.com.my\nLocal: 1-300-88-12265\nOverseas: +603-21179000"]

{"sheet":"Payment","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,null,"Note: Ensure macro is enabled before using this tool.",null,null,null,null,null,null,null,null,null,"NRIC","AUTO"]
[null,null,null,"Debiting Account :","220241133324",null,null,null,null,null,null,null,"OLD IC","IFT"]
[null,null,null,"Transaction Date :","2024-05-30",null,null,null,null,null,null,null,"PASSPORT","IBG"]
[{"$f":"\"Payment File Generator v\" & ver","v":"Payment File Generator v1.0b"},null,null,"Total Record :",{"$f":"COUNT(H8:H1048576)","v":3},null,null,null,null,null,null,null,"BR NUMBER","IBFT"]
[null,null,null,"Total Amount :",{"$f":"SUM(H8:H1048576)","v":308},null,null,null,null,null,null,null,"OTHERS","RENTAS"]
["*mandatory fields"]
["Ref No/EFT/\nReceipient Reference*","Beneficiary \nName*","Beneficiary \nID Type\n(please select)","Beneficiary \nID Number","Account No*","Transaction\nType*","Bank Code*\n(refer here)","Amount*","Remarks/Other Payment Details","Email Address","Mobile Number"]
["Example: StaffID001","BENEFICIARY NAME 1","NRIC","XXXXXX-XX-XXXX","22XXXXXXXX","AUTO","BKRMMYKL",101,"Salary May 2024","staff1@company.com","0123456789"]
["Example: StaffID002","BENEFICIARY NAME 2","OLD IC","4540838","XXXXXXXXXX","IBG","MBBEMYKL",102,"Salary May 2024","staff2@company.com","0123456789"]
["Example: StaffID003","BENEFICIARY NAME 3","PASSPORT","AXXX","XXXXXXXXXX","IBFT","MBBEMYKL",105,"Salary May 2024","staff3@company.com","0123456789"]

{"sheet":"Bank Code","index":2,"n_rows":91,"n_cols":3,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
[]
["List of Bank Code (IBG and RENTAS)"]
["last update 08/08/18"]
["BANK CODE","BANK NAME","IBG"]
["AFBQMYKL","MBSB BANK BERHAD",""]
["AGOBMY21","AGRO BANK PERTANIAN M'SIA BHD - SPI",""]
["AGOBMYKL","AGRO BANK PERTANIAN MALAYSIA","YES"]
["AIBBMYKL","AFFIN ISLAMIC BANK BERHAD",""]
["AISLMYKL","AMISLAMIC BANK BERHAD",""]
["ALSRMYKL","ALLIANCE ISLAMIC BANK BERHAD",""]
["AMMBMY21","AMINVESTMENT BANK BHD-SPI",""]
["AMMBMYKL","AMINVESTMENT BANK BERHAD",""]
["ARBKMYKL","AMBANK BERHAD","YES"]
["BIMBMYKL","BANK ISLAM BHD","YES"]
["BKCHMYKL","BANK OF CHINA (M) BHD","YES"]
["BKKBMYKL","BANGKOK BANK BHD","YES"]
["BKRMMYKL","BANK KERJASAMA RAKYAT MALAYSIA","YES"]
["BMDRMYK1","BURSA (M) DERIVATIVES CLEARING BHD",""]
["BMMBMYKL","BANK MUAMALAT MALAYSIA BHD","YES"]
["BMSCMYK1","BURSA MALAYSIA SECURITIES CLEARING",""]
["BNMAMYKL","BANK NEGARA MALAYSIA",""]
["BNPAMY21","BNP PARIBAS-SPI",""]
["BNPAMYKL","BNP PARIBAS","YES"]
["BOFAMY2X","BANK OF AMERICA BHD","YES"]
["BOTKMY21","MUFG BANK (MALAYSIA) BERHAD - SPI",""]
["BOTKMYKX","MUFG BANK (MALAYSIA) BERHAD","YES"]
["BSNAMY21","BANK SIMPANAN NASIONAL - SPI",""]
["BSNAMYK1","BANK SIMPANAN NASIONAL","YES"]
["CAGAMY21","CAGAMAS BERHAD - SPI",""]
["CAGAMYKL","CAGAMAS BERHAD",""]
["CHASMYKX","J.P. MORGAN CHASE BANK BHD","YES"]
["CIBBMYKL","CIMB BANK BERHAD","YES"]
["CITIMYKL","CITIBANK BHD","YES"]
["CITIMYM1","CITIBANK - SPI",""]
["COIMMY21","CIMB INVESTMENT BANK BHD - SPI",""]
["COIMMYKL","CIMB INVESTMENT BANK BERHAD",""]
["CTBBMYKL","CIMB ISLAMIC BANK BERHAD",""]
["DEUTMY21","DEUTSCHE BANK - SPI",""]
["DEUTMYKL","DEUTSCHE BANK (M) BHD","YES"]
["EXMBMY21","EXPORT IMPORT (EXIM) BANK - SPI",""]
["EXMBMYKL","EXPORT IMPORT (EXIM) BANK",""]
["HBMBMYKL","HSBC BANK MALAYSIA BHD","YES"]
["HDSBMY2P","AFFIN HWANG INVESTMENT BANK BERHAD",""]
["HLBBMYKL","HONG LEONG BANK","YES"]
["HLIBMYKL","HONG LEONG ISLAMIC BANK",""]
["HLIVMYKL","HONG LEONG INVESTMENT BANK BHD",""]
["HMABMYKL","HSBC AMANAH",""]
["ICBKMYKL","INDUSTRIAL & COMMERCIAL BANK OF CHINA","YES"]
["IIMBMYKL","INDIA INTERNATIONAL BANK (M) BERHAD",""]
["KAFBMY21","KAF INVESTMENT-SPI",""]
["KAFBMYKL","KAF INVESTMENT",""]
["KFHOMYKL","KUWAIT FINANCE HOUSE","YES"]
["KKENMY21","KENANGA INVESTMENT - SPI",""]
["KKENMYK1","KENANGA INVESTMENT",""]
["KWAPMYK1","KUMPULAN WANG PERSARAAN DIPERBADANKAN (KWAP)",""]
["KWSPMYK1","KUMPULAN WANG SIMPANAN PEKERJA (KWSP)",""]
["MBAMMY21","ALLIANCE INVESTMENT BANK BHD - SPI",""]
["MBAMMYKL","ALLIANCE INVESTMENT BANK BHD",""]
["MBBEMYKL","MALAYAN BANKING BHD","YES"]
["MBEAMY21","MAYBANK INVESTMENT BANK - SPI",""]
["MBEAMYKL","MAYBANK INVESTMENT BANK",""]
["MBISMYKL","MAYBANK ISLAMIC BANK",""]
["MCDSMYK1","BURSA MALAYSIA DEPOSITORY",""]
["MEPSMYK1","MALAYSIA ELECTRONIC PAYMENT SYSTEM (MEPS) SDN BHD",""]
["MFBBMYKL","ALLIANCE BANK","YES"]
["MGTCBEBE","EUROCLEAR",""]
["MHCBMYKA","MIZUHO BANK (M) BERHAD","YES"]
["MIDFMY21","MIDF AMANAH INVESTMENT - SPI",""]
["MIDFMYK1","MIDF AMANAH INVESTMENT",""]
["MSMEMY21","SME BANK - SPI",""]
["MSMEMYK1","SME BANK",""]
["NBADMYKL","NATIONAL BANK OF ABU DHABI",""]
["NOSCMYKL","THE BANK OF NOVA SCOTIA",""]
["OABBMYKL","OCBC AL-AMIN BANK BERHAD",""]
["OCBCMYKL","OCBC BANK","YES"]
["OSKIMYKL","RHB INVESTMENT BANK",""]
["PBBEMYKL","PUBLIC BANK","YES"]
["PCBCMYKL","CHINA CONSTRUCTION BANK",""]
["PEMBMY21","BANK PEMBANGUNAN - SPI",""]
["PEMBMYK1","BANK PEMBANGUNAN",""]
["PHBMMYKL","AFFIN BANK","YES"]
["PIBEMYK1","PUBLIC ISLAMIC BANK BERHAD",""]
["RHBAMYKL","RHB ISLAMIC BANK",""]
["RHBBMYKL","RHB BANK","YES"]
["RJHIMYKL","AL RAHJI BANKING & INV.CORP. (M) BHD","YES"]
["SCBLMYKX","STANDARD CHARTERED BANK BHD","YES"]
["SCSRMYKK","STANDARD CHARTERED SAADIQ BHD",""]
["SMBBMYK1","PUBLIC INVESTMENT BANK BERHAD",""]
["SMBCMYKL","SUMITOMO MITSUI BANK","YES"]
["UOVBMY21","UNITED OVERSEAS BANK - SPI",""]
["UOVBMYKL","UNITED OVERSEAS BANK","YES"]

{"sheet":"Help","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"sysparam","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["parameter","value","remarks"]
["version","1.0b","version number"]
["delimiter",",","field separator"]
["idcheck",true,"ID validation flag"]