PDF import from Saxo Bank

English Import/export
21

Hello @pheb @steve4life8

Please watch the tutorial video carefully and post a “complete” PDF debug.

  • Otherwise, please do not change or delete any other data.
  • The personal data must be replaced 1 to 1.
  • Other changes, such as replacing the date or similar, are also counterproductive.
  • **!! ONLY YOUR OWN PERSONAL DATA !!!
  • No PDFs which are converted to PDF from a browser or similar
  • No self-scanned paper slips

z. B.

  • Name → Max Mustermann and so on…
  • Address → Blumenstraße
  • IBAN and deposit numbers: The numbers 1 to 1.*

No more and no less… One post per PDF debug please.
End.

Video tutorial:
Extract PDF documents for debugging

Regards
Alex

22

Hello @pheb, @Callahan75 and @steve4life8
I have just made the changes for the Saxo PDF Importer in German and should be included in the next release.
So far you have made the wrong documents available here.
There are “Trade-Detail” PDF documents and e.g. the account statement report.
The “Trades Executed Report” is the wrong one… You will have to import the “Trade Details” as a document in the future. The same applies to dividends and sales. However, we do not have any PDF debugs here, so they are not yet available as PDF importers. (see here)

Regards
Alex

23

I am new but also on saxobank. I exported a single trade on one of my accounts (german). i changed the the Kunden ID to "123"and the konto to “1” and “12”. Hope this is useful… if this way is good I could also provide some dividends
Thanks for your work and merry christmas

Trades_123_2024-12-20_2024-12-20.pdf.txt (2.0 KB)

24

You can also the PDF Debugs create in other languages.

25

Hi there. I too am using Saxo Bank and Nordnet (Denmark). I assume the importer has not yet been built? Can I be of any assistance in its development? As I understand it, I need to provide the anonymized data on transactions etc. from the PDF? And from that, the developers will be able to create a template built on that? Thanks for the great app btw!

26

Hello @FAvonHayek
Welcome to the forum of PP. :slightly_smiling_face:
Please create a PDF debug and post it here.
The best way to find out how this works is to watch the video tutorial.

Video tutorial:

27

Hi,

Yes, you are correct. To improve the importer, you can post anonymized PDF-debugs here.

Please pay attention to Nirus’s note regarding the document types, as this bank seems to have many different document types:

29

I found the following individual transaction report. Unfortunately, Saxo has two portals (Saxotrader and Saxoinvestor) and only found this on the latter one.

