EXANTE
PIT-38 from EXANTE: two files and a sign instead of a buy/sell column
EXANTE splits trades and cash flows into two reports, and the direction of a trade is carried by the sign of the amount. Below is exactly what our engine reads.
Where to get the files
- In the client area download the Trades report for the tax year.
- Separately download the Financial operations report for the same year.
- Send both — dividends, interest and withholding live only in the second.
What is inside
- Two reports for one account
- Trades holds buys and sells. Financial holds dividends, interest, withholding tax and fees. A return needs both.
- Direction encoded in the sign
- There is no Buy/Sell column. A negative amount is a purchase, a positive one a sale — money leaving or arriving.
- Settlement date in its own column
- Value date, usually two business days after the trade.
- Timestamps down to milliseconds
- ISO 8601 with a fractional second, in the broker’s time zone.
Where it goes wrong
- A purchase taken for a sale
- With no direction column everything hangs on the sign. Ignore the minus and a cost becomes proceeds, doubling what section C/D reports.
- Filing from trades alone
- The Trades report carries no dividends and no withholding. Section G comes out empty and the tax withheld abroad is forfeited.
- Trade date used instead of value date
- The NBP rate comes from the day before income is realised. Swapping the columns shifts the rate by two business days, and around New Year it throws a trade into the wrong tax year.
What we compute from it
- Shares and ETFs — section C/D
- FIFO per account, art. 30b ust. 7.
- Dividends and interest — section G
- With withholding credited, art. 30a ust. 9.
- Rate from the settlement day
- Since the broker gives the value date, we take the NBP rate from the day before it — art. 11a ust. 1.
Run this once
claude mcp add --transport http taxroam https://taxroam.com/mcp --header "Authorization: Bearer $TAXROAM_KEY"Where this export usually goes wrong
- US dividends
- No W-8BEN, so 30 percent instead of 15
- The NBP rate
- The trade-date rate
Questions about EXANTE
I only have the trades report. Is that enough?
For gains on disposal, yes. Dividends, interest and foreign withholding exist only in the financial report — without it the return has a gap you cannot see.
How do I tell whether a row is a purchase?
By the amount: negative means cash out, hence a buy. Positive means cash in, hence a sell.