PDF import from DeGiro

English Import/export
36

Hello @salamartur,
I have looked at your PDF debug and found maybe the error.
I would like to fix this but I can’t do anything with these postings.

What is

23-03-2021 08:17 22-03-2021 FX Debit EUR 9.12 EUR -2,681.14
23-03-2021 08:17 22-03-2021 FX Debit 1.4958 CAD -13.65 CAD 0.00

Are these deposits / withdrawals? And what is posted here?
And what are these amounts?

1st:
9.12 -->?
-2,681.14 → ??

2nd:
1.4958 → Maybe ExchangeRate?
-13.65 → ?
0.00 → ?

And what ist your BaseCurrency?

The other thing is that there are three currencies in the PDF debug. When you create a settlement account, you set one currency, which is the base currency.
In the PDF debug of yours, you have three base currencies in it.
Once CAD, EUR and USD. Of course, these cannot all be imported on the same clearing account, because they differ from the defined base currency.

Please try to add one clearing account per basic currency. Once in USD, CAD and once EUR.
I think this should work if you import the PDF’s per clearing account.

37

Hi Guys,

(as a dutchman I can read german, but writing certainly isn’t a quality of mine)

My PP version:

PP (Version: 0.54.3 (Aug 2021)
Platform: linux, x86_64
Java: 15.0.3+3-Ubuntu-1, Private Build

I just imported a PDF from my dutch “DeGiro” account by going to my overview → transactions → export as PDF. This works fine but that PDF does not mention any dividends.

When I go to the “Rekeningoverzicht” (I guess account overview is a correct translation) tab and export it , PP says it can’t import the document:

Unkown or unsupported transaction type in <bla.pdf> .

This is logical sinds these aren’t transactions. But this way I still miss quite some stuff:

  • Dividends/taxes on these
  • Deposits on my deposit account (since no deposits are imported, it currently is a negative amount)
  • Also PP won’t draw a holding chart because there’s a negative amount in my holding : "The holdings chart is not correct because there are positions that have a negative valuation " . I think this is related to point 2 .

How should I fix this, or am I doing something wrong? I would be great to also have my dividends and deposits in PP too (on a different computer I maintained this for a while, but PDF import is much much much more convenient).

Thanks guys!

38

Hallo @hansdevries

Video tutorial:
Extract PDF documents for debugging

39

Hi,
I believe your are talking about the account.pdf. In the German Forum there has been a lot of discussion about that one aswell.
The main solution is always to give the extract, as Nirus mentioned, however believe the problem is like this:

  • The issue are here mainly the dividends. And that is rather simple, because when you look at the pdf yourself, you cannot identify which tax deduction belongs to which line, as it does not connect logically with the stock. You can guess and analyse with the amount deducted, but that is not enough for this importer. Especially because Degiro does not have to have a consistent logic. Sometimes the taxes are deducted before the purchase of a stock (at least on the statement). I heard that you can export there nowadays also dividend statements, maybe that solution helps.
  • well here you have to give some deposits then. Howelse did money get into your account?
40

I understand the issue is how to get dividends into PP.

I use PP for share performance and a cashbook to help with my tax return. My dividends go into a bank account which I export and import into a cashbook. My broker account in PP is exported, reformatted, and imported into a cashbook.

  1. Import bank transactions into cashbook then export a file from the cashbook and load it into PP as demonstrated by Get Dividend CSV File.
  2. PP Export CSV, Security Account then reformat transactions and import into the cashbook.
1 Like
41

Okay I’ll post the debug log. Problem is that there’s quite a lot of sensitive information in there… which I need to purge from the log.

The account.pdf file contains 15 pages and I’ve posted a debug log of just the first page. Please note that I’ve redacted my personal info, and changed all financial amounts to ‘123’

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
Dhr. <My first names>
<My last name>
<My address 1>
<My address 2>
Gebruikersnaam: *******<username>
(<account nr>)
Rekeningoverzicht van 01-01-2010 t/m 25-08-2021
Datum Tijd Valutadatum Product ISIN Omschrijving FX Mutatie Saldo
25-08-2021 09:55 25-08-2021 Reservation iDEAL / Sofort Deposit EUR 123,00 EUR 123,29
25-08-2021 08:42 24-08-2021 iDEAL Deposit EUR 123,00 EUR 123,29
25-08-2021 08:42 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -123,00 EUR 123,29
25-08-2021 08:41 24-08-2021 iDEAL Deposit EUR 1.123,00 EUR 123,29
25-08-2021 08:41 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -1.123,00 EUR -123,71
24-08-2021 13:43 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 123,00 EUR 123,29
24-08-2021 09:57 24-08-2021 VANGUARD FTSE AW IE00B3RBWM25 Koop 123 @ 123,96 EUR EUR -123,76 EUR 123,29
24-08-2021 01:26 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 123,00 EUR 123,05
28-07-2021 11:16 27-07-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 123,05
123,08 EUR
28-07-2021 11:16 27-07-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 123,08 EUR 123,13
27-07-2021 12:46 26-07-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 123,05
98,87 EUR
27-07-2021 12:46 26-07-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 123,87 EUR 123,92
27-07-2021 09:29 27-07-2021 VANGUARD FTSE AW IE00B3RBWM25 Koop 123 @ 123,52 EUR EUR -123,08 EUR 123,05
27-07-2021 08:43 26-07-2021 iDEAL Deposit EUR 123,00 EUR 123,13
27-07-2021 08:43 26-07-2021 Reservation iDEAL / Sofort Deposit EUR -123,00 EUR 123,13
26-07-2021 12:41 26-07-2021 Reservation iDEAL / Sofort Deposit EUR 123,00 EUR 123,13
26-07-2021 12:16 23-07-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 123,13
123,23 EUR
flatex DEGIRO Bank flatex DEGIRO Bank Dutch Branch,
Dutch Branch E klanten@degiro.nl handelend onder de naam DEGIRO, is
Amstelplein 1 I www.degiro.nl de Nederlandse vestiging van Pagina 1 / 15
1096 HA Amsterdam flatexDEGIRO Bank AG. flatexDEGIRO Rekeningoverzicht 2021-08-25
Bank AG staat primair

If I need to provide more information regarding this matter, please let me know!

42

Yes, that’s correct. I’m talking about the account.pdf.

The incoming dividends are indeed mentioned in there, like this:

01-07-2021 12:23 30-06-2021 VANGUARD FTSE AW IE00B3RBWM25 Dividend USD 123,97 USD 456,37

The taxes on dividends aren’t included in it… but that’s okay. In DeGiro’s yearly overview, there’s indeed a statement about that. The yearly overview is being published once a year of course.

Regarding the deposits: if the account.pdf can be parsed properly the deposits should be processed too. Thank you for the information!

43

That’s a good way to the dividend calculation, but DeGiro already publishes a yearly overview.
More important is the rest of the information in account.pdf, ie. deposits.

I hope the developers can fix the parser :).

