{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Einnahmen-Überschuss-Rechnung"],"read":"whole","date_system":"1900"}

{"sheet":"Einnahmen-Überschuss-Rechnung","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[0,0,0,10],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,1,5],[1,6,1,8],[1,9,1,10]]}
["Einnahmen-Überschuss-Rechnung"]
["Beleg-Nr.","Datum","Transaktion","Einnahmen",null,null,"Ausgaben",null,null,"Steuern"]
[{"$nulls":3},"Netto","U-St.","Summe","Netto","U-St.","Summe","Bez. V-St.","U-St.-Schuld"]
[1,"2024-09-01","Rechnung-Nr. 0001",{"v":1000,"d":"1,000.00 €"},{"v":190,"d":"190.00 €"},{"$f":"IF(D4+E4<>0,D4+E4,\"\")","v":{"v":1190,"d":"1,190.00 €"}},null,null,{"$f":"IF(G4+H4<>0,G4+H4,\"\")","v":""},null,{"$f":"IF(H4<>0,H4*-1,IF(E4<>0,E4,IF(J4<>0,J4,\"\")))","v":{"v":190,"d":"190.00 €"}}]
[2,"2024-09-02","Mobilfunkrechnung",null,null,{"$f":"IF(D5+E5<>0,D5+E5,\"\")","v":""},{"v":49,"d":"49.00 €"},{"v":9.31,"d":"9.31 €"},{"$f":"IF(G5+H5<>0,G5+H5,\"\")","v":{"v":58.31,"d":"58.31 €"}},null,{"$f":"IF(H5<>0,H5*-1,IF(E5<>0,E5,IF(J5<>0,J5,\"\")))","v":{"v":-9.31,"d":"-9.31 €"}}]
[3,"2024-09-06","Rechnung-Nr. 0002",{"v":2500,"d":"2,500.00 €"},{"v":475,"d":"475.00 €"},{"$f":"IF(D6+E6<>0,D6+E6,\"\")","v":{"v":2975,"d":"2,975.00 €"}},null,null,{"$f":"IF(G6+H6<>0,G6+H6,\"\")","v":""},null,{"$f":"IF(H6<>0,H6*-1,IF(E6<>0,E6,IF(J6<>0,J6,\"\")))","v":{"v":475,"d":"475.00 €"}}]
[4,"2024-09-07","Umsatzsteuer-Voranmeldung",null,null,"",null,null,"",{"v":-1500,"d":"-1,500.00 €"},{"v":-1500,"d":"-1,500.00 €"}]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[]
[]
[]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[{"$nulls":5},"",null,null,"",null,""]
[null,null,"Summe:",{"$f":"SUM(D4:D31)","v":{"v":3500,"d":"3,500.00 €"}},{"$f":"SUM(E4:E31)","v":{"v":665,"d":"665.00 €"}},{"$f":"SUM(F4:F31)","v":{"v":4165,"d":"4,165.00 €"}},{"v":49,"d":"49.00 €"},{"v":9.31,"d":"9.31 €"},{"v":58.31,"d":"58.31 €"},{"v":-1500,"d":"-1,500.00 €"},{"v":-844.31,"d":"-844.31 €"}]