Skip to content

First Solo Project using Python, Flask and PostgreSQL. It is a web application that allows users to input transactions linked to a date, merchant and category. These transactions can be saved, updated and deleted from the database. The User can also manipulate the transactions to see then based on criteria such as month, user, category and merch…

Notifications You must be signed in to change notification settings

linseycurrie/Spending-Tracker

Repository files navigation

Spending-Tracker

First CodeClan individual project creating in 7 days using Python, Flask, HTML/CSS PostgreSQL and the psycopg.

Brief:

Spending Tracker

Build an app that allows a user to track their spending.

MVP

  • The app should allow the user to create and edit merchants, e.g. Tesco, Amazon, ScotRail
  • The app should allow the user to create and edit tags for their spending, e.g. groceries, entertainment, transport
  • The user should be able to assign tags and merchants to a transaction, as well as an amount spent on each transaction.
  • The app should display all the transactions a user has made in a single view, with each transaction's amount, merchant and tag, and a total for all transactions.

Inspired by:

Monzo, MoneyDashboard, lots of mobile/online banking apps

Possible Extensions

  • The user should be able to mark Merchants and Tags as deactivated. Users will not be able to choose deactivated merchants/tags when creating a transaction.
  • Transactions should have a timestamp, and the user should be able to view transactions sorted by the time they took place.
  • The user should be able to supply a budget, and the app should alert the user somehow when when they are nearing this budget or have gone over it.
  • The user should be able to filter their view of transactions, for example, to view all transactions in a given month, or view all spending on groceries.

#Running Instructions for opening the App using Terminal

To Clone, git clone https://github.com/linseycurrie/Project1--Spending-Tracker.git

Create Database and open file,

  • createdb money_tracker
  • psql -d money_tracker -f money_tracker.sql

To run file,

  • python3 console.py

Open app,

  • flask run

About

First Solo Project using Python, Flask and PostgreSQL. It is a web application that allows users to input transactions linked to a date, merchant and category. These transactions can be saved, updated and deleted from the database. The User can also manipulate the transactions to see then based on criteria such as month, user, category and merch…

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published