Financial manager Excel

Financial Manager Excel

Financial Manager Excel (FME) is a handy tool which allows you to manage your finances with a few simple clicks. It is basically a driven by a simple excel sheet, and has a forms based user interface. It's so simple to use, that you will actually have fun managing your finances.

FME is especially useful for young bachelors who live in a shared house. I know from personal experience that managing the finances with more than two people in the house was a big headache. In fact that's exactly how FME came into existence in the first place.

Download Download Now Download

About FAQs

What is FEM?

It's a simple excel driven by a few Macros and forms which helps you manage your finances. It helps you in the following:

  • Track who paid how much money and for what.
  • Smartly calculates who needs to pay who how much.
  • Helps you track the people who owe you money.
  • Record a complete history of your expeditures.
  • Say bye bye to pen, paper and the headache to calculator to find out who owes how much.
Why do I need it?

Are you fed up of managing your daily finances? Do you have a headache trying to remember how much your friend/flat-mate owes you? If yes, the you definitely need to try this excel.

  • Tracks who needs to pay and who will recieve the money.
  • It does all the calculations for you.
  • It is simple and concise.
  • It is intuitive and easy to read and understand.
  • It is quite small.
What does it cost?

FEM is absolutly FREE !!!

If you really like the application, I would love if you could donate some money for me to maintain this website

Can I see a few SnapShots?

Sure. Here are a few (click on the thumbnail to enlarge the image):

What is the current version of FEM?

Even though I've been using the FEM for last 5 years, this is the first version I've released. Please so that I can further improve the application

How big is the application?

The application size is just 250KB for downloading. However, since the data is stored in the excel, as you use it the file size will increase.

What is the minimum system/software requirements for FEM?

All you need is a decent computer with Excel 2003/2007. Please make sure Macros support is enabled.

Does it work in OpenOffice Calc?

Unfortunately not as of now! Since this is the first version, I am only releasing the version compatible with MS Excel 2003/2007. However, depending on the requests, I will eventually port it to OpenOffice Calc

What other cool stuff do you have?

If you like the Financial Manager Excel, you will surely like the Online Organiser.

Help FAQs

How do I set it up?

Simply download the excel and open it. As soon as you open it, a form will be loaded which lets you setup the excel. Please make sure you enable the Macros for the excel to work properly.

How do I enable Macros?

Make sure the security level in the macros is set to 'medium' or 'low'. On how to change the security level, have a look at the following articles:
Excel 2007: http://office.microsoft.com/en-au/help/HA100310711033.aspx#12
Excel 2003: http://office.microsoft.com/en-au/excel/HP052356701033.aspx

What/Who is a member?

Any person who either needs to pay you, or has already paid you can be considered as a member. A member is basically a house member who will contribute to the daily life expenditures. You can also put the names of temporary people (who owe you money, or whom you owe money) into the same excel, without effecting other members.

How do I add more members?

Just click on the 'Add New Member' button and follow the steps.

How do I delete members?

Click on the 'Delete member' button. All the members who can be removed from the excel will be listed. If a person does not have a zero (0) balance, he/she cannot be deleted.

Why cant I see all members when I try to delete a Member?

A person can only be deleted if he/she has zero(0) balance. To list the person's name in the 'Delete Members' menu, please make sure his balance is 0 by either paying him (if he has positive balance) or getting money from him (if he has negative balance).

How do I add a new entry?

Click on the 'Add new Entry' button and follow the instructions.

What is the weird colorful sheet (with the current month + year in it's name)?

This sheet stores the History of the transactions made in the current month. The sheet gets automatically updated every month/or when a member is added/deleted.

How do I modify old entries?

For modifying old entries, there is no form based interface. This is where the 'weird' colorful sheet I've talked about above comes in handy. If the entry you need to modify was made this month, the go to the "February2012" (the only sheet other than "Home") sheet and find the entry. If it's an older entry, find the appropriate sheet amongst the hidden sheets. Sometimes, you may find multiple sheets for the same month. These are created everytime a member is added or deleted.

Once you find the correct sheet, make the modification as required. Make sure you update both the credit and debit columns. For eg:

Say there are 5 members (A, B, C, D & E) in the excel. Say A paid $200 for all 5 of them. However, by mistake you entered $100. So goto the correct Worksheet, and update the $100 in A's CR (credit) column to $200. At the same time, also update the $20 in the DB(debit) columns of A, B, C, D & E to $40.

How do I delete old entries?

For deleting old entries, there is no form based interface. This is where the 'weird' colorful sheet I've talked about above comes in handy. If the entry you need to delete was made this month, the go to the "February2012" (the only sheet other than "Home") sheet and find the entry. If it's an older entry, find the appropriate sheet amongst the hidden sheets. Sometimes, you may find multiple sheets for the same month. These are created everytime a member is added or deleted.

Once you find the entry, make sure you delete the complete row and not individual cells.

How do I setup a new FME sheet?

Once a FME sheet is setup, it stores all your data. Hence deleting it to the starting condition is not an option. The best option would be to download a fresh copy from here.

Need more help?

Please with your query and I'll try to get back to you ASAP.

Download Download Now Download

Please help me maintain this website. Even a small donation like $5 would be greatly appreciated.