PHP/JavaScript webapp to analyse spending habits
Du kannst nicht mehr als 25 Themen auswählen Themen müssen mit entweder einem Buchstaben oder einer Ziffer beginnen. Sie können Bindestriche („-“) enthalten und bis zu 35 Zeichen lang sein.
Chris Smith 6ce20c17a4 Ignore temporary files vor 13 Jahren
externals Add repeated transactions vor 13 Jahren
res Add a header vor 13 Jahren
.gitignore Ignore temporary files vor 13 Jahren
.gitmodules Add repeated transactions vor 13 Jahren
README.md Frontend now only needs one set of data vor 13 Jahren
analyser.js Add support for sporadically repeating transactions vor 13 Jahren
data.php Move rules, categories etc out of main data file vor 13 Jahren
index.html Add support for sporadically repeating transactions vor 13 Jahren

README.md

Overview

This project consists of a PHP backend which can parse CSV files containing bank account transaction information, and a JavaScript front-end which can analyse and display stats about the parsed data.

Data formats

Backend

The backend expects a ‘Statements’ directory containing CSV files with the following fields:

  • Date (dd/mm/yy)
  • Amount
  • Description

Frontend

The JS frontend uses a map containing one entry for each month’s worth of transactions. At present it expects this map to be assigned to a variable called ‘data’. Each month consists of an array of transactions, which are themselves objects containing the following properties:

  • Date - currently a serialisation of a PHP DateTime object, e.g.
    {"date":"2009-01-05 00:00:00","timezone_type":3,"timezone":"UTC"}
  • Amount
  • Description - a user-friendly description of the transaction
  • RawDescription - the raw description from the statement (not used)
  • Category - user-defined category for the transaction (optional)
  • Type - user-defined type for the transaction (optional)

If the category has the special value (Ignored), it is excluded from certain calculates and graphs and showed as greyed out in tables.