| Page Tree | ||
|---|---|---|
|
KU41 is the reporting for general income for funds that should be reported by fund companies among others. Detailed information can be found here: https://www.skatteverket.se/download/18.361dc8c15312eff6fd320ff/1478789803472/kontrolluppgifter--ranta-utdelning-mm-skv373-utgava30.pdf
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 goes 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 ETS'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 |
|---|---|
| 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 other 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 |
| BfsAmountAsset1 | This is the currency amount that was received for the sale, the proceeds |
| BfsAcquisitionValue | This is the acquisition value for the position in BFS |
| BfsAssetName | This is the name of the instrument in BFS |
| BfsAsset1Currency | The currency code of the cash that was received from the sale of the instrument |
| BfsCpfPrice | |
| BfsCpnPrice | |
| BfsInstrumentCurrency | The currency code that the instrument is traded in |
| BfsInstrumentType | The Instrument type id |
| BfsSoldToISK | This shows TRUE if the sales was made to an ISK account (KU30) and FALSE if not. |
| ReportAddress | This is the address of the account owner for the record that is being reported |
| ReportAmountAsset1 | This is the received amount from the sale in the currency of BfsAsset1Currency which means the currency that was used for the proceeds from the sale |
| ReportAcquisitionValue | The acquisition value that will be used for the report |
| ReportAssetName | This is the name of the instrument in BFS |
| ReportAsset1Currency | The currency code of the cash that was received from the sale of the instrument and that will be used in the report |
| ReportCity | This is the city of the account owner for the record that is being reported |
| ReportCpfPrice | |
| ReportCpnPrice | |
| ReportFirstName | This is the first name of the account owner for the record that is being reported |
| ReportFundNotTradedInMarketplace | This is TRUE if the fund is categorized as not traded in the marketplace |
| ReportInstrumentCurrency | The currency code that the instrument is traded in |
| ReportInterestFund | This is TRUE if the fund is categorized as an interest fund |
| ReportPersonalNumber | This is the personal number of the owner of the account being reported |
| ReportEarningsLoss | This is the result from the trade and will be included if the setting Ernings/Loss was selected |
| ReportSaleAmount | This is the received payment for the sale and will be included if the setting Sale Amount is selected |
| ReportSoldToISK | This shows TRUE if the sales was made to an ISK account (KU30) and FALSE if not. |
| ReportTaxCountry | This shows the tax country code for where the account owner is taxable |
| ReportZip | This is the zip code of the account owner |
| ReportOtherPersonalNumber | This is the personal number of the owner of the account being reported or other form of tax identification number |
| 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 KU40 and we do this by importing the Excel sheet.