|Click HERE for your copy! |
(From Google Drive,
click on the down arrow to download,
then select Open when prompted.)
Proverbs 10:4 A slack hand causes poverty, but the hand of the diligent makes rich.
This week, we sat down and discussed how to create a budget that would work best for us. I spent about an hour looking online, but nothing I found had the right FEEL. My dad is an accountant. The budgets I saw growing up (at home, with investments, and with client accounts) were maintained using paper and pencil one-writes. I LOVE one-writes. I love the extra long paper, all those crazy numbers, and the straight columns that balance forward. Excel is similar to a one-write and faster, so Brian voted for that.
I spent a few days creating, designing, and redesigning a template that we could use for 2013 and the future. It's not perfect by any means. Because of our high-deductible insurance plan, we've got an HSA to pay for all medical, dental, vision, and pharmacy fees. The HSA (pretax account) is not reflected in the budget since the budget is based off of our net (take-home) income. The medical expenses are also not reflected. The bank that manages our HSA does a beautiful job of managing all this information for us, so it would be redundant to put it on the spreadsheet. However, it might be worthwhile to track this information for others, so I've added it to the bottom of the spreadsheet.
Please use this spreadsheet as you like. Change it! Manipulate it! Make it your own! (It won't print very nicely because it's huge, but we never intended to print.) Here are a few suggestions on how to get started:
- Name each line item. Right now, I've made them generic (i.e., Income #1 and Trash). I find that it's easier to call things what they are (i.e., Brian's Job and Palmetto Waste) so that I can easily identify these items on my credit card or bank statements.
- Begin with the Income section.
- Look only at January (for the moment), and enter your "Budget" amounts. Since it's February, we just pulled up our bank statement and entered the total income Brian received for January into the "Budget" and "Actual" columns. He is paid bi-weekly, so typically it's just two pay periods per month. However, January has 3 pay periods, so we had to be mindful of that when entering the total income "Budget" for February, March, and so on.
- Complete the "Budget" columns for the entire income section. Your totals will be reflected in the "Annual" section.
- The "Annual" section (light yellow) is entirely based on equations. You can delete an equation (typically the sum of all "actual" or "budget" amounts for that row) and type in your own number if you like, though I would caution against it.
- Now pick a section you want to work on next. We skipped down to "Monthly Expenses" and completed those monthly budget columns very quickly. Those numbers typically stay the same :)
- "Monthly Flexible Expenses" are those that we have a bit more control over in their actual values. We tackled these next.
- "Annual Expenses" took a bit of research and were treated slightly differently. We didn't budget "per month" for these items. Instead, we looked up each item (i.e., Property Tax), identified what month that item would be due (i.e., June), and budgeted the amount from the previous year plus $10 in the June budget column. All of the other budget columns for that line item are $0.
- Now, evaluate what you can SAVE! Look at cell AC12. This cell tells you quickly what money you're supposed to have left over after subtracting all budgeted expenses from the budgeted income. We took that number, subtracted $5000 from it (because I really like to make sure I'm ALWAYS under budget), and then divided that remaining balance by 12. This gave us a goal, per month, of how much we could save. We then divvied up that per month amount into savings for Emergency, College, etc.
Trust God with your finances. Make wise decisions and evaluate your motives for spending in each category. Continue to give, and watch Him multiply your "mite" to use for His glory!