The value for an ISK is calculated for each quarter and then multiplied with a certain interest rate (1.4 % for 2016).
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 that 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 lets 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 part
Description
Default
This means that the transaction type relates to the standard transaction types in BFS which are pre-installed
Transfer
This can be Trade, Transfer or Payment and reflects the three main types of transactions in BFS
Trade
This reflects if the transaction type is used for trade or settle dimension transactions
Cash/Instrument
This 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 name
Description
ReportType
This 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.
BfsDepositValue
Using the same data as above the total deposits for the period was 30,000 SEK.
ReportAccountValue
The total account value for the report reflects the summarized values above and is 50,000 SEK.
ReportInterest
This 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).
ReportAccountNumber
This is the account number in BFS
ReportAccountOwner
This is the tax id of the owner of the account
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