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
- Person. One consistent name per person, not “Sam” one day and “Sam (work)” the next.
- Direction. Did you lend or borrow? Keep both in one ledger so you see the real balance with each person.
- Amount and currency. $25, or €20 from a trip. Never add different currencies together.
- Date. The day the money changed hands.
- Reason. “Concert tickets”, “October rent”. Months later, the reason is what helps you both remember.
- Due date, if you agreed on one.
- Payments. Each partial payment is its own line, with a date and an amount.
- Left. The original amount minus everything paid so far.
Three ways to keep it: paper, spreadsheet, app
| Method | Good for | Weak spot |
|---|---|---|
| Notebook | A few debts, a few people, if you like writing by hand | Easy to lose, you do the maths, not with you when you need it |
| Excel, Google Sheets | People who already live in spreadsheets and want their own layout | Slow to update on a phone; partial payments make it messy |
| Debt tracker app | Logging on the spot and seeing the balance per person | Pick 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:
| ID | Date | Person | Direction | Reason | Amount | Due | Paid | Left |
|---|---|---|---|---|---|---|---|---|
| D1 | 2026-10-05 | Alex | Lent | October rent | 400 | 2026-10-31 | 100 | 300 |
| D2 | 2026-10-12 | Sam | Lent | Concert tickets | 48 | 2026-10-20 | 0 | 48 |
| D3 | 2026-10-15 | Jamie | Borrowed | Uber and coffee | 18 | 0 | 18 |
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.
- Paid (cell H2):
=SUMIF('Payments'!B:B, A2, 'Payments'!C:C) - Left (cell I2):
=F2-H2 - Balance with Alex:
=SUMIFS(I:I, C:C, "Alex", D:D, "Lent") - SUMIFS(I:I, C:C, "Alex", D:D, "Borrowed"). A positive number means Alex still owes you.
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
- Record it when the money moves. Leave it till tonight and you forget the reason; leave it a week and you forget the debt.
- 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.
- Log partial payments. Don't change the original amount; add a payment so the history is there if you need it.
- Mark it settled, don't delete it. A paid-off debt is still useful when someone asks about it months later.
- 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:
- One page per person: every debt, every payment and what's left.
- Type 25 or 1.2k, pick a person, save. A few seconds.
- Partial payments, due dates and up to 5 receipt photos per debt.
- Each debt keeps its own currency, never added together.
- No account, no ads, works offline. Your ledger stays on your iPhone.
- Export a backup file that opens in any spreadsheet.