{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vejledning","Mapping std kontoplan","Upload fil til kundecenter"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Vejledning","index":0,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[[4,1,4,8],[10,4,11,7]]}
[]
[]
[]
[]
[null,"Opdatere modellen"]
[]
[null,null,null,null,"Formål"]
[null,null,null,null,"At kunne mappe (kortlægge) sine finanskonti i e-conomic til Keepers' kube for e-conomic regnskaber"]
[]
[null,null,1,null,"Hent kontoplanen fra din e-conomic aftale via regnskab -> søgning og lister -> kontoplan"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Gem i Excel via eksport knappen"]
[]
[null,null,2,null,"Indsæt dine finanskonti eksklusive sumkonti etc. i fanen \"Mapping Std kontoplan\" i kolonne A og B"]
[null,null,null,null,"Et tip kan her være at filterere på kolonne C i udtrækket fra e-conomic, så du kun kan se \"Drift\" og \"Balance\""]
[]
[null,null,3,null,"Klarlæg dine rapporeringskategorier og påfør dem i fanen \"Mapping Std kontoplan\" området G:Q"]
[null,null,null,null,"NB! Områet med summeringer kan variere og det kan være en fordel at benytte samme struktur."]
[null,null,null,null,"Årsagen er at sortering i Power BI eller generelt i pivottabeller er nemmere at sortere i dette format"]
[]
[null,null,4,null,"I fanen \"Mapping Std kontoplan\" kortlæg (mappe) dine finanskonti efter hvordan de skal lægges sammen"]
[null,null,null,null,"F.eks. Gives alle omsætningskonti den rapporteringskategori, som du har defineret i kolonne G."]
[null,null,null,null,"Kolonne C styrer mapping mod drifts og balance konti"]
[null,null,null,null,"Kolonne D styrer mappingen i cashflow opgørelsen"]
[]
[null,null,5,null,"Klik på makroen i område E2 i fanen \"Mapping Std kontoplan\""]
[null,null,null,null,"Nu genereres en fil i fanen \"Upload til kundecenter\" som gør det hurtigt at importere mappings"]
[]
[null,null,6,null,"I fanen \"Upload til kundecenter\" bør alle rapporteringskategorier være synlige"]
[null,null,null,null,"Klik på makroen i E2 for at oprette en ny workbook, der manuelt skal gemmes som en CSV fil i UTF-8 formatet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,7,null,"Upload mapping til kundecenteret"]
[null,null,null,null,"Når filen er gemt i UTF-8 skal man gå til kundecenteret og klikke på administration og derefter \"BI & virksomheder\". Dernæst klik på \"upload CSV\". "]
[null,null,null,null,"NB! Upload sletter de tidligere linjer, så upload altid fulde mappings via filen. Man kan tilføje og redigere i dem manuelt efter upload"]

{"sheet":"Mapping std kontoplan","index":1,"n_rows":141,"n_cols":17,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["Account no.","Name","Mapping - reporting","Mapping - Cashflow",null,null,"Mapping - reporting",null,"",null,"Mapping - Cashflow",null,"",null,"Mapping - Opsummeringer (manuel udfyldning)"]
[1010,"Salg af varer/ydelser m/moms","R1000","C1000",null,null,null,"Profit and loss"]
[1020,"Salg af varer til udland","R1000","C1000",null,null,null,null,null,null,"C1000","Resultat før skat og afskrivninger","1010..3780|4310..4640",null,"R1999","Omsætninger",{"$f":"I4","v":"1010..1030"}]
[1021,"Salg af ydelser til udland","R1000","C1000",null,null,"R1000","Omsætning","1010..1030",null,"C1020","Betalt skat","4810..4820|6310|6610",null,"R2598","Vareforbrug i alt",{"$f":"I5","v":"1310..1330"}]
[1025,"Salg af varer til EU","R1000","C1000",null,null,"R2000","Vareforbrug","1310..1330",null,"C2000","Ændring i arbejdskapitalen, debitorer",5600,null,"R2599","Dækningsbidrag",{"$f":"Q3&\"|\"&Q4","v":"1010..1030|1310..1330"}]
[1026,"Salg af ydelser til EU","R1000","C1000",null,null,"R3000","Personaleomkostninger","2210..2280",null,"C2040","Ændring i arbejdskapitalen, kreditorer",6800,null,"R3599","Kapacitetsomkostninger",{"$f":"I6&\"|\"&I7&\"|\"&I8&\"|\"&I9&\"|\"&I10","v":"2210..2280|2750..2811|3110..3140|3410..3450|3600..3780"}]
[1030,"Salg til kunder u/moms","R1000","C1000",null,null,"R3100","Salgsomkostninger","2750..2811",null,"C2080","Ændring i arbejdskapitalen, varelager",5520,null,"R3999","Resultat før afskrivninger",{"$f":"Q5&\"|\"&Q6","v":"1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780"}]
[1310,"Direkte omkostninger m/moms","R2000","C1000",null,null,"R3200","Autodrift","3110..3140",null,"C2100","Ændring i arbejdskapitalen, moms","6901..6917",null,"R4909","Periodens resultat før skat",{"$f":"Q7&\"|\"&I11&\"|\"&I12&\"|\"&I13","v":"1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780|3910..3950|4310..4481|4610..4640"}]
[1320,"Direkte omkostninger varer u/moms indenfor EU","R2000","C1000",null,null,"R3300","Lokaleomkostninger","3410..3450",null,"C2200","Ændring i arbejdskapitalen, ændring i korte poster","5312..5322|5650..5665|6830..6860|6920..9900",null,"R4999","Periodens resultat",{"$f":"Q8&\"|\"&I14","v":"1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780|3910..3950|4310..4481|4610..4640|4810..4820"}]
[1321,"Direkte omkostninger ydelser u/moms indenfor EU","R2000","C1000",null,null,"R3400","Administrationsomkostninger","3600..3780",null,"C3000","Ændring i langsigtede aktiver, investeringer","3910..3950|5111..5237",null,"C2998","Ændring i arbejdskapitalen",{"$f":"M5&\"|\"&M6&\"|\"&M7&\"|\"&M8&\"|\"&M9","v":"5600|6800|5520|6901..6917|5312..5322|5650..5665|6830..6860|6920..9900"}]
[1324,"Direkte omkostninger varer u/moms 3. lande","R2000","C1000",null,null,"R4000","Afskrivninger","3910..3950",null,"C4000","Ændring i langsigtede passiver, finansiering","6110..6130|6320",null,"C2999","Pengestrøm fra ordinær drift",{"$f":"Q10&M3&\"|\"&M4","v":"5600|6800|5520|6901..6917|5312..5322|5650..5665|6830..6860|6920..99001010..3780|4310..4640|4810..4820|6310|6610"}]
[1325,"Direkte omkostninger ydelser u/moms 3. lande","R2000","C1000",null,null,"R5000","Finansielle poster","4310..4481",null,null,null,null,null,"A1999","Langsigtede aktiver",{"$f":"I17&\"|\"&I18&\"|\"&I19","v":"5111..5117|5221..5227|5231..5237"}]
[1326,"Lønninger, afsluttede projekter (projekt)","R2000","C1000",null,null,"R5400","Ekstraordinære poster","4610..4640",null,null,null,null,null,"A2999","Kortsigtede aktiver",{"$f":"I20&\"|\"&I21&\"|\"&I23&\"|\"&I24&\"|\"&I22","v":"5312..5322|5600|5520|5650..5655|5665|5660"}]
[1327,"Omkostninger, afsluttede projekter (projekt)","R2000","C1000",null,null,"R5900","Selskabsskat","4810..4820",null,null,null,null,null,"A9999","Totale aktiver",{"$f":"Q12&\"|\"&Q13&\"|\"&I25","v":"5111..5117|5221..5227|5231..5237|5312..5322|5600|5520|5650..5655|5665|5660|5810..5820"}]
[1330,"Vareforbrug (lagermodul)","R2000","C1000",null,null,null,null,null,null,null,null,null,null,"A2999","Langsigtede passiver",{"$f":"I30&\"|\"&I31","v":"6310..6610|6750"}]
[2210,"Lønninger","R3000","C1000",null,null,null,"Assets",null,null,null,null,null,null,"A3999","Kortsigtede passiver",{"$f":"I32&\"|\"&I34&\"|\"&I33","v":"6800|6830..6860|6920..9900|6901..6917"}]
[2211,"Feriepenge & SH","R3000","C1000",null,null,"A1100","Indretning","5111..5117",null,null,null,null,null,"A9999","Totale passiver",{"$f":"Q15&\"|\"&Q16&\"|\"&I29","v":"6310..6610|6750|6800|6830..6860|6920..9900|6901..6917|6110..6130"}]
[2212,"Sygedagpenge mv.","R3000","C1000",null,null,"A1200","Driftsmidler & Inventar","5221..5227"]
[2213,"B-honorar","R3000","C1000",null,null,"A1300","IT","5231..5237"]
[2214,"Personalegoder og multimedier","R3000","C1000",null,null,"A2100","Deposita","5312..5322"]
[2215,"Pensioner, arbejdsgiver","R3000","C1000",null,null,"A2200","Debitorer",5600]
[2222,"AER (Samlet betaling)","R3000","C1000",null,null,"A2300","Periodeafgrænsningsposter",5660]
[2223,"ATP","R3000","C1000",null,null,"A2400","Lager",5520]
[2224,"DA-barsel","R3000","C1000",null,null,"A2900","Andre omsætningsaktiver","5650..5655|5665"]
[2230,"KM-penge","R3000","C1000",null,null,"A3000","Likvide midler","5810..5820"]
[2241,"Personaleudgifter","R3000","C1000"]
[2242,"Projektførte lønninger (projekt)","R3000","C1000",null,null,null,"Equity and Liabilities"]
[2280,"Feriepengeforpligtelse, reg.","R3000","C1000"]
[2750,"Restaurationsbesøg","R3100","C1000",null,null,"P1000","Egenkapital","6110..6130"]
[2754,"Gaver og blomster","R3100","C1000",null,null,"P2000","Hensættelser & skyldig skat","6310..6610"]
[2770,"Rejseudgifter","R3100","C1000",null,null,"P2100","Banklån",6750]
[2800,"Annoncer og reklame","R3100","C1000",null,null,"P3100","Kreditorer",6800]
[2811,"Fragt m/moms","R3100","C1000",null,null,"P3200","Moms & afgifter","6901..6917"]
[3110,"Brændstof","R3200","C1000",null,null,"P3300","Anden gæld","6830..6860|6920..9900"]
[3120,"Bilforsikring","R3200","C1000"]
[3130,"Vægtafgift","R3200","C1000"]
[3140,"Reparation/vedligeholdelse","R3200","C1000"]
[3410,"Husleje m/moms","R3300","C1000"]
[3411,"Husleje u/moms","R3300","C1000"]
[3420,"El, vand og gas","R3300","C1000"]
[3430,"Vedligeholdelse og rengøring","R3300","C1000"]
[3450,"Forsikringer (lokale)","R3300","C1000"]
[3600,"Kontorartikler og tryksager","R3400","C1000"]
[3601,"Avishold","R3400","C1000"]
[3604,"Edb-udgifter / software","R3400","C1000"]
[3610,"Rep./vedligeholdelse af inventar","R3400","C1000"]
[3617,"Mindre anskaffelser","R3400","C1000"]
[3618,"Mindre anskaffelser, omvendt betalingspligt","R3400","C1000"]
[3620,"Telefon","R3400","C1000"]
[3621,"Internetforbindelse","R3400","C1000"]
[3628,"Porto og gebyrer","R3400","C1000"]
[3640,"Revisor","R3400","C1000"]
[3645,"Advokat","R3400","C1000"]
[3650,"Forsikringer","R3400","C1000"]
[3660,"Faglitteratur m/moms","R3400","C1000"]
[3661,"Faglitteratur u/moms","R3400","C1000"]
[3662,"Kontingenter m/moms","R3400","C1000"]
[3663,"Kontingenter u/moms","R3400","C1000"]
[3664,"Web-hotel og domænenavne","R3400","C1000"]
[3670,"Leje/leasing af driftsmidler","R3400","C1000"]
[3720,"Tab på debitorer","R3400","C1000"]
[3770,"Kassedifferencer mv.","R3400","C1000"]
[3780,"Ej fradragsberettigede omkostninger","R3400","C1000"]
[3910,"Afskrivning, indretning lejede lokaler","R4000","C3000"]
[3940,"Afskrivning, driftsmidler og inventar","R4000","C3000"]
[3950,"Afskrivning, edb","R4000","C3000"]
[4310,"Renteindtægt, bank","R5000","C1000"]
[4360,"Renteindtægt, debitorer","R5000","C1000"]
[4365,"Rykkergebyr, debitorer","R5000","C1000"]
[4380,"Valutakursdifference, debitorer gevinst","R5000","C1000"]
[4381,"Valutakursdifference, kreditorer gevinst","R5000","C1000"]
[4410,"Renteudgift, bank","R5000","C1000"]
[4450,"Låneomkostninger","R5000","C1000"]
[4460,"Renteudgift, kreditorer","R5000","C1000"]
[4465,"Renteudgift, Told & Skat","R5000","C1000"]
[4470,"Finansieringstillæg, selskabsskat","R5000","C1000"]
[4480,"Valutakursdifference, debitorer tab","R5000","C1000"]
[4481,"Valutakursdifference, kreditorer tab","R5000","C1000"]
[4610,"Ekstraordinære indtægter m/moms","R5400","C1000"]
[4620,"Ekstraordinære indtægter u/moms","R5400","C1000"]
[4630,"Ekstraordinære udgifter m/moms","R5400","C1000"]
[4640,"Ekstraordinære udgifter u/moms","R5400","C1000"]
[4810,"Selskabsskat, aktuel","R5900","C1020"]
[4820,"Reg. af udskudt skat","R5900","C1020"]
[5111,"Indretning, anskaffelse primo","A1100","C3000"]
[5112,"Indretning, årets tilgang","A1100","C3000"]
[5113,"Indretning, årets afgang","A1100","C3000"]
[5116,"Indretning, afskrivning primo","A1100","C3000"]
[5117,"Indretning, årets afskrivninger","A1100","C3000"]
[5221,"Driftsmidler, anskaffelse primo","A1200","C3000"]
[5222,"Driftsmidler, årets tilgang","A1200","C3000"]
[5223,"Driftsmidler, årets afgang","A1200","C3000"]
[5226,"Driftsmidler, afskrivning primo","A1200","C3000"]
[5227,"Driftsmidler, årets afskrivninger","A1200","C3000"]
[5231,"Edb-anlæg, anskaffelse primo","A1300","C3000"]
[5232,"Edb-anlæg, årets tilgang","A1300","C3000"]
[5233,"Edb-anlæg, årets afgang","A1300","C3000"]
[5236,"Edb-anlæg, afskrivning primo","A1300","C3000"]
[5237,"Edb-anlæg, årets afskrivninger","A1300","C3000"]
[5312,"Huslejedepositum m/moms","A2100","C2200"]
[5313,"Huslejedepositum u/moms","A2100","C2200"]
[5322,"Leasingdepositum","A2100","C2200"]
[5520,"Varelager","A2400","C2080"]
[5600,"Debitorer","A2200","C2000"]
[5650,"Andre tilgodehavender","A2900","C2200"]
[5654,"Igangværende arbejder - aktiviteter (projekt)","A2900","C2200"]
[5655,"Igangværende arbejder - omkostninger (projekt)","A2900","C2200"]
[5660,"Forudbetalte poster","A2300","C2200"]
[5665,"Personaletilgodehavender","A2900","C2200"]
[5810,"Kassebeholdning","A3000"]
[5820,"Bankkonto","A3000"]
[6110,"Anpartskapital","P1000","C4000"]
[6120,"Overkursfond","P1000","C4000"]
[6130,"Overført resultat tidligere år","P1000","C4000"]
[6310,"Udskudt skat","P2000","C1020"]
[6320,"Øvrige hensættelser","P2000","C4000"]
[6610,"Skyldig selskabsskat","P2000","C1020"]
[6750,"Kassekredit","P2100"]
[6800,"Kreditorer","P3100","C2040"]
[6830,"Skyldige omkostninger","P3300","C2200"]
[6835,"Skyldige medarbejderudlæg","P3300","C2200"]
[6860,"Mellemregning med anpartshaver","P3300","C2200"]
[6901,"Skyldig moms, primo","P3200","C2100"]
[6902,"Udgående (salg) moms","P3200","C2100"]
[6903,"Indgående (køb) moms","P3200","C2100"]
[6906,"Erhvervelsesmoms/byggeydelse (køb i udland)","P3200","C2100"]
[6907,"Erhvervelsesmoms/byggeydelse (modkonto)","P3200","C2100"]
[6910,"Olieafgift","P3200","C2100"]
[6911,"Elafgift","P3200","C2100"]
[6914,"CO2-afgift","P3200","C2100"]
[6917,"Betalt moms","P3200","C2100"]
[6920,"Skyldig A-skat","P3300","C2200"]
[6921,"Skyldig ATP","P3300","C2200"]
[6922,"Skyldig pension","P3300","C2200"]
[6923,"Skyldige feriepenge & SH","P3300","C2200"]
[6924,"Skyldig DA-barsel","P3300","C2200"]
[6930,"Skyldig AM-bidrag","P3300","C2200"]
[6940,"Skyldige lønninger","P3300","C2200"]
[6945,"Andre skyldige løn poster","P3300","C2200"]
[6946,"Hensat feriepengeforpligtelse","P3300","C2200"]
[9900,"Analyse/fejlkonto","P3300","C2200"]

{"sheet":"Upload fil til kundecenter","index":2,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["reporting account","reporting account nr.","accounts in mapping","measurement calculation"]
["Omsætning","R1000","1010..1030"]
["Vareforbrug","R2000","1310..1330"]
["Personaleomkostninger","R3000","2210..2280"]
["Salgsomkostninger","R3100","2750..2811"]
["Autodrift","R3200","3110..3140"]
["Lokaleomkostninger","R3300","3410..3450"]
["Administrationsomkostninger","R3400","3600..3780"]
["Afskrivninger","R4000","3910..3950"]
["Finansielle poster","R5000","4310..4481"]
["Ekstraordinære poster","R5400","4610..4640"]
["Selskabsskat","R5900","4810..4820"]
["Indretning","A1100","5111..5117"]
["Driftsmidler & Inventar","A1200","5221..5227"]
["IT","A1300","5231..5237"]
["Deposita","A2100","5312..5322"]
["Debitorer","A2200","5600"]
["Periodeafgrænsningsposter","A2300","5660"]
["Lager","A2400","5520"]
["Andre omsætningsaktiver","A2900","5650..5655|5665"]
["Likvide midler","A3000","5810..5820"]
["Egenkapital","P1000","6110..6130"]
["Hensættelser & skyldig skat","P2000","6310..6610"]
["Banklån","P2100","6750"]
["Kreditorer","P3100","6800"]
["Moms & afgifter","P3200","6901..6917"]
["Anden gæld","P3300","6830..6860|6920..9900"]
["Resultat før skat og afskrivninger","C1000","1010..3780|4310..4640"]
["Betalt skat","C1020","4810..4820|6310|6610"]
["Ændring i arbejdskapitalen, debitorer","C2000","5600"]
["Ændring i arbejdskapitalen, kreditorer","C2040","6800"]
["Ændring i arbejdskapitalen, varelager","C2080","5520"]
["Ændring i arbejdskapitalen, moms","C2100","6901..6917"]
["Ændring i arbejdskapitalen, ændring i korte poster","C2200","5312..5322|5650..5665|6830..6860|6920..9900"]
["Ændring i langsigtede aktiver, investeringer","C3000","3910..3950|5111..5237"]
["Ændring i langsigtede passiver, finansiering","C4000","6110..6130|6320"]
["Omsætninger","R1999","1010..1030"]
["Vareforbrug i alt","R2598","1310..1330"]
["Dækningsbidrag","R2599","1010..1030|1310..1330"]
["Kapacitetsomkostninger","R3599","2210..2280|2750..2811|3110..3140|3410..3450|3600..3780"]
["Resultat før afskrivninger","R3999","1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780"]
["Periodens resultat før skat","R4909","1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780|3910..3950|4310..4481|4610..4640"]
["Periodens resultat","R4999","1010..1030|1310..1330|2210..2280|2750..2811|3110..3140|3410..3450|3600..3780|3910..3950|4310..4481|4610..4640|4810..4820"]
["Ændring i arbejdskapitalen","C2998","5600|6800|5520|6901..6917|5312..5322|5650..5665|6830..6860|6920..9900"]
["Pengestrøm fra ordinær drift","C2999","5600|6800|5520|6901..6917|5312..5322|5650..5665|6830..6860|6920..99001010..3780|4310..4640|4810..4820|6310|6610"]
["Langsigtede aktiver","A1999","5111..5117|5221..5227|5231..5237"]
["Kortsigtede aktiver","A2999","5312..5322|5600|5520|5650..5655|5665|5660"]
["Totale aktiver","A9999","5111..5117|5221..5227|5231..5237|5312..5322|5600|5520|5650..5655|5665|5660|5810..5820"]
["Langsigtede passiver","A2999","6310..6610|6750"]
["Kortsigtede passiver","A3999","6800|6830..6860|6920..9900|6901..6917"]
["Totale passiver","A9999","6310..6610|6750|6800|6830..6860|6920..9900|6901..6917|6110..6130"]