Login
Financial Independence

Savings rate, FI number, and the path to freedom.

Retirement Strategies

Withdrawal plans, Roth ladders, and early access.

Investing

Index funds, asset allocation, and real estate.

Tax Strategies

Roth conversions, capital gains, and FI tax planning.

Earning More

Career growth, side hustles, and entrepreneurship.

Money Mindset

Beliefs, purpose, and financial psychology.

Health & Fitness

Exercise, nutrition, and mental wellness.

Expense Tracking Paper and Spreadsheet

Expense Tracking Paper and Spreadsheet

JoeQ17
JoeQ17 2,262 XP · · 9 replies

Writing down what we actually spend has been one of the most eye-opening habits we’ve ever built. It forces intentionality around where our money goes.

I’ve had a bunch of people ask about our expense tracking spreadsheet, so I figured I’d share (also includes our '25 monthly expenses, family of 4 from Atlanta). Huge shoutout to my wife, who started this before I met her. Because of her, we now have 17+ years of monthly expense tracking, which gives us a lot of confidence in knowing our true costs. It’s also been incredibly helpful in understanding our personal inflation versus headline inflation, as well as how our lifestyle has changed over time.

Our process: Each month, we use a printed sheet that sits on my wife’s desk. She handwrites expenses across about a dozen categories, updating every few days or catching up on the weekend from credit card statements. At month-end, she hands the sheet to me and I enter everything into the spreadsheet. No apps, yes takes 5-10min a week but forces understanding of where our money goes.

Every quarter or so, we review trends, look for meaningful increases, prepare for upcoming annual expenses (insurance, taxes, etc.), and forecast what future seasons of life may cost as the kids grow and eventually move on. For forecasting, I don’t try to guess inflation, I focus instead on real changes, like adding teen car insurance or reducing food and activity costs once kids are out of the house.

Feel free to take this, use it, and improve it, just make the categories fit your life. One key piece of feedback from my wife: less is more when it comes to categories. We used to split things like groceries vs. alcohol or home maintenance vs. toiletries. Fewer categories made it easier, no splitting receipts, just pick one and move on.

You could simplify even further into buckets like:

  • Home
  • Transportation
  • Essentials (food, healthcare)
  • Discretionary (self-care, eating out, travel)
  • Kids

There’s no perfect system; just find a level of detail you’ll actually stick with. Enjoy!

spreadsheet screenshot.png

processed-FF0E65E3-A4A8-49E8-879F-15BC2FDD80AD.jpeg

Share
Share on Facebook
Share on X
Share on Reddit
Share via Email
Copy link

What's your savings rate right now?

Your savings rate is the single most important number on the path to FI. Find yours in 2 minutes.

Calculate Your Savings Rate

Replies (9)

alexmarcus

alexmarcus

2 months ago

I did this for eight years and it totally changed my life. I used an app called AndroMoney and exported the csv to do Excel magic on it.

It was still a lot of work and the app left something to be desired, so in February I decided to start on a mobile app of my own to improve the experience (and hopefully make it more accessible to others as a pradtice by making it visually appeling). It's coming out later this month and I'd be happy grateful for feedbadk if you or anyone in this thread would be interested in taking a look at it.

Not many people in my life who understand the value of manual tracking…just found this community recently and figured there might be some sympathetic ears. You can see a preview here:

22BWO

22BWO

62 XP

7 months ago

Hello all,

I'm new to the app but have been following Johnathan and Brad from nearly the first podcast. I think the back catalog was in the single digits when I started. I can remember the road I was driving on when they suggested a 50% savings rate.

Anyway, I began tracking my spending with a very simple method which I planned to make more complicated and accurate in the future. I figured if I start a adequate system I can modify and improve it later. After I few months of tracking my spending I realized I didn't need to complicate things. I was tracking what I needed, my spending over the month. No need to check if my eating meals outside of the house was growing vs meals in… That didn't matter to me. All that mattered was weather my income exceed my spending for that month.

Here was/is my guiding principles:

Track spending without categories or buckets. There is no good spending and no bad spending.

Using Vicky Robin's principal from her book Your Money or Your Life ask yourself was that worth it or not.

Ex: I spend $200 on a fancy meal was that worth the X number of hours to earn that money? If it was continue, if it wasn't either make the meal better (invite friends) or don't order that particular meal again and possibly have friends over and cook on the grill next time.

I further simplified the system my only tracking to the dollar. I round the cents down if an item is X.25 or under and up if the item is X.26 or over.

Because I automated my savings and always pay off the credit card each month I had no need to calculate interest payments. I simply record my purchase when made.

Ex: using my credit card I spend 30.26 in gas for my car. I record the purchase on my phone in the gas station parking lot:

Car gas. Date. $31.00

I use the pre loaded Google sheets which tallys the totals for income and spending. I use a different sheet per month and lable with and month and year.

After the first few weeks of tracking my spending I became aware of where my money was going. That is what allowed me to dramatically increase my savings rate without much hassle.

I look forward to reading opinions on my system. Thought or ways to improve it.

–Don

JoeQ17

JoeQ17

1,527 XP

7 months ago

whatever you're able to stick with can work. Make things as simple as possible, but no simpler!

Key thing is the awareness of where money is going, not to say spending on one thing vs another is good or bad. I've switch over time from tracking to the dollar to nearest $10 in categories and ultimately the nearest hundred or so each month is close enough.

Tracking via categories or buckets I do think is very helpful especially if you're younger and going through the changes of family life as certain buckets will stay more stable and certain ones will grow and shrink as kids grow and then eventually leave. The categories have helped a lot forecast where expenses will be once kids are in college which is what i focus on for retirement spending (not what we spend today).

klcbaking

klcbaking

8 months ago

Q: Do you have any more formal process for discussing this with the family/kids?

I've adopted this monthly spreadsheet to support our family dialogue around money. We're not trying to decrease spend, I just want them to know what's happening invisibly with all the automatic bill pay. I print out my version (included image), put it on the fridge and occasionally pull it down to add expenses and discuss. I'd love to hear if anyone has a system/regular timing for talking about it with the fam.

JoeQ17

JoeQ17

1,527 XP

7 months ago

Way to go! No formal process. At the end of the month I take the sheet and input into the spreadsheet and share anything of interest with my wife during our weekly meeting (more of a scheduling meeting with coffee for the week). And then we openly talk about money with our kids, which often happens over dinner table discussions. And at the end of the year i update projections based on yearly spend and we discuss then as well if anything changes.

I've heard others that do monthly family meeting to discuss things like this as well, especially for bigger spends like vaca, events…

Interested to hear how this works out for you.

jgordon1970

jgordon1970

18 XP

8 months ago

I guess that since I'm more a tech guy that I'd prefer to use an automated software product to group and categorize all my credit card items, bills paid through checking account, etc. I'd rather not spend or waste time manually tracking it monthly on a calendar and then manually enter it into a spreadsheet each month. That sounds like torture to me but hey; you do what works for you ! You atleast have an idea where you money is going where I really don't have a clue yet because I haven't implemented an expense tracking system yet. It is on my 2026 list of goals to accomplish. I did a quick ChatGPT search and it came up with a few different automated options. I know Ginger or Brad or somebody on the Podcast mentioned Monarch for expense tracking but that didn’t show up in my ChstGPT search. I will have to research Monarch. For $79 a year, ChatGPT is leaning towards using or trying out Tiller Money as I don't mind using Excel to customize my budgeting and expense tracking. Below is my ChatGPT links showing my search and the results I received. I also found the Empower website and they offer a free online account linking, expense tracking and net worth calculator. I might try that one first since it is free. See my 2nd ChatGPT link for links and comparison of various expense/budget tracking options out there.

chatgpt.com

JoeQ17

JoeQ17

1,527 XP

7 months ago

any of these systems can work. the manual part of writing it down is very powerful vs just seeing the numbers at the end of the month. Yes it's a little bit of time 5-10min a week, it's meaningful.

That said any tech version can work, just take the time to look at it, have gpt analyze it, to know the individual expenses so you can reflect on what was worth it and what wasn't something you valued. It's that reflection that makes things stick and help take further action.

SomeSunnyDay

SomeSunnyDay

590 XP

9 months ago

We do a hand written pull from credit card statements and there is something pretty powerful about actually having to write it out instead of typing it. A surprising benefit was having my kids help do the adding up of the totals for categories. Some math by hand and the big numbers with an actual physical calculator. They feel important and likely are picking up some ideas about using the tool of money. Planning on updating spreadsheets to include some more of the paper info.Thank you for sharing!

JoeQ17

JoeQ17

1,527 XP

9 months ago

Very cool with having the kids help. Both for the math challenge as well as the early money lessons.

j-in-vancouver

j-in-vancouver

143 XP

9 months ago

Appreciate the support for hand-done budgets. My partner and I also did budgets and expense tracking in paper or modified excel for a decade or so. It gives you such a feeling of power and control (if you have the patience for this kind of thing).

We also used the cash envelope approach when we really needed to cut costs, though I don't know how feasible that is now.

Smaller categories that everyone understands helps so much for year over year comparisons. Bigger buckets makes staying in top of monthly data entry much easier to do, and you still get plenty of detail. Nice work on this, you two!

Showing 6 of 9 replies

View all replies on Community

Comments

Your comment will be posted after signing in
Join the Conversation

Create an account or sign in to post a comment.

Spending Smarter

Cutting costs doesn’t mean sacrificing quality of life. This guide provides actionable tips to lower your expenses, from mindful spending and frugal hacks to optimizing big-ticket items like housing, food, and transportation.

Spending Smarter Guide
Spending Smarter: Keep More of What You Earn

Read our complete guide to get up to speed.

From a Recent FI Weekly
“If you’re at Fidelity investing $500/month into a Vanguard mutual fund, you might be losing almost 10% of every contribution before it’s even invested.”

Plus more counterintuitive insights, real stories, and actionable strategies — every Tuesday.

Join 87,000+ people. Free. Unsubscribe anytime.

Track Your Progress to Financial Independence

Get your personalized FI number and track how close you are to reaching your milestones. Most members are closer than they think.

Personalized FI number calculation

Track progress to Coast FI & full FI

Live dashboard updates as you hit milestones

or

100% free — no credit card required

Account created! Redirecting...

Try searching for

⌘K to open anytime

Where Are You on the Path to FI?

1/3

Step 1 of 3

Which of these sounds most like you?

Scan to get the app

Point your phone camera at the QR code