Ask the Readers: But HOW Do You Track Every Penny You Spend?
Published on - July 8th, 2011 (by J.D. Roth) It’s tough to dig out of debt (or make other changes to your spending habits) if you don’t know where your money goes. I tried for years to turn things around, but was unsuccessful until I started tracking every penny I spent. Armed with info about my actual spending habits (instead of perceived patterns), I was able to make a realistic budget.
But getting started with expense tracking can be overwhelming. There’s so much data! Where do you begin? That’s what Crystal wants to know. She writes:
I’m a little confused. How do you track every penny you spend? Isn’t that what receipts are for? I’m confused (or maybe I’m overthinking it). Let me explain.
Say I stop at a gas station and spend $30 on gas, $2.15 for a Red Bull, and $4.10 for a gas treatment. My receipt already says that, so why rewrite it?
Or at the grocery store, what do you do here? $X on dairy, $X on meat, $X on lunch stuff, and so on? Do I count eating with co-workers as networking? What about fast food that I buy because I’m too lazy to cook? Should this be lumped into the food category or separated out?
How do you actually track your spending? Could you or your readers share some examples?
This is yet another question for which there’s no one right answer. Different people need to track their spending in different ways. That said, I can offer some general guidelines.
First, a tracking system is only effective if you actually use it. You can design the greatest tracking system in the world, and it doesn’t matter a whit if you never enter your expenses. Because of this, you need to do what works for you. By that I mean that Crystal should try a system that seems promising and if that doesn’t work, try something else. Don’t give up if the first method doesn’t work. There’s always another method that might do the trick.
From talking with GRS readers, it seems clear that the more complex a system gets — the more detailed the tracking — the more likely it is to break down. I’ve certainly found this to be true in my own life.
I like the idea of breaking my food category into subcategories like:
- Meat
- Dairy
- Produce
- Beverages
- Junk Food
- Entertaining
- Restaurants
In reality, though, tracking this level of detail makes my head hurt. It makes me not want to do my finances. Instead, I track just two food categories: Groceries and Dining Out. That’s enough detail for me to spot trends and to make changes. By tracking only a couple of dozen categories, I’m able to spot trouble without being overwhelmed by unimportant stuff.
This leads us to the cardinal rule of expense tracking: Track the stuff that matters. Decide which categories you need the most information about and track them. For me, that means tracking how much money goes to books and comic books. I know these are my weak spots, so I have to monitor myself. Each person will track different categories. For instance:
- If you don’t care how much you spend on books, don’t have a separate category for them. Lump them into your general Entertainment category.
- But if you want more detail about a category, create a subcategory. For instance, you might want to know how much you’re spending on iTunes; if so, create an iTunes subcategory in your Entertainment category.
In general, it’s best to start with broad categories and add detail as needed.
It’s also important to record your expenses often. If you set aside a few minutes every day (or maybe half an hour every weekend), it’s vastly easier to track your spending than if you have tackle the task only once a month. In my own case, I’ve found it’s best to designate an hour a week for “doing my finances”. At this time, I record the week’s transactions and pay my bills. This is what works for me.
Lastly: Why doesn’t it work to just use your receipts for expense tracking? Well, for some people it might, but I suspect those folks are few and far between. I know that for me, just having the receipts doesn’t accomplish anything. Yes, I could look at them to see how much I spent, but there’s no way to organize this data or to get an overview of my spending habits unless I categorize it somehow. Receipts are a temporary record of your spending; for this information to be useful, you need to store it in a more permanent way. (In the olden days, this meant using some sort of ledger book. Nowadays that means using a spreadsheet, a software program like Quicken, or an online tool like Mint.)
What about you? Do you track your expenses? If so, how? What level of detail do you go to? What categories do you use? Have your methods changed over the years? Or do you find expense tracking just too much overkill? What words of wisdom can you offer Crystal?
This article is about Ask the Readers, Basics, Budgeting
SEARCH FOR RECENT ARTICLES




