Export a tax year's gains, dividends and costs

Change one setting and last year’s realised gain changes with it. The cost-basis method decides which purchase each sale used up, so switching it re-reads every past sale, and the Realized report is the only place the difference shows. Set it before you export, not after your adviser has the file.

The export itself is plain: Reports has three tabs, Realized, Dividends and Costs, each with a period and an Export CSV button, and each file is the table you were looking at. The surprises are the method, the period and what the files hold, in that order below. The columns are at the end.

Before you start

You have imported every account whose sales, dividends or fees belong in the year, and closed the gaps a red notice points to. Keep the broker’s annual statements at hand: they are the record, and the figures here are only as complete as what you imported. Which of these figures a tax return needs, and how, depends on your country and your situation; your tax adviser or tax authority decides that, not this guide.

Set the cost-basis method

Open Settings, then Portfolio, and look at Cost-basis method. The two choices are “FIFO — the oldest lot goes first” and “Moving average”. FIFO is the default. Which method applies to you is not for Stonqs to say: ask your adviser. Your broker’s tax statement, if it has one, names the method it used, and the totals can match only when the setting agrees.

The two methods only disagree about a position that was partly sold. A made-up example, worked by hand from the rule in that reference, in EUR, with no fees: buy 10 shares at 100, buy 10 more at 120, sell 10 at 130.

	FIFO	Moving average
Cost of the 10 sold	10 x 100 = 1,000	10 x 110 = 1,100
Realised result	1,300 - 1,000 = +300	1,300 - 1,100 = +200
Cost left in the 10 still held	10 x 120 = 1,200	10 x 110 = 1,100

The realised result differs by 100 and the cost still held differs by the same 100 in the other direction. Over the life of the position the totals agree; the methods disagree about which year counts it. The same reference says it is “a tax question rather than a valuation one”.

The positions table can show both methods in side-by-side columns, which is a quick way to see whether the choice matters for you before you export.

Make a period for the year

Open Reports. The period strip offers 1M, 3M, YTD, 1Y, 3Y, 5Y and All, and YTD runs from 1 January to the date the app is set to. That is the tax year only while the year is still running.

For a finished year, select the plus button at the end of the strip (“Add a period”), then New period. Name it (“Tax year 2025”), set Kind to “Two dates”, enter From and To, and save. Select the new period in the strip. The window includes both end dates. Check the From and To against the year your adviser asked for.

Two cautions. A period that ends in the future stops at today, so a half-finished year exports as it stands. And the tax year is not the calendar year in every country; enter the dates your tax authority names. Because lots are built from your whole history, a sale in the window that consumed a purchase made years earlier still reports that purchase’s cost.

Export the realised gains

Open the Realized tab. The four tiles show Result, Return, Proceeds and Disposals. The Result is proceeds minus cost basis, fees and taxes, on disposals only: sales and outgoing deliveries inside the window. A holding you still own has no realised result however much it gained; that is on the Positions screen.

Press Export CSV and choose one of three tables:

• “Transactions — every row”: one line per disposal. This is the file to hand over.
• “Totals by instrument”: the same figures added up per ticker.
• “Totals by year”: one line per calendar year inside the window. It is useful when the window crosses a year end.

A purchase commission has no column of its own, because it is already inside the cost basis. The on-screen column “Of it, FX” (the part of the result made by the exchange rate rather than the instrument) is not in the CSV. If your adviser asks for it, copy it from the screen.

The save dialog suggests a name such as gains-detail-2025-01-01_2025-12-31.csv, with the section and the window in it. Keep the names; they tell two years’ files apart.

Export dividends and costs

Switch to Dividends. The tiles are Received (net of withholding tax, what reached the cash accounts), Accrued (the gross amount), Tax withheld and Payments. Gross and net are both real numbers: withholding tax is a separate operation, not a smaller dividend. Export CSV offers “Payments — every row”, “Totals by instrument” and “Totals by year”.

In the by-instrument table, “Pays”, “Yield a year” and “Yield on cost” read the instrument’s whole payment history and ignore your window. The yield-on-cost column is the one that reaches the CSV, so it will not match a year-only calculation. A closed position shows a dash there, which is empty in the file.

Switch to Costs, the third tab. It counts standalone fees and taxes only: account charges, custody fees, a tax charged on its own. A commission paid inside a purchase went into that position’s cost basis and is not here. Counting it twice would overstate what the portfolio cost, and the two fee figures are explained in their own post. Export CSV offers “Transactions — every row”, “Totals by kind”, “Totals by account” and “Totals by year”.

What the files contain

Every file is semicolon-separated, with a comma as the decimal mark and a UTF-8 byte-order mark at the start. That is what a spreadsheet on a European locale opens without asking. On another locale, if the columns land in one or the numbers read as text, use the spreadsheet’s text-import dialog and pick semicolon as the separator and comma as the decimal mark. The export applies no rounding of its own.

Money columns carry your base currency’s code in the header (proceeds EUR, for a portfolio in euros). Each file ends, after a blank row, with one line in the interface’s language: “Recorded with Stonqs, a portfolio tracker — not investment advice. Figures are derived from data you entered and from free third-party sources, with no guarantee of accuracy.” Delete it if your adviser’s import cannot take a text row; it is not part of the table.

The header of each detail file, as the export code writes it:

File	Columns
Realised gains, every row	date; transaction; ticker; name; quantity; proceeds; cost basis; fees; taxes; result; return
Dividends, every row	date; account; ticker; name; currency; accrued in currency; accrued; tax; fees; received
Costs, every row	date; kind; account; ticker; name; currency; amount in currency; amount

On the gains rows, result is proceeds minus fees, taxes and cost basis, and return is the result divided by the cost basis; it is empty where the cost is zero, such as shares delivered in for free and then sold. In the dividends rows, accrued is the gross payment, tax is the withholding, and received is what arrived. Income and charges in another currency are converted into the base currency at the rate of the day they were paid, and that figure is fixed at that day. These are Stonqs’s rates, not the broker’s own conversion, so a statement in another currency can differ from the base-currency columns.

If something goes wrong

The Reports screen says “No transactions — there is nothing to report yet”, or a tab says there is nothing in this period. The window holds no sale, dividend or fee. Check the From and To of your period, that the app’s date is not moved back before the year’s end, and the account picker. A realised result appears only on a sale.

A red notice above the screen says an instrument was sold without being bought. The history has a hole, usually shares moved in from another broker. Until you fill it, the figures for that instrument are estimates: the uncovered part counts as bought on the sale day at the sale price, so its result is nil apart from costs. Fix it with the missing purchase before you export.

The dividends are far below the broker’s statement. Check the picker first (a securities account alone hides income), then whether the deposit account is part of the portfolio in Settings, under “Accounts in the portfolio”. An account left outside appears in no report.

The totals differ from your broker’s annual tax statement. Expect it, and ask the adviser to treat the broker’s statement as the record. The usual causes are the cost-basis method, the exchange rate each side used, a purchase never imported, and a window that does not match the broker’s year.

Market data comes from free third-party sources without warranty. The figures here are derived from what you imported, and your broker’s own statements are what counts.