  |
08-05-2008, 08:41 AM
|
#2
|
|
|
|
|
Newbie
Last Online: Today 08:27 AM
Join Date: Jul 2007
Posts: 31
|
I have been keeping our budget in an excel spredsheet for two years. It works very well for me. First, we use our debit card for most everything. That way it is easier to track exactly what we are spending and where without keeping receipts. I log onto my online banking account every two weeks and print off my checking account activity and plug it into my spread sheet.
this is how do my budget:
1. Start with total income for the month. Please note that the income number is after a 10% contribution to our 401(k) and paying for health insurance.
2. Subtract all fixed costs that must be paid every month. (mortage, car payments, ineternet, satelite, car insurance, life insurance etc)
3. Subract all variable costs that must be paid each month (utilities, doctor bills, home phone, cell phone, etc). I plug in the number form my checking account each month. It took a few months of tracking these until I got a baseline for these. The result is my basis for building the rest of my budget.
4. I have separate line item categories for gas and groceries. I have a set budget for these, but lately I seem to go over every month. I did not have a budget for these items at first. I tracked them for a few months to get a baseline amount.
5. Once I have subtracted my gas and groceries I move onto credit cards. My goal is to starting breaking out credit card expenditures into the appropriate categories. I dont have a bugeted amount for this. We only use it to pay for big things that we may not have the cash for at that moment (i.e. new tires or things for the house) . I pay it off everymonth either from our emergency fund or from our checking account.
6.The final category is miscellaneaous items. I have a line item for each expense listed below. I have it broken into three categories:
(1) Entertainment which includes: aerobic classes, eating out and any other activites that may come up
(2) General Miscellaneous includes: House repairs or anything related to the house, gifts, vet bills, diapers and formula, hair cuts and clothes. My trips to Target are in this category too. I want to start breaking out each item that I purchase into a category. But for now it is just a line item called target.
(3) Cash - this is for the little things that we buy with cash. We spend very little cash since we use the debit card for every thing.
After I have subracted everying from income the net result goes into savings.
I have found that the spreadsheet software that came with my PC is just fine for doing my budget every month. I have the freedom to add any categories that I want. I have even started to do annual averages of everything. I also calcute each item as a percentage of income. I am finding that the longer I have been doing it the easier it has become to track things and anticpate future expenses.
sorry this is soooo long, But I am obsessed with working on our budget! It has been the main driver in keeping us on track since I became a SAHM. Without it I think that we would totally overspend.
|
|
|
|
|