Expenses tracker web app

🔴 Username: jorge10 🔴

🔑 Password: jorbuepe123 🔑

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

✅ Jupyer notebook - Python

✅ SQL queries

✅ HTML

✅ CSS

⭐ 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:

⭐ Screens:

☑️ 1) Login screen:

☑️ 2) Index screen:

☑️ 3) Data form - Income screen:

☑️ 4) Data form - Outcome screen:

☑️ 5) Analysis screen:

☑️ 6) Graphs screen:

⭐ 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