{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Info","Factuur ingave","Factuur print","Instellingen"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":17,"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":"Info","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Hoe starten?",null,null,null,null,null,null,"De werking zelf aanpassen?"]
[null,"1. Maak een account aan via recommand.eu en registreer je bedrijf",null,null,null,null,null,null,"Interesse om te zien hoe de Excel macro die voor de verzending zorgt werkt?"]
[null,"2. Maak hier een API sleutel aan",null,null,null,null,null,null,"Schakel je ontwikkelaarstools in in Excel, en klik in het ontwikkelaarstabblad op \"Visual Basic\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Vul deze samen met je bedrijfsgegevens in in het tabblad \"Instellingen\""]
[null,"4. Pas je factuur template eventueel aan via het tabblad \"Factuur print\""]
[null,"5. Stel een factuur op via het tabblad \"Factuur ingave\""]
[null,"6. Exporteer als PDF om te testen en verstuur je eerste factuur over het Peppol netwerk"]

{"sheet":"Factuur ingave","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Algemene informatie"]
[null,"Factuurnummer","VF002"]
[null,"Factuurdatum","2025-07-02"]
[null,"Vervaldatum",{"$f":"EDATE(issueDate, 1)","v":"2025-08-02"}]
[null,"Betalingsreferentie",{"$f":"invoiceNumber","v":"VF002"}]
[]
[null,"Klant"]
[null,"Klantnaam"]
[null,"BTW nummer"]
[null,"Peppol adres",{"$f":"IF(buyer_vatNumber=\"\", \"\", IF(LEFT(UPPER(buyer_vatNumber),2)<>\"BE\", \"❌ Enkel Belgische BTW-nummers worden ondersteund\", \"0208:\" & _xlfn.TEXTJOIN(\"\", TRUE, IF(ISNUMBER(FIND(MID(SUBSTITUTE(buyer_vatNumber,\"BE\",\"\"), ROW(INDIRECT(\"1:\" & LEN(buyer_vatNumber))), 1), \"0123456789\")), MID(SUBSTITUTE(buyer_vatNumber,\"BE\",\"\"), ROW(INDIRECT(\"1:\" & LEN(buyer_vatNumber))), 1), \"\"))))","v":""}]
[null,"Adres"]
[null,"Postcode"]
[null,"Gemeente"]
[null,"Land","BE"]
[]
[null,"Factuurlijnen"]
[null,"Artikel","Aantal","Eenheidsprijs excl.","BTW-percentage","Totaal excl.","Totaal incl."]
[null,"Brood",2,5,0.06,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":10},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":10.600000000000001}]
[null,"Bloemkool",3,4,0.06,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":12},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":12.72}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,null,null,null,null,{"$f":"invoiceLines[[#This Row],[Aantal]]*invoiceLines[[#This Row],[Eenheidsprijs excl.]]","v":0},{"$f":"invoiceLines[[#This Row],[Totaal excl.]]*(1+invoiceLines[[#This Row],[BTW-percentage]])","v":0}]
[null,"Totaal",{"$f":"SUBTOTAL(109,invoiceLines[Aantal])","v":5},null,null,{"$f":"SUBTOTAL(109,invoiceLines[Totaal excl.])","v":22},{"$f":"SUBTOTAL(109,invoiceLines[Totaal incl.])","v":23.32}]

{"sheet":"Factuur print","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,0,2,5]]}
[]
["Factuur XXX"]
[]
[]
[]
[{"$f":"Instellingen!C9","v":0},null,null,null,null,"Klantnaam"]
[{"$f":"Instellingen!C10","v":0},null,null,null,null,"BE123456789"]
[]
[{"$f":"Instellingen!C11","v":0},null,null,null,null,"Straat 1"]
[{"$f":"Instellingen!C12 & \" \" & Instellingen!C13","v":" "},null,null,null,null,"3990 Peer"]
["België",null,null,null,null,"BE"]
[]
["Factuurdatum: XXX - Vervaldatum: XXX"]
["Artikel","Aantal","Eenheidsprijs excl.","BTW-percentage","Totaal excl.","Totaal incl."]
["Artikel 1",1,10,0.21,10,12.1]
["Artikel 2",1,10,0.21,10,12.1]
[]
[null,null,null,null,"Totaal excl. BTW",20]
[null,null,null,null,"Totaal BTW",4.2]
[null,null,null,null,"Totaal incl. BTW",24.2]
[]
["Ons rekeningnummer is ."]
["Gelieve bij betaling referentie XXX te gebruiken."]
["Bedankt voor uw vertrouwen."]

{"sheet":"Instellingen","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Bedrijfsinstellingen",null,null,"Factuur opmerkingen"]
[null,"Bedrijfsnaam",null,null,"Tekst"]
[null,"BTW nummer",null,null,"Bedankt voor uw vertrouwen."]
[null,"Adres"]
[null,"Postcode"]
[null,"Gemeente"]
[null,"IBAN rekeningnummer"]
[]
[null,"Recommand instellingen"]
[null,"Company ID"]
[null,"API key"]
[null,"API secret"]