Use Google Sheets to build a free roommate expense tracker with a due date column. Add columns for Date, Description, Amount, Category, Split Type, Paid Date, Due Date, and Paid status. Enter sample data like rent due on the 1st or utilities due on the 15th. Apply a due date formula adapted from a Medium article on task management - note that Google Sheets functions like REGEXMATCH and WORKDAY remain compatible in 2026 based on ongoing platform support. Share via link with granular edit permissions for real-time updates, per Google Workspace.

Recommended Columns for Roommate Expense Tracker with Due Dates

Start with these essential columns in row 1 of your Google Sheet. They cover common roommate expenses like rent, utilities, groceries, and one-off reimbursements.

  • Date: When the expense occurred (format as MM/DD/YYYY).
  • Description: Item details, e.g., "Electric bill" or "Groceries from Costco".
  • Amount: Total cost, e.g., $1200.
  • Category: Rent, Utilities, Groceries, Internet, Reimbursement, Other.
  • Split Type: Equal (for shared costs), Reimbursement (for one person covering then getting paid back), or Income-Based. Use "Reimbursement" for expenses where one roommate pays 100% upfront and others owe 0% initially, as noted in an expensesorted.com blog post.
  • Paid Date: Date payment was made (leave blank until paid).
  • Due Date: Calculated or entered deadline for payment/reimbursement.
  • Paid: Yes/No dropdown to mark completion.

Example row for rent: 10/01/2026, "October Rent", $2400, Rent, Equal, , 10/01/2026, No.

Example row for reimbursement: 10/05/2026, "Alex's groceries", $45, Groceries, Reimbursement, , 10/12/2026, No.

These columns support equal splits (divide by roommate count), usage-based (e.g., higher utility user pays more), or per-person for items like shared meals.

Setup Steps for Google Sheets Roommate Tracker

Follow these steps to create the tracker.

  1. Go to sheets.google.com and click "Blank" to start a new spreadsheet. Name it "Roommate Expenses 2026".

  2. In row 1, enter the recommended columns from A1 to H1: Date, Description, Amount, Category, Split Type, Paid Date, Due Date, Paid.

  3. Format columns: Select Amount column (C), right-click > Format > Currency. Select Date columns (A, F, G) > Format > Date.

  4. Enter sample data in rows 2-5, e.g.:

    • Row 2: 10/01/2026 | October Rent | 2400 | Rent | Equal | | =formula here | No
    • Row 3: 10/15/2026 | Utilities | 180 | Utilities | Equal | | =formula here | No

  5. Add the due date formula in G2 and drag down:
    =IF(ISBLANK(F2), "", IF(REGEXMATCH(E2, "week"), WORKDAY(F2, REGEXEXTRACT(E2, "[0-9]+")*5), WORKDAY(F2, REGEXEXTRACT(E2, "[0-9]+")-1)))
    Adapted from a Medium article on automating task due dates. Assumes Paid Date (F) is the reference; "2 week" in Split Type calculates 10 workdays ahead (2*5), "5" calculates 4 workdays ahead. Test and adjust for your needs - Google Sheets REGEX and WORKDAY functions work in 2026.

  6. Add a summary in a new sheet tab named "Dashboard". In A1: Category, B1: Total. In A2:
    =QUERY(Expenses!A:H, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'", 1)
    From a relayfi.com blog example, where Expenses is your data sheet, D is Category, C is Amount. This lists totals like Rent: $2400, Utilities: $180.

Sharing and Permissions for Group Access

Google Sheets supports real-time collaboration - everyone with edit access updates simultaneously and sees changes live, per Google Workspace product details.

To share:

  1. Click "Share" top-right.
  2. Add roommate emails or generate a link.
  3. Set permissions: Editor (full changes), Commenter (notes only), Viewer (read-only). Granular controls let you restrict downloading, printing, or further sharing.
  4. Notify roommates via the share email or chat.

Use Editor for active trackers; restrict to Viewer if read-only suffices. Changes like marking "Paid" update for all instantly, reducing disputes.

Practical Workflows and Formulas for Tracking

Reimbursement workflow (from expensesorted.com blog): Log the expense with Split Type "Reimbursement", Amount as full cost, one roommate as initial payer. Once reimbursed, mark Paid "Yes" or add a note in Description like "Reimbursed via Venmo 10/10". For equal splits, calculate owed amount manually as Amount / roommate count.

Filter overdue items: In Dashboard A10:
=FILTER(Expenses!A:H, Expenses!G:G<TODAY(), Expenses!H:H="No")
Adapted from relayfi.com; shows unpaid items past due date.

Category totals: Use the QUERY formula above for summaries.

Budget warning: In a new column I (Budget Check), enter for utilities row:
=AND(C2>=200*0.8, C2<=200)
From relayfi.com; true if Amount is 80-100% of $200 budget (yellow conditional formatting: Format > Conditional formatting > Formula =I2 > Custom formula =TRUE, yellow fill).

Review weekly: Sort by Due Date column, check Paid status, discuss reimbursements. For rent due 1st, set recurring rows monthly.

Common Mistakes and When Sheets Are Enough

Avoid these pitfalls:

  • Forgetting to update Paid column or Paid Date, leading to double-counting.
  • Over-customizing formulas like due dates without testing on sample data - REGEXMATCH fails if text doesn't match exactly.
  • Poor permissions: Editors accidentally deleting rows; start with Commenter and upgrade as needed.
  • No backups: Download as Excel monthly via File > Download.

Sheets work well for small groups with under 20 expenses per month, low-conflict splits, and no need for automated payments. For larger groups or payment reminders, consider pairing with a simple note in the sheet directing to external apps, but a spreadsheet plus written rules often suffices.

FAQ

How do I calculate due dates automatically in the tracker?
Use the attributed REGEX/WORKDAY formula in the Due Date column, referencing Paid Date and terms like "2 week" in Split Type. Test on samples.

What split type works for one roommate reimbursing groceries?
Mark as "Reimbursement" - one pays 100%, others 0% until settled, per expensesorted.com example.

Can multiple roommates edit the sheet at once?
Yes, Google Sheets real-time collaboration allows simultaneous edits with changes visible live for Editor access.

How do I summarize totals by category like utilities?
Use =QUERY(Expenses!A:H, "SELECT D, SUM(C) GROUP BY D LABEL SUM(C) 'Total'", 1) in a Dashboard tab, from relayfi.com.

What if the due date formula doesn't work in 2026?
Verify REGEXMATCH and WORKDAY in a test sheet; Google maintains core functions. Simplify to =F2+7 for fixed days if needed.

Is this tracker good for tracking rent due dates?
Yes, enter rent monthly with Due Date on the 1st; filter for upcoming dates and mark Paid after transfer.

Next, duplicate the sheet yearly, agree on update rules with roommates, and keep receipts photographed in a shared folder.