PDF import from Trade Republic

Hi,

I try to import a Market-Order order but PP said that it can’t detect transaction type.

Hi,

please share a PDF extract, like shown in the video here:

Be careful, UI changed a little bit. But it’s easier now.

Hi,
I can also share my extract for Trade Republic

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.64.1
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
JWyNX aNnmV PAGE 1 from 1
A. AEAaLy 18 DATE 02.06.2023
131 56 rwMMPGwX EXECUTION d008-0f58
SAVINGS PLAN dbc9-ad4d
SECURITIES ACCOUNT 0781322201
SECURITIES SETTLEMENT SAVINGS PLAN
OVERVIEW
Savings plan execution on 02.06.2023 on the Lang & Schwarz Exchange.
The counterparty to the transaction is Lang & Schwarz TradeCenter AG & Co. KG.
POSITION QUANTITY AVERAGE RATE AMOUNT
Berkshire Hathaway Inc. 0.081967 Pcs. 305.00 EUR 25.00 EUR
Reg.Shares B New DL -,00333
ISIN: US0846707026
TOTAL 25.00 EUR
BOOKING
CLEARING ACCOUNT VALUE DATE AMOUNT
DE27502109007011534672 06.06.2023 -25.00 EUR
Berkshire Hathaway Inc. Reg.Shares B New DL -,00333 in giro collection storage in Germany.
This statement is generated automatically and therefore not signed.
If no VAT is shown, it is according to § 4 No. 8 UStG for a sales tax-free service.
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin Directors
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin VAT-ID DE307510626 Gernot Mittendorfer
ABRE / 02.06.2023 / 65418192 / 1e89-a75f

One more

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.64.1
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
Sntks lxdmR PAGE 1 from 1
A. GgNQLO 35 DATE 02.06.2023
228 67 HstTMCbM EXECUTION 8c26-15e1
SAVINGS PLAN 6af7-5be3
SECURITIES ACCOUNT 2099779584
SECURITIES SETTLEMENT SAVINGS PLAN
OVERVIEW
Savings plan execution on 02.06.2023 on the Lang & Schwarz Exchange.
The counterparty to the transaction is Lang & Schwarz TradeCenter AG & Co. KG.
POSITION QUANTITY AVERAGE RATE AMOUNT
Vanguard S&P 500 UCITS ETF 0.336491 Pcs. 74.296 EUR 25.00 EUR
Reg. Shs USD Acc. oN
ISIN: IE00BFMXXD54
TOTAL 25.00 EUR
BOOKING
CLEARING ACCOUNT VALUE DATE AMOUNT
DE27502109007011534672 06.06.2023 -25.00 EUR
Vanguard S&P 500 UCITS ETF Reg. Shs USD Acc. oN in securities invoice in Germany.
Custody Location: United Kingdom
This statement is generated automatically and therefore not signed.
If no VAT is shown, it is according to § 4 No. 8 UStG for a sales tax-free service.
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin Directors
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin VAT-ID DE307510626 Gernot Mittendorfer
ABRE / 02.06.2023 / 90962085 / 6e6b-65c6

Hello @segi
I have tested both PDF debug and could not find any error… Please check if you have chosen the right PDF debug.

Greetings
Alex

Sorry, yes it works. I tried it a few weeks ago and it didn’t work and now I haven’t tried it again.

Hi @Nirus ,
I have two stocks with the same ISIN but in different currencies. One in USD and once in EUR. When I use PDF import it crashes with error that ISIN is twice in list of stocks. Is it not possible to pair by ISIN and currency in the import?

Hi,