PDFBox Version: 3.0.3
Portfolio Performance Version: 0.75.1
System: macosx | aarch64 | 21.0.5+11-LTS | Azul Systems, Inc.
-----------------------------------------
gkHW cKEkaTVNz - 38701869
Transaction Report
Reporting period: 20-Mrz-2025 - 29-Apr-2025
Generated at: 29-Apr-2025 07:35:18 19:35:18 (GMT+01)
eLoN aysmFOSQy
hlvfIqdL 14a 25
13-821 fSEXHldN
Poland
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark YJMF eEQxbnPPw Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 1 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025
Transactions, USD
Reporting period
20-Mrz-2025 to 29-Apr-2025
Type Instrument Event Booked Amount Cash
28-Apr-2025 20,23 14.593,49
Corporate action Virtus Infracap US Preferred Stock ETF Cash dividend 20,23 -
Eligible quantity Dividend per share Conversion Rate Corporate Actions - Withholding Tax
140 0,17 USD 1,000000 -3,57 USD
Corporate Actions - Withholding Tax (%) Corporate Actions - Cash Dividends Transaction description ISIN
15% 23,80 USD Event Id 9357422 US26923G8226
25-Apr-2025 16,87 14.573,26
Corporate action NEOS S&P 500 High Income ETF Cash dividend 16,87 -
Eligible quantity Dividend per share Conversion Rate Corporate Actions - Cash Dividends
43 0,46 USD 1,000000 19,85 USD
Corporate Actions - Withholding Tax Corporate Actions - Withholding Tax (%) Transaction description ISIN
-2,98 USD 15% Event Id 9378500 US78433H3030
16-Apr-2025 -3.695,65 14.556,39
Trade NEOS S&P 500 High Income ETF Buy 22 @ 45,30 USD -997,60 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -996,60 USD -1,00 USD 1,000000
ISIN
US78433H3030
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark ZhqP AXcbVgFMP Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 2 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025
Transactions, USD
Reporting period
20-Mrz-2025 to 29-Apr-2025
Type Instrument Event Booked Amount Cash
Trade Ares Capital Corp. Buy 89 @ 20,13 USD -1.793,00 -
Commission Share Amount Total cost Conversion Rate
-1,43 USD -1.791,57 USD -1,43 USD 1,000000
ISIN
US04010L1035
Trade Virtus Infracap US Preferred Stock ETF Buy 45 @ 20,09 USD -905,05 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -904,05 USD -1,00 USD 1,000000
ISIN
US26923G8226
09-Apr-2025 -981,98 18.252,04
Trade Virtus Infracap US Preferred Stock ETF Buy 49 @ 20,02 USD -981,98 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -980,98 USD -1,00 USD 1,000000
ISIN
US26923G8226
07-Apr-2025 39,90 19.234,02
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark Dirk Ackermann Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 3 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025
Transactions, USD
Reporting period
20-Mrz-2025 to 29-Apr-2025
Type Instrument Event Booked Amount Cash
Corporate action Janus Henderson AAA CLO ETF Cash dividend 39,90 -
Eligible quantity Dividend per share Conversion Rate Corporate Actions - Withholding Tax
197 0,24 USD 1,000000 -7,04 USD
Corporate Actions - Withholding Tax (%) Corporate Actions - Cash Dividends Transaction description ISIN
15% 46,94 USD Event Id 9357212 US47103U8457
03-Apr-2025 -1.978,40 19.194,12
Trade PIMCO Corporate & Income Opportunity Fund Buy 69 @ 14,46 USD -998,48 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -997,48 USD -1,00 USD 1,000000
ISIN
US72201B1017
Trade NEOS S&P 500 High Income ETF Buy 21 @ 46,62 USD -979,92 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -978,92 USD -1,00 USD 1,000000
ISIN
US78433H3030
01-Apr-2025 20.000,71 21.172,52
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark vrAH BVrjvuqcz Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 4 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025
Transactions, USD
Reporting period
20-Mrz-2025 to 29-Apr-2025
Type Instrument Event Booked Amount Cash
Cash amount Interest 0,71 -
Conversion Rate Interest Comment
1,000000 0,71 USD Interest - Mar 2025
Cash Transfer Deposit 20.000,00 -
Comment Conversion Rate Cash Amount
/FIN53/CITIGB2LXXX 1,000000 20.000,00 USD
28-Mrz-2025 968,61 1.171,81
Cash Transfer Deposit 20.953,18 -
IBAN IBAN owner name Currency Conversion Cost Conversion Rate
DE12100110012622249680 Dirk Ackermann -52,52 1,079504
Cash Amount
20.953,18 USD
Trade Janus Henderson AAA CLO ETF Buy 197 @ 50,63 USD -9.981,40 -
Commission Share Amount Total cost Conversion Rate
-7,98 USD -9.973,42 USD -7,98 USD 1,000000
ISIN
US47103U8457
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark GTsG ETGbGlgBC Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 5 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025
Transactions, USD
Reporting period
20-Mrz-2025 to 29-Apr-2025
Type Instrument Event Booked Amount Cash
Trade BlackRock Taxable Municipal Bond Trust Buy 604 @ 16,55 USD -10.003,17 -
Commission Share Amount Total cost Conversion Rate
-8,00 USD -9.995,17 USD -8,00 USD 1,000000
ISIN
US09248X1000
20-Mrz-2025 203,20 203,20
Cash Transfer Deposit 1.200,00 -
Comment Conversion Rate Cash Amount
/FIN53/CITIGB2LXXX 1,000000 1.200,00 USD
Trade Virtus Infracap US Preferred Stock ETF Buy 46 @ 21,65 USD -996,80 -
Commission Share Amount Total cost Conversion Rate
-1,00 USD -995,80 USD -1,00 USD 1,000000
ISIN
US26923G8226
Saxo Bank / Philip Heymans Alle 15 / 2900 Hellerup / Denmark hrtD YVCRRHygj Reporting period
/ Phone No.: +45 39 77 40 00 / Fax No.: +45 39 77 42 00 / Email: info@saxobank.com Currency: USD 20-Mrz-2025 - 29-Apr-2025
Page 6 of 6 Account(s): USD 923974INET Generated at: 29-Apr-2025

I hope this allows to create the importer. Thanks in advance and happy to provide any additional data if required.

30

Hello @gaugloli
if everything is OK, then this will be included in the next release.

Regards
Alex

1 Like
31

Hello @stoudamire
There are “Trade-Detail” PDF documents and e.g. the account statement report.
The “Trades Executed Report” is the wrong one… You will have to import the “Trade Details” as a document in the future. The same applies to dividends and sales. However, we do not have any PDF debugs here, so they are not yet available as PDF importers. (see here)

Regards
Alex

33

I tried everything I could to import it via CSV to no avail. Now I’m trying to manually import buys to no avail either.

For some reason it can’t figure out that JPGL is a security denominated in EUR just because the security account is denominated in DKK? I also tried creating the security manually (EUR denominated) and adding the buy manually, and it just completely messed up with the currency exchange.

Deposit - Saxo DKK v4.csv (5.1 KB)

Really close to giving up after having spent hours on this. Really wish I had known how buggy the software is, then I wouldn’t have poured so much wasted time into it.

35

@Nirus I believe I finally found the individual transaction reports. Would you mind checking the attached ones?
Saxo Trade Example.txt (1.7 KB)
Saxo Dividend Example 2.txt (2.1 KB)
Saxo Interest Example.pdf.txt (1.2 KB)
Saxo Dividend Example.pdf.txt (2.1 KB)

36

@Nirus have you had the chance to look my uploads? Thanks.