By The Chipkie Team, Personal Finance Editorial Team · Last updated 7 September 2026
Money moves between American families constantly — a parent covering a semester of tuition, a sibling floating a car repair, an aunt helping with a security deposit. What almost never moves alongside it is a record. A family loan tracker — whether that’s a simple repayment tracking spreadsheet or a dedicated loan agreement app — is the difference between a loan that gets repaid and a “gift” someone remembers differently three years later.
The stakes are higher than most people assume. Without documentation, the IRS may treat your loan as a taxable gift, a court may treat it as unenforceable, and a mortgage lender may treat it as disqualifying. All three outcomes are avoidable with paperwork you can put together in an afternoon.
Key Takeaways
- A family loan tracker is a running record of principal, interest, payments and dates — it is what turns an informal handshake into provable, enforceable debt.
- The IRS gift tax annual exclusion is $19,000 per recipient per giver in 2026; forgiven or undocumented loan balances above that can consume part of your $15,000,000 lifetime exemption.
- Family loans should charge at least the Applicable Federal Rate (AFR), published monthly by the IRS, to avoid imputed interest — always check the current month’s rate before signing.
- An unsecured family loan cannot legally be used as a mortgage down payment under Fannie Mae Selling Guide B3-4.3-15 — this is a source-of-funds prohibition, not a DTI issue.
- Statutes of limitation on written contracts vary by state, roughly four to ten years, and the clock usually starts at the missed payment, not the loan date.
What Exactly Is a Family Loan Tracker, and Why Does It Matter?
A family loan tracker is an ongoing ledger that records the original principal, the agreed interest rate, every payment received, the date of each payment, and the remaining balance. It sits alongside a signed promissory note. Together they prove the money was a loan and not a gift — the single distinction that drives every tax, legal and lending consequence.
Good informal loan record keeping captures:
- Principal advanced and the date it left your account
- Interest rate and how it compounds (simple, monthly, annually)
- Payment schedule — amount, frequency, first and final due dates
- Every payment received, with date, method and how it splits between interest and principal
- Running balance after each payment
- Any variations — deferrals, hardship pauses, partial forgiveness — in writing, signed by both parties
That last item is where most families come undone. Our experience across the agreements users create shows that verbal side-deals (“just skip this quarter”) are the most common cause of later disputes, because neither party remembers the terms identically.
How Does the IRS Treat an Undocumented Family Loan?
The IRS presumes intra-family transfers are gifts unless you can show genuine loan characteristics: a written note, a stated interest rate at or above the Applicable Federal Rate, a fixed repayment schedule, and evidence of actual repayments. A tracker supplies that evidence. Without it, the transfer is treated as a gift.
According to the Internal Revenue Service, the 2026 gift tax annual exclusion is $19,000 per recipient, per giver. A married couple can jointly give $38,000 to one adult child, or $76,000 to that child and their spouse. Exceed the exclusion and you file Form 709 — which usually means no tax is owed, but the excess draws down your lifetime exemption, now $15,000,000 per individual following the One Big Beautiful Bill Act.
The interest rate trap. If you charge below the AFR, the IRS can impute interest income to you that you never actually received. The AFR changes monthly and is never safe to quote from memory — check the current month’s published rate before you set your terms. Our guide to setting a fair interest rate on a family loan walks through how to apply it.
| Characteristic | Looks like a loan | Looks like a gift |
|---|---|---|
| Documentation | Signed promissory note | Nothing in writing |
| Interest | At or above current AFR | Zero or unstated |
| Repayments | Regular, tracked, banked | Sporadic or none |
| Enforcement | Lender follows up on arrears | Lender never asks |
Can a Family Loan Be Used Toward a Home Down Payment?
Not if it is unsecured. Under HUD/FHA rules and the Fannie Mae Selling Guide (B3-4.3-15), an unsecured personal loan — including an informal family loan — is not an acceptable source of down payment funds. This is a source-of-funds prohibition. The loan will be refused as a source outright, regardless of how comfortable your debt-to-income ratio looks.
Borrowed funds can be used only if they are secured against an asset. In practice that means a properly documented note secured by a recorded deed of trust — often against the parents’ own home, or recorded behind the first mortgage on the property being purchased — at a reasonable rate of interest.
The gift letter question. Many families sidestep the rules by signing a gift letter. A gift letter states plainly that the money is a gift with no expectation of repayment. If your family in fact expects to be repaid, signing that letter is mortgage fraud — a federal offense. This happens constantly, and almost never maliciously; people simply do not realize the letter is a legal declaration. If repayment is expected, the honest options are to secure the loan properly or to make it a true gift.
Two paths, clearly:
- True gift: sign the gift letter, expect nothing back, document it for gift tax purposes if it exceeds the annual exclusion.
- Real loan: secure it against an asset, disclose it to the lender, charge at least the AFR, and track every payment.
How Do You Set Up Tracking That Actually Holds Up?
Start with a signed written agreement, then maintain the ledger from day one. A repayment tracking spreadsheet works if you are disciplined; a dedicated loan agreement app is better because it timestamps entries, produces amortization schedules, and generates statements neither party can quietly edit later.
- Write the note first. Principal, rate, schedule, default terms, security if any, and signatures.
- Move the money by bank transfer with a clear reference. Never cash.
- Log every payment on the day it clears, splitting interest and principal.
- Send an annual statement to the borrower confirming the balance — this also restarts acknowledgment of the debt in many states.
- Document variations in writing. A one-paragraph signed amendment is enough.
- Know your clock. The statute of limitations on written contracts runs roughly four to ten years depending on your state — see our breakdown of the hidden statute of limitations on family loan agreements.
The Consumer Financial Protection Bureau consistently emphasizes written terms and payment records as the foundation of any consumer credit arrangement — the logic applies just as strongly between relatives.
Does a Family Loan Need a Written Agreement to Be Enforceable?
Verbal loans are legally valid in most states, but they are extremely difficult to prove. Courts look for evidence of repayment expectation: texts, transfers, partial repayments. A written note plus a payment ledger removes the argument entirely. See our guide on proving a verbal family loan in court.
What Happens If the Borrower Simply Stops Paying?
Your tracker becomes the evidence base. It shows the balance, the last payment, and the date default began — which typically starts the limitations clock. Options include renegotiating in writing, formally forgiving the balance (a gift, with Form 709 consequences above $19,000), or pursuing small claims or civil court.
Do I Have to Report Interest I Receive From a Relative?
Yes. Interest you actually receive on a family loan is taxable interest income and must be reported on your federal return, even though no Form 1099-INT is issued. And if you charge below the current AFR, the IRS may impute interest you never collected. Track interest separately from principal for this reason.
Is a Spreadsheet Good Enough, or Do I Need Software?
A spreadsheet is far better than nothing and is perfectly adequate for a small, short-term loan. For larger or longer arrangements — anything secured, multi-year, or involving several siblings — purpose-built software reduces disputes because entries are timestamped, amortization is automatic, and both parties see the same figures.
Where Should You Start Today?
The paperwork is the easy part; the conversation is the hard part. Get the terms agreed, get them signed, and keep the ledger current from the first dollar. Everything else — tax treatment, enforceability, lender acceptance — flows from those three habits.
If you are lending to family this year, create a written loan agreement and track every repayment in one place before the money moves. It takes minutes, and it protects the relationship far more reliably than good intentions do.
Disclaimer: The information provided in this article is for informational purposes only and should not be considered financial or legal advice. Laws and lending criteria vary significantly between states. We always recommend consulting with a qualified real estate attorney and financial advisor before entering into a property purchase or financial arrangement with another party.
