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

{"sheet":"Kassaflödesrapport","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"merged":[[14,1,14,18],[39,1,39,18],[49,1,49,18]]}
[null,"Kassaflöde Rapport"]
[]
[null,"Räkenskapsåret inleds:",null,"(Inför) start",{"$f":"UPPER(TEXT(Räkenskapsårets_startdatum,\"MMM\"))","v":"JAN"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,1),\"MMM\"))","v":"FEB"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,2),\"MMM\"))","v":"MAR"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,3),\"MMM\"))","v":"APR"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,4),\"MMM\"))","v":"MAJ"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,5),\"MMM\"))","v":"JUN"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,6),\"MMM\"))","v":"JUL"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,7),\"MMM\"))","v":"AUG"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,8),\"MMM\"))","v":"SEP"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,9),\"MMM\"))","v":"OKT"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,10),\"MMM\"))","v":"NOV"},{"$f":"UPPER(TEXT(EOMONTH(Räkenskapsårets_startdatum,11),\"MMM\"))","v":"DEC"},null,"Summa"]
[null,"2012-01-05",null,"UPPSK",{"$f":"Räkenskapsårets_startdatum","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(Räkenskapsårets_startdatum)","v":"2012-12-05"},null,"UPPSK, post"]
[]
[null,"Kontanta medel (i början av månaden)",null,100,{"$f":"D51","v":100},{"$f":"E51","v":-125},45,-1,224,269,269,269,269,269,269,269,null,{"$f":"P6","v":269}]
[]
[null,"Inbetalningar"]
[]
[null,"Kontantförsäljning",null,null,125,120,130,100,{"$nulls":9},{"$f":"SUM(Inbetalningar[[#This Row],[Period 0]:[Period 12]])","v":475}]
[null,"Överföringar från krediterade konton",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(Inbetalningar[[#This Row],[Period 0]:[Period 12]])","v":120}]
[null,"Lån/övriga kassainflöden",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(Inbetalningar[[#This Row],[Period 0]:[Period 12]])","v":200}]
[null,"Summa",null,{"$f":"SUBTOTAL(109,Inbetalningar[Period 0])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 1])","v":175},{"$f":"SUBTOTAL(109,Inbetalningar[Period 2])","v":170},{"$f":"SUBTOTAL(109,Inbetalningar[Period 3])","v":180},{"$f":"SUBTOTAL(109,Inbetalningar[Period 4])","v":225},{"$f":"SUBTOTAL(109,Inbetalningar[Period 5])","v":45},{"$f":"SUBTOTAL(109,Inbetalningar[Period 6])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 7])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 8])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 9])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 10])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 11])","v":0},{"$f":"SUBTOTAL(109,Inbetalningar[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Inbetalningar[Summa])","v":795}]
[null,"Summa kontanta medel (före kassaräkning)",null,{"$f":"D6+SUM(Inbetalningar[Period 0])","v":100},{"$f":"E6+SUM(Inbetalningar[Period 1])","v":275},{"$f":"F6+SUM(Inbetalningar[Period 2])","v":45},{"$f":"G6+SUM(Inbetalningar[Period 3])","v":225},{"$f":"H6+SUM(Inbetalningar[Period 4])","v":224},{"$f":"I6+SUM(Inbetalningar[Period 5])","v":269},{"$f":"J6+SUM(Inbetalningar[Period 6])","v":269},{"$f":"K6+SUM(Inbetalningar[Period 7])","v":269},{"$f":"L6+SUM(Inbetalningar[Period 8])","v":269},{"$f":"M6+SUM(Inbetalningar[Period 9])","v":269},{"$f":"N6+SUM(Inbetalningar[Period 10])","v":269},{"$f":"O6+SUM(Inbetalningar[Period 11])","v":269},{"$f":"P6+SUM(Inbetalningar[Period 12])","v":269},null,{"$f":"R6+SUM(Inbetalningar[Summa])","v":1064}]
[]
[null,"Utbetalningar"]
[]
[null,"Inköp (varor)",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":626}]
[null,"Inköp (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Inköp (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Bruttolöner (exakta uttag)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Lönekostnader (arbetsgivaravgifter osv.)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Externa tjänster",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Förbrukningsmaterial (kontor och drift)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Reparationer och underhåll",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Annonsering",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Fordon, frakt och resor",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Redovisning och juridiska tjänster",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Hyra",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Telefon",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"El,  vatten och avfallshantering",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Försäkring",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Skatter (fastighetsskatt osv.)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Ränta",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Övriga utgifter (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Övrigt (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Övrigt (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Diverse",{"$nulls":15},{"$f":"SUM(Utbetalningar1[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Summa",null,{"$f":"SUBTOTAL(109,Utbetalningar1[Period 0])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 1])","v":400},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 2])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 3])","v":226},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 4])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 5])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 6])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 7])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 8])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 9])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 10])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 11])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar1[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Utbetalningar1[Summa])","v":626}]
[]
[null,"Utbetalningar (inte i resultaträkning)"]
[]
[null,"Kapitalkostnad",{"$nulls":15},{"$f":"SUM(Utbetalningar2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Investeringar (anges)",{"$nulls":15},{"$f":"SUM(Utbetalningar2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Övriga startkostnader",{"$nulls":15},{"$f":"SUM(Utbetalningar2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Reserv och/eller deposition",{"$nulls":15},{"$f":"SUM(Utbetalningar2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Eget uttag",{"$nulls":15},{"$f":"SUM(Utbetalningar2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Summa",null,{"$f":"SUBTOTAL(109,Utbetalningar2[Period 0])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 1])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 2])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 3])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 4])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 5])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 6])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 7])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 8])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 9])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 10])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 11])","v":0},{"$f":"SUBTOTAL(109,Utbetalningar2[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Utbetalningar2[Summa])","v":0}]
[null,"Summa utbetalningar",null,{"$f":"SUM(Utbetalningar1[Period 0],Utbetalningar2[Period 0])","v":0},{"$f":"SUM(Utbetalningar1[Period 1],Utbetalningar2[Period 1])","v":400},{"$f":"SUM(Utbetalningar1[Period 2],Utbetalningar2[Period 2])","v":0},{"$f":"SUM(Utbetalningar1[Period 3],Utbetalningar2[Period 3])","v":226},{"$f":"SUM(Utbetalningar1[Period 4],Utbetalningar2[Period 4])","v":0},{"$f":"SUM(Utbetalningar1[Period 5],Utbetalningar2[Period 5])","v":0},{"$f":"SUM(Utbetalningar1[Period 6],Utbetalningar2[Period 6])","v":0},{"$f":"SUM(Utbetalningar1[Period 7],Utbetalningar2[Period 7])","v":0},{"$f":"SUM(Utbetalningar1[Period 8],Utbetalningar2[Period 8])","v":0},{"$f":"SUM(Utbetalningar1[Period 9],Utbetalningar2[Period 9])","v":0},{"$f":"SUM(Utbetalningar1[Period 10],Utbetalningar2[Period 10])","v":0},{"$f":"SUM(Utbetalningar1[Period 11],Utbetalningar2[Period 11])","v":0},{"$f":"SUM(Utbetalningar1[Period 12],Utbetalningar2[Period 12])","v":0},null,{"$f":"SUM(Utbetalningar1[Summa],Utbetalningar2[Summa])","v":626}]
[]
[null,"Kassa (månadsslutet)",null,{"$f":"D14-D49","v":100},-125,45,-1,224,269,269,269,269,269,269,269,269,null,{"$f":"R14-R49","v":438}]