search

portfolio-performance / portfolio

Track and evaluate the performance of your investment portfolio across stocks, cryptocurrencies, and other assets.
http://www.portfolio-performance.info
Eclipse Public License 1.0
2.77k stars 580 forks source link

Trade Republic Importer not working anymore for Dividends #4134

Closed kellerkind87 closed 1 week ago

kellerkind87 commented 1 week ago

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. use the pdf importer with an Trade Republic Dividend Document

Expected behavior Dividend is imported

Screenshots image

Desktop (please complete the following information):

Importer Debug Output

PDFBox Version: 1.8.17
Portfolio Performance Version: 0.69.0
-----------------------------------------
TRADE REPUBLIC BANK GMBH  BRUNNENSTRASSE 19-21  10119 BERLIN
John Doe SEITE 1 von 1
Main Str. 1 DATUM 02.07.2024
99999 City DEPOT 0174238201
WAHLDIVIDENDE
ÜBERSICHT
Wahldividende mit Ex-Datum21.06.2024.
POSITION ANZAHL ERTRAG BETRAG
Main Street Capital
US56035L1044 107.975362 Stücke 0.3 USD
32.39 USD
GESAMT 32.39 USD
ABRECHNUNG
POSITION BETRAG
Quellensteuer für US-Emittenten -4.86 USD
Zwischensumme 27.53 USD
Zwischensumme 1.0689 USD/EUR 25.75 EUR
Kapitalertragssteuer 1.0689 USD/EUR -2.97 EUR
Kirchensteuer 1.0689 USD/EUR -0.23 EUR
Solidaritätszuschlag 1.0689 USD/EUR -0.16 EUR
GESAMT 22.39 EUR
BUCHUNG
VERRECHNUNGSKONTO DATUM DER ZAHLUNG BETRAG
DE99999999999999999999 27.06.2024 22.39 EUR
US56035L1044 in Wertpapierrechnung
Diese Abrechnung wird maschinell erstellt und daher nicht unterschrieben.
Wird keine Umsatzsteuer ausgewiesen, handelt es sich um eine umsatzsteuerfreie Leistung gemäß § 4 Nr. 8 UStG
Trade Republic Bank GmbH
Brunnenstraße 19-21 www.traderepublic.com
Sitz der Gesellschaft: Berlin Direktoren
service@traderepublic.com AG Charlottenburg HRB 244347 B Andreas Torner10119 Berlin Umsatzsteuer-ID DE307510626 Gernot Mittendorfer
Sn1kk3r5 commented 1 week ago

Fix will available with the new version:

https://github.com/portfolio-performance/portfolio/pull/4123

kellerkind87 commented 1 week ago

You are doing a good job here! Thank you ❤️

kellerkind87 commented 1 week ago

it works again. Thank you. I'll close this here

notallowed123 commented 2 days ago

There is still a problem with dividend import on 0.69.1. At least for the English version of the document:

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
Sn1kk3r5 commented 2 days ago

Easiest is a post including your debug right here: https://forum.portfolio-performance.info/t/pdf-import-von-trade-republic/5107/588