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

{"sheet":"Portokassenjournal","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[3,1,3,3],[3,6,3,7]]}
[null,"Firmenname"]
[null,"Portokassenjournal"]
[]
[null,{"$f":"\"Für \"&TEXT(MIN(B7:B11),\"TT.MM.JJJJ\")&\" bis \"&TEXT(MAX(B7:B11),\"TT.MM.JJJJ\")","v":"Für 01.07.2018 bis 03.07.2018"},null,null,"Saldo",{"$f":"IFERROR(E12-F12, \"\")","v":{"v":31.47,"d":"31.47 €"}}]
[]
[null,"Datum","Beleg-Nr.","Beschreibung","Eingezahlter Betrag","Entnommener Betrag","Gebucht auf","Erhalten von","Genehmigt von"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-07-01"},1011,"Einzahlung in Portokasse",{"v":50,"d":"50.00 €"},null,"Portokasse",null,"Anna Lange"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),3)","v":"2018-07-03"},243,"Pizza für Überstunden",null,{"v":18.53,"d":"18.53 €"},"Mitarbeitermotivation","Detlev Hembrock","Anna Lange"]
[]
[]
[]
[null,"Summe",{"$f":"SUBTOTAL(103,Portokasse[Beleg-Nr.])","v":2},null,{"$f":"SUBTOTAL(109,Portokasse[Eingezahlter Betrag])","v":{"v":50,"d":"50.00 €"}},{"$f":"SUBTOTAL(109,Portokasse[Entnommener Betrag])","v":{"v":18.53,"d":"18.53 €"}}]