![roommate expense tracker excel roommate expense tracker excel](https://nomoredebts.org/wp-content/uploads/2020/08/excel-monthly-spending-tracker-3_2colm.jpg)
If you’re going to be using an Excel spreadsheet on a single workstation, then your roommates will have to be diligent about giving you their receipts. This allows them to access the spreadsheet and edit it with their expense line items. If you’re using a Google spreadsheet, you can share the spreadsheet by going to the Share tab and adding your roommates’ email addresses as collaborators. Step by step through the spreadsheetĬlick on screenshots to open a larger version in a new window. This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 License. Roommate Expense Tracker Excel spreadsheet download – shared-expenses.xls.This spreadsheet includes a template and four example spreadsheets that go along with the diagrams above. Roommate Expense Tracker – published Google spreadsheet.If you’re willing to mirror the download, please let me know! Hopefully my server doesn’t crash again with the Excel download. The rest of this post describes how to use the spreadsheet and includes links to view my open Google spreadsheet example and to download an Excel version. With a shared Google spreadsheet, each of us can go to Google docs and update the spreadsheet ourselves with receipts. In the old days, my roommates had to save, mark, and initial receipts, which I would enter into the spreadsheet and then print out each month. Now that we live with housemates again, I’ve resurrected the spreadsheet with the power of shared Google documents. Instead of writing a check for each item someone purchased, we settled our accounts monthly.
![roommate expense tracker excel roommate expense tracker excel](https://i.etsystatic.com/25331523/r/il/598b82/3256195320/il_1140xN.3256195320_h1ig.jpg)
This allowed us to visibly see what we were spending money on, equitably divide expenses, and consolidate paybacks. The spreadsheet was complicated enough so that it not only tracked items we all shared, but also allowed for tracking items that some people shared but not others. When I lived with four other roommates in college, I developed a roommate expense tracking spreadsheet. How do you keep track of it all without writing 800 checks to each other at a time? Let’s make this hypothetical scenario more complicated: Three of you share milk, but the other person doesn’t. You share occasional grocery and household items. For example, one person is in charge of writing the rent check, another person pays utilities, another person pays for internet access. The scenario: You live with roommates and share some expenses.