How I Track My Money

When it comes to money management, I try to strike a balance between maximum simplicity and maximum effectiveness. I care where my money is going and how it is growing, but at the same time, I am not interested in tracking every dollar spent.

Instead of budgeting my money, I use a version of this sheet to track my income, spending, saving, and net worth on a monthly basis.

Read on for a breakdown of the Frequently Frugal Money Tracker and how you can put it to use in your own life. The sample numbers in the sheet are made up, but hopefully they will give you a sense of what this simple practice could look like for you.

If you are interested in the various bank/investment accounts and credit cards that I use, you’ll want to check out my How I Manage My Money post.

Income

A spreadsheet titled, "Frequently Frugal Money Tracker." The first section, "Income," is shown

Expected income

I currently have a line for my full-time job and one for the seasonal work I did over the winter. You could add more rows if you need to track a partner’s income, investment/retirement income (if you are actively collecting it), etc.

Other Income

I use the “other” row to track miscellaneous income, such as a work bonus or a tax return.

P.S. Check out this post to learn why a $200 tax return may sound small, but it’s actually ideal!

Spending

The second section of the "Frequently Frugal Money Tracker" spreadsheet, "Spending," is shown

As you can see, my approach is mostly to track which accounts I’m spending from rather than what I am actually spending the money on – although there are a few exceptions (see below for the breakdown). You will want to add, subtract, or modify as needed to reflect your own spending.

It may seem odd to include reimbursement lines (which are removed from the monthly totals). You may choose to remove these, but I split costs with friends and get reimbursed for work expenses often enough that it makes sense to factor into my money tracking. I used to include these reimbursements in my “other” income line, but it’s not really income! These costs show up on my credit card bill or come out of my bank account as if I purchased, say, an entire pizza, when I really only paid for my own portion and was reimbursed for the rest. That’s why I choose to track this as spending that didn’t really happen – rather than tracking it as spending and income.

Credit cards

I typically pay for things with a credit card as long as there isn’t a fee for doing so. Then, once my statements are posted, I pay my credit card bill(s) from my checking account.

I like to track how often I am using each card, so I record each credit card statement separately rather than including the bill payments in the “checking” row.

Savings & checking accounts

I transfer money from my checking account to my investment accounts, but I don’t consider this to be “spending” money. Instead, I track this in the Contributions section (see below).

Because it is rare for me to pay for things directly from my bank accounts, I make note of any miscellaneous spending from those accounts. Venmo, Lyft, and Uber, for example, are linked to my checking account, so I note those expenses as they occur.

Monthly “squaring up” with a partner/roomate(s)

While Hans and I share many expenses, we find it important to have our own separate financial lives – at least for the time being. Anytime one of us pays a bill, goes to the grocery store, covers the cost of a restaurant meal, etc., we record the expense. At the end of the month, we tally up each of our expenses and make up the difference with a Venmo payment.

When I reimburse Hans it comes from my checking account, but I include these “squaring up” reimbursements separately so that I can track them over time (just like my credit card payments).

Contributions

The third section of the "Frequently Frugal Money Tracker" spreadsheet, "Contributions," is shown

Check out the “Investment Accounts” section of my How I Manage My Money post for a detailed breakdown of the types of investments I have and how I allocate money between them.

Taxable investments

This is where I track my two taxable Vanguard investment accounts.

Retirement investments

My retirement accounts include my Roth IRA and my employer sponsored account.

You’ll notice that I include a separate row to track what my employer is contributing on my behalf. I include this in my monthly contribution totals because it is my money, even if I’m not the one making the deposit!

Active saving

I have one joint savings account with Hans, which we contribute to monthly to save up for our next house. If you are actively contributing money to a savings account to build an emergency fund, travel fund, etc., you’ll probably want to include your contributions to those accounts in this section.

I don’t include my other bank accounts in the Contributions section because I am not actively using them to save up money; instead, money goes in and out as needed, and I try to keep their balances relatively stable month-to-month.

Debt

If you have debt, you can dedicate a row for each source of debt (student loan, car loan, credit card debt, etc.) so that you can track your monthly payments.

I have this set up the same way that I handle credit card spending and my monthly “squaring up” with Hans. If you have a car loan, for example, the sheet is set up for you to have a “car loan” line in the Contributions section and record your monthly car payment there instead of including it in your “checking” line in the Spending section.

Net worth

The fourth section of the "Frequently Frugal Money Tracker" spreadsheet, "Net Worth," is shown

This is where I track how much money I have! At the end of every month, I record the ending balance of each account. If you have debt, the debt balances will be subtracted from your total net worth.

To match the other sections of the spreadsheet, the rows are broken up into the following categories:

  • Taxable Investment Accounts
  • Retirement Accounts
  • Active Saving Accounts
  • Checking/Savings Accounts
  • Debt (negatively impacts net worth)

Monthly summary graph

A graph showing monthly income, spending, contributions, and net worth data

I like visuals. Sure, I can look at the totals in each of my sections separately, but I like the way that the graph and the section summaries bring it all together in one place.

As you can see, I have included a bonus line for tracking Net Savings (income – spending). This allows me to see how much of my monthly income was left over after the month’s spending, and compare it to the amount that I actively contributed to my various savings/investment vessels. If you have debt, you may wish to include a line that separately breaks this out, as well.

I’ve chosen not to include my net savings in the graph to keep it simpler, but feel free to customize it however you like!

Steal my sheet

Get Access to the Frequently Frugal Money Tracker

Get access to the same spreadsheet I use to keep track of my money - quickly and easily - every month.

    I like content related to:
    We respect your privacy. Unsubscribe at any time.

    I sincerely encourage you to try my money tracking method for yourself!

    Here’s how:

    1. Enter your name and email address into the box above (or click here)
    2. Open the sample spreadsheet
    3. Click File > Make a copy
    4. Customize it to your liking and remove the sample data
    5. Get tracking!

    When the year is over:

    1. Right click the “2021” tab and then click “Duplicate”
    2. Right click the new tab and then click “Rename”
    3. Call it “2022” – or something else if you’d rather
    4. Keep tracking!
    Need help setting it up? Email me.