--- title: Country-by-Country Reporting – Converting Excel to XML description: It is almost time to file the Country-by-Country report in a format called XML schema. Many multinational enterprises (MNEs) are now probably ready with their report but are uncertain on how to file the CbC report. image: https://blogg.pwc.se/hs-fs/hub/315629/file-346254160.png --- [![pwc-logo-1](https://blogg.pwc.se/hs-fs/hubfs/Imported%20sitepage%20images/pwc-logo-1.png?width=200&name=pwc-logo-1.png)](https://blogg.pwc.se/) ## Tax matters - Sweden's tax blog [‹ Back to the articles](https://blogg.pwc.se/taxmatters-en) 23 November 2017 | [Corporate taxation](https://blogg.pwc.se/taxmatters-en/topic/corporate-taxation) # Country-by-Country Reporting – Converting Excel to XML Contact PwC Reading time: 2 min ![PwC-skatteradgivning-regulations-and-standards.png](https://blogg.pwc.se/hs-fs/hub/315629/file-346254160.png?width=900&name=file-346254160.png) ![PwC-skatteradgivning-regulations-and-standards.png](https://blogg.pwc.se/hs-fs/hub/315629/file-346254160.png?width=150&name=file-346254160.png "PwC-skatteradgivning-regulations-and-standards.png")It is almost time to file the Country-by-Country report in a format called XML schema. Many multinational enterprises (MNEs) are now probably ready with their report but are uncertain on how to file the CbC report. MNE Groups with a financial year ending 31 December will be required to file their first Country-by-Country Report (CbCR) by 31 December 2017. The Report is required to be filed in a format called “Extensible Markup Language (XML)”. The intention for the OECD is to facilitate an easy and automatic exchange of information of the CBC report between different tax jurisdictions. They developed a user guide on a common reporting structure and format for the reporting to be adopted by all countries. However, many countries like Sweden have made some local adaptation and adjustments to this format and it is required for MNEs reporting in Sweden to adapt to this local reporting format. The Swedish Tax Authority (STA) has also opened a test webpage for MNE Group to test their CbC report in XML and check if all the data passes validation. If your CbC report does not pass the data validations, then you will receive an error report on the different areas where the data has failed to transmit. It will be prudent to test your data submission on the test website before you submit your final CbCR data. The webpage for final submission of the CbC report on the Swedish Tax Authority is expected to be open from 1 December 2017. PwC can assist MNE Groups on their issue of conversion from Excel to XML through a conversion tool. PwC has the necessary expertise and capabilities available to assist MNEs on their CbCR requirements. Please contact Rohit Sidhwani and Niklas Elofsson for more information regarding this solution. For more information about the Swedish Tax Authority XML schema, [click here](https://www.skatteverket.se/foretagochorganisationer/skatter/internationellt/landforlandrapporter.4.361dc8c15312eff6fd334a9.html) To test your XML, [click here](https://www.skatteverket.se/foretagochorganisationer/skatter/internationellt/landforlandrapporter/testtjanstforlandforlandrapporter.4.1927c51b15e7ee4387229b6.html) [![Do you have any questions on corporate taxation?](https://hubspot-no-cache-eu1-prod.s3.amazonaws.com/cta/default/315629/f5391ae9-6043-4e07-94f3-b00c7c0e3030.png)](https://hubspot-cta-redirect-eu1-prod.s3.amazonaws.com/cta/redirect/315629/f5391ae9-6043-4e07-94f3-b00c7c0e3030) ![PwC](https://blogg.pwc.se/hs-fs/hub/315629/file-2337440090.png) ### PwC PwC Sverige är marknadsledande inom revision och rådgivning med 2 700 medarbetare runt om i landet – vi finns där du finns! Vårt syfte är att skapa förtroende i samhället och lösa viktiga problem och våra värderingar genomsyrar allt vi gör. ## Subscribe to Tax Matters Get the latest news, directly to your inbox [Yes, I'd like to subscribe to Tax matters](https://cloud.email.pwc.se/tm-en-hubspot) ## Contact a tax advisor Do you need more information or do you have a question? [Get in Touch](https://www.pwc.se/kontakt) [Corporate taxation](https://blogg.pwc.se/taxmatters-en/topic/corporate-taxation) [Value Added Taxes, customs and excise duties](https://blogg.pwc.se/taxmatters-en/topic/value-added-taxes-customs-and-excise-duties) [Individual taxation](https://blogg.pwc.se/taxmatters-en/topic/individual-taxation) [Entrepreneur and SME Taxes](https://blogg.pwc.se/taxmatters-en/topic/entrepreneur-and-sme-taxes) [Recommended](https://blogg.pwc.se/taxmatters-en/topic/recommended) [Base Erosion and Profit Shifting (BEPS)](https://blogg.pwc.se/taxmatters-en/topic/base-erosion-and-profit-shifting-beps) [Seminars and courses](https://blogg.pwc.se/taxmatters-en/topic/seminars-and-courses) [Tax rules and regulations](https://blogg.pwc.se/taxmatters-en/topic/tax-rules-and-regulations) [Legal](https://blogg.pwc.se/taxmatters-en/topic/legal) [Pension](https://blogg.pwc.se/taxmatters-en/topic/pension) [Rekommenderad](https://blogg.pwc.se/taxmatters-en/topic/rekommenderad) ### What do you want help with? - [Services](https://www.pwc.se/en/services.html) - [Consulting](https://www.pwc.se/en/services/consulting.html) - [People and Organisation](https://www.pwc.se/en/services/consulting/people-organisation.html) - [Risk Management](https://www.pwc.se/en/services/risk-management.html) - [Audit and Assurance](https://www.pwc.se/en/services/audit-and-assurance.html) - [Tax](https://www.pwc.se/en/services/tax-sweden.html) - [Legal](https://www.pwc.se/en/services/legal.html) ### Doing business in Sweden - [Doing business in Sweden](https://www.pwc.se/en/business-sweden.html) - [Type of precense](https://www.pwc.se/en/business-sweden/type-of-presence.html) - [Tax issues](https://www.pwc.se/en/business-sweden/taxes-sweden.html) - [Operational matters](https://www.pwc.se/en/business-sweden/operational-matters-sweden.html) - [Registration requirements](https://www.pwc.se/en/business-sweden/registration-requirement-sweden.html) - [Compensate our employees](https://www.pwc.se/en/business-sweden/compensate-employees.html) ### About PwC - [About us](https://www.pwc.se/en/about-us.html) - [Offices](https://www.pwc.se/sv/kontor.html) - [Global pressreleases](https://press.pwc.com/) © 2018 - 2026 PwC. All rights reserved. PwC refers to the PwC network and/or one or more of its member firms, each of which is a separate legal entity. Please see [www.pwc.com/structure](https://www.pwc.com/structure) for further details. - [Integritetspolicy](https://www.pwc.se/integritetspolicy) - [Cookies](https://www.pwc.se/cookies) - [Legal](https://www.pwc.se/sv/om-pwc/ansvarsfriskrivning.html) - [Site provider](https://www.pwc.se/siteprovider) ```json { "@context" : "https://schema.org", "@type" : "WebSite", "name" : "PwC", "potentialAction" : { "@type" : "SearchAction", "query-input" : "required name=search_term_string", "target" : "https://blogg.pwc.se/search?term={search_term_string}" }, "url" : "https://blogg.pwc.se" } ``` ```json { "@context" : "https://schema.org", "@type" : "WebPage", "name" : "Country-by-Country Reporting – Converting Excel to XML", "url" : "https://blogg.pwc.se/taxmatters-en/country-by-country-reporting-converting-excel-to-xml" } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "PwC", "url" : "" }, "dateModified" : "2017-11-23T08:38:10+0000", "datePublished" : "2017-11-23T08:38:10+0000", "description" : "It is almost time to file the Country-by-Country report in a format called XML schema. Many multinational enterprises (MNEs) are now probably ready with their report but are uncertain on how to file the CbC report. ", "headline" : "Country-by-Country Reporting – Converting Excel to XML", "image" : "https://info.pwc.se/hs-fs/hub/315629/file-346254160.png", "keywords" : "Corporate taxation", "mainEntityOfPage" : { "@id" : "https://blogg.pwc.se/taxmatters-en/country-by-country-reporting-converting-excel-to-xml", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "name" : "PwC" } } ``` ```json { "@context" : "https://schema.org", "@type" : "BreadcrumbList", "itemListElement" : [ { "@type" : "ListItem", "item" : "https://blogg.pwc.se", "name" : "Home", "position" : 1 }, { "@type" : "ListItem", "item" : "https://blogg.pwc.se/taxmatters-en", "name" : "Tax matters - Sweden's tax blog", "position" : 2 }, { "@type" : "ListItem", "item" : "https://blogg.pwc.se/taxmatters-en/country-by-country-reporting-converting-excel-to-xml", "name" : "Country-by-Country Reporting – Converting Excel to XML", "position" : 3 } ] } ```