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

{"sheet":"Petty Cash Log","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[3,1,3,3],[3,6,3,7]]}
[null,"Company Name"]
[null,"Petty Cash Log"]
[]
[null,{"$f":"\"For \"&TEXT(MIN(B7:B11),\"mm/dd/yyyy\")&\" to \"&TEXT(MAX(B7:B11),\"mm/dd/yyyy\")","v":"For 06/01/2018 to 06/03/2018"},null,null,"Balance",{"$f":"IFERROR(E12-F12, \"\")","v":{"v":31.47,"d":"£31.47"}}]
[]
[null,"Date","Receipt No.","Description","Amount Deposited","Amount Withdrawn","Charged to","Received by","Approved by"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-06-01"},1011,"Deposit to petty cash",{"v":50,"d":"£50.00"},null,"petty cash",null,"Sarah Davis"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),3)","v":"2018-06-03"},243,"Pizza for overtime workers",null,{"v":18.53,"d":"£18.53"},"morale account","Ben Miller","Sarah Davis"]
[]
[]
[]
[null,"Total",{"$f":"SUBTOTAL(103,CashLog[Receipt No.])","v":2},null,{"$f":"SUBTOTAL(109,CashLog[Amount Deposited])","v":{"v":50,"d":"£50.00"}},{"$f":"SUBTOTAL(109,CashLog[Amount Withdrawn])","v":{"v":18.53,"d":"£18.53"}}]