Skip to content

Private lending software: what a loan tracker will not do

A tracker stores terms and a balance. Servicing derives the accrual, applies each payment in the order the note sets, and produces documents other people rely on. Here are the four moments the difference stops being academic.

10 min read
  • servicing
  • payments
  • escrow
  • taxes

Almost every private lender starts with something that tracks loans. A spreadsheet, a tab in the accounting file, a folder of PDFs and a reliable memory. It holds the terms and the current balance, and for a good while that is honestly all the job asks for.

Then something arrives that the tracker has no answer for, and the answer has to be rebuilt by hand while somebody waits.

This is about the line between tracking a loan and servicing one, and how to tell which side of it your book is already on. It is not an argument that everyone needs software. Plenty of books belong exactly where they are, and the last section says when.

The difference, in one sentence

A tracker stores what you told it. A servicing system derives what follows from it.

That sounds like a distinction without a difference until you notice what "derives" is doing. Interest accrues over a count of days on a basis your note sets, not in twelfth-of-a-year lumps. A payment is applied in the order your document specifies, against whatever is actually outstanding on the day the money landed. Escrow is a second ledger with its own inflows, its own irregular disbursements, and an annual analysis. And the outputs are not for you. A payoff figure is funded against by a closing agent. An escrow statement is read by a borrower. A tax form is received by the IRS. A remittance statement is checked by somebody who owns part of the loan.

A tracker holds numbers. Servicing produces documents other people act on, which is why the tolerance for being approximately right is so different.

What a tracker is genuinely good at

Worth saying plainly, because the answer for a lot of readers is "keep the tracker".

A tracker is excellent at the questions you already know how to ask. What is the balance. When is the next payment due. Which loans are current. How much interest came in last year, roughly. If your notes pay on time, none of them escrow, nobody else needs the file, and you are comfortable rebuilding a figure when somebody asks for one, a tracker is cheaper and simpler than anything you could buy and switching would be busywork.

The costs described below scale with moving parts rather than with loan count. Here is where the parts start moving.

Moment one: a payment arrives short

A borrower sends less than the installment. It happens on every book eventually, and it is the first place a tracker quietly goes wrong.

There are two tempting wrong answers. Applying the short amount as though it were a full payment corrupts the schedule from that month forward, because principal was credited that nobody paid. Dropping it into an unlabelled adjustment loses it, and it surfaces months later as a balance nobody can explain.

The correct answer is a suspense balance: the money is received and visible, held separately, and applied as a payment once enough accumulates to make one. That is not just a design preference. Regulation Z's servicing provisions, published by the Consumer Financial Protection Bureau at consumerfinance.gov, require a covered servicer that holds a partial payment in a suspense or unapplied funds account to disclose the amount being held and to apply it as a periodic payment once the account holds enough. The same provisions require a periodic payment to be credited as of the date of receipt, which is a plainer requirement than it sounds: the day the money arrived governs the accrual, not the day somebody keyed it in.

Whether those provisions reach a specific private loan is a legal question about the transaction and the parties, and an attorney answers it rather than a vendor. As bookkeeping it is simply correct either way. There is a longer treatment in partial payments and suspense.

A tracker has nowhere for that money to sit. That is the tell.

Moment two: an escrowed tax bill changes

If none of your loans escrow, skip this section. If one does, this is the moment that usually decides the question.

Escrow is a second ledger that fills monthly and empties irregularly, on dates a county and an insurer choose. Once a year it has to be analysed: project the next twelve months of disbursements, find the low point, compare it to what is actually in the account, and turn the result into a new payment plus a shortage or a surplus you can send the borrower.

Regulation X at 12 CFR 1024.17, also published by the Consumer Financial Protection Bureau at consumerfinance.gov, sets out how an account subject to it is analysed. Four figures are worth carrying around, all accurate as of September 2026 and all worth rechecking against the regulation rather than against an article, this one included. The cushion may be no greater than one sixth of the estimated total annual payments from the account. The borrower gets an annual escrow account statement within 30 days of the end of the computation year. A surplus of fifty dollars or more is refunded within 30 days when the borrower is current. And a shortage of less than one month's escrow payment may be repaid in equal monthly payments over at least a twelve month period rather than demanded at once.

None of that is arithmetic a tracker refuses to do. It is arithmetic a tracker does not know it is supposed to do, on a schedule nobody set a reminder for. The practical failure is not a wrong number, it is a payment that stays wrong for eleven months because the tax bill moved in March and the analysis runs in December.

Moment three: somebody wants a payoff good to a date

A payoff is not a balance. It is the balance plus interest accrued to a chosen date on the right day count basis, plus whatever charges are outstanding, plus or minus the escrow position, with a per diem attached so the closer can extend the figure when funding slips a day.

Where Regulation Z applies, a creditor has to provide an accurate payoff statement within a reasonable time and in no case more than seven business days after receiving a written request. In practice the request arrives with a closing date attached and nobody is waiting seven days, which is the real point: the figure has to be producible on demand, not reconstructed.

This is the moment tracker arithmetic gets independently checked for the first time. Every month before it, the tracker was checked against itself. A closing agent computes from the note and the payment record, and any drift that accumulated over four years shows up at once, as a disputed number, in front of a borrower who is trying to close. What a payoff statement must show covers the line items an agent expects.

