{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Basisgegevens","Menu","Verkopen","Aankopen","Leveranciers","Klanten","Factuur","Kwartaaloverzicht","Jaarrekening","BTW-aangifte","Afschrijvingstabel","vraag"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Basisgegevens","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Naam onderneming","Silouette"]
["Jaar boekhouding"]
["Straat","Leest"]
["Nummer",44]
["Postcode",2330]
["Gemeente","Merksplas"]
["KBO",123456789]
["IBAN","BE42733005279254"]
["BIC","KREDBEBB"]
[]
["BTW percentages",null,null,"Soort inkomsten",null,null,"Soort uitgaven"]
["Geen",0,null,1,"Retouche particulier",null,"Goederen"]
["Laag",0.06,null,2,"Retouche winkel",null,"Diensten"]
["Middel",0.12,null,3,"Verkopen ",null,"Investeringen"]
["Hoog",0.21,null,4]
[null,null,null,5]

{"sheet":"Menu","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TO DO"]
[null,"- factuur"]
[null,"- factuur laten boeken in verkopen"]
[null,"- afschrijvingstabel"]
[null,"- jaarrekening"]

{"sheet":"Verkopen","index":2,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Volgnr","Datum","Maand","Type Verkoop","klant","Bedrag incl BTW","BTW percentage","Bedrag\nexcl BTW","Bedrag BTW","Betaaldatum","Betalingswijze"]
[null,null,null,null,null,null,null,{"$f":"ROUND(F2/(1+G2),2)","v":0},{"$f":"F2-H2","v":0}]
[2013001,"2013-01-01",{"$f":"MONTH(B3)","v":1},null,null,121,0,{"$f":"ROUND(F3/(1+G3),2)","v":121},{"$f":"F3-H3","v":0}]
[2013002,"2013-02-01",{"$f":"MONTH(B4)","v":2},null,null,212,0.06,{"$f":"ROUND(F4/(1+G4),2)","v":200},12]
[2013003,"2013-03-01",{"$f":"MONTH(B5)","v":3},null,null,336,0.12,300,36]
[2013004,"2013-03-01",3,null,null,100,0.21,82.64,17.36]
[2013005,"2013-03-01",3,null,null,250,0.06,235.85,14.150000000000006]
[null,null,1,null,null,null,null,0,{"$f":"F8-H8","v":0}]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
[null,null,1,null,null,null,null,0,0]
["Totaal",null,null,null,null,{"$f":"SUBTOTAL(109,Verkopen!$F$3:$F$21)","v":1019},null,{"$f":"SUBTOTAL(109,Verkopen!$H$3:$H$21)","v":939.49},{"$f":"SUBTOTAL(109,Verkopen!$I$3:$I$21)","v":79.510000000000005}]

{"sheet":"Aankopen","index":3,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,10,0,14],[0,15,0,16]]}
[null,null,null,null,null,null,null,null,null,null,"BTW",null,null,null,null,"Personenbelasting"]
["Volgnr","Datum","Maand","Type","Leverancier","Omschrijving","Bedrag\nincl BTW","%\nPrivé","BTW %","Bedrag \nexcl BTW","Aftrekbaarheid\nBTW","Aftrekbare BTW","Kost + niet aftr BTW\nDiensten","Kost + niet aftr BTW\nGoederen","Kost + niet aftr BTW\nInvesteringen","Aftrekbaarheid \nPB","Aftrekbare\n kost","Betaaldatum","Betalingswijze"]
[null,"2013-09-09",{"$f":"MONTH(B3)","v":9},"Investeringen",null,"computer",800,0.5,0.21,{"$f":"ROUND((G3*H3)/(1+I3),2)","v":330.58},1,{"$f":"((G3*H3)-J3)*K3","v":69.420000000000016},{"$f":"IF($D$3=\"Diensten\",($J$3+((($G$3*$H$3)-$J$3)*(1-$K3))),0)","v":0},{"$f":"IF($D$3=\"Goederen\",($J$3+((($G$3*$H$3)-$J$3)*(1-$K3))),0)","v":0},{"$f":"IF($D$3=\"Investeringen\",($J$3+((($G$3*$H$3)-$J$3)*(1-$K3))),0)","v":330.58},1,{"$f":"IF(D3=\"Diensten\",M3,IF(D3=\"Goederen\",N3,0))*P3","v":0}]
[null,null,{"$f":"MONTH(B4)","v":1}]
[null,null,{"$f":"MONTH(B5)","v":1}]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
["Totaal",null,null,null,null,null,{"$f":"SUBTOTAL(109,Aankopen!$G$3:$G$21)","v":800},null,null,{"$f":"SUBTOTAL(109,Aankopen!$J$3:$J$21)","v":330.58},null,{"$f":"SUBTOTAL(109,Aankopen!$L$3:$L$21)","v":69.420000000000016},{"$f":"SUBTOTAL(109,Aankopen!$M$3:$M$21)","v":0},{"$f":"SUBTOTAL(109,Aankopen!$N$3:$N$21)","v":0},{"$f":"SUBTOTAL(109,Aankopen!$O$3:$O$21)","v":330.58},null,null,null,{"$f":"SUBTOTAL(103,Aankopen!$S$3:$S$21)","v":0}]