44

Hallo @hansdevries
I need some help from you please.
Firstly, for checking the correct amounts, please do not change them. By anonymizing your personal data, I think enough privacy is guaranteed. Please rework your post above and also post the whole PDF debug, because there could still be hidden postings which the importer could detect.

Secondly, I do not speak Dutch and need the following translations or the booking types:
(delivery inbound, delivery outbound, dividends, deposit, removal, interest, interest charge, tax, tax refund, fee and fee refund).

Reservation iDEAL / Immediate Deposit → is?
iDEAL Deposit → is?
Overboeking van uw geldrekening bij → is?
FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer → is?
and other unknown bookings…

greetings
Alex

45

Sure, glad to be able to help.

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
Dhr. <firstname1 firstname2>
<firstname3 secondname>
<address >
<zipcode, City >
Gebruikersnaam: *******xxx
(1172470)
Rekeningoverzicht van 03-08-2021 t/m 02-09-2021
Datum Tijd Valutadatum Product ISIN Omschrijving FX Mutatie Saldo
02-09-2021 21:29 31-08-2021 DEGIRO Aansluitingskosten 2021 (Borsa Italiana S.p.A. - EUR -2,50 EUR 12,91
MIL)
27-08-2021 10:16 26-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
4,59 EUR
27-08-2021 10:16 26-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 4,59 EUR 20,00
26-08-2021 12:16 25-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
1.210 EUR
26-08-2021 12:16 25-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 1.210,00 EUR 1.225,41
26-08-2021 08:41 25-08-2021 iDEAL Deposit EUR 20,00 EUR 15,41
26-08-2021 08:41 25-08-2021 Reservation iDEAL / Sofort Deposit EUR -20,00 EUR -4,59
25-08-2021 12:03 24-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
4,05 EUR
25-08-2021 12:03 24-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 4,05 EUR 19,46
25-08-2021 11:55 25-08-2021 RIZE CYBERSECUR AND DA IE00BJXRZJ40 Koop 95 @ 6,325 EUR EUR -600,88 EUR 15,41
25-08-2021 09:55 25-08-2021 Reservation iDEAL / Sofort Deposit EUR 20,00 EUR 616,29
25-08-2021 08:42 24-08-2021 iDEAL Deposit EUR 10,00 EUR 596,29
25-08-2021 08:42 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -10,00 EUR 586,29
25-08-2021 08:41 24-08-2021 iDEAL Deposit EUR 1.200,00 EUR 596,29
25-08-2021 08:41 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -1.200,00 EUR -603,71
24-08-2021 13:43 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 10,00 EUR 596,29
24-08-2021 09:57 24-08-2021 VANGUARD FTSE AW IE00B3RBWM25 Koop 6 @ 102,96 EUR EUR -617,76 EUR 586,29
flatex DEGIRO Bank flatex DEGIRO Bank Dutch Branch,
Dutch Branch E klanten@degiro.nl handelend onder de naam DEGIRO, is
Amstelplein 1 I www.degiro.nl de Nederlandse vestiging van Pagina 1 / 2
1096 HA Amsterdam flatexDEGIRO Bank AG. flatexDEGIRO Rekeningoverzicht 2021-09-02
Bank AG staat primair
Dhr. <firstname1 firstname2>
<firstname3 secondname>
<address >
<zipcode, City >
Gebruikersnaam: *******xxx
(1172470)
Datum Tijd Valutadatum Product ISIN Omschrijving FX Mutatie Saldo
24-08-2021 01:26 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 1.200,00 EUR 1.204,05
flatex DEGIRO Bank flatex DEGIRO Bank Dutch Branch,
Dutch Branch E klanten@degiro.nl handelend onder de naam DEGIRO, is
Amstelplein 1 I www.degiro.nl de Nederlandse vestiging van Pagina 2 / 2
1096 HA Amsterdam flatexDEGIRO Bank AG. flatexDEGIRO Rekeningoverzicht 2021-09-02
Bank AG staat primair

