So, the bill is shared between Jessica, Graham, and Alyssa. In this image, Tyler opted out of the grocery store run because he was away that week. If the bill is to be split equally, just click to checkmark the boxes of who is in on the bill. Step 4: Let the spreadsheet do the workīy selecting how to split as “variably,” you can enter percentages. In a 14 slice pizza, Tyler at 60%, Jessica and Graham each ate 20%, and Alyssa is at 0% – adjust your numbers accordingly. Well, you can variably split the bill using the drop-down menu then enter in the percentage attributable to each person. But what if Tyler demolished 8 slices from the large pizza and Jessica and Graham only ate 2? Alyssa wasn’t there that night. If everyone is using the internet, it could be an equal split. To add multiple rows, first select multiple empty rows and you’ll add as many rows as you’ve selected. Step 2: Fill in your shared expensesĭid your roommates share pizza recently? Do you all use the same internet connection? How do you buy groceries? Do you share a Netflix account? Enter in all the shared costs and if you need more rows, simply right-click (control+click) on the numbered row and insert row either above or below. Once you change the names in this row, it will auto-populate the “who paid” dropdown menu. How to use our roommate expense tracker spreadsheet Step 1: Edit the names of your roommatesĬlick into each cell and change the names to reflect the names in your household. It’s a Google Sheets, so click the file, then “make copy” and you can begin to edit. We built a roommate expense tracker spreadsheet to make this easy for you and your roommates. Using a simple spreadsheet is a great way for everyone to see who owes and who has paid what, and can prevent a great deal of misunderstanding and miscommunication. Some roommates might be late on their payments, some might feel that they didn’t use the internet as much as others and therefore shouldn’t have to pay the same amount.Ī roommate expense tracker is a convenient spreadsheet that allows you to clearly show the total bill cost, what each individual’s contribution is to be, and who has and who hasn’t paid. Unfortunately, that’s not always as easy as it seems. You might think that by living with three other people all you have to do is divide your bills by four, and everyone pays their fair share. So, living with roommates helps to ease the financial burden. Rent, food, hydro, internet, insurance, cell phone – you’ll undoubtedly be spending more money per month than if you were still living at home. There are a lot of expenses when you move into your own place. Good financial planning and using a roommate expense tracker can help prevent a lot of headaches.īy using an expense tracker, you can make sure that each roommate is properly contributing their share of payments for expenses, and help everyone stay on top of their finances. Poor communication regarding expenses and failing to properly track it can lead to a whole lot of unnecessary stress. Unfortunately, your roommates might not have the same financial prowess you wish to achieve. You might be aware of the value of money, and recognize it’s important to budget your expenses based on your income and savings. One of the most important life skills you’ll be developing is financial responsibility. No matter the circumstances, it’s an exciting change, as you’re going to be able to embrace your independence while at the same time putting those hard-learned life skills to use. These could be friends, acquaintances, colleagues, or sometimes even strangers. Chances are the first time you leave home, you’ll have roommates. Moving out on your own is a major life experience.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |