Monday, April 25, 2011

A Simple Way To Track Expenses, Incomes And Accounts

A friend of mine asked me for some help to help track expenses at home. And to keep track of money given by her boss towards his expenses which she makes (meaning stuff for his house or the office that she buys for her boss). While her boss trusts her implicitly she still likes to keep track of money that he pays her and settle accounts. Every once in a while she gives him an account of where the money was spent. 

Then she has a running account with a cousin for whom similarly she makes purchases.

Sounds familiar? 

On top of it if you have a need for keeping track of future expenses and know how much balance you are likely to have in each account (so that your cheques don't bounce, you have to make sure that a minimum amount is in the account)?

Well there is a simple solution. All you need is Microsoft Excel. A spreadsheet that I have does all this and more. So if you need to know where you spent money, what your balance will be in future, who owes you how much or how much do people owe you, this spreadsheet will help you.

And it takes 5 minutes each day to update your transactions on the spreadsheet. You don't have to depend on your memory or write in pieces of paper. You get to track all the information that I mentioned above in one spreadsheet.

Note: This is not a spreadsheet meant for investment planning. This is meant for tracking your expenses, account balances.

No comments:

Post a Comment

Popular Posts

Featured Post

Trump's Election Interference

I can think anything that may not be true. And I can say untruths because I have a right to freedom of speech. Based on that thought and wor...