iDEAL is a dutch payment method (actually by far the largest method in .nl: iDEAL - Wikipedia) . By using iDEAL my money is being sent from my regular bank to deGiro, and usually it’s being processed in about 15 minutes. Free of charge for customers, and you always have to authenticate at your own bank (instead of a webshop for instance).Really good system.

So yes I do my deposits using iDEAL. Let’s have a look at the above log:

02-09-2021 21:29 31-08-2021 DEGIRO Aansluitingskosten 2021 (Borsa Italiana S.p.A. - EUR -2,50 EUR 12,91 MIL)
Connection costs for milanese stock market.

deGiro actually creates quite some lines for a ‘simple’ 1200 euro deposit:

john@john-desktop:~/Desktop$ grep "1\.200" Account\(2\).pdf.txt 
25-08-2021 08:41 24-08-2021 iDEAL Deposit EUR 1.200,00 EUR 596,29
25-08-2021 08:41 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -1.200,00 EUR -603,71
24-08-2021 01:26 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 1.200,00 EUR 1.204,05

(it really is just a single deposit…) So the ‘deposit’ and ‘reservation’ come together I guess…
(i made a 10 euro, and a 20 euro deposit too)

Regarding the cash sweep transfers: I just looked it up. I’m a tech-person, not a finance-person so please correct me if I’m wrong. Cash sweeps are deGiro using my ‘unused’/superfluous money in my account for their investments.Every month they reimburse the money (or even earlier in case of running low on money) including some of the profits they made by investing it.

if you need more help having certain lines translated, please tell me :slight_smile:

46

@Nirus have you been able to have a look at this? It would be marvelous to be able to track my investmens automatically using PP.

47

Hallo @hansdevries,
The PDF importer reads in line by line. So I need the info from you which lines are deposit and removals, fees and taxes.

Alex

48

Okay I’ll try to explain how I think the log is working.
I did 3 deposits in august, 1200E and 10E both on the 24th and 20E on the 25th.

In the log:

25-08-2021 08:41 24-08-2021 iDEAL Deposit EUR 1.200,00 EUR 596,29
25-08-2021 08:42 24-08-2021 iDEAL Deposit EUR 10,00 EUR 596,29
26-08-2021 08:41 25-08-2021 iDEAL Deposit EUR 20,00 EUR 15,41

