PDF import from DeGiro

English Import/export
16

Hello Reycobos,
welcome to the forum.

If there is an error in the PDF import, you can send us the PDF exports and someone will look at them. You can see how this works in the video tutorial.

Tutorial:

It could also be that your PDF imports are currently not working because the documents have been changed. The necessary changes have been made and will probably come in the next release of PP.

If it’s about how to use the software, check out some tutorials on YouTube or use google translator and check out this:

I hope I could help you…
Alex

17

Hello Nirus,

Many thanks for your reply. I tried many times but I’ve still got the same error. As I can read on the previous post, there is an ongoing update for the next version. Just in case, here is my text.

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
Transactions from 29-01-2020 until 02-02-2021
Date Time Product ISIN Referen Quantitce Venue y Price Local value Value
Exchan Transaction
ge rate costs Total
02-02-2021 17:39 NRG ENERGY INC. COMMO US6293775085 NSY XNAS 25 43.30 USD -1,082.50 USD -972.53 CHF 1.112 -0.63 CHF -973.16 CHF
02-02-2021 16:14 AMERICAN STATES WATER US0298991011 NSY XNAS 10 80.35 USD -803.50 USD -721.95 CHF 1.1118 -0.04 CHF -721.99 CHF
02-02-2021 16:14 AMERICAN STATES WATER US0298991011 NSY XNAS 4 80.35 USD -321.40 USD -288.78 CHF 1.1118 -0.55 CHF -289.33 CHF
02-02-2021 15:47 HOME DEPOT INC. (THE) US4370761029 NSY BATS 4 271.94 USD -1,087.76 USD -977.94 CHF 1.1112 -0.55 CHF -978.49 CHF
02-02-2021 14:11 FLATEXDEGIRO AG DE000FTG1111 XET XETA 11 79.00 EUR -869.00 EUR -939.22 CHF 0.9243 -4.80 CHF -944.02 CHF
28-01-2021 15:30 BLACKBERRY LTD CA09228F1036 NSY CDED -50 19.00 USD 950.00 USD 842.86 CHF 1.126 -0.72 CHF 842.14 CHF
27-01-2021 16:08 BLACKBERRY LTD CA09228F1036 NSY CDED 50 20.88 USD -1,044.00 USD -929.73 CHF 1.1218 -0.72 CHF -930.45 CHF
30-12-2020 10:09 CD PROJEKT RED SA PLOPTTC00011 WSE XWAR 15 277.80 PLN -4,167.00 PLN -998.93 CHF 4.1673 -7.03 CHF -1,005.96 CHF
03-08-2020 09:30 VANGUARD FTSE AW IE00B3RBWM25 EAM XAMS 15 77.09 EUR -1,156.35 EUR -1,248.40 CHF 0.9253 -1,248.40 CHF
08-05-2020 17:52 V.F. CORPORATION COMMO US9182041080 NSY XNAS 9 58.42 USD -525.78 USD -509.94 CHF 1.03 -0.56 CHF -510.50 CHF
08-05-2020 17:34 CARNIVAL CORPORATION C PA1436583006 NSY CDED 15 13.905 USD -208.58 USD -202.26 CHF 1.0302 -0.59 CHF -202.85 CHF
08-05-2020 17:02 SIMON PROPERTY GROUP US8288061091 NSY CDED 6 58.75 USD -352.50 USD -341.32 CHF 1.0317 -0.55 CHF -341.87 CHF
08-05-2020 16:59 3M COMPANY COMMON US88579Y1010 NSY SOHO 4 148.16 USD -592.64 USD -573.78 CHF 1.0318 -0.55 CHF -574.33 CHF
STOC
08-05-2020 16:58 SYSCO CORPORATION US8718291078 NSY ARCX 10 52.20 USD -522.00 USD -505.48 CHF 1.0316 -0.57 CHF -506.05 CHF
COMM
08-05-2020 15:15 VANGUARD FTSE AW IE00B3RBWM25 EAM XAMS 14 74.35 EUR -1,040.90 EUR -1,095.96 CHF 0.9488 -1,095.96 CHF
DEGIRO B.V. DEGIRO B.V. is registered as an
Amstelplein 1 E customers@degiro.ch investment company with the
1096 HA Amsterdam I www.degiro.ch Netherlands Financial Markets Page 1 / 1
Authority (AFM). Account statement 2021-02-02
1 Like
18

