R-CMD-check codecov

ledger is an interface for formatting banking exports. The idea is that every bank export should provide tabular data with a date, a recipient and an amount. This data gets extended by this library to add a mapping table for categorization, enabling further analysis and dashboarding.

Table of Contents



ledger_dir <- "my_ledger/"              # designated directory for all your ledger files
export_type <- "dkb"                    # specify from which bank your export is from
dkb_export <- "dkb_export_20210101.csv" # path to your export

# starting a ledger
create_ledger(dkb_export, ledger_dir, export_type)

# updating ledgers mapping table or balance

# append a new ledger to your short ledger
dkb_export2 <- "dkb_export_20211201.csv"
append_ledger(dkb_export2, ledger_dir, export_type)

Custom Data Entry

General labels are not always best - in case you want to overwrite data in a transparent way, you enter that in any of the *_custom columns:


The occurence column is a way to specify how often that exact transaction occurs per year. This is especially useful when determining what your baseline income and expense is.

Supported Exports

Right now the following banking exports are supported:

If you want to contribute another export, this is what you need supply:

  1. Add your bank to valid_types in check_export_type.R

  2. Add functions transform_export_YOURBANK.R and setup_balance_YOURBANK.R

  3. Implement the new function call in transform_export.R and setup_balance.R

  4. Create a pull request!


The existing tests are called in every function and will check if the ledger directory and its files(short ledger, mapping table) actually exist, if they have at least one row and if the column names match.

tilschuenemann/ledger documentation built on March 20, 2022, 8:36 p.m.