{"product_id":"roommate-bill-split-tracker","title":"Roommate Bill Split Tracker Spreadsheet","description":"\u003cp\u003eThis roommate bill split tracker is for shared houses and apartments where one person usually pays the rent and everyone else settles up later. Add the bills once, choose how each one is split, and the workbook shows every share and exactly who owes whom.\u003c\/p\u003e\u003cp\u003eSplitting the internet equally makes sense. Splitting the rent equally when one room is twice the size often does not. This file lets each bill follow its own rule.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Pick everyone or one person and their share lights up everywhere.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills a month:\u003c\/strong\u003e the household's bills, or one person's share of them\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEvery bill, split:\u003c\/strong\u003e each bill divided between roommates the way it should be\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSettling up:\u003c\/strong\u003e share, paid in, owes and is owed, for every person\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills against income:\u003c\/strong\u003e how much of each person's income goes on the house\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThree ways to split:\u003c\/strong\u003e what equal, by income and by room would mean for each person\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWho pays what:\u003c\/strong\u003e each person's share of the month as a ring\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe biggest bills:\u003c\/strong\u003e the six largest, with the chosen person's part highlighted\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eThree ways to split, chosen per bill:\u003c\/strong\u003e equal, by income or by room, from a dropdown on each bill\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eShares that move together:\u003c\/strong\u003e change one bill from equal to by room and every share recalculates, so the discussion is about the method rather than anyone's number\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA settle-up that says who owes whom:\u003c\/strong\u003e each share against what was actually paid, with owes and is-owed in separate columns\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWhat has not gone out yet\u003c\/strong\u003e this month, on its own line\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eStill a full budget underneath\u003c\/h2\u003e\u003cp\u003eTwelve connected tabs: Start Here, Setup, Accounts, Income, Recurring, The Split, Transactions, Bill Calendar, twelve monthly tabs, Annual Summary, Expense Breakdown and Dashboard. It takes up to six roommates with their income and room size, and 16 shared bills, each split its own way, with what each person pays in total on the summary strip. The worked example is four people on eleven shared expenses, with the rent split by room, groceries by income and the rest equal, and one person owed for covering the rent. It works for a student house, a flatshare or any shared house where you need to split bills fairly.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not just the dashboard, and both use the same formulas. Each comes filled with a worked example and blank, in Excel and in Google Sheets, so the whole house can use the rent split in the version they like.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eCan we use it in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan different bills be split in different ways?\u003c\/h3\u003e\u003cp\u003eYes. Every bill has a dropdown for equal, by income or by room, and every share recalculates when you change it.\u003c\/p\u003e\u003ch3\u003eHow many roommates and bills does it handle?\u003c\/h3\u003e\u003cp\u003eUp to six roommates, each with their income and room size, and 16 shared bills.\u003c\/p\u003e\u003ch3\u003eHow does it show who owes whom?\u003c\/h3\u003e\u003cp\u003eThe settle-up compares each person's share with what they actually paid, with owes and is-owed in separate columns.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both are included in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597871939678,"sku":"OPX-214","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/roommate-bill-split-tracker-01.jpg?v=1790833147","url":"https:\/\/opxviashop.com\/products\/roommate-bill-split-tracker","provider":"OPXVIA","version":"1.0","type":"link"}