stoier

stoier is the accounting helper toolkit.

00_csv_to_yaml

This script reads Postbank bank statements and converts rows into dictionaries

Note: No deduplication of rows is done at this point!

Example:

The following command will read all CSVs in data/00_account. If the string gebuchte Umsätze is encountered in the first column of a row, the data will start 2 rows after that. A custom header is used. Results will be written to the dist directory.

$ 00_csv_to_yml -v dist -t "0:gebuchte Umsätze:2" data/00_account/*.csv -h "date_1:date_2:type:details:sender:receiver:amount:balance" -r

Options: -v: verbose output -d: debug output -t: trigger; split head from body -h: header; add a custom csv header -r: read file in reverse order dist: out directory

Alternatively you could use the following command to skip only 1 row after the trigger and use the row after the trigger as header.

$ 00_csv_to_yml -v dist -t "0:gebuchte Umsätze:1" data/00_account/*.csv

01_clean

This script removes control characters from data.

Note: 01_clean will always select the latest file.

$ 01_clean -v dist dist/01_bookings

Options: -v: verbose output -d: debug output dist: out directory

02_deduplicate

Since this Postbank csv files have overlapping time slots, this scripts will deduplicate the records. Its writes to files: One with the unique bookings, one with all the customes. The customer file needs to be enriched manually with the "virtual account" they belong to, in our case mostly the interal customer reference number.

Note: 02_deduplicate will always select the latest file.

All bookings between 1.1.2020 (incl.) and 31.12.2020 (incl.) will be added to the result.

$ 02_deduplicate -v dist dist/02_clean_bookings -s 01.01.2020 -e 31.12.2020

Options: -v: verbose output -d: debug output -s: start date -e: end date dist: out directory

03_validate

This scripts returns a file which contains a sorted list of bookings, grouped by day. Each booking has a field

gross_accounts (internal customer reference),
ìd (idetifier per day),
net_accounts
vat
vat_account

Note: 03_validate will always select the latest file.

$ 03_validate -d dist dist/03_unique_bookings