{"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":3,"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":27,"n_cols":11,"rows_kept":27,"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(F3/(1+G3),2)","v":0},{"$f":"F3-H3","v":0}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F4/(1+G4),2)","v":24},{"$f":"F4-H4","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,null,{"$f":"ROUND(F5/(1+G5),2)","v":29.04},{"$f":"F5-H5","v":0}]
[2013001,"2013-01-01",{"$f":"MONTH(B6)","v":1},null,null,121,0,{"$f":"ROUND(F6/(1+G6),2)","v":121},{"$f":"F6-H6","v":0}]
[2013002,"2013-02-01",{"$f":"MONTH(B7)","v":2},null,null,212,0.06,{"$f":"ROUND(F7/(1+G7),2)","v":200},{"$f":"F7-H7","v":12}]
[2013003,"2013-03-01",{"$f":"MONTH(B8)","v":3},null,null,336,0.12,{"$f":"ROUND(F8/(1+G8),2)","v":300},{"$f":"F8-H8","v":36}]
[2013004,"2013-03-01",{"$f":"MONTH(B9)","v":3},null,null,100,0.21,{"$f":"ROUND(F9/(1+G9),2)","v":82.64},{"$f":"F9-H9","v":17.36}]
[2013005,"2013-03-01",{"$f":"MONTH(B10)","v":3},null,null,250,0.06,{"$f":"ROUND(F10/(1+G10),2)","v":235.85},{"$f":"F10-H10","v":14.150000000000006}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F11/(1+G11),2)","v":24},{"$f":"F11-H11","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F12/(1+G12),2)","v":24},{"$f":"F12-H12","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F13/(1+G13),2)","v":24},{"$f":"F13-H13","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F14/(1+G14),2)","v":24},{"$f":"F14-H14","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F15/(1+G15),2)","v":24},{"$f":"F15-H15","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F16/(1+G16),2)","v":24},{"$f":"F16-H16","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F17/(1+G17),2)","v":24},{"$f":"F17-H17","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F18/(1+G18),2)","v":24},{"$f":"F18-H18","v":5.0399999999999991}]
[2013006,"2013-09-13",null,null,"Romence",29.04,0.21,{"$f":"ROUND(F19/(1+G19),2)","v":24},{"$f":"F19-H19","v":5.0399999999999991}]
[null,null,{"$f":"MONTH(B20)","v":1},null,null,null,null,{"$f":"ROUND(F20/(1+G20),2)","v":0},{"$f":"F20-H20","v":0}]
[null,null,{"$f":"MONTH(B21)","v":1},null,null,null,null,{"$f":"ROUND(F21/(1+G21),2)","v":0},{"$f":"F21-H21","v":0}]
[null,null,{"$f":"MONTH(B22)","v":1},null,null,null,null,{"$f":"ROUND(F22/(1+G22),2)","v":0},{"$f":"F22-H22","v":0}]
[null,null,{"$f":"MONTH(B23)","v":1},null,null,null,null,{"$f":"ROUND(F23/(1+G23),2)","v":0},{"$f":"F23-H23","v":0}]
[null,null,{"$f":"MONTH(B24)","v":1},null,null,null,null,{"$f":"ROUND(F24/(1+G24),2)","v":0},{"$f":"F24-H24","v":0}]
[null,null,{"$f":"MONTH(B25)","v":1},null,null,null,null,{"$f":"ROUND(F25/(1+G25),2)","v":0},{"$f":"F25-H25","v":0}]
[null,null,{"$f":"MONTH(B26)","v":1},null,null,null,null,{"$f":"ROUND(F26/(1+G26),2)","v":0},{"$f":"F26-H26","v":0}]
["Totaal",null,null,null,null,{"$f":"SUM(F5:F26)","v":1309.3999999999996},null,{"$f":"SUM(H5:H26)","v":1184.53},{"$f":"SUM(I5:I26)","v":124.86999999999995}]

