Expense Analysis System.

Expense Analysis System:

Video:

This has 3 functionalities:

1.      Upload  data:

·      Data should be uploaded in CVS format.

·      Must have Six Columns as below.

	Column Heading	Type	Description
1	Value Date	Date	Date
2	Transaction Date	Date	Consider for Analysis
3	Transaction Remarks	Character	Without any comma punctuation mark
4	Withdrawal Amount	Number/Double	Without any comma punctuation mark
5	Deposit Amount	Number/Double	Without any comma punctuation mark
6	Balance	Number/Double	Without any comma punctuation mark

·      Heading rows is must

·      Date column can be either ‘DD-MM-YYYY’ or ‘DD/MM/YYYY’ format.

·      Sample Screenshots opened in excel and actual text format is below:

Figure 1: Sample Screenshot in excel

Figure 2 Actual data in text format file

Once uploaded a response page with uploaded will be displayed.

Figure 3: File Upload Response Screen

2.      Edit and delete data:

·      Once you upload the data a default category is assigned to each row and default category is “MISC”.

·      This can be edited or row can be deleted in the edit screen.

·      By querying data giving date range edit screen is displayed.

Figure 4 Query with date range

·      Once queried edit screen is displayed with data for editing and deleting.

·      Here the category can be changed
Figure 5 Edit Data Screen for editing and deleing rows

Figure 6 After changing category

·      After Submitting a response screen with number of updates and deletes will be displayed.

Figure 7: Edit Response Screen

3.      Analysis:

·      Select date range from Home page and submit.

·      Once submitted “ Analysis Screen” is displayed with details.

Figure 8 Analysis Result

Database Table Structures:

Included in Document  folder of code.

Code is available is https://github.com/gokulakrishnana/expenseanalysis