{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cash Advance Reconciliation","Debit (POS) Reconciliation","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Cash Advance Reconciliation","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,6,4,8],[51,2,51,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[50,8,50,9],[51,8,51,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[24,8,24,9],[13,8,13,9],[9,8,9,9],[8,0,8,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[38,8,38,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[44,8,44,9],[40,0,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[0,6,0,7],[1,6,1,7],[2,6,2,7],[36,8,36,9],[37,8,37,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[25,8,25,9],[14,8,14,9],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9]]}
[null,null,"Name:",null,null,"AP Cash Advance:",0,null,"Signed:"]
[null,null,"Ministry:",null,null,"Foreign Currency (CUR) Advance:",0,null,"Total Cash Advance:",{"$f":"SUM(G1:G3)","v":0}]
[null,null,"Phone Number:",null,null,"Debit Card Advance:",0,null,"Receipts Total:",{"$f":"G39","v":0}]
[null,null,"E-mail:",null,null,"(Money from ATM)",null,null,"Cash Returned:"]
[null,null,"Trip:",null,null,null,"Foreign Currency (CUR) Returned :"]
[null,null,"Dates:",null,null,null,null,null,"(in $USD equivalent)  "]
[null,null,"Account Number:",null,null,null,null,null,"Balance:",{"$f":"J2-J3-J4-J5","v":0}]
[]
["Receipts Returned"]
[null,"Date","Vendor","Purpose","Local CUR-PMT ","Exchange","USD $","Location ","Notes"]
[1,null,null,null,0,1,{"$f":"E11/F11","v":0}]
[2,null,null,null,0,1,{"$f":"E12/F12","v":0}]
[3,null,null,null,0,1,0]
[4,null,null,null,0,1,0]
[5,null,null,null,0,1,0]
[6,null,null,null,0,1,0]
[7,null,null,null,0,1,0]
[8,null,null,null,0,1,0]
[9,null,null,null,0,1,0]
[10,null,null,null,0,1,0]
[11,null,null,null,0,1,0]
[12,null,null,null,0,1,0]
[13,null,null,null,0,1,0]
[14,null,null,null,0,1,0]
[15,null,null,null,0,1,0]
[16,null,null,null,0,1,0]
[17,null,null,null,0,1,0]
[18,null,null,null,0,1,0]
[19,null,null,null,0,1,0]
[20,null,null,null,0,1,0]
[21,null,null,null,0,1,0]
[22,null,null,null,0,1,0]
[23,null,null,null,0,1,0]
[24,null,null,null,0,1,0]
[25,null,null,null,0,1,0]
[26,null,null,null,0,1,0]
[27,null,null,null,0,1,{"$f":"E37/F37","v":0}]
[28,null,null,null,0,1,{"$f":"E38/F38","v":0}]
[null,null,null,null,{"$f":"SUM(E11:E38)","v":0},null,{"$f":"SUM(G11:G38)","v":0},null,"Click here and press (Ctrl N) to add lines"]
[]
["Currency Exchanges/ATM Withdraws"]
[null,"Date","Vendor",null,"Currency 1","Exchange","Currency 2","Location ","Notes"]
[1,null,null,null,0,1,{"$f":"E43*F43","v":0}]
[2,null,null,null,0,1,0]
[3,null,null,null,0,1,0]
[4,null,null,null,0,1,0]
[5,null,null,null,0,1,0]
[6,null,null,null,0,1,0]
[7,null,null,null,0,1,0]
[8,null,null,null,0,1,0]
[9,null,null,null,0,1,0]
[10,null,null,null,0,1,0]

{"sheet":"Debit (POS) Reconciliation","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[15,8,15,9],[8,0,8,9],[9,8,9,9],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[27,8,27,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[40,0,40,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[41,2,41,3],[41,8,41,9],[42,2,42,3],[42,8,42,9],[43,2,43,3],[43,8,43,9],[44,2,44,3],[44,8,44,9],[45,2,45,3],[45,8,45,9],[46,2,46,3],[46,8,46,9],[50,2,50,3],[50,8,50,9],[51,2,51,3],[51,8,51,9],[47,2,47,3],[47,8,47,9],[48,2,48,3],[48,8,48,9],[49,2,49,3],[49,8,49,9]]}
[null,null,"Name:",{"$f":"('Cash Advance Reconciliation'!D1)","v":0},null,null,null,null,"Signed:"]
[null,null,"Ministry:",{"$f":"'Cash Advance Reconciliation'!D2","v":0},null,null,null,null,"Debit Card Advance:"]
[null,null,"Phone Number:",{"$f":"'Cash Advance Reconciliation'!D3","v":0},null,null,null,null,"Receipts Total:",{"$f":"G39","v":0}]
[null,null,"E-mail:",{"$f":"'Cash Advance Reconciliation'!D4","v":0}]
[null,null,"Trip:",{"$f":"'Cash Advance Reconciliation'!D5","v":0}]
[null,null,"Dates:",{"$f":"'Cash Advance Reconciliation'!D6","v":0}]
[null,null,"Account Number:",{"$f":"'Cash Advance Reconciliation'!D7","v":0},null,null,null,null,"Balance:",{"$f":"J2-J3-J4-J5","v":0}]
[]
["Receipts Returned"]
[null,"Date","Vendor","Purpose","Local CUR-PMT ","Exchange","USD $","Location ","Notes"]
[1,null,null,null,0,{"$f":"IF(E11>0, G11/E11, 1)","v":1},0]
[2,null,null,null,0,{"$f":"IF(E12>0, G12/E12, 1)","v":1},{"$f":"E12/F12","v":0}]
[3,null,null,null,0,1,0]
[4,null,null,null,0,1,0]
[5,null,null,null,0,1,0]
[6,null,null,null,0,1,0]
[7,null,null,null,0,1,0]
[8,null,null,null,0,1,0]
[9,null,null,null,0,1,0]
[10,null,null,null,0,1,0]
[11,null,null,null,0,1,0]
[12,null,null,null,0,1,0]
[13,null,null,null,0,1,0]
[14,null,null,null,0,1,0]
[15,null,null,null,0,1,0]
[16,null,null,null,0,1,0]
[17,null,null,null,0,1,0]
[18,null,null,null,0,1,0]
[19,null,null,null,0,1,0]
[20,null,null,null,0,1,0]
[21,null,null,null,0,1,0]
[22,null,null,null,0,1,0]
[23,null,null,null,0,1,0]
[24,null,null,null,0,1,0]
[25,null,null,null,0,1,0]
[26,null,null,null,0,1,0]
[27,null,null,null,0,1,0]
[28,null,null,null,0,{"$f":"IF(E38>0, G38/E38, 1)","v":1},0]
[null,null,null,null,{"$f":"SUM(E11:E38)","v":0},null,{"$f":"SUM(G11:G38)","v":0},null,"Click here and press (Ctrl N) to add lines"]
[]
["Currency Exchanges/ATM Withdraws"]
[null,"Date","Vendor",null,"Currency 1","Exchange","Currency 2","Location ","Notes"]
[1,null,null,null,0,{"$f":"IF(E43>0, G43/E43, 1)","v":1},0]
[2,null,null,null,0,{"$f":"IF(E44>0, G44/E44, 1)","v":1},0]
[3,null,null,null,0,1,0]
[4,null,null,null,0,1,0]
[5,null,null,null,0,1,0]
[6,null,null,null,0,1,0]
[7,null,null,null,0,1,0]
[8,null,null,null,0,1,0]
[9,null,null,null,0,1,0]
[10,null,null,null,0,1,0]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}