{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["algemene instellingen","Verkoopfactuur","Verkoop & Opbrengsten","Inkoop & Uitgaven","Debiteuren","data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":12,"comments":1,"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":"algemene instellingen","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Algemene instellingen"]
[]
[null,"Algemene gegevens"]
[null,"Bedrijfsnaam","ABC"]
[null,"Adres","ABCDEE"]
[null,"Postcode","1234 Bs"]
[null,"Plaats","AAAAAAA"]
[null,"Telefoonnummer","06-123456789"]
[null,"Fax"]
[null,"E-mail","1234@4569.nl"]
[null,"Website 1","www.adfaygfk.nl"]
[null,"website 2"]
[null,"website 3"]
[]
[]
[null,"Betaalgegevens"]
[null,"BTW nummer"]
[null,"Bic / Swift"]
[null,"Bank"]
[null,"Rekeningnummer"]
[null,"KvK nummer"]
[]
[]
[null,"Voorwaarden"]
[null,"Algemene voorwaarden tekst"]
[null,"extra voorwaarden"]
[null,"Aanvullende betalingsvoorwaarden factuur"]
[null,"Aanvullende betalingsvoorwaarden factuur herinnering"]
[null,"aanvullende betalingsvoorwaarden factuur aanmaning"]
[null,"Creditnota"]

{"sheet":"Verkoopfactuur","index":1,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,6,35,7],[36,6,36,7],[29,6,29,7],[30,6,30,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[43,0,43,9],[17,1,17,3],[28,1,28,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[18,1,18,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[41,0,41,9],[40,0,40,9],[39,0,39,9],[38,0,38,9],[42,0,42,9],[17,12,17,13],[24,12,24,13],[17,7,17,8],[9,4,9,5],[0,5,0,9]]}
[{"$f":"'algemene instellingen'!C4","v":"ABC"},null,null,null,null,{"$f":"N30","v":"Factuur"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Opmerking voor afdrukken"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Afdrukinstellingen: "]
[{"$f":"'algemene instellingen'!C5","v":"ABCDEE"},null,null,null,null,null,null,null,null,null,null,null,"Afdrukken"]
[{"$f":"'algemene instellingen'!C6&\"\"&'algemene instellingen'!C7&\"\"","v":"1234 BsAAAAAAA"},null,null,null,null,null,null,null,null,null,null,null,"*Selecteer actief blad"]
[{"$f":"'algemene instellingen'!C10","v":"1234@4569.nl"},null,null,null,null,null,null,null,null,null,null,null,"Schalen"]
[{"$f":"'algemene instellingen'!C8","v":"06-123456789"},null,null,null,null,null,null,null,null,null,null,null,"*Selecteer blad passend maken"]
[]
[]
["Factuuradres:",{"$f":"VLOOKUP(E12,klantenlijst,2,0)","v":"bedrijf 1"},null,"Datum:",{"$f":"N26","v":"00:00:00"}]
[null,{"$f":"VLOOKUP(E12,klantenlijst,3,0)","v":"voorbeeld 1"},null,"Factuurnr.:",{"$f":"N27","v":2018008}]
[null,{"$f":"VLOOKUP(E12,klantenlijst,4,0)","v":"1234 AC dorp"},null,"Debiteuren nr.:",{"$f":"N28","v":1}]
[null,{"$f":"VLOOKUP(E12,klantenlijst,5,0)","v":0},null,{"$f":"IF(F1=Q25,Q18,Q19)","v":"Vervaldatum"},{"$f":"IF(F1=Q25,E10+VLOOKUP(E12,klantenlijst,6,0),data!L8)","v":"1900-01-30"}]
[null,null,null,{"$f":"IF(F1=Q25,\"\",\"Nieuwe betaaldatum\")","v":""},{"$f":"IF(F1=Q25,\"\",E13+15)","v":""}]
[]
[]
[]
["HOEVEELHEID","BESCHRIJVING",null,null,"PRIJS PER EENHEID","BTW-Tarief",{"$f":"IF(N29=Q29,\"Korting\",\"Commissie\")","v":"Korting"},{"$f":"IF(N29=Q29,\"Korting bedrag\",\"Commissie bedrag\")","v":"Korting bedrag"},null,"BEDRAG",null,null,"Lijst met gegevens",null,null,null,"Vervaldatum"]
[10,"sgweswtgyse",null,null,100,0.21,0.1,{"$f":"IF(G19>0%,J19*G19,\"\")","v":100},{"$f":"IF(G19>0%,J19-H19,\"\")","v":900},{"$f":"(A19*E19)","v":1000},null,null,"BTW-tarief",{"$f":"IF(N29=Q29,Q29,Q30)","v":"KORTING"},null,null,"Org. Vervaldatum"]
[10,null,null,null,20,"BTW VERLEGD",0.3,{"$f":"IF(G20>0%,J20*G20,\"\")","v":60},{"$f":"IF(G20>0%,J20-H20,\"\")","v":140},{"$f":"(A20*E20)","v":200},null,null,"BTW VERLEGD",0.05]
[10,null,null,null,20,0.06,null,"","",200,null,null,0,0.1]
[10,null,null,null,10,0,null,"","",100,null,null,0.06,0.15]
[null,null,null,null,null,null,null,"","",0,null,null,0.21,0.3]
[null,null,null,null,null,null,null,"","",0]
[null,null,null,null,null,null,null,"","",0,null,null,"Keuze menu",null,null,null,"Factuur"]
[null,null,null,null,null,null,null,"","",0,null,null,"Factuurdatum",null,null,null,"Herinnering"]
[null,null,null,null,null,null,null,"","",0,null,null,"Factuurnummer",2018008,null,null,"Aanmaning"]
[null,null,null,null,null,null,null,"","",0,null,null,"Debiteurnummer",1]
[{"$f":"IF(F1=Q27,1,\"\")","v":""},{"$f":"IF(F1=Q27,\"Aanmaningskosten\",\"\")","v":""},null,null,{"$f":"IF(F1=Q27,(N31/1.21),\"\")","v":""},{"$f":"IF(F1=Q27,21%,\"\")","v":""},null,"","",{"$f":"IF(F1=Q27,(A29*E29),)","v":0},null,null,"Korting/ Commissie","KORTING",null,null,"KORTING"]
[{"$f":"IF(F1=Q25,\"\",\"Opmerking\")","v":""},null,null,null,null,null,"SUBTOTAAL",null,null,{"$f":"SUM(J19:J29)","v":1500},null,null,"Soort factuur","Factuur",null,null,"COMMISSIE"]
[{"$f":"IF(F1=Q25,\"\",IF(F1=Q26,'algemene instellingen'!C29,'algemene instellingen'!C29))","v":""},null,null,null,null,null,{"$f":"IF(N29=Q29,Q29,Q30)","v":"KORTING"},null,null,{"$f":"SUM(H19:H29)","v":160},null,null,"Aanmaningskosten exclusief BTW",17.5]
[{"$f":"IF(F1=Q25,\"\",IF(F1=Q26,'algemene instellingen'!C28,'algemene instellingen'!C27))","v":""},null,null,null,null,null,null,"BTW VERLEGD",{"$f":"(SUMIF(F18:F28,\"=BTW VERLEGD\",J18:J28)-SUMIF(F18:F28,\"=BTW VERLEGD\",H18:H28))","v":140},{"$f":"(SUMIF(F18:F28,\"BTW VERLEGD\",J18:J28)-SUMIF(F18:F28,\"BTW VERLEGD\",H18:H28))*0","v":0}]
[null,null,null,{"$f":"IF(I32>0,\"Let op BTW Verlegd !\",\"\")","v":"Let op BTW Verlegd !"},null,null,"0% BTW",null,{"$f":"(SUMIF(F19:F29,\"=0%\",J19:J29)-SUMIF(F19:F29,\"=0%\",H19:H29))","v":100},{"$f":"(SUMIF(F19:F29,\"=0%\",J19:J29)-SUMIF(F19:F29,\"=0%\",H19:H29))*0","v":0}]
[null,null,null,null,null,null,"6% BTW",null,{"$f":"(SUMIF(F19:F29,\"=6%\",J19:J29)-SUMIF(F19:F29,\"=6%\",H19:H29))","v":200},{"$f":"(SUMIF(F19:F29,\"=6%\",J19:J29)-SUMIF(F19:F29,\"=6%\",H19:H29))*0.06","v":12}]
[null,null,null,null,null,null,"21% BTW ",null,{"$f":"(SUMIF(F19:F29,\"=21%\",J19:J29)-SUMIF(F19:F29,\"=21%\",H19:H29))","v":900},{"$f":"(SUMIF(F19:F29,\"=21%\",J19:J29)-SUMIF(F19:F29,\"=21%\",H19:H29))*0.21","v":189}]
[null,null,null,null,null,null,"VERZENDKOSTEN"]
[null,null,null,null,null,null,"TOTAAL",null,null,{"$f":"J30-J31+J33+J35+J34+J36","v":1541}]
[]
[{"$f":"data!D25","v":"U wordt verzocht het vermelde bedrag binnen 30 dagen over te maken op  bankrekeningnummer NL80INGB00006051477, onder vermelding van het factuurnummer."}]
[{"$f":"data!D26","v":"MARITFOOD is het moederconcern van COUSCOUSOFZO en PAKPASTA"}]
[{"$f":"'algemene instellingen'!C11&\" |\"&'algemene instellingen'!C12&\"|\"&'algemene instellingen'!C13&\"\"","v":"www.adfaygfk.nl ||"}]
[{"$f":"'algemene instellingen'!B20&\" \"&'algemene instellingen'!C20&\" | \"&'algemene instellingen'!B18&\" \"&'algemene instellingen'!C18&\" | \"&'algemene instellingen'!B21&\" \"&'algemene instellingen'!C21&\" | \"&'algemene instellingen'!B17&\" \"&'algemene instellingen'!C17&\"\"","v":"Rekeningnummer  | Bic / Swift  | KvK nummer  | BTW nummer "}]
[{"$f":"'algemene instellingen'!C25","v":0}]
[{"$f":"'algemene instellingen'!C26","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"N26","v":"00:00:00"},{"$f":"N30","v":"Factuur"},{"$f":"N27","v":2018008},{"$f":"B10","v":"bedrijf 1"},{"$f":"J30","v":1500},{"$f":"J32","v":0},{"$f":"J33","v":0},{"$f":"J34","v":12},{"$f":"J35","v":189},{"$f":"J37","v":1541}]

{"sheet":"Verkoop & Opbrengsten","index":2,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Verkoop & Opbrengsten"]
[]
[null,"Datum","Soort","Factuurnummer","Relatie","excl. Bedrag","Btw verlegd","Btw 0"," Btw 6","Btw 21","Totaal bedrag","Catergorie"]
[null,0,"Factuur",2018007,"Bedrijf 5",1500,0,0,12,189,1541]
[null,"1900-01-23","Factuur",2018008,"Bedrijf 5",1500,0,0,12,189,1541]

{"sheet":"Inkoop & Uitgaven","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Debiteuren","index":4,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Nr","Naam","Adres","Postcode en Plaats","BTW nummer","Betaaltermijn (dagen)"]
[1,"bedrijf 1","voorbeeld 1","1234 AC dorp",null,30]
[{"$f":"A2+1","v":2},"Bedrijf 2","Voorbeeldlaan 2","1235 AB STAD",null,30]
[3,"bedrijf 3","Voorbeeldlaan 3","1236 AB STAD",null,16]
[4,"Bedrijf 4","Voorbeeldlaan 4","1237 AB STAD",null,22]
[5,"Bedrijf 5","Voorbeeldlaan 5","1238 AB STAD",null,23]
[6,"Bedrijf 6","Voorbeeldlaan 6","1239 AB STAD",null,24]
[7,"Bedrijf 7","Voorbeeldlaan 7","1240 AB STAD",null,25]
[8,"Bedrijf 8","Voorbeeldlaan 8","1241 AB STAD",null,26]
[9,"Bedrijf 9","Voorbeeldlaan 9","1242 AB STAD",null,27]
[10,"Bedrijf 10","Voorbeeldlaan 10","1243 AB STAD",null,28]
[11,"Bedrijf 11","Voorbeeldlaan 11","1244 AB STAD",null,29]
[12,"Bedrijf 12","Voorbeeldlaan 12","1245 AB STAD",null,30]
[13,"Bedrijf 13","Voorbeeldlaan 13","1246 AB STAD",null,31]
[14,"Bedrijf 14","Voorbeeldlaan 14","1247 AB STAD",null,32]
[15,"Bedrijf 15","Voorbeeldlaan 15","1248 AB STAD",null,33]
[16,"Bedrijf 16","Voorbeeldlaan 16","1249 AB STAD",null,34]
[17,"Bedrijf 17","Voorbeeldlaan 17","1250 AB STAD",null,35]
[18,"Bedrijf 18","Voorbeeldlaan 18","1251 AB STAD",null,36]
[19,"Bedrijf 19","Voorbeeldlaan 19","1252 AB STAD",null,37]
[20,"Bedrijf 20","Voorbeeldlaan 20","1253 AB STAD",null,38]
[21,"Bedrijf 21","Voorbeeldlaan 21","1254 AB STAD",null,39]
[22,"Bedrijf 22","Voorbeeldlaan 22","1255 AB STAD",null,40]
[23,"Bedrijf 23","Voorbeeldlaan 23","1256 AB STAD",null,41]
[24,"Bedrijf 24","Voorbeeldlaan 24","1257 AB STAD",null,42]
[25,"Bedrijf 25","Voorbeeldlaan 25","1258 AB STAD",null,43]
[26,"Bedrijf 26","Voorbeeldlaan 26","1259 AB STAD",null,44]
[27,"Bedrijf 27","Voorbeeldlaan 27","1260 AB STAD",null,45]
[28,"Bedrijf 28","Voorbeeldlaan 28","1261 AB STAD",null,46]
[29,"Bedrijf 29","Voorbeeldlaan 29","1262 AB STAD",null,47]
[30,"Bedrijf 30","Voorbeeldlaan 30","1263 AB STAD",null,48]
[31,"Bedrijf 31","Voorbeeldlaan 31","1264 AB STAD",null,49]
[32,"Bedrijf 32","Voorbeeldlaan 32","1265 AB STAD",null,50]
[33,"Bedrijf 33","Voorbeeldlaan 33","1266 AB STAD",null,51]
[34,"Bedrijf 34","Voorbeeldlaan 34","1267 AB STAD",null,52]
[{"$f":"A35+1","v":35},"Bedrijf 35","Voorbeeldlaan 35","1268 AB STAD",null,53]
[{"$f":"A36+1","v":36}]

{"sheet":"data","index":5,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,3,24,17],[25,3,25,10],[13,3,13,37],[14,3,14,34]]}
[]
[]
[]
[null,null,"factuurinstelling"]
[null,null,1,"Factuurtekst","tekst1","waarde1","tekst2","waarde2","tekst4","waarde4","tekst5","waarde5","tekst6","waarde6"]
[null,null,1,"FACTUUR","DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"},"FACTUURNR.:",{"$f":"Verkoopfactuur!N27","v":2018008},"DEBITEUR NR. :",{"$f":"Verkoopfactuur!N28","v":1},"VERVALDATUM:",{"$f":"F6+VLOOKUP(J6,klantenlijst,6)","v":"1900-01-30"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,2,"KOPIE-FACTUUR","DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"},"FACTUURNR.:",{"$f":"Verkoopfactuur!N27","v":2018008},"DEBITEUR NR. :",{"$f":"Verkoopfactuur!N28","v":1},"VERVALDATUM:",{"$f":"F7+VLOOKUP(J7,klantenlijst,6)","v":"1900-01-30"},{"$f":"\"\"","v":""},{"$f":"\"\"","v":""}]
[null,null,3,"HERINNERING","DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"},"FACTUURNR.:",{"$f":"Verkoopfactuur!N27","v":2018008},"DEBITEUR NR. :",{"$f":"Verkoopfactuur!N28","v":1},"ORG. VERVALDATUM:",{"$f":"F8+VLOOKUP(J8,klantenlijst,6)","v":"1900-01-30"},"ORG. FACT. DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"}]
[null,null,4,"AANMANING","DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"},"FACTUURNR.:",{"$f":"Verkoopfactuur!N27","v":2018008},"DEBITEUR NR. :",{"$f":"Verkoopfactuur!N28","v":1},"ORG. VERVALDATUM:",{"$f":"F9+VLOOKUP(J9,klantenlijst,6)","v":"1900-01-30"},"ORG. FACT. DATUM:",{"$f":"Verkoopfactuur!N26","v":"00:00:00"}]
[]
[null,null,"factuurtekst",null," "," "," "," "," "," "," "," "," "," "]
[null,null,1,{"$f":"IF(Bedragincl>0,\"U wordt verzocht het factuurbedrag bedrag binnen \"&L6-F6&\" dagen over te maken op \"&'algemene instellingen'!C19&\" rekening nummer \"&'algemene instellingen'!C20&\" t.n.v. \"&'algemene instellingen'!C4&\" \"&'algemene instellingen'!C7&\" o.v.v. factuurnummer \"&Verkoopfactuur!E11&\".\")","v":"U wordt verzocht het factuurbedrag bedrag binnen 30 dagen over te maken op  rekening nummer  t.n.v. ABC AAAAAAA o.v.v. factuurnummer 2018008."}]
[null,null,2,{"$f":"IF(Bedragincl>0,\"U wordt verzocht het factuurbedrag bedrag binnen \"&L6-F6&\" dagen over te maken op \"&'algemene instellingen'!C19&\" rekening nummer \"&'algemene instellingen'!C20&\" t.n.v. \"&'algemene instellingen'!C4&\" \"&'algemene instellingen'!C7&\" o.v.v. factuurnummer \"&Verkoopfactuur!E11&\". \"&'[1]Algemene instellingen'!E17,'[1]Algemene instellingen'!E18)","v":"U wordt verzocht het factuurbedrag bedrag binnen 30 dagen over te maken op  rekening nummer  t.n.v. ABC AAAAAAA o.v.v. factuurnummer 2018008. "}]
[null,null,3,{"$f":"\"U wordt verzocht het factuurbedrag bedrag binnen \"&L8-N8&\" dagen over te maken op \"&'algemene instellingen'!C19&\" rekening nummer \"&'algemene instellingen'!C20&\" t.n.v. \"&'algemene instellingen'!C4&\" \"&'algemene instellingen'!C7&\" o.v.v. factuurnummer \"&Verkoopfactuur!E11&\".Indien u niet binnen deze termijn betaald, zal er € 17,50 administratiekosten in rekening worden gebracht. \"","v":"U wordt verzocht het factuurbedrag bedrag binnen 30 dagen over te maken op  rekening nummer  t.n.v. ABC AAAAAAA o.v.v. factuurnummer 2018008.Indien u niet binnen deze termijn betaald, zal er € 17,50 administratiekosten in rekening worden gebracht. "}]
[null,null,4,{"$f":"\"U wordt verzocht het factuurbedrag bedrag binnen \"&L8-N8&\" dagen over te maken op \"&'algemene instellingen'!C19&\" rekening nummer \"&'algemene instellingen'!C20&\" t.n.v. \"&'algemene instellingen'!C4&\" \"&'algemene instellingen'!C7&\" o.v.v. factuurnummer \"&Verkoopfactuur!E11&\". \"&'algemene instellingen'!C27&\" \"","v":"U wordt verzocht het factuurbedrag bedrag binnen 30 dagen over te maken op  rekening nummer  t.n.v. ABC AAAAAAA o.v.v. factuurnummer 2018008.  "}]
[]
[null,null,"factuurtitel"]
[]
[null,null,{"$f":"VLOOKUP(factuurtypen,factuurgegevens,2)&\" \"&VLOOKUP(factuurtypen,factuurgegevens,6)","v":"FACTUUR 2018008"}]
[]
[null,null,{"$f":"VLOOKUP(factuurtype,factuurinstelling,2)&\" \"&VLOOKUP(factuurtype,factuurinstelling,6)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"factuurtekst"]
[null,null,1,"U wordt verzocht het vermelde bedrag binnen 30 dagen over te maken op  bankrekeningnummer NL80INGB00006051477, onder vermelding van het factuurnummer."]
[null,null,null,"MARITFOOD is het moederconcern van COUSCOUSOFZO en PAKPASTA"]