{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Manual","Kontoplan","Bogføring","Regnskab","Tjekark","Kontoudtog","Revisorerklæring","Kasseoptælling","Kørsel","Telefontilskud","Honorar","Indtægter - udgifter"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":14,"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":"Manual","index":0,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! DER KAN IKKE TASTES PÅ DENNE SIDE!"]

{"sheet":"Kontoplan","index":1,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! DER KAN IKKE TASTES PÅ DENNE SIDE!"]
[]
[null,null,"Kontoplan"]
[]
[]
[null,"Konto","Indtægter "]
[null,100,"Rådighedsbeløb","Rådighedsbeløb og bonus"]
[null,102,"Provision skrabelodder","Køb, salg og returnering af skrabelodder"]
[null,110,"Arrangementsindtægter","Deltagerbetaling, salg af kaffe og brød m.m."]
[null,120,"Sponsorindtægter","Sponsorater"]
[null,125,"Øremærkede midler","Øremærkede midler specifikt til jer"]
[null,130,"§18-tilskud  ","Udlodninger fra offentlige puljer (f.eks. §18 og §59)"]
[null,140,"Bogsalg","Salg af bøger ved f.eks. arrangementer"]
[null,150,"Andre indtægter","Beløb der ikke passer ind under øvrige indtægtskonti"]
[null,null,"Udgifter - administration - Bestyrelsens udgifter"]
[null,200,"Mødeudgifter","Forplejning til bestyrelsesmøder"]
[null,210,"Kontorartikler ","Porto, kuverter, printerpatroner og andet kontorhold"]
[null,220,"Telefontilskud","Bestyrelsens telefonudgifter"]
[null,225,"Kørsel - bestyrelsen","Bestyrelsens kørsel "]
[null,230,"Husleje","I tilfælde af lejede lokaler"]
[null,250,"Øvrige udgifter","Beløb der ikke passer ind under øvrige udgiftskonti"]
[null,270,"Anskaffelser","Store engangsinvesteringer f.eks. PC, projektor eller lign."]
[null,null,"Udgifter – aktiviteter - Udgifter til medlemmerne"]
[null,300,"Arrangementer ","Forplejning, lokaleleje mm."]
[null,305,"Honorar","Honorar til foredragsholder m.fl."]
[null,310,"Annoncer og reklame","Annoncer i f.eks. aviser og årsplaner/folder "]
[null,320,"Andre udgifter","Gaver, blomster mm."]
[null,325,"Kørsel ifb. med arrangementer","Kørselsgodtgørelse til foredragsholdere m.fl."]
[null,340,"Udsendelser til medlemmer","Tryk, materialer, porto mm."]
[null,350,"Generalforsamling","Alle omkostninger i forbindelse med generalforsamling"]
[null,360,"Bogkøb","Køb af bøger til videresalg"]
[null,null,"Likvidbeholdning"]
[null,400,"Kassebeholdning","Ind- og udbetalinger i kassen"]
[null,500,"Bankbeholdning","Ind- og udbetalinger i banken"]
[null,550,"Anden beholdning","Ind- og udbetalinger i anden bank eller kasse"]
[null,600,"Mellemregning","Midler deponeret hos Hovedkontoret"]
[null,null,"Periodisering"]
[null,700,"Tilgodehavender","Indtægter der ikke er modtaget i indeværende år"]
[null,800,"Gæld","Udgifter der ikke er betalt i indeværende år"]
[null,820,"Øremærkede midler overført til næste år","Øremærkede midler der er overført til næste år"]
[null,830,"§-midler overført til næste år","§-midler der er overført til næste år"]

{"sheet":"Bogføring","index":2,"n_rows":267,"n_cols":12,"rows_kept":267,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OBS! TAST KUN I DE HVIDE FELTER!"]
[]
[null,"BOGFØRINGSARK",null,2026,"Regnskab for","XXX",null,null,"Primoposter"]
[null,null,null,null,null,null,null,null,"Tilgode","Gæld","Øremærkede","Gl. §-midler"]
[null,null,null,null,null,null,null,"Indtast tilgode/gæld/øremærkede/gl. §-midler fra ultimo året før (husk at sætte minus foran gæld, øremærkede og gl. §-midler) > > > "]
[null,null,null,null,null,null,null,null,"Bank","Kasse","Andet","Mellemregn."]
[null,"Dato","Bilagsnr.","Konto ","Modkonto","Beskrivende tekst","Sortering","Beløb"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(D9=500,E9=\"bank\"),FALSE,IF(D9=500,-H9,IF(E9=\"bank\",H9,\"\")))","v":""},{"$f":"IF(AND(D9=400,E9=\"kasse\"),FALSE,IF(D9=400,-H9,IF(E9=\"kasse\",H9,\"\")))","v":""},{"$f":"IF(AND(D9=550,E9=\"andet\"),FALSE,IF(D9=550,-H9,IF(E9=\"andet\",H9,\"\")))","v":""},{"$f":"IF(AND(D9=600,E9=\"mellemregning\"),FALSE,IF(D9=600,-H9,IF(E9=\"mellemregning\",H9,\"\")))","v":""}]
[null,null,{"$f":"IF(B10=\"\",\"\",C9+1)","v":""},null,null,null,null,null,{"$f":"IF(AND(D10=500,E10=\"bank\"),FALSE,IF(D10=500,-H10,IF(E10=\"bank\",H10,\"\")))","v":""},{"$f":"IF(AND(D10=400,E10=\"kasse\"),FALSE,IF(D10=400,-H10,IF(E10=\"kasse\",H10,\"\")))","v":""},{"$f":"IF(AND(D10=550,E10=\"andet\"),FALSE,IF(D10=550,-H10,IF(E10=\"andet\",H10,\"\")))","v":""},{"$f":"IF(AND(D10=600,E10=\"mellemregning\"),FALSE,IF(D10=600,-H10,IF(E10=\"mellemregning\",H10,\"\")))","v":""}]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,{"$f":"IF(B74=\"\",\"\",C73+1)","v":""},null,null,null,null,null,{"$f":"IF(AND(D74=500,E74=\"bank\"),FALSE,IF(D74=500,-H74,IF(E74=\"bank\",H74,\"\")))","v":""},{"$f":"IF(AND(D74=400,E74=\"kasse\"),FALSE,IF(D74=400,-H74,IF(E74=\"kasse\",H74,\"\")))","v":""},{"$f":"IF(AND(D74=550,E74=\"andet\"),FALSE,IF(D74=550,-H74,IF(E74=\"andet\",H74,\"\")))","v":""},{"$f":"IF(AND(D74=600,E74=\"mellemregning\"),FALSE,IF(D74=600,-H74,IF(E74=\"mellemregning\",H74,\"\")))","v":""}]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,{"$f":"IF(B138=\"\",\"\",C137+1)","v":""},null,null,null,null,null,{"$f":"IF(AND(D138=500,E138=\"bank\"),FALSE,IF(D138=500,-H138,IF(E138=\"bank\",H138,\"\")))","v":""},{"$f":"IF(AND(D138=400,E138=\"kasse\"),FALSE,IF(D138=400,-H138,IF(E138=\"kasse\",H138,\"\")))","v":""},{"$f":"IF(AND(D138=550,E138=\"andet\"),FALSE,IF(D138=550,-H138,IF(E138=\"andet\",H138,\"\")))","v":""},{"$f":"IF(AND(D138=600,E138=\"mellemregning\"),FALSE,IF(D138=600,-H138,IF(E138=\"mellemregning\",H138,\"\")))","v":""}]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,{"$f":"IF(B202=\"\",\"\",C201+1)","v":""},null,null,null,null,null,{"$f":"IF(AND(D202=500,E202=\"bank\"),FALSE,IF(D202=500,-H202,IF(E202=\"bank\",H202,\"\")))","v":""},{"$f":"IF(AND(D202=400,E202=\"kasse\"),FALSE,IF(D202=400,-H202,IF(E202=\"kasse\",H202,\"\")))","v":""},{"$f":"IF(AND(D202=550,E202=\"andet\"),FALSE,IF(D202=550,-H202,IF(E202=\"andet\",H202,\"\")))","v":""},{"$f":"IF(AND(D202=600,E202=\"mellemregning\"),FALSE,IF(D202=600,-H202,IF(E202=\"mellemregning\",H202,\"\")))","v":""}]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,"",null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,"Ultimoposter",{"$f":"SUM(I8:I208)","v":0},{"$f":"SUM(J8:J208)","v":0},{"$f":"SUM(K8:K208)","v":0},{"$f":"SUM(L8:L208)","v":0}]
[null,null,null,null,null,null,null,"Afstemning til kontoudtog og optælling af kasse"]
[null,null,null,null,null,null,null,"Difference",{"$f":"I209-I210","v":0},{"$f":"J209-J210","v":0},{"$f":"K209-K210","v":0},{"$f":"L209-L210","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Hvor er indtægten kommet ind og hvor er udgiften taget fra?"]
[null,null,"Bank"]
[null,null,"Kasse"]
[null,null,"Andet"]
[null,null,"Mellemregning"]
[]
[null,null,"konto"]
[null,null,{"$f":"Kontoplan!$B$7","v":100},{"$f":"VLOOKUP(C237,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Rådighedsbeløb"}]
[null,null,{"$f":"Kontoplan!$B$8","v":102},{"$f":"VLOOKUP(C238,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Provision skrabelodder"}]
[null,null,{"$f":"Kontoplan!$B$9","v":110},{"$f":"VLOOKUP(C239,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Arrangementsindtægter"}]
[null,null,{"$f":"Kontoplan!$B$10","v":120},{"$f":"VLOOKUP(C240,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Sponsorindtægter"}]
[null,null,125,"Øremærkede midler"]
[null,null,{"$f":"Kontoplan!$B$12","v":130},{"$f":"VLOOKUP(C242,Kontoplan!$B$6:$C$41,2,FALSE)","v":"§18-tilskud  "}]
[null,null,{"$f":"Kontoplan!$B$13","v":140},{"$f":"VLOOKUP(C243,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bogsalg"}]
[null,null,{"$f":"Kontoplan!$B$14","v":150},{"$f":"VLOOKUP(C244,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Andre indtægter"}]
[null,null,{"$f":"Kontoplan!$B$16","v":200},{"$f":"VLOOKUP(C245,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Mødeudgifter"}]
[null,null,{"$f":"Kontoplan!$B$17","v":210},{"$f":"VLOOKUP(C246,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kontorartikler "}]
[null,null,{"$f":"Kontoplan!$B$18","v":220},{"$f":"VLOOKUP(C247,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Telefontilskud"}]
[null,null,{"$f":"Kontoplan!$B$19","v":225},{"$f":"VLOOKUP(C248,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kørsel - bestyrelsen"}]
[null,null,{"$f":"Kontoplan!$B$20","v":230},{"$f":"VLOOKUP(C249,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Husleje"}]
[null,null,{"$f":"Kontoplan!$B$21","v":250},{"$f":"VLOOKUP(C250,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Øvrige udgifter"}]
[null,null,{"$f":"Kontoplan!$B$22","v":270},{"$f":"VLOOKUP(C251,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Anskaffelser"}]
[null,null,{"$f":"Kontoplan!$B$24","v":300},{"$f":"VLOOKUP(C252,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Arrangementer "}]
[null,null,{"$f":"Kontoplan!$B$25","v":305},{"$f":"VLOOKUP(C253,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Honorar"}]
[null,null,{"$f":"Kontoplan!$B$26","v":310},{"$f":"VLOOKUP(C254,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Annoncer og reklame"}]
[null,null,{"$f":"Kontoplan!$B$27","v":320},{"$f":"VLOOKUP(C255,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Andre udgifter"}]
[null,null,{"$f":"Kontoplan!$B$28","v":325},{"$f":"VLOOKUP(C256,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kørsel ifb. med arrangementer"}]
[null,null,{"$f":"Kontoplan!$B$29","v":340},{"$f":"VLOOKUP(C257,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Udsendelser til medlemmer"}]
[null,null,{"$f":"Kontoplan!$B$30","v":350},{"$f":"VLOOKUP(C258,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Generalforsamling"}]
[null,null,{"$f":"Kontoplan!$B$31","v":360},{"$f":"VLOOKUP(C259,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bogkøb"}]
[null,null,{"$f":"Kontoplan!$B$33","v":400},{"$f":"VLOOKUP(C260,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kassebeholdning"}]
[null,null,{"$f":"Kontoplan!$B$34","v":500},{"$f":"VLOOKUP(C261,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bankbeholdning"}]
[null,null,{"$f":"Kontoplan!$B$35","v":550},{"$f":"VLOOKUP(C262,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Anden beholdning"}]
[null,null,{"$f":"Kontoplan!$B$36","v":600},{"$f":"VLOOKUP(C263,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Mellemregning"}]
[null,null,{"$f":"Kontoplan!$B$38","v":700},{"$f":"VLOOKUP(C264,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Tilgodehavender"}]
[null,null,{"$f":"Kontoplan!$B$39","v":800},{"$f":"VLOOKUP(C265,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Gæld"}]
[null,null,820,{"$f":"VLOOKUP(C266,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Øremærkede midler overført til næste år"}]
[null,null,{"$f":"Kontoplan!$B$41","v":830},{"$f":"VLOOKUP(C267,Kontoplan!$B$6:$C$41,2,FALSE)","v":"§-midler overført til næste år"}]

{"sheet":"Regnskab","index":3,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! TAST KUN I BUDGETKOLONNEN!"]
[]
[null,null,"Regnskab for",{"$f":"Bogføring!D4","v":2026}]
[null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[]
[null,null,null,"Realiseret",null,"BUDGET",null,"Til rest",null,"i %"]
[null,"Konto","Indtægter"]
[null,{"$f":"Kontoplan!$B$7","v":100},{"$f":"VLOOKUP(B8,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Rådighedsbeløb"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B8,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D8+F8","v":0}]
[null,{"$f":"Kontoplan!$B$8","v":102},{"$f":"VLOOKUP(B9,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Provision skrabelodder"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B9,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$9","v":110},{"$f":"VLOOKUP(B10,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Arrangementsindtægter"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B10,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$10","v":120},{"$f":"VLOOKUP(B11,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Sponsorindtægter"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B11,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$11","v":125},{"$f":"VLOOKUP(B12,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Øremærkede midler"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B12,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D12+F12","v":0}]
[null,{"$f":"Kontoplan!$B$12","v":130},{"$f":"VLOOKUP(B13,Kontoplan!$B$6:$C$41,2,FALSE)","v":"§18-tilskud  "},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B13,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$13","v":140},{"$f":"VLOOKUP(B14,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bogsalg"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B14,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$14","v":150},{"$f":"VLOOKUP(B15,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Andre indtægter"},{"$f":"SUMIF(Bogføring!$D$9:$D$208,B15,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,null,"Indtægter i alt",{"$f":"SUM(D8:D15)","v":0},null,{"$f":"SUM(F8:F15)","v":0},null,{"$f":"SUM(H8:H15)","v":0},null,{"$f":"IFERROR((D16/$D$16*100),0)","v":0}]
[]
[null,null,"Udgifter - administration"]
[null,{"$f":"Kontoplan!$B$16","v":200},{"$f":"VLOOKUP(B19,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Mødeudgifter"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B19,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D19+F19","v":0}]
[null,{"$f":"Kontoplan!$B$17","v":210},{"$f":"VLOOKUP(B20,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kontorartikler "},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B20,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$18","v":220},{"$f":"VLOOKUP(B21,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Telefontilskud"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B21,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$19","v":225},{"$f":"VLOOKUP(B22,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kørsel - bestyrelsen"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B22,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D22+F22","v":0}]
[null,{"$f":"Kontoplan!$B$20","v":230},{"$f":"VLOOKUP(B23,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Husleje"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B23,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D23+F23","v":0}]
[null,{"$f":"Kontoplan!$B$21","v":250},{"$f":"VLOOKUP(B24,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Øvrige udgifter"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B24,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D24+F24","v":0}]
[null,{"$f":"Kontoplan!$B$22","v":270},{"$f":"VLOOKUP(B25,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Anskaffelser"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B25,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,null,"Udgifter - administration i alt",{"$f":"SUM(D19:D25)","v":0},null,{"$f":"SUM(F19:F25)","v":0},null,{"$f":"SUM(H19:H25)","v":0},null,{"$f":"IFERROR((D26/$D$16*100),0)","v":0}]
[]
[null,null,"Udgifter - aktiviteter"]
[null,{"$f":"Kontoplan!$B$24","v":300},{"$f":"VLOOKUP(B29,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Arrangementer "},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B29,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D29+F29","v":0}]
[null,{"$f":"Kontoplan!$B$25","v":305},{"$f":"VLOOKUP(B30,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Honorar"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B30,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D30+F30","v":0}]
[null,{"$f":"Kontoplan!$B$26","v":310},{"$f":"VLOOKUP(B31,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Annoncer og reklame"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B31,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$27","v":320},{"$f":"VLOOKUP(B32,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Andre udgifter"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B32,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$28","v":325},{"$f":"VLOOKUP(B33,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kørsel ifb. med arrangementer"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B33,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$29","v":340},{"$f":"VLOOKUP(B34,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Udsendelser til medlemmer"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B34,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,{"$f":"Kontoplan!$B$30","v":350},{"$f":"VLOOKUP(B35,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Generalforsamling"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B35,Bogføring!$H$9:$H$208)","v":0},null,null,null,{"$f":"-D35+F35","v":0}]
[null,{"$f":"Kontoplan!$B$31","v":360},{"$f":"VLOOKUP(B36,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bogkøb"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B36,Bogføring!$H$9:$H$208)","v":0},null,null,null,0]
[null,null,"Udgifter - aktiviteter i alt",{"$f":"SUM(D29:D36)","v":0},null,{"$f":"SUM(F29:F36)","v":0},null,{"$f":"SUM(H28:H36)","v":0},null,{"$f":"IFERROR((D37/$D$16*100),0)","v":0}]
[]
[null,null,"Udgifter i alt",{"$f":"D26+D37","v":0},null,{"$f":"+F26+F37","v":0},null,{"$f":"+H26+H37","v":0}]
[]
[null,null,"Årets resultat",{"$f":"D16-D39","v":0},null,{"$f":"+F16-F39","v":0},null,{"$f":"+H16-H39","v":0},null,0]
[]
[]
[null,{"$f":"Kontoplan!$B$33","v":400},{"$f":"VLOOKUP(B44,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Kassebeholdning"},{"$f":"Bogføring!J209","v":0}]
[null,{"$f":"Kontoplan!$B$34","v":500},{"$f":"VLOOKUP(B45,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Bankbeholdning"},{"$f":"Bogføring!I209","v":0}]
[null,{"$f":"Kontoplan!$B$35","v":550},{"$f":"VLOOKUP(B46,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Anden beholdning"},{"$f":"Bogføring!K209","v":0}]
[null,{"$f":"Kontoplan!$B$36","v":600},{"$f":"VLOOKUP(B47,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Mellemregning"},{"$f":"Bogføring!L209","v":0}]
[null,{"$f":"Kontoplan!$B$38","v":700},{"$f":"VLOOKUP(B48,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Tilgodehavender"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B48,Bogføring!$H$9:$H$208)+Bogføring!I6","v":0}]
[null,null,"Beholdninger i alt",{"$f":"SUM(D44:D48)","v":0}]
[]
[]
[null,{"$f":"Kontoplan!$B$39","v":800},{"$f":"VLOOKUP(B52,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Gæld"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B52,Bogføring!$H$9:$H$208)+Bogføring!J6","v":0}]
[null,820,{"$f":"VLOOKUP(B53,Kontoplan!$B$6:$C$41,2,FALSE)","v":"Øremærkede midler overført til næste år"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B53,Bogføring!$H$9:$H$208)+Bogføring!K6","v":0}]
[null,{"$f":"Kontoplan!$B$41","v":830},{"$f":"VLOOKUP(B54,Kontoplan!$B$6:$C$41,2,FALSE)","v":"§-midler overført til næste år"},{"$f":"-SUMIF(Bogføring!$D$9:$D$208,B54,Bogføring!$H$9:$H$208)+Bogføring!L6","v":0}]
[null,null,"Gæld og reserver i alt",{"$f":"SUM(D52:D54)","v":0}]
[]
[]
[null,null,"Værdi primo",{"$f":"SUM(Bogføring!I6:L6,Bogføring!I8:L8)","v":0}]
[null,null,"Årets resultat",{"$f":"SUM(D41)","v":0}]
[null,null,"Værdi ultimo",{"$f":"SUM(D58:D59)","v":0}]
[]
[]
[null,null,"Til årsafslutningen"]
[null,null,"Gennemgået og godkendt af følgende:"]
[]
[null,null,"Formand:"]
[]
[]
[null,null,"Kasserer:"]
[]
[]
[null,null,"Revisor skal skrive under på \"Revisorerklæring\"."]
[]
[null,null,"Årsregnskabet indstilles til godkendelse på lokalforeningens generalforsamling."]

{"sheet":"Tjekark","index":4,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! DER KAN IKKE TASTES PÅ DENNE SIDE!"]
[null,{"$f":"\"Tjekark til kontrol af  regnskab for \"&Bogføring!D4","v":"Tjekark til kontrol af  regnskab for 2026"}]
[]
[]
[null,"Tjek af regnskab for",null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[]
[null,{"$f":"Regnskab!C41","v":"Årets resultat"},null,null,{"$f":"Regnskab!D41","v":0}]
[]
[null,{"$f":"Regnskab!C8","v":"Rådighedsbeløb"},null,{"$f":"Regnskab!D8","v":0}]
[]
[null,{"$f":"Regnskab!C44","v":"Kassebeholdning"},"Primo",{"$f":"Bogføring!J8","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D44","v":0},{"$f":"+D12-D11","v":0}]
[]
[null,{"$f":"Regnskab!C45","v":"Bankbeholdning"},"Primo",{"$f":"Bogføring!I8","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D45","v":0},{"$f":"D15-D14","v":0}]
[]
[null,{"$f":"Regnskab!C46","v":"Anden beholdning"},"Primo",{"$f":"Bogføring!K8","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D46","v":0},{"$f":"D18-D17","v":0}]
[]
[null,{"$f":"Regnskab!C47","v":"Mellemregning"},"Primo",{"$f":"Bogføring!L8","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D47","v":0},{"$f":"D21-D20","v":0}]
[]
[null,{"$f":"Regnskab!C48","v":"Tilgodehavender"},"Primo",{"$f":"Bogføring!I6","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D48","v":0},{"$f":"D24-D23","v":0}]
[]
[null,{"$f":"Regnskab!C52","v":"Gæld"},"Primo",{"$f":"Bogføring!J6","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D52","v":0},{"$f":"D27-D26","v":0}]
[]
[null,{"$f":"Regnskab!C53","v":"Øremærkede midler overført til næste år"},"Primo",{"$f":"Bogføring!K6","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D53","v":0},{"$f":"D30-D29","v":0}]
[]
[null,{"$f":"Regnskab!C54","v":"§-midler overført til næste år"},"Primo",{"$f":"Bogføring!L6","v":0}]
[null,null,"Ultimo",{"$f":"Regnskab!D54","v":0},{"$f":"D33-D32","v":0}]
[]
[]
[null,"denne skal give 0 (der kan dog være ørerdifferencer)",null,null,{"$f":"SUM(E12:E33)-E7","v":0}]
[]
[]
[]
[null,"Kontroller, om primoposterne er de samme som ultimo året før!"]

{"sheet":"Kontoudtog","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! DER KAN IKKE TASTES PÅ DENNE SIDE!"]
[null,"Dato","Bilagsnr.","Konto ","evt mellemregning","Tekst, beskrivende","Sortering","Beløb"]

{"sheet":"Revisorerklæring","index":6,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[36,1,36,2],[27,1,27,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[35,1,35,2],[28,1,28,2],[33,1,33,2],[26,1,26,2],[5,1,5,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
[null,"OBS! TAST KUN I DE MARKEREDE FELTER!"]
[]
[]
[]
[]
[null,{"$f":"\"Revisorerklæring \"&Bogføring!D4","v":"Revisorerklæring 2026"}]
[]
[null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[]
[null,"Årets resultat:",{"$f":"Regnskab!D41","v":0}]
[]
[null,"Jeg har gennemgået regnskabet for lokalforeningen/gruppen."]
[]
[null,"Gennemgangen er foregået på følgende måde:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hvis der er nogle af disse ting som ikke stemmer, vil vi bede dig om at notere det nedenfor, såfremt du ikke,"]
[null,"i samarbejde med kassereren, kan få løst eller afklaret problemet. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Dato og underskrift af kritisk revisor"]

{"sheet":"Kasseoptælling","index":7,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! TAST KUN UNDER ANTAL MØNTER /SEDLER!"]
[]
[]
[]
[]
[null,"Kasseoptælling",null,{"$f":"Bogføring!F4","v":"XXX"}]
[null,{"$f":"TODAY()","v":"2026-02-09"}]
[]
[null,"Antal mønter/sedler","Værdi"]
[null,null,1000,{"$f":"B10*C10","v":0}]
[null,null,500,{"$f":"B11*C11","v":0}]
[null,null,200,0]
[null,null,100,0]
[null,null,50,0]
[null,null,20,0]
[null,null,10,0]
[null,null,5,0]
[null,null,2,0]
[null,null,1,0]
[null,null,0.5,0]
[null,null,"Evt. andet (skriv det fulde beløb i kollonne A)",{"$f":"B21","v":0}]
[]
[null,null,"I alt",{"$f":"SUM(D10:D22)","v":0}]
[]
[null,"Optalt af (navn):"]
[]
[null,"Efter endt optælling skrives siden ud og underskrives."]
[]
[null,"Underskrifter"]
[null,null,"Kasserer samt andet medlem af bestyrelsen"]

{"sheet":"Kørsel","index":8,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,4,12,4],[17,1,18,1],[17,4,18,4],[9,4,10,4],[13,4,14,4],[15,4,16,4],[9,1,10,1],[15,1,16,1],[13,1,14,1]]}
[null,"OBS! TAST KUN I DE MARKEREDE FELTER!"]
[]
[]
[]
[]
[null,"Kørselsopgørelse",null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[null,{"$f":"\"Lav sats pr. 1. januar \"&Bogføring!D4","v":"Lav sats pr. 1. januar 2026"},null,2.2799999999999998,{"$f":"Bogføring!D4","v":2026}]
[]
[null,"Dato","Kørt fra/til","Formål","Antal km."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Antal km. I alt",{"$f":"SUM(E10:E19)","v":0}]
[null,null,null,"Kørselsgodtgørelse kr. i alt",{"$f":"E20*D7","v":0}]
[null,"Bilag til refusion (bilag vedlægges/vedhæftes)"]
[null,"Dato","Tekst/kommentar",null,"Beløb i kr."]
[]
[]
[]
[]
[null,null,null,"Refusion kr. i alt",{"$f":"SUM(E24:E27)","v":0}]
[]
[null,null,null,"Udbetaling kr. i alt",{"$f":"SUM(E28,E21)","v":0}]
[]
[null,null,"Oplysninger om modtager"]
[null,null,"Navn"]
[null,null,"Adresse"]
[null,null,"Postnummer og by"]
[null,null,"Fødselsdato"]
[null,null,"Bilens registreringsnummer"]
[]
[null,null,"Bedes udbetalt til"]
[null,null,"Registrerings- og kontonummer"]
[]
[null,"Efter endt udfyldning skrives siden ud og underskrives"]
[]
[null,"Dato:"]
[]
[]
[null,null,"Modtager","Kasserer eller anden fra bestyrelsen"]

{"sheet":"Telefontilskud","index":9,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! TAST KUN I DE HVIDE FELTER!"]
[]
[]
[]
[]
[null,"Telefontilskud",null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[null,null,null,null,{"$f":"Bogføring!D4","v":2026}]
[]
[null,"Dato","Periode","Formål","Beløb i kr."]
[]
[]
[null,null,"Oplysninger om modtager"]
[null,null,"Stilling"]
[null,null,"Navn"]
[null,null,"Adresse"]
[null,null,"Postnummer og by"]
[null,null,"Fødselsdato"]
[null,null,"Telefonnummer"]
[]
[null,null,"Bedes udbetalt til"]
[null,null,"Registrerings- og kontonummer"]
[]
[null,"Efter endt udfyldning skrives siden ud og underskrives"]
[]
[null,"Dato:"]
[]
[]
[null,null,"Modtager","Kasserer eller anden fra bestyrelsen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Kvartaler"]
[null,null,"1. kvartal"]
[null,null,"2. kvartal"]
[null,null,"3. kvartal"]
[null,null,"4. kvartal"]
[null,null,"1. halvår"]
[null,null,"2. halvår"]
[null,null,"Hele året"]

{"sheet":"Honorar","index":10,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! TAST KUN I DE MARKEREDE FELTER!"]
[]
[]
[]
[]
[null,"Honorarskema",null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[null,null,null,null,{"$f":"Bogføring!D4","v":2026}]
[]
[null,"Dato","Periode","Anledning","Beløb i kr."]
[]
[]
[]
[]
[]
[null,"Skattepligtigt:"]
[null,null,"Honorar pr. time"]
[null,null,"Antal timer",null,{"$f":"D16*D17","v":0}]
[null,null,{"$f":"\"Km. (takst \"&Kørsel!D7&\")\"","v":"Km. (takst 2,28)"},null,{"$f":"D18*Kørsel!D7","v":0}]
[]
[null,"Bilag til refusion (bilag vedlægges/vedhæftes)"]
[null,"Dato","Tekst/kommentar",null,"Beløb i kr."]
[]
[]
[]
[]
[null,null,null,"Refusion kr. i alt",{"$f":"SUM(E22:E25)","v":0}]
[]
[null,null,null,"Udbetaling kr. i alt",{"$f":"SUM(E17,E18,E26)","v":0}]
[]
[null,null,"Oplysninger om modtager"]
[null,null,"Stilling"]
[null,null,"Navn"]
[null,null,"Adresse"]
[null,null,"Postnummer og by"]
[null,null,"CPR-nr."]
[null,null,"Telefonnummer"]
[]
[null,null,"Bedes udbetalt til"]
[null,null,"Registrerings- og kontonummer"]
[]
[null,"Efter endt udfyldning skrives siden ud og underskrives"]
[]
[null,"Dato:"]
[]
[]
[null,null,"Modtager","Kasserer eller anden fra bestyrelsen"]
[]
[null,"Beløbet udbetales af lokalforeningen og bilaget indsendes til Diabetesforeningen for indberetning til SKAT."]
[null,"Bilaget sendes med underskrift til Diabetesforeningen, Stationsparken 24, st. tv., 2600 Glostrup "]
[null,"eller scannes med underskrifter og sendes til bogholderiet@diabetes.dk."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1900-01-04"]

{"sheet":"Indtægter - udgifter","index":11,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"OBS! TAST KUN I DE HVIDE FELTER!"]
[]
[]
[]
[]
[null,"Indtægter / udgifter",null,null,{"$f":"Bogføring!F4","v":"XXX"}]
[null,null,null,null,{"$f":"Bogføring!D4","v":2026}]
[]
[null,"Eventuelt modtaget aconto-beløb"]
[]
[null,"Indtægter"]
[null,"Dato","Konto","Tekst","Indtægter"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Instægter i alt",{"$f":"SUM(E13:E19)","v":0}]
[null,"Udgifter"]
[null,"Dato","konto","Tekst","Udgifter"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Udgifter i alt",{"$f":"SUM(E23:E29)","v":0}]
[]
[null,null,null,"Evt. aconto-beløb  tillagt indtægter og fratrukket udgifter",{"$f":"SUM(E9+E20-E30)","v":0}]
[]
[null,null,null,"Udbetales af lokalforeningen",{"$f":"-SUMIF(E32,\"<0\")","v":0}]
[]
[null,null,null,"Indbetales til lokalforeningen",{"$f":"SUMIF(E32,\">0\")","v":0}]
[]
[null,null,"Oplysninger om modtager"]
[null,null,"Stilling"]
[null,null,"Navn"]
[null,null,"Adresse"]
[null,null,"Postnummer og by"]
[null,null,"Telefonnummer"]
[]
[null,null,"Bedes udbetalt til"]
[null,null,"Registrerings- og kontonr."]
[]
[null,"Efter endt udfyldning skrives siden ud og underskrives"]
[]
[null,"Dato:"]
[]
[]
[null,null,"Kasserer eller anden fra bestyrelsen"]