jamsix / ib-edavki

Skripta, ki prevede XML poročilo trgovalnih poslov v platformi InteractiveBrokers v XML format primeren za uvoz v obrazce Doh-KDVP, D-IFI, Doh-Div in Doh-Obr v eDavkih Finančne uprave.
MIT License
194 stars 60 forks source link

IBKR Stock Yield Enhancement Program gains #7

Closed pronebird closed 3 years ago

pronebird commented 3 years ago

Hey,

Do you report stock yield gains somehow? I am not really sure how to report those. I could probably export XML and see inside if there is some information on that.

Cheers, Andrej

jamsix commented 3 years ago

The script doesn't do that yet. If you can help me out with what exactly this gains fall under (interests?), I'm happy to add it.

pronebird commented 3 years ago

Falls under "Interest Accrued" (positive) to my understanding. I can try exporting XML and see how it looks there. The reports that IBKR generates are fairly verbose so it's difficult to read them.

Looks like something like that:

<InterestAccruals>
<InterestAccrualsCurrency accountId="UXXXXX" acctAlias="" model="" currency="BASE_SUMMARY" fromDate="20200923" toDate="20201231" startingAccrualBalance="0" interestAccrued="1.62" accrualReversal="-0.59" fxTranslation="0" endingAccrualBalance="1.03" />
</InterestAccruals>

Pretty weird that the base currency is specified as BASE_SUMMARY... My base is in USD.

jamsix commented 3 years ago

Alright, do you have any idea how is this reported to FURS? As interests in Doh-Obr?

pronebird commented 3 years ago

@jamsix I am gonna have to read on that. But for now this is just an idea. I think those interest payments have to be reported even if they are so small, although I am thinking to enable stock yield program for my main account and see how much I can squeeze. (Holding some heavily shorted stocks)

ddbk commented 3 years ago

In my understanding they need to be reported to FURS on the DOHKAP 1 form (https://edavki.durs.si/EdavkiPortal/OpenPortal/CommonPages/Opdynp/PageD.aspx?category=odmera_dohodnine_od_drugih_obresti). Not sure about the correct reporting code (šifra) for this type of interests though, so I might need to look a bit more into it.

ddbk commented 3 years ago

I just received written confirmation from FURS that Stock Yield Enhancement Program gains should indeed be reported in DOHKAP-1 or Doh-Obr form (both are essentially the same) and that reporting code ("šifra vrste obresti") is not that important since it doesn't affect taxation. Their advice is to choose the one most most closely resembling this type of interest (their suggestion is code no. 2 -- although in my opinion no. 8 is maybe more appropriate?).

These are all the codes:

Šifra | Naziv
1 | Obresti od posojil
2 | Obresti od dolžniško vrednostnih papirjev, vključno z zamenljivimi dolžniškimi vrednostnimi papirji
3 | Obresti na denarne depozite pri bankah in hranilnicah
4 | Obresti od podobnih finančnih terjatev do dolžnikov
5 | Dohodek iz oddajanja v finančni najem
6 | Dohodek iz življenjskega zavarovanja
7 | Dohodek, dosežen na podlagi delitve prihodkov vzajemnega sklada v obliki obresti
8 | Nadomestila, diskonti, bonusi, premije, ki se obdavčujejo kot obresti
9 | Dohodek iz dodatnega pokojninskega zavarovanja, sklenjenega po pokojninskem načrtu, ki ni vpisan v poseben register, in dohodek iz prostovoljnega zavarovanja
ddbk commented 3 years ago

I prepared a pull request for this feature.

For clarification since there was discussion above about what data to use for generating the report: Taking interest accruals is not the correct way to report this since FURS only cares about the actual payments. Gains are paid by IB once per month (this is report date for tax purposes) and are reported as cash transactions with type Broker Interest Received in flex statement. This is also relevant since we need to report IB affiliate as the Interest payer (and take the correct IB affiliate data, since there were some changes at the end of 2020/beginning of 2021 due to Brexit).