Report this item to Etsy

Roommate Bill Splitter Spreadsheet, Shared Household Expenses Tracker, Split Rent and Utilities, Google Sheets + Excel

NowPrice:$3.14

Original Price: $3.49

10% off

•

Sale ends on November 24

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by Vantovault
  • Digital download
  • Digital file type(s): 1 PDF, 2 other files

Split rent, utilities and every shared cost between up to six people, see who owes whom, and settle up with a short list of payments.

I built this for shared homes where people move in and out mid-month and not every bill is split evenly. Every input lives on one Start Here tab with the instructions beside it, and the Overview tab shows the whole picture.

WHAT IT DOES
- Four ways to split each bill: Equal, Weighted, By day (fair when someone moves in or out part way through a period) or Custom
- Each person's balance: what they paid, their share, paybacks sent and received, opening balance
- Settle up: a short list of payments that clears every balance, to the cent (never more payments than one fewer than the number of people)
- Where the money goes: totals by category and a 12-month chart
- Row checks flag a missing payer, date or amount instead of quietly getting it wrong
- Refunds, opening balances and future-dated bills handled

CAPACITY
Up to 6 people, 300 bills and 200 paybacks per workbook. USD formatting.

WHAT YOU RECEIVE
- Blank workbook and a filled sample with fictional figures
- Google Sheets copy links in a two-page start-here PDF
- Excel .xlsx files (Excel 2016 or newer, Windows or Mac)
The Google and Excel versions do not sync. A free Google account is needed for Sheets. Desktop or laptop recommended for setup.

PLEASE NOTE
This calculates shared costs and suggested paybacks. It does not move money and is not a lease or legal advice. Digital download only; nothing ships. Personal use; please do not redistribute or resell.

Landlord splitting utilities with tenants? See my Landlord Utility Bill Splitter in the shop.

HOW IT WAS MADE
Made with help from AI tools. I designed it and checked every formula and source myself.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Item Tracker

Divorce Asset Spreadsheet

Listed on Oct 26, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Personal Finance Templates