alpar-t / elk-save-money

Use an ELK stack to analyse finances and save some money

elk-save-money

Use an ELK stack to analyse finances and save some money

Usage

Minor adjustments will likely be needed to the sample_preapre_input.sh script to match your statements.

# first time only 
./build.sh

# Then use the wrapper scripts
./start.sh
./stop.sh

# push statement into the stack
./sample_prepare_input.sh <<Path to XLS>>

# When doing changes to the logstash config 
./start --develop

How it works ?

Brings up an ELK stack in docker.

Logstash is configured with a tcp input and a csv filter to be able to ingest credit card statements in CSV format.

A series of other filters are applied to process the data:

• date to set the correct date.
• grok to get a category.

The processed credit card statement finds it's way into elastic search. Kibana generates nice visuals and let's you search explore your statement.

The nice visuals help you understand spending and spend less.

Security

The elastic search data is stored in a docker volume. You can see where this is actually stored on disk after the container is created with :

docker inspect elk-save-money | jq '.[0].Mounts'

The provided start and stop wrapper scripts export the data into finances.tar.gz and then remove all data from docker. A future version of the wrappers will also offer encryption.