AdSense

Tuesday, 21 January 2014

Tool: Daily Expense Tracker in excel - free to use and share

Tool: Daily Expense Tracker in excel - free to use and share How many times it has happened that you wondered where all your money went? Where did you spend all of it? How frequently do you take out cash and spend it even more frequently and immediately.
All you wanted is to know a trend of your spending so that you can plan and if necessary, control it.

There are many sites and phone applications that are available for this but not all are easy to use.
Every application has its own method of usage - some ask you to create and define bank accounts while others just don't seem to be secure. All you really want is is place where you can mention how much you spend and earn and keep a track.

Here is an option for you in our very own EXCEL spreadsheet by BabaGyan.
All you have to do is update the rows with your account transaction - both credit and debit. Also available is a Cash sheet where you should enter your cash transactions. The ATM withdrawal transaction from Account tab is added into Available Cash in your Cash tab. This way, you don't need to worry about Cash Credits at all.

There is also an optional Forecasting tab. Here you should list down all the routine transaction like Rent payment, Fuel expenses, EMI installments, etc. This will help you predict how much you can save at the end of the month. If you need more to save, just spend less - at least try for it.

In short - Update the cells in Orange before starting to use the sheet and daily update the cells in Green.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Expense tracking Month Excel file to download.