/Expenses_tracker

Web app project with python and SQL

Primary LanguageHTML

Expenses tracker web app

License: MIT

🔴 Username: jorge10 🔴

🔑 Password: jorbuepe123 🔑

Deploy

Here you can find my first web app project.

📍 Front-end: HTML, CSS and JavaScript

📍 Back-end: Python (numpy, pandas 🐼 and matplotlib)

📍 Framework: Flask

📍 Database: SQLite3

⭐ Main functionalities:

The Expenses tracker web app could give the user a web tool to login with one username and password, in order to introduce the outcomes and incomes. Once the data is introduced, the user would be able to analyse it, so as to check how the money was spent, the current balance, but also plot the data in a graph.

⭐ Database structure:

alt text

⭐ Screens:

☑️ 1) Login screen:

alt text

☑️ 2) Index screen:

alt text

☑️ 3) Data form - Income screen:

alt text

☑️ 4) Data form - Outcome screen:

alt text

☑️ 5) Analysis screen:

alt text

☑️ 6) Graphs screen:

alt text

⭐ User manual:

An email should be sent to the administrator: admin@gmailp.com for the creation of a new user, category, vendor or sender. Also, to create new analysis variables, graphs or amend any data introduced, because the user will not be able to do it for himself. Additionally, the same email should be sent in case the user forgets the password.

You will be able to login with the username and password that the administrator gave you after the registration. Once you introduced the username and password, the button submit should be pressed.

In the main page you will be able to access to the main content, in the left side you will find a menu and in the main page you will find some important information, which should be read carefully.

🌟 Please find further information about the navigation through the menu below:

  • Main page: You will be able to return back to the main page.
  • Income: You will be able to introduce incomes data by several fields, also the username should be selected, please select your correct username before introducing the data. Once you introduced the incomes data, the button submit should be pressed.
  • Outcome: You will be able to introduce incomes data by several fields, also the username should be selected, please select your correct username before introducing the data. Once you introduced the outcomes data, the button submit should be pressed.
  • Analysis: You will be able to analyse the data introduced by several variables. This functionality at the moment is only available for the user: jorge10, we are working to build it as soon as possible for the rest of the users.
  • Graphs: You will be able to plot a graph of the data introduced. This functionality at the moment is only available for the user: jorge10 and only for one graph, we are working to develop these functions as soon as possible.
  • Logout: You should press this once you finish your session, you will be redirected to the login page.

✉️ In case of any question or suggestion, kindly contact the administrator: admin@gmailp.com