{"product_id":"komptidsbank-arbetstidssaldon-2026-2027-komp-atf-flextid-excel-word-pdf","title":"Comp Time Bank \u0026 Working Hour Balances 2026\/2027 – Comp Time, ATF \u0026 Flextime | Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product-description\" lang=\"en\"\u003e\n\u003ch2\u003eTime Bank \u0026amp; Working Hour Balances 2026\/2027 – register comp time, ATF, and flextime\u003c\/h2\u003e\n\n\u003cp\u003eDo you need a \u003cstrong\u003etime bank in Excel\u003c\/strong\u003e to track earned and taken hours? This template package for Swedish employers includes a ready-made Excel workbook with separate accounts for \u003cstrong\u003ecompensatory leave (comp time), reduction of working hours (ATF), and flextime\u003c\/strong\u003e, complemented by practical Word and PDF documents for leave requests, approval, balance checks, corrections, and usage.\u003c\/p\u003e\n\n\u003cp\u003eThe tool only summarizes \u003cstrong\u003eapproved, manually classified transactions\u003c\/strong\u003e. It does not automatically determine which hours an employee is entitled to according to collective agreements, employment contracts, or employer decisions. Suitable for HR, payroll administration, small businesses, workshops, service companies, and workplaces where time balances are managed separately from a payroll system.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the template:\u003c\/strong\u003e \u003ca href=\"#mb-innehall\"\u003eWhat's included\u003c\/a\u003e · \u003ca href=\"#mb-excel\"\u003eThe Excel tool\u003c\/a\u003e · \u003ca href=\"#mb-steg\"\u003eStep by step\u003c\/a\u003e · \u003ca href=\"#mb-juridik\"\u003eLegal info\u003c\/a\u003e · \u003ca href=\"#mb-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#EDF7F0;border-left:4px solid #397A5C;padding:15px;margin:16px 0\"\u003e\n\n\u003cstrong\u003eSource-checked October 13, 2026.\u003c\/strong\u003e Relevant provisions in the Swedish Working Hours Act and AFS 2023:2, as well as Unionen’s guidance on reduction of working hours and compensatory leave, have been verified. This labeling does not imply government approval, external labor law certification, or adaptation to any specific collective agreement.\u003c\/div\u003e\n\n\u003ch2 id=\"mb-innehall\"\u003eWhat's included – 13 ready-made files\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eFunction\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eTime Bank \u0026amp; Working Hour Balances\u003c\/td\u003e\n\n\u003ctd\u003eExcel with eight sheets: Overview, Staff, Transactions, Balances, Monthly, Leave Requests, Settings, and Guide.\u003c\/td\u003e\n\n\u003ctd\u003eExcel (XLSX)\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eRoutine for time banks and balances\u003c\/td\u003e\n\n\u003ctd\u003eInternal responsibilities, decisions, accrual, withdrawal, balance checks, and monthly reconciliation.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eRequest for comp time \/ ATF \/ flextime\u003c\/td\u003e\n\n\u003ctd\u003eApplication with balance type, number of hours, decision, approval, and transaction reference.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBalance reconciliation\u003c\/td\u003e\n\n\u003ctd\u003eCheck of opening balance, approved changes, and comparison against HR\/payroll systems.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eBalance discrepancy \u0026amp; correction decision\u003c\/td\u003e\n\n\u003ctd\u003eInvestigation of incorrect entries with a new, traceable correction transaction.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eTime Bank Balance \u0026amp; Leave Request\u003c\/td\u003e\n\n\u003ctd\u003eSupplementary English work form for use in Sweden.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eDetailed user guide\u003c\/td\u003e\n\n\u003ctd\u003eFill-in instructions, calculation examples, checkpoints, common errors, sources, and English quick guide.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003e\u003cstrong\u003eTotal:\u003c\/strong\u003e 6 editable DOCX, 6 searchable PDF, and 1 XLSX in a ZIP file. For digital delivery, the file must be correctly linked to the product's Shopify Digital Products variant.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-excel\"\u003eExcel template with separate balances and control panel\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e200 transactions:\u003c\/strong\u003e date, employee ID, balance type, positive or negative hour change, decision status, and reference.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e120 balance accounts:\u003c\/strong\u003e opening balance and the sum of only approved changes per employee and balance type.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e40 employees:\u003c\/strong\u003e simple staff register using internal IDs instead of personal identity numbers.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e80 leave requests:\u003c\/strong\u003e application, requested hours, decision, and separate link to executed balance transaction.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMonthly overview:\u003c\/strong\u003e summarizes approved changes monthly for Comp time, ATF, and Flex.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e total balances, negative balance indicators, pending transactions, and open requests.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eControl flags:\u003c\/strong\u003e duplicate IDs, unknown employees, and missing mandatory information.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cdiv style=\"background:#FFF3D6;padding:15px;margin:16px 0\"\u003e\n\n\u003cstrong\u003eImportant:\u003c\/strong\u003e Excel does not automatically calculate overtime compensation, 1.5\/2.0 multipliers, ATF accrual, payroll costs, vacation, or eligibility for leave. Contractual factors and authorized decisions must be established before registration. Comp time, ATF, and flextime are different balance types and should not be mixed.\u003c\/div\u003e\n\n\u003ch2 id=\"mb-steg\"\u003eHow to use the time bank\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eCheck the applicable collective agreement, individual employment terms, local agreements, and decision mandates.\u003c\/li\u003e\n\n\u003cli\u003eEnter employees or employment IDs in the \"Staff\" Excel sheet.\u003c\/li\u003e\n\n\u003cli\u003eRegister verified opening hours in \"Balances,\" one row per person and balance type.\u003c\/li\u003e\n\n\u003cli\u003eRegister manually approved allocations as positive hours and withdrawals as negative hours, using unique transaction IDs and references.\u003c\/li\u003e\n\n\u003cli\u003eMark the status as \"Approved\" only when there is an authorized decision. Pending and rejected entries do not affect the balance.\u003c\/li\u003e\n\n\u003cli\u003eFollow the monthly overview and negative balances, and document leave decisions using the Word form.\u003c\/li\u003e\n\n\u003cli\u003eReconcile against payroll\/HR systems and document discrepancies with a separate correction sheet.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2 id=\"mb-juridik\"\u003eRules regarding comp time, ATF, and time recording\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eThe Working Hours Act (1982:673)\u003c\/strong\u003e regulates, among other things, regular working hours, overtime, and documentation requirements, but does not establish a general compensation factor or a universal right to a working hour reduction bank for all employees. Such benefits may instead stem from collective agreements, employment contracts, or specific agreements. The union \"Unionen\" emphasizes that the forms of ATF and compensatory leave vary between different collective agreements.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eNote on separate record-keeping duty:\u003c\/strong\u003e Section 11 of the Working Hours Act and \u003cstrong\u003eAFS 2023:2, Chapter 9\u003c\/strong\u003e set specific requirements for notes regarding on-call time, overtime, and extra hours. This Excel register does not automatically contain the specifications and identification data prescribed and is therefore \u003cstrong\u003enot a complete replacement for the employer's statutory working hours log\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eOfficial sources and guidance:\u003c\/strong\u003e \u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/arbetstidslag-1982673_sfs-1982-673\/\"\u003eWorking Hours Act – The Riksdag\u003c\/a\u003e · \u003ca href=\"https:\/\/www.av.se\/arbetsmiljoarbete-och-inspektioner\/publikationer\/foreskrifter\/afs-20232\/\"\u003eAFS 2023:2 – Swedish Work Environment Authority\u003c\/a\u003e · \u003ca href=\"https:\/\/www.unionen.se\/rad-och-stod\/arbetstidsforkortning\"\u003eReduction of working hours – Unionen\u003c\/a\u003e · \u003ca href=\"https:\/\/www.unionen.se\/rad-och-stod\/regler-overtidsersattning-och-kompensationsledighet\"\u003eCompensatory leave – Unionen\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eCan I have comp time, ATF, and flex for the same employee?\u003c\/h3\u003e\n\n\u003cp\u003eYes, when the balance types occur according to relevant agreements. Set up a separate account row per person and balance type so that movements are not mixed up.\u003c\/p\u003e\n\n\u003ch3\u003eIs comp time calculated automatically with a 1.5 or 2.0 factor?\u003c\/h3\u003e\n\n\u003cp\u003eNo. The factor and the right to compensation depend on applicable terms. You first register the hour change that has actually been decided and documented.\u003c\/p\u003e\n\n\u003ch3\u003eCan I register withdrawals that have not yet been approved?\u003c\/h3\u003e\n\n\u003cp\u003eYes, as a leave request or pending transaction. Only transactions with the status \"Approved\" affect the closing balance.\u003c\/p\u003e\n\n\u003ch3\u003eCan Excel be used as a complete overtime log?\u003c\/h3\u003e\n\n\u003cp\u003eNo. For on-call time, overtime, and extra hours, there are additional prescribed requirements and time periods that must be recorded separately where applicable.\u003c\/p\u003e\n\n\u003ch3\u003eHow are incorrectly registered comp time entries handled?\u003c\/h3\u003e\n\n\u003cp\u003eInvestigate the discrepancy, document the correction, and use a new traceable transaction. Do not change an approved historical entry without a decision basis.\u003c\/p\u003e\n\n\u003ch3\u003eIs this the same product as the Shift Schedule or Time Report?\u003c\/h3\u003e\n\n\u003cp\u003eNo. \u003ca href=\"\/en\/products\/skiftschema-personalbemanning-2026-2027-rullande-schema-arbetstider-excel-word-pdf\"\u003eShift Schedule\u003c\/a\u003e plans work shifts, and \u003ca href=\"\/en\/products\/tidrapport-tidsredovisning-2026-2027-overtidsjournal-projektuppfoljning-excel-word-pdf\"\u003eTime Report\u003c\/a\u003e documents actual reported time. This product tracks approved balance changes in separate time banks.\u003c\/p\u003e\n\n\u003ch3\u003eIs an English version included?\u003c\/h3\u003e\n\n\u003cp\u003eYes, a separate English work form and an English quick guide, designed for Swedish working conditions. The entire package is not fully translated.\u003c\/p\u003e\n\n\u003ch3\u003eHow are the documents delivered?\u003c\/h3\u003e\n\n\u003cp\u003eDigitally as a ZIP file containing Excel, Word, and PDF, without physical delivery. Automatic download requires the ZIP file to be verified and linked in Digital Products.\u003c\/p\u003e\n\n\u003ch2\u003eDigital delivery and limitations\u003c\/h2\u003e\n\n\u003cp\u003eVersion 1.0, source-checked October 13, 2026. Use locally in Word, Excel, or compatible office software. The product does not replace payroll systems, labor law advice, individual contract assessment, personal data security, or prescribed logs for overtime\/extra hours.\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55733544091990,"sku":"KOMPTIDSBANK-ATF-FLEX-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/komptidsbank_2027_hero.png?v=1791913507","url":"https:\/\/mallbutiken.se\/en\/products\/komptidsbank-arbetstidssaldon-2026-2027-komp-atf-flextid-excel-word-pdf","provider":"Mallbutiken","version":"1.0","type":"link"}