Skip to content
The title slide and first slides of the Money Owed to Me Tracker template

Money Owed to Me Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Lending money is easy and collecting it is awkward, so it helps to have the facts ready. This money owed to me tracker keeps one row per loan on the Debtors tab: who, what for, when it was lent, the amount and the due date. Payments received are added up from the Payments tab, which lets the sheet calculate the balance and the days late, then give each loan a status of Open, Paid or Overdue. The Overdue tab adds up the totals and groups unpaid loans by age in a column chart.

The six sample loans cover a borrower who is paying in installments, one who is long overdue, one just past due, a loan not yet due and a loan paid in full. Because payments match on the borrower name, a repeat borrower needs a different label for each loan. Days late grows by itself each day, so open the file before you send a reminder and you have the exact figure.

Useful for

  • Keep a list of personal loans and who has paid
  • Show a borrower the payments received and the balance remaining
  • See how much money is more than a month overdue

What's included

  • 4 tabs: Debtors, Payments, Overdue, How to use
  • Debtors: a table
  • Payments: a table
  • Overdue: a dashboard with 5 summary figures
  • 2 charts that update as you type
  • 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 Debtors 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

How do I track money someone owes me?

Record the borrower, the sum lent, the loan date and the due date, then log each payment you receive. The balance is the amount lent minus payments. This sheet works that out and flags overdue loans.

How do I calculate how many days a payment is late?

Subtract the due date from today's date. If the result is below zero the loan is not yet due. The Days late column does this automatically and stays at zero for paid loans.

Should I put a personal loan in writing?

It is a good idea. A short written note with the amount, date and repayment plan prevents arguments. For large sums, ask a professional about the right paperwork.

  • #tracker
  • #money-owed-to-me-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…