src | ||
.gitignore | ||
LICENSE | ||
Pipfile | ||
Pipfile.lock | ||
README.md | ||
toldg.py |
ledgerai
Script to transform CSV data into ledger accounting files.
Usage
Run pipenv install -dev
to install all packages.
Run pipenv shell
to get venv shell.
Run pipenv install <package>
to install a package.
Architecture
The script takes a directory in which it recursively searches for CSV and LDG files. From these files, it generates a single ledger accounting file that includes all transactions.
Ledger files are appended to the output file without modifications.
However, the transaction for the CSV files are extended with their account2 information, i.e, the category of the transaction. Optionally, these transactions can also get a more meaningful description and tags.
The mapping information are stored in a file mappings.json
. It maps a unique
identifier for each transaction (based on the filename and full CSV row) to a
respective account2.