If you want to sanity check a figure by hand, you can solve for a payment, a rate or a term with the free financial calculator. It is public and stays that way.

Moment four: January

The year end forms are a reconciliation problem wearing a printing problem's clothes. If the forms are produced somewhere other than where the ledger lives, someone is retyping totals, and the retyping happens in the worst month for it.

Two thresholds from the IRS instructions at irs.gov, accurate as of September 2026 and worth confirming each filing season because they do move. Form 1098 is filed by someone engaged in a trade or business who receives six hundred dollars or more of mortgage interest from an individual in the course of that business. The instructions say directly that you are not required to file if the interest is not received in the course of your trade or business, and give the example of holding the mortgage on your own former residence. Form 1099-INT has its own thresholds: ten dollars for the ordinary interest amounts, six hundred dollars for interest paid in the course of a trade or business, and any amount at all where backup withholding was applied and not refunded.

Whether you are in a trade or business, and therefore which forms you owe, is a determination for your CPA. It is not something a vendor can answer and not something a tracker can imply. What the software owes you is that the number on the form came from the payments you actually posted, on the dates they actually arrived.

The three questions worth asking your current setup

Not a feature list. Three questions with uncomfortable answers.

Where does a short payment go today? If the answer is "I apply it and remember", the ledger and the note have already begun to disagree.

How long would a payoff to a date three weeks out take you? If it is more than a minute, you are reconstructing rather than reading, and you will be doing that under time pressure the next time.

Who else could produce these numbers if you were unavailable for two weeks? A tracker whose logic lives in one person's head is a single point of failure that nobody has priced.

If the answers are comfortable, stop reading and keep the tracker. If two of the three make you wince, the book has crossed the line already and the work is going somewhere, either into software or into your evenings. The real cost of servicing notes in a spreadsheet puts numbers on the second option.

Where NoteHarbor sits

Stated plainly so it can be held against anyone else's answer.

It is a system of record for private loans. Loan terms are entered once and the schedule is derived from them, in integer cents through a tested engine rather than through formulas you maintain; creating a loan walks through what goes in and what comes out. Payment order is set per loan. Short payments land in a visible suspense balance. Escrow runs as its own ledger with an analysis behind the cushion cap described above. Payoff quotes carry a per diem to a chosen date. Investor and lienholder positions are tracked as bookkeeping over money you moved yourself: NoteHarbor does not hold or move money, and no funds pass through it. Forms 1098, 1099-INT, 1099-A and 1099-C generate from the same ledger you service against, and filing them remains yours to do. Understanding cashflow covers how the money in and money out views are built from posted payments rather than from a separate set of numbers.

The private lender overview is the product version of this article, and loan servicing software for private lenders is the longer functional spec, with the federal rule behind each requirement. If you want to test the four moments above against your own loans, the trial is 30 days with no card.

The honest summary is that a tracker is not wrong, it is unfinished. It handles the part of servicing where nothing has gone sideways, and the part where something has gone sideways is the part somebody else is depending on you for.

This article is general information, not legal, tax, or accounting advice. Which servicing rules apply to a given loan, what your note may charge, and which year end forms you owe all depend on facts specific to you and to where the property sits. The regulatory and tax figures above are accurate as of September 2026 and change. Talk to a licensed attorney and your CPA about your own situation.

Common questions

What is the difference between a loan tracker and loan servicing software?

A tracker stores what you typed into it: the terms, the payments you recorded, and a balance you maintain. A servicing system derives what follows from those inputs. It accrues interest on a day count basis, applies each payment in the order the note specifies, carries escrow as a second ledger, and produces documents somebody outside your office relies on, such as a payoff a closing agent funds against or a tax form filed with the IRS. The distinction only matters when a payment does not arrive exactly as scheduled, which is to say it matters eventually on every book.

Do I need servicing software for a handful of private loans?

Not necessarily, and loan count is a poor way to decide. What drives the answer is moving parts: whether any loan escrows for taxes and insurance, whether money is owed onward to an investor or a lienholder, whether a second person needs access to the book, whether borrowers expect to look up a balance without calling, and whether you file the year end forms yourself. Four loans with escrow and an investor split are harder than twenty performing notes with none of that.

Can a spreadsheet do private lending servicing properly?

It can do the arithmetic, and for one simple performing note it usually does. What it does not supply by default is a day count convention applied to actual receipt dates, a payment order that knows what is already outstanding, an escrow ledger with an annual analysis behind it, and a record of who changed what. Each of those has to be built and then maintained by hand, and the errors surface late, at a payoff or a sale, rather than in the month they happen.

What should I test before trusting any lending software with a real loan?

Take one loan you already understand and run the four hard moments through it. Post a payment dated a week ago and confirm the interest split moves with the receipt date. Post one that is short and see where the shortfall lands. Change an escrowed tax bill and read the document the analysis produces. Ask for a payoff good three weeks out and check the per diem against your own arithmetic. Anything that cannot do all four will hand the rest back to you in a spreadsheet.

Private lending software vs a loan tracker | NoteHarbor