Personal Finance Blog India –

Excel:Best Offline Personal Finance Manager-Part I

There are very less tools which have both ‘simple’ and ‘powerful’ attributes and MS Excel is one of them.We can easily use Excel for personal finance calculations,store and track the data.As this is offline tool we ┬áneed to do / update few things manually.

This is a Part-I post on Excel as it is difficult to incorporate all the uses in single post.

Record Of Fixed Deposits:

We can FD record of different banks with calculation like principal,todays value and maturity value.

Similar to this we can create for other instruments like NCDs,80-ccf issues and other debt instruments.

[Above Excel file is continuous in fact.Due to less horizontal space its shown in two parts.]

Record of Mutual funds:

Record can be kept with order of name of the scheme,total units,NAV ,original investment,current value and % returns.Number of units and NAV will be changed time to time and can be updated accordingly.

Similar sheet can be prepared for stocks,Gold and silver also.

[Above Excel file is continuous in fact.Due to less horizontal space its shown in two parts.MF Scheme names are merely indicative and not necessarily recommendations]

Home Loan schedule:

We can track the home loan / car loan schedule,for paid and next installments.


What Next Can we do In Excel-Part-II post:

Create Summary of Each Individual using Pivot Table:

Tracking of individual investments of Mr X and Mrs X in above case.

Create Dash Board:

We can create dashboard summary with different headings like Equity,Debt, Precious metals and connect all source files to dash board.We can track asset allocation very well using Dashboard.

Tax Planning Files:

We can create Excel file having detailed tax saving investments for that particular year and keep it for future reference.
There are number of online tools available for investment tracking purpose.But I do not find anything as simple as Excel is.As well we can keep files at email also to access any time and anywhere isn’t it?


Category: Uncategorized

Tagged: ,

3 Responses

  1. tester says:

    Record of fixed deposits .please attach the excel file to be of use to many people.

  2. GG says:

    where is the xl sheet

Leave a Reply




Blog Archives

See How Much Interest Your Saving Have Generated!!!Final Value will be Original Principal + Interest generated

Blog Author

Blog Author

Who's Online

10 visitors online now
3 guests, 7 bots


Information provided on this blog is for general purpose only & not investment advice.Please take advice of SEBI Registered Investment Advisors before taking any investment decision.
10 visitors online now
3 guests, 7 bots, 0 members
Max visitors today: 18 at 11:31 am UTC
This month: 26 at 10-09-2018 05:38 pm UTC
This year: 69 at 08-02-2018 04:13 pm UTC
All time: 363 at 09-23-2016 05:45 am UTC
Thank You For Visiting This Blog!!!