Good morning, with the new actualization of PDF TRANSACTIONS format of DEGIRO PP does not read the document anymore, it does not recognize the document. Thanks for your hard work.

19

It is now published with Version 0.50.4.

21

When the PDF have the field “Transaction costs” empty an error occurs while importing.

22

Hello @Jorge_Bachiller
please post the PDF debug here, then we can have a look and adjust the importer if necessary.

Video tutorial:
Extract PDF documents for debugging

23

In my case, with the lastest update is at least processing the PDF from degiro.

This is the error I’m having:

image
image1483×88 4.22 KB

Transacciones de 16-01-2021 a 08-02-2021
Fecha Hora Producto ISIN Bolsa Centro dede ejecución Número Precio Valor local Valor
Tipo de Costes de
cambio transacción Total
05-02-2021 17:10 MERCK & COMPANY INC. US58933Y1055 NSY XNYS 22 75,75 USD -1.666,50 USD -1.385,52 EUR 1,2016 -0,57 EUR -1.386,09 EUR
05-02-2021 16:43 PROCTER & GAMBLE COMPA US7427181091 NSY XNYS 15 129,30 USD -1.939,50 USD -1.613,56 EUR 1,2008 -0,55 EUR -1.614,11 EUR
05-02-2021 09:30 NOVARTIS AG CH0012005267 SWX JSSI 30 82,15 CHF -2.464,50 CHF -2.279,62 EUR 1,08 -5,14 EUR -2.284,76 EUR
04-02-2021 20:42 BHP BILLITON PLC SPONS US05545E2090 NSY CDED 22 55,79 USD -1.227,38 USD -1.025,98 EUR 1,1951 -0,57 EUR -1.026,55 EUR
04-02-2021 18:40 ZILLOW GROUP INC. - C US98954M1018 NDQ CDED 3 155,73 USD -467,19 USD -390,50 EUR 1,1952 -0,51 EUR -391,01 EUR
04-02-2021 18:06 MCDONALDS CORPORATION US5801351017 NSY XNAS 5 211,75 USD -1.058,75 USD -884,50 EUR 1,1958 -0,52 EUR -885,02 EUR
04-02-2021 16:39 ETFS BRENT CRUDE JE00B78CGV99 MIL MTAA -386 19,692 EUR 7.601,11 EUR 7.601,11 EUR -4,28 EUR 7.596,83 EUR
27-01-2021 20:55 APPLE INC. - COMMON ST US0378331005 NDQ XNAS 9 141,70 USD -1.275,30 USD -1.053,79 EUR 1,209 -0,53 EUR -1.054,32 EUR
27-01-2021 20:54 NIKOLA CORP US6541101050 NDQ XNAS -48 28,00 USD 1.344,00 USD 1.108,34 EUR 1,2114 -0,66 EUR 1.107,68 EUR
DEGIRO B.V. DEGIRO B.V. es una empresa de
Amstelplein 1 E clientes@degiro.es servicios de inversión regulada por la
1096 HA Amsterdam I www.degiro.es Autoridad Financiera de los Mercados Página 1 / 1
Holandeses. Estado de cuenta 2021-02-08

If I remove the ETF BRENT… from the PDF transactions, works perfectly, dont know if has nothing to do with the currency, could be the system expecting a currency exchange even if the transaction was is in EUR?.

thanks!

24

Of course yes

Autor PDF: ''
PDFBox Version: 1.8.16
-----------------------------------------
Transacciones de 03-02-2021 a 03-02-2021
Fecha Hora Producto ISIN Bolsa Centro dede ejecución Número Precio Valor local Valor
Tipo de Costes de
cambio transacción Total
03-02-2021 21:57 LUMINAR TECHNOLOGIES US5504241051 NDQ SOHO 19 32,169 USD -611,21 USD -507,95 EUR 1,2021 -0,56 EUR -508,51 EUR
INC. - CLASS A COMMON
STOCK
03-02-2021 21:55 PALANTIR TECHNOLOGIES US69608A1088 NSY CDED 20 31,67 USD -633,40 USD -526,30 EUR 1,2023 -0,57 EUR -526,87 EUR
INC-A
03-02-2021 21:28 WORKHORSE GROUP INC. US98138J2069 NDQ CDED -14 35,87 USD 502,18 USD 416,71 EUR 1,2039 -0,05 EUR 416,66 EUR
03-02-2021 21:28 WORKHORSE GROUP INC. US98138J2069 NDQ CDED -2 35,88 USD 71,76 USD 59,55 EUR 1,2039 -0,01 EUR 59,54 EUR
03-02-2021 21:28 WORKHORSE GROUP INC. US98138J2069 NDQ CDED -1 35,88 USD 35,88 USD 29,77 EUR 1,2039 -0,50 EUR 29,27 EUR
03-02-2021 21:18 UPWORK INC. CMN US91688F1049 NDQ SOHO -20 47,00 USD 940,00 USD 780,08 EUR 1,2038 -0,07 EUR 780,01 EUR
03-02-2021 21:18 UPWORK INC. CMN US91688F1049 NDQ SOHO -1 47,00 USD 47,00 USD 39,00 EUR 1,2038 39,00 EUR
03-02-2021 21:18 UPWORK INC. CMN US91688F1049 NDQ SOHO -4 47,00 USD 188,00 USD 156,02 EUR 1,2038 -0,51 EUR 155,51 EUR
03-02-2021 19:31 SEA LTD-ADR US81141R1005 NSY CDED -3 244,00 USD 732,00 USD 607,57 EUR 1,2036 -0,51 EUR 607,06 EUR
DEGIRO B.V. DEGIRO B.V. es una empresa de
Amstelplein 1 E clientes@degiro.es servicios de inversión regulada por la
1096 HA Amsterdam I www.degiro.es Autoridad Financiera de los Mercados Página 1 / 1
Holandeses. Estado de cuenta 2021-02-07
25

Hello @Xip, @Reycobos and @Jorge_Bachiller ,

Thx for the PDF debugs…
With the new format, each transaction must be customized.
Tested the following detections

  • with currency exchange and fees
  • with currency exchange and without fees
  • without currency exchange and with fees
  • no example was included for testing
    • without currency exchange and without fees
1 Like
26

Thanks for your patience . I’m looking forward for the next release.

27

Hi,
I’m also waiting for the changes in degiro import format.
I’m attaching my transactions, just to give more testing data.import_degiro.txt (305.2 KB)

28

@zet
I guess we need your translation support from Polish into English, otherwise we need to roll the dices when allocate the columns. :wink:

Furthermore a screen dump is at least helpful as the columns are mostly not named. Or I’m not able to recognise them.

1 Like
29

Hallo @zet @brandtbombe @MandelKr

  • Add polski language support
  • Add new polski amount format
  • Add new detection format
  • Add new transaction format
1 Like
30

Hi everyone, new user here.
For what I’ve read and watched about PP, it seems like it would be the right tool for me. I have been investing for a few years and now that I would like to track my investments with PP, I have a long history of dividends paid to my Degiro accounts (first one created is in finnish and my current one is in english). I tried to import the account.pdf but like many, got errors.

For what Ive reaad so far in this thread, I am assuming that english language inputs are not yet supported. Would it be possible to add them and what would you need me to provide if so?

Thanks a lot for the support!

31

Hello @salamartur

Video tutorial:
Extract PDF documents for debugging

32

Hi,
I am not so sure with the English language. I am more concerned about the dividends.
I implemented all my Degiro dividends last year in Portfolio-Performance manually, as it seemed very difficult for the importer to understand what belongs to the dividend payment.
At least in my German degiro account pdf, I have to sometimes guess what belongs to which dividend payment. I especially see the currency changes as the problem.
Not sure if the team has developed this further, but maybe it is good to give @Nirus the debugging and then let’s see.

