/ta

Bank Transaction Analyser

Primary LanguagePHP

ta: Bank Transaction Analyser

Currently only works for FNB csv files

Installation:

  1. PHP setup sudo apt-get install sqlite3 libsqlite3-dev sudo apt-get install php5-sqlite

  2. cd ~/somewhere

  3. git clone git@github.com:rishadomar/ta.git

  4. cd ta

  5. md reports

  6. cp example_categories.list categories.list

  7. sqlite3 ta.db CREATE TABLE trans ( ID INTEGER PRIMARY KEY, trdate, description, amount, category , status, comment);

  8. download your csv into some folder For FNB this is the route on their website:

  • My Bank Accounts

  • Select Account

  • Click on Available balance

  • Orange Menu + Search

  • Custom

  • Download in csv format

Then extract the csv file into a folder

  1. Import your csv file. Duplicates are ignored ./ta import downloads/2014-01-23.csv

  2. Generate a report ./ta report jan2014 >reports/jan2014.txt vim reports/jan2014.txt