Previous post:

Next post:

3 New Year’s Worksheets

Each Christmas, the M-Network blogs celebrates the 12 days of Christmas with 12 posts on personal finance. Of course, these aren’t the real 12 days of Christmas, but since those come after Christmas it’s rather anti-climactic. We’ll be posting from December 1st to December 12th.

Today, I’m introducing three worksheets which can help you manage your financial life. If you haven’t started yet, the New Year is a great time to get your finances in order!

The first two are spreadsheets, the third is a Word document (since it’s most likely to be modified and should be easiest to modify). If you don’t have Microsoft Word/Excel/Office, you can still use them. Just get the free Open Office suite.

Basic Budget Spreadsheet

This basic budget spreadsheet ( [download#8#nohits] ) is based off the one I use. Jeff at My Supercharged Life points out that a rigid budget normally dies quickly. Take that into consideration, look for ways to give yourself flexibility of possible and remember that it’s ok to spend more in one area as long as you reduce in others. That’s why the sheet has a balance tally at the bottom. As long as that’s 0, you’re perfect. If it’s positive, then you have extra in your accounts and if it’s negative, you spent more than you earned.

The budgeted amount areas have numbers such as $100 pre-entered as placeholders. They bear no reflection on what I think a budget should be. Simply enter your budgeted amount in the budget column, your actual spending in the next column, and you’ll find out how much you have left in the third. It all adds up at the bottom.

At the top, there is a section for income. I put in two incomes, since it’s easier to delete a row than add one. I added a third section for misc. income from such things as blogging, freelance, consulting, and odd jobs. You can also put any planned withdrawals from savings in the third line.

There are sections for variable monthly spending (groceries, gas) and fixed monthly spending (cable bill, rent/mortgage payment, insurance payments and money saved for biannual/annual insurance payments). Fixed monthly spending includes debts. You may want to budget the amount of your snowball or just snowflake on as you decide. Either way, your income should still equal your outflow.

There’s onepagefor each month, since your needs will probably vary month-to-month.

You can download it here: [download#8#nohits]

Blogger/Freelance Spreadsheet

This one ( [download#9#nohits] ) has already been introduced on the blog, but I’ve updated it for 2009. It has two pages, one for recording income from advertisers and the other for recording specific consulting jobs. The first allows you to easily enter a series of payments from one advertiser or spread out effective payments which were made in a lump sum. So not only can you keep track of your earnings, you know when a pre-paid ad is due to come down.

The second sheet makes it easy to record job-by-job. It has a place for the name of the client, amount due, whether or not it’s been invoiced, whether or not it’s been paid, and then room for a description of the job (useful for your portfolio).

You can download it here: [download#9#nohits]

Financial Life Worksheet

This worksheet ( [download#10#nohits] ) is a in a Word document. It prepares for the possibility that you or your spouse/partner may die (eventually, both of you will) and compiles all your important financial information. If you’re single, you may still want to have a copy kept somewhere safe with your parent or a trusted relative to ease the handling of your affairs.

It includes places to write your checking, savings, cd, retirement, college savings, credit card, student loan, and car loan account numbers, instutions, login information, payment schedules, interest rates, etc. Then there are places for insurance information (policy numbers, coverage, payment schedules) and for monthly bills such as water, heat, electricity, cell phone, and cable/phone.

Of course, some sections will be completely irrelevant to you, which is why it’s in a Word document rather than a spreadsheet. You can easily delete entire sections, add new ones, add more account information, etc. Be sure to keep this document in a safe place, you may want to print it out and delete the file from your computer. While it could provide you or your partner with everything they’d need after one of your deaths, it could also be very useful to a thief.

You can download it here: [download#10#nohits]

The 12 Days of Christmas

Day 1 – The First Rule Of Personal Finance at Paid Twice
Day 2 – Two Financial Goals – Less Debt, More Income at Cash Money Life
Day 3 – 3 New Year’s Worksheets at Mrs. Micah
Day 4 – 4 ways to be better prepared for Christmas next year at Gather Little By Little
Day 5 – 5 Golden Rules To Follow During The Holiday Season at My Two Dollars
Day 6 – 6 Ways To Give at Moolanomy
Day 7 – 7 Savings Strategies at Being Frugal
Day 8 – Eight Simple Snowflakes at Paid Twice
Day 9 – 9 Year-End Money Moves at Moolanomy
Day 10 – 10 Personal Finance Essentials at Cash Money Life
Day 11 – 11 Ways To Decorate at Plonkee
Day 12 – 12 Steps to a Prosperous New Year at Being Frugal

{ 25 trackbacks }

Two Financial Goals - Less Debt, More Income | Cash Money Life
December 3, 2008 at 7:34 am
The 12 Days of Christmas - Personal Finance Style 2008
December 3, 2008 at 6:03 pm
The First Rule Of Personal Finance | I've Paid For This Twice Already...
December 4, 2008 at 11:18 am
3 Handy Financial Worksheets For The New Year | Live To Budget
December 4, 2008 at 10:08 pm
5 Golden Rules To Follow During The Holiday Season. | My Two Dollars
December 6, 2008 at 10:14 pm
Strategies for Saving Money |
December 7, 2008 at 7:01 am
Weekend Roundup- The Christmas Spirit Edition | Think Your Way to Wealth
December 7, 2008 at 6:51 pm
squawkfox » Welcomes, Freebies, and Downloads Oh My!
December 8, 2008 at 3:08 am
Eight Simple Snowflakes | I've Paid For This Twice Already...
December 8, 2008 at 9:13 am
10 Personal Finance Essentials | Cash Money Life
December 10, 2008 at 8:03 am
Are You Spending Less This Christmas? | The Bad Credit Lender
December 10, 2008 at 5:48 pm
the 11th day of Christmas: 11 ways to decorate more frugally | plonkee money
December 11, 2008 at 7:01 am
Make a Financial Plan for a Prosperous New Year |
December 12, 2008 at 7:01 am
12 Days of Christmas - Personal Finance Style Wrap-up
December 13, 2008 at 5:34 pm
12 Days of Christmas - Personal Finance Style : M-Network Blogs
December 14, 2008 at 8:56 am
Link Love: 12 Days and 12 Peeps to Love | I've Paid For This Twice Already...
December 16, 2008 at 1:00 pm
Going Frugal: Prioritize for 2009 | Sisterly Savings
December 17, 2008 at 11:46 pm
Organize Financial Information for Your Spouse
December 22, 2008 at 7:30 am
12 things you must do in the new year | The Whinging Geezer
December 23, 2008 at 3:21 pm
6 Ways To Give : Moolanomy
December 25, 2008 at 11:59 pm
Weekend Highlights, December 14, 2008 : Moolanomy
December 26, 2008 at 12:02 am
9 Year-End Money Moves : Moolanomy
December 26, 2008 at 10:52 am
Creating a Household Budget and Why it is Important | Think Your Way to Wealth
January 4, 2009 at 12:31 am
Taking Care of Business « zpetals
January 26, 2009 at 5:34 pm
Lessons learned from filing my taxes
January 12, 2010 at 7:00 pm


Miranda December 3, 2008 at 8:04 am

Thanks for the great spreadsheets. It’s great to get things in order now, and start getting ready for those financial New Year’s goals. And in this economy, we need it πŸ™‚

Jeff@MySuperChargedLife December 3, 2008 at 8:17 am

Great resources! I need to take a look at that Word document. It sounds like a neat way of keeping track of important information. I really need to get my information organized for the reason you mention.

Thanks so much for the link!

Saver in the City December 4, 2008 at 2:19 pm

Thanks for the Financial Life Worksheet! Being single, I had started to draft something similar to send to my parents just in case but I didn’t think of the home insurance, healthcare info, etc. Very useful…

mrsmicah December 4, 2008 at 3:01 pm

@ Miranda, yep. When times are tight, it’s even more important to stay on top of our finances.

@ Jeff, there’s a lot of stuff in the Financial Life document, you’d be surprised how many accounts and whatnot we end up having.

@ Saver, since I handle all of our insurance stuff except (sometimes) paying the bills, I realized that Micah might have a hard time finding our physical policies, whatnot, if something happened to me. Until then, I hadn’t thought to include it either, but since we just renewed our renter’s insurance, it was on the brain. πŸ™‚

Steve @ brip blap December 19, 2008 at 9:22 pm

Those are some nice spreadsheets – thanks for sharing! I’m a sucker for spreadsheet downloads… πŸ™‚

Marie Feudo December 21, 2008 at 1:23 pm

Who are you exactly? Is this site for free? Thank you.

Comments on this entry are closed.

WordPress Admin