Even
Language: English
Guide

How to keep track of money you lent or borrowed

Covered dinner, lent cash for concert tickets, chipped in for rent: keep it in your head and sooner or later the numbers blur. Here is what to record for each debt, a spreadsheet template you can copy, and five habits that keep it tidy.

Updated October 22, 2026

What a personal debt ledger is

It's a list of the money between you and people you know: who you lent to, who you borrowed from, what has been paid back and what's left.

It's not business bookkeeping. A personal ledger has a few dozen entries with people you see every week, so what matters is clarity: when someone asks “how much do I still owe you?”, you can answer at once, with the date and the reason.

What to record for each debt

Three ways to keep it: paper, spreadsheet, app

MethodGood forWeak spot
NotebookA few debts, a few people, if you like writing by handEasy to lose, you do the maths, not with you when you need it
Excel, Google SheetsPeople who already live in spreadsheets and want their own layoutSlow to update on a phone; partial payments make it messy
Debt tracker appLogging on the spot and seeing the balance per personPick one you trust; many make you create an account

Any of them works if you record right away and keep at it. A notebook you update beats an app you forget.

A spreadsheet template

Make two sheets. The Debts sheet has one row per debt, starting in column A:

IDDatePersonDirectionReasonAmountDuePaidLeft
D12026-10-05AlexLentOctober rent4002026-10-31100300
D22026-10-12SamLentConcert tickets482026-10-20048
D32026-10-15JamieBorrowedUber and coffee18018

The Payments sheet has three columns: Date, Debt ID, Amount. Each time someone pays part of a debt, add a row there instead of editing the Debts sheet.

These are Google Sheets and English Excel names. Some Excel languages translate function names and use semicolons between arguments.

Five habits that keep it tidy

  1. Record it when the money moves. Leave it till tonight and you forget the reason; leave it a week and you forget the debt.
  2. Say the amount and the due date out loud. “I'll send 400, pay me back by the end of the month” gives you both the same number.
  3. Log partial payments. Don't change the original amount; add a payment so the history is there if you need it.
  4. Mark it settled, don't delete it. A paid-off debt is still useful when someone asks about it months later.
  5. Review once a month. Five minutes at the end of the month shows what's coming due and what has been open too long.

Keep your ledger in Even

Even is a personal debt tracker for iPhone. It does the work above for you:

iOS 18 or lateriPhone Coming soonAndroid

See Even →

Questions

Spreadsheet or app: which is better?

If you already use spreadsheets and rarely lend money while you're out, the template above is enough. If you often cover things on the go, an app lets you log it on the spot and works out what's left.

Does a personal ledger replace a written loan agreement?

No. It helps you remember and compare notes. For larger amounts, both sides should have something in writing with the amount, the date and signatures.

Is Even free?

Yes. Everything for tracking debts is free. Even Premium is optional and adds sign-in, cloud sync and extra widgets.

Where is my ledger stored?

On your iPhone. Even needs no account and sends your ledger nowhere, unless you turn on Even Premium sync.