How to track multiple loans without losing the thread

The problem with per-lender views

Every lender gives you a portal showing your loan with them: balance, next payment, maybe a schedule. Each one is accurate and each one is useless for the question you actually have.

The questions that matter span lenders:

• How much of my income is committed to debt every month, in total?
• What do I owe in total, and how much of that is principal versus interest still to come?
• What is due next, and is anything due in a week where money is tight?
• If I have one extra payment to make, where does it do the most good?
• How long until each of these is actually finished?

None of those can be answered from a single lender portal, which is why people with several loans routinely misjudge their own position — usually in the direction of thinking it is better than it is.

What to record for each loan

You need a specific and fairly small set of fields. More than this is bookkeeping for its own sake; less than this and you cannot answer the questions above.

1. A name you will recognise in a hurry. "Car — blue hatchback" beats "Loan 2".
2. Original principal, so you can see how far you have come.
3. Remaining principal, which is the number that actually matters.
4. The regular payment amount.
5. Total instalments and how many are paid. This is what turns a balance into a finish date.
6. The due day, so the schedule is visible.
7. The rate, for deciding where extra payments go.

In expenie a loan is its own kind of record rather than an account — it holds original and remaining principal, an optional EMI plan with amount and total instalments, instalments paid, and an optional display rate. When both the EMI amount and total instalments are present, total payable and plan interest are derived for you.

The reason a loan is not an Account is worth understanding: an account holds money you have. A loan is an agreement with a remaining balance and a schedule. Modelling them the same way makes both harder to read.

The four numbers to keep visible

Once several loans are recorded, four aggregate figures tell you almost everything:

• Total monthly commitment — every payment summed. Compare it to your income and you have your debt-service position in one number.
• Total principal remaining — what you actually owe, ignoring future interest.
• Still to pay — the sum of remaining instalments across all loans. This is larger than principal remaining, and the difference is future interest.
• Interest left — still-to-pay minus principal-remaining. This is what the debt will cost you from here.

That last pair is the useful one for decisions. Principal remaining tells you the size of the hole; interest left tells you the price of staying in it. Watching interest-left fall is the clearest signal that extra payments are doing something.

expenie sums monthly EMI across every loan that has one — including plans that are incomplete — specifically so the commitment figure is not silently understated by a loan you have not fully specified.

Handling loans without a clean plan

Real loan portfolios are messy. Some will not have a tidy EMI and total-instalments structure.

Common awkward cases and how to handle each:

A loan where you know the payment but not the total instalments. Record what you know; the payment still counts toward monthly commitment even if the finish date is unknown. Filling in the total instalments later immediately unlocks the derived totals.

Informal loans from family with no schedule at all. Record the principal and remaining balance and skip the plan entirely. The value here is having the amount written down somewhere neutral, which prevents the disagreements that informal lending is famous for.

Revolving credit like a card. This is not really a loan with a schedule — it is a balance that changes as you use it. In expenie that is better modelled as a credit card account, where expenses increase what you owe and paying the bill is a transfer that reduces it.

Recording payments

A payment on a loan is usually not one thing. It typically splits into principal, interest, and sometimes fees or insurance.

Only the principal portion reduces what you owe. The rest is the cost of borrowing. If you record the whole payment as a principal reduction, your remaining balance will drift steadily away from your lender's figure, and you will not notice until the numbers are far apart.

expenie asks you to enter the split rather than generating an amortisation schedule. That is more work per payment, and it is deliberate: real lender allocations differ from textbook amortisation often enough that a generated schedule would quietly diverge from reality. Your statement shows the actual split, and entering it keeps your books matching your lender's.

One consequence worth knowing: loan-linked transactions cannot be edited or deleted from the ordinary ledger, because doing so would silently desynchronise the loan's principal. Adjustments are made from the loan itself.

Keeping the schedule visible

With one loan, remembering the due date is easy. With four at different points in the month, it is not — and a missed payment costs a fee and sometimes a rate increase, which is the most avoidable expense in the whole category.

Set each loan payment up as a recurring rule. In expenie a due item appears in an inbox and waits for you to confirm it; confirming creates the transaction dated to the due date, and skipping advances the schedule without creating anything.

For a loan-linked recurring expense, confirming posts the payment as a principal component, reduces the remaining balance, and increments the count of instalments paid — so confirming the due item and updating the loan are the same action rather than two you might do inconsistently.

Month-end due dates are handled explicitly rather than drifting: a payment due on the 31st does not permanently become the 28th after passing through February.

The monthly review

Once a month, read the whole set together:

1. Does each remaining principal match the lender's figure? Divergence means a split was recorded wrong, and it is much cheaper to catch after one month than after twelve.
2. Has total monthly commitment changed? A variable rate or a finished loan moves it.
3. Is anything close to finished? A loan about to complete frees a payment that should be redirected deliberately, not absorbed.
4. Where should the next extra payment go? Rates and balances shift, and the answer occasionally changes.

Ten minutes. The reconciliation step in particular is what keeps the aggregate numbers trustworthy — and aggregates you do not trust are aggregates you stop looking at.