Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

My log/notes on using this with Volksbank #13

Open
2 of 3 tasks
behinger opened this issue Jan 7, 2023 · 1 comment
Open
2 of 3 tasks

My log/notes on using this with Volksbank #13

behinger opened this issue Jan 7, 2023 · 1 comment

Comments

@behinger
Copy link

behinger commented Jan 7, 2023

First of all - thanks for the code!!


I'm keeping a log on what I had to fix to get this working with Volksbank

  • 2022 pdfs:
    • had to rename in ipynb the from statement_reader to from bank_statement_reader
    • couldn't handle "Euro-Überweisung" => added L50 in booking/booking-base.py
        "Euro-Überweisung": "Überweisung",
        "Auszahlung Maestro":"Überweisung",
        "Entgelt/Auslagen":"Kontogebühren",
        "Überweisung":"Überweisung",
        "SEPA-Basislastschr.":"Überweisung",
        "Kartennutzung":"Bargeldabhebung",
        "Überweisung SEPA":"Überweisung",
        
       ```
  • let's try something harder: 2012 pdfs: - just works. nice!

One issue: if transfers that needed course exchange (in my case NOR to EUR), they are linked as attachements - I guess these are impossible to parse. I get a Payee "siehe" info ;)

  • let's try credit card statements - maybe next time.

Btw. I do all my categorisation in beancount, thus didn't change anything there / used it. My simple script:

from bank_statement_reader import csv2bookings, pdf2bookings, txt2bookings
import os
import pandas as pd
df_list = []
for filename in os.listdir():
    if filename.endswith('.pdf') and "Kontoauszug" in filename:
        booking = pdf2bookings(filename)
        booking_list = [[b.date,b.type,b.payee,b.comment,b.amount] for b in booking]
        df = pd.DataFrame(booking_list, columns=["date","type","payee","narration","amount"])
        df_list.append(df)
df = pd.concat(df_list)
@CarliJoy
Copy link
Owner

CarliJoy commented Jan 8, 2023

Sounds good.
I currently not really using this code, as I converted and imported everything I need. And the new system allows to export csv for a much larger period.
Feel free to submit a PR if you finished your work to get it working with Volksbank.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants