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?
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?
Response by poster: 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
posted by IanMorr at 12:52 PM on July 6, 2009
Best answer: 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
posted by megatherium at 3:06 PM on July 6, 2009
Response by poster: 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
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.
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