Notes · 31 October 2026

Tracking a mortgage and a car loan with AI

By Peter Varga. The loans demo is below and the other four are on YouTube; the rules are in the loans spec.

A mortgage payment is one line on a checking statement. It says how much went to the lender. It doesn't say how much of it paid down the loan, how much was interest, and how much went into escrow for taxes and insurance. That split is what you need to know what you still owe, when the loan ends, and how much interest you paid this year.

In Saybooks, Claude keeps your loans from your own statements. This is how it works.

A loan starts from the lender's figures. What was owed on a given day, the fixed rate, the monthly payment, the escrow collected with it and the due day, each with where it came from. Nothing is assumed.

Each payment is split, and says how. When the lender's statement arrives, you hand it to Claude and it links the checking row to the loan with the split exactly as the lender printed it. If the statement hasn't come yet, the payment is split by the schedule (a month's interest on what was owed, the escrow, the rest to principal), and the record says it was split by the schedule, not by the lender. The split always adds up to the row, to the cent.

The lender's balance is checked against ours. When a statement prints what is still owed, that figure is recorded next to the one the books arrive at. If they match, you see that they match. If they don't, the difference is named and left for you to look at, never quietly absorbed.

What you get from it. For each loan: what is owed and as of when, the next payment, the payoff date, months and interest left, and interest paid this year, with mortgage interest as its own figure for whoever does your taxes. The loans count against your net worth next to the accounts and the house.

One detail from building it, because it is the kind of thing a household actually runs into. In the demo household the mortgage payment went out on 24 August, a week before it was due on 1 September, and the list of what was due still showed September as unpaid. Paying early is normal. The rule now is that a regular payment covers the nearest due date, so an early payment counts for the month it was meant for.

What it doesn't do, on purpose: variable rates, refinances and lines of credit are out for now (after a refinance you start a new loan from the new figures). It never pays anything. There's no bank feed and nothing logs into your bank; Claude reads the statements you give it, and a statement is taken whole only when its rows add up to its printed balances.

The household demo has a mortgage and a car loan in it with three months of statements, no account needed. How to connect your own is on the personal finances page.

More: all five personal finance demos.