{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inkoop","Betalingen","Lijsten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Inkoop","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,{"$f":"SUBTOTAL(9,Table1[BEDRAG  EXCL. BTW])","v":282.68},null,null,null,{"$f":"SUBTOTAL(9,Table1[BTW BEDRAG])","v":55.61},{"$f":"SUBTOTAL(9,Table1[BEDRAG INCL BTW])","v":338.28999999999996}]
[null,"DATUM BOEKING","RELATIE","OMSCHRIJVING","CATEGORIE","BEDRAG  EXCL. BTW","BTW-TARIEF","STATUS","DATUM BETAALD","BTW BEDRAG","BEDRAG INCL BTW","JAAR ","MAAND"]
[null,"2022-01-01","HN",250,4315,125.43,0.21,{"$f":"IF(ISNUMBER(I3),\"Betaald\",\"Openstaand\")","v":"Openstaand"},null,{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]*Table1[[#This Row],[BTW-TARIEF]],2)","v":26.34},{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]+Table1[[#This Row],[BTW BEDRAG]],2)","v":151.77000000000001},2021,1]
[null,"2022-01-25","MP",288,4603,25,0.06,{"$f":"IF(ISNUMBER(I4),\"Betaald\",\"Openstaand\")","v":"Openstaand"},null,{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]*Table1[[#This Row],[BTW-TARIEF]],2)","v":1.5},{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]+Table1[[#This Row],[BTW BEDRAG]],2)","v":26.5},2022]
[null,"2022-03-01","HN",2021,4810,10,0.21,"Openstaand",null,{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]*Table1[[#This Row],[BTW-TARIEF]],2)","v":2.1},{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]+Table1[[#This Row],[BTW BEDRAG]],2)","v":12.1},2022,3]
[null,"2022-03-19","A",1234,4315,122.25,0.21,{"$f":"IF(ISNUMBER(I6),\"Betaald\",\"Openstaand\")","v":"Openstaand"},null,{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]*Table1[[#This Row],[BTW-TARIEF]],2)","v":25.67},{"$f":"ROUND(Table1[[#This Row],[BEDRAG  EXCL. BTW]]+Table1[[#This Row],[BTW BEDRAG]],2)","v":147.91999999999999},2022,3]

{"sheet":"Betalingen","index":1,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DATUM BETALING","REALATIE","OMSCHRIJVING","CATEGORIE","X","X","X","X","X","X","X","X","PINC","X","X","X","X","X","X"]
["2022-01-10","2022-03-01","HN",2021,4315,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAN"]
["2022-01-25","2022-03-04","MP",288,4603]
["2022-01-27","2022-03-08","A",250,4810]

{"sheet":"Lijsten","index":2,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Relatie",null,"Openstaand",null,"Btw-Tarief",null,"Categorie"]
["A",null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!1:1))-1.1),\"\")","v":250},null,0.06,null,4315]
["HN",null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!2:2))-1.1),\"\")","v":288},null,0.21,null,4603]
["MP",null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!3:3))-1.1),\"\")","v":2021},null,null,null,4810]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!4:4))-1.1),\"\")","v":1234}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!5:5))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!6:6))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!7:7))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!8:8))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!9:9))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!10:10))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!11:11))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!12:12))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!13:13))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!14:14))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!15:15))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!16:16))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!17:17))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!18:18))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!19:19))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!20:20))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!21:21))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!22:22))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!23:23))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!24:24))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!25:25))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!26:26))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!27:27))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!28:28))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!29:29))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!30:30))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!31:31))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!32:32))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!33:33))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!34:34))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!35:35))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!36:36))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!37:37))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!38:38))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!39:39))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!40:40))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!41:41))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!42:42))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!43:43))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!44:44))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!45:45))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!46:46))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!47:47))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!48:48))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!49:49))-1.1),\"\")","v":""}]
[null,null,{"$f":"IFERROR(INDEX(Table1[OMSCHRIJVING],SMALL(IF(Table1[STATUS]=\"Openstaand\",ROW(Table1[OMSCHRIJVING])),ROW(Inkoop!50:50))-1.1),\"\")","v":""}]