Versions Compared

Key

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

Page Tree
rootTax Reporting App

KU30 is the reporting for the Swedish Investment Savings Account (ISK) where the general value of the account should be reported. Detailed information can be found here: 
https://www.skatteverket.se/download/18.569165a01749e7ae7892631/1603976889365/kontrolluppgifter--ranta-utdelning-mm-skv373-utgava34.pdf (Inkomstår 2020Kontrolluppgifter – ränta, utdelning m.m. (SKV 373 utgåva 35) (skatteverket.se) (Inkomstår 2021)

The value for an ISK is calculated for each quarter and then multiplied with a certain interest rate (1.25% for 20202021).

Since you are able to create your own Account Types in BFS it is possible that you have created other account types to represent ISK accounts than our default account type and that is why you have to select which account types from BFS should be interpreted as ISK accounts.

To illustrate how this works we have created a test user in BFS with an account called KU30 where we have created a few deposits and also a purchase of shares.

In the Tax Reporting Tool we will now click on Get Excel for KU30.

This will open a dialogue where we can make our settings.

First, let us look at the Transaction Types that should be selected. For KU30 the transaction types that you have selected to use for transferring instruments and cash into ISK accounts should be selected. If you have not altered the default settings the transaction types should be Default_Transfer_Trade_Cash and Default_Transfer_Trade_Instrument.

The naming convention for the transaction types in BFS, in general, means the following.

Naming partDescription
DefaultThis means that the transaction type relates to the standard transaction types in BFS which are pre-installed
TransferThis can be Trade, Transfer or Payment and reflects the three main types of transactions in BFS
TradeThis reflects if the transaction type is used for trade or settle dimension transactions
Cash/InstrumentThis reflects if the transaction type is used for cash or instruments

In the example above we have selected the transaction type used for transferring cash (it is only the trade dimension that we include in the tax reports). We now need to add the transaction type for instrument transfers. Click on the image below to watch.

The next setting is Account types. By default in BFS the account type for ISK is called ISKAccount so if you have not changed this or added any new account types you should only have the ISKAccount selected here. If you need to add more account types you can click on the button "Select account types..." and get a list of account types that are available in your BFS instance.

Finally, you should set the interest rate to be used in the calculations.

Once you click on the button that says "Get Excel" you will receive an excel file in your browser. The excel file will contain the following records (click the image to maximize).

The fields mean the following.

Column nameDescription
ReportTypeThis is the KU number for the record
BfsAccountValue

This is the summarized value of the starting values for each quarter. Remember that for the account we made the following transactions.

This means that the quarterly calculations will look like below.

So the summarized total for BfsAccountValue is 50,000 SEK in this case.

BfsDepositValueUsing the same data as above the total deposits for the period was 30,000 SEK.
ReportAccountValueThe total account value for the report reflects the summarized values above and is 50,000 SEK.
ReportInterestThis is the interest that will be reported to the tax agency and for 2016 the interest is 1.4%. Before applying the interest the BfsAccountValue and BfsDepositValue will be added together (80,000 SEK) and then divided by 4 (4 quarters). The resulting amount of 20,000 SEK will then be used for calculating the ReportInterest (20,000 * 1.4% = 280 SEK).
ReportAccountNumberThis is the account number in BFS
ReportAccountOwnerThis is the tax id of the owner of the account
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 KU30 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
titleKU30
<?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-29T00:41:42.5140415+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="2312">
    <ku:Arendeinformation>
      <ku:Arendeagare>165555555555</ku:Arendeagare>
      <ku:Period>2016</ku:Period>
    </ku:Arendeinformation>
    <ku:Blankettinnehall>
      <ku:KU30>
        <ku:Inkomstar faltkod="203">2016</ku:Inkomstar>
        <ku:Specifikationsnummer faltkod="570">1</ku:Specifikationsnummer>
        <ku:Schablonintakt faltkod="815">280</ku:Schablonintakt>
        <ku:Kontonummer faltkod="817">10000289</ku:Kontonummer>
        <ku:UppgiftslamnareKU30>
          <ku:UppgiftslamnarId faltkod="201">165555555555</ku:UppgiftslamnarId>
        </ku:UppgiftslamnareKU30>
        <ku:InkomsttagareKU30>
          <ku:Inkomsttagare faltkod="215">197001010101</ku:Inkomsttagare>
        </ku:InkomsttagareKU30>
      </ku:KU30>
    </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.


By downloading the file we can see how it looks.

View file
nameKU30_2016_12_29.pdf
height250