1 Like
34 
PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
Account statement from 27-02-2021 to 29-03-2021
Date Time Value date Product ISIN Description FX Change Balance
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
22-03-2021 07:39 19-03-2021 MANULIFE FINANCIAL COR CA56501R1064 Dividend CAD 18.20 CAD 13.65
22-03-2021 07:39 19-03-2021 MANULIFE FINANCIAL COR CA56501R1064 Dividend Tax CAD -4.55 CAD -4.55
16-03-2021 20:35 16-03-2021 TESLA MOTORS INC. - C US88160R1014 FX Credit 1.1897 USD 1,365.14 USD -0.00
16-03-2021 20:35 16-03-2021 TESLA MOTORS INC. - C US88160R1014 FX Debit EUR -1,147.45 EUR -2,690.26
16-03-2021 20:35 16-03-2021 TESLA MOTORS INC. - C US88160R1014 DEGIRO Transaction Fee EUR -0.01 EUR -1,542.81
16-03-2021 20:35 16-03-2021 TESLA MOTORS INC. - C US88160R1014 DEGIRO Transaction Fee EUR -0.50 EUR -1,542.80
16-03-2021 20:35 16-03-2021 TESLA MOTORS INC. - C US88160R1014 Buy 2 TESLA MOTORS INC. - C@682.568 USD USD -1,365.14 USD -1,365.14
(US88160R1014)
16-03-2021 09:24 15-03-2021 FX Debit EUR 31.66 EUR -1,542.30
16-03-2021 09:24 15-03-2021 FX Debit 1.1942 USD -37.82 USD -0.00
16-03-2021 03:39 15-03-2021 TYSON FOODS INC. COMM US9024941034 Dividend USD 44.50 USD 37.82
16-03-2021 03:39 15-03-2021 TYSON FOODS INC. COMM US9024941034 Dividend Tax USD -6.68 USD -6.68
12-03-2021 09:33 11-03-2021 FX Debit EUR 32.59 EUR -1,573.96
12-03-2021 09:33 11-03-2021 FX Debit 1.1997 USD -39.10 USD -0.00
12-03-2021 08:05 11-03-2021 PRUDENTIAL FINANCIAL US7443201022 Dividend USD 46.00 USD 39.10
12-03-2021 08:05 11-03-2021 PRUDENTIAL FINANCIAL US7443201022 Dividend Tax USD -6.90 USD -6.90
03-03-2021 08:41 02-03-2021 FX Debit EUR 38.09 EUR -1,606.55
DEGIRO B.V. DEGIRO B.V. is registered as an
Amstelplein 1 E clients@degiro.ie investment company with the
1096 HA Amsterdam I www.degiro.ie Netherlands Financial Markets Page 1 / 2
Authority (AFM). Account statement 2021-03-29
Mr Arturo Salazar Martinez
Niiittaajankatu 12 A 5
00810 Helsinki
Finland
User name: ***********989
(161040666)
Date Time Value date Product ISIN Description FX Change Balance
03-03-2021 08:41 02-03-2021 FX Debit 1.5292 CAD -58.25 CAD 0.00
02-03-2021 14:53 01-03-2021 ENBRIDGE INC COMMON ST CA29250N1050 Dividend CAD 77.66 CAD 58.25
02-03-2021 14:53 01-03-2021 ENBRIDGE INC COMMON ST CA29250N1050 Dividend Tax CAD -19.41 CAD -19.41
01-03-2021 18:47 28-02-2021 Interest EUR -0.88 EUR -1,644.64
DEGIRO B.V. DEGIRO B.V. is registered as an
Amstelplein 1 E clients@degiro.ie investment company with the
1096 HA Amsterdam I www.degiro.ie Netherlands Financial Markets Page 2 / 2
Authority (AFM). Account statement 2021-03-29
35

Hope this helps.

Thanks again!

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!