Skip to content
The title slide and first slides of the IOU Tracker template

IOU Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Small loans between people who like each other go wrong when nobody remembers the amount. This IOU tracker works in both directions. People lists everyone you lend to or borrow from, and shows what each owes you, what you owe them and the net. Loans holds each loan with a code, direction, amount and due date, and works out the amount repaid and the amount left, then labels the loan Open, Paid or Overdue. Repayments logs every payment against a loan code and fills in the name for you.

Six sample loans show the mix: concert tickets lent to a friend and partly repaid, a car repair borrowed from an uncle, a loan paid in full and two that are past due. Spell each name the same way on People and Loans, because the totals match on the name. Overdue loans turn red, which means a glance down the Loans tab shows who needs a friendly reminder.

Useful for

  • Remember who paid for what at a group trip
  • Track a family loan with a repayment schedule
  • Send a polite reminder with the right amount

What's included

  • 4 tabs: People, Loans, Repayments, How to use
  • People: a table with 4 summary figures
  • Loans: a table
  • Repayments: a table
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the People tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is the easiest way to record money lent to friends?

Note who borrowed, how much, on what day and when it should be repaid, then log every repayment. A balance column makes the amount outstanding obvious.

Should I write down small loans between friends?

Yes. A record protects the friendship because both sides can check the amount instead of arguing about memory. It takes under a minute per loan.

Can I track money I owe as well as money owed to me?

Yes. Each loan has a direction, either I lent or I borrowed. The People tab shows both amounts and a net figure for each person.

  • #tracker
  • #iou-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…