Managing expenses on Google Spreadsheets – follow up

I wrote about managing expenses on Google spreadsheets earlier this week and offered to share a template. I was admittedly blown away at the response. Unlike other posts where I tend to hear from a few folks I’ve come to know well, long time readers sprang out of nowhere asking about the template (read: it was a delight meeting you all). It is no wonder good blogs on personal finance build up large and engaging readerships. Anyway, I digress.

As promised to those of you wrote in, please find the template here. You should just be able to download the Google sheet as an excel file on your computer or copy the Google sheet. Below are a few notes that might help.

First, I’ve added a few notes on the Google sheet to make the flow of sheets intelligible. The main principle at play is consciousness. We consciously enter every expense on the sheet using the “Sheets” app by Google. We also ensure we track all our subscriptions in one place so we’re being intentional about shutting subscriptions we don’t use. The yearly math sheet just ensures we have a macro view of what’s going on.

Second, we don’t use a budget anymore. The 2012 version had budgets – but, we shelved them a few years back. We realized that we don’t make frivolous spending decisions if we’re conscious about our expenses. So, we didn’t see benefit of the overhead involved with setting and maintaining a budget. That doesn’t mean we haven’t made dumb or and the occasional expense we’ve regretted. But, thanks to this sheet, we discuss it and aim to learn from it. Our biggest lesson from these reflections is to simply pause 24 hours before making a large expense.

Third, while there’s a tab for investments, we don’t use this sheet to manage it. We are fans of the app “Personal Capital” and use the free version to get an overview of how things are going. An important complementary document is a living document called the “Finance Thesis Sheet” that I’ve written about before. I’d co-created a “learnographic” a few years back that synthesizes lessons learnt on personal finance and investing – those principles, for the most part, inform our approach to investments.

Fourth, the paycheck sheet is a very lightweight version of the finance thesis sheet. We’ve tried to maintain conscious boundaries about how we think about our money. The key here is to assume we earn far less than we do, not increase our expenses as our income increases, and to make sure most money goes to longer term investment accounts.

Fifth, as you can tell, this is all (relatively) low tech. We’ve been recommended many fancier apps from time to time. But, the key feature of all these apps is that they do the work for us. And, that’s a problem where we’re concerned. We spend a few mins every week going through our accounts, talk about any anomalies, and look at trends annually to see how we’re doing. Doing the work to understand how we’re spending our money is a feature for us – not a bug.

Hope you find this useful. Look forward to hearing your notes and lessons learnt.

Things that do not scale – in business and life

On balance, growing our business requires us to do things that scale. We need processes, infrastructure, and systems that help us deliver value to hundreds, thousands, or even millions at a time. You may not want to over-think scaling as you find product-market fit – but, beyond that, businesses that succeed do a good job with scaling.

The dichotomy here is that our life and careers work the other way around. The more you obsess about scaling your impact, the less you contribute in the rooms you are actually in. The more you attempt to personalize, the less personal you are.

Deciding to not do things that scale means doing fewer things – but doing them in a way that is authentic to us. It means adding our brand of thoughtfulness to the emails we send. It means demonstrating our brand of extraordinary care to the folks we touch on a daily basis. And, it means writing those thank you notes.

Our contribution, and ensuing impact, on people are often determined by our ability to consistently do things that do not scale.

Investments and soap

I came across an intriguing quote on investments from a banker at Merrill Lynch- “I’ve always felt that investing is like a bar of soap. The more you handle it, the smaller it gets.”

It is both a powerful analogy and a great reminder that, when it comes to investments, doing nothing for long periods of time is a very powerful tactic.

Managing expenses on Google Spreadsheets

There are many personal finance tools that help automate managing our expenses with fancy graphs and stats on our expenses. Mint, for example, uses data from your credit cards to generate graphs about your spending across categories. Each of your credit card apps likely do so too. But, if you’re in it to be on top of your expenses, I’m still a big fan of managing expenses on a Google Spreadsheet.

I’d shared a simple Google spreadsheet template in a post on calculating expenses 6 years back. We still use an evolved version of that template (happy to clean up + share an updated version if it is valuable to you). And, managing our expenses involves entering each expense. This process has friction built into it by design because the friction inspires consciousness.

We get all the other benefits – we always know exactly how much we’ve spent across major categories. And, we have a wealth of historical data cut in a way that makes sense to us.

We recently compared notes on how we do this with a couple of friends and they tested the “old fashioned” spreadsheet approach as well. Their first reaction after switching was that their spreadsheet made them acutely aware of the areas where they wanted to minimize expenses. This is so true – it is effective to the point where you soon realize you don’t need a budget.

Every technology tool creator’s goal is to make our lives more convenient. But, it is on us to both find the right tools and add the necessary amount of friction to use these tools consciously.

And, as far as topics that are as important as personal finance go, the more the consciousness, the better the long term outcome.

The three main things

Before we wade into that ocean of email/messages on other communication tools and start working away on everyone else’s priority list, the first question for Monday morning is – are we clear about the three main things that will help us move the needle this week? 

It is okay if the three things evolve as we receive new information over the course of the week. It is also okay if we decide someone else’s main thing is more important than ours. It is just not okay to not have given our list of three things thought and definitely not okay to not have them written down someplace where they can be tracked.

In a workday with more communication tools than people we need to actually communicate with, the main challenge with getting things done remains the main thing. The main thing, it turns out, is to keep the main thing the main thing.

