{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cashflowoverzicht"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Cashflowoverzicht","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[13,1,13,18],[37,1,37,18],[46,1,46,18]]}
[null,"CashflowAfschrift"]
[]
[null,"Fiscaal jaar begint:",null,"(Voor) Opstarten",{"$f":"UPPER(TEXT(BegindatumBoekjaar,\"mmm\"))","v":"JAN"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,1),\"mmm\"))","v":"FEB"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,2),\"mmm\"))","v":"MRT"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,3),\"mmm\"))","v":"APR"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,4),\"mmm\"))","v":"MEI"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,5),\"mmm\"))","v":"JUN"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,6),\"mmm\"))","v":"JUL"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,7),\"mmm\"))","v":"AUG"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,8),\"mmm\"))","v":"SEP"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,9),\"mmm\"))","v":"OKT"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,10),\"mmm\"))","v":"NOV"},{"$f":"UPPER(TEXT(EOMONTH(BegindatumBoekjaar,11),\"mmm\"))","v":"DEC"},null,"Totaal"]
[null,"2012-01-05",null,"GMT",{"$f":"BegindatumBoekjaar","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(BegindatumBoekjaar)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(BegindatumBoekjaar)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(BegindatumBoekjaar)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(BegindatumBoekjaar)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(BegindatumBoekjaar)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(BegindatumBoekjaar)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(BegindatumBoekjaar)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(BegindatumBoekjaar)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(BegindatumBoekjaar)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(BegindatumBoekjaar)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(BegindatumBoekjaar)","v":"2012-12-05"},null,"Item GMT"]
[]
[null,"Contanten in kas (begin van maand)",null,100,{"$f":"D48","v":100},{"$f":"E48","v":-125},45,-1,224,269,269,269,269,269,269,269,null,{"$f":"P6","v":269}]
[]
[null,"Kasontvangsten"]
[null,"Contante verkoop",null,null,125,120,130,100,{"$nulls":9},{"$f":"SUM(OntvangstbewijsContanten[[#This Row],[Periode 0]:[Periode 12]])","v":475}]
[null,"Geïnde rekeningen",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(OntvangstbewijsContanten[[#This Row],[Periode 0]:[Periode 12]])","v":120}]
[null,"Lening/andere contanten",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(OntvangstbewijsContanten[[#This Row],[Periode 0]:[Periode 12]])","v":200}]
[null,"Totaal",null,{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 0])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 1])","v":175},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 2])","v":170},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 3])","v":180},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 4])","v":225},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 5])","v":45},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 6])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 7])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 8])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 9])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 10])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 11])","v":0},{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Periode 12])","v":0},null,{"$f":"SUBTOTAL(109,OntvangstbewijsContanten[Totaal])","v":795}]
[null,"Totale beschikbare contanten (voor uitbetaling)",null,{"$f":"D6+SUM(OntvangstbewijsContanten[Periode 0])","v":100},{"$f":"E6+SUM(OntvangstbewijsContanten[Periode 1])","v":275},{"$f":"F6+SUM(OntvangstbewijsContanten[Periode 2])","v":45},{"$f":"G6+SUM(OntvangstbewijsContanten[Periode 3])","v":225},{"$f":"H6+SUM(OntvangstbewijsContanten[Periode 4])","v":224},{"$f":"I6+SUM(OntvangstbewijsContanten[Periode 5])","v":269},{"$f":"J6+SUM(OntvangstbewijsContanten[Periode 6])","v":269},{"$f":"K6+SUM(OntvangstbewijsContanten[Periode 7])","v":269},{"$f":"L6+SUM(OntvangstbewijsContanten[Periode 8])","v":269},{"$f":"M6+SUM(OntvangstbewijsContanten[Periode 9])","v":269},{"$f":"N6+SUM(OntvangstbewijsContanten[Periode 10])","v":269},{"$f":"O6+SUM(OntvangstbewijsContanten[Periode 11])","v":269},{"$f":"P6+SUM(OntvangstbewijsContanten[Periode 12])","v":269},null,{"$f":"R6+SUM(OntvangstbewijsContanten[Totaal])","v":1064}]
[]
[null,"Uitbetaalde contanten"]
[null,"Aankopen (koopwaar)",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":626}]
[null,"Aankopen (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Aankopen (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Brutolonen (exacte opnames)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Loonkosten (belastingen enz.)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Externe services",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Kantoorartikelen en dergelijke",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Reparaties en onderhoud",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Reclame",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Auto, bezorging en reizen",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Boekhouding en juridisch",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Huur",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Telefoon",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Gas, water, elektra",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Verzekeringen",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Belastingen (onroerend goed enz.)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Rente",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Overige uitgaven (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Overige (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Overige (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Diversen",{"$nulls":15},{"$f":"SUM(BetaaldInContanten[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Totaal",null,{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 0])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 1])","v":400},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 2])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 3])","v":226},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 4])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 5])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 6])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 7])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 8])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 9])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 10])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 11])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten[Periode 12])","v":0},null,{"$f":"SUBTOTAL(109,BetaaldInContanten[Totaal])","v":626}]
[]
[null,"Uitbetaalde contanten (geen W&V)"]
[null,"Betaling hoofdsom lening",{"$nulls":15},{"$f":"SUM(BetaaldInContanten2[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Kapitaalaankopen (specificeren)",{"$nulls":15},{"$f":"SUM(BetaaldInContanten2[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Overige opstartkosten",{"$nulls":15},{"$f":"SUM(BetaaldInContanten2[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Reserve en/of borg",{"$nulls":15},{"$f":"SUM(BetaaldInContanten2[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Opname van eigenaar",{"$nulls":15},{"$f":"SUM(BetaaldInContanten2[[#This Row],[Periode 0]:[Periode 12]])","v":0}]
[null,"Totaal",null,{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 0])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 1])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 2])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 3])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 4])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 5])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 6])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 7])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 8])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 9])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 10])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 11])","v":0},{"$f":"SUBTOTAL(109,BetaaldInContanten2[Periode 12])","v":0},null,{"$f":"SUBTOTAL(109,BetaaldInContanten2[Totaal])","v":0}]
[null,"Totaal uitbetaalde contanten",null,{"$f":"SUM(BetaaldInContanten[Periode 0],BetaaldInContanten2[Periode 0])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 1],BetaaldInContanten2[Periode 1])","v":400},{"$f":"SUM(BetaaldInContanten[Periode 2],BetaaldInContanten2[Periode 2])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 3],BetaaldInContanten2[Periode 3])","v":226},{"$f":"SUM(BetaaldInContanten[Periode 4],BetaaldInContanten2[Periode 4])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 5],BetaaldInContanten2[Periode 5])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 6],BetaaldInContanten2[Periode 6])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 7],BetaaldInContanten2[Periode 7])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 8],BetaaldInContanten2[Periode 8])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 9],BetaaldInContanten2[Periode 9])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 10],BetaaldInContanten2[Periode 10])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 11],BetaaldInContanten2[Periode 11])","v":0},{"$f":"SUM(BetaaldInContanten[Periode 12],BetaaldInContanten2[Periode 12])","v":0},null,{"$f":"SUM(BetaaldInContanten[Totaal],BetaaldInContanten2[Totaal])","v":626}]
[]
[null,"Cashpositie (einde van maand)",null,{"$f":"D13-D46","v":100},-125,45,-1,224,269,269,269,269,269,269,269,269,null,{"$f":"R13-R46","v":438}]