Managing Our Savings Account
Categories: Budgeting, Saving
No Debt Plan is a blog about living a debt-free life. If you're new here, you may want to subscribe to my RSS feed (e-mail subscription also available). Learn more about me, or some of my most popular posts. Thanks for visiting!
I received a reader comment/question on The Savings Snowball. Instead of answering within the comments, I thought I would share it here and flesh it out a bit. Here’s the question.
But how do you separate what you’re saving for?
My bank lets me put the money into a savings plan (banking in Israel is different - we don’t have “savings accounts”, just savings plans).
What financial management system do you use to separate out what you’ve saved into various blocks?
Let me clarify how our savings work. We only have one savings account with ING Direct. All of our “saved” money goes into this account. (ING does give you the option to open up multiple mini-accounts to save for specific purposes, but we don’t use it.)
Instead I use Microsoft Excel to track what is in the account. We have a Excel Workbook for our finances, and each worksheet within it tracks one account (savings, checking, etc.). So there is a worksheet for the ING savings account. We then break down and track each category within the spreadsheet.

An example that is similar to what we use is shown to the right. The top 5 rows are what is currently in the account. The first line shows the total of the four categories below it. All of the money is in the one savings account, but we track it individually with the spreadsheet.
Below that, if we transfer money into the account, it goes towards a specific category. If we were depositing $400, it might be broken up as shown.
The grouping on the bottom is the new total… simply the first group plus the deposit group to give the new totals in each category. I then copy the numbers from the bottom row to the top row to complete the update.
That’s how we track everything. Excel is a very powerful tool if you can learn how to use it. Most of what we do is just addition and subtraction, so your average user should be able to handle it.





