Personal Finance Management System

• 

  Thumbnail

• 

  Main Window

• 

  New Entry Function

• 

  Check Function

• 

  Data Fetch

• 

  instant statement

• 

  excel statement

Inspiration

I am currently pursuing degree in college, and living in hostel. In that situation I used my diary to enter and write the data of all purchases and payment details, then I think an idea to develop application according to personal finance management system.

What it does

Through this program we can enter our data, what we have purchased (ex: shoe : 700 Rs) with data wise, if we doesn't mention date means also no problem, it automatically consider today date, after entering the data it is stored in customized excel file and saved. Through this program we can derive data from database(Oracle) and it displayed in the tree view format for that deriving data we need to mention from when to which date on given entry(example date in this format only everywhere 01 02 23). Only one important thing was there this program will work when the oracle workspace name is database and the password is user123, otherwise it will show error. data was not entered in database. and we need to create table in oracle named as data2 it must contains 3 columns for first column product date and 2nd product name and 3rd product price all in varchar format this is command to create data2 "create table data2 (pdate varchar(200),pname varchar(200), pprice varchar(200)); .

How we built it

Frontend: Tkinter (python) Backend: Cx_oracle, pandas, os, openpyxl(for handle excel file)

Challenges we ran into

I faced a challenge to fetch the data from this date to this date, for that I build my own logic to store all dates from starting to end in list format to check the list values matches with the datas date stored in oracle or not if it is stored means it derive, for that we created a logic to store dates in list. Problem in logic I faced In year there is two type Leap year, and Non Leap year for leap year we have 365 days , according to that I made logic.

Accomplishments that we're proud of

Yeah I didn't believe that I do this project, but the result is amazing. For this opportunity, I am thanking to HackThePlan Hackathon and my friends.

What we learned

I learned Cx_oracle and openpyxl extra in this hackathon.

What's next for Personal Finance Management System

There is some thigs were remaing to do ex: alert window for registered data like that I didn't did.

Built With

• cx-oracle
• openpyxl
• python
• tkinter