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

{"sheet":"Kassenbericht","index":0,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[2,2,2,4],[2,7,2,8],[4,3,4,4],[4,7,4,8],[35,4,35,7],[36,4,36,7],[37,4,37,7],[38,4,38,7],[39,4,39,7],[40,4,40,7],[45,4,45,7],[48,4,48,7],[49,4,49,7],[50,4,50,7],[52,2,52,8]]}
[]
[]
[null,null,"Kassenbericht",{"$nulls":3},"Datum:"]
[]
[null,null,"zur Kasse:",{"$nulls":3},"erstellt durch:"]
[]
[]
[]
[null,null,"Zählung zum Tagesende"]
[]
[{"$nulls":3},"Noten","Anzahl","Betrag","Münzen","Anzahl","Betrag"]
[{"$nulls":3},"500 EUR",null,{"$f":"E12*500","v":{"v":0,"d":"0.00"}},"2 EUR",null,{"$f":"H12*2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"200 EUR",null,{"$f":"E13*200","v":{"v":0,"d":"0.00"}},"1 EUR",null,{"$f":"H13*1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"100 EUR",null,{"$f":"E14*100","v":{"v":0,"d":"0.00"}},"50 Cent",null,{"$f":"H14*0.5","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"50 EUR",null,{"$f":"E15*50","v":{"v":0,"d":"0.00"}},"20 Cent",null,{"$f":"H15*0.2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"20 EUR",null,{"$f":"E16*20","v":{"v":0,"d":"0.00"}},"10 Cent",null,{"$f":"H16*0.1","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"10 EUR",null,{"$f":"E17*10","v":{"v":0,"d":"0.00"}},"5 Cent",null,{"$f":"H17*0.05","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"5 EUR",null,{"$f":"E18*5","v":{"v":0,"d":"0.00"}},"2 Cent",null,{"$f":"H18*0.02","v":{"v":0,"d":"0.00"}}]
[{"$nulls":6},"1 Cent",null,{"$f":"H19*0.01","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"Summe Noten",{"$f":"SUM(F12:F18)","v":{"v":0,"d":"0.00"}},null,"Summe Münzen",{"$f":"SUM(I12:I19)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":7},"Kassenbestand",{"$f":"I20+F20","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Weitere Angaben",null,"- Anfangsbestand / Bestand Wechselgeld",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"- Einlagen",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"- Transit aus anderen Kassen",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"+ Entnahmen",{"$nulls":3},{"v":0,"d":"0.00"}]
[{"$nulls":4},"+ Abschöpfung über den Tag in andere Kassen o. Bank",{"$nulls":3},{"v":0,"d":"0.00"}]
[]
[{"$nulls":7},"neutrale Vorgänge",{"$f":"-I25-I26-I27+I28+I29","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Ausgaben des Tages"]
[]
[{"$nulls":3},"lfd. Nr.","Bezeichnung",{"$nulls":3},"Betrag"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"Ausgaben gesamt",{"$f":"SUM(I37:I41)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"Tageseinnahmen",null,{"$f":"IF(I46<0,\"Bitte Eingabe prüfen! Retouren?\",\"\")","v":""},{"$nulls":3},{"$f":"I22+I31+I43","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":4},"  gezählter Kassenbestand (Übertrag von oben)",{"$nulls":3},{"$f":"I22","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},"- Abschöpfung zum Tagesende"]
[{"$nulls":4},"= Wechselgeld/Eröffnungsbestand zum nächsten Tag",{"$nulls":3},{"$f":"I49-I50","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Vorlagen (auch als Excel-Version): Frankoniabilanz Miskys & Lang Steuerberater-Partnerschaft   I   www.frankoniabilanz.de"]