...
This report includes the sum of credited or paid intersts that has been made throughout the year. As far as settings go we have to set which transaction types and account types to use and then the tax application will sum up the amount of the interest transactions and the deducted tax connected to these transactions.
In the Tax Reporting Application, we will click on Get Excel for KU20.[bild]
...
This will open the following form dialog where we can select transaction types and account types.
BILD
BILD DÄR MAN TRYCkER CONFIRM
The Excel file will have the following columns.
BILD på alla kolumner i excel:en
The fields mean the following. [ÄNDRA I NEDAN TABELL]
...
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
When we are happy with the excel file, we will create the control report xml.
This is how the KU20 xml will look like.
...
In the Excel file the interest and reported tax deducted is in columns E and F.
...
When we upload the excel file to create the control report xml, it will look like this.
...
And the pdf file that was uploaded to the user in BFS looks like this.BILD
...