Expense Tracker
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Expense Tracker as PDF for free.
More details
- Words: 6,580
- Pages: 32
OVERVIEW
Enter year for calendar:
SALIENT FEATURES 2005
(1900 - 2078)
HOW TO GET STARTED
CHANGE THE YEAR HERE
Help
Annual Financial Report
2006
Help
January
Expense
Savings
0
0
0
February
0
0
0
March
0
0
0
April
0
0
0
May
0
0
0
June
0
0
0
July
0
0
0
August
0
0
0
September
0
0
0
October
0
0
0
November
0
0
0
December
0
0
0
Total
0
0
0
Average
0
0
0
Help
Yearly Summary Balance from Previous Year Savings of the Year
0 0
Balance to Next Year Balance from Jama/Udhar
0
Balance Available
0 How to fill in this?
Help
Jama/Udhar of Previous Year
0
Total
Help
Available Cash
0
Kharcha Paani- Ups and Downs Available Cash
Income, Expense, Savings
Month
Expense
Savings
30000 28000 26000 24000 22000 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 Janu ary
Feb- March ruary
April
May
June
July
Month
A ugu st
Septe Ocmber tober
Nove mber
Dece mber
Kharcha/Pani DashBoard
Help
January 2005 Day Date
S 0
M 0
Week 1 W T 0 0
T 0
F 0
S 1
S 2
M 3
Week 2 W T 5 6
T 4
F 7
S 8
S 9
M 10
Week 3 W T 12 13
T 11
F 14
S 15
S 16
M 17
Week 4 W T 19 20
T 18
F 21
S 22
S 23
M 24
Week 5 W T 26 27
T 25
F 28
S 29
S 30
M 31
Week 6 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Available Cash
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
February 2005 Day Date
S 0
M 0
Week 6 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 7 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 8 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 9 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 10 W T 0 0
T 0
F 0
S 0
S 0
M 0
Week 11 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Available Cash
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
March 2005 Day Date
S 0
M 0
Week 10 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 11 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 12 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 13 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 14 W T 30 31
T 29
F 0
S 0
S 0
M 0
Week 15 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
April 2005 Day Date
S 0
M 0
Week 14 W T 0 0
T 0
F 1
S 2
S 3
M 4
Week 15 W T 6 7
T 5
F 8
S 9
S 10
M 11
Week 16 W T 13 14
T 12
F 15
S 16
S 17
M 18
Week 17 W T 20 21
T 19
F 22
S 23
S 24
M 25
Week 18 W T 27 28
T 26
F 29
S 30
S 0
M 0
Week 19 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
May 2005 Day Date
S 1
M 2
Week 19 W T 4 5
T 3
F 6
S 7
S 8
M 9
Week 20 W T 11 12
T 10
F 13
S 14
S 15
M 16
Week 21 W T 18 19
T 17
F 20
S 21
S 22
M 23
Week 22 W T 25 26
T 24
F 27
S 28
S 29
M 30
Week 23 W T 0 0
T 31
F 0
S 0
S 0
M 0
Week 24 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
June 2005 Day Date
S 0
M 0
Week 23 W T 1 2
T 0
F 3
S 4
S 5
M 6
Week 24 W T 8 9
T 7
F 10
S 11
S 12
M 13
Week 25 W T 15 16
T 14
F 17
S 18
S 19
M 20
Week 26 W T 22 23
T 21
F 24
S 25
S 26
M 27
Week 27 W T 29 30
T 28
F 0
S 0
S 0
M 0
Week 28 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
July 2005 Day Date
S 0
M 0
Week 27 W T 0 0
T 0
F 1
S 2
S 3
M 4
Week 28 W T 6 7
T 5
F 8
S 9
S 10
M 11
Week 29 W T 13 14
T 12
F 15
S 16
S 17
M 18
Week 30 W T 20 21
T 19
F 22
S 23
S 24
M 25
Week 31 W T 27 28
T 26
F 29
S 30
S 31
M 0
Week 32 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
September 2005 Day Date
S 0
M 0
Week 36 W T 0 1
T 0
F 2
S 3
S 4
M 5
Week 37 W T 7 8
T 6
F 9
S 10
S 11
M 12
Week 38 W T 14 15
T 13
F 16
S 17
S 18
M 19
Week 39 W T 21 22
T 20
F 23
S 24
S 25
M 26
Week 40 W T 28 29
T 27
F 30
S 0
S 0
M 0
Week 41 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
August 2005 Day Date
S 0
M 1
Week 32 W T 3 4
T 2
F 5
S 6
S 7
M 8
Week 33 W T 10 11
T 9
F 12
S 13
S 14
M 15
Week 34 W T 17 18
T 16
F 19
S 20
S 21
M 22
Week 35 W T 24 25
T 23
F 26
S 27
S 28
M 29
Week 36 W T 31 0
T 30
F 0
S 0
S 0
M 0
Week 37 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
October 2005 Day Date
S 0
M 0
Week 40 W T 0 0
T 0
F 0
S 1
S 2
M 3
Week 41 W T 5 6
T 4
F 7
S 8
S 9
M 10
Week 42 W T 12 13
T 11
F 14
S 15
S 16
M 17
Week 43 W T 19 20
T 18
F 21
S 22
S 23
M 24
Week 44 W T 26 27
T 25
F 28
S 29
S 30
M 31
Week 45 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
November 2005 Day Date
S 0
M 0
Week 45 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 46 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 47 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 48 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 49 W T 30 0
T 29
F 0
S 0
S 0
M 0
Week 50 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
December 2005 Day Date
S 0
M 0
Week 49 W T 0 1
T 0
F 2
S 3
S 4
M 5
Week 50 W T 7 8
T 6
F 9
S 10
S 11
M 12
Week 51 W T 14 15
T 13
F 16
S 17
S 18
M 19
Week 52 W T 21 22
T 20
F 23
S 24
S 25
M 26
Week 53 W T 28 29
T 27
F 30
S 31
S 0
M 0
Week 54 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Year for calendar:
2005
Help
CALENDER FOR 2005 JANUARY
FEBRUARY
MARCH
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
0
0
0
0
0
0
1
6
0
0
1
2
3
4
5
10
0
0
1
2
3
4
5
2
2
3
4
5
6
7
8
7
6
7
8
9
10
11
12
11
6
7
8
9
10
11
12
3
9
10
11
12
13
14
15
8
13
14
15
16
17
18
19
12
13
14
15
16
17
18
19
4
16
17
18
19
20
21
22
9
20
21
22
23
24
25
26
13
20
21
22
23
24
25
26
5
23
24
25
26
27
28
29
10
27
28
0
0
0
0
0
14
27
28
29
30
31
0
0
6
30
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
APRIL
MAY
JUNE
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
15
0
0
0
0
0
1
2
19
1
2
3
4
5
6
7
23
0
0
0
1
2
3
4
16
3
4
5
6
7
8
9
20
8
9
10
11
12
13
14
24
5
6
7
8
9
10
11
17
10
11
12
13
14
15
16
21
15
16
17
18
19
20
21
25
12
13
14
15
16
17
18
18
17
18
19
20
21
22
23
22
22
23
24
25
26
27
28
26
19
20
21
22
23
24
25
19
24
25
26
27
28
29
30
23
29
30
31
0
0
0
0
27
26
27
28
29
30
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
JULY
AUGUST
SEPTEMBER
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
28
0
0
0
0
0
1
2
33
0
1
2
3
4
5
6
37
0
0
0
0
1
2
3
29
3
4
5
6
7
8
9
34
7
8
9
10
11
12
13
38
4
5
6
7
8
9
10
30
10
11
12
13
14
15
16
35
14
15
16
17
18
19
20
39
11
12
13
14
15
16
17
31
17
18
19
20
21
22
23
36
21
22
23
24
25
26
27
40
18
19
20
21
22
23
24
32
24
25
26
27
28
29
30
37
28
29
30
31
0
0
0
41
25
26
27
28
29
30
0
33
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
OCTOBER
NOVEMBER
DECEMBER
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
42
0
0
0
0
0
0
1
47
0
0
1
2
3
4
5
51
0
0
0
0
1
2
3
43
2
3
4
5
6
7
8
48
6
7
8
9
10
11
12
52
4
5
6
7
8
9
10
44
9
10
11
12
13
14
15
49
13
14
15
16
17
18
19
53
11
12
13
14
15
16
17
45
16
17
18
19
20
21
22
50
20
21
22
23
24
25
26
54
18
19
20
21
22
23
24
46
23
24
25
26
27
28
29
51
27
28
29
30
0
0
0
55
25
26
27
28
29
30
31
47
30
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5
1 2
1 2 3
1 2
1 2 3 4 5
1 2
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8
1 2 3 4
1 2 3 4
Overview This excel aims at giving the user the complete view of his finances and help him to manage his daily personal expenses in a b also helps the user to keep track of his monetary transactions with his friends(Jama/Udhar). All you need to do is to fill in your daily personal expense/income and the information about your monetary transactions with yo savings, monthly and yearly summaries and the graphs will be automatically generated. Summary 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 used. 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 sheet The user should then save this file (with the file name e.g. Expenses_2003) as each file corresponds to the expenses of one ca Summary Page Annual Financial Report This 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 Downs Summary Page
Kharcha Pani- Ups and Downs Kharcha 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 advised to chang Summary Page
Yearly Summary The 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 automatically pop The 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, current year Summary Page
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 carried over to the cu The 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 type of expen The 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 subsequent
Jama/Udhar DashBoard This 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) respectively. The 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 amount as positive If the user gives some udhar money to his friend (basically money gone for now ), he should enter the amount as negative. The 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 subsequent months The entity name description entered in one month automatically gets populated in the corresponding cells of the subsequent m
Monthly Summary The 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' balance, cur
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' sheet. The calendar gets dynamically changed according to the Year entered. Auto count of the aggregate number of weeks of the year. Calendar
and type of of the graph as per his needs.
m the corresponding monthly sheets.
and his Jama/Udhar transactions.
h's savings and his till date Jama/Udhar transactions.
Enter year for calendar:
SALIENT FEATURES 2005
(1900 - 2078)
HOW TO GET STARTED
CHANGE THE YEAR HERE
Help
Annual Financial Report
2006
Help
January
Expense
Savings
0
0
0
February
0
0
0
March
0
0
0
April
0
0
0
May
0
0
0
June
0
0
0
July
0
0
0
August
0
0
0
September
0
0
0
October
0
0
0
November
0
0
0
December
0
0
0
Total
0
0
0
Average
0
0
0
Help
Yearly Summary Balance from Previous Year Savings of the Year
0 0
Balance to Next Year Balance from Jama/Udhar
0
Balance Available
0 How to fill in this?
Help
Jama/Udhar of Previous Year
0
Total
Help
Available Cash
0
Kharcha Paani- Ups and Downs Available Cash
Income, Expense, Savings
Month
Expense
Savings
30000 28000 26000 24000 22000 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 Janu ary
Feb- March ruary
April
May
June
July
Month
A ugu st
Septe Ocmber tober
Nove mber
Dece mber
Kharcha/Pani DashBoard
Help
January 2005 Day Date
S 0
M 0
Week 1 W T 0 0
T 0
F 0
S 1
S 2
M 3
Week 2 W T 5 6
T 4
F 7
S 8
S 9
M 10
Week 3 W T 12 13
T 11
F 14
S 15
S 16
M 17
Week 4 W T 19 20
T 18
F 21
S 22
S 23
M 24
Week 5 W T 26 27
T 25
F 28
S 29
S 30
M 31
Week 6 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Available Cash
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
February 2005 Day Date
S 0
M 0
Week 6 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 7 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 8 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 9 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 10 W T 0 0
T 0
F 0
S 0
S 0
M 0
Week 11 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Available Cash
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
March 2005 Day Date
S 0
M 0
Week 10 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 11 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 12 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 13 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 14 W T 30 31
T 29
F 0
S 0
S 0
M 0
Week 15 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
April 2005 Day Date
S 0
M 0
Week 14 W T 0 0
T 0
F 1
S 2
S 3
M 4
Week 15 W T 6 7
T 5
F 8
S 9
S 10
M 11
Week 16 W T 13 14
T 12
F 15
S 16
S 17
M 18
Week 17 W T 20 21
T 19
F 22
S 23
S 24
M 25
Week 18 W T 27 28
T 26
F 29
S 30
S 0
M 0
Week 19 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
May 2005 Day Date
S 1
M 2
Week 19 W T 4 5
T 3
F 6
S 7
S 8
M 9
Week 20 W T 11 12
T 10
F 13
S 14
S 15
M 16
Week 21 W T 18 19
T 17
F 20
S 21
S 22
M 23
Week 22 W T 25 26
T 24
F 27
S 28
S 29
M 30
Week 23 W T 0 0
T 31
F 0
S 0
S 0
M 0
Week 24 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
June 2005 Day Date
S 0
M 0
Week 23 W T 1 2
T 0
F 3
S 4
S 5
M 6
Week 24 W T 8 9
T 7
F 10
S 11
S 12
M 13
Week 25 W T 15 16
T 14
F 17
S 18
S 19
M 20
Week 26 W T 22 23
T 21
F 24
S 25
S 26
M 27
Week 27 W T 29 30
T 28
F 0
S 0
S 0
M 0
Week 28 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
July 2005 Day Date
S 0
M 0
Week 27 W T 0 0
T 0
F 1
S 2
S 3
M 4
Week 28 W T 6 7
T 5
F 8
S 9
S 10
M 11
Week 29 W T 13 14
T 12
F 15
S 16
S 17
M 18
Week 30 W T 20 21
T 19
F 22
S 23
S 24
M 25
Week 31 W T 27 28
T 26
F 29
S 30
S 31
M 0
Week 32 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
September 2005 Day Date
S 0
M 0
Week 36 W T 0 1
T 0
F 2
S 3
S 4
M 5
Week 37 W T 7 8
T 6
F 9
S 10
S 11
M 12
Week 38 W T 14 15
T 13
F 16
S 17
S 18
M 19
Week 39 W T 21 22
T 20
F 23
S 24
S 25
M 26
Week 40 W T 28 29
T 27
F 30
S 0
S 0
M 0
Week 41 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
August 2005 Day Date
S 0
M 1
Week 32 W T 3 4
T 2
F 5
S 6
S 7
M 8
Week 33 W T 10 11
T 9
F 12
S 13
S 14
M 15
Week 34 W T 17 18
T 16
F 19
S 20
S 21
M 22
Week 35 W T 24 25
T 23
F 26
S 27
S 28
M 29
Week 36 W T 31 0
T 30
F 0
S 0
S 0
M 0
Week 37 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
October 2005 Day Date
S 0
M 0
Week 40 W T 0 0
T 0
F 0
S 1
S 2
M 3
Week 41 W T 5 6
T 4
F 7
S 8
S 9
M 10
Week 42 W T 12 13
T 11
F 14
S 15
S 16
M 17
Week 43 W T 19 20
T 18
F 21
S 22
S 23
M 24
Week 44 W T 26 27
T 25
F 28
S 29
S 30
M 31
Week 45 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
November 2005 Day Date
S 0
M 0
Week 45 W T 2 3
T 1
F 4
S 5
S 6
M 7
Week 46 W T 9 10
T 8
F 11
S 12
S 13
M 14
Week 47 W T 16 17
T 15
F 18
S 19
S 20
M 21
Week 48 W T 23 24
T 22
F 25
S 26
S 27
M 28
Week 49 W T 30 0
T 29
F 0
S 0
S 0
M 0
Week 50 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Kharcha/Pani DashBoard
Help
December 2005 Day Date
S 0
M 0
Week 49 W T 0 1
T 0
F 2
S 3
S 4
M 5
Week 50 W T 7 8
T 6
F 9
S 10
S 11
M 12
Week 51 W T 14 15
T 13
F 16
S 17
S 18
M 19
Week 52 W T 21 22
T 20
F 23
S 24
S 25
M 26
Week 53 W T 28 29
T 27
F 30
S 31
S 0
M 0
Week 54 W T 0 0
T 0
F 0
S 0
On Self Movie Local Commuting / site scenes Rent Travel Books Lunch Dinner Groceries Giving Parties House holds Phone Nasta Gifts/Cards Miscellaneous Courier/Post Juice/Fruits Medicine Clothes Music/Casettes Shoes For Vehicle Petrol Specs Press 0
Total Expenditure Salary/Other Income
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Savings Previous Month
Jama/Udhar DashBoard 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Total
Help
3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Monthly Summary Balance from Previous Month Savings of the month Balance to Next Month Balance from Jama/Udhar Balance Available
0 Help
0 0 0 0 0
Tip: If you received the amount from someone, enter that amount as positive value and viceversa
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
% in Total Expense
Total 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Year for calendar:
2005
Help
CALENDER FOR 2005 JANUARY
FEBRUARY
MARCH
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
0
0
0
0
0
0
1
6
0
0
1
2
3
4
5
10
0
0
1
2
3
4
5
2
2
3
4
5
6
7
8
7
6
7
8
9
10
11
12
11
6
7
8
9
10
11
12
3
9
10
11
12
13
14
15
8
13
14
15
16
17
18
19
12
13
14
15
16
17
18
19
4
16
17
18
19
20
21
22
9
20
21
22
23
24
25
26
13
20
21
22
23
24
25
26
5
23
24
25
26
27
28
29
10
27
28
0
0
0
0
0
14
27
28
29
30
31
0
0
6
30
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
APRIL
MAY
JUNE
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
15
0
0
0
0
0
1
2
19
1
2
3
4
5
6
7
23
0
0
0
1
2
3
4
16
3
4
5
6
7
8
9
20
8
9
10
11
12
13
14
24
5
6
7
8
9
10
11
17
10
11
12
13
14
15
16
21
15
16
17
18
19
20
21
25
12
13
14
15
16
17
18
18
17
18
19
20
21
22
23
22
22
23
24
25
26
27
28
26
19
20
21
22
23
24
25
19
24
25
26
27
28
29
30
23
29
30
31
0
0
0
0
27
26
27
28
29
30
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
JULY
AUGUST
SEPTEMBER
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
28
0
0
0
0
0
1
2
33
0
1
2
3
4
5
6
37
0
0
0
0
1
2
3
29
3
4
5
6
7
8
9
34
7
8
9
10
11
12
13
38
4
5
6
7
8
9
10
30
10
11
12
13
14
15
16
35
14
15
16
17
18
19
20
39
11
12
13
14
15
16
17
31
17
18
19
20
21
22
23
36
21
22
23
24
25
26
27
40
18
19
20
21
22
23
24
32
24
25
26
27
28
29
30
37
28
29
30
31
0
0
0
41
25
26
27
28
29
30
0
33
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
OCTOBER
NOVEMBER
DECEMBER
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
WK SUN MON TUE WED THU FRI SAT
42
0
0
0
0
0
0
1
47
0
0
1
2
3
4
5
51
0
0
0
0
1
2
3
43
2
3
4
5
6
7
8
48
6
7
8
9
10
11
12
52
4
5
6
7
8
9
10
44
9
10
11
12
13
14
15
49
13
14
15
16
17
18
19
53
11
12
13
14
15
16
17
45
16
17
18
19
20
21
22
50
20
21
22
23
24
25
26
54
18
19
20
21
22
23
24
46
23
24
25
26
27
28
29
51
27
28
29
30
0
0
0
55
25
26
27
28
29
30
31
47
30
31
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5
1 2
1 2 3
1 2
1 2 3 4 5
1 2
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8
1 2 3 4
1 2 3 4
Overview This excel aims at giving the user the complete view of his finances and help him to manage his daily personal expenses in a b also helps the user to keep track of his monetary transactions with his friends(Jama/Udhar). All you need to do is to fill in your daily personal expense/income and the information about your monetary transactions with yo savings, monthly and yearly summaries and the graphs will be automatically generated. Summary 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 used. 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 sheet The user should then save this file (with the file name e.g. Expenses_2003) as each file corresponds to the expenses of one ca Summary Page Annual Financial Report This 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 Downs Summary Page
Kharcha Pani- Ups and Downs Kharcha 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 advised to chang Summary Page
Yearly Summary The 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 automatically pop The 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, current year Summary Page
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 carried over to the cu The 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 type of expen The 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 subsequent
Jama/Udhar DashBoard This 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) respectively. The 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 amount as positive If the user gives some udhar money to his friend (basically money gone for now ), he should enter the amount as negative. The 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 subsequent months The entity name description entered in one month automatically gets populated in the corresponding cells of the subsequent m
Monthly Summary The 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' balance, cur
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' sheet. The calendar gets dynamically changed according to the Year entered. Auto count of the aggregate number of weeks of the year. Calendar
and type of of the graph as per his needs.
m the corresponding monthly sheets.
and his Jama/Udhar transactions.
h's savings and his till date Jama/Udhar transactions.
Related Documents
Expense Tracker
November 2019 19
Tracker
April 2020 30
Travel Expense
April 2020 24
Of Expense
June 2020 0
Own Expense
June 2020 5