Money Tracker

Python reads csv files downloaded from sparebanken møre, and adds them to a mysql database.

Frontend written in javascript Backend running ? Data stored in Mysql

CSV reader written i python

---

• Add updates via CSV files from bank

• Page for adding receipts

• API for adding receipts (images and money spent)

---

• Accounts

  • Functions:

    • Add
    • Delete
    • Alter
    • Active

  • Data:

    • Account ID - Primary Key
    • Account number - text
    • Account name - text
    • Account description - text

• Stores

  • Functions:

    • Add
    • Delete
    • Alter
    • Active

  • Data:

    • Store ID - Primary Key
    • Store name - text/varchar

• Receipts Functions: - Add - Delete - Alter - Active

  Data: - Receipt ID - Primary key - Receipt Date -

• Transactions Functions: - Add - Delete - Alter - Active

  Data: - Transaction ID - Primary Key - Account ID - FK -