In the long run, everything else is gravy.

Germs and shields

Writing here every day for the past decade has inspired many changes – chief among them is a higher degree of awareness about my response to various stimuli. One application of this awareness is a better understanding of how I (/we?) fall sick. I call it the germs and shields theory.

The premise of the theory is that we face attacks by germs throughout the course of the year. But, we naturally shield ourselves from these attacks when we make good regular health decisions – i.e. when we sleep 7+ hours every night, eat healthy, keep good mental health via good mental food and company, and stay active. However, when we go through periods when our ability to do some of this and take good rest is stretched, our shields come down. And, when they do, the germs hit us with some combination of the flu, throat pains, and so on. (Note: every once a while, if the germs don’t get us, we can also become accident prone)

So, what should we do when the germs finally get us? I think there are two constructive steps.

First, take a break and get those shields back up. Someone once told me that falling sick is the universe’s way of saying – “Dude, take a break.” While the germs should naturally see to this, it is worth putting a stop to any kind of work, switching off, and recovering. The more we postpone the break, the longer our shields will be down.

Second, take some time to think about what caused our shields to go down and how we can reduce its occurrence. My goal is to keep such occurrences to once per year. Such periods of frenetic activity are often not in our control. But, every once a while, we can walk away with powerful insights about changes in our operating model. Dealing with these issues now go a long way in preventing bigger issues in the future.

For example, my latest “shields down” moment is a direct result of not changing a few things as we settle into life with two kids under two.  Making it a habit to take a personal day off every few weeks to just sleep in, get some admin done, etc., has never been more essential.

Simple actions can go a long way in helping prevent issues. And, as far as our health goes, the old adage – prevention is better than cure – is spot on.

RSS and Feedly

“In the middle of all of this, Wired’s Article It’s Time For An RSS Revival caught my attention. I’ve been using RSS continuously for over a decade as my primary source of information. My current feed reader is Feedly, which I think is currently the best in class. It’s one of my primary sources for information that informs me, is private, and allows me to control and modulate what information I look at.

While RSS has disappeared into the plumbing of the internet, there’s still something fundamental about it. Its durability is remarkably impressive, especially in the context of the lack of the evolution and perceived displacement of the protocol over the past few years.”

The above paragraphs were from venture capitalist Brad Feld’s post on the wonderful RSS protocol today. Thanks to Google Reader and Feedly, I’ve found myself grateful to RSS nearly every day over the past 8 or so years.

I only read blogs on my Feedly (no news sources). As a result, opening up my Feedly generally feels like sitting down with a cup of coffee with a friend. While I look forward to my daily dose of Seth in the morning, Feedly is also how I’ve gotten to know those of you blog + write in from time to time. I look forward to posts from Arthur, Ashwin, Barry, CarolEfesa, JanaMarvin, Mary EllenMikePaul, RyanShishir, Steve, and Zac – among others who’ve since stopped writing. :-)

The RSS protocol has endured for almost two decades. I’m hopeful it will endure for many more.

A giraffe, elephant, and diversity

A giraffe built a home suited to his family’s specifications – with soaring ceilings and narrow hallways. The home also included a home-office. As he working in his office one day, he saw an elephant he knew passing by and decided to invite him to work with him.

The elephant gladly accepted. But, as he entered the giraffe’s home, he started breaking things. The hallways were too narrow and the stairs weren’t built to take the elephant’s weight. In response, the giraffe first made a few minor adjustments by removing a few bolts and panels.

But, he soon realized that the elephant was not suited for the office/house and began suggesting the elephant take aerobics and ballet classes so he could fit in. The elephant, on the other hand, realized that a house built for giraffes wouldn’t make sense for elephants without major changes.

The story is a great way to think about how we often approach the subject of diversity and speaks to the massive opportunity that lies ahead of us if he considered the implications of this parable.

Powerful.

(H/T: Thank you Stephen Weiss for writing in and sharing this)

Mastery – The Terry Laughlin summary

Life is not designed to hand us success or satisfaction, but rather to present us with challenges that make us grow. Mastery is the mysterious process by which those challenges become progressively easier and more satisfying through practice. The key to that satisfaction is to reach the nirvana in which love of practice for its own sake (intrinsic) replaces the original goal (extrinsic) as our grail. The antithesis of mastery is the pursuit of quick fixes.

I haven’t read George Leonard’s 1990s classic “Mastery.” But, I came across this synthesis of the book’s core ideas from legendary swimming coach Terry Laughlin and thought it was spot on.

The quote – “Life is not designed to hand us success or satisfaction, but rather to present us with challenges that make us grow.” – is a keeper. And, “The antithesis of mastery is the pursuit of quick fixes.” is one for anyone facing a tough challenge.

Contribution and Impact

“Your contribution is what happens when you’re in the room. Your impact is what happens when you’re out of the room.” – Matt Dunsmoor

This is a beautiful articulation and is one for all of us who hope to have a positive impact on the world. Contribution is the process that leads to impact.

And, in the spirit of focusing on process over outcomes, perhaps we ought to stop asking ourselves if what we’re doing is having an impact. Instead, the the question to ask ourselves is – “Am I making a positive and thoughtful contribution?”

If the answer is yes, it follows that we are doing our absolute best to create the impact we hope to create.

Of course, when we know better, we’ll contribute better.