Excel savings template
July 6, 2009 11:02 AM   Subscribe

Can anyone recommend a good template for tracking multiple savings account balances in Excel?

I have a number of savings accounts, plus an investment account. For our expense budget we have a whiz bang template that includes contributions to savings, investments, etc as an outgoing. I can't find anything similar to then track the balances and gains of the savings accounts.

Right now I have a clunky spreadsheet that looks kind of like this:

Accounts | May Bal | In | Out | Gain | Loss | June Bal
Sav 1 |
Sav 2 |
....... |
Invest |

I group the in month columns to only show the monthly balances, but it's still ugly and there must be a better way. Any ideas?
posted by IanMorr to Work & Money (5 answers total) 3 users marked this as a favorite

Yes I know it is not an excel template, but it is a better system for tracking expenses than a custom excel spreadsheet.
posted by nielm at 12:46 PM on July 6, 2009

I've tried it. I've tried loads of different money management software and most of them are far too complicated for my needs. Getting the data in, even when it's already in QIF, is more of a pain than putting up with my clunky spreadsheet.
posted by IanMorr at 12:52 PM on July 6, 2009

Another non-answer: You may want to investigate Yodlee MoneyCenter or Mint.com. They automatically get your latest balances from your bank for you.
posted by floam at 2:50 PM on July 6, 2009

Check It's Your Money to see if one of their offerings will work.
posted by megatherium at 3:06 PM on July 6, 2009

Thanks, there's a couple of good templates over at IYM that meet my needs. The freedom one is pretty complicated, but I can tailor it.

My CU is not supported by mint.com unfortunately.
posted by IanMorr at 8:43 AM on July 7, 2009

« Older How was it proved that mass exerts the gravitic...   |   Where to buy fitness equipment in SF Newer »
This thread is closed to new comments.