Expense
Analysis System:
Video:
Video:
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 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
