{"product_id":"prislista-prisandring-varor-tjanster-excel-2027","title":"Price List \u0026 Price Adjustment 2026\/2027 – Goods, Services, VAT \u0026 Excel | Word\/PDF","description":"\u003csection lang=\"en\" style=\"max-width:940px;color:#17384B;line-height:1.78\"\u003e\n\u003ch2\u003ePrice list template 2026\/2027 – goods, services, price changes \u0026amp; Excel with VAT\u003c\/h2\u003e\n\n\u003cp\u003eCreate a clear and professional \u003cstrong\u003eprice list in Word, PDF and Excel\u003c\/strong\u003e for your business. This complete package includes ready-to-use, editable price lists for \u003cstrong\u003eproducts and services\u003c\/strong\u003e, customer letters for price changes, an internal price decision protocol, and a dedicated checklist for promotional prices and price reductions.\u003c\/p\u003e\n\n\u003cp\u003eYou will also receive an \u003cstrong\u003eExcel price list template\u003c\/strong\u003e with nine worksheets and formulas that calculate from price excluding VAT to price including VAT when you enter and verify the VAT rate yourself. The package is suitable for businesses selling goods, consultancy\/service firms, e-commerce, and other operations that need to publish, update, and archive price information.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eA total of 15 digital files: 7 editable Word documents (DOCX), 7 corresponding searchable PDFs, and 1 Excel workbook (XLSX).\u003c\/strong\u003e Five Swedish main templates, as well as a Swedish guide and an English User Guide, are included.\u003c\/p\u003e\n\n\u003cnav aria-label=\"Product information\" style=\"padding:15px 18px;margin:20px 0;border-radius:11px;background:#EFF7F7\"\u003e\n\u003ca href=\"#mb-price-box1\"\u003ePackage contents\u003c\/a\u003e · \u003ca href=\"#mb-price-box2\"\u003eWhat the files contain\u003c\/a\u003e · \u003ca href=\"#mb-price-excel\"\u003eExcel\u003c\/a\u003e · \u003ca href=\"#mb-price-howto\"\u003eHow to do it\u003c\/a\u003e · \u003ca href=\"#mb-price-law\"\u003ePrice information\u003c\/a\u003e · \u003ca href=\"#mb-price-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv id=\"mb-price-box1\" style=\"border:1px solid #C6DDDF;border-left:5px solid #177B83;border-radius:14px;background:#E8F4F5;padding:20px 23px;margin:23px 0\"\u003e\n\n\u003ch2 style=\"font-size:1.34em;margin-top:0\"\u003e01. Package contents\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e7 DOCX\u003c\/strong\u003e – five Swedish main templates, one Swedish user guide, and a separate English guide.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e7 searchable PDFs\u003c\/strong\u003e – corresponding preview, reference, and print documents.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e1 Excel (XLSX)\u003c\/strong\u003e – nine tabs: Overview, Price register, Service prices, Price changes, VAT \u0026amp; control, Price history, 30-day price reductions, Approvals, and Read me.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003e15 delivery files – 8 unique documents or tools\u003c\/strong\u003e in a downloadable ZIP package. No physical delivery.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cp\u003eEach Word file contains two framed information boxes for purpose and usage, as well as checkpoints. These support texts can be removed before the price list or letter is sent to the customer. Version 1.0 – 2026\/2027.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003cdiv id=\"mb-price-box2\" style=\"border:1px solid #CFDFE2;border-radius:14px;background:#FFF;padding:20px 23px;margin:23px 0\"\u003e\n\n\u003ch2 style=\"font-size:1.34em;margin-top:0\"\u003e02. What the files contain – document by document\u003c\/h2\u003e\n\n\u003cdiv style=\"overflow-x:auto\"\u003e\u003ctable style=\"width:100%;border-collapse:collapse;font-size:.94em\"\u003e\n\n\u003cthead\u003e\u003ctr style=\"background:#15394F;color:#fff\"\u003e\n\n\u003cth style=\"padding:12px;text-align:left\"\u003eDocument\u003c\/th\u003e\n\n\u003cth style=\"padding:12px;text-align:left\"\u003eFunction\u003c\/th\u003e\n\n\u003cth style=\"padding:12px;text-align:left\"\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e01. Price list for goods and products\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eCustomer-facing price list with item identity, total price incl. VAT, any surcharges, and unit price verification.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e02. Price list for services and hourly rates\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eService price list with fixed price, hourly rate, materials, travel, minimum billing, and clear calculation bases.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e03. Price change notice to customer\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eWritten customer letter with previous and new price, effective date, contact method, and contract check.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e04. Internal price decision and approval\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eDecision documentation for price adjustment with economic justification, control, authorized approval, and publication receipt.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e05. Price reduction and 30-day check\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eControl sheet for actual price history, promotional messaging, lowest 30-day price, and verifiable source.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e06. Swedish user guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eStep-by-step guide on consumer pricing, VAT, unit pricing, price reductions, price changes, and register management.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e07. English User Guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eEnglish guidance for the five Swedish main templates – not separate English main templates.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003e\u003cstrong\u003e08. Excel register with nine tabs\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7\"\u003eRegister for prices, services, price changes, VAT, history, 30-day check, approvals, and dashboard.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #d8e4e7;white-space:nowrap\"\u003eExcel\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\u003c\/div\u003e\n\n\u003cp\u003e\u003cstrong\u003eLanguage:\u003c\/strong\u003e The five main templates are in Swedish. The English User Guide is a user manual, not a translation of the main templates.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"mb-price-excel\"\u003eExcel price list with VAT, price history, and 30-day check\u003c\/h2\u003e\n\n\u003cp\u003eThe Excel workbook contains nine connected tabs where you can register your own goods and service prices, follow up on changes, and document who has reviewed and approved a price list. The overview shows \u003cstrong\u003eeight automatic summaries\u003c\/strong\u003e based on actual entered items – empty registers show zero.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eProduct price including VAT:\u003c\/strong\u003e Enter the price excluding VAT and a VAT rate verified for the current product. Excel calculates \u003cem\u003eprice incl. VAT = price excl. VAT × (1 + VAT rate)\u003c\/em\u003e, rounded to two decimal places. In the service tab, you can enter the hourly rate, number of hours, material cost, and VAT rate for an illustrative calculation of a specific assignment.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003ePrice changes:\u003c\/strong\u003e Excel shows the difference in currency and percentage between the old and new total price. \u003cstrong\u003e30-day price reductions:\u003c\/strong\u003e you can register promotional prices and a \u003cem\u003emanually verified\u003c\/em\u003e lowest price during the relevant period. Excel does not pull data from Shopify or POS systems and therefore does not in itself prove compliance with the 30-day rule. Save history and documentation separately.\u003c\/p\u003e\n\n\u003cp\u003eThe file has optional status fields, formula cells that are visually distinct from input cells, and version control fields. It does not contain any pre-filled fictitious items, prices, personal data, or customers.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-price-howto\"\u003eHow to use the price list template – 10 steps\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eChoose target audience:\u003c\/strong\u003e consumer, business, or separate price lists for both. Do not mix up the total price incl. VAT and clearly labeled B2B price excl. VAT.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eFill in company details\u003c\/strong\u003e, contact info, website URL, version number, and valid-through date.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eRegister goods and services\u003c\/strong\u003e with name, item\/service ID, unit, and actual scope.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCheck VAT rate per product\u003c\/strong\u003e against current sales. Do not automatically enter 25% for all goods and services.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCalculate and check total prices\u003c\/strong\u003e as well as any mandatory surcharges, fees, and unit prices.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eReview the price change:\u003c\/strong\u003e compare old and new prices and ensure that any existing customer contracts actually permit the change.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eVerify promotional claims\u003c\/strong\u003e and previous lowest price based on verified price history when the 30-day rule is applicable.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMake and document the price decision\u003c\/strong\u003e with an authorized decision-maker, date, and approved version.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003ePublish consistently\u003c\/strong\u003e in store, webshop, quotes, checkout, and customer materials, and archive the previous version.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eFollow up and revise\u003c\/strong\u003e registers, VAT assessments, customer letters, and published price information regularly.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2 id=\"mb-price-law\"\u003eWhat applies to price lists and price information in 2026\/2027?\u003c\/h2\u003e\n\n\u003ch3\u003ePrice list for consumers – total price and VAT\u003c\/h3\u003e\n\n\u003cp\u003eAccording to the \u003cstrong\u003ePrice Information Act (1991:601)\u003c\/strong\u003e and the Swedish Consumer Agency's guidance, price information to consumers must be clear and accurate. The main rule is that the consumer must see the \u003cstrong\u003etotal price including VAT\u003c\/strong\u003e. Mandatory additional costs must be displayed so that the price is not misleading. Rules apply to both physical retail and online commerce. For certain goods, a \u003cstrong\u003eunit price\u003c\/strong\u003e with the correct unit of measure is also required, for example, SEK\/kg or SEK\/l.\u003c\/p\u003e\n\n\u003ch3\u003ePrice information for services and hourly rates\u003c\/h3\u003e\n\n\u003cp\u003eIf the final price of a service cannot be specified in advance, the company must instead be able to state the \u003cstrong\u003ebasis for how the price is determined\u003c\/strong\u003e. The template helps you distinguish between fixed price, hourly rate, materials, travel, and any surcharges. Certain specific industries and agreements have their own requirements that must be checked.\u003c\/p\u003e\n\n\u003ch3\u003eVAT rates – important changes 2026\u003c\/h3\u003e\n\n\u003cp\u003eThe Swedish Tax Agency normally specifies \u003cstrong\u003e25%, 12%, 6%, or VAT exemption\u003c\/strong\u003e depending on the product and conditions. From \u003cstrong\u003eApril 1, 2026\u003c\/strong\u003e, VAT on food is normally 6%, while restaurant services are normally 12%. This may affect businesses with both take-away and dine-in service. The applicable VAT rate may not be determined solely based on the industry name. Excel therefore requires explicit entry of a verified VAT rate for each price row.\u003c\/p\u003e\n\n\u003ch3\u003ePrice reduction – lowest price in the last 30 days\u003c\/h3\u003e\n\n\u003cp\u003eWhen a consumer-facing price reduction is advertised, the company must, as a general rule, state the previous lowest price used for the product during the \u003cstrong\u003e30 days preceding the price reduction\u003c\/strong\u003e. Specific exceptions and rules for, e.g., gradual price reductions may apply. It is not sufficient to enter an estimated regular price – use actual history and document the source.\u003c\/p\u003e\n\n\u003ch3\u003ePrice change letters and existing contracts\u003c\/h3\u003e\n\n\u003cp\u003eSending a price change notice does not automatically imply the right to unilaterally raise the price of an existing, binding contract. Check the price adjustment clause, relevant consumer protection rules, contract type, and any notification or termination rights. The price change letter is a communication tool, not an automatic contract amendment decision.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#FFF5E8;border:1px solid #E7D4B9;border-left:5px solid #B1813C;border-radius:10px;padding:17px 19px;margin:20px 0\"\u003e\n\n\u003cstrong\u003eLegal limitation\u003c\/strong\u003e\u003cp style=\"margin:8px 0 0\"\u003eGeneral document templates and price registers, not authority-approved tax rules, certified price monitoring, or legal advice for a specific contract. Verify current VAT, industry requirements, unit pricing, 30-day rules, and contract terms in each specific case. Source review October 18, 2026; the 2027 version marking is not a guarantee for future legal changes.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2\u003eRelated templates at Mallbutiken.se\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003ca href=\"\/en\/products\/priskalkyl-tackningsbidrag-produkt-tjanst-2026-2027\"\u003ePrice calculation \u0026amp; contribution margin\u003c\/a\u003e – for profitability calculations and price setting before publication.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003ca href=\"\/en\/products\/offertmall-offertkalkyl-excel-2026-2027\"\u003eQuote template \u0026amp; quote calculation\u003c\/a\u003e – for customer-specific bids, calculations, and quote letters.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003ca href=\"\/en\/products\/receptkalkyl-menyprissattning-2026-2027-restaurang-cafe-excel-word-pdf\"\u003eRecipe calculation \u0026amp; menu pricing\u003c\/a\u003e – for restaurant and café with specific raw material and price calculation.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003ca href=\"\/en\/products\/allmanna-villkor-mall-e-handel-foretag-2026\"\u003eGeneral terms and conditions for e-commerce\u003c\/a\u003e – for contract and purchase terms that need to align with published prices.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2 id=\"mb-price-faq\"\u003eFrequently asked questions about price lists\u003c\/h2\u003e\n\n\u003ch3\u003eHow do you create a price list in Word?\u003c\/h3\u003e\n\n\u003cp\u003eOpen the template, enter the company, products or services, units, current prices, any surcharges, valid-through date, and contact. Check VAT and unit price before publishing.\u003c\/p\u003e\n\n\u003ch3\u003eIs there an Excel template that calculates VAT?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The Excel register calculates the price including VAT from the price excluding VAT and the entered VAT rate. You must personally determine and verify the correct VAT rate.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the price list for hourly rates and services?\u003c\/h3\u003e\n\n\u003cp\u003eYes. A separate service price list and an Excel tab for hourly rate, hours, materials, and VAT are included.\u003c\/p\u003e\n\n\u003ch3\u003eMust I show the price including VAT?\u003c\/h3\u003e\n\n\u003cp\u003eWhen prices are marketed to consumers, the general rule is total price including VAT. Additional fees must be clearly disclosed, and rules may vary between industries.\u003c\/p\u003e\n\n\u003ch3\u003eIs a template for notifying a price increase included?\u003c\/h3\u003e\n\n\u003cp\u003eYes, a price change letter is included. It does not replace the requirement that the change must actually be permitted under contract and law.\u003c\/p\u003e\n\n\u003ch3\u003eCan Excel automatically check the previous lowest price for 30 days?\u003c\/h3\u003e\n\n\u003cp\u003eNo. You register a manually verified amount and document the source\/history. Excel calculates any discount difference but does not pull prices from a webshop or POS system.\u003c\/p\u003e\n\n\u003ch3\u003eDoes Excel have different VAT rates?\u003c\/h3\u003e\n\n\u003cp\u003eYes. You can enter the VAT rate applicable to each row, for example, 25%, 12%, 6%, or 0% when legally appropriate.\u003c\/p\u003e\n\n\u003ch3\u003eIs an English price list included?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Five main templates and a user guide are in Swedish. An English User Guide is included, not separate English main templates.\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\/prisinformation-regler-for-foretag\/\" target=\"_blank\" rel=\"noopener\"\u003eSwedish Consumer Agency – price information and marketing\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.konsumentverket.se\/lagar\/prisinformationslagen-konsument\/\" target=\"_blank\" rel=\"noopener\"\u003eSwedish Consumer Agency – Price Information Act and previous price\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.skatteverket.se\/foretagorganisationer\/moms\/saljavarorochtjanster\/momspavarorochtjanster.4.58d555751259e4d66168000409.html\" target=\"_blank\" rel=\"noopener\"\u003eSwedish Tax Agency – VAT rates and exemptions\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/prisinformationslag-1991601_sfs-1991-601\/\" target=\"_blank\" rel=\"noopener\"\u003eSwedish Parliament – Price Information Act (1991:601)\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003csmall\u003eSvenska Dokumentmallar · Version 1.0 – 2026\/2027 · Source check 2026-10-18 · Word (DOCX), searchable PDF and Excel (XLSX).\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55838082826582,"sku":"PRISLISTA-PRISANDRING-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/prislista-prisandring-2027-hero_ff4d8e5d-38e7-4fd1-b127-ba834d8a5530.png?v=1792309421","url":"https:\/\/mallbutiken.se\/en\/products\/prislista-prisandring-varor-tjanster-excel-2027","provider":"Mallbutiken","version":"1.0","type":"link"}