Page Comparison

Page Tree

root	Tax 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 – ränta, utdelning m.m. (SKV 373) Lämna kontrolluppgifter | 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.

Image Removed

Image Added

The Excel file will have the following columns.

The fields mean the following.

Column name	Description
ReportType	This is the KU number for the record
AppInterestRate	This is the interest rate that was stored for the report
BfsISIN	This is the ISIN code of the instrument in BFS
BfsAssetName	This is the name of the instrument
BfsTaxCountry	This shows the country code for where the account owner is taxable
BfsTotalMarketValueAccountCurrency	This is the position value in the base currency of the account
ReportISIN	This is the ISIN code of the instrument that will be used in the report
ReportAccountNumber	This is the account number for where the trade was made
ReportAccountOwner	This is the tax id of the owner of the account
ReportCountryCode	This is the country code for where the account owner is registered
ReportOtherPersonalNumber	This is the personal number of the owner of the account being reported or another form of tax identification number
ReportFirstName	This is the first name of the account owner for the record that is being reported
ReportLastname	This is the last name of the account owner for the record that is being reported
ReportAddressStreet	This is the street address of the account holder
ReportAddressZip	This is the zip code of the account owner
ReportAddressCity	This is the city of the account owner for the record that is being reported
ReportAssetName	This is the instrument name that will be used in the report
ReportInterestValue	This is the calculated interest amount that will be reported
ReportDeductedTax	This is the amount of deducted tax that has occurred
ReportPaidOutDividend	This is how much dividend that has been paid out
RowNumber	This is the specification number of the record in the report
OwnerId	This 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.
AppIncomeYear	This is the income year that is set in the Tax Reporting Application.
AppHouseOrganizationNumber	This is the organization number for the company that is submitting the tax report to the tax agency
AppHouseName	This is the name of the organization that is submitting the tax report to the tax agency
BfsFirstName	This is the first name of the account owner for the record that is being reported
BfsLastName	This is the last name of the account owner for the record that is being reported
BfsAddress	This is the address of the account owner for the record that is being reported
BfsZip	This is the zip code of the account owner for the record that is being reported
BfsCity	This is the city of the account owner for the record that is being reported
BfsAccountNumber	This is the account number in BFS for the reporting record
BfsPersonalNumber	This 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.

Image Removed

Image Added

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 file looks like this.

KU41

Code Block

language	xml

<?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

name	KU41_2016_12_29.pdf

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

Versions Compared

Old Version 14

New Version Current

Key

KU41