OpenSteuerAuszug: generate your own eTax / eSteuerauszug for IBKR, Schwab and others

Pet · February 18, 2026, 9:24pm

This thread got extracted out of Programmatic Tax Return.

It can be used for discussion and also support if needed.

If possible, issues should be reported at GitHub.

j_from_b · January 15, 2026, 1:24am

I hate to hijack a thread about another Made-in-Birmensdorf product but I already went down this rabbit hole

Pet · January 15, 2026, 6:58am

@j_from_b Wow, this sounds awesome. I have not tested it so far, but I really like the idea. No privacy concerns, fully open source. I would suggest that we extract this into an own thread for your solution. It also sounds pretty extendable for any other broker / bank.

What is the status of IBKR? Can you probably share a report based on dummy data?

PhilMongoose · January 15, 2026, 8:28am

Thanks for sharing! I’m definitely going to try this!

alanmack · January 15, 2026, 8:37am

Have you tried it yet? Curious!

PhilMongoose · January 15, 2026, 8:47am

This hits my nerd interests of both finance and technology. I’m genuinely excited to do my tax return this year

cubanpete_the_swiss · January 15, 2026, 8:55am

Bit confused, doesn’t it need a signature / certificate from Kantons?

j_from_b · January 15, 2026, 5:33pm

No certificate seems be required. In fact I cannot see any signatures in any of the payloads for statements I have from other banks.

I tried reaching out to the listed email adres for new implementers and got no response

There has been one real world use case and ZH Private Tax accepted it.

The fornat assumes yiu are a bank in some places so some fakery is required. For instance the 1D barcode on each page that is used by the document scanner if you use paper requires a Bankleitzahl.

But yes one reaction to this is a lockdown…

PhilMongoose · January 15, 2026, 5:43pm

I have some examples of stock splits etc. so I can send you some for testing.

j_from_b · January 15, 2026, 5:48pm

To answer questions raised elsewhere

It has been accepted at least once by ZH private tac
iBKR and Schwab work for me with fairly run of the mill ETGss & security lending
All formats ate under documented. For instance I don’t how IBKR represents stock splits and the last rights issue was also too long ago do me.
Using investments not on the kurskiste does bot work (skeketon is there) but i general outsourcing the actual tac decisions to IC Tax seems the bettter strategy
It is nissing day level authoritative exchange rate data. The tax iffice can correct on import (IC Yax publishes only monthly)

If somebody has paper trading on IBKR that they xan donate for test data that would be great

This is for tinkerers. datalevel.ch is the option if you want polish & matury

PhilMongoose · January 15, 2026, 5:53pm

you also have a reference to the kursliste data management guide, but it is a dead link:

https://github.com/vroonhof/opensteuerauszug/blob/main/docs/data/kursliste/kursliste.md

does generated language need to be de, fr or it or is en also valid?

nabalzbhf · January 15, 2026, 6:47pm

Btw another tricky thing is late withholding refund (eg BND US withholding that’s refunded early on subsequent year).

PhilMongoose · January 15, 2026, 7:36pm

OK. Great! After some tinkering, I managed to generate a PDF.

I need to double check to see how accurate it is.

I also added functionality for it to check for missing ISINs:

