Skip to content

My log/notes on using this with Volksbank #13

Open
@behinger

Description

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)

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