Personal loan recordkeeping
How to Track a Personal Loan Between Friends or Family
Keep one record for the loan and add every real payment as a separate dated entry. Keep the repayment plan beside that record—not in place of it—so you can always see what actually happened, what remains, and what is expected next.
The copyable template below works in Notes or a spreadsheet. If payments have already started, the free browser tracker can calculate the current state.
Use this when repayment is already understood. If it is unclear whether the money was a gift, a loan, or flexible support, clarify that first.
Actual record
- Jul 10 Loan started · 1,200
- Aug 1 Payment · −150
- Sep 1 Payment · −300
- Sep 15 Additional borrowing · +100
Current balance · 850
Repayment plan
- Expected payment · 200 monthly
- Next expected date · Oct 1
- Projected payoff · updates after real activity
- Plan last confirmed · Sep 15
Real activity updates the current balance. The future plan can change without rewriting the past.
Example amounts use one currency.
Use this guide for one identifiable loan
This guide is for one personal loan between people who know each other—a laptop purchase, repair, deposit, family loan, or another amount that will be repaid over time. It works whether you lent the money or borrowed it.
The arrangement can be informal, but repayment should already be understood. The purpose of the record is to prevent memory, messages, and payment notifications from turning into different versions of what happened.
| Use this guide when | Start elsewhere when |
|---|---|
| One named loan will be repaid over time. | It is unclear whether repayment was expected. Clarify whether the money was a gift or a loan first. |
| You need an actual payment history and a current remaining balance. | One tiny IOU will settle immediately and a note or message is enough. |
| Payments may be partial, early, late, or different from the expected amount. | Mixed expenses and repayments move both ways across the whole relationship. Use the Running Balance Calculator. |
| The loan has its own purpose, plan, or history. | You need legal terms, repayment enforcement, tax guidance, or a formal lending service. |
The core rule
Record reality. Plan the future.
A clear personal-loan record answers two different questions: What actually happened? What is expected next? Those answers belong together, but they should not be treated as the same thing.
A payment is an event. An installment is an expectation.
Only a real payment reduces the balance. A promised or scheduled installment shows what was expected, but it should never be recorded as paid until the money actually moves.
When one payment is smaller, larger, earlier, or later than planned, record the real event first. Review the future plan separately. That keeps the history honest without pretending that the original schedule still fits perfectly.
| Actual record | Repayment plan |
|---|---|
| What really happened | What is expected to happen |
| The loan started or a current starting balance was confirmed | A regular payment amount was proposed or agreed |
| The date and amount of each real payment | Expected installment dates and amounts |
| Additional borrowing or a confirmed correction | The next expected payment and projected payoff |
| The balance after each event | A future projection that may change |
| History that should remain visible | An expectation that can be revised without deleting history |
History records reality. The plan describes the future. The current status connects them.
Copyable template
Copy the two-layer personal loan record
Use this blank record in Notes, a document, or a spreadsheet. Keep actual activity in its own history. Keep the current repayment plan in a separate block so an expectation is never mistaken for a payment.
1. Loan snapshot
- Loan: [name or purpose]
- People: [names or labels]
- Direction: [who lent / who borrowed]
- Currency: [currency]
- Repayment expectation: [repayment agreed]
- Loan start date: [date]
- Tracking start date: [date]
- Starting balance for this record: [amount]
- Original loan amount, if known: [amount or unknown]
- Paid before this record, if known: [amount — context only]
- Status: [active / settled]
For a new loan, the starting balance is normally the amount provided. For a loan already in progress, use the amount that is definitely still owed when reliable tracking begins.
2. Actual activity
Add one row for every event that really happened.
| Date | What actually happened | Amount | Balance after | Note |
|---|---|---|---|---|
| [date] | [loan started / payment / additional borrowing / correction] | [amount] | [amount] | [optional note] |
Use the real date and real amount. Do not create a payment row for money that was only promised or scheduled.
3. Current repayment plan, if any
- Regular payment: [amount or no regular plan]
- Frequency: [weekly / every two weeks / monthly]
- Next expected date: [date]
- Projected payoff: [date or not calculated]
- Plan last confirmed: [date]
- Flexibility note: [optional]
This block describes the current expectation. It does not replace the actual payment history.
4. Current status
- Remaining balance: [amount]
- Total paid since tracking began: [amount]
- Last actual payment: [date and amount]
- Next expected step: [amount and date, or check-in]
- Last reviewed: [date]
Review this summary after every confirmed payment, correction, or additional amount.
Plain-text template
PERSONAL LOAN RECORD Loan: [name or purpose] People: [names or labels] Direction: [name] lent / [name] borrowed Currency: [currency] Repayment expectation: repayment agreed Loan start date: [date] Tracking start date: [date] Starting balance for this record: [amount] Original loan amount, if known: [amount or unknown] Paid before this record, if known: [amount — context only] Status: [active / settled] ACTUAL ACTIVITY - [date] — [loan started / payment / additional borrowing / correction] — [amount] — balance after: [amount] — [optional note] - [date] — [activity] — [amount] — balance after: [amount] — [optional note] CURRENT STATUS Remaining balance: [amount] Total paid since tracking began: [amount] Last actual payment: [date and amount] Next expected step: [amount and date, or check-in] Last reviewed: [date] CURRENT REPAYMENT PLAN, IF ANY Regular payment: [amount or no regular plan] Frequency: [weekly / every two weeks / monthly] Next expected date: [date] Projected payoff: [date or not calculated] Plan last confirmed: [date] Flexibility note: [optional]
Payments already started? Use the free browser tracker to calculate what remains and compare actual payments with the expected plan.
Track actual payments in the browserWorked example
One loan, several real changes
Alex lent Jordan 1,200 for a laptop. They expected payments of 200 each month, starting on 1 August. The plan describes what should happen. The activity log records what actually happens.
All amounts in this example use one currency.
| Date | Actual event | Balance change | Balance after | What the record preserves |
|---|---|---|---|---|
| Jul 10 | Laptop loan started | +1,200 | 1,200 | The opening loan remains part of the history. |
| Aug 1 | Jordan paid 150 | −150 | 1,050 | The payment was 150, even though the expected installment was 200. |
| Sep 1 | Jordan paid 300 | −300 | 750 | The complete 300 stays visible as one real payment. |
| Sep 15 | Jordan borrowed another 100 | +100 | 850 | The additional amount is a new event. Earlier payments are not rewritten. |
What changes—and what does not
After the 150 payment, do not replace the original 1,200 loan with 1,050. Add the real 150 payment and show the new balance.
The plan may still show that 200 was expected. The missing 50 belongs to the current plan status; it is not a payment that happened.
When Jordan later pays 300, keep the full payment as one real event. A tracker can apply part of it to the earlier shortfall and part to future installments, but the historical payment should still show the amount and date that actually occurred.
When another 100 is borrowed, add it as new activity. The balance becomes 850. The future projection may change, but the earlier loan and payment entries remain visible.
The balance follows real activity. The plan follows the balance.
Use the browser tracker to reproduce this example and see how the current installment and projected payoff change.
See this example in the payment trackerRecord these facts when the loan begins
A useful record does not need to feel formal. It only needs enough context for the amount, history, and next step to remain understandable later.
People and direction
Record who lent the money and who borrowed it.
Loan name or purpose
Use a short label such as “Laptop purchase,” “Moving deposit,” or “Bike repair” so this loan is not confused with other money between the same people.
Currency
Record the currency instead of assuming the symbol will remain obvious later.
Date the money was provided
Use the real date when the money or purchase was provided, not the date when you finally created the record.
Starting amount
For a new loan, record the amount provided. For an existing loan, start from the balance that is definitely still owed today.
Repayment expectation
Record that repayment is understood. If that is still unclear, resolve the gift-versus-loan question before treating the amount as owed.
Current repayment plan, if one exists
Record the expected amount, frequency, and next date without treating future installments as completed payments.
Where real payments will be recorded
Choose one reliable record rather than splitting the history across a note, spreadsheet, bank notifications, and several chat threads.
What happens if timing changes
Agree to record the real payment first and review the future plan separately when circumstances change.
A transfer receipt can show that money moved. A chat can show what someone said. Neither one automatically maintains the remaining balance. Keep them as supporting context, not as the only record.
Add repayments without rewriting the past
Every repayment should become a new dated event. Use the amount that actually moved, add a short note when context may matter later, and update the current balance.
Do not edit the opening loan every time money is repaid. The starting point explains where the loan began; the activity history explains how it reached the current amount.
| Situation | Correct record action | Avoid |
|---|---|---|
| The payment matches the expected installment | Add the real payment with its actual date and amount. | Replacing the opening loan with a smaller number. |
| The payment is smaller than expected | Add the smaller amount and keep the unpaid difference visible in the plan. | Marking the full installment as paid. |
| The payment is larger than expected | Add the complete amount that was actually paid. | Hiding the extra amount or inventing several separate transfers. |
| The payment arrives early | Use the real payment date. | Moving the payment to the date when it had been expected. |
| More money is borrowed | Add a new activity row that increases the balance. | Replacing the original loan amount and losing the earlier history. |
| An entry was wrong | Correct the affected entry and recalculate every later balance. | Rebuilding the record from memory without preserving the confirmed events. |
| The loan reaches zero | Mark the loan settled and preserve its history. | Deleting the record because nothing remains open. |
Need to confirm one payment clearly? Create a repayment receipt with the amount paid, what it covered, and what remains.
Loan already in progress
Start from what is definitely true today
You do not need to recreate uncertain history before you can begin. Start with the amount that both people can confidently treat as the current remaining balance.
Keep the original start date and any known paid-before-tracking amount as context. Do not subtract earlier payments from the current balance again.
| Question | What to record |
|---|---|
| What is definitely still owed today? | The current starting balance for the reliable new record. |
| When did the arrangement begin? | The historical loan start date, if known. |
| How much was paid before tracking began? | Historical context only. Do not subtract it from the current balance again. |
| Which earlier payments are uncertain? | A separate unresolved note rather than invented transaction rows. |
| What future repayment is currently expected? | The current payment amount, next date, or agreed check-in. |
| When does the reliable record begin? | The tracking start date. |
The current balance is the live starting amount. “Paid before tracking” is historical context and must not reduce that balance again.
Migration note
This record begins on [date] with a confirmed remaining balance of [amount]. The loan originally began on [date, if known]. Approximately [amount] had already been repaid before this record began. Earlier individual payments are not being recreated unless they can be confirmed.
You Owe Me can start a named Loan Record from what remains today while preserving the historical start date and paid-before-tracking context.
See how an existing personal loan can be brought into the appKeep a loan separate when it has its own story
Two people can have more than one kind of money between them. A loan deserves its own record when it has a separate purpose, balance, repayment plan, or settlement point.
A laptop loan and a moving-deposit loan may involve the same two people, but combining them into one unexplained number makes it harder to see which payment belongs where.
| Situation | Best record structure |
|---|---|
| One laptop loan with its own repayment plan | A separate named loan record |
| A laptop loan and a moving-deposit loan with the same person | Two separate named loan records |
| Groceries, taxis, subscriptions, and repayments moving both ways | One relationship running balance |
| One group ticket purchase with several participants | A Group Payback record rather than a personal loan |
| Temporary help where repayment is still unclear | Clarify the expectation or use the temporary-support record template |
| One small amount that will settle immediately | A note or message may be enough |
In You Owe Me, “Laptop purchase” and “Moving deposit” can keep separate names, balances, histories, and repayment plans while still contributing to the full balance with that person.
See how separate Loan Records workChoose the lightest method that will stay accurate
You do not need an app for every informal loan. Choose the simplest method that will still be clear after the next real payment.
| Situation | Best next method |
|---|---|
| One clear loan, one predictable payment, and no reminder needed | Use the copyable Notes template on this page. |
| You want manual control and will maintain formulas and history yourself | Use a spreadsheet. |
| The balance is known, but the payment schedule has not been chosen | Use the Payment Plan Calculator. |
| Payments already happened and you need the current balance or installment status | Use the Personal Loan Payment Tracker. |
| Expenses and repayments moved both ways across the relationship | Use the Running Balance Calculator. |
| Future payments, reminders, corrections, or plan changes will continue | Use a You Owe Me Loan Record and repayment plan. |
| Repayment itself was never clearly agreed | Clarify whether the money was a gift or a loan first. |
The best method is not the one with the most features. It is the lightest method that will still give you the correct current answer later.
When the record needs to keep working after the next payment
A note can preserve the starting facts. You Owe Me becomes useful when payments, reminders, corrections, plan changes, and shared updates need to stay connected to the same named loan.
One person can keep the record. The other person does not need to install the app.
Keep each loan named and separate
Keep a laptop loan, moving deposit, family loan, or other meaningful balance in its own Loan Record, with its own remaining balance and history. Each loan still contributes to the full balance with that person.
Connect the plan to real payments
Add a weekly, every-two-weeks, or monthly repayment plan to the same loan record. Smaller, larger, early, or late payments update progress from the real activity instead of creating a second balance that can drift away.
Keep the next step current
Keep the next payment amount, date, projected payoff, and reminder aligned as payments, corrections, or additional borrowing change the schedule.
Preserve the relationship history
Use Relationship Timeline to see when the loan started, when a plan changed, which payments were recorded, and what was shared—without deleting the earlier story.
Share visibility without forcing an install
Share an always-current, read-only Live Link that opens in a browser without requiring the other person to install the app or create an account. When a fixed summary fits better, create a focused PDF loan record.
Write from the real balance
Money Conversations can turn the current balance and history into a calmer follow-up or repayment update, so the next message does not have to be reconstructed from memory.
Keep this loan current in You Owe Me
Use You Owe Me when the record will continue through future payments, reminders, corrections, plan changes, or shared updates.
Share the current understanding without turning it into pressure
One person can maintain the working record. Share the current state when the other person needs context—not every time the number changes.
Use a message for one simple update
State the payment that was recorded, the remaining balance, and the next expected step.
Use a Live Link for an always-current view
You maintain the record. The other person opens a read-only browser link and does not need the app or an account.
Use a PDF for a fixed summary
A focused loan record can preserve the loan name, current balance, payment history, and current repayment-plan summary when a document fits better than a live view.
Do not rely on an old screenshot as the lasting record
A screenshot can become stale as soon as another payment, correction, or plan change happens.
I’ve updated the loan record with the latest payment. The remaining balance is [amount], and the next expected step is [amount/date].See the sharing and communication features
What this record does—and does not do
This record can
- Keep one personal loan understandable
- Preserve the starting point and actual payment history
- Show the current remaining balance
- Keep the current repayment plan visible
- Support a calmer update based on the same numbers
This record does not
- Create a binding loan agreement
- Decide whether money is legally a gift or loan
- Recommend an interest rate
- Provide legal or tax advice
- Move or collect payments
- Enforce repayment
- Prove that every entered detail is correct
- Replace professional advice when formal documentation is needed
You Owe Me records and plans. It is not a bank, lender, payment processor, debt collector, accounting system, tax tool, or legal-contract service. It does not guarantee that another person will pay.
Frequently asked questions
Should I change the original loan amount after each payment?
No. Keep the opening loan or starting balance as part of the history and add each repayment as a new dated event. The current remaining balance changes; the historical starting point does not disappear.
What if a payment is smaller than the planned installment?
Record the amount that was actually paid. Reduce the loan balance only by that real amount, and keep any unpaid part of the expected installment visible in the repayment plan. Do not record the full installment as paid.
What if I do not know the complete earlier payment history?
Begin with the amount that is definitely still owed today. Record the original start date if it is known, and keep any paid-before-tracking amount as historical context only. Do not subtract it from the current balance again or invent uncertain transactions.
Should two separate loans to the same person be combined?
Keep them separate when they have different purposes, repayment plans, interest context, or settlement points. A laptop loan and a moving-deposit loan can each keep their own record while an overall relationship balance shows the combined position.
Do both people need to use the same app?
No. One person can keep the record. When the other person needs visibility, you can share a message, a focused PDF, or an always-current Live Link that opens in a browser without requiring the app or an account.
When is a note enough for a personal loan?
A note may be enough when one clear loan will settle through one predictable payment, both people already understand the arrangement, no reminder is needed, and no future changes are expected. Use a tracker or ongoing app record when payments, corrections, reminders, or plan changes will continue.