Download - Manage Money
-
7/28/2019 Manage Money
1/32
Help
118609118609
118609
How to fill in this? Help
3806.375 14826.125Average 18633
Savings of the Year
Balance to Next Year
Total
Jama/Udhar of Previous Year
November
December
30451 118609149060
Balance from Jama/Udhar Balance Available
Yearly Summary
Balance from Previous Year
Total
-
7/28/2019 Manage Money
2/32
Help
S M T W T F S S M T W T1 2 3 4 5 6 7 8 9 10 11 12
Press0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoardPreviousMonth Help Tip: If you received the amount from someone, enter that amount as positive value
0 0
0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 0Savings of the month 0Balance to Next Month 0Balance from Jama/Udhar 0Balance Available 0
LunchDinner
Courier/Post
Total Expenditure
Petrol
Juice/Fruits
House holdsPhone
Kharcha/Pani DashBoard
Monthly Summary
MovieLocal Commuting/ Auto / site scenesRentTravel (To other city)Books
Date
GroceriesGiving Parties
Salary/Other Income
MedicineClothes/shoes
Gifts/CardsMiscellaneous
1 Week 2
Icecream
Nasta
January 2012
On Self
DayWeek
-
7/28/2019 Manage Money
3/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%00 0.00%
00000000000000
00000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
4/32
-
7/28/2019 Manage Money
5/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
0000000000000000000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
6/32
Help
S M T W T F S S M T W T0 0 0 0 1 2 3 4 5 6 7 8
0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoardrev ous
Month Help Tip: If you received the amount from someone, enter that amount as positive value0 00 00 00 00 00 00 00 00 00 00 00 00 0
0 00 00 00 00 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 0Savings of the month 0Balance to Next Month 0Balance from Jama/Udhar 0Balance Available 0
#REF!IcecreamPetrol
#REF!
Monthly Summary
Press
Total ExpenditureSalary/Other Income
MiscellaneousCourier/PostJuice/FruitsMedicineClothes/shoes
#REF!
GroceriesGiving PartiesHouse holdsPhoneNastaGifts/Cards
Local Commuting/ Auto / site scenesRentTravel (To other city)BooksLunchDinner
On Self
Week 9 Week 10
Movie
Kharcha/Pani DashBoard
March 2012DayDate
-
7/28/2019 Manage Money
7/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
0000000000000000000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
8/32
Kharcha/Pani DashBoard Help
S M T W T F S S M T W T1 2 3 4 5 6 7 8 9 10 11 12
0 0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoard rev ousMonth Help Tip: If you received the amount from someone, enter that amount as positive value a0 00 00 00 00 00 00 00 00 00 00 00 00 0
0 00 00 00 00 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 0Savings of the month 0Balance to Next Month 0Balance from Jama/Udhar 0Balance Available 0
Week 14 Week 15
MovieLocal Commuting/ Auto / site scenesRentTravel (To other city)
April 2012DayDate
On Self
Giving PartiesHouse holdsPhoneNasta
BooksLunchDinner Groceries
MedicineClothes/shoes
#REF!#REF!
Gifts/CardsMiscellaneousCourier/PostJuice/Fruits
Total ExpenditureSalary/Other Income
Monthly Summary
IcecreamPetrol
#REF!Press
-
7/28/2019 Manage Money
9/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
0000000000000000000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
10/32
Help
S M T W T F S S M T W T0 0 1 2 3 4 5 6 7 8 9 10
0 0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoard rev ousMonth Help Tip: If you received the amount from someone, enter that amount as positive value a0 00 00 00 00 00 00 00 00 00 00 00 00 0
0 00 00 00 00 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 0Savings of the month 0Balance to Next Month 0Balance from Jama/Udhar 0Balance Available 0
Week 18 Week 19
On Self MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
May 2012DayDate
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
Juice/FruitsMedicineClothes/shoes
#REF!
NastaGifts/CardsMiscellaneousCourier/Post
Press
Total ExpenditureSalary/Other Income
Monthly Summary
#REF!IcecreamPetrol
#REF!
-
7/28/2019 Manage Money
11/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
0000000000000000000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
12/32
Help
S M T W T F S S M T W T0 0 0 0 0 1 2 3 4 5 6 7
0 0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoard rev ousMonth Help Tip: If you received the amount from someone, enter that amount as positive value a0 00 00 00 00 00 00 00 00 00 00 00 00 0
0 00 00 00 00 0
Total 0 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 0Savings of the month 0Balance to Next Month 0Balance from Jama/Udhar 0Balance Available 0
22 Week 23
MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
June 2012DayDate
Week
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
On Self
Juice/FruitsMedicineClothes/shoes
#REF!
NastaGifts/CardsMiscellaneousCourier/Post
Press
Total ExpenditureSalary/Other Income
Monthly Summary
#REF!IcecreamPetrol
#REF!
-
7/28/2019 Manage Money
13/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
0000000000000000000
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
14/32
Help
S M T W T F S S M T W T1 2 3 4 5 6 7 8 9 10 11 12
23540 105 15 100
8100
220 45 35 220 90
3000 708
1070 300
616
599 25030 17
50 50
869 686 115 0 617 3000 270 325 8110 15 90 7190 7####
Jama/Udhar DashBoardrev ous
Month Help Tip: If you received the amount from someone, enter that amount as positive valueAmir Khan 130 -129 77 -95 329 100 284 170 -29 -166 -410Sreekumar 0 60 70 54 205 15Bishwadeep 0 70 -17 15 -13Deepak 0 150Pranav 0 70Vivek 70 -80Shubhanker -525 70 150Avishek 0 150
00 0
Mona 5500 00 00 00 00 00 00 0
Total 0 -69 427 0 -95 366 550 489 120 -42 -166 -410 0 -
HelpBalance from Previous Month 0Savings of the month 5121Balance to Next Month 5121Balance from Jama/Udhar 2012Balance Available 7133
Local Commuting/ Auto / site scenesRent
GroceriesGiving Parties
Week 27 Week 28
Travel (To other city)BooksLunchDinner
July 2012
Kharcha/Pani DashBoard
DayDate
On Self Movie
NashtaGifts/CardsMiscellaneousCourier/Post
House holdsPhone
Monthly Summary
Press
Total ExpenditureSalary/Other Income
Petrol
Juice/FruitsMedicineClothes/shoesIcecream
-
7/28/2019 Manage Money
15/32
2685 10.35%708 2.73%345 1.33%
8100 31.23%0 0.00%0 0.00%
155 0.60%1377 5.31%
0 0.00%10080 38.86%
0 0.00%0 0.00%
94 0.36%530 2.04%784 3.02%
0 0.00% A C D J0 0.00% 500 648 200 548 1896
15 0.06% 26 174 -274 74 474849 3.27%
67 0.26%150 0.58%
0 0.00%25939 100.00%31060
5121 16.49%
1189 8100 for rent;by amir next month304133
8670
-10-305150
00
5500000000
2012
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
16/32
Help
S M T W T F S S M T W 0 0 0 1 2 3 4 5 6 7 8 9
20 20 100
54
100 10
0 0 0 20 0 0 120 154 0 10 0 118000
Jama/Udhar DashBoardrev ous
Month Help Tip: If you received the amount from someone, enter that amount as positive value Amir Khan 1189 100 -30 37 -7Sreekumar 304Bishwadeep 133 10 25 -Deepak 86Pranav 70
Shubhanker -305Avishek 150
0 00 0
Mona 5500 00 00 00 00 00 00 0
Total 2012 0 0 0 100 0 0 0 0 0 -20 62 -85
HelpBalance from Previous Month 5121Savings of the month 116042Balance to Next Month 121163Balance from Jama/Udhar 515Balance Available 121678
Week 31 Week 32
On Self MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
August 2012DayDate
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
Juice/FruitsMedicineClothes/shoesJuice/Fruits
NashtaGifts/CardsMiscellaneousCourier/Post
Press
Total ExpenditureSalary/Other Income
Monthly Summary
MedicineIcecreamPetrolIcecream
-
7/28/2019 Manage Money
17/32
0 0.00%200 10.21%406 20.74%
0 0.00%0 0.00%0 0.00%
144 7.35%355 18.13%
0 0.00%0 0.00%0 0.00%0 0.00%
410 20.94%0 0.00%
200 10.21%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
88 4.49%50 2.55%
105 5.36%0 0.00%
1958 100.00%118000
116042 98.34%
500651.33333 165
-4264
-1470
-305150
00
5500000000
515.33333
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
18/32
Help
S M T W T F S S M T W T0 0 0 0 0 0 1 2 3 4 5 6
0 0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoardPreviousMonth Help Tip: If you received the amount from someone, enter that amount as positive value a
Amir Khan 651.333 -24 2250Sreekumar -426Bishwadeep 4 -250Deepak -14 250Pranav 70
0 0Shubhanker -305Avishek 150
0 00 0
Mona 5500 00 0
0 00 00 00 00 0
Total 515.333 0 0 0 0 0 0 0 -24 0 0 2250 0
HelpBalance from Previous Month 121163Savings of the month -1610Balance to Next Month 119553Balance from Jama/Udhar 3965Balance Available 123518
Week 35 Week 36
Local Commuting/ Auto / site scenes
On Self Movie
Rent
Kharcha/Pani DashBoard
September 2012DayDate
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
Juice/FruitsMedicineClothes/shoesJuice/Fruits
NashtaGifts/CardsMiscellaneousCourier/Post
Monthly Summary
Press
Total ExpenditureSalary/Other Income
MedicineDaaruPetrolIcecream
-
7/28/2019 Manage Money
19/32
698 43.35%0 0.00%
140 8.70%0 0.00%0 0.00%0 0.00%0 0.00%
180 11.18%0 0.00%0 0.00%0 0.00%
100 6.21%
20 1.24%0 0.00%
182 11.30%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
250 15.53%0 0.00%
40 2.48%0 0.00%
1610 100.00%0
-1610 0.00%
3387.33332444
330-50
0-305150
00
5500000000
3965.3333
% in TotalExpense
Total
-
7/28/2019 Manage Money
20/32
Help
S M T W T F S S M T W T0 1 2 3 4 5 6 7 8 9 10 11
20 50 95
85 85 40 95
24 10 10 10
80 71
199
10 60
0 95 24 110 145 0 276 0 294 0 0 0
Jama/Udhar DashBoardPreviousMonth Help Tip: If you received the amount from someone, enter that amount as positive value a
Amir Khan 3387.33 6 25 -310 -10 199Sreekumar 24 130 85 1435Bishwadeep 44Deepak 330Pranav -50
0 0Shubhanker -305Avishek 150
0 00 0
Mona 550 -5500 00 00 00 00 00 00 0
Total 3965.33 0 -550 6 130 85 1460 -310 -10 199 0 0 0 0
HelpBalance from Previous Month 119553Savings of the month -944Balance to Next Month 118609Balance from Jama/Udhar 3319Balance Available 121928
40 Week 41
MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
October 2012DayDate
Week
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
On Self
Juice/FruitsMedicineClothes/shoesJuice/Fruits
NashtaGifts/CardsMiscellaneousCourier/Post
PressTotal ExpenditureSalary/Other Income
Monthly Summary
MedicineDaaruPetrolIcecream
-
7/28/2019 Manage Money
21/32
0 0.00%0 0.00%
165 17.48%0 0.00%0 0.00%0 0.00%
305 32.31%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
54 5.72%0 0.00%
151 16.00%0 0.00%
199 21.08%0 0.00%0 0.00%
70 7.42%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
944 100.00%0
-944 0.00%
2935.3333 742 DONE112 DONE430
-580 DONE0
-305150
00
0000000
3319.3333
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
22/32
Help
S M T W T F S S M T W T0 0 0 0 1 2 3 4 5 6 7 8
0 0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoard rev ousMonth Help Tip: If you received the amount from someone, enter that amount as positive value aAmir Khan 2935.33 200 50 190Sreekumar 742Bishwadeep 112Deepak 430Pranav -580 240Samarth 0 240 -70 -85Shubhanker -305Avishek 150
0 00 0
Mona 0 240 150Snehanshu 0 240 150Anjali 0 240 magic
0 00 00 00 00 0
Total 3319.33 0 0 0 0 0 1400 230 -85 0 0 50 190 -13
HelpBalance from Previous Month 118609Savings of the month 0Balance to Next Month 118609Balance from Jama/Udhar 3459Balance Available 122068
44 Week 45
MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
November 2012DayDate
Week
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
On Self
Juice/FruitsMedicineClothes/shoesJuice/Fruits
NashtaGifts/CardsMiscellaneousCourier/Post
Press
Total ExpenditureSalary/Other Income
Monthly Summary
MedicineDaaruPetrolIcecream
-
7/28/2019 Manage Money
23/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
1730.3333742
430-340
85-305150
00
390390240
00000
3459.3333
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
24/32
Help
S M T W T F S S M T W T0 0 0 0 0 0 1 2 3 4 5 6
0 0 0 0 0 0 0 0 0 0 0
Jama/Udhar DashBoard rev ousMonth Help Tip: If you received the amount from someone, enter that amount as positive valueAmir Khan 1730.33Sreekumar 742Bishwadeep 0Deepak 430Pranav -340Samarth 85Shubhanker -305Avishek 150
0 00 0
Mona 390Snehanshu 390Anjali 240
0 00 00 00 00 0
Total 3459.33 0 0 0 0 0 0 0 0 0 0 0 0
HelpBalance from Previous Month 118609Savings of the month 0Balance to Next Month 118609Balance from Jama/Udhar 3459Balance Available 122068
Week 48 Week 49
On Self MovieLocal Commuting/ Auto / site scenesRent
Kharcha/Pani DashBoard
December 2012DayDate
GroceriesGiving PartiesHouse holdsPhone
Travel (To other city)BooksLunchDinner
Juice/FruitsMedicineClothes/shoesJuice/Fruits
NashtaGifts/CardsMiscellaneousCourier/Post
Press
Total ExpenditureSalary/Other Income
Monthly Summary
MedicineDaaruPetrolIcecream
-
7/28/2019 Manage Money
25/32
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%
0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0 0.00%0
0 0.00%
1730.3333742
0430
-34085
-305150
00
390390240
00000
3459.3333
% inTotal
ExpenseTotal
-
7/28/2019 Manage Money
26/32
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
1 1 2 3 4 5 6 7 5 1 2 3 4 9 1
2 8 9 10 11 12 13 14 6 5 6 7 8 9 10 11 10 4 5 6 7 8 9
3 15 16 17 18 19 20 21 7 12 13 14 15 16 17 18 11 11 12 13 14 15 16
4 22 23 24 25 26 27 28 8 19 20 21 22 23 24 25 12 18 19 20 21 22 23
5 29 30 31 9 26 27 28 29 13 25 26 27 28 29 3
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
14 1 2 3 4 5 6 7 18 1 2 3 4 5 22
15 8 9 10 11 12 13 14 19 6 7 8 9 10 11 12 23 3 4 5 6 7 8
16 15 16 17 18 19 20 21 20 13 14 15 16 17 18 19 24 10 11 12 13 14 15
17 22 23 24 25 26 27 28 21 20 21 22 23 24 25 26 25 17 18 19 20 21 22
18 29 30 22 27 28 29 30 31 26 24 25 26 27 28 29
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
27 1 2 3 4 5 6 7 31 1 2 3 4 35
28 8 9 10 11 12 13 14 32 5 6 7 8 9 10 11 36 2 3 4 5 6
29 15 16 17 18 19 20 21 33 12 13 14 15 16 17 18 37 9 10 11 12 13 1
30 22 23 24 25 26 27 28 34 19 20 21 22 23 24 25 38 16 17 18 19 20 2
31 29 30 31 35 26 27 28 29 30 31 39 23 24 25 26 27 2
40 30
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
40 1 2 3 4 5 6 44 1 2 3 48
41 7 8 9 10 11 12 13 45 4 5 6 7 8 9 10 49 2 3 4 5 6 7
42 14 15 16 17 18 19 20 46 11 12 13 14 15 16 17 50 9 10 11 12 13 14
43 21 22 23 24 25 26 27 47 18 19 20 21 22 23 24 51 16 17 18 19 20 21
44 28 29 30 31 48 25 26 27 28 29 30 52 23 24 25 26 27 28
53 30 31
DECEMBERNOVEMBEROCTOBER
JUNEMAYAPRIL
JULY AUGUST SEPTEMBER
2012CALENDER FOR
JANUARY FEBRUARY MARCH
-
7/28/2019 Manage Money
27/32
123456789
10
12345
12
123
12
12345
-
7/28/2019 Manage Money
28/32
12
123456789
10
12345678
1234
1234
-
7/28/2019 Manage Money
29/32
OverviewThis excel aims at giving the user the complete view of his finances and help him to manage his daily personalexpenses in a better way. This excel also helps the user to keep track of his monetary transactions with hisfriends(Jama/Udhar).
All you need to do is to fill in your daily personal expense/income and the information about your monetarySummary Page
Salient Features Automatic generation of Yearly Summary Report. Automatic creation of line graph depicting the income, expenses and savings in a single view. Automatic generation of Monthly Summary Reports for each month. Automatic alignment of the dates with the days of the week. Auto count of the aggregate number of weeks of the year.Generic calender (for year 1900 to 2078)No use of macros is done in this file. Only the simple and commonly used features and formulas of excel are
All the formulas used are visible to the user and user can modify them to suit his requirements.Small size and so easy to store, copy or carry.If compared to any similar application, here Excel serves the dual purpose of GUI as well as the database.
Summary Page
How to get started?Fill in the Year.Fill in the "Balance from Previous Year" data in the Yearly Summary Section.Fill in the "Jama/Udhar" information of the previous year.Daily fill in your expenses, income and jama/udahar data in the current date of the current month sheet.
And you have the total savings, monthly and yearly summaries and the graphs auto generated for you.Summary Page
Year The user needs to enter the year for which he wants to maintain his expenses in the Summary sheetThe user should then save this file (with the file name e.g. Expenses_2003) as each file corresponds to the expenSummary Page
Annual Financial ReportThis report tabulates the income, expense and savings for each month.The data here gets automatically populated from the corresponding monthly sheets.This data is used to generates the line graph- Kharch Pani - Ups and DownsSummary Page
Kharcha Pani- Ups and DownsKharcha Pani- Ups and Downs is line graph depicting the income, expenses and savings in a single view.This graph can be customised by right clicking the graph and modifying it as per user's comfortability. User is adviSummary Page
Yearly SummaryThe Yearly Summary for the current year is presented to the user.The user needs to manually enter the information about his "Balance from Previous Year".The figures for 'Savings of the Year', 'Balance to Next Year' and 'Balance from Jama/Udhar' information gets autoThe Balance to Next Year does not include the Jama/Udhar information.The 'Balance Available' figure shows the financial health of the user taking into account his previous years' saving,Summary Page
-
7/28/2019 Manage Money
30/32
Jama/Udhar of Previous Year The user should fill in the Jama/Udhar information of the previous years so that his Jama/Udhar data gets carriedThe data filled in will be automatically considered for the January month of the current year.Summary Page
Kharcha/Pani DashBoard
This section is available in the sheet for each of the months.The horizontal and vertical axes are dates and types of expense respectively.The user should fill in the daily EXPENSE data for the correspoding date and type of expense.The user should fill in the INCOME data for the correspoding date for the Income row.The savings will be automatically calculated depending upon the income and expense data.The percentages for each type of expense in the total expense for the month is automatically calculated for each tThe percentage of total incomes getting converted to savings for each month is also automatically calcualted.The total expense for each day and for the each type gets automatically calculated in all the months.Depending upon the year in the Summary sheet, the dates get dynamically aligned to the week days.The expense type description entered in one month automatically gets populated in the corresponding cells of the
Jama/Udhar DashBoardThis section is available in the sheet for each of the months.The horizontal and vertical axes are dates and name of the transacting entity (friends, credit card, project etc) respThe user should fill in the details of his monetary transaction with his friends in the cells for corresponding dates.If the user takes some udhar money from his friend (basically money received for now), he should enter the amouIf the user gives some udhar money to his friend (basically money gone for now ), he should enter the amount as nThe total outstanding amount for each entitiy can be determined from the last cell in the row for that entity.The total outstanding amount for each entitiy automatically gets populated in the corresponding cells of the subseqThe entity name description entered in one month automatically gets populated in the corresponding cells of the su
Monthly SummaryThe monthly summary is provided for the user for each of the months.The user need NOT enter any information manually in this. All the figures are populated automatically.The Balance to Next Month does not include the Jama/Udhar information.The 'Balance Available' figure shows the financial health of the user after taking into account his previous months'
Generic Calendar The generic calendar (from year 1900 to 2078) is provided for the user in the Calendar tabsheet.The user needs to enter the year manually in the Year cell. The default value is the value of Year in the 'Summary'The calendar gets dynamically changed according to the Year entered.
Auto count of the aggregate number of weeks of the year.Calendar
-
7/28/2019 Manage Money
31/32
es of one calendar year only.
ed to change the scale and type of of the graph as per his needs.
atically populated from the corresponding monthly sheets.
current year's savings and his Jama/Udhar transactions.
-
7/28/2019 Manage Money
32/32
ver to the current year.
pe of expense.
ubsequent months.
ectively.
t as positive.egative.
uent months.bsequent months.
balance, current month's savings and his till date Jama/Udhar transactions.
sheet.