I track all of my expenses via Quicken. I’ve been doing it for about the last decade and I find it very empowering. I really like knowing where all my money is going and where it’s coming from. It really gives me a sense of control over my life.
I use a credit to buy almost everything (and pay it off each month) because I find it easier to keep track when they all get downloaded into my computer. Cash, I just round up to the nearest dollar and track it that way. But some people even think I’m crazy for doing that. Honestly, I can understand that. However, being a student I need to keep track to a greater resolution than every ATM withdrawal. Maybe once I’m salaried again, I can just forget about tracking cash.
As to the detail, I agree on food. I do groceries as one category and dining out as another. The only thing I break out is coffee, out of curiosity of the “Starbucks effect.”
loading....
Like Matt, Quicken really works for me. I use the reports feature a lot to see what I’m spending on certain categories, how my spending has changed, etc.
I don’t use the automatic download feature from my banks and credit cards, etc. I like to hand enter everything so I’ll have more awareness of what we’re spending.
I’m a big nerd, though, so I actually enjoy this whole process.
loading....
I also like to enter my credit card transactions manually. Over the years, I have caught several errors in the charges, such as restaurants adding on extra tip, one restaurant running my card for both my bill and someone else’s, cancelled subscriptions continuing to charge me, and a few completely incorrect charges.
loading....
I am with you. I set up Quicken 8 years ago and have manually tracked since. At penny level. I know where I spend my money and track things to try to improve my decision-making.
loading....
Well i find that most people use their credit card to track spending. For me it doesn’t work because i don’t use my credit cards!
I remain fairly frugal all my life so to me i only spend on big items and necessities.
Because of that i use a Quicken solution.
I basically create virtual accounts for each broad categories
-personal utilities spending account
-household spending account
-investment warchest
-spending buffer account
-transport account
-vacation account
when i spend i usually can remember the amount off my head. hey its not possible to spend so much. if its groceeres i keep the receipt. then i enter into my quicken.
i kept till date 8 years of data on this.
that is not to say it has helped much.
you can view how i set this up over here > http://www.investmentmoats.com/budgeting/how-to-budget-with-envelope-budgeting-to-save-money-easily/
loading....
I agree that the more complicated it gets, the less inclined I am to track. Crystal might try just tracking one category for six months — clothing, say, or gas, or eating out. That way she gets an idea of how much she really spends on that category, and she can decide whether she *wants* to be spending that much.
Some people carry a notebook and write down everything at the time of purchase. You can definitely use receipts if you want – just stuff them all in an envelope that you keep right near the front door, so you can put the receipts there immediately when you get home every day. Then once a week add all the numbers up on a piece of paper you keep in the envelope. Since you’re only tracking one category, it’ll take about two minutes.
But of course the biggest motivation to track is because you want to have money for something and you need to figure out where the money you want to spend is currently disappearing. If you’re not motivated, you won’t keep tracking, no matter how simple the system you set up…at least in my experience!
loading....
I agree with this. Overly complicated processes will have her throwing in the towel after a day of shopping.
I track by categories – food, entertainment, mortgage, etc. If I go to a store that sells a few different categories (I buy groceries, clothes, household supplies, etc. at Target), I use the receipt to calculate taxes and put the amount in the correct category. I created my budget sheet in Excel and print out a sheet every month. It’s second nature now, so the hard part is just remembering to record expenses as you pay them.
loading....
This is a great idea, and one I’m trying right now. I am just tracking eating out. That’s it. Start small.
loading....
I find it easiest to track all of my spending with my credit card. The detailed spending details automatically let me see where every penny goes that I spend every month, and my credit card (CHASE) allows me to look at charts and graphs of the categories that I spend in. This makes it easy to track and easy to compare month to month. Of course, I pay the balance off every month, so I don’t incur any interest or fees for using this service. Not to mention the added protection of using a credit card. Much easier to have this data automatically recorded every time you swipe your card, then carrying a pen and paper every where you go.
loading....
What do you do about tracking non-card spending? Or is absolutely all your spending on a credit card?
I tried using credit-card linked PF software but couldn’t add in non-card purchases (bus fares, farmers’ markets, other small independent shops) so abandoned it. I’d like to hear how people include that data if using card-linked software.
loading....
Card-linked software is useless. You need a more robust solution (e.g., Mint) that allows you to track multiple accounts. Because, last time I checked, my bank still won’t accept my credit card for my biggest expense: the mortgage
loading....
For non card spending, I used to do it by memory and just update Quicken every few days, but I found I’d invariably forget things.
I’ve since created a very simple Google Docs Form that just asks “Where”, “How Much”, and any comments. Then whenever I spend cash I just pull that up on my iPhone (use the handy add URL to home screen feature to give it it’s own icon) and quickly tap it in.
Then when I finally get around to putting in everything, cash-wise, it’s just waiting for me in that Google Spreadsheet.
If anybody wants that sheet/form, follow this link (https://spreadsheets.google.com/spreadsheet/ccc?key=0AjfhCn2YU7AUdFpGbWxwU0pWTnkwb21FdEVLWHJPTkE&hl=en_US) and then you can save a copy for yourself. Once you have your own copy, you can get to the form by click up in the menu bar Form > Go To Live Form. Once you fill it out you’ll see how it automatically populates the spreadsheet for you.
It’s the easiest (and “free-est”) way I’ve come up with to track cash spending on the go.
loading....
Thanks for posting this link!
loading....
That’s exactly how I do it! Plus, I also love seeing how much I’ve spent every month so I’m truly motivated to keep track of every penny I spend as soon as I spend it. I actually break it down by week, as well as quarter, which is pretty simple when you’ve done all the formulas in google docs. But I know I’m an anomoly, most people hate that idea of having to jot each instance of spending down.
loading....
Years ago I spent one month writing every single thing I purchased in my day planner note pad as I purchased it. It helped me immensely to track my expenses and I quickly found the funds to pay off my credit card debt in just a few months.
I still like to write down every expense in a small notebook so I can easily glance back at a certain time frame. I have to admit though, I have been slack about doing it this past month.
I definitely like the google docs idea and while I do not have a smartphone, that sounds like the perfect way to upgrade my old paper and pen day planner system.
loading....
Sorry for the obvious plug, but it’s for a free site
I built a simple cash tracker. It emails you every day. Just reply with your purchases, and your spending is logged. I built it because I spend mostly cash and like you guys couldn’t figure out the best way to track it. I’d love feedback on how to make it better. It sounds like it needs an “export to Quicken” feature, if nothing else.
loading....
I try to rely on credit cards exclusively. Cash spending I usually just lump in the unknown/error category because I’m lazy, but it’s a small amount–I withdraw maybe $300 annually, excluding international travel.
In a few years, this won’t be an issue anyway, because we’ll just be using our phones for payment. Even at farmers’ markets.
loading....
I have maybe 3 big bills every month that are not paid through a credit card (mortgage, natural gas, and life insurance policy). So I can easily keep track of those three and add them into the necessary categories when I look at my budget and what I have spent each month. Other than those, I put all of my expenses on the credit card.
loading....
My problem with credit card tracking is that I shop at places that have things in many categories. Some things I get at grocery stores are food (though some of that food is more of a luxury item than others), and some is toiletries or kitchen tools or supplies. And I shop at Target a lot. And thrift stores.
Also, I don’t use a credit card for everything such as my dance classes, one of my utility bills and fast food purchases of less than $2.50.
Plus I like to include the amount I’m saving for things, such as 1/12 of my estimated annual homeowner’s insurance bill.
loading....
I think a lot of the concerns about splitting credit card line items goes back to the comment JD makes in his article: keep it simple. Do I really *need* to split out the toilet paper into a different category than my food. Yes, it won’t be perfectly accurate, but its close enough just to lump it in with the food. After all, they are kind of related.
loading....
On Mint, I split out an estimation of the major stuff that I bought at the grocery store or Target. So, for example, if I went to Target and bought some clothes, sporting goods, shampoo, and allergy medicine, I’d estimate those for the appropriate categories. At the grocery store, generally everything is just in the “groceries” category – I don’t itemize whether it was for the house or food. If it is a major item like a huge stockup on toilet paper, I might make a note of it in the budget so that I can review how long products last (and give myself peace of mind that I didn’t spend too much that month!).
loading....
I track everything through Mint and mostly stick with the default categories
loading....
Since I mostly use my AmEx to pay for everything (2% back, and never carry a balance) I just use Mint to track my spending. It’s pretty darn automatic and I can aggregate or get as granular as I want with the data for the most part.
The $4 here $5 there tracking doesn’t help unless you pull it up to a higher level and go, OMG I spent $500 at gas stations this month/year/etc. It’s your spending as a whole that affects debt and savings so you need to aggregate to that level to make tracking worthwhile.
loading....
What does “aggregrate” mean?
loading....
Aggregate, in this sense, means combining many things into one. Mint.com lets you input your financial institution logins (checking, savings, credit cards, retirement accounts, investments, as well as manual input of assets). Whenever you login, it automatically downloads the latest data for each one. It allows you to see an entire snapshot of your net worth within seconds, and then has many levels of details if you need more (re-categorizing transactions, creating a budget, savings goals, trends, etc.) I’m a recent user, but I could not be happier! Haven’t opened Quicken since.
loading....
Thanks Amy, I had the same question and you explained it eloquently
loading....
Like JD, I track the stuff that matters. I don’t really care how much I spend on food to be eaten at home – because I’m already pretty good at monitoring that and would rather have good base ingredients than worrying too much about the budget. But I do care about how much I spend on dining out/take out or having to buy snacks/drinks while I’m out and about because I’ve not been organised enough to take it with me from home. That stuff feels more frivolous to me, things that I can easily trim with a bit more discipline.
I also care what I spend on craft supplies, books, gardening stuff (seeds etc) and general entertainment, because I know those are things that can quickly mount up – and again, things that feel more frivolous.
Tracking these categories (and a couple of others) helps make me more conscious about my spending – I still buy things but much more consciously than before.
loading....
First of all, I don’t track fixed expenses. Once a year, I go over all my fixed expenses and see which ones have changed (maybe electricity rates went up or our insurance is higher or whatever). I design a general “monthly budget” with the fixed expenses already removed. Whatever is left is available for monthly “variable expenses.”
We then look at what we spent on our variable expenses for the past year, and decide what to budget for each category for the upcoming year. Then those amounts are fixed. For each category, that’s ALL we have to spend in it.
Each month, I start with an empty template spreadsheet, with a different tab for each category (and a “Summary” tab at the front that shows the running totals of each category). Each category already has the monthly budget amount entered, and a running total that automatically updates as expenses are added. I use this to track my spending and to detect when I’m approaching the limits in each category.
Whenever I spend money, I keep the receipt and put it on my desk at home by the computer. The next time I’m at the computer, I enter all the receipts into the various categories for that month, and take note of categories where I’m approaching the budgeted limit. I then shred the receipts.
In addition, my wife and I each take out $400/month for personal spending. This covers things we buy for ourselves that aren’t shared expenses. Things like comic books, video games, days at the spa, haircuts, beer, and so on. Anything I’d feel bad asking my wife to chip in for (why should she pay for MY beer?), comes out of this money.
My jaw dropped at JD’s “couple dozen” categories. I have just 5: Groceries, Household Expenses, Transportation, Car Repairs, and Gifts.
Groceries: Anything that goes in your mouth for sustenance. Things that go in your mouth for pleasure (alcohol, junk food) come out of our individual monthly cash allowance.
Household Expenses: This one is sort of a “catch-all.” This covers toilet paper, cleaning supplies, lawn maintenance fees, gas for the lawn mower, anything for the house, basically everything that is a shared expense that doesn’t fit in any of the other categories.
Transportation: Gasoline, taxis, and bus tickets.
Car Repairs: Oil changes, new wiper blades, new tires, minor repairs, etc.
Gifts: Birthday, Christmas, charitable donations, etc.
That’s it. Everything we spend has to fit into those categories. I’d suggest updating it frequently (at least once a week), otherwise you could end up blowing your budget in one category without even realizing it. And the whole point of this entire exercise is to control your spending.
loading....
If I make it up to the office today (which is where my copy of Quicken lives), I’ll transcribe my categories. I should have thought to do that yesterday. I really do have 20-30 categories, though, most of which are default Quicken categories. I’m not so concerned about how much I spend on insurance, though, even though it’s a category. I’m more interested in the categories I’ve created for myself, such as books and comic books and “sin” (alcohol and tobacco) and the like. These are the things I try not to spend too much on.
loading....
I care how much I spend on insurance, some of it’s tax deductible!
loading....
You smoke? Isn’t that an expensive habit? Now, from budget. Long-term-potential expensive health bills. Might be a good topic… or has it been covered in the past?
loading....
Our categories are: groceries (food & household), house maintenance, gas/auto, pets, clothing, miscellaneous, travel.
I agree with focusing your expense tracking on variable items. We subtract out our fixed bills for the month and use Inzolo (a web-based envelope system) to track the rest. We’ve tinkered with the envelopes over the years. We started with many, and have adjusted them over time as we became more aware of our habits. I think your categories should be designed for your problem areas, and for your goals. If comic books are your weakness, then those should be a separate category so you can monitor it. If your goal is to reduce your spending on starbucks, have a separate category for that.
We’ve always found it’s nearly impossible to separate out groceries (ie food) from other household items (cat litter, cleaning supplies, etc) because they’re purchased from the same places and itemizing out the receipts would be a total pain. So we sort of lump those together and budget accordingly. Same with dining out vs. entertainment. Where do you put the slice of pizza you bought at the movie theater?
loading....
I lump eating out and entertainment (i.e. movie) in the same category.
loading....
After reading Your Money or Your Life, I reviewed my spending via my online checking account at USAA where I could export a month’s worth of transactions at a time, and reviewed my expenses for patterns and to make future decisions. I made some big decisions– increased savings, less starbucks, etc and made goals.
I track spending in a notebook against my USAA checking account. Each page of my notebook has my two paydates, and under that the bills that are due during that pay period, any auto payments including automatic transfers to savings, and then a total that is my paycheck less those expenses. Sometimes I go through and add upcoming trips, birthdays, etc to the period, which allows me to plan ahead.
The rest of the money is groceries + whatever I want.
Sometimes daily, but mostly every few days, I match my notebook to my checking account for what’s cleared and adjust the remaining spending amount for the pay period if I’ve spent something.
I never miss a bill this way, I always know what I am charged, and I am very conscious if I have overspent, and I don’t really care that much about tracking the remaining spending amount for each paycheck because I have made all my decisions already in my spending plan.
Theoretically I could spend all my spending money on Starbucks and not groceries, but I won’t. And if I did, it wouldn’t impact my ability to pay my bills.
loading....
using your categories, where would you include books or movies?
loading....
For me personally, there has been much less to track since I have set myself on a course to financial responsibility. I have far fewer purchases of little things that are hard to categorize (and justify).
As for your food questions, I don’t break it down by type of food, but rather where and how I intend to consume it. If I eat at a restaurant, stop and get fast food for lunch, or even just grab a few snacks while at a gas station, I put it under a category called Dining. If I go into a store and buy items that I intend to consume later, I call it groceries and put it under that category. Pretty much everything falls under those two categories. The point of my tracking is not to critique my diet (meat, dairy, produce) but whether I am spending more eating out vs. buying in bulk at a grocery store and preparing my own meals.
I think it is more important that you are tracking your money in some sort of accounting program than it is to classify every item absolutely correctly in it. I track every single penny. I’ll transfer 8 cents in pocket change between my wallet and my piggy bank after I pay cash for lunch. It seems a little ridiculous at first, but it becomes routine after a while. I know how much money I have in my piggy back to the exact penny.
loading....
There was a period of time (in college, after having bounced several checks because of a check register error), where I was using a combination of Quicken and Excel to track everything down to the penny. Like you, I had a cash category, as well as a piggy bank category, which I would adjust on a quarterly basis (literally dumped out my change jar and counted how much I had, then added/subtracted the difference). At the time, it was fun and it really helped me get into personal finance. After graduating and getting married, I no longer feel the need to do that, and have found less time-consuming ways to track my income/expenses.
loading....
DH and I have been using Excel and a Asset/Liability, Income/Expense system since grad school, when we had to track every penny.
These are our Expense categories (sorry for the length):
–MONTHLY–
Federal taxes
State and wage taxes
SS/FICA/Other taxes
Health/Dental
Tithing
Mortgage Interest
Escrow
Car Insurance
Gas/Electric
Phone
Cable
Groceries
Eating out – separated between DH and I
Car/Gas
Entertainment
–OCCASIONAL–
Sewer
Water
Trash
Pest Control
Lawn Care
Clothing
Haircuts
Housewares
Postal
Dry cleaning
Magazines
Office Supplies
Depreciation
Other
loading....
I try to think about what data I will need in the future, especially if there are life style changes. So when I buy groceries I do split it into food and non-food items. If I ever was able to garden extensively, I’d like to know if the food portion changed. Gardening wouldn’t affect toiletries so I split those out. Eating out is different than eating at home.
I use a lot of categories partly because I want to have a good record of personal inflation as I’m interested in early retirement.
I have a separate category for food bought at work because it’s likely money I wouldn’t have spent if I wasn’t bored at work.
For broader categories, I group “hobbies” together. This includes computers, video games, books, crafts, etc.
I also like tracking and find it easy. It’s easier because I use the credit card most of the time and also because most days I make no purchases.
For someone having difficulty, I agree – start with less categories. If Crystal hasn’t done this yet, I’d suggest even just starting with money in vs. money out. Technically this would give me the adequate broad picture that I want, just not the level of detail I think I might want in the future.
loading....
I have two food categories – Groceries (which actually includes things like cleaning supplies, toothpaste, shampoo etc. also) and Restaurants.
I keep my categories fairly broad (Transportation, Utilities, Housing) unless there is a reason I need to track something in more specific detail. I recently broke out gas from within transportation just to see what was happening with that over time.
Keep the categories fairly simple – really think about what it is you want to know specifically when you are setting them up. Do you need to know how much the family spends on clothes as a whole or do you want to know how much is spent on each individual family member? Or on Adults and Kids?
I have found that when I started tracking, I needed/wanted more detail and have been more comfortable with less detail as time has gone on.
loading....
I also agree that I have a hard time tracking detailed budgets… I switched the balanced money formula about three months ago with great success.
I’ve started using a lot of cash, so switched to tracking on Pearbudget. I keep all my receipts in my wallet and every couple days log them. I also think that it’s not the weekly or monthly number that really grabs your attention, rather the year-to-date or yearly number as a whole. It’s also nice to see how spending has changed–such as decrease in monthly gas or increase in food– or how much exactly you have left to throw at your debt.
loading....
I let my financial goals determine how I track spending. Approximately every six months and/or every life change (raise, move, etc.) I review my tracked expenses, review my financial goals, and then review my budget. The big goals and expenses are identified first: school loan pay-back, rent, utilities, savings goals, etc. Next come the other necessary expenses: food, “fun” (i.e. sanity money), and incidentals like clothes or office supply needs/books – I do research for a living. Finally, I do a quick check to see how much extra I have even after accounting for all this – needs, savings, wants – against my current fixed income level. Anything else I have I’ll throw around in the categories I feel like boosting (e.g., I want to buy more local food, so I’ll boost the food spending this time around to account for increased costs).
With these categories set, I revise my tracking spreadsheet to reflect the monthly allotment, with some automatic functions to aggregate spending in particular areas. For example, at the moment I have only one payment to rent, so I just plug it into that month’s cell. However, I buy groceries from more than one place more than once a month, so I write down those exact amounts farther down in some “scratch space” and have an Excel function tally up the spending in that month’s cell. Technically I write everything that I spend down onto the spreadsheet somehow, but my basic “view” is only of aggregated budget-category monthly spending.
loading....
Big pretzel jug for all paper receipts, ATM withdrawls or transfers. End of each week log the receipts, checks, electronic transfers, etc. into a spreadsheet of categories. Trash or hold receipts based on other needs (e.g. warrenty/item return). End of month roll it up. Did it hard core for two months. Looked at where the problems were, and focused on those. Helped to have an end date for the hard core tracking.
Eventually moved to using a whiteboard with monthly limits for four broad categories (Gas, Groceries, Entertainment, Miscl.) As long as we keep to the total for all four, we are meeting our goals each month. Within limits we can agree to move money among categories as long as the total for the four doesn’t exceed the max for the board. Major items outside the categories are met via the emergency fund or planned savings. Works for us.
loading....
Right now, I have only my own budget to worry about. But I like your whiteboard approach because I can see how it would help budget in a hosuehold of more than just one person.
loading....
i actually think it sounds pretty laborious and involves some significant time lags. it would be better to use linked accounts and mint. my boyfriend and i are able to coordinate our monthly grocery shopping this way. we get text alerts when either of us exceeds our per-person budget, and we let the other know by how much we are over. as soon as we get a shared credit card, this will be even easier–we can both get emails/text alerts when we exceed our mutual budget. i like this system because it’s basically completely automated, and travel/life won’t disrupt it.
is this household a family or cohabiting friends?
loading....
I believe it’s not worth it to track every penny you spent at all. It’s tedious, and you won’t stick to it.
I love this post from Ramit on cutting back on Lattes (substitute whatever little thing you feel guilty about spending money on for Latte here):
http://www.iwillteachyoutoberich.com/blog/save-on-coffee/
More effective I think is to automate your finances (e.g. have money towards retirement, mid-term savings, and paying down debt automatically deducted from your checking account 2 days after your paycheck is deposited). What’s left in the account you can spend however you want. It’s like the envelope system, only with one big envelope.
This is what I did about a year ago to seriously great effect.
loading....
I never could stick with it, so i’ve generally stuck with a “put a chunk in savings whatever is left over is for spending” method (or, conversely, a cash allowance for myself and when its gone its gone). But it’s good to track every penny for at least part of every year, to keep yourself honest and see things you might be missing otherwise.
loading....
To keep my spreadsheet compact, I keep only the running total for each category (as opposed to storing each transaction). So if I just spent, say, $20 on food, I’ll add the $20 to the running total as follows (in Excel 2007):
- type ’20′ into the right of the current month’s ‘food’ total cell
- click on the ’20′ cell and copy (ctrl-c)
- click on the food total cell, right click, type ‘s’, type ‘d’, enter.
- then delete the ’20′ cell
loading....
have you tried mint? this seems very time-consuming
loading....
I agree with the time-consuming part. Excel has a great feature (Pivot Tables) that will allow you to summarize your data so easily and quickly that once it’s set up, you’re good to go. Depending on your familiarity with Excel and willingness to learn new things, you can set up your own workbook, or you can download a template online. I don’t want to bog down this post with more technical details, but I urge anyone who is using spreadsheets to track spending to at least try it out and see if it will work for you.
loading....
We basically track two different categories – needs and wants. Then we subdivide each category, particularly the needs.
For us, that trip to the gas station falls into two categories, you need the gas – so that’s a need, (I don’t know what a gas treatment is so I can’t categorize that one), and a want – the Red Bull. We’d put the gas on a credit card and pay for the Red Bull with cash from our adult allowance.
Every need except our mortgage and our electric bill (which don’t allow for cc billing)go automatically to a single points earning credit card – this is how we track our need spending. When a need category gets too high, we see if we can get it lower.
The wants primarily come from our adult allowance each month, but we also have some ING savings accounts set up specifically for more expensive wants.
Our Emergency Fund is fully funded so each month any leftover money is apportioned among 4 ING subaccounts – car replacement fund (need), kids’ tuition (need/want), vacation fund (want), handmade breakfast nook (want).
Works for us. One big savings account made us overspend.
loading....
I don’t track except for occasional months just to check nothing’s gone out of whack, but I do the same needs/wants split and the same debit/cash method for it.
I don’t even ever go inside the gas station except for “wants” so it’s easy to put gas on the debit and a lottery ticket in cash. It’s harder at the grocery store, but when we had roomates we had a list of approved shared things that came out of the kitty and everything else was personal, so i did two checkouts for that anyway. The absolutely hardest place to do the split is a big box store like Target – so many wants look like maybe justifiable needs.
loading....
So true about the big box stores being hard to track. Truth is, I buy most of our socks and underwear from them while I’m doing my weekly grocery shopping. I just count all of that spending (even if it’s a shirt or pants) in the grocery category, which we need to keep below $900 a month. If we’re too close to that number, that stuff just doesn’t get purchased. I try to make any purchases like socks and underwear only when the items are on sale.
We do make exceptions to the practice of all big box purchases being groceries. For instance, when we bought new bunk beds at BJ’s those got their own line item in the monthly budget.
loading....
I use the same system as Rob at #15. Every payday I move a certain percentage of my pay to savings (after having my 401k taken out) and then whatever is left in my checking account is what I have to spend that month. It’s far easier than holding on to receipts and entering data about a 99 cent pack of gum I bought at the checkout stand.
loading....
I absolutely agree about complex systems breaking down. I love to write up budgets, but I never stuck to one until I started using Mint. I can play with the budgeted amounts all I want, and it automatically categorizes and shows me what I’m spending. I also like having budgets that “roll over” because sometimes it doesn’t make sense to budget $50/month for clothes when you really spend $150 once every 3 months.
loading....
I know this isn’t supposed to be about what tool we use to track our expenses, but the tool you use matters. When I used Quicken, I was able to track to a level of detail that I simply cannot now that I use paper and pencil. No way am I making separate pages for rent, utilities, auto repair, gasoline, clothes, vacation, etc.
Crystal should ask herself why she wants to track her spending in the first place. Does she run out of money before month and need to find the leak? Then she’ll need to use very specific categories. Is she trying to reach a savings goal by year’s end? Broader categories could suffice. When I was paying off debt. I wanted to throw as much as possible to that debt and tracking very closely helped me find extra money. Now my goal has shifted to growing savings. Savings gets “paid” first, then regular bills like rent, utilities, etc. I don’t worry too much about where the rest goes because I know my main money goals are taken care of.
loading....
Vanessa- you are correct with both reasons. I do have a goal of a new couch by the year end and on paper I seem to have the $, but in reality I have so many $ leaks that I use that $ and then some and I’m unsure *how* that happened. I must have a couple of tiny leaks adding up because aside from my weekday Red Bull I don’t *think* I spend any money!
loading....
Crystal:
Instead of tracking, pay the couch first. Set up an ING account for it and an automatic transfer: however much you need divided by however any paychecks are left before you get to your target date. So for instance if you need 2000 by the end of the year and you get paid twice a month like me, that’s $181 out of each of your next eleven paychecks.
You’ll still probably want to know where your money is going, but at least this way, you can be sure to save for the couch while you experiment with ways to track your spending.
loading....
mint + virtually exclusive use of credit cards. i check my spending every other day and get text alerts when i exceed budgets i’ve set for myself.
i don’t see how more complicated or labor-intensive systems are a good use of anyone’s time.
loading....
I track my expenses using Mint. I have thermometers for groceries, rent, bills, transportation and entertainment.
I keep things simple by putting everything that isn’t an ABSOLUTE MUST HAVE in Entertainment, and further breaking that down into gifts/movies/music/eating out/coffee/fast food/etc/etc/etc as I see, but if I become too lazy for that, I just tag it all as entertainment. It’s a pretty simple system, but it’s been working way better for me to just have one pot with $X in it than 6 different pots with amounts that add up to $X.
To answer some of Crystal’s questions: If it’s not purchased at a grocery store, it’s not part of my grocery budget. Period. I might flag dinner with a colleague as a business expense, but it still goes under Entertainment. For the trip to the gas station, I’d split it, so the gas would go under Transportation, and the rest would go under entertainment. Realizing that I could split up receipts into difficult categories made a big difference in how I kept track of things.
loading....
I use YouNeedABudget (YNAB) software. It allows you to create categories. I take my receipts or checking website and transfer my expenses to it.
loading....
We use a zero based budget in our house, and track every single purchase with an app called HomeBudget (http://itunes.apple.com/us/app/homebudget-with-sync/id306257910?mt=8). Syncs data between devices. Great for couples.
I resisted doing any kind of budget for years, but since we have started this one, we have never been more liberated. It feels like I’ve gotten a raise since we started it! And we never feel guilty about spending. Its in the budget!
loading....
I’ve been using quicken for years and years and I find it really helpful for reconciling spending. As far as tracking, I also use only a few categories. A couple tips I found that work well for me: 1) I don’t track any of my cash spending, instead I have a category “Weekly Cash” that I track for all ATM or bank withdrawals so I can understand what my cash usage is; and I have a very generic “Household” category that I track for most of the purchases at places like Target, Walgreens, hardware stores, etc.
loading....
My husband and I actually do track every penny we spend. We keep an Excel document with a list of spending in several categories, which aggregates up to a front page with an aggregated budget, which is adjusted slightly on a monthly basis. We use this same workbook but separate sheets to keep track of other things we need to: cash flow, gifts purchased, vacation planning, etc.
Categories are:
Transportation (Gas, maintenance, bus passes, bike repair)
Phone
Electric
Groceries (Everything purchased at a grocery store or similar except produce)
Restaurants
Clothing
Household (home/garden supplies, maid service)
Allowance (one for each of us for our spending money)
Miscellaneous (gifts, healthcare, charitable spending, other one-off items that don’t fit anywhere else)
Produce
The last category is the one I’m most proud of. We recently decided to make some changes and eat healthier, and one of the ways we’re doing that is by treating all produce as free. We still track that spending and overspending would deplete our vacation budget, but we can spend whatever we want on it without “going over”. Remarkably, this change hasn’t made much difference in our total food spending. When I start with a basket full of produce, I’m less likely to splurge on other things in the store, and I’ve found myself eating out less because I’d rather eat healthfully at home.
loading....
How much time does it take? I have done snapshot budgets in Excel but the folks we know who track every penny in it seem like they spend hours entering data every week (with one I sort of suspect it’s his version of “I have an important woodworking project in the garage”)
loading....
It takes a few minutes a day, plus 40-50 minutes at the end of the month, but that’s mostly because we tend to miss things and I compare it to Mint to double-check everything. If you’re more vigilant than we are, it would probably take 10 minutes a week and 10 minutes at the end of the month to review and set up the next month’s sheet.
Our data entry is very simple and only for our own use, not taxes or anything else. So we just enter the date, the place, the amount and the category. Place names and categories pre-fill in an Excel list if you’ve entered them before, and we frequently use acronyms.
Just as an example, here are the keystrokes I entered in my last entry:
7/6 tab W tab 4.13 tab P
WF (meaning Whole Foods) and Produce pre-filled from earlier entries.
loading....
That sounds totally manageable.
I do think our friend who spends hours every week just really likes dinking around on Excel instead of helping out around the house.
loading....
I make a different column for each category in a spreadsheet (with the most commonly used ones on the far left), then I put the amount spent directly in the appropriate column. Then you can have a sum at the bottom of each column to keep track of your total spending.
loading....
I collect every receipt, and at least once a week I will enter the receipts into a spreadsheet in Excel. I also track my checkbook and income in Excel. I lump together all grocery expenditures but have separate categories for ‘eating out’ and ‘wine/beer.’ I compare all monthly totals and keep a year-to-year comparison. I LOVE excel since it gives me the flexibility to grow and develop new categories of spending. Tracking every dollar has helped me understand how the little things can add up. Comparing spending to my income on an on-going basis also keeps me grounded in reality.
loading....
I created a spreadsheet that has the 7 main categories my spending usually falls into: debt, home, car, food, tithing, savings, and misc. At least once every couple days I enter my receipts, and I generally take receipts for everything. It was hard to do at first, but I’ve been doing it for over a year. It’s the main thing that’s stopped my overdrafts.
On the spreadsheet also are my current financial goals (pay off credit cards and save $3500 in my emergency fund). It keeps them fresh in my mind at all times.
I started using Mint, but something is wonky. It keeps telling me I’m $35K over budget for “misc” but there’s nothing that reflects that anywhere else, and I can’t find that miscellaneous charge anywhere in Mint other than the reports!
-j
loading....
I only track my spending if I’m creating a budget, or have begun to consistantly veer from my budget. After I create a budget though I already know what my spending limits are for certain categories which are: savings, varying essentials-food/gas, utilities, non varying essentials-insurances, mortgage, phone/internet, and misc/free money.
Needless to say, I don’t track, I budget. That’s the purpose of my budget.
loading....
I use a credit card for every purchase I can. I carry $40 in cash and frequently have that same $40 for a 4 months and never spend it. If they don’t take credit cards – I don’t do business with them (like McDonald’s did not take CC until a few years ago – I never ate there due to that fact). Each of my CC gives me monthly (online) and yearly (in the mail) details of my spending per location, etc. I look that over. I know generally I spend less than I earn (depends on the month) so I know I am ahead. I have 9 categories which are:
House (mortgage, repairs, upgrades)
Investments
Taxes and payroll deductions
Insurance
Cost Of Living (Utilities, phone, cable, internet)
Food
Kids (money given to my kids for school lunches and allowances)
Gifts
Travel/Vacation
Stuff (anything else)
If I start spending more than what I should in each of these categories (I have a number for each) then I look at the details. I do that monthly.
loading....
I use Moneydance to track expenses after using Quicken for years. We create categories that reflect items of concern.
For example, we’re pretty frugal and don’t shop much. But we’re very tempted by meals out. So I separate out groceries from dining out. Dining out includes quick carry out salads or sushi from the supermarket, though, because it’s not cooked at home.
For a while, my husband was getting out of control with junk food. So we created a category with his name and junk food.
Every year or so, we evaluate our categories and make adjustments so we can track what we are concerned with. It doesn’t help us compare information over many years. But it helps us focus on our concerns of the moment.
So I’d ask Crystal what she’s trying to learn about her spending. What data does she need to decide if she’s spending her money in places most important to her?
If your rent and utilities are very stable, or if you can’t do anything about them anyway, you could lump them together into a category called living expenses. Save the detailed breakdowns for things you find important — like a lunch because you forgot to pack one, lunch to network, or lunch to socialize.
You also have to realize that those of us who like to track expenses with a high level of detail and who put a lot of time into it, sometimes do it because our brains are wired that way. If you hate it, you might have to find another way of looking at the problem. Like setting aside the money in advance for a specific category and not bothering to track where each penny of your allowance goes.
In the end, you’re the only one who can decide what’s the best money management system for you.
loading....
As to your “brain wired that way” comment, I totally agree! During college, after some financial issues, I started tracking my budget in minutiae through Quicken/Excel. Excel was my favorite, because I could make it look however I wanted. I spent HOURS. I would wake up on Saturday morning and that was all I wanted to do.
Turns out, I have a real knack for spreadsheets, and I changed my career goal from a teacher to a bookkeeper, just on my love of Excel alone, without any education/experience. 4 years later, and I am loving my job and considering going back to get a degree in accounting. Who knew that the endless hours I “wasted” tracking my finances down to my piggy bank pennies would turn out to show me what I really am passionate about!
loading....
I’m trying to discover my $ leaks b/c in my head I’m hard core frugal, but if that were true I would not be wondering how my pockets are empty.
Also I’d like to see how my ‘lack’ of planning is costing me-like having to buy a soda at the zoo b/c I didn’t think ahead to pack one; or at the gas station I bought gas treatment for almost $5, but I know it is like $2 at Walmart…again with the planning. Maybe if I track every single little penny I could see those kinds of things?
loading....
Crystal, tracking every penny should tell you exactly where your money is going. And you can always do it religiously for a month, see what you learn, and then figure out where you want to go from there.
loading....
I use YNAB on the desktop and YNAB on the iPhone. This allows me to enter income or expenses at anytime. When I’m at the grocery store, I have the YNAB app running, and ready to enter in the expense and then I can sync it when I get home. I can also see my budget balances at anytime. It’s great while I’m on a trip.
But the question is more about how, not what tools. I think the easy thing to do is consolidate accounts. It can be a pain to track cash, two credit cards, and a debit card. Try sticking to just cash and one card to make expenses.
Create categories to track the trends. Keep it simple at first, and make it more detailed if necessary. For example, I track the main things like regular bills, and vehicle expenses, and living expenses. I live kind of minimalist lifestyle, so I have discretionary spending category. This covers clothes, gadgets, and whatever else I don’t buy on a regular basis. I make a note of what it is so I can review it later. If I see a trend of something I’m spending more money on than other items in that category, I’ll create a subcategory, for example, my vegetable garden.
loading....
I use BuckTrak.com; it’s free and has every bell and whistle that the average household budget requires.
loading....
I was happy with Mint/FinanceWorks (the mini version on my bank’s site) until one of my banks updated their online banking system and no longer integrates with Mint. With no way to import transactions via CSV or manually enter them, my Mint reports no longer show the entire picture of our spending. I don’t really want to go back to Quicken, and we’re not going to ditch the bank since they’re paying 2.5% interest on our checking account. Is there a Mint-a-like that allows importing from CSV or at least manually entering transactions?
loading....
Interesting to see everyone’s methods! I’ve done this for years using an Excel spreadsheet; I’ve considered moving to Mint but the current system works for me.
I have a few broad categories (Home, Utilities, Health, Food, Transportation, Childcare, Gifts, Entertainment, Clothing etc) and then subcategories under each depending on how granular I want to get. Lately I’ve also been defining each subcategory as either a “Need” or a “Want” (i.e., groceries are a need but restaurants are a want) and it’s been interesting to see what the overall split is (40% needs, 20% wants, and 40% savings if you’re interested
) But I’m admittedly nerdy about tracking this kind of stuff and realize the amount of time I spend would not necessarily be useful or informative for all.
loading....
Hi all,
After reading many replies, I do they they all can be effective. However, I try to keep it much simpler. I only use a debit card which is through my credit union. Every dollar spent is tracked and available on line to view. That is it. I look at it frequently to see where I am spending (of late it is gas and dinners out). For me it works great. NO special programs, keeping receipts, tracking categories, entering data in a website etc…
loading....
I use Moleskine monthly notebooks (one book a month–http://www.amazon.com/Moleskine-Month-Color-Daily-Planner/dp/8862937512/ref=pd_sim_b_21), mainly because they’re small, discreet and I like writing stuff with pen and paper (I’m old-school that way). Every Sunday I total the week’s spending in the following categories (good for single people who live in a city and rent):
FIXED EXPENSES
Rent
Debt repayment (student loan)
Health Insurance
Savings
Travel fund
Roth IRA
VARIABLE EXPENSES
Transportation
Food (Anything I buy prepared)
Groceries (Anything I use to make meals at home or work)
Personal care (toiletries, salon visits)
Clothing
Books
Entertainment
Gifts
Charity
Travel (gas, parking, tickets)
Subscriptions
Business (networking, etc.)
I’m sure I’m missing some categories, but that’s a good place to start and then tweak the categories according to your needs. I create a separate spreadsheet for each month, with a column for each week. I’ve programmed the spreadsheet to keep a running total of all expense so that even if I’m over my expected budget in one category, I make sure what I spend is less than what I earn.
Hope that helps!
loading....
I also like using pen and paper! Glad I’m not the only one. Something about writing it down in a notebook just makes it fun and interesting. Marks on paper.
loading....
I`m a pen and paper girl, too. Cheap notebook, pen, calculator. I tot everything up at the end of the month. The physical act of writing it down seems to help to jog my memory. Admittedly I am a one-person household so tracking is not complex.
My solution is actually an even-cheaper version of the budget binder used by Gail Vaz-Oxlade on her TV show. Represent, sister!
loading....
Hurrah for paper and pencil!!!
I use a slightly simpler form. I list fixed expenses and savings, and then I have an amount budgeted for all discretionary expenses (gifts, ordering out food, buying a candy bar, whatever…) If I have an unusual large expense that month, I pull it out as a separate line item so that I can see when I have irregular yet somewhat recurring costs that I need to plan for. I spend maybe 5-10 minutes each week balancing my checkbook and making sure that I’m staying within my specified budget. My favorite thing to do is to cross out my paid line items with a highlighter, so that I know I’ve taken care of them!
loading....
We do track every penny (or peso, in our case haha)
We have an Excel sheet with all of our monthly expenses (rent, dog grooming, cable, etc etc etc).
We do not directly track small purchases. Instead, we each have a weekly budget that covers our transportation, eating out, fun money, etc… so every week I know I’ve spent my $50 dollars. I don’t need to track individual items, just write on the Excel sheet that I spent my $50 dollar allowance for the week.
Same goes for groceries. We set aside $200 a month, and we spend it at the grocery store. No need to itemize since we’re ok with that amount.
It works well for us. We don’t have to write down daily purchases, just general allowances and monthly purchases. Since the whole Excel sheet is already formated, we only have to sit down for maybe 5 minutes a week to plug in numbers.
loading....
Oh, and we pay cash for everything and use the envelope system.
loading....
With grocery store expenses, we split out “groceries” (food and also non-food household stuff like detergents), “personal care” (tooth paste, etc.), and “kid stuff” (mostly diapers). That’s not too much detail to keep up with, but it’s enough detail to help us manage what we want to manage.
If we order a pizza and our grocery budget is getting maxed out, we’ll call it “entertainment.” If our entertainment budget is getting maxed out, we’ll call it “groceries.”
As JD said, track what matters to you. And build in enough flexibility so that the budget is a tool, not your master.
loading....
Before I was married and using Quicken I was a big fan of using Microsoft Excel to track expenses. You could do the same thing with a notebook though.
I was on the computer every day anyway so I just saved an excel spreadsheet document to my desktop with a tab for each month. I would just enter the cost and place I spent money that day when I was online.
After a month you have a list of all the things you bought if you remember to write it all down.
If you forget for a day or two (weekends I am not online much) you can look back at your reciepts or credit card statement online.
Many cards allow you to see the charges you have made online even before they send a bill. Sometimes within minutes of making a purchase.
If you prefer paper, just log everything after you make purchases in a notebook and look back at it later to determine if you want categories or more structure.
I think remembering what you spend and writing it down is really the hardest part. Especially with cash.
Some people like the automated functions of Quicken because it can pull in all your charges from the credit cards to show you everything together. I have found that Quicken is overly complicated and some credit cards do not allow the data to be sent to quicken until the statement is ready (BofA) and you have to wait a month to find out. Plus Quicken’s categories are named oddly.
Some people prefer to use money tracking apps on their phone, but I find that manually typing everything in on a phone at the point of purchase is more cumbersome than typing it into excel. But some people like to have the data with them at all times to look at.
So, I prefer excel over both Quicken, Apps and Paper methods.
loading....
I do almost the exact same thing, except my wife and I have a spreadsheet on Google docs. The whole thing is pre-formatted for the entire year. Then I make small improvements to the formatting/categories each year when I create a new one. After 5 years of doing this, my format is remarkably simple and useful.
I agree and I’ve found most of the apps and Quicken are overly complicated and you spend more time trying to use/configure/troubleshoot the app than you do tracking your expenses. Keep it simple!
loading....
Does anyone here travel for work and still track their spending? I travel periodically for work, but my expenses are paid via reimbursement, not per diem or company card.
I assume the easiest way is to create a catagory just for the reembursed expenses, then credit it when the reimbursement comes through. However, how does one handle the non-recipt expenses/reimbursement, such as milage allowances?
loading....
My partner just never enters the covered expenses (like plane tickets) into our personal budget.
Things like mileage, or internet for working from home, where the reimbursement is not linked to what we actually spend, I count the expenses as plain expenses (car, utilities) and the reimbursement gets lumped under income, with bonuses.
loading....
I do the same, just never enter reimbursed expenses at all. Since I have a home office I’m reimbursed for Internet, so I deduct that amount from my overall TV/phone/Internet bill. I also get reimbursed for my cell phone, so don’t have a category for that.
loading....
I use a corporate card primarily, so that’s easy enough, but cash purchases (generally tips) and mileage get reimbursed by direct deposit. Since mileage is so nebulous, I enter the tips under “Transportation” in my budget and then credit that category when the reimbursement comes through, which effectively wipes out the tips and gives us a credit for the increased costs of gas/maintenance.
loading....
I keep receipts in my wallet. Every evening or two, when I sit down to watch tv, I get out my pen and paper and write everything down. Yes, I have an old-fashioned system. I love it. I’ve been doing it for 23 years so it’s easy and simple for me. I’ve changed categories when I’ve felt the need to, nothing is set in stone.
loading....
I use excel and enter my reciepts daily as I am always on the computer for work. It only takes about 2 minutes a day and I track every penny. I started this year to see where my money goes and I was shocked to find out that I was spending $500 a month just on gas. My categories are:
Groceries (food only)
Dining Out
Dog
Utilities
Loan pmts (mortgage, student, car, etc)
credit card pmts
Household (toiletries are included here)
clothing/shoes
medical
entertainment
insurance
taxes
vehicle maintenance
fees (bank, library, etc)
charity
loading....
I’m confused by the category “credit card payments”. Does that mean extra payments to pay off past debts? If you are paying for most of the items in the other categories using the card (in order to get the benefits, not to purchase something you can’t actually afford), then you’ve already covered those expenses. Unless you mean payment on old debt being carried forward month after month then there doesn’t need to be a credit card category (I see you don’t you listing debit card or cash which are also just payment methods).
loading....
I don’t track my cash expenses at all. I just categorize my ATM withdrawals in Quicken as the expense category “Cash Expenses.”
Then I just try to minimize what I pay for in cash by using my credit card whenever possible (which I of course pay off each month). I can then remember what my spending is for based on the credit card transactions that I download into Quicken. This way I don’t have to write down or otherwise track what I spent money on.
loading....
I’ve been tracking my expenses for over two years now and I find that I only need about a dozen categories. Auto, business, clothing, dining out, entertainment, fees, food, gift, home improvement, medical, personal care, shopping and travel.
Personally, I track meals eaten out in one of three categories. If it’s my husband going out to lunch with coworkers, I track that as business. It’s good for him to build relationships at work and the culture of his business is to do that over lunch. Meals that we eat out with friends is counted as entertainment. Dining out is solely for meals where I didn’t have the foresight or energy to have something prepared at home. I like separating them this way because when I look at my graphs, I can get an idea of what was going in our lives at the time. For instance, our dining out bill skyrocketed when I was pregnant and had round the clock morning sickness.
I do not have a monthly budget for each category because that would make me crazy to keep track of. Instead I have a lump sum to spend on all these categories each month. It gives me the freedom to adjust our spending with our needs. So if I’m sick with baby, I dial back our home improvement spending. Or if I want to splurge on new clothing for a member of the family, I reduce our dining out for the month.
It took a few months to fine-tune my system. I think the best thing you can do is just jump in and start tracking, you’ll figure out what you need along the way.
loading....
I actually smiled when I read your 3 subcategories for eating out. For awhile, my hubby and I had 4 categories for eating out: His Fast Food, Her Fast Food, Fast Food (when we were together), and Restaurant (pretty much, any place a tip is expected). It was mostly to settle a bet, because each of us thought the other ate out more during lunch. Turned out to be pretty much even!
loading....
It shocked me a few years when I did indeed track everything. I was appalled at spending £50 in McDonald’s in one month. However until I really did break it down I hadn’t been aware that I was frequenting quite so much for a coffee here and there…
loading....
I’d like to respectfully suggest to Crystal that she quit fighting it and surrender to the suggestion of writing all her spending down. What works for her, and the benefits she experiences, will emerge over time. Each of us is different.
I record every penny spent in a small spiral notebook I keep in my purse. (this is easier for women due to the nearly constant presence of a purse!)
The recording is helpful to me because it keeps me mindful of my spending. I spend less frequently as a result. Not coincidentally, I have not had an overdraft on my bank account since I started this process. (a terribly irresponsible habit that hopefully is behind me.)
Writing down CASH is especially important. It’s amazing where that stuff disappears to. Parking meters? Tip jars? Girl Scout Cookie Sales? Yard sales? “Pass the hat” collections for your favorite beat poet at the coffee shop? (As a side note, if your cash is going toward something less than legitimate, you might have a bigger problem than GRS can address…!)
I have done this recording for years, yet only this week did I add up my totals for the first time, for two separate months–one winter month and one summer month.
I added them up on a piece of legal paper and it took about 45 minutes, and I did while I was watching Law and Order so it was time I would not have used any other way, anyhow.
Based on this I now have a budget direction. I was not emotionally ready to take this step until just this week. But the recording step prepared me for that and also kept things much more sane and orderly than they had been otherwise.
IT MADE ME FEEL BETTER!
Kinda like exercising and eating right even when I haven’t gotten on the scale to see if I am losing weight….
Categories? Each of us has our own. Live your life and write stuff down and over time your particular patterns will emerge.
Good luck to you Crystal!
loading....
HA! I *wish* I had a sin habbit like that…it would at least explain why I can’t remember where my money went…lol
loading....
My husband and I started tracking every penny a few years ago.
Our method is this: keep every receipt, make a voice message of the purchase. Later when we get home, record the purchases in record-keeping software of choice.
When we started we used google docs and would divide up the purchases in each receipt by category. One of the most frustrating things about going by the credit card statement alone is we’d know how much we spent at the grocery store, but not how much we spent on actual groceries versus cleaning supplies, random office supplies, etc. With the receipt all the information is in front of you. Also when I used quicken and credit reports I had a hard time getting my spend records to sync accurately.
I totally agree with the “start broad; add more detail as you go” idea. When we started we put purchases in categories that made sense. Household, Groceries, Utilities, etc. Gradually we add more detail.
A little over a year ago we switched to GNUcash, and a few months ago we switched to recording every item on the receipt. The hope is that in a few months we’ll have an idea of where we can cut our grocery spending.
I love our system. Going through receipts is theraputic. And luckily my husband likes doing this as much as I do, so I’m not doing all the entering myself.
Also, it’s helped with business bookkeeping. When I started my teaching business there was almost no learning curve for the accounting side of it.
loading....
Cash is magic. I withdraw an amount equal to whatever my fun money adds up to per pay period, and an additional $80 for food. If I need more than this, I’m not sure what I would do. I’ve never needed more than this. This is all based on doing this each time I get paid (not monthly like most people seem to do).
Then, I spend as needed, but never from card if I can avoid it. Without tracking exactly how much I spend, I already know that it will never exceed whatever I withdrew, so I’m safely within my budget.
loading....
When I first started tracking and budgeting 2 years ago I thought about using Mint.com. Also bought the Quicken program, but never used it. I decided to just use Excel spreadsheets since it’s a lot easier to adjust categories.
I track monthly. Before a month starts I draw up a Budget based on the last month’s data. 3 Categories (Needs, Wants, Savings), which contain all the rows of headings (Rent, Utilities, Groceries in Needs; Restaurants, Travel, and Date Nights in Wants; Roth IRA, Emergency Fund, and Wedding Fund in Savings). The Budget has 3 columns: Projected (from before the month started), Adjusted (to account for changes within the month), and Actual (how closely I adhere to the Adjusted column).
I also have a Register that I update daily, as a means to reconcile with my credit card and bank accounts (just like a physical check register).
And then comes my Summary, which I use to place the finalized data (from the Register), group into categories (from the Budget), create charts (gives me the big picture), and plan the next months Budget.
Budget = Goals, Register = Path to Goals, Summary = Results in pursuit of Goals to be used to plan/adjust next months Goals.
At first it took about 5/6 hours every weekend, but then I got smart about it and started doing it every day. Now it takes about 10 minutes in the evening while it shares the screen with the latest Hulu episode =P
Seems a bit crazy (my boyfriend just doesn’t get why I’d put so much work into tracking), but it’s pretty awesome being able to pull up my files for 2010 and see at a glance how much I spent on Car Maintenance for the year, Gifts in December, or Entertainment in the summer.
Personal finance is whatever works for you! I’m a single, 26 year old from Southern California, and I used this system to get out of 13k credit card debt in 1 year, and haven’t carried a balance since December 2010! Now I’m focusing on Savings and I’m so happy I put in the time to create my system in the very beginning.
loading....