I do not understand how the reservation works actually. It happens when you transfer money… I do get that part. Interesting: the money is ‘instantaneously’ on the account which is normal for iDEAL ,but the deposit seems to happen the 25th. Maybe that’s the reason for the reservations?
I’d love to be helping on this but I don’t understand it either. These are the lines

john@john-desktop:~$ grep Reservation degiro

26-08-2021 08:41 25-08-2021 Reservation iDEAL / Sofort Deposit EUR -20,00 EUR -4,59
25-08-2021 09:55 25-08-2021 Reservation iDEAL / Sofort Deposit EUR 20,00 EUR 616,29
25-08-2021 08:42 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -10,00 EUR 586,29
25-08-2021 08:41 24-08-2021 Reservation iDEAL / Sofort Deposit EUR -1.200,00 EUR -603,71
24-08-2021 13:43 24-08-2021 Reservation iDEAL / Sofort Deposit EUR 10,00 EUR 596,29

john@john-desktop:~$

Also happening: I have some italian stocks, for which I have to pay a yearly connection fee (milanese stock exchange):

Connection costs for “Borsa Italiana”

02-09-2021 21:29 31-08-2021 DEGIRO Aansluitingskosten 2021 (Borsa Italiana S.p.A. - EUR -2,50 EUR 12,91 MIL)
Aansluitingskosten == Connection costs


25-08-2021 11:55 25-08-2021 RIZE CYBERSECUR AND DA IE00BJXRZJ40 Koop 95 @ 6,325 EUR EUR -600,88 EUR 15,41
24-08-2021 09:57 24-08-2021 VANGUARD FTSE AW IE00B3RBWM25 Koop 6 @ 102,96 EUR EUR -617,76 EUR 586,29

Well I bought some stock. “Koop” means buy. “Verkoop” means “sell”

Remaining stuff:


27-08-2021 10:16 26-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
4,59 EUR
27-08-2021 10:16 26-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 4,59 EUR 20,00
26-08-2021 12:16 25-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
1.210 EUR
26-08-2021 12:16 25-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 1.210,00 EUR 1.225,41
25-08-2021 12:03 24-08-2021 Overboeking van uw geldrekening bij flatexDEGIRO Bank EUR 15,41
4,05 EUR
25-08-2021 12:03 24-08-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 4,05 EUR 19,46

These all have to do with “Cash sweep transfers”, meaning degiro investing the “unused” money on my account. When not using the money deGiro automatically transfers it to another account, and when you do need it they transfer it back…

“Overboeking van uw geldrekening bij flatexDEGIRO”
means “transfer from your money account at flatexDEGIRO” (i know money account is really bad english).

Is this of any help?

1 Like
49

In the hopes that it would be any help to you, i want to provide you with my transaction file as well. It never worked with pp import for now. Its more or less a gambling account and has many different kinds of trades.

Would be awesome to import that into pp.

greetings
Transactions (26)_anonym.pdf.txt (69,6 KB)

1 Like
50

I don’t understand your concern about the deposit but I’d like to understand it if there is a better way of doing it. What deposits are in the bank account other than dividends? Do you mean buy/sell transactions?

The first example bank statement download linked clearly shows 23/03/2021 [dividend] deposit of $37.76 from REA into bank account. The Franking [tax credit] is not actually paid so doesn’t appear in the bank statement but it is reported in the dividend statement (and given in the tax return). I enter the Franking credit manually from the dividend statement. An automated process would be nice but almost every security uses a unique report format and I don’t think there are enough @Nirus to code every format.

Maybe the system is totally different in other countries and the bank operates as a broker and reports dividends? On my bank statement a dividend it is no different to salary or any other payment, apart from the description of the transaction, and my broker doesn’t report (or know) distributions.

I don’t think it is worth automating Franking credit capture for me because I need to manually review transactions in my cashbook anyway. I would be interested in a cashbook macro to automate running the PP csv import process.

1 Like
51

Hallo @hansdevries
I am currently editing your PDF-Debug. Unfortunately, you have posted only a part Pagina 1 / 15 here. Could you please post the rest of the pages here?

Greetings
Alex

52

Hallo @mmeen
Thanks for the PDF-Debug.
Can you find me an example from this where the import does not work correctly? That would help me a lot. If necessary also a minimal example as PDF-Debug.

Greetings
Alex

53

Hallo @mmeen @hansdevries @salamartur
Wenn alles i.O. ist und Andreas auch das Okay gibt, dann sollte diverse Änderungen ab dem nächsten Release mit dabei sein.
If everything is ok and Andreas gives the okay, then various changes should be included in the next release.

