{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ACH File Upload","Bank List","Branch List"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"ACH File Upload","index":0,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["Company Name","Company Name",null,null,"File SUMMARY  "]
["OriginatorId","0771234567"]
["Company A/C","123456789",null,null,{"$f":"SUM(C10:C65555)","v":0},"File Total"]
["File type","CR",null,null,{"$f":"COUNTIFS(C10:C65555,\">0\",H10:H65555,\"=0\") + COUNTIFS(C10:C65555,\"=0\",H10:H65555,\"=1\")","v":0},"No. of Entries"]
["File Currency","JMD"]
["Effective Date (YYYYMMDD)","20190523"]
["Company discretionary Data","Elink Paymnt Company Name"]
["Transaction Records"]
["Account Number ","Account Type","Transaction Amount","Financial Institution ID","Participant ID","Participant Name","Trace ID #","Notification","Addenda"]

{"sheet":"Bank List","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Bank_Code","Bank_Name"]
["002","BANK OF NOVA SCOTIA (JAMAICA) LIMITED"]
["010","FIRST CARIBBEAN INT'L BANK."]
["026","CITIBANK N.A."]
["050","JN BANK"]
["051","VICTORIA MUTUAL BUILDING SOCIETY"]
["062","JMMB BANK (JAMAICA) LIMITED"]
["075","FIRST GLOBAL BANK LIMITED"]
["077","NATIONAL COMMERCIAL BANK"]
["081","SAGICOR BANK JAMAICA LTD"]
["999","BANK OF JAMAICA"]

{"sheet":"Branch List","index":2,"n_rows":259,"n_cols":3,"rows_kept":259,"cut":false,"hidden":true,"merged":[]}
["BANK_CODE","BR_CODE","BR_NAME"]
["002","00125","CHRISTIANA"]
["002","00265","SAVANNA-LA-MAR"]
["002","01305","FALMOUTH"]
["002","07765","TELEPHONE BANKING"]
["002","09225","PRIVATE BANKING"]
["002","10165","EAST QUEEN STREET"]
["002","10215","MONTEGO BAY"]
["002","10355","VICTORIA AND BLAKE"]
["002","18465","UNIVERSITY"]
["002","20115","BROWN'S TOWN"]
["002","20255","ST. ANN'S BAY"]
["002","20685","NEW PORT WEST"]
["002","21345","LUCEA"]
["002","21725","CONSTANT SPRING FINANCIAL CENT"]
["002","22475","JUNCTION"]
["002","30015","KING STREET"]
["002","30155","SHARED SERVICES"]
["002","30205","MAY PEN"]
["002","31575","RIVERTON CITY"]
["002","36525","SCOTIA JA. BUILDING SOCIETY"]
["002","38745","IRONSHORE"]
["002","40105","BLACK RIVER"]
["002","41335","OLD HARBOUR"]
["002","50195","MANDEVILLE"]
["002","50245","PORT MARIA"]
["002","50575","NEW KINGSTON"]
["002","50765","SCOTIA CENTRE"]
["002","56275","SCOTIA CENTRE"]
["002","57935","CENTRALISED ACCOUNTING UNIT"]
["002","60145","HALF WAY TREE"]
["002","60665","HIGHGATE"]
["002","61325","PREMIER BRANCH"]
["002","61655","MORANT BAY"]
["002","62075","DATA CENTRE"]
["002","70185","LINSTEAD"]
["002","70235","PORT ANTONIO"]
["002","78345","CASH PROCESSING UNIT"]
["002","80135","CROSS ROADS"]
["002","80275","SPANISH TOWN"]
["002","81315","SANTA CRUZ"]
["002","81505","OXFORD ROAD"]
["002","90175","HAGLEY PARK ROAD"]
["002","90225","OCHO RIOS"]
["002","90365","LIGUANEA"]
["002","90605","WESTGATE"]
["002","90795","COMPTROLLERS DEPT."]
["002","92825","NEGRIL"]
["002","95505","PORTMORE"]
["010","07406","PROCESSING"]
["010","07426","CORPORATE"]
["010","09004","WEALTH MANAGEMENT"]
["010","09076","MANOR PARK"]
["010","09156","KING STREET"]
["010","09176","NEWPORT WEST"]
["010","09495","MONTEGO BAY"]
["010","09516","PORT ANTONIO"]
["010","09526","OCHO RIOS"]
["010","09536","HALF WAY TREE"]
["010","09546","MONTEGO BAY"]
["010","09596","MAY PEN"]
["010","09597","FCIB SANTA CRUZ"]
["010","09656","TWIN GATES"]
["010","09666","DUKE & LAWS STREETS"]
["010","09676","KNUTSFORD BLVD"]
["010","09677","SAVANAH-LA-MAR"]
["010","09746","MANDEVILLE"]
["010","09747","PORTMORE"]
["010","09748","FIRST CARIBBEAN LIGUANEA"]
["010","09866","HEAD OFFICE"]
["010","27502","SMALL BUSINESS UNIT"]
["026","00001","HEAD OFFICE"]
["050","00001","HEAD OFFICE"]
["050","00002","INTERNAL PROCESSING CENTRE "]
["050","00023","FINANCE"]
["050","00036","CENTRALISED OPERATIONS"]
["050","00051","HALF-WAY-TREE  "]
["050","00052","NEW KINGSTON   "]
["050","00053","DUKE STREET"]
["050","00055","PAPINE "]
["050","00056","SPANISH TOWN ROAD (TIVOLI)"]
["050","00057","BARBICAN "]
["050","00058","WHITEHOUSE "]
["050","00059","KNUTSFORD "]
["050","00060","OLD HARBOUR "]
["050","00092","HIGHGATE "]
["050","00093","HWT TRANSPORT CENTRE "]
["050","00094","UWI "]
["050","00095","MICHI SUPER CENTRE "]
["050","00120","PORTMORE PINES "]
["050","00121","SPANISH TOWN "]
["050","00122","LINSTEAD "]
["050","00148","PREMIER"]
["050","00191","MAY PEN"]
["050","00261","MANDEVILLE"]
["050","00262","CHRISTIANA "]
["050","00331","SANTA CRUZ"]
["050","00332","JUNCTION "]
["050","00401","SAVANNA-LA-MAR"]
["050","00450","FALMOUTH "]
["050","00471","LUCEA "]
["050","00541","MONTEGO BAY "]
["050","00681","BROWN’S TOWN "]
["050","00682","ST ANN’S BAY "]
["050","00683","OCHO RIOS"]
["050","00751","PORT MARIA"]
["050","00752","ANNOTTO BAY "]
["050","00753","GAYLE "]
["050","00821","PORT ANTONIO"]
["050","00891","MORANT BAY "]
["050","00999","CATHERINE HALL"]
["051","00001","HALF WAY TREE"]
["051","00002","SPANISH TOWN"]
["051","00003","MAY PEN"]
["051","00004","LIGUANEA"]
["051","00005","MONTEGO BAY"]
["051","00006","OCHO RIOS"]
["051","00007","MANDEVILLE"]
["051","00008","FALMOUTHTH"]
["051","00009","LINSTEAD"]
["051","00010","DUKE STREET"]
["051","00011","NEW KINGSTON"]
["051","00012","SAVANNA-LA-MAR"]
["051","00014","SANTA CRUZ"]
["051","00015","PORTMORE MALL"]
["051","00024","UTECH"]
["051","00028","FAIRVIEW"]
["062","00002","HEAD OFFICE"]
["062","00003","KINGSTON"]
["062","00004","MONTEGO BAY"]
["062","00024","OCHO RIOS"]
["062","00060","HAUGHTON"]
["062","00061","PORTMORE"]
["062","00063","MANDEVILLE"]
["062","00064","MANDEVILLE"]
["062","00086","FAIRVIEW"]
["075","99075","NEW KINGSTON"]
["075","99080","GLOUCESTER AVENUE"]
["075","99082","MANOR PARK"]
["075","99084","MANDEVILLE"]
["075","99085","LIGUANEA"]
["075","99086","SANTA CRUZ"]
["075","99087","CORPORATE"]
["075","99089","DUKE &  HARBOUR"]
["075","99094","OCHO RIOS"]
["075","99095","CROSS ROADS"]
["075","99096","SANTA CRUZ"]
["075","99097","PORTMORE"]
["075","99098","LINSTEAD"]
["075","99099","HOPEWELL"]
["075","99100","MAY PEN"]
["077","00006","DUKE STREET"]
["077","00013","BOULEVARD SUPER CENTRE"]
["077","00017","HAGLEY PARK"]
["077","00020","WINDWARD ROAD"]
["077","00021","OXFORD PLACE"]
["077","00023","CROSS ROADS"]
["077","00029","PRIVATE BANKING"]
["077","00030","HALF WAY TREE"]
["077","00033","MANOR PARK"]
["077","00035","1-7 KNUTSFORD BOULEVARD"]
["077","00036","PORTMORE"]
["077","00037","MATILDA'S CORNER"]
["077","00040","UNIVERSITY"]
["077","00043","MONTEGO BAY"]
["077","00044","FALMOUTH"]
["077","00047","ST JAGO SHOPPING CENTRE"]
["077","00049","HALF MOON"]
["077","00050","MANDEVILLE"]
["077","00054","ST ANN'S BAY"]
["077","00056","MAY PEN"]
["077","00057","CHAPELTON"]
["077","00058","OCHO RIOS"]
["077","00060","NEGRIL"]
["077","00061","SAVANNA-LA-MAR"]
["077","00064","MORANT BAY"]
["077","00067","BLACK RIVER"]
["077","00068","LINSTEAD"]
["077","00071","BROWN'S TOWN"]
["077","00075","LUCEA"]
["077","00078","ANNOTTO BAY"]
["077","00081","PORT MARIA"]
["077","00084","PORT ANTONIO"]
["077","00085","CHRISTIANA"]
["077","00087","OLD HARBOUR"]
["077","00088","JUNCTION"]
["077","00089","SANTA CRUZ"]
["077","00090","HEAD OFFICE"]
["081","01001","TOWER STREET"]
["081","01002","HALF WAY TREE"]
["081","01003","MONTEGO BAY"]
["081","01004","MANDEVILLE"]
["081","01005","LINSTEAD"]
["081","01006","BLACK RIVER"]
["081","01008","SAVANNA LA MAR"]
["081","01009","ST. LUCIA"]
["081","01011","MAY PEN"]
["081","01012","SPANISH TOWN"]
["081","01014","PORTMORE"]
["081","01015","OCHO RIOS"]
["081","01017","FAIRVIEW SHOPPING CENTRE"]
["081","01020","UP-PARK CAMP"]
["081","01021","KNUTSFORD BOULEVARD"]
["081","01023","SOUTHFIELD"]
["081","01024","HOPE ROAD"]
["081","01025","FAIRVIEW"]
["081","01026","LIONEL TOWN"]
["081","01031","BROWN'S TOWN"]
["081","01032","CROSS ROADS"]
["081","01034","DOMINICA"]
["081","01035","PORT ANTONIO"]
["081","01036","SANTA CRUZ"]
["081","01037","STONY HILL"]
["081","01050","LIGUANEA"]
["081","01051","HARBOUR STREET"]
["081","01063","TROPICAL PLAZA"]
["081","01080","TREASURY"]
["081","01085","CORPORATE BANKING CENTRE"]
["081","01089","CREDIT CARD CENTRE"]
["081","01100","HEAD OFFICE"]
["081","01103","PRIVATE BANKING"]
["081","01110","CENTRALISED OPERATIONS"]
["999","00999","BOJ - HEAD OFFICE"]
["6000","CMB001","CAPITAL & CREDIT MERCHANT BANK"]
["6000","CMB002","CAPITAL & CREDIT MERCHANT BANK"]
["6000","CMB003","CAPITAL & CREDIT MERCHANT BANK"]
["6010","BAR001","BARITA  KINGSTON"]
["6010","BAR002","BARITA MANDEVILLE"]
["6010","BAR003","BARITA MONTEGO BAY"]
["6030","SDB001","SCOTIA DBG INVESTMENTS"]
["6030","SDB002","SCOTIA FINANCIAL CENTRE"]
["6030","SDB003","MONTEGO BAY"]
["6030","SDB004","SAVANNA-LA-MAR"]
["6030","SDB005","MANDEVILLE"]
["6040","FCS001","FIRSTCARIBBEAN INTERNATIONAL S"]
["6050","FGF001","FIRST GLOBAL FINANCIAL SERVICE"]
["6060","JMM001","JMMBL H/O KINGSTON"]
["6060","JMM003","JMMBL KNUTSFORD BLVD"]
["6060","JMM004","JUNCTION ANGENCY"]
["6060","JMM005","OCHO RIOS BRANCH"]
["6060","JMM006","PORTMORE"]
["6060","JMM007","MANDEVILLE"]
["6060","JMM008","MONTEGO BAY"]
["6060","JMM009","MAY PEN"]
["6060","JMM010","SANTA CRUZ"]
["6070","JNF001","JN FUND MANAGERS LIMITED"]
["6080","MBI001","MAYBERRY INVESTMENTS LIMITED"]
["6090","NCM001","NCB CAPITAL MARKETS LIMITED"]
["6100","PCF001","PANCARIBBEAN FINANCIAL SERVICE"]
["6100","PCF002","MONTEGO BAY"]
["6100","PCF003","OCHO RIOS"]
["6100","PCF004","MANDEVILLE"]
["6100","PCF005","SAVANNA-LA-MAR"]
["6130","JCS001","JAMAICA CENTRAL SECURITIES DEP"]
["6140","61401","CCSL KINGSTON"]
["6140","61402","CCSL MANDEVILLE"]
["6140","61403","CCSL MONTEGO BAY"]
["6150","MFG001","MF&G TRUST & FINANCE LIMITED"]
["6160","AGD001","ACCOUNTANT GENERALS DEPARTMENT"]