{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Petty cash log"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Petty cash log","index":0,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[2,1,2,2],[4,6,4,7]]}
[]
[]
[null,"Petty cash log"]
[]
[null,{"$f":"\"For \"&TEXT(MIN(B8:B16),\"dd/mm/yyyy\")&\" through \"&TEXT(MAX(B8:B16),\"dd/mm/yyyy\")","v":"For 01/01/2019 through 31/12/2019"},null,null,"Balance",{"$f":"E17-F17","v":{"v":131.47,"d":"£131.47"}}]
[]
[null,"Date","Receipt No.","Description","Amount Deposited","Amount withdrawn","Charged to","Received by","Approved by"]
[null,"2019-01-01",1011,"Deposit to petty cash",{"v":50,"d":"£50.00"},null,"petty cash",null,"Angelica Astrom"]
[null,"2019-01-03",243,"Pizza for overtime workers",null,{"v":18.53,"d":"£18.53"},"morale account","Allan Mattsson","Angelica Astrom"]
[null,"2019-12-31",324,"Deposit to petty cash",{"v":100,"d":"£100.00"},null,"petty cash",null,"Angelica Astrom"]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUBTOTAL(103,Table1[Receipt No.])","v":3},null,{"$f":"SUBTOTAL(109,Table1[Amount Deposited])","v":{"v":150,"d":"£150.00"}},{"$f":"SUBTOTAL(109,Table1[Amount withdrawn])","v":{"v":18.53,"d":"£18.53"}}]