Skip to content

Latest commit

 

History

History
86 lines (58 loc) · 5.17 KB

README_EN.md

File metadata and controls

86 lines (58 loc) · 5.17 KB
Raw

Python Finance Manager

Support Python versions

Deutsche Version

Python Finance Manager for Financial Overview from comdirect Financial Reports
Using a Python script, the PDF financial reports stored on the PC for a given year are read, and the included income and expenses are assigned to booking groups based on keywords. The result is CSV files with balances and transactions per group name, which can then be further analyzed in Excel, for example.

Disclaimer

This is purely a hobby project. There is no guarantee for error-free operation, support, or timely assistance! The mentioned product and brand names are the property of their respective owners.

Requirements

  • Python 3.7+

Download and support for the Python runtime environment can be found on the support page. The Python library pdfplumber is required to read the PDF financial reports.

Installation

  1. Download Python 3.11+
  2. On Windows: Open the command line window (Start by pressing the "Windows key" + "R". Then enter "cmd.exe" and confirm with "Enter"). All further steps are to be executed in the command line window.
  3. Check the Python version with the command: python --version
  4. Update Python with the command: pip install update
  5. Install pdfplumber: pip install pdfplumber
  6. Download com_fm.py and com_fm.ini
  7. Adjust the parameters in com_fm.ini, see below

Configuration

The file com_fm.ini contains all the necessary parameters for individual customization:

Parameter Description
path : D:\comdirect\Kto1234567 Path to the location where comdirect financial reports are stored.
year : 2022 Analysis year
Group name : Keyword1, Keyword2,... e.g.:
Online Expenses : paypal,amazon,internet,online		 All income and expenses whose text contains one of the following keywords will be summarized under the group name.

com_fm.ini already contains example group names and keywords, which can be individually expanded or customized. Note: The separation between path, year, and group names is " : " (a space before and after the colon). The keywords (written in lowercase) are separated by commas without spaces. com_fm.ini is searched in the order of entry. Note that very short keywords can suppress later longer keywords. For example, the keyword "markt" can prevent the keyword "kaufmarkt" from being found.

Structure of the Financial Reports

The relevant transactions for evaluation begin on page 2 of the financial report and start with reading the Old Balance. Further income and expenses are read line by line until the New Balance is reached. The booking text lines are taken into account, e.g.: 02.06.2022 Direct Debit/ CITY SERVICES KD.-NR.345,00-INSTALLMENT0 -91,00
The text is compared with the keywords stored in com_fm.ini, and the booking amount is assigned to the group balance. The text is converted to lowercase during comparison so that case sensitivity does not matter. If no assignment can be found, income will be assigned to the group "Miscellaneous Income" and expenses to the group "Miscellaneous Expenses". To verify and possibly supplement keywords in com_fm.ini, all bookings of the groups "Miscellaneous Income" and "Miscellaneous Expenses" are output at the end. If com_fm.ini does not contain any group names, all income will be assigned to "Miscellaneous Income" and expenses to "Miscellaneous Expenses".

Execution

com_fm.py and com_fm.ini must be in the same directory.

python com_fm.py

Runtime output:

Finanzreport_Nr._01_per_03.02.2020.pdf saldo delta 0.0
Finanzreport_Nr._02_per_02.03.2020.pdf saldo delta 0.0
...

During processing, the names of the financial report files being read are displayed. A balance discrepancy is shown as delta in case of an analysis error.

Result Files

Two CSV files are generated: year_finmnanager.csv and year_finmnanager_bookings.csv. year_finmnanager.csv contains the group overview and group balances with the columns: Year; Group name; Number of transactions in the group; Balance. year_finmnanager_bookings.csv contains Booking date; Group name; Transaction; Booking text; Amount.

License

Creative Commons BY-NC-SA
Give Credit, NonCommercial, ShareAlike

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Acknowledgments

This project is a fork of the original Python-Finanzmanager by t4ri.