PDF import from Trade Republic

Bounzz · May 20, 2024, 6:26pm

Hello,

I try to impot a dividend on trade republic but it’s not recognized.

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.68.4
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
cgWgw mLh bolGSUQ PAGE 1 / 1
42 VRwFhq Bg dYWFU DATE 16/05/2024
66838 ageKj COMPTE-TITRES 8041860503
DIVIDENDE
RÉCAPITULATIF
Dividende à la date du 10/05/2024.
POSITION QUANTITÉ REVENU MONTANT
Apple Inc. 1,92086 titre(s) 0,25 USD 0,48 USD
Registered Shares o.N.
ISIN : US0378331005
TOTAL 0,48 USD
DÉTAIL
POSITION MONTANT
Impôt à la source pour les émetteurs américains -0,07 USD
Sous-total 0,41 USD
Sous-total 1,0802 EUR/USD 0,38 EUR
TOTAL 0,38 EUR
RÉSERVATION
COMPTE-ESPÈCES DATE DE VALEUR MONTANT
DE98502109007017811111 16/05/2024 0,38 EUR
Apple Inc. Registered Shares o.N. en garde collective en Allemagne.
Ce document est généré automatiquement et n'est donc pas signé.
Si aucune taxe sur le chiffre d'affaires n'est indiquée, il s'agit d'un service non sujet à la taxe sur le chiffre d'affaires (conformément à la 
réglementation UStG. § 4 n° 8).
Trade Republic Bank GmbH www.traderepublic.com Siège de la Société: Berlin Directeur Général
Brunnenstraße 19-21 service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10119 Berlin VAT-ID DE307510626 Gernot Mittendorfer
ABRE / 16/05/2024 / 64217923 / d7c6-4ca9

Thanks for your help

Nirus · May 21, 2024, 5:06am

Hello @Bounzz
Qui qui…
If everything is OK, this should be included in the next release.

Regards
Alex

imcvampire · June 30, 2024, 7:22pm

Hi,

I’m trying to import a PDF file which is a cash settle (payment) of an option but, currently, PP can’t understand it.

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.69.0
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
pmUr IGm KthjGC PAGE 1 from 1
iXBOzZXwU 9 DATE 05.07.2023
05722 BcodlSKP SECURITIES ACCOUNT 4337564104
REPAYMENT
OVERVIEW
NO. BOOKING SECURITY AMOUNT
1 Repayment Société Générale Effekten GmbH 500 Pcs.
MiniL O.End CBOE VIX 14,94
DE000SQ728J8
BILLING
NO. POSITION AMOUNT
1 Market value 35.00 EUR
TOTAL 35.00 EUR
BOOKING
CLEARING ACCOUNT VALUE DATE AMOUNT
DE32502109007011423226 06.07.2023 35.00 EUR
Société Générale Effekten GmbH MiniL O.End CBOE VIX 14,94 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 / 06.07.2023 / 46649403 / 6fc7-3f72

Nirus · July 1, 2024, 4:18am

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

Regards
Alex

Nessaiy · July 1, 2024, 11:00am

Do you know when is the next release? Clicking daily on the update button, because i am missing 5 dividends.

Jo92 · July 1, 2024, 11:54am

It depends, whenever @AndreasB finds time to manage it. Normally there is one release each month. But you’ll never know

ProgFriese · July 1, 2024, 1:52pm

You know the possibility to enter dividends manually?

Nessaiy · July 1, 2024, 3:31pm

yes, but some are in dollars with foreign taxes and stuff like that.

segi · July 2, 2024, 7:17am

Last month TR change interest rate in 11.6.2024. Inport inported it as one payment but in the PDF there are two payments.

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.69.0
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
XLvEf QMVFW PAGE 1 from 1
A. eWOPmG 51 DATE 01.07.2024
263 01 TSfIqvXd CASH ACCOUNT 9901707353
TAX ID 7495030331
INTEREST INVOICE
as of 30.06.2024
OVERVIEW
ASSET INCOME TYPE INTEREST RATE DATE TOTAL
Cash Interest 4,00% 01.06.2024 - 11.06.2024 7,10 EUR
Cash Interest 3,75% 12.06.2024 - 30.06.2024 11,56 EUR
BOOKING
IBAN BOOKING DATE TOTAL
DE27564972157013461572 01.07.2024 18,66 EUR
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin Directors
Brunnenstraße 19-21 service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10119 Berlin VAT-ID DE307510626 Gernot Mittendorfer

Nirus · July 2, 2024, 7:43am

Hello @segi
this problem is solves in the next release

Regards
Alex

notallowed · July 15, 2024, 12:05pm

Hi guys,

I still have problem with dividend import after latest (0.69.1) update. The debug info from Portfolio performance:

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.69.1
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
My address 1 DATE 12.07.2024
9999 City SECURITIES ACCOUNT 1234567890
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 28.06.2024.
POSITION QUANTITY YIELD AMOUNT
Mondelez
US6092071058 2.000000 Pcs. 0.425 USD
0.85 USD
TOTAL 0.85 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -0.13 USD
Sub Total 0.72 USD
Sub Total 1.0855 USD/EUR 0.66 EUR
TOTAL 0.66 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE12345678901234567890 12.07.2024 0.66 EUR
US6092071058 in giro collection storage in Germany
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21
10119 Berlin service@traderepublic.com
AG Charlottenburg HRB 244347 B Andreas Torner
VAT-ID DE307510626 Gernot Mittendorfer

notallowed · July 19, 2024, 10:03am

@Nirus I’ve seen you’ve been updating TR importer for Spanish and Germany lately, may I kindly ask to look into the case above? Thank you.

Nirus · July 19, 2024, 7:14pm

Hello @notallowed
… done.

Regards
Alex

DrLous · July 21, 2024, 9:46am

Hello, I have trouble with distribution with TR in French.

Thank you

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.69.1
-----------------------------------------
TRADE REPUBLIC BANK GMBH  KÖPENICKER STRASSE 40C  10179 BERLIN
ckxR oYSL PigNfj qHftDB PAGE 1 / 1
758 Rue Lasson DATE 55/77/8891
82422 LMqDqVqg COMPTE-TITRES 8068554482
DISTRIBUTION
RÉCAPITULATIF
Distribution à la date du 42/36/5054.
POSITION QUANTITÉ REVENU MONTANT
Xtrackers Nikkei 225 1,580925 titre(s) 0,324 EUR 0,51 EUR
Inhaber-Ant. 2D EURH o.N.
ISIN : LU1875395870
TOTAL 0,51 EUR
RÉSERVATION
COMPTE-ESPÈCES DATE DE VALEUR MONTANT
DE13502109007011547146 51/82/3421 0,51 EUR
Xtrackers Nikkei 225 Inhaber-Ant. 2D EURH o.N. en relevé de transaction en Allemagne.
Pays d'enregistrement: Irlande
Ce document est généré automatiquement et n'est donc pas signé.
Si aucune taxe sur le chiffre d'affaires n'est indiquée, il s'agit d'un service non sujet à la taxe sur le chiffre d'affaires (conformément à la 
réglementation UStG. § 4 n° 8).
Trade Republic Bank GmbH www.traderepublic.com Siège de la Société: Berlin Directeur Général
Köpenicker Straße 40c service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner
10179 Berlin VAT-ID DE307510626 Gernot Mittendorfer
ABRE / 07/09/2023 / 61162068 / 24c4-87ff

Nirus · July 21, 2024, 12:55pm

Hello @DrLous
If everything is OK, this should be included in the next release. Please be careful what you anonymize. You have inadvertently changed the date.

Regards
Alex

notallowed · August 5, 2024, 7:45am

Darn. I thought I provided enough examples for the English version of TR dividends, however I did not, so there are still multiple versions of divi PDFs that can not be imported in 0.70 version. Looks like they have several variants with different footer notes. So hopefully @Nirus can look in the cases below and support them too:
#1

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.2
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
Address 1 DATE 17.06.2024
1234 PostName SECURITIES ACCOUNT 1234567890
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 03.06.2024.
POSITION QUANTITY YIELD AMOUNT
Realty Income
US7561091049 15 Pcs. 0.26 USD
3.94 USD
TOTAL 3.94 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -0.59 USD
Sub Total 3.35 USD
Sub Total 1.0759 EUR/USD 3.11 EUR
TOTAL 3.11 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE12345678901234567890 14.06.2024 3.11 EUR
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21 service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner10119 Berlin VAT-ID DE307510626 Gernot Mittendorfer

#2

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.2
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
Address 99 DATE 04.07.2024
1234 PostName SECURITIES ACCOUNT 1234567890
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 18.06.2024.
POSITION QUANTITY YIELD AMOUNT
Vici Properties 30.000000 Pcs. 0.415 USD 12.45 USDUS9256521090
TOTAL 12.45 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -1.87 USD
Sub Total 10.58 USD
Sub Total 1.0729 USD/EUR 9.86 EUR
TOTAL 9.86 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE12345678901234567890 03.07.2024 9.86 EUR
US9256521090 in securities invoice
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21
10119 Berlin service@traderepublic.com
AG Charlottenburg HRB 244347 B Andreas Torner
VAT-ID DE307510626 Gernot Mittendorfer

Regards,
notallowed

Nirus · August 5, 2024, 8:40am

Hallo @notallowed
If everything is OK, this should be included in the next release,

Regards
Alex

notallowed · August 7, 2024, 8:38am

Hi @Nirus, I just updated to 0.70.3, however I still can not import the PDFs that I generated last reports from. Can you please check again?

Nirus · August 7, 2024, 3:18pm

Hello @notallowed
I don’t see any problems… all tests are successful without errors.

Please create a PDF debug with the error and a screenshot.
Please check version of PP… v.0.70.3

Best regards
Alex

notallowed · August 7, 2024, 3:52pm

Hi, PDF debugs are the same as I reported in this post (PDF import from Trade Republic - #57 by notallowed) and yes I did try on v0.70.3. But nevertheless I will supply screenshot of the error and PDF debugs below.

Screenshot:

PDF Debugs:
#1

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
My Address 99 DATE 15.07.2024
9999 City Name SECURITIES ACCOUNT 9999999999
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 01.07.2024.
POSITION QUANTITY YIELD AMOUNT
Realty Income 15.000000 Pcs. 0.263 USD 3.95 USDUS7561091049
TOTAL 3.95 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -0.59 USD
Sub Total 3.36 USD
Sub Total 1.089 USD/EUR 3.09 EUR
TOTAL 3.09 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE99999999999999999999 15.07.2024 3.09 EUR
US7561091049 in giro collection storage in Germany
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21
10119 Berlin service@traderepublic.com
AG Charlottenburg HRB 244347 B Andreas Torner
VAT-ID DE307510626 Gernot Mittendorfer

#2

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
My Address 99 DATE 04.07.2024
9999 City Name SECURITIES ACCOUNT 9999999999
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 18.06.2024.
POSITION QUANTITY YIELD AMOUNT
Vici Properties 30.000000 Pcs. 0.415 USD 12.45 USDUS9256521090
TOTAL 12.45 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -1.87 USD
Sub Total 10.58 USD
Sub Total 1.0729 USD/EUR 9.86 EUR
TOTAL 9.86 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE99999999999999999999 03.07.2024 9.86 EUR
US9256521090 in securities invoice
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21
10119 Berlin service@traderepublic.com
AG Charlottenburg HRB 244347 B Andreas Torner
VAT-ID DE307510626 Gernot Mittendorfer

#3

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
My Address 99 DATE 19.06.2024
9999 City Name SECURITIES ACCOUNT 9999999999
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 08.06.2024.
POSITION QUANTITY YIELD AMOUNT
Alphabet (A)
US02079K3059 2 Pcs. 0.2 USD
0.40 USD
TOTAL 0.40 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -0.06 USD
Sub Total 0.34 USD
Sub Total 1.0821 EUR/USD 0.31 EUR
TOTAL 0.31 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE99999999999999999999 17.06.2024 0.31 EUR
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21 service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner10119 Berlin VAT-ID DE307510626 Gernot Mittendorfer

#4

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.70.3
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
Name Surname PAGE 1 from 1
My Address 99 DATE 17.06.2024
9999 City Name SECURITIES ACCOUNT 9999999999
CASH DIVIDEND
OVERVIEW
Cash Dividend with Ex-Date 03.06.2024.
POSITION QUANTITY YIELD AMOUNT
Realty Income
US7561091049 15 Pcs. 0.26 USD
3.94 USD
TOTAL 3.94 USD
INVOICE
POSITION AMOUNT
Withholding Tax for US issuer -0.59 USD
Sub Total 3.35 USD
Sub Total 1.0759 EUR/USD 3.11 EUR
TOTAL 3.11 EUR
BOOKING
SETTLEMENT ACCOUNT PAYMENT DATE AMOUNT
DE99999999999999999999 14.06.2024 3.11 EUR
This statement is generated automatically and therefore not signed.
If no sales tax is shown, this is a sales tax-free service in accordance with Section § 4 Nr. 8 UStG
Trade Republic Bank GmbH www.traderepublic.com Headquarters: Berlin DirectorsBrunnenstraße 19-21 service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner10119 Berlin VAT-ID DE307510626 Gernot Mittendorfer

Best regards,
notallowed