Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Page Tree
rootTax Reporting App

KU41 is the reporting for general income for funds that should be reported by fund companies among others. Detailed information can be found here: Kontrolluppgifter – Kontrolluppgifter – ränta, utdelning m.m. (SKV 373 utgåva 35) (skatteverket.se)) | Skatteverket

This report only includes the value of fund positions that are held at the start of the income year that is being reported. As far as settings go we only have to set instrument types and account types together with the interest rate value to use.

To illustrate this we have created a test user with an account called KU41 where we have conducted a few trades during the previous year to establish a position worth 10,000 SEK each for two funds.

In the Tax Reporting Application, we will click on Get Excel for KU41.

This will open the following form.

For instruments, we have selected funds and ETF's.

The next setting is what account types to include. Since you are able to create your own account types in BFS we cannot assume that you have used the default account types so you need to select these. For example, you should not include the ISKAccount which is included in KU30.

Finally, there is the setting for which interest rate to use.

Once we are happy with the settings we should click on Get Excel.

This action will download the Excel file for us.

The Excel file will have the following columns.

The fields mean the following.

Column name
Description
ReportTypeThis is the KU number for the record
AppInterestRateThis is the interest rate that was stored for the report
BfsISINThis is the ISIN code of the instrument in BFS
BfsAssetNameThis is the name of the instrument
BfsTaxCountryThis shows the country code for where the account owner is taxable
BfsTotalMarketValueAccountCurrencyThis is the position value in the base currency of the account
ReportISINThis is the ISIN code of the instrument that will be used in the report
ReportAccountNumberThis is the account number for where the trade was made
ReportAccountOwnerThis is the tax id of the owner of the account
ReportCountryCodeThis is the country code for where the account owner is registered
ReportOtherPersonalNumberThis is the personal number of the owner of the account being reported or another form of tax identification number
ReportFirstNameThis is the first name of the account owner for the record that is being reported
ReportLastnameThis is the last name of the account owner for the record that is being reported
ReportAddressStreetThis is the street address of the account holder
ReportAddressZipThis is the zip code of the account owner
ReportAddressCityThis is the city of the account owner for the record that is being reported
ReportAssetNameThis is the instrument name that will be used in the report
ReportInterestValueThis is the calculated interest amount that will be reported
ReportDeductedTaxThis is the amount of deducted tax that has occurred
ReportPaidOutDividendThis is how much dividend that has been paid out
RowNumberThis is the specification number of the record in the report
OwnerIdThis is the id (BrickID see the API documentation at http://api.bricknode.com) of the Legal Entity that owns the account. This can be used in your own applications for example.
AppIncomeYearThis is the income year that is set in the Tax Reporting Application.
AppHouseOrganizationNumberThis is the organization number for the company that is submitting the tax report to the tax agency
AppHouseNameThis is the name of the organization that is submitting the tax report to the tax agency
BfsFirstNameThis is the first name of the account owner for the record that is being reported
BfsLastNameThis is the last name of the account owner for the record that is being reported
BfsAddressThis is the address of the account owner for the record that is being reported
BfsZipThis is the zip code of the account owner for the record that is being reported
BfsCityThis is the city of the account owner for the record that is being reported
BfsAccountNumberThis is the account number in BFS for the reporting record
BfsPersonalNumberThis is the personal number of the owner of the account being reported

If we for some reason are not happy with the contents of the tax report we can change this directly in the Excel sheet.

Now we are ready to create the tax report for KU41 and we do this by importing the Excel sheet.

The uploaded file will appear at the bottom of the page and we can also select if we would like to create PDF-files for the customer of the KU's that we are reporting so that the customer can log on to BFS and download their KU's as verifications. For this example, we will generate the PDF files by checking the box for this and then click on Download tax report.

We will now receive a compressed zip file with the KU-reports that we generated.

The zip file contains an XML-file (the format that should be uploaded to the tax agency) for each KU report type.

For the example that we just created the XML fill looks like this.

Code Block
languagexml
themeRDark
titleKU41
<?xml version="1.0" encoding="utf-8"?>
<Skatteverket xmlns:ku="http://xmls.skatteverket.se/se/skatteverket/ai/komponent/infoForBeskattning/2.0" xmlns:gm="http://xmls.skatteverket.se/se/skatteverket/ai/gemensamt/infoForBeskattning/2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmls.skatteverket.se/se/skatteverket/ai/instans/infoForBeskattning/2.0 http://xmls.skatteverket.se/se/skatteverket/ai/kontrolluppgift/instans/Kontrolluppgifter_2.0.xsd " omrade="Kontrolluppgifter" xmlns="http://xmls.skatteverket.se/se/skatteverket/ai/instans/infoForBeskattning/2.0">
  <ku:Avsandare>
    <ku:Programnamn>KUfilsprogrammet</ku:Programnamn>
    <ku:Organisationsnummer>165555555555</ku:Organisationsnummer>
    <ku:TekniskKontaktperson>
      <ku:Namn>Firstname Lastname</ku:Namn>
      <ku:Telefon>0500-1234561</ku:Telefon>
      <ku:Epostadress>info@yourdomain.com</ku:Epostadress>
      <ku:Utdelningsadress1>Street 20</ku:Utdelningsadress1>
      <ku:Postnummer>11111</ku:Postnummer>
      <ku:Postort>CITY</ku:Postort>
    </ku:TekniskKontaktperson>
    <ku:Skapad>2016-12-29T11:52:45.2623019+00:00</ku:Skapad>
  </ku:Avsandare>
  <ku:Blankettgemensamt>
    <ku:Uppgiftslamnare>
      <ku:UppgiftslamnarePersOrgnr>165555555555</ku:UppgiftslamnarePersOrgnr>
      <ku:Kontaktperson>
        <ku:Namn>Firstname Lastname</ku:Namn>
        <ku:Telefon>0500-123456</ku:Telefon>
        <ku:Epostadress>info@yourdomain.com</ku:Epostadress>
        <ku:Sakomrade>Skatteverket</ku:Sakomrade>
      </ku:Kontaktperson>
    </ku:Uppgiftslamnare>
  </ku:Blankettgemensamt>
  <ku:Blankett nummer="2313">
    <ku:Arendeinformation>
      <ku:Arendeagare>165555555555</ku:Arendeagare>
      <ku:Period>2016</ku:Period>
    </ku:Arendeinformation>
    <ku:Blankettinnehall>
      <ku:KU41>
        <ku:InkomsttagareKU41>
          <ku:LandskodTIN faltkod="076">SE</ku:LandskodTIN>
          <ku:Fornamn faltkod="216">Tax</ku:Fornamn>
          <ku:Efternamn faltkod="217">Tester</ku:Efternamn>
          <ku:Gatuadress faltkod="218">Street1</ku:Gatuadress>
          <ku:Postnummer faltkod="219">Zip</ku:Postnummer>
          <ku:Postort faltkod="220">City</ku:Postort>
          <ku:AnnatIDNr faltkod="224">197001010101</ku:AnnatIDNr>
          <ku:TIN faltkod="252">197001010101</ku:TIN>
        </ku:InkomsttagareKU41>
        <ku:UppgiftslamnareKU41>
          <ku:UppgiftslamnarId faltkod="201">165555555555</ku:UppgiftslamnarId>
        </ku:UppgiftslamnareKU41>
        <ku:Inkomstar faltkod="203">2016</ku:Inkomstar>
        <ku:Specifikationsnummer faltkod="570">1</ku:Specifikationsnummer>
        <ku:VPNamn faltkod="571">Fund 1 Foreign specialty fund</ku:VPNamn>
        <ku:ISIN faltkod="572">SE1112223334</ku:ISIN>
        <ku:Schablonintakt faltkod="815">100</ku:Schablonintakt>
      </ku:KU41>
    </ku:Blankettinnehall>
  </ku:Blankett>
  <ku:Blankett nummer="2313">
    <ku:Arendeinformation>
      <ku:Arendeagare>165555555555</ku:Arendeagare>
      <ku:Period>2016</ku:Period>
    </ku:Arendeinformation>
    <ku:Blankettinnehall>
      <ku:KU41>
        <ku:InkomsttagareKU41>
          <ku:LandskodTIN faltkod="076">SE</ku:LandskodTIN>
          <ku:Fornamn faltkod="216">Tax</ku:Fornamn>
          <ku:Efternamn faltkod="217">Tester</ku:Efternamn>
          <ku:Gatuadress faltkod="218">Street1</ku:Gatuadress>
          <ku:Postnummer faltkod="219">Zip</ku:Postnummer>
          <ku:Postort faltkod="220">City</ku:Postort>
          <ku:AnnatIDNr faltkod="224">197001010101</ku:AnnatIDNr>
          <ku:TIN faltkod="252">197001010101</ku:TIN>
        </ku:InkomsttagareKU41>
        <ku:UppgiftslamnareKU41>
          <ku:UppgiftslamnarId faltkod="201">165555555555</ku:UppgiftslamnarId>
        </ku:UppgiftslamnareKU41>
        <ku:Inkomstar faltkod="203">2016</ku:Inkomstar>
        <ku:Specifikationsnummer faltkod="570">2</ku:Specifikationsnummer>
        <ku:VPNamn faltkod="571">Fund 2 Normal</ku:VPNamn>
        <ku:ISIN faltkod="572">SE1112223335</ku:ISIN>
        <ku:Schablonintakt faltkod="815">100</ku:Schablonintakt>
      </ku:KU41>
    </ku:Blankettinnehall>
  </ku:Blankett>
</Skatteverket>

The information at the top of the XML file called "Avsandare" and "Uppgiftslämnare" is configured in the settings section for the reporting tool which was described here: Sweden

We can also navigate to the test user in BFS and make sure that the PDF file was created there, one for each report setting.

The pdf files look like this.

View file
nameKU41_2016_12_29.pdf
height250

Kontrolluppgifter – ränta, utdelning m.m. (SKV 373 utgåva 35) (skatteverket.se)