ADVERTISEMENT

I saved almost $2,000 just by tracking my money on a spreadsheet

I started tracking my money on a Google spreadsheet in 2017, and it inspired me to pick up writing as a side hustle. I loved seeing that "income" line increase, and the more I made, the more motivated I was to cut back my spending and watch my money grow.

woman using laptop
ADVERTISEMENT

I started tracking my money in 2017 using a Google spreadsheet template that I customized to my needs. The process was so motivating that it inspired me to start freelance writing on the side, because seeing that "income" line item increase every month kept me focused on bringing in more.

Now that I've been placing a heavy focus on increasing my income for the past year, I'm starting to get a bit, well, protective of it. I look around at my apartment and realize I have everything I need and plenty of other nice things as well. My car is only a year old and my laptop (my biggest revenue generator) is brand new.

With no major expenses on the horizon, I felt even more motivated to make the most of my discretionary income, so I decided to do a quick audit of my spending to see just how much tracking has helped me trim my output. It's a golden an opportunity to search for areas where I can trim even more.

ADVERTISEMENT

Restaurants, bars, and coffee shops. Though I love to eat out, tracking motivated me to plan ahead. I make weekly trips to the grocery store for fresh produce and weekly items, plus one big trip every four to six weeks for bulk items. The result? My restaurant, bar, and coffee shop spending has steadily creeped down.

In 2017, I spent $2,684 at restaurants, bars, and coffee shops. That is about $224 per month eek! In 2018, I trimmed it to $2,338, or $195 per month. So far, in 2019, I am averaging $191 per month. This is a decrease of $33/month not bad. But now that my long-term financial health has become more important than dining out, I imagine I'll be motivated to lower my restaurant spending even more.

ADVERTISEMENT

Home goods. This includes trinkets, decorations, furniture, rugs anything I pin to my "Home" board on Pinterest and lust after in HomeGoods. While I don't have a lot of expensive artwork or kitchen appliances, I do love browsing the throw pillows and bedding aisles. In 2017 I spent $1,076 on home items, mostly because I was furnishing a new apartment. But in 2018, I spent about half, at $580. This year so far I've spent $375 because, again, I moved apartments. Life changes do happen, but now that I know how expensive they are, I think twice before making big moves.

Transportation. This one is tricky because I've changed jobs and commutes, plus fuel prices fluctuate so much. But I want to give myself credit where it's due, and in this case I believe my actions have paid off a lot. In 2017, I spent $1,523 on commuting. (I put vacation travel on a separate line.) This $1,523, or $127 per month, included gas and train passes because, apparently, I like variety.

In 2018, that number became $686, or $57 per month. In 2019, I am averaging $51 per month. I achieved that decrease by getting a much more fuel-efficient car, cancelling my EZ toll-road pass and learning to drive the non-toll roads, and finding a day job that lets me work from home. On the days I do drive to the office, I plan errands around my commute. This shaves off time spent in traffic, since I do my shopping or exercising during rush hour instead of sitting in traffic. Most importantly, my home days are truly that I don't drive and I walk or bike around the city to avoid using my car.

Uber/Lyft. One of the nice things about going to bars less often is that I don't have to take so many Ubers and Lyfts. After a few years of tracking, I find I mainly use rideshares now when I'm traveling without a vehicle, but even then I prefer to use metros and subways when possible. I've learned the art of hauling suitcases through crowded metro stations, and I don't mind because I know how much I'm saving.

ADVERTISEMENT

In 2017, I spent $500 on rideshares, or $42 a month. In 2018, I spent $268, or $22 a month. In 2019, I have spent $30, or $4 per month. This is definitely my most drastic decrease in spending, but it didn't happen without some sweat. If you took a look at my phone's fitness tracker, you would see that those dollars turned into steps while taking public transport in places like New York City, Rome, Dublin, San Francisco, and DC.

There you have it. The power of accountability. Without setting any specific goals, I made these changes just by tracking my spending because I knew I'd have to look at it all on paper. Well, digital paper. And it saved me $1,911 between 2017 and 2018 with another decrease on the horizon for 2019.

Now that I know the power of tracking, I'll combine it with goal setting to manage my money even more effectively down the road.

Grow your money even faster with a high-yield savings account from one of our partners:

ADVERTISEMENT

See Also:

FOLLOW BUSINESS INSIDER AFRICA

Unblock notifications in browser settings.
ADVERTISEMENT

Recommended articles

10 African countries with the lowest inflation rates in 2024

10 African countries with the lowest inflation rates in 2024

Davido launches his label Nine+ in partnership with UnitedMasters

Davido launches his label Nine+ in partnership with UnitedMasters

Nigeria's economic ranking drops to fourth in Africa

Nigeria's economic ranking drops to fourth in Africa

Moscow inaugurates its House of Africa

Moscow inaugurates its House of Africa

The CBN justifies $2b billion loss in forex, dispelling Naira defense claims

The CBN justifies $2b billion loss in forex, dispelling Naira defense claims

10 best airports in Africa in 2024

10 best airports in Africa in 2024

10 most expensive cities in Africa in 2024

10 most expensive cities in Africa in 2024

Illegal money changers adapt to Zimbabwe's ZiG currency rollout

Illegal money changers adapt to Zimbabwe's ZiG currency rollout

Zimbabwe's ZiG currency printing contingent on reserve sufficiency

Zimbabwe's ZiG currency printing contingent on reserve sufficiency

ADVERTISEMENT