Sorry for very late response but you can check my output here

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.65.1
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
cbtC xAi kIvJgh PAGE 1 from 1
ujINzumUs 2 DATE 28.04.2023
42766 wtbOoUAY ORDER 10VG-16T0
EXECUTION 4A66-g597
SECURITIES ACCOUNT 5700950391
SECURITIES SETTLEMENT
OVERVIEW
Limit-Order Buy on 28.04.2023 at 11:13 (Europe/Berlin).
The counterparty to the transaction is Société Générale S.A.
POSITION QUANTITY PRICE AMOUNT
Société Générale Effekten GmbH 100 Pcs. 0.864 EUR 86.40 EUR
MiniL O.End CBOE VIX 11,49
ISIN: DE000SQ6QKU9
TOTAL 86.40 EUR
BILLING
POSITION AMOUNT
External cost surcharge -1.00 EUR
TOTAL -87.40 EUR
BOOKING
CLEARING ACCOUNT VALUE DATE AMOUNT
DE32502109007011423226 03.05.2023 -87.40 EUR
Société Générale Effekten GmbH MiniL O.End CBOE VIX 11,49 in giro collection storage in Germany.
This statement is generated automatically and therefore not signed.
If no VAT is shown, it is according to § 4 No. 8 UStG for a sales tax-free service.
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin Directors
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin VAT-ID DE307510626 Gernot Mittendorfer
ABRE / 28.04.2023 / 25358381 / 5d00-ea78

Hello @imcvampire
If everything is ok, this should be included in the next release.

Regards
Alex

1 Like

Hello,
would you please add support for Dividend in Italian, thanks:

```
PDFBox Version: 1.8.17
Portfolio Performance Version: 0.65.2
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
ObYkIGLA pNFXCP LTViL SSJjRhj PAGINA 1 dal 1
nTr lUHU nrgaLGt 127 DATA 01.06.2023
73580 wGrIRVNYS CONTO TITOLI 5087647531
DIVIDENDO
PANORAMICA
Dividendo con l'ex-tag 12.05.2023.
POSIZIONE QUANTITÀ Reddito IMPORTO
Enbridge Inc. 20,971565 Pz. 0,8875 CAD 18,61 CAD
Registered Shares o.N.
ISIN: CA29250N1050
TOTALE 18,61 CAD
FATTURAZIONE
POSIZIONE IMPORTO
Ritenuta alla fonte -4,65 CAD
Subtotale 13,96 CAD
Subtotale 1,46055 EUR/CAD 9,56 EUR
TOTALE 9,56 EUR
PRENOTAZIONE
CONTO DI TRANSITO DATA VALUTA IMPORTO
DE98XX566XX071XX65XX87 01.06.2023 9,56 EUR
Enbridge Inc. Registered Shares o.N. in conto titoli in Germania.
Luogo di custodia: Canada
Questo regolamento viene creato automaticamente e quindi non è firmato.
Se non viene mostrata l'IVA, si tratta di un servizio esente da imposte sulle vendite in conformità con la 
regolamentazione UStG § 4 n. 8.
Trade Republic Bank GmbH www.traderepublic.com Sede centrale: Berlin Direttore Generale
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin PARTITA IVA DE307510626 Gernot Mittendorfer
ABRE / 01.06.2023 / 93769604 / 2cba-c6b8

```

Hello @goolpone
Yes, this is not a problem.
Can you provide us some more PDF debugs with purchases, sales and dividends?
Please also with fees and/or exchange rates.

Regards
Alex

Hello @goolpone
If everything is ok, this should be included in the next release.

Regards
Alex

1 Like

Sure, not a problem, as soon as I get them for such transaction I will provide them.

Thanks and regards