{"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,"Romence","Gasthuisstraat",1,2340,"Beerse"]
[null,"Veja","Veldenbergstraat",100,2330,"Merksplas"]

{"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]
[null,{"$f":"Basisgegevens!B5 &\" \"& Basisgegevens!B6","v":"Leest 44"},null,null,"Datum","2013-09-14"]
[null,{"$f":"Basisgegevens!B7 &\" \"& Basisgegevens!B8","v":"2330 Merksplas"},null,null,"Factuurnr.",2013023]
[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,{"$f":"VLOOKUP(B11,Klanten!B2:F20,2)&\" \"&VLOOKUP(B11,Klanten!B2:F20,3)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(B11,Klanten!B2:F20,4)&\" \"&VLOOKUP(B11,Klanten!B2:F20,5)","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Aantal","Beschrijving","Prijs per eenheid","Excl BTW","Incl. btw"]
[null,null,null,null,{"$f":"IF(COUNT(D18)=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(D19)=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(D20)=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(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,"BTW-percentage",0.21,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,null,null,"Factuurtotaal incl.  BTW",null,{"$f":"IF(COUNT(Tabel1[Incl. btw])>0,SUM(Tabel1[Incl. btw]),\"\")","v":""}]
[null,null,null,"Btw-bedrag (21%)",null,{"$f":"IF(COUNT(F29)=1,F29*C27,\"\")","v":""}]
[null,null,null,"Factuurtotaal excl. BTW",null,{"$f":"F29-F30","v":{"$error":"#VALUE!"}}]

{"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$15:$H$26,Verkopen!$C$15:$C$26,\">=1\",Verkopen!$C$15:$C$26,\"<4\",Verkopen!$G$15:$G$26,\"0%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=4\",Verkopen!$C$15:$C$26,\"<7\",Verkopen!$G$15:$G$26,\"0%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=7\",Verkopen!$C$15:$C$26,\"<10\",Verkopen!$G$15:$G$26,\"0%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=10\",Verkopen!$C$15:$C$26,\"<12\",Verkopen!$G$15:$G$26,\"0%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 6%","01",{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=1\",Verkopen!$C$15:$C$26,\"<4\",Verkopen!$G$15:$G$26,\"6%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=4\",Verkopen!$C$15:$C$26,\"<7\",Verkopen!$G$15:$G$26,\"6%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=7\",Verkopen!$C$15:$C$26,\"<10\",Verkopen!$G$15:$G$26,\"6%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=10\",Verkopen!$C$15:$C$26,\"<12\",Verkopen!$G$15:$G$26,\"6%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 12%","02",{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=1\",Verkopen!$C$15:$C$26,\"<4\",Verkopen!$G$15:$G$26,\"12%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=4\",Verkopen!$C$15:$C$26,\"<7\",Verkopen!$G$15:$G$26,\"12%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=7\",Verkopen!$C$15:$C$26,\"<10\",Verkopen!$G$15:$G$26,\"12%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=10\",Verkopen!$C$15:$C$26,\"<12\",Verkopen!$G$15:$G$26,\"12%\")","v":0}]
["Handelingen onderworpen aan de belastingen van 21%","03",{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=1\",Verkopen!$C$15:$C$26,\"<4\",Verkopen!$G$15:$G$26,\"21%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=4\",Verkopen!$C$15:$C$26,\"<7\",Verkopen!$G$15:$G$26,\"21%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=7\",Verkopen!$C$15:$C$26,\"<10\",Verkopen!$G$15:$G$26,\"21%\")","v":0},{"$f":"SUMIFS(Verkopen!$H$15:$H$26,Verkopen!$C$15:$C$26,\">=10\",Verkopen!$C$15:$C$26,\"<12\",Verkopen!$G$15:$G$26,\"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$15:$I$26,Verkopen!$C$15:$C$26,\">=1\",Verkopen!$C$15:$C$26,\"<4\")","v":0},{"$f":"SUMIFS(Verkopen!$I$15:$I$26,Verkopen!$C$15:$C$26,\">=4\",Verkopen!$C$15:$C$26,\"<7\")","v":0},{"$f":"SUMIFS(Verkopen!$I$15:$I$26,Verkopen!$C$15:$C$26,\">=7\",Verkopen!$C$15:$C$26,\"<10\")","v":0},{"$f":"SUMIFS(Verkopen!$I$15:$I$26,Verkopen!$C$15:$C$26,\">=10\",Verkopen!$C$15:$C$26,\"<12\")","v":0}]
["Verschuldigde BTW op ontvangen creditnota's    ",63,0,0,0,0]
[null,"XX",{"$f":"ROUND(SUM(C20:C21),2)","v":0},{"$f":"ROUND(SUM(D20:D21),2)","v":0},0,0]
["        "]
["Verschuldigde BTW",null,{"$f":"C22-C18","v":0},{"$f":"D22-D18","v":0},-69.42,0]
["- voorschotten"]
["+ interesten/boeten"]
["Totaal te betalen BTW",null,{"$f":"C24-C25+C26","v":0},{"$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":28,"n_cols":2,"rows_kept":28,"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."]
[]
["Antwoorden"]
[]
[null,"ik heb de \"subtotalen\" inderdaad vervangen door SOM. In eerste instantie had ik het bereik omgevormd naar een tabel en dan subtotalen gebruikt. Tabellen blijken wel wat beperkingen te geven. Dus heb ik dit terug gewijzigd"]
[null,"C27 heb ik terug gezet en gekoppeld aan de lijst met mogelijke percentages. Je weet maar nooit dat we toch ooit andere percentages krijgen."]
[null,"In verkopen heb ik terug gerekend omdat de formules er toch staan. Er zijn immers ook kasverkopen die hierin genoteerd worden. (geen factuurnummer)"]
[null,"factuurnummer heb ik automatisch laten verhogen na de knop \"nieuw factuur\""]
[null,"datum laat ik ook automatisch invullen"]
[null,"factuur drukken maakt een pdf-aan op een locatie die ik zelf kies (voorlopig een map op gezet maar kan ik dus nog wijzigen)"]
[null,"factuurnummers hebben geen beperking. Ik zelf handmatig jaarlijst terug beginnen van JJJJ0001 of zo"]
[null,"Het is inderdaad niet de bedoeling dat het document groter wordt dan hetgeen het nu is. Vermoedelijk zal dat ook niet gebeuren. Ik weet echter niet goed hoe ik dat moet beperken."]