{"sheet":"Leveranciers","index":4,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","Naam","Voornaam","Straat","Nummer","Postcode","Gemeente","Telefoon","email","Type","Btw-nummer"]

{"sheet":"Klanten","index":5,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ID","Naam","Straat","Nummer","Postcode","Gemeente","Telefoon","email","Type","Btw-nummer"]
[null,"Veja","Veldenbergstraat",100,2330,"Merksplas"]
[null,"Romence","Gasthuisstraat",1,2340,"Beerse"]

{"sheet":"Factuur","index":6,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[12,1,12,4],[13,1,13,4],[14,1,14,4],[9,1,9,4],[11,1,11,4],[10,1,10,5]]}
[]
[null,null,null,null,null,"FACTUUR"]
[2013006,"2013-09-13",null,null,"Romence"]
[null,{"$f":"Basisgegevens!B5 &\" \"& Basisgegevens!B6","v":"Leest 44"},null,null,"Datum","2013-09-13"]
[null,{"$f":"Basisgegevens!B7 &\" \"& Basisgegevens!B8","v":"2330 Merksplas"},null,null,"Factuurnr.",2013006]
[null,{"$f":"Basisgegevens!A9 &\" \"& Basisgegevens!B9","v":"KBO 123456789"}]
[null,{"$f":"Basisgegevens!A10 &\" \"& Basisgegevens!B10","v":"IBAN BE42733005279254"}]
[null,{"$f":"Basisgegevens!A11 &\" \"& Basisgegevens!B11","v":"BIC KREDBEBB"}]
[]
[null,"Factureren aan:"]
[null,"Romence"]
[null,{"$f":"VLOOKUP(B11,Klanten!B2:F20,2)&\" \"&VLOOKUP(B11,Klanten!B2:F20,3)","v":"Gasthuisstraat 1"}]
[null,{"$f":"VLOOKUP(B11,Klanten!B2:F20,4)&\" \"&VLOOKUP(B11,Klanten!B2:F20,5)","v":"2340 Beerse"}]
[]
[]
[]
[null,"Aantal","Beschrijving","Prijs per eenheid","Excl BTW","Incl. btw"]
[null,10,"Artikelnummer 1",2,{"$f":"IF(COUNT(D18)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":20},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":24.2}]
[null,1,"Artikelnummer 2",2,{"$f":"IF(COUNT(D19)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":2},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":2.42}]
[null,1,"Artikelnummer 3",2,{"$f":"IF(COUNT(D20)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":2},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":2.42}]
[null,null,null,null,{"$f":"IF(COUNT(D21)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D22)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D23)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D24)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D25)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D26)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(COUNT(D27)=1,Tabel1[[#This Row],[Aantal]]*Tabel1[[#This Row],[Prijs per eenheid]],\"\")","v":""},{"$f":"IF(COUNT(Tabel1[[#This Row],[Excl BTW]])=1,Tabel1[[#This Row],[Excl BTW]]*1.21,\"\")","v":""}]
[]
[null,0.21,null,"Factuurtotaal incl.  BTW",null,{"$f":"IF(COUNT(Tabel1[Incl. btw])>0,SUM(Tabel1[Incl. btw]),\"\")","v":29.04}]
[null,null,null,"Btw-bedrag (21%)",null,{"$f":"IF(COUNT(F29)=1,F29*B29,\"\")","v":6.0983999999999998}]
[null,null,null,"Factuurtotaal excl. BTW",null,{"$f":"F29-F30","v":22.941600000000001}]

{"sheet":"Kwartaaloverzicht","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Fac"]

{"sheet":"Jaarrekening","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BTW-aangifte","index":9,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Kwartaal I","Kwartaal II","Kwartaal III","Kwartaal IV"]
[null,"Vak"]
[]
["Handelingen onderworpen aan het nultarief","00",{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=1\",Verkopen!$C$3:$C$21,\"<4\",Verkopen!$G$3:$G$21,\"0%\")","v":121},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=4\",Verkopen!$C$3:$C$21,\"<7\",Verkopen!$G$3:$G$21,\"0%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=7\",Verkopen!$C$3:$C$21,\"<10\",Verkopen!$G$3:$G$21,\"0%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=10\",Verkopen!$C$3:$C$21,\"<12\",Verkopen!$G$3:$G$21,\"0%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 6%","01",{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=1\",Verkopen!$C$3:$C$21,\"<4\",Verkopen!$G$3:$G$21,\"6%\")","v":435.85},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=4\",Verkopen!$C$3:$C$21,\"<7\",Verkopen!$G$3:$G$21,\"6%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=7\",Verkopen!$C$3:$C$21,\"<10\",Verkopen!$G$3:$G$21,\"6%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=10\",Verkopen!$C$3:$C$21,\"<12\",Verkopen!$G$3:$G$21,\"6%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 12%","02",{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=1\",Verkopen!$C$3:$C$21,\"<4\",Verkopen!$G$3:$G$21,\"12%\")","v":300},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=4\",Verkopen!$C$3:$C$21,\"<7\",Verkopen!$G$3:$G$21,\"12%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=7\",Verkopen!$C$3:$C$21,\"<10\",Verkopen!$G$3:$G$21,\"12%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=10\",Verkopen!$C$3:$C$21,\"<12\",Verkopen!$G$3:$G$21,\"12%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 21%","03",{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=1\",Verkopen!$C$3:$C$21,\"<4\",Verkopen!$G$3:$G$21,\"21%\")","v":82.64},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=4\",Verkopen!$C$3:$C$21,\"<7\",Verkopen!$G$3:$G$21,\"21%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=7\",Verkopen!$C$3:$C$21,\"<10\",Verkopen!$G$3:$G$21,\"21%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$3:$H$21,Verkopen!$C$3:$C$21,\">=10\",Verkopen!$C$3:$C$21,\"<12\",Verkopen!$G$3:$G$21,\"21%\")","v":0}]
["Creditnota's op handelingen eerder vermeld in de andere vakken",49,0,0,0,0]
[]
["Aankopen handelsgoederen, grond- en hulpstoffen    ",81,{"$f":"SUMIFS(Aankopen!$N$3:$N$21,Aankopen!$C$3:$C$21,\">=1\",Aankopen!$C$3:$C$21,\"<4\")","v":0},{"$f":"SUMIFS(Aankopen!$N$3:$N$21,Aankopen!$C$3:$C$21,\">=4\",Aankopen!$C$3:$C$21,\"<7\")","v":0},{"$f":"SUMIFS(Aankopen!$N$3:$N$21,Aankopen!$C$3:$C$21,\">=7\",Aankopen!$C$3:$C$21,\"<10\")","v":0},{"$f":"SUMIFS(Aankopen!$N$3:$N$21,Aankopen!$C$3:$C$21,\">=10\",Aankopen!$C$3:$C$21,\"<12\")","v":0}]
["Diensten, diverse goederen en andere    ",82,{"$f":"SUMIFS(Aankopen!$M$3:$M$21,Aankopen!$C$3:$C$21,\">=1\",Aankopen!$C$3:$C$21,\"<4\")","v":0},{"$f":"SUMIFS(Aankopen!$M$3:$M$21,Aankopen!$C$3:$C$21,\">=4\",Aankopen!$C$3:$C$21,\"<7\")","v":0},{"$f":"SUMIFS(Aankopen!$M$3:$M$21,Aankopen!$C$3:$C$21,\">=7\",Aankopen!$C$3:$C$21,\"<10\")","v":0},{"$f":"SUMIFS(Aankopen!$M$3:$M$21,Aankopen!$C$3:$C$21,\">=10\",Aankopen!$C$3:$C$21,\"<12\")","v":0}]
["Bedrijfsmiddelen        ",83,{"$f":"SUMIFS(Aankopen!$O$3:$O$21,Aankopen!$C$3:$C$21,\">=1\",Aankopen!$C$3:$C$21,\"<4\")","v":0},{"$f":"SUMIFS(Aankopen!$O$3:$O$21,Aankopen!$C$3:$C$21,\">=4\",Aankopen!$C$3:$C$21,\"<7\")","v":0},{"$f":"SUMIFS(Aankopen!$O$3:$O$21,Aankopen!$C$3:$C$21,\">=7\",Aankopen!$C$3:$C$21,\"<10\")","v":330.58},{"$f":"SUMIFS(Aankopen!$O$3:$O$21,Aankopen!$C$3:$C$21,\">=1\",Aankopen!$C$3:$C$21,\"<4\")","v":0}]
["Handelingen ontvangen creditnota's m.b.t. de andere   ",85,0,0,0,0]
[]
["Aftrekbare BTW       ",59,{"$f":"SUMIFS(Aankopen!$L$3:$L$21,Aankopen!$C$3:$C$21,\">=1\",Aankopen!$C$3:$C$21,\"<4\")","v":0},{"$f":"SUMIFS(Aankopen!$L$3:$L$21,Aankopen!$C$3:$C$21,\">=4\",Aankopen!$C$3:$C$21,\"<7\")","v":0},{"$f":"SUMIFS(Aankopen!$L$3:$L$21,Aankopen!$C$3:$C$21,\">=7\",Aankopen!$C$3:$C$21,\"<10\")","v":69.420000000000016},{"$f":"SUMIFS(Aankopen!$L$3:$L$21,Aankopen!$C$3:$C$21,\">=10\",Aankopen!$C$3:$C$21,\"<12\")","v":0}]
["Aftrekbare BTW wegens verstrekte creditnota's    ",64,0,0,0,0]
["Totaal aftrekbare BTW","YY",{"$f":"ROUND(SUM(C16:C17),2)","v":0},{"$f":"ROUND(SUM(D16:D17),2)","v":0},69.42,0]
[]
["Verschuldigde BTW op de omzet in vakken 00 01 02 03",54,{"$f":"SUMIFS(Verkopen!$I$3:$I$21,Verkopen!$C$3:$C$21,\">=1\",Verkopen!$C$3:$C$21,\"<4\")","v":79.510000000000005},{"$f":"SUMIFS(Verkopen!$I$3:$I$21,Verkopen!$C$3:$C$21,\">=4\",Verkopen!$C$3:$C$21,\"<7\")","v":0},{"$f":"SUMIFS(Verkopen!$I$3:$I$21,Verkopen!$C$3:$C$21,\">=7\",Verkopen!$C$3:$C$21,\"<10\")","v":0},{"$f":"SUMIFS(Verkopen!$I$3:$I$21,Verkopen!$C$3:$C$21,\">=10\",Verkopen!$C$3:$C$21,\"<12\")","v":0}]
["Verschuldigde BTW op ontvangen creditnota's    ",63,0,0,0,0]
[null,"XX",{"$f":"ROUND(SUM(C20:C21),2)","v":79.510000000000005},{"$f":"ROUND(SUM(D20:D21),2)","v":0},0,0]
["        "]
["Verschuldigde BTW",null,{"$f":"C22-C18","v":79.510000000000005},{"$f":"D22-D18","v":0},-69.42,0]
["- voorschotten"]
["+ interesten/boeten"]
["Totaal te betalen BTW",null,{"$f":"C24-C25+C26","v":79.510000000000005},{"$f":"D24-D25+D26","v":0},-69.42,0]

{"sheet":"Afschrijvingstabel","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Afsc"]

{"sheet":"vraag","index":11,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Doel is om een werkblad \"factuur\" te hebben (zie bijlage) waarin de gegevens worden ingevoerd. Op die pagina zouden dan 3 knoppen komen: factuurboeken, factuurdrukken,factuur leeg maken"]
[]
["Factuurboeken zou er voor moeten zorgen dat de velden F4, F5, B11, F29 en C27 gekopieerd worden naar het werkblad \"verkopen\"."]
["In dat werkblad zou de eerstvolgende lege rij moeten gezocht worden. Lijkt me het handigst dat er dan een extra rij ingevoerd wordt (dan schuift het totaal steeds mee op). "]
["Vervolgens zouden de gekopieerde cellen in de juiste kolom moeten komen (F4 = datum, F5 = factnr, B11 = klant, F29 = totaalbedrag, C27 = BTW-percentage) geplakt moeten worden."]
[]
[]
["Let op:","Op het Blad \"Verkopen\" is rij 2 verborgen, omdat deze rij gebruikt wordt om de formules te kopieren"]
[null,"Er wordt telkens een nieuwe Rij 3 ingevoegd, dus de bestaande gaan telkens een rij omlaag."]
[null,"De formules van de \"Subtotalen\" worden ook aangepast als er een rij ingevoegd is. "]
[null,"Volgens mij kun je deze totalen ook gewoon met de SOM formule berekenen, maar dat is aan jezelf. "]
[]
[null,"In je vraag staat dat er op C27 BTW-percentage zou moeten staan ?????"]
[null,"Waarom op \"Verkopen\" nog eens BTW berekenen, als dit al is gedaan op \"Factuur\""]
[null,"Beetje vreemd dat je in \"Verkopen\" het BTW kunt wijzigen"]
[]
[null,"factuurnummer kun je automatisch laten ophogen, tot een zelf in te stellen maximum, of bij begin nieuw jaar."]