{"product_id":"reklamationsregister-returhantering-excel-2026-2027","title":"Complaint Register \u0026 Returns Management 2026\/2027 – Customer Service, Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product-description\" lang=\"en\"\u003e\n\u003cp\u003e\u003cstrong\u003eComplaint Register \u0026amp; Return Management 2026\/2027\u003c\/strong\u003e is a complete, editable template package for Swedish e-commerce businesses, retail stores, and customer service departments looking to document customer cases, complaints, statutory rights of withdrawal, voluntary returns, warranty issues, and refunds in a structured manner. The package combines a well-developed customer service routine with protocols, a Swedish user guide, English working documents, and an Excel workbook with six tabs for follow-up.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003e79 SEK as a one-time purchase.\u003c\/strong\u003e No subscription. The package is an offline-based administrative tool, not a customer portal, e-commerce integration, or automatic payment\/withdrawal function.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#rek-inne\"\u003ePackage contents\u003c\/a\u003e · \u003ca href=\"#rek-excel\"\u003eExcel tools\u003c\/a\u003e · \u003ca href=\"#rek-guide\"\u003eHow to use\u003c\/a\u003e · \u003ca href=\"#rek-lag\"\u003eRegulations 2026\/2027\u003c\/a\u003e · \u003ca href=\"#rek-faq\"\u003eFAQ\u003c\/a\u003e · \u003ca href=\"#rek-format\"\u003eFormat and delivery\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#EAF5EF;border-left:4px solid #278151;padding:15px 18px;margin:17px 0\"\u003e\n\n\u003cstrong\u003eLegally and\/or technically reviewed: October 9, 2026\u003c\/strong\u003e\u003cp\u003eVersion 1.0 relevant for 2026\/2027. The structure has been cross-checked against the Swedish Consumer Agency's current business guidance, the Consumer Sales Act (2022:260), the Distance Contracts Act (2005:59), and the Swedish Authority for Privacy Protection (IMY) GDPR guidance. No government certification or individual legal advice is included.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"rek-inne\"\u003eIncluded in the complaint 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 is included?\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\u003e\u003cstrong\u003eComplaint and return routine\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eResponsibilities, classification, receipt, investigation, decision support, feedback, data protection, and final verification.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eComplaint case and decision protocol\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eCase ID, customer and order reference, product details, case type, documentation, decision, execution, and final control.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eDetailed user guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eWalkthrough of all Excel sheets, practical examples, common errors, and important legal limitations.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eCustomer Complaint Case Sheet (English)\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSupplementary English staff materials for Swedish consumer law. Does not include a full English translation of all main documents.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eComplaint Register – Excel\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSix-tab workbook with overview, cases, measures, returns\/refunds, contact log, and instructions.\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 nine files:\u003c\/strong\u003e four DOCX, four searchable A4-PDFs, and one Excel workbook, compiled in a ZIP. Swedish is the product's primary language.\u003c\/p\u003e\n\n\u003ch2\u003eWho is this document template for?\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eE-commerce companies\u003c\/strong\u003e that need to distinguish between complaint claims and rights of withdrawal or voluntary returns. \u003cstrong\u003ePhysical stores\u003c\/strong\u003e that want to follow up on statutory consumer complaints and satisfaction guarantees (open purchase). \u003cstrong\u003eCustomer service teams\u003c\/strong\u003e that need a shared register for tracking responsibilities, communication, decisions, and status. \u003cstrong\u003eSmall business owners\u003c\/strong\u003e who want to work in a structured way without complex case management systems.\u003c\/p\u003e\n\n\u003ch2 id=\"rek-excel\"\u003eExcel: six worksheets with real functions\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eWorksheet\u003c\/th\u003e\n\n\u003cth\u003eContent and function\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOverview\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eDashboard calculating registered\/open cases, complaints, withdrawal cases, internal deadlines, closed cases without final verification, open actions, and actual registered refunds.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eCases\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e160 prepared rows with unique IDs, case type, order reference, contact\/submission dates, product, responsibility, status, and decision basis. Automatic calendar status and separate check signal.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eActions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e160 rows with action ID, case reference, person in charge, internal target date, implementation, and impact assessment.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eReturns\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e160 rows for return type, receipt, inspection, decided refund amount, actual refund, date, and reference.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eContact log\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e180 rows for customer contact, channel, date, case ID, factual notes, and next steps.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eInstructions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eWalkthrough of workflow, legal differences, data protection, and official sources.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003eThe workbook features clearly color-coded headers, dropdown lists, and formulas. The status \u003cem\u003eOverdue\u003c\/em\u003e only indicates that an internal target date has passed. If a case is marked \u003cem\u003eClosed\u003c\/em\u003e without a completed final check, Excel displays \u003cstrong\u003eCHECK MISSING\u003c\/strong\u003e. No formula determines whether a customer's claim is legally valid.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#FFF3D7;border-left:4px solid #D6A434;padding:15px 18px;margin:17px 0\"\u003e\n\n\u003cstrong\u003eImportant regarding the withdrawal function:\u003c\/strong\u003e As of June 19, 2026, there are new provisions in the Distance Contracts Act concerning a specific withdrawal function on websites and apps where such a right applies. \u003cstrong\u003eThis Excel package does not replace that function\u003c\/strong\u003e, and it does not send automatic customer notifications or process refunds.\u003c\/div\u003e\n\n\u003ch2 id=\"rek-guide\"\u003eHow to use the complaint register – step by step\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eEstablish responsibility and data protection:\u003c\/strong\u003e determine who receives, assesses, and closes cases, and where documentation is securely stored.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate case ID:\u003c\/strong\u003e register a unique ID used throughout the entire Excel workbook and in the Word protocols.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eSelect case type:\u003c\/strong\u003e complaint, statutory right of withdrawal, voluntary return, or warranty. These rules must not be treated as equivalent.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eGather documentation:\u003c\/strong\u003e document the customer's request, purchase, receipt, description of the fault, relevant contact, and actual investigation.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eAssess consumer rights manually:\u003c\/strong\u003e check laws, agreements, and circumstances. Note the decision, justification, and responsible party.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDocument measures and returns:\u003c\/strong\u003e register actual processing, receipt, refund, and verification details.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eFollow up:\u003c\/strong\u003e save customer communication and track internal dates without presenting them as mandatory legal deadlines.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eClose and archive:\u003c\/strong\u003e verify implementation, restrict access to information, and follow an established storage\/disposal policy.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2 id=\"rek-lag\"\u003eComplaints and right of withdrawal – what applies in 2026\/2027?\u003c\/h2\u003e\n\n\u003ch3\u003eComplaints according to the Consumer Sales Act\u003c\/h3\u003e\n\n\u003cp\u003eFor purchases from businesses to consumers, the Consumer Sales Act (2022:260) applies to covered purchases. Businesses are primarily responsible for original defects in goods for \u003cstrong\u003eat least three years\u003c\/strong\u003e. A complaint made within \u003cstrong\u003etwo months of the consumer noticing the defect\u003c\/strong\u003e is always considered timely. For faults that appear within the first two years, specific burden of proof rules apply as a general rule. Circumstances and any exceptions must be assessed in each individual case.\u003c\/p\u003e\n\n\u003ch3\u003eRight of withdrawal and new rules 2026\u003c\/h3\u003e\n\n\u003cp\u003eFor applicable distance contracts and off-premises contracts, consumers generally have a 14-day right of withdrawal. When the period begins and which exceptions apply depends on the purchase and the fulfillment of information requirements. From \u003cstrong\u003eJune 19, 2026\u003c\/strong\u003e, the rules also include a specific withdrawal function on websites and in apps for applicable contracts. An email form or this Excel workbook does not automatically satisfy the technical requirement for a withdrawal function.\u003c\/p\u003e\n\n\u003ch3\u003eVoluntary returns and warranty\u003c\/h3\u003e\n\n\u003cp\u003eSatisfaction guarantees (open purchase) and exchange rights are generally voluntary offers. Warranties may provide additional rights but must not limit mandatory consumer protection. Different rules and terms may apply to business-to-business purchases. The templates must therefore not be used to automatically deny a complaint based solely on a calculated date.\u003c\/p\u003e\n\n\u003ch3\u003eGDPR and accounting records\u003c\/h3\u003e\n\n\u003cp\u003ePersonal data in cases and contact logs requires an appropriate legal basis, purpose limitation, secure storage, and disposal. Prefer saving internal customer\/order numbers over unnecessary personal identification numbers (personnummer) or sensitive free-text descriptions. Excel is a follow-up tool – not a complete invoicing or accounting system. Registered refunds are not automatically posted accounting vouchers.\u003c\/p\u003e\n\n\u003ch2\u003eCommon errors to avoid\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003eTreating a complaint as a voluntary return.\u003c\/li\u003e\n\n\u003cli\u003eAutomatically rejecting a complaint because a certain Excel date has passed.\u003c\/li\u003e\n\n\u003cli\u003eConfusing warranty with statutory complaint rights.\u003c\/li\u003e\n\n\u003cli\u003eMarking a case closed before the decided action has been verified.\u003c\/li\u003e\n\n\u003cli\u003eRegistering a planned refund as if the money had actually been paid.\u003c\/li\u003e\n\n\u003cli\u003eStoring too much personal data in openly shared spreadsheets.\u003c\/li\u003e\n\n\u003cli\u003eBelieving that the Excel register fulfills the new requirement for a withdrawal function in the web shop.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2 id=\"rek-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat is the difference between a complaint and a return?\u003c\/h3\u003e\n\n\u003cp\u003eA complaint implies a claim due to a defect. A voluntary return follows the company's offered return terms. For distance purchases, the consumer may also have a statutory right of withdrawal.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the register in Shopify?\u003c\/h3\u003e\n\n\u003cp\u003eYes, as a manual, standalone Excel document. The package has no automated Shopify integration or customer portal.\u003c\/p\u003e\n\n\u003ch3\u003eDoes Excel calculate legal deadlines automatically?\u003c\/h3\u003e\n\n\u003cp\u003eNo. It calculates calendar status for manually set internal target dates, not the right to complain, exercise withdrawal rights, or receive a specific remedy.\u003c\/p\u003e\n\n\u003ch3\u003eCan I track refunds?\u003c\/h3\u003e\n\n\u003cp\u003eYes. There are separate fields for planned and actual refunded amounts as well as dates. An actual payout must, however, be confirmed by the finance department.\u003c\/p\u003e\n\n\u003ch3\u003eDoes Excel accommodate multiple cases?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The workbook has 160 prepared case rows, 160 actions, 160 returns, and 180 contact entries.\u003c\/p\u003e\n\n\u003ch3\u003eIs an English version included?\u003c\/h3\u003e\n\n\u003cp\u003eYes, a supplementary English staff resource adapted to the Swedish business context. The Swedish main documents and the detailed guide are not fully translated.\u003c\/p\u003e\n\n\u003ch3\u003eCan a PDF be filled out digitally?\u003c\/h3\u003e\n\n\u003cp\u003eThe Word version is editable. The PDF versions are searchable and printable but are not specifically built as interactive AcroForm forms.\u003c\/p\u003e\n\n\u003ch2 id=\"rek-format\"\u003eFormat, price, and digital delivery\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003e79 SEK.\u003c\/strong\u003e ZIP containing four Word documents (DOCX), four searchable A4-PDFs, and one Excel workbook (XLSX). The files can be used offline in compatible software. No physical shipping. For automatic delivery after purchase, the ZIP file needs to be linked to the product variant in Shopify Digital Products.\u003c\/p\u003e\n\n\u003ch2\u003eOfficial sources\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.konsumentverket.se\/marknadsratt-foretag\/konsumentkoplagen-for-foretag\/\"\u003eSwedish Consumer Agency – Consumer Sales Act for businesses\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.konsumentverket.se\/marknadsratt-foretag\/informationskrav-vid-distansavtal-regler-for-foretag\/\"\u003eSwedish Consumer Agency – Distance contracts and withdrawal function\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.imy.se\/\"\u003eIMY – GDPR and processing of customer data\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/konsumentkoplag-2022260_sfs-2022-260\/\"\u003eSwedish Parliament – Consumer Sales Act (2022:260)\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eRelated product\u003c\/h2\u003e\n\n\u003cp\u003eFor technically complex product defects requiring a structured root cause analysis, the \u003ca href=\"\/en\/products\/8d-rapport-rotorsaksanalys-5-varfor-mall-2026-2027\"\u003e8D Report \u0026amp; Root Cause Analysis\u003c\/a\u003e can complement this customer service process.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eDisclaimer: This package is a general documentation and administrative aid, not an integrated return portal, accounting service, technical withdrawal function, or guarantee of legal compliance. Consumer law, product safety, tax rules, and individual contractual relationships must be assessed separately as needed.\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55655171522902,"sku":"REKLAMATION-RETURER-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/01_reklamationsregister_hero_2027_cf2e0ca6-fdbe-41c0-a10b-e6a51c6c50ac.png?v=1791504428","url":"https:\/\/mallbutiken.se\/en\/products\/reklamationsregister-returhantering-excel-2026-2027","provider":"Mallbutiken","version":"1.0","type":"link"}