Updated data/security_identifiers.csv

  Total entries: 178 securities
  With ISINs: 169 (95%)
  Without ISINs: 9 (e.g. futures/options that typically don't have ISINs)

  The 9 securities without ISINs (all futures/options):

    [list of securities]

Pet · January 15, 2026, 8:27pm

This finding is pretty useful: while searching for this taxstatement-api file, I have found this page, which even mentions your post here. This goes pretty much into details, because they found a security issue in the library. They pretty much explain how to retrieve the file from public sources.

Based on this, I went down the rabbit hole, and looked into the .jar file using IntelliJ decompiler. In the end, I was able to generate a PDF (and even an official validation report) for the sample XML created by @j_from_b . There is way more config params available for styling and configuration the PDF, but for now I had to stop. The funny thing is, that the jar official jar file even contains some official logos and other content from banks - looks like they are also using this tool.

Let’s hope this helps @j_from_b a bit. I really like the idea of creating an open source generator for this, which also works for banks and brokers who do not offer digital CH tax statements. Also the validation tool seems to be quite helpful - it already reports some issues for the sample XML file.

I had to attach the script as text because I cannot upload text files here. Feel free to edit my post.

#!/bin/sh

# script to download official taxstatement.jar from public sources.
# the jar is mentioned in the official technical documentation:
# https://www.ech.ch/sites/default/files/dosvers/beilagen/BEIL2_d_DEF_2022-06-07_eCH-0196_V2.0.0_Barcode%20Generierung%20-%20Technische%20Wegleitung.pdf
# it also fetches a sample XML file from https://github.com/vroonhof/opensteuerauszug and creates a PDF and validation report

mkdir taxstatement
cd taxstatement

wget https://efisc.kttg.ch/update/eFisc/2025/efisc2025_1.0.2-70_amd64.deb
ar x efisc2025_1.0.2-70_amd64.deb data.tar.zst
tar --use-compress-program=zstd -xf data.tar.zst --transform 's,.*/,,g' ./usr/share/efisc2025/taxstatement-2.2.4.1.jar
rm data.tar.zst

# libs for creating PDF
wget https://repo1.maven.org/maven2/uk/org/okapibarcode/okapibarcode/0.5.2/okapibarcode-0.5.2.jar
wget https://repo1.maven.org/maven2/org/apache/pdfbox/fontbox/2.0.35/fontbox-2.0.35.jar
wget https://repo1.maven.org/maven2/org/apache/pdfbox/pdfbox/2.0.35/pdfbox-2.0.35.jar
wget https://repo1.maven.org/maven2/commons-logging/commons-logging/1.3.5/commons-logging-1.3.5.jar

# additional libs for validation report
wget https://repo1.maven.org/maven2/org/apache/poi/poi/5.5.1/poi-5.5.1.jar
wget https://repo1.maven.org/maven2/org/apache/poi/poi-ooxml/5.5.1/poi-ooxml-5.5.1.jar
wget https://repo1.maven.org/maven2/org/apache/poi/poi-ooxml-lite/5.5.1/poi-ooxml-lite-5.5.1.jar
wget https://repo1.maven.org/maven2/commons-io/commons-io/2.21.0/commons-io-2.21.0.jar
wget https://repo1.maven.org/maven2/org/apache/xmlbeans/xmlbeans/5.3.0/xmlbeans-5.3.0.jar
wget https://repo1.maven.org/maven2/org/apache/commons/commons-collections4/4.5.0/commons-collections4-4.5.0.jar
wget https://repo1.maven.org/maven2/org/apache/commons/commons-compress/1.28.0/commons-compress-1.28.0.jar
wget https://repo1.maven.org/maven2/org/apache/logging/log4j/log4j-api/2.25.3/log4j-api-2.25.3.jar
wget https://repo1.maven.org/maven2/org/apache/logging/log4j/log4j-core/2.25.3/log4j-core-2.25.3.jar

# additional libs for PDF to XML extraction
wget https://repo1.maven.org/maven2/com/google/zxing/core/3.5.4/core-3.5.4.jar
wget https://repo1.maven.org/maven2/com/google/zxing/javase/3.5.4/javase-3.5.4.jar

# the following is only needed for demonstration purposes

wget https://raw.githubusercontent.com/vroonhof/opensteuerauszug/refs/heads/main/tests/samples/fake_statement.xml

# creates PDF
# force needed for fake_statement.xml because it seems to miss some needed declarations: xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ech.ch/xmlns/eCH-0196/2.2/eCH-0196-2-2.xsd http://www.ech.ch/xmlns/eCH-0097/4/eCH-0097-4-0.xsd"
java -Dforce=true -Dssk=false -Dpdf=true -cp "./*" ch.ewv.taxstatement.examples.TaxStatementMain fake_statement.xml

# creates validation report
java -Dxlsx=true -cp "./*" ch.ewv.taxstatement.examples.TaxStatementMain fake_statement.xml

# extracts XML from a PDF
java -cp "./*" ch.ewv.taxstatement.examples.TaxStatementPDFToXML fake_statement.pdf extracted.xml

PhilMongoose · January 15, 2026, 8:52pm

I’ve had to make some changes to the code, but it is getting there now, there are still some fixups to be made:

e.g. make BuySell.BUY to just ‘BUY’

opening value is blank when 0 etc.

Then there is inconsistency in IBKR data, why do some rows have:

19.02.2025 SELL 5000 AWE @ 1.448 GBP-5’000

and others just:

01.04.2025 Sell-10’000

PhilMongoose · January 15, 2026, 9:51pm

OK. Making progress and having more fun with this than is normal/healthy.

Still stuff that isn’t quite right yet.

nkbhnomfcmmwxdlula · January 15, 2026, 10:09pm

Has anyone actually done that? I also have 1000+ of trades last year.

PhilMongoose · January 15, 2026, 10:32pm

Thanks for sharing this. I see that I’m still having a few failures against the validator. This is useful!

It is so nice having the all the data in one place. It makes it easier to do some checks e.g.

Top 20 Price Discrepancies
  ┌──────┬──────────────┬─────────────────────────────┬───────────────────────┬────────────────┬─────────────┬─────────────────┐
  │ Rank │     ISIN     │          Security           │     Broker Price      │   Kursliste    │ Discrepancy │      Notes      │
  │      │              │                             │                       │     Price      │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 1    │ US82575P1075 │ SIBANYE-STILLWATER          │ 4.55 USD (3.61 CHF)   │ 11.29 CHF      │ +212.91%    │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 2    │ IE00B4LHWP62 │ ISHARES PHYSICAL PLATINUM   │ 10.46 GBP (11.15 CHF) │ 25.06 CHF      │ +124.85%    │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 3    │ GB00BNDRMJ14 │ ALPHAWAVE IP GROUP          │ 1.78 GBP (1.90 CHF)   │ 0 CHF          │ -100.00%    │ ⚠ Kursliste =  │
  │      │              │                             │                       │                │             │ 0               │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 4    │ CA0679011084 │ BARRICK GOLD                │ 18.40 USD (14.57 CHF) │ 0 CHF          │ -100.00%    │ ⚠ Kursliste =  │
  │      │              │                             │                       │                │             │ 0               │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 5    │ DE000ENER6Y0 │ SIEMENS ENERGY              │ 60.66 EUR (56.44 CHF) │ 112.03 CHF     │ +98.48%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 6    │ US2566771059 │ DOLLAR GENERAL              │ 71.76 USD (56.85 CHF) │ 105.19 CHF     │ +85.02%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 7    │ US36828A1016 │ GE VERNOVA                  │ 361 USD (286.00 CHF)  │ 517.79 CHF     │ +81.04%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 8    │ US63253R2013 │ NAC KAZATOMPROM             │ 33.4 USD (26.46 CHF)  │ 44.21 CHF      │ +67.07%     │ Qty: 1100       │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 9    │ US4464131063 │ HUNTINGTON INGALLS          │ 227.60 USD (180.31    │ 269.42 CHF     │ +49.42%     │                 │
  │      │              │                             │ CHF)                  │                │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 10   │ US02079K1079 │ ALPHABET (GOOG)             │ 212.13 USD (168.06    │ 248.61 CHF     │ +47.93%     │                 │
  │      │              │                             │ CHF)                  │                │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 11   │ US81369Y1001 │ MATERIALS SELECT SECTOR     │ 86.60 USD (68.61 CHF) │ 35.93 CHF      │ -47.63%     │                 │
  │      │              │ SPDR                        │                       │                │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 12   │ US75513E1010 │ RTX CORP                    │ 124.55 USD (98.67     │ 145.30 CHF     │ +47.25%     │                 │
  │      │              │                             │ CHF)                  │                │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 13   │ US5324571083 │ ELI LILLY                   │ 731.69 USD (579.68    │ 851.42 CHF     │ +46.88%     │                 │
  │      │              │                             │ CHF)                  │                │             │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 14   │ IE0001827041 │ CRH PLC                     │ 86.05 USD (68.17 CHF) │ 98.87 CHF      │ +45.03%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 15   │ US46428Q1094 │ ISHARES SILVER TRUST        │ 45.37 USD (35.94 CHF) │ 51.04 CHF      │ +41.99%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 16   │ US93627C1018 │ WARRIOR MET COAL            │ 63.59 USD (50.38 CHF) │ 69.85 CHF      │ +38.65%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 17   │ CA85207Q1046 │ SPROTT PHYSICAL PLATINUM    │ 12.15 USD (9.63 CHF)  │ 13.34 CHF      │ +38.60%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 18   │ JE00BF50RG45 │ YELLOW CAKE PLC             │ 4.29 GBP (4.57 CHF)   │ 6.31 CHF       │ +38.00%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 19   │ US78462F1030 │ SPDR S&P 500 ETF            │ 496 USD (392.96 CHF)  │ 540.25 CHF     │ +37.48%     │                 │
  ├──────┼──────────────┼─────────────────────────────┼───────────────────────┼────────────────┼─────────────┼─────────────────┤
  │ 20   │ (next row)   │ ...                         │ ...                   │ ...            │ ...         │                 │
  └──────┴──────────────┴─────────────────────────────┴───────────────────────┴────────────────┴─────────────┴─────────────────┘

dbu · January 16, 2026, 4:02am

Yes, several confirmed.
But it will depend on your canton how well it’s received. (Worked in ZH and BS, not sure about others)

PhilMongoose · January 16, 2026, 8:25am

Some cantons do not allow it as they do not use the actual market values but have their own specific tax values for securities that need to be applied.