I’ve been working behind the scenes on a tool that I personally use to track and organize our finances:
Family Budget Spreadsheets
This package of 9 Microsoft Excel spreadsheets is designed to help you organize your finances, plan for major purchases, create a budget, understand your cash flow, and track your net worth.
Many years ago, we could say yes to the questions in the above graphic.
This blog was based on my very first spreadsheet, the Family Balance Sheet. I created it as a way to communicate our finances to my husband. That first family balances sheet sparked my love for spreadsheets, and over the years I created many more out of necessity.
To plan for our monthly spending, I started searching online for a budget spreadsheet. I found a lot of printable (pdf) budgets, but couldn’t find a spreadsheet that I liked. I created a Monthly Budget spreadsheet, because I like formulas.
There was a month in 2013 where I hadn’t planned on a large property tax bill and I wasn’t sure where we were going to find the money. We scrambled to find the cash, but in that moment I created the Personal Escrow spreadsheet, because I NEVER wanted to have that frantic feeling again.
One January, we received a very large credit card bill in the mail. I knew it was coming, because we hadn’t planned for all of the gifts we bought in December and used a credit card to pay for them. I created the Gift Spending Budget spreadsheet to start planning for the next Christmas, because I NEVER wanted to feel that out of control again. When the following Christmas rolled around, we were able to use cash, and slept quite soundly in January knowing there wouldn’t be any large bills in our mailbox.
One summer, we didn’t have enough money to cover a vacation and some day trips, so we hosted a yard sale to find the extra cash. I created my Summer Budget Spreadsheet, because I never wanted to feel that we couldn’t afford a camping trip again.
Two years ago, we had some appliances that were starting to not work very efficiently. They were older units and we sucked the life our of them as long as we could. Knowing that newer models aren’t cheap, I devised a plan…and a spreadsheet. I created my Special Purchases spreadsheet to help us plan for new appliances. We were able to set aside the money over a course of 16 months and it felt amazing to walk in to a store and have the cash for a purchase.
I am a planner by nature, so I leaned into my spreadsheets. I hated feeling out of control with our money, so I created them to gain a sense of control, freedom, and optimism. We could afford a camping trip, we could pay our tax bill on time, and we could pay cash for Christmas, but we needed to PLAN for it.
Introducing the Family Budget Spreadsheets:
This workbook of 9 Microsoft Excel spreadsheets includes:
- Family Balance Sheet – A one page snapshot of all your accounts. You enter your information and the spreadsheet calculates your total assets, liabilities, and your net worth. You might already have this spreadsheet, since it’s free for joining my newsletter community.
- Financial Goals – Use this spreadsheet to quantify your financial goals for the current year and years to come.
- Monthly Budget – This spreadsheet will help you plan and budget your monthly income and expenses before the month begins. This is a one month only spreadsheet.
- Actual Spending Log – Use this spreadsheet to enter your actual income and spending for each month. This is a 12 month spreadsheet.
- Personal Escrow – Use this spreadsheet to plan for your high yearly expenses, such property taxes, association fees, insurance, etc.
- Special Purchases – Have some fun with this spreadsheet and use it to plan for upcoming large expenses, such as vacations, home renovations, equipment, replacement, etc.
- Gift Giving – Use this spreadsheet to plan for your gift giving for the entire year, but especially Christmas.
- Petty Cash – This spreadsheet can be used to keep track of high value gift cards and any cash that you have tucked away.
- Summer Planning – Use this spreadsheet to plan for your summer fun, such as vacations, day trips, pool memberships, home/landscaping renovations, etc.
Want to see the spreadsheets, visit my page: Family Budget Spreadsheets, for images of each spreadsheet.
If these spreadsheets sound like something that you need in your life, visit my new website for more details: