Advertising Disclosure

A Simple Spreadsheet For Tracking Shared Expenses

If you and your partner (or roommate) both pay for different monthly expenses, how do you keep things square? This spreadsheet handles the math for you.

Joint Expense Tracking SpreadsheetDo you share monthly expenses with a roommate or significant other but pay for them from separate bank accounts?

For better or worse, that’s how my wife and I split up our monthly expenses for the years we lived together before we got married and combined our finances. We had a joint savings account and credit card, but we didn’t get around to joint checking until after we tied the know.

We used to use a simple Excel spreadsheet that we emailed back and forth to figure out who owed whom—and how much.

By replacing the Excel version with Google Spreadsheets, we could both access and edit the same document from anywhere. That means it’s no longer just one person’s job to update the bills every month—with a Google Spreadsheet either of us can update the file as soon as we pay the latest bill.

This system doesn’t just work for couples, it’s perfect for roommates, too (who, arguably, will be more concerned about equally dividing living expenses than cohabitating lovebirds).

I’ve created a free, sharable version of this Google Spreadsheet for splitting joint monthly expenses. You’ll need a free Google Drive (formerly Docs) account to access it.

Important instructions

By default, you can’t edit the spreadsheet (lest you want all of us to see your monthly expenses). To start using the spreadsheet, you must save a copy first! Then you’ll be able to edit your copy. (You DO NOT need to request access to edit the spreadsheet. Just save a copy, and have at it.)

How it works

The joint expense tracking spreadsheet is very simple. For each month, you simply enter what you paid for in one area and what your partner paid for in another. The spreadsheet adds it all up and tells you who owes who what.

This spreadsheet is only setup for two people splitting expenses evenly, although with a little finessing it could easily accommodate any number of roommates.

To use it, simply change the expense categories to reflect your monthly expenses, enter what you spent on each category. The other person enters what her or she spent in each category and the spreadsheet automatically calculates how much you owe the other person or how much he or she owes you.

Published or updated on August 13, 2015

Want FREE help eliminating debt & saving your first (or next) $100,000?

Money Under 30 has everything you need to know about money, written by real people who've been there. Enter your email to receive our free weekly newsletter and MoneySchool, our free 7-day course that will help you make immediate progress on whatever money challenge you're facing right now.

We'll never spam you and offer one-click unsubscribe, always.

About David Weliver

David Weliver is the founding editor of Money Under 30. He's a cited authority on personal finance and the unique money issues we face during our first two decades as adults. He lives in Maine with his wife and two children.


We invite readers to respond with questions or comments. Comments may be held for moderation and will be published according to our comment policy. Comments are the opinions of their authors; they do not represent the views or opinions of Money Under 30.

  1. ShayC says:

    Thank you for sharing this! I was previously calculating expenses that I and my fiance share manually and it was a really long and exhausting process. This will save me hours of time!

  2. Lindsay says:

    You should check out when you get the chance. It allows you to automate a lot of that stuff by linking your bank accounts to a group profile.

  3. kathy says:

    I have been using google docs for my personal budget for about 9 months now and it has changed my life! When we purchased our home I immediately set up a spreadsheet for our shared expenses. This was so much easier than the random slips of IOUs. We have categories for home improvement projects (lowe’s, home depot, etc). Thanks for the post!

  4. David Weliver says:

    Nice work, Brian. Thanks for sharing. The income-sensitive allocation is definitely something that could be useful for a lot of people, I’m sure. I like that it calculates an 8-month emergency fund, too.

  5. Brian says:

    My wife and I use to do a sort of “ad-hoc” method of dividing up who pays for what (similar to your spreadsheet), but we came up with a different way that makes it so each person pays the appropriate amount of the joint expenses dependent on their actual income. I haven’t switched it to google docs, but I thought you might be interested in checking it out anyways –

    • Caroline says:

      Just came across this post – Brian, your link doesn’t work anymore. Any chance you could share it again with a working link? Would love to see what you came up with!

  6. Speak Your Mind