IOU Tracker with Due Date Column: Google Sheets Template Guide

✨ Community Finance

Published: May 5, 2026

Use Google Sheets to create a simple IOU tracker with a due date column. Start with these columns: Lender, Borrower, Description, Amount Owed, Due Date, and Status. Add the formula =$C2>=TODAY() in a "Due?" column to check if the due date has passed, as shown in Graphed's due date tracker guide. Apply conditional formatting to highlight overdue rows in red if the due date is past and Status is not "Complete." Use =SUMIFS to total amounts owed to or by each person, adapted from Simular's SUMIFS guide.

This setup helps roommates track utility reimbursements, travel groups settle trip costs, or friends monitor dinner splits without needing paid apps. Enter data row by row, update Status when paid, and review totals weekly. It keeps records clear for small groups handling under 20 IOUs.

Recommended Columns for Your IOU Tracker

Tailor columns to shared expenses like rent overpayments, grocery runs, or vacation deposits. Essential ones include:

Lender: Name of the person who paid upfront (e.g., "Alex").
Borrower: Name of the person who owes money (e.g., "Jordan").
Description: Short note on the expense (e.g., "Groceries Feb 2026" or "Uber to concert").
Amount Owed: Numeric value (e.g., 45.50). Format as currency.
Due Date: Reimbursement deadline (e.g., 2026-03-15). Use date format.
Status: Dropdown with "Pending," "Paid," or "Complete."

These columns track who owes what and when, making it easy to spot delays in roommate rent splits or group travel reimbursements. Add a "Notes" column for receipt links or payment proof if needed. Keep the sheet to one tab for simplicity.

Set Up Due Date Checks and Status Tracking

Follow these steps for automated checks, based on Graphed's due date tracker workflow.

Enter due dates in column E (e.g., row 2: 2026-03-15).
In column F ("Due?"), enter =$E2>=TODAY() and drag down. TRUE means not overdue; FALSE means past due.
For conditional formatting: Select rows 2-100. Go to Format > Conditional formatting. Set rule: If $E2<TODAY() AND $G2<>"Complete", color row red. This highlights overdue IOUs still pending.
In Status column G, use Data Validation for dropdown: Pending, Paid, Complete. For Complete, add strikethrough formatting: Select column, Format > Text > Strikethrough.

Update Status manually after payment confirmation via Venmo screenshot or bank transfer note. Review the sheet before group chats to discuss overdue items.

Calculate Totals for Each Person

Sum owed amounts by person using SUMIFS for multiple criteria, as in Simular's guide. Place totals in a summary section at the top or a separate tab.

Example: To total amounts owed to Alex (Lender in A:A, Amount in D:D):

=SUMIFS(D2:D200, A2:A200, "Alex")

To total amounts Alex owes (as Borrower in B:B):

=SUMIFS(D2:D200, B2:B200, "Alex")

For all pending only (Status in G:G):

=SUMIFS(D2:D200, A2:A200, "Alex", G2:G200, "Pending")

Adjust ranges like D2:D200 to fit your data. This shows quick dashboards: "Alex is owed $120 total; $45 pending." Recalculates automatically as you add rows.

Sharing, Updates, and Common Mistakes

Share via Google Sheets link: Click Share > Get link > Set to "Editor" for group input or "Viewer" for read-only. Assign one person as owner to avoid overwrites.

Update cadence: Weekly reviews, or before bills like rent. Add rows for new IOUs; archive paid ones to a "History" tab.

Common mistakes include version control issues like multiple files (e.g., "IOU_Tracker_v2_final.xlsx") or accidental deletes. Use Google Sheets' Version history (File > Version history) to revert changes. Avoid emailing copies; stick to one live link. For groups, set notification rules: Tools > Notification rules for row edits.

When a Spreadsheet IOU Tracker Is Enough

Spreadsheets work well for small groups with occasional shared costs, like roommates splitting utilities or friends settling a trip under 20 IOUs. They handle tracking, due dates, and totals without fees. Pair with a shared photo album for receipts.

Consider apps if you need frequent payment requests, automated reminders, or receipt scanning. Apps separate requesting from paying, but start simple: a spreadsheet plus group chat reminders often suffices. Save digital receipts and export to PDF yearly for records. If IOUs exceed 50 or involve complex splits (e.g., income-based), test a dedicated tracker.

FAQ

How do I adapt this for roommate rent splits?

Add a "Month" column for recurring rent. Use SUMIFS to total per roommate across months. Set due dates 7 days post-rent payment.

What if someone ignores the due date?

Discuss in group chat with total owed from SUMIFS. Suggest partial payments in Status notes. For ongoing issues, agree on group rules upfront, like auto-escalation after 30 days.