How to track loan repayments without a spreadsheet
Loan repayments are the most predictable expense you have, and the most commonly excluded from budgets. That combination is why a month can look fine on paper and still leave you short.
What counts as a loan here
More than you would expect. Anything you have committed to repaying on a schedule belongs in the same place:
- Bank loans — car, personal, home improvement, mortgage.
- Student loans, including ones in deferment that will start later.
- Buy-now-pay-later plans and installment purchases, which people rarely think of as debt.
- Phone or device plans where the handset is being paid off inside the bill.
- Money borrowed from family or friends — informal, but still a scheduled commitment.
The last one matters more than it appears. Informal loans are the ones with no statement, no reminder, and no paper trail, so they are the ones that quietly go unpaid and damage a relationship rather than a credit score.
The four numbers you actually need
| Number | Why it matters |
|---|---|
| Original amount | The baseline the balance is measured against, and what tells you how far you have come |
| Installment | The committed monthly figure your budget must reserve before anything else |
| Payment date | What puts the loan on your upcoming timeline instead of surprising you |
| Remaining balance | The only number that answers "how much longer" — and the one that makes progress visible |
An interest rate is useful for comparing loans or deciding what to overpay first, but it is not needed to track one. Do not let a missing rate stop you from recording the loan at all.
Log each installment as it is paid
A loan tracked as a single lump sum tells you nothing month to month. Tracked as a series of installments, it does two useful things at once: the balance falls visibly, and the payment appears in your spending where it belongs.
In Wisspy, adding a loan with its start date, installment, and schedule is enough — installments that have already come and gone are booked automatically, so a loan you took out two years ago does not start from zero when you enter it today. From then on each payment marks off against the balance.
Put installments in the budget, not beside it
This is the mistake worth fixing today. A loan installment is a committed expense — the same category as rent. If your budget treats it as something paid from whatever is left over, then every "safe to spend" figure you look at is overstated by the amount of the installment, every single month.
Handled properly, the loan sits alongside your bills and subscriptions on the upcoming timeline, is subtracted from income before anything is called discretionary, and stops distorting the rest.
Deciding what to overpay
Once several loans are visible together, the question becomes which one to attack. Two defensible strategies, and the honest trade-off between them:
- Highest interest rate first. Mathematically optimal — you pay the least in total.
- Smallest balance first. Slightly more expensive, but a loan that disappears entirely is a real motivational event, and finishing things is how people stay with a plan.
Pick either. The strategy you keep doing beats the strategy that is 3% better on a spreadsheet and abandoned in March. Before overpaying anything, check whether your lender charges an early-repayment fee — some do, and it can erase the benefit.
Frequently asked questions
Should a loan repayment count as an expense?
For budgeting purposes, yes — the money leaves your account and is not available to spend. In strict accounting terms the principal portion reduces a liability rather than being an expense, which matters for business books but not for deciding what you can spend this weekend.
How do I track a loan to a friend in another currency?
Record it in the currency it was agreed in, and let the tracker convert for reporting. Repayments should be measured against the original currency, otherwise exchange-rate movement will make it look as though the balance is changing when nothing has been repaid.
What about a loan with a variable rate?
Track the installment as it currently stands and update it when your lender changes it. Trying to model future rate changes is guesswork; recording what you actually pay is not.
In short
Record every scheduled commitment in one place, log installments as they are paid, and — most importantly — subtract them from income before you decide what is spendable. The balance falling is the reward; the accurate budget is the point.