Imports PDF deposit statements from the German online broker flatex to Sage Business Cloud Accounting.
Supported documents:
- Sammelabrechnung (Wertpapierkauf/-verkauf)
- Dividendengutschrift fuΜr auslΓ€ndische Wertpapiere
- Ertragsmitteilung - ausschuΜttender/teilthesaurierender Fonds
- Create a Sage Developer account and log in to the Sage Developer console
- Click Create App
- Enter a name and
http://localhost:8080
as Callback URL for your app - Click Save
- Rename
config-sample.json
toconfig.json
- Copy the Client ID and Client Secret from the Sage Developer console to
config.json
- Copy your SKR04 ledger account names to
config.json
- Run app.py
$ pip install virtualenv
$ virtualenv -p python3.9 env
$ source ./env/bin/activate
$ pip install -r ./requirements.txt
$ python ./app.py
__ _ _ _ _
/ _|| | __ _ | |_ ___ __ __ (_) _ __ ___ _ __ ___ _ __ | |_
| |_ | | / _` || __| / _ \\ \/ / _____ | || '_ ` _ \ | '_ \ / _ \ | '__|| __|
| _|| || (_| || |_ | __/ > < |_____|| || | | | | || |_) || (_) || | | |_
|_| |_| \__,_| \__| \___|/_/\_\ |_||_| |_| |_|| .__/ \___/ |_| \__|
|_|
[*] Please continue the login in the web browser.
127.0.0.1 - - [22/Jul/2021 19:42:47] "GET /?code=DE%1F07b6534d-2096-3c87-af09-04522459531e&country=DE HTTP/1.1" 200 -
[*] Please enter the filepath of the flatex deposit statement you want to import:
/Users/L480/flatex-deposit-statement.pdf
[*] The following transactions will be imported:
Sales with profit:
ββββββ€βββββββββββββββββββββββββββββββ€ββββββββββββ€ββββββββββββββββ€ββββββββββββββββββββ€βββββββββββββββββββββββββββ
β β Referenz β Datum β Bank (Soll) β ErtrΓ€ge (Haben) β AnlagevermΓΆgen (Haben) β
ββββββͺβββββββββββββββββββββββββββββββͺββββββββββββͺββββββββββββββββͺββββββββββββββββββββͺβββββββββββββββββββββββββββ‘
β 0 β Verkauf 4x DE000BAY0017 β 2021-7-21 β 1045.7 β 156.53 β 889.17 β
ββββββΌβββββββββββββββββββββββββββββββΌββββββββββββΌββββββββββββββββΌββββββββββββββββββββΌβββββββββββββββββββββββββββ€
β 1 β Verkauf 5x DE0007100000 β 2021-7-21 β 1224.35 β 175.27 β 1049.08 β
ββββββ§βββββββββββββββββββββββββββββββ§ββββββββββββ§ββββββββββββββββ§ββββββββββββββββββββ§βββββββββββββββββββββββββββ
Sales with loss:
ββββββ€βββββββββββββββββββββββββββ€ββββββββββββ€βββββββββββββββββββββββββββ€ββββββββββββββββββββ€ββββββββββββββββ
β β Referenz β Datum β AnlagevermΓΆgen (Haben) β Verluste (Soll) β Bank (Soll) β
ββββββͺβββββββββββββββββββββββββββͺββββββββββββͺβββββββββββββββββββββββββββͺββββββββββββββββββββͺββββββββββββββββ‘
β 0 β Verkauf 7x DE0008232125 β 2021-7-21 β 784.76 β 67.18 β 717.58 β
ββββββΌβββββββββββββββββββββββββββΌββββββββββββΌβββββββββββββββββββββββββββΌββββββββββββββββββββΌββββββββββββββββ€
β 1 β Verkauf 13x DE0005557508 β 2021-7-21 β 903.44 β 121.98 β 781.46 β
ββββββ§βββββββββββββββββββββββββββ§ββββββββββββ§βββββββββββββββββββββββββββ§ββββββββββββββββββββ§ββββββββββββββββ
Purchases:
ββββββ€ββββββββββββββββββββββββ€ββββββββββββ€βββββββββββββββββ€ββββββββββββββββββββββββββ
β β Referenz β Datum β Bank (Haben) β AnlagevermΓΆgen (Soll) β
ββββββͺββββββββββββββββββββββββͺββββββββββββͺβββββββββββββββββͺββββββββββββββββββββββββββ‘
β 0 β Kauf 10x DE0005552004 β 2021-7-21 β 1265.4 β 1265.4 β
ββββββ§ββββββββββββββββββββββββ§ββββββββββββ§βββββββββββββββββ§ββββββββββββββββββββββββββ
[*] Continue? [y/N]:
y
[β] Created journal 'Verkauf 4x DE000BAY0017'.
[β] Created journal 'Verkauf 5x DE0007100000'.
[β] Created journal 'Verkauf 7x DE0008232125'.
[β] Created journal 'Verkauf 13x DE0005557508'.
[β] Created journal 'Kauf 10x DE0005552004'.