{"product_id":"tidrapport-tidsredovisning-2026-2027-overtidsjournal-projektuppfoljning-excel-word-pdf","title":"Time Report \u0026 Time Tracking 2026\/2027 – Overtime Log \u0026 Project Follow-up | Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product-description\" lang=\"en\"\u003e\n\u003ch2\u003eTime Reporting \u0026amp; Time Tracking 2026\/2027 – Excel Template with Word and PDF\u003c\/h2\u003e\n\n\u003cp\u003eCollect \u003cstrong\u003eactual hours worked, project hours, and time reports\u003c\/strong\u003e in a professional, editable tool. The package is designed for smaller Swedish employers, consulting firms, project teams, and administrators who want to document, compile, and approve hours without starting from a blank spreadsheet.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eYou receive 11 ready-to-use files:\u003c\/strong\u003e an Excel tool with eight worksheets, five Word documents, and corresponding five PDF files. The documents are primarily in Swedish, with an English working document and an English quick guide adapted for Swedish conditions.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document 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 and limitations\u003c\/a\u003e · \u003ca href=\"#mb-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003caside style=\"background:#eef8f0;border-left:4px solid #377b59;padding:14px;margin:16px 0\"\u003e\u003cstrong\u003eSource-checked October 13, 2026.\u003c\/strong\u003e Relevant Swedish law and authority guidance have been checked, including Section 11 of the Working Hours Act and AFS 2023:2, Chapter 9. The template is not authority-approved, legally certified, or adapted to any specific collective agreement. Always check the rules that apply to your business.\u003c\/aside\u003e\n\u003ch2 id=\"mb-innehall\"\u003eWhat is included in the template package\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eWhat it is used for\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 reporting routine\u003c\/td\u003e\n\n\u003ctd\u003eResponsibilities, registration requirements, approval, corrections, and data protection.\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 report \u0026amp; approval form\u003c\/td\u003e\n\n\u003ctd\u003eReporting of actual time, projects, breaks, deviations, and approval.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003eJournal for on-call time, overtime, and extra time\u003c\/td\u003e\n\n\u003ctd\u003eEditable form and checklists for the employer's separate documentation process.\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 Report \u0026amp; Approval\u003c\/td\u003e\n\n\u003ctd\u003eEnglish working document adapted 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\u003eInstructions, checklists, common errors, data protection, and English quick guide.\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 Report \u0026amp; Project Follow-up\u003c\/td\u003e\n\n\u003ctd\u003eEight worksheets with input, automatic hour summation, monthly overview, registers, and dashboard.\u003c\/td\u003e\n\n\u003ctd\u003eExcel (XLSX)\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 of 11 files in one ZIP:\u003c\/strong\u003e 5 DOCX + 5 searchable PDF + 1 XLSX. Use locally and offline in compatible programs.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-excel\"\u003eExcel template – automatic time reporting and follow-up\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eTime entries:\u003c\/strong\u003e up to 250 rows with date, personnel ID, project, start\/end time, unpaid breaks, time category, potential billable time, and approval.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eTime calculation:\u003c\/strong\u003e calculates normal shifts and night shifts crossing midnight, for shifts shorter than 24 hours.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003ePersonnel and projects:\u003c\/strong\u003e registers for up to 60 employees and 30 projects or cost centers.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMonthly overview:\u003c\/strong\u003e hours per month and manually classified type, for an editable calendar year.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eOn-call\/overtime\/extra time:\u003c\/strong\u003e an annual personnel overview to support further verification of employer journals.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e key performance indicators and tracking of approved, unapproved, and incomplete time entries.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eProject data:\u003c\/strong\u003e separate marking of billable time and simple calculation of amounts when an hourly rate is specified.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003caside style=\"background:#fff5d9;padding:14px;margin:16px 0\"\u003e\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e Excel only compiles data and time categories entered by the user. The tool does not determine legally accurate overtime, extra time, compensation, daily or weekly rest, supplementary allowances, salary amounts, or permitted calculation periods. It does not replace the employer's prescribed notes or mandatory personnel ledgers.\u003c\/aside\u003e\n\u003ch2 id=\"mb-steg\"\u003eHow to use the template – step by step\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eEnter company, workplace, and calendar year in the Settings tab.\u003c\/li\u003e\n\n\u003cli\u003eSet up personnel IDs and project codes in their respective registers.\u003c\/li\u003e\n\n\u003cli\u003eReport actual start time, end time, unpaid breaks, project, and a manually assessed time category.\u003c\/li\u003e\n\n\u003cli\u003eCheck automatic summaries and warnings for missing information.\u003c\/li\u003e\n\n\u003cli\u003eReview time categories and calculation periods against laws, agreements, and the employer's routines.\u003c\/li\u003e\n\n\u003cli\u003eApprove using the form and archive the documentation with version control.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2\u003eCommon use cases\u003c\/h2\u003e\n\n\u003cp\u003eTime reporting for small businesses, administration of hours worked, project-based time accounting for consultants, internal approval documentation, follow-up of billable consulting hours, and separate compilation of on-call, overtime, and extra time.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-juridik\"\u003eThe Working Hours Act and the employer's documentation responsibility\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eThe Working Hours Act (1982:673) Section 11\u003c\/strong\u003e requires employers to record on-call time, overtime, and extra time. \u003cstrong\u003eAFS 2023:2, Chapter 9\u003c\/strong\u003e contains further provisions regarding identification, periods, division, and how the records are to be maintained. The conditions applicable to an operation may be affected by collective agreements, exemptions, and actual working conditions. The form and Excel register are aids for documentation, not a substitute for legal assessment. Time reporting is also not the same as the personnel ledger required by the Swedish Tax Agency in certain industries.\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/arbetstidslag-1982673_sfs-1982-673\/\"\u003eThe Riksdag – The Working Hours Act\u003c\/a\u003e · \u003ca href=\"https:\/\/www.av.se\/arbetsmiljoarbete-och-inspektioner\/publikationer\/foreskrifter\/afs-20232\/\"\u003eSwedish Work Environment Authority – AFS 2023:2\u003c\/a\u003e · \u003ca href=\"https:\/\/www.av.se\/arbetsmiljoarbete-och-inspektioner\/arbetsgivarens-ansvar-for-arbetsmiljon\/anteckna-uppgifter-om-jourtid-overtid-och-mertid\/\"\u003eSwedish Work Environment Authority – Recording working hours\u003c\/a\u003e\u003c\/p\u003e\n\n\u003ch2 id=\"mb-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eCan I report a night shift crossing midnight?\u003c\/h3\u003e\n\n\u003cp\u003eYes. Time entries can total, for example, 22:00–06:00 with a deduction for unpaid breaks. See the guide on how such shifts are periodized manually.\u003c\/p\u003e\n\n\u003ch3\u003eDoes Excel automatically calculate overtime pay?\u003c\/h3\u003e\n\n\u003cp\u003eNo. You specify the time category yourself; actual overtime and any compensation levels are determined by relevant rules and collective agreements. Fields for billing purposes do not refer to salary.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the template as a statutory personnel ledger?\u003c\/h3\u003e\n\n\u003cp\u003eNo. For certain industries, there are specific requirements, and in construction, there is normally a requirement for an electronic personnel ledger. Use a dedicated system when such obligation applies.\u003c\/p\u003e\n\n\u003ch3\u003eIs this the same product as Shift Schedule \u0026amp; Staffing?\u003c\/h3\u003e\n\n\u003cp\u003eNo. \u003ca href=\"\/en\/products\/skiftschema-personalbemanning-2026-2027-rullande-schema-arbetstider-excel-word-pdf\"\u003eShift Schedule \u0026amp; Staffing\u003c\/a\u003e refers to planned work shifts. This product is used for actual reported time, approval, and project follow-up.\u003c\/p\u003e\n\n\u003ch3\u003eIs an English version included?\u003c\/h3\u003e\n\n\u003cp\u003eYes, a specific English working document and an English quick guide. The entire package is not fully translated. The Swedish labor law framework is the foundation.\u003c\/p\u003e\n\n\u003ch2\u003eFormat and digital delivery\u003c\/h2\u003e\n\n\u003cp\u003eEditable Word, Excel, and PDF files delivered digitally as a ZIP once the download file has been linked to the product's Digital Products variant. No physical product is sent. Compatibility and calculations may vary between office programs. Ensure appropriate software and verify results before use.\u003c\/p\u003e\n\n\u003c\/section\u003e\u003caside data-mb-seo=\"2026-10-13\" style=\"margin-block:24px;padding:18px;border:1px solid #d8e0e7;border-radius:10px;background:#f5f8fb\" dir=\"auto\"\u003e\u003ch2\u003eGuides to help you use the materials\u003c\/h2\u003e\n\n\u003cul\u003e\u003cli\u003e\u003ca href=\"\/en\/blogs\/arbetsmiljo-hr-guider\/tidrapportering-arbetade-timmar-overtid-mertid\"\u003eTime reporting – hours worked, overtime, extra time, and documentation\u003c\/a\u003e\u003c\/li\u003e\u003c\/ul\u003e\u003c\/aside\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55730534023510,"sku":"TIDRAPPORT-2027-SVEN","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/tidrapport_2027_hero.png?v=1791898224","url":"https:\/\/mallbutiken.se\/en\/products\/tidrapport-tidsredovisning-2026-2027-overtidsjournal-projektuppfoljning-excel-word-pdf","provider":"Mallbutiken","version":"1.0","type":"link"}