Skip to content

Export report

The Export to Excel dialog creates a documentation report for a selected year. You can use the report to reconcile figures against a broker’s annual statement or as supporting documentation if requested by the Norwegian Tax Administration.

Select File → Export report…. You can also use Export report… on the year summary. In that case, the year shown there is preselected. The File menu defaults to the previous calendar year.

The menu item is available when the portfolio contains registered events.

Option Meaning
Selected year The report is calculated through 31 December of this year. Later events are excluded.
All accounts All accounts in the portfolio are included by default, independently of the toolbar’s account filter. Clear the checkbox to select one or more accounts.
Include previous year summaries for each security Adds summaries for earlier years to each security worksheet. This option is off by default.

The security worksheets also show older purchases and other registered events included in the selected accounts’ event history. The option for previous year summaries only controls the additional summary tables.

The report uses the Include shielding deduction setting from Preferences. The dialog shows whether the calculation is enabled. Country and listing-status filters on the year summary do not limit the export.

Click Export to Excel to download AktieFiks_YYYY.xlsx. The file is created locally in the browser and uses the app’s language at the time of export.

The report contains these worksheets:

Worksheet Contents
Report information Report year, creation time, app version, included accounts, calculation settings, and shielding rates. Missing valuations and rates are listed here.
Year summary Dividends, realised results, withholding tax, year-end quantities, and registered year-end values. Stocks, funds, options, and subscription rights have separate tables. Securities sold during the year can also be included. Shielding amounts are shown when the calculation is enabled.
Year-end holdings Quantities, remaining cost basis, registered year-end values, and any unused shielding at 31 December. Proceeds received for open short positions are shown separately from acquisition costs.
Dividends by country Dividends and withholding tax grouped by the country registered for the stocks and funds.
One worksheet per security A summary for the report year, event history through year-end, the year’s realised trades with FIFO results, open FIFO positions at 31 December, and the registered valuation basis. Previous year summaries are included if selected.

Events show original amounts, currencies, exchange rates, and NOK amounts where those details are available. Source event ID links an automatically generated event to the event that created it, for example a spinoff or option exercise.

Names in the year summary and holdings worksheets link to the security’s detail worksheet. Links at the top of each detail worksheet return to both overviews, directly to the security’s row where it exists. The top rows are frozen so the links remain visible when you scroll down.

Summaries and calculated results are shown in NOK. Registered year-end values follow the valuation basis in the app and are not always market values.

Missing year-end values for remaining holdings are marked Missing, including totals that would otherwise be incomplete. A registered value of zero is shown as zero.

For a current or future year, the report only includes events that have already been registered. If a shielding rate is missing, the app uses zero for that year. This is noted in the report, and shielding amounts may therefore be incomplete.

The report reflects the information at the time of export. Create a new report after changing events, valuations, or calculation settings.

Also save the portfolio file with File → Save to continue working in AksjeFiks. The Excel report cannot be used to reopen the portfolio.