Track dividends and the tax withheld

Take a made-up dividend: 80.00 EUR before withholding, 10.00 EUR withheld, 70.00 EUR in your account. Stonqs shows all three, under different names, but only if the 10.00 was recorded in the right place. Recorded as its own row next to the dividend, the way an Interactive Brokers Flex Query writes it, it never reaches the Income screen’s tax figure, and Received in the period reads 80.00.

Check that before you trust the numbers. The figures here are computed from the transactions you imported; exchange rates come from free third-party sources without warranty, and your broker’s statement is the record.

Before you start

You have a portfolio with the dividends in it, from a broker’s CSV or an Interactive Brokers Flex Query. Have the broker’s dividend statement for one payment open, to compare against. This guide shows no tax treatment: how withholding is credited or reclaimed depends on your country and your situation, and your tax authority or a tax adviser answers that.

Open Income and pick the accounts

Choose Income in the sidebar. The account scope reads “Whole portfolio” until you narrow it. Leave it there for the first look.

A dividend is paid to a deposit (cash) account. If you narrow the scope to a securities account alone, dividends, interest and fees fall outside that lens and the screen shows little or nothing. That is the scope, not a lost payment. An instrument’s own dividend history ignores the scope, so it still shows on the instrument.

Read gross, tax and net

Set the period control, then read the four figures above the panels:

Label	What it is
Received in the period	Net: what reached the cash accounts, after withholding. The hint compares it with the previous window of the same length.
Tax withheld	Withheld at the source, so not in what was received. The hint gives it as a percentage of the accrued amount.
Accrued	Gross: what the instruments distributed, before withholding. The hint counts the payments.
Portfolio yield	Accrued against the portfolio’s current market value, not against what you paid.

Some of these can sit behind “more figures”; “Show less” folds them back.

Gross and net are both real numbers (income and costs), and the app keeps both: Accrued minus Tax withheld, and minus any fee on the same row, is Received. The percentage under Tax withheld is Tax withheld divided by Accrued over your own rows. The app has no table of withholding rates for any country. Portfolio yield is income against value, not a return; reading your returns covers those.

To see dividends alone, set “Income kind” to “Only dividend”. It narrows the whole screen, not just the list.

Find the payer and the month

“Who pays” splits the period by instrument. “What it is made of” splits it by kind. The calendar shows the whole history whatever the period, because one year of it is not a seasonal pattern. Pick a month and a panel opens with Accrued, Tax withheld, Received and the same month a year earlier.

Underneath, “Payments” lists every income payment in the period, newest first, with the date, the instrument and the amount as the broker recorded it.

Compare one payment with the broker’s statement

Open Reports and choose the “Dividends” tab. The “Payments” table there has one row per payment with the columns Accrued in currency, Accrued, Tax and Received, in the base currency; “By instrument” and “By year” add up the same rows. Export CSV writes what the tab shows for the period. Exporting one tax year is the next guide.

Pick one payment and check three things against the broker’s statement: the gross in its own currency, the tax, the net. If Accrued and Received match to the cent, and the broker did withhold, the tax is missing from the row, and the next section is your case.

Check where the tax was recorded

A transaction has a Tax field next to Commission. On a dividend row, Tax is the withholding on that payment: Stonqs subtracts it from the payment, shows it as Tax withheld, and the net lands in Received. A row of kind Tax is a different thing, a standalone charge: it reduces your cash and appears in Reports under “Costs” and in the tax rate on Performance, but the dividend it belongs to still counts in full.

How your export spells it	Where it lands	Income shows
A tax column on the dividend row (CSV headers such as “Withholding tax”, “Tax”, “Steuer”)	The dividend’s Tax field	Tax withheld filled, Received net
A separate row (Interactive Brokers “Withholding Tax” in a Flex Query)	A Tax transaction beside the dividend	Tax withheld 0, Received equals Accrued; the tax sits under “Costs” in Reports

The first two columns come from the importer’s column aliases and its Flex mapping, the last from how the ledger books each kind (the code is in the sources). We traced this in the code and did not run it on a real Flex file, so check yours: one payment, both screens.

If your tax came as a separate row and you want it on the dividend, edit the dividend in Transactions, enter the amount in its Tax field (with the currency, if the broker withheld in another), then delete the separate Tax row. Do both, not one: leave the Tax row in place and cash is reduced twice. Deletion has no undo.

See what is still to come

On the Overview dashboard the “Expected dividends” list carries each payment the price source reported over the last year one year forward. It writes nothing and is a forecast, not income. It lists only instruments you hold and whose price source reports dividends; one priced by hand is never in it, which does not mean it pays nothing. The amount is net of the withholding your last received payment of that instrument had, gross when none was ever received. “Announced” means the source already reported the payment, “estimated” means date and amount are carried forward. How it is made covers the special-dividend and suspended-payer rules.

If something goes wrong

Income is empty, or far lower than the broker says. The scope is on a securities account alone. Set it back to “Whole portfolio” or to the cash account the dividends settle on.

Tax withheld reads 0, but the broker withheld. The tax came as its own row (see above). Look under “Costs” in Reports; the tax should be there as a Tax row.

Withholding was taken in a different currency from the dividend. Enter the tax with its own currency in the Tax field. It is converted at the rate of its own currency on the payment date and leaves that currency’s balance, so a EUR dividend of 100.00 with USD 15.00 withheld at 0.90 (a made-up rate) gives 13.50 EUR tax and 86.50 EUR net (the worked case in the tests).

A number differs from the statement by a few cents. Amounts in a currency other than your base currency are converted at the exchange rate for the payment date, from a free source. Compare in the payment’s own currency first (“Accrued in currency”).