Is this you? The Street reported this week that as female breadwinning grows, so does financial anxiety. They report that women tend to a) earn less than men and b) worry more about money than men and c) worry about retirement more than men. It would appear that money–duh–is gendered, or at least sexed. Nine out of ten women, they say, are the main support of their families at some point, and many women support themselves alone. Having some sense of what money you have, where it is going, and where you might change those paths to meet particular goals (so long, student loans), brings at least some sense of calm. My free Budget and Spend Spreadsheet is here to help.
I am the primary breadwinner in our household and my husband has fluctuating income as an adjunct professor (we should talk about labor exploitation in academia some other time, as well as women-as-breadwinners ). We’ve had some hefty expenses over the years—hello, front steps needing replacement; sick tree in front yard; kitchen reno we sloooowly did ourselves—but we never quite seemed to be getting ahead. Mind you, we are very, very fortunate; we’ve been extraordinarily lucky to live comfortably since I started my job in 2008. Even so, I was surprised that every year our balances seemed to be exactly where we started, and our credit cards were constantly in use, creating high monthly balances we paid off.
Where did the money go? I expect I’m not alone in my wonder here. Many Americans don’t keep track of their funds, and the stuff they buy—little and big—add up over time (google the “latte factor” –the idea that buying expensive coffee frequently is a money pit). Many Americans don’t budget, either. I was one of them, even after my financial adviser suggested doing so. Budgeting seemed like a pain to do, and it could bring up some painful truths I did not want to face. So I ignored her.
But ignoring my advisor’s advice and my own internal monologue telling me something could be better meant that I wasn’t making my money work for me. Spending it with no plan is fun sometimes (buying new front steps less so), but it came with an opportunity cost—that money might be put elsewhere, better used. I had no real way of knowing. Those Target runs might have added up to something more consequential.
Good thing I like spreadsheets.
I built this one originally for me in a much simpler form. This version features all the bells and whistles I’ve added in five months of working on and with it. William Buffet (evidently) once said that what you spend is what remains after you save (thanks, feministfinancier.com!). So let’s get a handle on what we’re actually spending. And maybe—if we’re feeling brave—consider a budget, so as to better save.
This Budget and Spend Spreadsheet allows you to do both. It’s set up with pre-build categories for both expenses and income, so you can just punch in some numbers and get rolling. It’s also got blank spaces for new items. That’s just the main sheet. Subsequent sheets are set up for each of those expense categories; you just punch in the number you allowed on sheet one at the top of each subsequent sheet and enter your expenses in that category as you go. For example, there’s a sheet for dining out. Say you allot $5k/year for that (you crazy minx, you)—you put that number in at the top and fill in the rows as you go and it does the math for you, allowing you to see what you have on balance to spend.
I like spending down. Beats spending up.
If you run out of rows, you can always add some with the edit function. Then copy the last cell that contains a number derived by the formula (that is, the last one that math-ed correctly), copy it, and paste it into the new boxes below. That’ll keep your math going.
The very last sheet is a net worth sheet. This is a fun little element that lets you track your net worth over time. Net worth, simply put, is assets minus liabilities. On my own personal sheet, for example, I have our house as an asset with its approximate value (somewhere in between Zillow and the town’s recent revaluation) and what we owe on it as liability. The difference between them isn’t just equity, it’s part of your net worth. There are areas for 401k balances, bank accounts, student loans, car loans, the whole kit and caboodle.
The sheet is entirely editable, so if you want it to have different themes, different topics, or math in different ways, you can adjust it for your own consumption. It contains a number of comments that will help you fill boxes in. Feel free to send any questions along to me as well at email@example.com.
If you talk about this spreadsheet—and please, talk about it, on your blog, your twitter, your instagram, whatever!—please link back. It’s creative commons copyrighted to me.
I’d love to hear about your progress! Let me know how the Budget and Spend Spreadsheet works for you.
Just a reminder: I AM NOT A FINANCIAL ADVISOR. You can take whatever I say with a grain of salt. I’m sharing what has worked for me, but that doesn’t mean it will work for you. I am not responsible for any action taken based on my posts.