The following has been a share purchase (BUY):

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.65.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
mRXWPxWr rYTgBw IJLoT soUgLTO PAGINA 1 dal 1
DLF TRUI INYUjUB 515 DATA 01.06.2023
51670 cyuzKxpHr ORDINE cY43-6m6l
ESECUZIONE V711-7789
CONTO TITOLI 5505511218
REGOLAMENTO TITOLI
PANORAMICA
Market-OrderAcquisto il 01.06.2023 alle 10:46 (Europe/Berlin) su Lang & Schwarz Exchange.
La controparte della transazione è Lang & Schwarz TradeCenter AG & Co. KG.
POSIZIONE QUANTITÀ PREZZO IMPORTO
zjBAM Corp. 125 Pz. 29,75 EUR 3.718,75 EUR
Registered Shares DL -,001
ISIN: US3281404601
TOTALE 3.718,75 EUR
FATTURAZIONE
POSIZIONE IMPORTO
Supplemento spese di terzi -1,00 EUR
TOTALE -3.719,75 EUR
PRENOTAZIONE
CONTO DI TRANSITO DATA VALUTA IMPORTO
DE76502107645011478092 05.06.2023 -3.719,75 EUR
zjBAM Corp. Registered Shares DL -,001 in giro collection storage in Germania.
Questo regolamento viene creato automaticamente e quindi non è firmato.
Se non viene mostrata l'IVA, si tratta di un servizio esente da imposte sulle vendite in conformità con la 
regolamentazione UStG § 4 n. 8.
Trade Republic Bank GmbH www.traderepublic.com Sede centrale: Berlin Direttore Generale
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin PARTITA IVA DE307510626 Gernot Mittendorfer
ABRE / 01.06.2023 / 70254581 / 15b2-ec38

The following one is for interest income:

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.65.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
ObPLvFzA YeGWca QEcaE gWDyIOI PAGINA 1 dal 1
djg yOlH KuVOJsM 980 DATA 01.06.2023
07760 yUPLszhsA DISPONIBILITÀ 
LIQUIDE 0785705711
YUhKAd 
FISCALE GPRNSU81M15I836Y
RESOCONTO INTERESSI MATURATI
alla data 31.05.2023
PANORAMICA
CATEGORIA TIPO DI PROVENTO TASSO D'INTERESSE TOTALE
Liquidità Interessi 2,00% 0,12 EUR
PAGAMENTO
IBAN DATA EMISSIONE TOTALE
DE93752109007837402856 01.06.2023 0,12 EUR
Trade Republic Bank GmbH www.traderepublic.com Sede centrale: Berlin Direttore Generale
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin PARTITA IVA DE307510626 Gernot Mittendorfer

Hello @goolpone
if everything is okay… in the next release.

Regards
Alex

1 Like

Thanks.
I confirm it worked, but I forgot to share the template for ETF distribution, which looks different from the previously shared stocks dividend:

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.65.4
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
qbqIykNK XAAxHm TrfTJ PEraGMV PAGINA 1 dal 1
lUW vvIB wxdGLPM 529 DATA 17.07.2023
00009 AlgChRhBR CONTO TITOLI 1810039672
DISTRIBUZIONE
PANORAMICA
Distribuzione con l'ex-tag 17.08.2023.
POSIZIONE QUANTITÀ REDDITO IMPORTO
iSh.ST.Gl.Sel.Div.100 U.ETF DE 23,632607 Pz. 0,704284 EUR 16,64 EUR
Inhaber-Anteile
ISIN: DE001A0F8UH1
TOTALE 16,64 EUR
PRENOTAZIONE
CONTO DI TRANSITO DATA VALUTA IMPORTO
DE09762409007071864502 17.07.2023 16,64 EUR
iSh.ST.Gl.Sel.Div.100 U.ETF DE Inhaber-Anteile in giro collection storage in Germania.
Questo regolamento viene creato automaticamente e quindi non è firmato.
Se non viene mostrata l'IVA, si tratta di un servizio esente da imposte sulle vendite in conformità con la 
regolamentazione UStG § 4 n. 8.
Trade Republic Bank GmbH www.traderepublic.com Sede centrale: Berlin Direttore Generale
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin PARTITA IVA DE307510626 Gernot Mittendorfer
ABRE / 18.07.2023 / 68741871 / d39b-5ebf

Hello @goolpone
sure… if everything is okay… in the next release.

Regards
Alex

Hi @Nirus,
are the interest income implemented in version 0.65.4 (now released) or in some next?
Because I tried to import but with faul.

Hello @segi
as far as I remember I have not received or been implemented any interest PDF debug.
We can only adjust what is available, so create a few PDF debugs where you have problem importing and then we’ll look at that as soon as we have time for this.

Where are the PDF-Debugs?

Greetings
Alex