Friday, 18 October 2013

Expense tool for daily and monthly usage analysis in Excel


Enter your daily expenses in "Expense" sheet and analyse through both "Expense" and "Graphs" sheets.

Features in Sheet “Expense”:

Below are the things that you can do on Expense sheet…….

Categories:
I have included below categories and also left few cells blank so you can fill them with your requirements.
Bill Payments
House maintenance
Mobile bill
Net bill
DTH bill(cable bill)
Water bill
Electricity
Milk
Loans / Liabilities
Home loan
NSC bond loan
LIC


Food / Entertainment
Shopping
Daily Snacks/Tea
Vegetables/Fruits
Medical
Fuel/Travel
Miscellaneous

Features:
·         You can mention your monthly income and other income also
·         And you can check your remaining balance instantly
Month salary
26000.00
Other income

Remaining Month Balance after expenses
767.00

·         you can check individual category total
Expense Details
Individual Total
Bill Payments
2770
House maintenance
800
Mobile bill
0
Net bill
500
·         You can check the day wise total


Features In sheet “Graphs”:

This sheet will analyze your expenses in graphical way based on the inputs you have given in sheet “Expense”

This is analyzed in two ways






Download Expense tool from below link:
https://docs.google.com/file/d/0B9koxHF-9Xjia3B6ZUZnN0lPZHc/edit?usp=sharing

1 comment:

  1. Book our a <a href=" http://topcabs.in/services/outstation-cabs/”> outstation cabs in Hyderabad</a> to cover nearest places within Telangana & other nearby states.

    ReplyDelete