Skip to content

Latest commit

 

History

History
75 lines (57 loc) · 1.8 KB

README.md

File metadata and controls

75 lines (57 loc) · 1.8 KB
Raw

Finance Aggregator

Aggregates financial CSVs from multiple sources into a single transaction record.

Supports simple preprocessing and postprocessing steps such as:

  • Adding missing headers
  • Combining in/out columns to a single column with positive and negative values
  • Negating transaction amounts (i.e. for credit cards)
  • Filtering by date range
  • Removing records matching a list of names
  • Adding categories based on transaction description
  • Prefilling notes based on transaction description

Each source is configured in a config.json file. See config_example/config_example.json for an example.

Usage

finance-aggregator --config ./config_example/config_example.json --output ./output.csv

# Output
Loading Some Bank...
	Preprocessing with AddMissingHeader...
	Preprocessing with CombineInOutColumns...
	Postprocessing with FilterByDate...
	Postprocessing with FilterByName...
	Postprocessing with WithCategories...


	Postprocessing with WithNotes...


Saved to /.../output.csv

Example CSV

Input

01-Jan-2023,AMAZON,,50
02-Jan-2023,UBERTRIP,,15
04-Jan-2023,IKEA,,269.72
20-Jan-2023,INTERAC e-Transfer From Human,200,
07-Feb-2023,spotify,,11.59

Output

date,name,amount,source,category,notes
2023-01-01,AMAZON,-50.0,Some Bank,amazon,What did you buy? Pick a better category. 
2023-01-02,UBERTRIP,-15.0,Some Bank,transportation,
2023-01-04,IKEA,-269.72,Some Bank,furniture,
2023-01-20,INTERAC e-Transfer From Human,200.0,Some Bank,deposit,

Configuration

Option Description
--config Path to config file
--work-dir Path to working directory
--output Path to output file

Environment Setup

# Ubuntu
sudo apt install python3-venv

pip3 install virtualenv
python3 -m venv venv
source venv/bin/activate
pip install -r requirements.txt

pip install -e .