Managing Personal Finances using Python

Transcript

1. Managing Personal Finances using Python Siddhant Goel  /  @siddhantgoel PyMunich October 2018
2. Let's talk about money.
3. What is my net worth?
4. Where is my money going?
5. How much do I owe others?
6. Started questioning things earlier this year.
7. Spend less Track more
8. Number of solutions = O(∞) Mint.com YNAB Outbank GNUCash ...
9. Proprietary ... mayyyyybe
10. -based ... sorry, that's not happening
11. Requirements Simple No cloud Ideally free Open source Hopefully Python
12. #plaintextaccounting
13. Double Entry Bookkeeping
14. Beancount $ pip install beancount
15. Big Fat Disclaimers ™ I'm not a nancial advisor Aim is to show you the tip of the iceberg Next slide may or may not contain some maths
16. ∑(postings) = 0
19. ; Date format - YYYY-MM-DD option "title" "Mustermann" option "operating_currency" "EUR" 2018-10-01 open Assets:DKB 2018-10-01 open Income:BigCorp 2018-10-01 open Expenses:Food 2018-10-01 open Expenses:Rent ; ... ; ... ; ... 2018-10-25 "*" "Überweisung BigCorp" Assets:DKB 3000.00 EUR Income:BigCorp -3000.00 EUR 2018-11-01 "*" "Miete" Assets:DKB -1500.00 EUR Expenses:Rent 1500.00 EUR 2018-11-02 "*" "Essen" Assets:DKB -50.00 EUR Expenses:Food 50.00 EUR 2018-10-26 balance Assets:DKB 3000.00 EUR 2018-11-03 balance Expenses:Food 50.00 EUR
20. How to get started?
21. Work ow     
22. Beancount does not understand your CSV les? Write an importer.
23. Sample Importer from beancount.core.amount import Amount from beancount.core.number import Number from beancount.ingest.importer import ImporterProtocol class SampleImporter(ImporterProtocol): # ... def identify(self, file_): """Check if file_ is from the bank we're supposed to work with """ # ... def extract(self, file_): """Read file_, and emit a list of beancount data structures """
24. Fava: web UI for Beancount $ pip install fava
27. Bean SQL SELECT month, SUM(position) FROM year = 2017 WHERE account ~ 'Expenses:Supermarket' GROUP BY month
28. What's next? Envelope Budgeting Automating Downloads
29. Resources https://plaintextaccounting.org https://www.reddit.com/r/plaintextaccounting https://aumayr.github.io/beancount-docs-static/ https://beancount.github.io/fava/ Slides https://bit.ly/sg-pymunich-2018
30. Thank you for your time!  bit.ly/sg-pymunich-2018  /  @siddhantgoel  sgoel.org