Skip to content

My log/notes on using this with Volksbank #13

Description

@behinger

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)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions