This app attempts to implement the double-entry bookkeeping system using a relational data model.
- This is strictly a work in progress. Comments and documentation are incomplete and it's barely a prove of concept.
- I am currently using the (pretty awesesome) YNAB app for keeping track of expenses but once I have enough free time again I am going to continue this project.
Start the MySQL Docker instance
docker run --name jup-finance-database -p 3306:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:8
- Keep the data readable; I want to be able to analyze the SQL tables using simple tools like Excel, so I try to minimize complexity in the database schema.
- No split-entries; It is not possible for one debit to go to multiple credits or vice versa. This limitation can be circumvented by using separate entries on both sides.
- Great Stack Overflow Answer about implementing Double-Entry bookkeeping in relational data models: Link
- https://gist.github.com/NYKevin/9433376