Alex

54

Thank you very much. I was waiting for either a new version or some spare time to install Eclipse and Maven etc to build from git.

I’ll have a look into the results later tonight or maybe tomorrow. Thank you!

2 Likes
55 
PDFBox Version: 1.8.16
-----------------------------------------
Signor 
Via 
XXXXXXXX
Italy
Nome Utente: *********rri
(XXXXXXXXX)
Estratto conto da 01-01-2021 a 29-11-2021
Data Ora Data Valore Prodotto ISIN Descrizione Borsa Variazioni Saldo
02-11-2021 12:34 01-11-2021 Trasferisci dal tuo conto deposito presso flatexDEGIRO EUR 215,21
Bank: 0,56 EUR
02-11-2021 12:34 01-11-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 0,56 EUR 215,77
01-11-2021 14:26 31-10-2021 DEGIRO Costi di connessione 2021 (Xetra - XET) EUR -0,56 EUR 215,21
28-10-2021 08:50 28-10-2021 Deposito flatex EUR 200,00 EUR 215,77
06-10-2021 11:47 05-10-2021 Trasferisci dal tuo conto deposito presso flatexDEGIRO EUR 15,77
Bank: 192,46 EUR
06-10-2021 11:47 05-10-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 192,46 EUR 208,23
04-10-2021 09:04 04-10-2021 VANGUARD FTSE ALL-WORLD UCITS ETF - (... IE00BK5BQT80 Acquisto 2 Vanguard FTSE All-World UCITS ETF - (USD) EUR -191,22 EUR 15,77
Accumulating@95,61 EUR (IE00BK5BQT80)
02-10-2021 10:46 30-09-2021 DEGIRO Costi di connessione 2021 (Xetra - XET) EUR -1,24 EUR 206,99
02-10-2021 05:50 30-09-2021 Flatex Interest EUR -0,03 EUR 208,23
29-09-2021 08:50 29-09-2021 Deposito flatex EUR 200,00 EUR 208,26
27-09-2021 10:16 24-09-2021 Trasferisci dal tuo conto deposito presso flatexDEGIRO EUR 8,26
Bank: 291,75 EUR
27-09-2021 10:16 24-09-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR 291,75 EUR 300,01
24-09-2021 09:04 24-09-2021 VANGUARD FTSE ALL-WORLD UCITS ETF - (... IE00BK5BQT80 Acquisto 3 Vanguard FTSE All-World UCITS ETF - (USD) EUR -291,75 EUR 8,26
Accumulating@97,25 EUR (IE00BK5BQT80)
20-09-2021 08:50 20-09-2021 Deposito flatex EUR 300,00 EUR 300,01
02-09-2021 11:46 01-09-2021 Trasferisci sul tuo conto deposito presso flatexDEGIRO EUR 0,01
Bank: 0,01 EUR
02-09-2021 11:46 01-09-2021 FLATEX EURO BANKACCOUNT NLFLATEXACNT Degiro Cash Sweep Transfer EUR -0,01 EUR 0,00
flatex DEGIRO Bank flatex DEGIRO Bank Dutch Branch,
Dutch Branch E clienti@degiro.it che opera come DEGIRO, e' la branca
Amstelplein 1 I www.degiro.it olandese della flatexDEGIRO Bank Pagina 1 / 2
1096 HA Amsterdam AG. flatexDEGIRO Bank AG opera Estratto conto 2021-11-29
innanzi tutto sotto la supervisione
Signor XXXXXXXXX
Via XXXXXXXXXX
XXXXXXXXXXXXXX
Italy
Nome Utente: *********rri
(XXXXXXXXX)
Data Ora Data Valore Prodotto ISIN Descrizione Borsa Variazioni Saldo
01-09-2021 02:44 31-08-2021 Deposito EUR 0,01 EUR 0,01
02-07-2021 07:41 30-06-2021 Flatex Interest Income EUR 0,00 EUR 0,00
flatex DEGIRO Bank flatex DEGIRO Bank Dutch Branch,
Dutch Branch E clienti@degiro.it che opera come DEGIRO, e' la branca
Amstelplein 1 I www.degiro.it olandese della flatexDEGIRO Bank Pagina 2 / 2
1096 HA Amsterdam AG. flatexDEGIRO Bank AG opera Estratto conto 2021-11-29
innanzi tutto sotto la supervisione
1 Like